data is going in main table while executing procedure

this procedure compiled  and execute fine;but when i see the data in FS_FRS_HBL_MSTR i didnt the data;but the data is going in FS_FR_SHIPMENT_PLAN;what may be the reason;when i print the values dbms_output.put_line('70' || hblno); it is coming correctly;why data is not going in  FS_FRS_HBL_MSTR  table;


create or replace procedure HBLMASTERprocedure is

shipperaddrid  number;
consigneeaddrid  number;
billtoaddrid  number;
customeraddrid  number;
originstationaddrid  number;
deststationaddrid  number;
rtplanid  number;
sailingschedule number;
hblno number;

begin
FOR i IN 1 .. 1
LOOP


SELECT SAIL_SCH_SNO_SEQ.NEXTVAL into sailingschedule FROM       DUAL;


INSERT INTO FS_FRS_SAILING_SCHEDULE (SAILING_SCHEDULE_ID,PORT_OF_LOADING,PORT_OF_DISCHARGE,CUT_OFF_DATE,VOYAGE_NO,VESSEL_NAME,CARRIER_ID,ETA,ETD,AUTO_GENERATED_NY,VESSEL_ID) VALUES (sailingschedule,'INMAA','INBOM',sysdate,'VOYAGE','VAN PHONG','ABTB',sysdate,sysdate,'Y','VANPHO');


SELECT ADDRESS_SEQ.NEXTVAL into shipperaddrid FROM DUAL;

INSERT INTO FS_ADDRESS(ADDRESSID,ADDRESSLINE1,ADDRESSLINE2,ADDRESSLINE3,CITY,STATE,ZIPCODE,COUNTRYID) VALUES(shipperaddrid,'350 N BUCKEYE ST','BELLEVUE OH 44811','','BELLEVUE','OH','44811','US');

SELECT ADDRESS_SEQ.NEXTVAL  into consigneeaddrid FROM DUAL;

INSERT INTO FS_ADDRESS(ADDRESSID,ADDRESSLINE1,ADDRESSLINE2,ADDRESSLINE3,CITY,STATE,ZIPCODE,COUNTRYID) VALUES(consigneeaddrid,'820 MISSION ST','SOUTH PASADENA CA 91030','','SOUTH PASADENA','CA','91030','US');

SELECT ADDRESS_SEQ.NEXTVAL into billtoaddrid FROM DUAL;

INSERT INTO FS_ADDRESS(ADDRESSID,ADDRESSLINE1,ADDRESSLINE2,ADDRESSLINE3,CITY,STATE,ZIPCODE,COUNTRYID) VALUES(billtoaddrid,'31 KAZBEGI','TBILISI GEORGIA 380060','','TBILISI','','380060','GE');


SELECT ADDRESS_SEQ.NEXTVAL into customeraddrid FROM DUAL;

INSERT INTO FS_ADDRESS(ADDRESSID,ADDRESSLINE1,ADDRESSLINE2,ADDRESSLINE3,CITY,STATE,ZIPCODE,COUNTRYID) VALUES(customeraddrid,'350 N BUCKEYE ST','BELLEVUE OH 44811','','BELLEVUE','OH','44811','US');

SELECT ADDRESS_SEQ.NEXTVAL into originstationaddrid FROM DUAL;

INSERT INTO FS_ADDRESS(ADDRESSID,ADDRESSLINE1,ADDRESSLINE2,ADDRESSLINE3,CITY,STATE,ZIPCODE,COUNTRYID) VALUES(originstationaddrid,'HEATHROW GATEWAY','GODFREY WAY','','HOUNSLOW','MIDDLESEX','TW4 5SY','SG');

SELECT ADDRESS_SEQ.NEXTVAL into deststationaddrid  FROM DUAL;

INSERT INTO FS_ADDRESS(ADDRESSID,ADDRESSLINE1,ADDRESSLINE2,ADDRESSLINE3,CITY,STATE,ZIPCODE,COUNTRYID) VALUES(deststationaddrid,'15 CHANGI SOUTH STREET 2','','','SINGAPORE','','486068','SG');


 SELECT HAWB_NO.NEXTVAL into hblno FROM DUAL;
SELECT SHIPMENT_PLAN_SEQ.NEXTVAL into rtplanid FROM DUAL;


dbms_output.put_line(rtplanid);
INSERT INTO FS_FR_SHIPMENT_PLAN(RT_PLAN_ID, SHIPMENT_NO, ORG_STATION, DEST_STATION, SHIPMENTMODE, STATUS, CRTD_BY, CRTD_TSTMP, LAST_UPDT_BY, LAST_UPDT_TSTMP, DOCUMENT_TYPE) VALUES (rtplanid, '70' || hblno, 'LHR', 'SIN', 2, 'N', '', SYSDATE, '', SYSDATE, '');

