/* Added by Mahendra Jadhav on 20/MAR/14 for 'Freight Charges Table'*/

update system_events set service_code='poic_default_ejb', comp_type='EJB',comp_name='FreightChargeIC',chg_date=sysdate ,chg_user='mahendra' where obj_name='frt_chgs_table' and event_code='post_item_change';


update system_events set service_code='prv_default_ejb',comp_type='EJB',comp_name='FreightChargeIC',chg_date=sysdate ,chg_user='mahendra' where obj_name='frt_chgs_table' and event_code='pre_validate';



INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMFCTEMT', 'Invalid Freigth Charges Table','Freigth Charges Table cannot be Empty!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');


INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMFCTEX', 'Already exist','Freigth Charges Table should not exist in master!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');


INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMLTEMT', 'Invalid Load Type','Load Type can not be empty,Please enter Load Type!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');

INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMCHCOEMT', 'Invalid Charge Code','Charge Code can not be empty,Please enter Charge Code!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');

INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMCHMDEMT', 'Invalid Charges Mode','Charge Mode can not be empty,Please enter Charge Mode!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');

INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMAMTEMT', 'Invalid Amount','Amount can not be empty,Please enter Amount!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');


INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMADCHEMT', 'Invalid Add charges','Add Charges can not be empty,Please enter Add Charges!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');


INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMSEQEMT', 'Invalid Sequence','Sequence can not be empty,Please enter Sequence!', 'E', 'Y', SYSDATE, 'BASE', 'BASE');

update system_events set obj_name='frt_chgs_table_old' where obj_name='frt_chgs_table' and event_code='post_validate';
