/* SQL added by SAGAR on 15/MAR/14 for Freight List(DI3LSUN004)  */

UPDATE system_events SET COMP_TYPE='EJB',COMP_NAME='FreightListIC',SERVICE_CODE='prv_default_ejb',CHG_DATE=SYSDATE
WHERE obj_name='frt_list' AND EVENT_CODE='pre_validate';

UPDATE system_events SET COMP_TYPE='EJB', COMP_NAME='FreightListIC', SERVICE_CODE='poic_default_ejb', CHG_DATE=SYSDATE
WHERE obj_name='frt_list' AND EVENT_CODE='post_item_change';

INSERT INTO MESSAGES (msg_no , msg_str , msg_descr ,  msg_type ,  msg_opt , chg_date , chg_user , chg_term ) 
VALUES ('VMNULLFRTL', 'Empty Freight List !','Freight List should not 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 ('VMDUPFRTLT', 'Duplicate Freight List','Freight List Alrady 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 ('VMVLDCURNC', 'Error Invalid Currency','Currency Code not defined in Masters !', '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 ('VMNULLCURN', 'Empty Currency Code','Currency code cannot be blank !', '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 ('VMNULFRTBL', 'Empty Freight Charges Table','Freight Charges Table should not 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 ('VMNULLDTYP', 'Empty Load Type!','Load Type should not 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 ('VMVLDFRTTB', 'Invalid Freight Charges Table','Freight Charges Table does not exists 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 ('VMVLDCALI1', 'Invalid Call Inc. Charges.','Call Incidental Charges doesnot exists 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 ('VMNULCALI2', 'Empty Call Inc. Charges','Call Incidental Charges should not 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 ('VMVLDDLVCG', 'Invalid Delivery Inc. Charges','Delivery Incidental  Charges does not exists 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 ('VMNULDLVCG', 'Empty Dlv. Incidental Charges','Delivery Incidental Charges should not 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 ('VMVLDDETCG', 'Invalid Detention Inc Charges!','Detention Incidental Charges doesnot exists 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 ('VMNULDETCG', 'Empty Dtn. Incidental Charges!','Detention Incidental Charges should not 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 ('VMEFROMDTE', 'Empty Effective From Date','Please Enter Effective From Date !', '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 ('VMVLDTODTE', 'Empty Valid Upto Date','Please Enter Valid Upto Date !', '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 ('VMVLDFRMTO', 'Invalid Date','Valid Upto Date can not be less than Effective From Date !', 'E', 'Y', SYSDATE, 'BASE', 'BASE');