dbms_output.put_line('70' || hblno);
INSERT INTO FS_FRS_HBL_MSTR (HBL_NO,HBL_ID,HBL_DATE,STATION,ORIGIN_STATION,DESTINATION_STATION,RATING_ORIGIN,RATING_DESTINATION,ORIGIN_GATEWAY,PLACE_OF_RECEIPT,PLACE_OF_DESTINATION,PORT_OF_LOADING_NAME,PORT_OF_DISCHARGE_NAME,SHIPMENT_TYPE,LOAD_TYPE,FREIGHT_TERMS,FREIGHT_TERMS_DESCRIPTION,PRIORITY_ID,SERVICE_TYPE_ID,INCO_TERMS_ID,HAZARDOUS_NY,UN_NUMBER,NATURE_OF_GOODS,CURRENCY_ID,SAILING_SCHEDULE_ID,DOCS_RECVD_FROM_SHIPPER,NO_OF_PIECES,GROSS_WT,UOW,VOLUME,UOV,TOTAL_REVENUE_TONES,FAX_REQUIRED_NY,FAX_NUMBER,EMAIL_REQUIRED_NY,EMAIL_ID,PICKUP_ID,CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDR_ID,CUSTOMER_ADDR_FLAG,CUSTOMER_REF_ID,SHIPPER_ID,SHIPPER_NAME,SHIPPER_ADDR_ID,SHIPPER_ADDR_FLAG,SHIPPER_REF_ID,CONSIGNEE_ID,CONSIGNEE_NAME,CONSIGNEE_ADDR_ID,CONSIGNEE_ADDR_FLAG,CONSIGNEE_REF_ID,BILLTO_ID,BILLTO_NAME,BILLTO_ADDR_ID,BILLTO_ADDR_FLAG,BROKER_ID,BROKER_NAME,BROKER_ADDR_ID,BROKER_ADDR_FLAG,NOTIFY_ID,NOTIFY_NAME,NOTIFY_ADDR_ID,NOTIFY_ADDR_FLAG,ALSO_NOTIFY_ID,ALSO_NOTIFY_NAME,ALSO_NOTIFY_ADDR_ID,ALSO_NOTIFY_ADDR_FLAG,PLANT_ID, MARKSANDNUMBERS ,SERVICECONTRACTNO ,DELIVERYLOCATION ,DELIVERYINSTRUCTIONS ,BOOKINGNUMBER ,CONSOLEID ,CONSOLESTATUS,SPEC_REQ_RIDER,SPEC_REQ_RIDER_CRTD,REQUESTED_ETD,INCOMPLETE_NY,CRTD_TSTMP,CRTD_BY,CONSOL_ID,PLANT_NAME,SAIL_FLAG,ORIGIN_STATION_ADDR_ID, ORIGIN_STATION_NAME, DESTINATION_STATION_ADDR_ID, DESTINATION_STATION_NAME,BILL_LADING_NO,PRE_CARRIAGE_BY,COURIER_NAME,COURIER_NUMBER,SYSTEM_FLAG_NY,SHIPPER_COUNTRY_NAME,CONSIGNEE_COUNTRY_NAME,NOTIFY_COUNTRY_NAME,ALSO_NOTIFY_COUNTRY_NAME, RECEIPT_POINT, HAZ_QUALIFIER,CUSTOMS_REQUIRED_NY,ASSEMBLY_TYPE,HBL_TYPE,MASTER_HBL_NO,NO_PRINTS,NO_CHRGS_COMP,CONTACT_NAME,DELIVERY_CUT_OFF,ITEM_REMARKS,FINAL_DESTINATION,CONTACT_FAX_NO,IS_BACK_TO_BACK ) VALUES ('70' || hblno,'70' || hblno,sysdate,'LHR','LHR','SIN','AEDAS','AEAUH','BOM','','','MADRAS, IN','BOMBAY, IN','H','L','P','Prepaid','AW','BP','','N','','  ','',sailingschedule,sysdate,10.0,100.0,'KG',0.01,'CBM',0.1,'N','','N','',0,'1130179','A SCHULMAN',customeraddrid,'N','112','1130179','A SCHULMAN',shipperaddrid,'N','233','1189281','ABBOTT LABORATORIES',consigneeaddrid,'N','444','1133774','SKYNET WORLDWIDE KIEV',billtoaddrid,'N','','',0,'N','','',0,'N','','',0,'N','','','','','','70' || hblno,'','N','','',sysdate,'Y',sysdate,'ANIL',0,'','N',originstationaddrid,'EGL EAGLE GLOBAL LOGISTICS (UK) LTD.',deststationaddrid,'EGL EAGLE GLOBAL LOGISTICS (S) PTE LTD','','','','','Y','UNITED STATES OF AMERICA','UNITED STATES OF AMERICA','','','IN','','N','','HBL',0,0,'N','','','','','','N');
dbms_output.put_line('70' || hblno);

END LOOP;
end HBLMASTERprocedure;