888: l_shipment_batch_tbl(l_cnt).freight_terms_code,
889: l_shipment_batch_tbl(l_cnt).fob_code,
890: 'Y',
891: SYSDATE,
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
890: 'Y',
891: SYSDATE,
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
891: SYSDATE,
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
900: END IF;
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
900: END IF;
901: --} Seperating Batches Ends Here
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
900: END IF;
901: --} Seperating Batches Ends Here
902:
922: set shipment_batch_id = l_dd_batch_id_tbl(i),
923: shipment_line_number = l_dd_line_num_tbl(i),
924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
923: shipment_line_number = l_dd_line_num_tbl(i),
924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
932: where rowid = l_rowid_tbl(i)
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
932: where rowid = l_rowid_tbl(i)
933: and l_wdd_update_flag(i) = 'Y';
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
932: where rowid = l_rowid_tbl(i)
933: and l_wdd_update_flag(i) = 'Y';
934:
1028: --
1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.log(l_module_name, 'Total No. of shipment batches created', l_batch_tbl.count);
1031: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------------');
1032: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN
1033: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of shipment batches created => ' || l_batch_tbl.count);
1034: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------');
1035: END IF;
1036: --
1036: --
1037:
1038: --
1039: IF l_debug_on OR
1040: nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0
1041: THEN
1042: IF l_batch_tbl.count > 0 THEN
1043: FOR i in l_batch_tbl.first..l_batch_tbl.last
1044: LOOP
1043: FOR i in l_batch_tbl.first..l_batch_tbl.last
1044: LOOP
1045: IF l_debug_on THEN
1046: WSH_DEBUG_SV.logmsg(l_module_name, i || '. Shipment Batch Id => ' || l_batch_tbl(i));
1047: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN
1048: FND_FILE.put_line(FND_FILE.LOG, i || '. Shipment Batch Id => ' || l_batch_tbl(i));
1049: END IF;
1050: END LOOP;
1051: END IF;
1055: --
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------------');
1058: WSH_DEBUG_SV.pop(l_module_name);
1059: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN
1060: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------');
1061: END IF;
1062: --
1063:
1228: set shipment_batch_id = null,
1229: shipment_line_number = null,
1230: reference_line_id = null,
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1229: shipment_line_number = null,
1230: reference_line_id = null,
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1230: reference_line_id = null,
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1238: where delivery_detail_id = l_unassign_detail_tab(i);
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1238: where delivery_detail_id = l_unassign_detail_tab(i);
1239:
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1238: where delivery_detail_id = l_unassign_detail_tab(i);
1239:
1240: --