eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INV_ISO_PKG dependencies on FND_MESSAGE

Line 825: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

821: ELSE -- Error No dest non serial recs round
822: IF (l_debug > 0) THEN
823: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-14, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
824: END IF;
825: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

Line 826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

822: IF (l_debug > 0) THEN
823: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-14, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
824: END IF;
825: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
830: l_error_message := fnd_message.get;

Line 827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

823: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-14, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
824: END IF;
825: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
830: l_error_message := fnd_message.get;
831: RAISE fnd_api.g_exc_error;

Line 828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

824: END IF;
825: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
830: l_error_message := fnd_message.get;
831: RAISE fnd_api.g_exc_error;
832: END IF; -- End of Destination Record If

Line 829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

825: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
830: l_error_message := fnd_message.get;
831: RAISE fnd_api.g_exc_error;
832: END IF; -- End of Destination Record If
833:

Line 830: l_error_message := fnd_message.get;

826: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
827: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
828: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
829: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
830: l_error_message := fnd_message.get;
831: RAISE fnd_api.g_exc_error;
832: END IF; -- End of Destination Record If
833:
834: END IF; -- End of j=1 for Control Code 1

Line 842: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

838: IF (l_debug > 0) THEN
839: csi_t_gen_utility_pvt.add('No Records were found in Install Base-13');
840: END IF;
841:
842: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
843: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
844: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
845: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
846: l_error_message := fnd_message.get;

Line 843: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

839: csi_t_gen_utility_pvt.add('No Records were found in Install Base-13');
840: END IF;
841:
842: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
843: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
844: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
845: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
846: l_error_message := fnd_message.get;
847: RAISE fnd_api.g_exc_error;

Line 844: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

840: END IF;
841:
842: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
843: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
844: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
845: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
846: l_error_message := fnd_message.get;
847: RAISE fnd_api.g_exc_error;
848:

Line 845: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

841:
842: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
843: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
844: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
845: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
846: l_error_message := fnd_message.get;
847: RAISE fnd_api.g_exc_error;
848:
849: END IF; -- SRC Table Count

Line 846: l_error_message := fnd_message.get;

842: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
843: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
844: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
845: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
846: l_error_message := fnd_message.get;
847: RAISE fnd_api.g_exc_error;
848:
849: END IF; -- SRC Table Count
850:

Line 942: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

938: ELSE -- Inv Does not allowe neg qty and source is not found
939: IF (l_debug > 0) THEN
940: csi_t_gen_utility_pvt.add('No Records were found in Install Base-16');
941: END IF;
942: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
943: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
944: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
945: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
946: l_error_message := fnd_message.get;

Line 943: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

939: IF (l_debug > 0) THEN
940: csi_t_gen_utility_pvt.add('No Records were found in Install Base-16');
941: END IF;
942: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
943: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
944: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
945: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
946: l_error_message := fnd_message.get;
947: RAISE fnd_api.g_exc_error;

Line 944: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

940: csi_t_gen_utility_pvt.add('No Records were found in Install Base-16');
941: END IF;
942: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
943: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
944: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
945: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
946: l_error_message := fnd_message.get;
947: RAISE fnd_api.g_exc_error;
948:

Line 945: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

941: END IF;
942: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
943: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
944: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
945: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
946: l_error_message := fnd_message.get;
947: RAISE fnd_api.g_exc_error;
948:
949: END IF; -- End of Neg Qty IF

Line 946: l_error_message := fnd_message.get;

942: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
943: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
944: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
945: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
946: l_error_message := fnd_message.get;
947: RAISE fnd_api.g_exc_error;
948:
949: END IF; -- End of Neg Qty IF
950: ELSIF l_src_instance_header_tbl.count = 1 THEN -- Source Records are found

Line 1025: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

1021: -- Multiple Instances were found so throw error
1022: IF (l_debug > 0) THEN
1023: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-19');
1024: END IF;
1025: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

1022: IF (l_debug > 0) THEN
1023: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-19');
1024: END IF;
1025: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1030: l_error_message := fnd_message.get;

Line 1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

1023: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-19');
1024: END IF;
1025: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1030: l_error_message := fnd_message.get;
1031: RAISE fnd_api.g_exc_error;

Line 1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

1024: END IF;
1025: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1030: l_error_message := fnd_message.get;
1031: RAISE fnd_api.g_exc_error;
1032: END IF; -- End of If for Main Source

Line 1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

1025: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1030: l_error_message := fnd_message.get;
1031: RAISE fnd_api.g_exc_error;
1032: END IF; -- End of If for Main Source
1033: END IF; -- End of J If

Line 1030: l_error_message := fnd_message.get;

1026: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1027: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1028: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1029: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1030: l_error_message := fnd_message.get;
1031: RAISE fnd_api.g_exc_error;
1032: END IF; -- End of If for Main Source
1033: END IF; -- End of J If
1034:

Line 1307: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

1303: ELSE -- Error No Src Recs with usage of In Transit or Returned
1304: IF (l_debug > 0) THEN
1305: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-20, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
1306: END IF;
1307: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

Line 1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

1304: IF (l_debug > 0) THEN
1305: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-20, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
1306: END IF;
1307: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1312: l_error_message := fnd_message.get;

Line 1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

1305: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-20, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
1306: END IF;
1307: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1312: l_error_message := fnd_message.get;
1313: RAISE fnd_api.g_exc_error;

Line 1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

1306: END IF;
1307: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1312: l_error_message := fnd_message.get;
1313: RAISE fnd_api.g_exc_error;
1314: END IF; -- In Transit and Returned Usage Code Check

Line 1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

1307: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1312: l_error_message := fnd_message.get;
1313: RAISE fnd_api.g_exc_error;
1314: END IF; -- In Transit and Returned Usage Code Check
1315: END IF; -- End of Destination Record If

Line 1312: l_error_message := fnd_message.get;

1308: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1309: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1310: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1311: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1312: l_error_message := fnd_message.get;
1313: RAISE fnd_api.g_exc_error;
1314: END IF; -- In Transit and Returned Usage Code Check
1315: END IF; -- End of Destination Record If
1316:

Line 1912: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

1908: ELSE -- Error No dest non serial recs round
1909: IF (l_debug > 0) THEN
1910: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-20, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
1911: END IF;
1912: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

Line 1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

1909: IF (l_debug > 0) THEN
1910: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-20, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
1911: END IF;
1912: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1917: l_error_message := fnd_message.get;

Line 1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

1910: csi_t_gen_utility_pvt.add('No Records were found in Install Base but the usage is not correct-20, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);
1911: END IF;
1912: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1917: l_error_message := fnd_message.get;
1918: RAISE fnd_api.g_exc_error;

Line 1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

1911: END IF;
1912: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1917: l_error_message := fnd_message.get;
1918: RAISE fnd_api.g_exc_error;
1919:

Line 1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

1912: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1917: l_error_message := fnd_message.get;
1918: RAISE fnd_api.g_exc_error;
1919:
1920: end if; --End of Destination Record If

Line 1917: l_error_message := fnd_message.get;

1913: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1914: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1915: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1916: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1917: l_error_message := fnd_message.get;
1918: RAISE fnd_api.g_exc_error;
1919:
1920: end if; --End of Destination Record If
1921:

Line 1972: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

1968: IF (l_debug > 0) THEN
1969: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Internal Sales Order Transaction - In Transit Shipment');
1970: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
1971: END IF;
1972: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1973: fnd_message.set_token('API_NAME',l_api_name);
1974: fnd_message.set_token('SQL_ERROR',SQLERRM);
1975: x_return_status := l_fnd_unexpected;
1976:

Line 1973: fnd_message.set_token('API_NAME',l_api_name);

1969: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Internal Sales Order Transaction - In Transit Shipment');
1970: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
1971: END IF;
1972: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1973: fnd_message.set_token('API_NAME',l_api_name);
1974: fnd_message.set_token('SQL_ERROR',SQLERRM);
1975: x_return_status := l_fnd_unexpected;
1976:
1977: IF l_mtl_item_tbl.count > 0 THEN

Line 1974: fnd_message.set_token('SQL_ERROR',SQLERRM);

1970: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
1971: END IF;
1972: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1973: fnd_message.set_token('API_NAME',l_api_name);
1974: fnd_message.set_token('SQL_ERROR',SQLERRM);
1975: x_return_status := l_fnd_unexpected;
1976:
1977: IF l_mtl_item_tbl.count > 0 THEN
1978: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 1994: x_trx_error_rec.error_text := fnd_message.get;

1990: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
1991: x_trx_error_rec.transaction_error_date := l_sysdate ;
1992: END IF;
1993:
1994: x_trx_error_rec.error_text := fnd_message.get;
1995: x_trx_error_rec.transaction_id := NULL;
1996: x_trx_error_rec.source_type := 'CSIINTSS';
1997: x_trx_error_rec.source_id := p_transaction_id;
1998: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 2893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

2889: -- Multiple Instances were found so throw error
2890: IF (l_debug > 0) THEN
2891: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-14');
2892: END IF;
2893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

2890: IF (l_debug > 0) THEN
2891: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-14');
2892: END IF;
2893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2898: l_error_message := fnd_message.get;

Line 2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

2891: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-14');
2892: END IF;
2893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2898: l_error_message := fnd_message.get;
2899: RAISE fnd_api.g_exc_error;

Line 2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

2892: END IF;
2893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2898: l_error_message := fnd_message.get;
2899: RAISE fnd_api.g_exc_error;
2900:

Line 2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

2893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2898: l_error_message := fnd_message.get;
2899: RAISE fnd_api.g_exc_error;
2900:
2901: END IF; -- End of Destination Record If

Line 2898: l_error_message := fnd_message.get;

2894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2898: l_error_message := fnd_message.get;
2899: RAISE fnd_api.g_exc_error;
2900:
2901: END IF; -- End of Destination Record If
2902: --END IF; -- End of J Index Loop

Line 3212: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

3208: -- Multiple Instances were found so throw error
3209: IF (l_debug > 0) THEN
3210: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-28');
3211: END IF;
3212: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

3209: IF (l_debug > 0) THEN
3210: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-28');
3211: END IF;
3212: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3217: l_error_message := fnd_message.get;

Line 3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

3210: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-28');
3211: END IF;
3212: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3217: l_error_message := fnd_message.get;
3218: RAISE fnd_api.g_exc_error;

Line 3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

3211: END IF;
3212: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3217: l_error_message := fnd_message.get;
3218: RAISE fnd_api.g_exc_error;
3219:

Line 3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

3212: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3217: l_error_message := fnd_message.get;
3218: RAISE fnd_api.g_exc_error;
3219:
3220: END IF; -- End of Destination Record If

Line 3217: l_error_message := fnd_message.get;

3213: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3214: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3215: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3216: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3217: l_error_message := fnd_message.get;
3218: RAISE fnd_api.g_exc_error;
3219:
3220: END IF; -- End of Destination Record If
3221: END IF; -- End J Loop IF

Line 3490: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

3486:
3487: IF (l_debug > 0) THEN
3488: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-43');
3489: END IF;
3490: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

3487: IF (l_debug > 0) THEN
3488: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-43');
3489: END IF;
3490: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3495: l_error_message := fnd_message.get;

Line 3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

3488: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-43');
3489: END IF;
3490: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3495: l_error_message := fnd_message.get;
3496: RAISE fnd_api.g_exc_error;

Line 3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

3489: END IF;
3490: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3495: l_error_message := fnd_message.get;
3496: RAISE fnd_api.g_exc_error;
3497: END IF; -- End of Destination Record If

Line 3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

3490: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3495: l_error_message := fnd_message.get;
3496: RAISE fnd_api.g_exc_error;
3497: END IF; -- End of Destination Record If
3498:

Line 3495: l_error_message := fnd_message.get;

3491: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3492: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3493: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3494: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3495: l_error_message := fnd_message.get;
3496: RAISE fnd_api.g_exc_error;
3497: END IF; -- End of Destination Record If
3498:
3499:

Line 3901: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

3897: IF (l_debug > 0) THEN
3898: csi_t_gen_utility_pvt.add('No Records were found in Install Base-55');
3899: END IF;
3900:
3901: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3902: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3903: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3904: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3905: l_error_message := fnd_message.get;

Line 3902: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

3898: csi_t_gen_utility_pvt.add('No Records were found in Install Base-55');
3899: END IF;
3900:
3901: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3902: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3903: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3904: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3905: l_error_message := fnd_message.get;
3906: RAISE fnd_api.g_exc_error;

Line 3903: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

3899: END IF;
3900:
3901: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3902: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3903: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3904: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3905: l_error_message := fnd_message.get;
3906: RAISE fnd_api.g_exc_error;
3907: END IF; -- Usage Code If

Line 3904: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

3900:
3901: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3902: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3903: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3904: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3905: l_error_message := fnd_message.get;
3906: RAISE fnd_api.g_exc_error;
3907: END IF; -- Usage Code If
3908:

Line 3905: l_error_message := fnd_message.get;

3901: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3902: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3903: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3904: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3905: l_error_message := fnd_message.get;
3906: RAISE fnd_api.g_exc_error;
3907: END IF; -- Usage Code If
3908:
3909: ELSIF l_dest_instance_header_tbl.count > 1 THEN

Line 3915: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

3911: -- Multiple Instances were found so throw error
3912: IF (l_debug > 0) THEN
3913: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-54');
3914: END IF;
3915: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

3912: IF (l_debug > 0) THEN
3913: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-54');
3914: END IF;
3915: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3920: l_error_message := fnd_message.get;

Line 3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

3913: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-54');
3914: END IF;
3915: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3920: l_error_message := fnd_message.get;
3921: RAISE fnd_api.g_exc_error;

Line 3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

3914: END IF;
3915: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3920: l_error_message := fnd_message.get;
3921: RAISE fnd_api.g_exc_error;
3922:

Line 3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

3915: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3920: l_error_message := fnd_message.get;
3921: RAISE fnd_api.g_exc_error;
3922:
3923: END IF; -- End of Destination Record If

Line 3920: l_error_message := fnd_message.get;

3916: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3917: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3918: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3919: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3920: l_error_message := fnd_message.get;
3921: RAISE fnd_api.g_exc_error;
3922:
3923: END IF; -- End of Destination Record If
3924:

Line 3931: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

3927: ELSE -- No IB Records Found So throw Error
3928: IF (l_debug > 0) THEN
3929: csi_t_gen_utility_pvt.add('No Records were found in Install Base to receive-55');
3930: END IF;
3931: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3932: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3933: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3934: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3935: l_error_message := fnd_message.get;

Line 3932: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

3928: IF (l_debug > 0) THEN
3929: csi_t_gen_utility_pvt.add('No Records were found in Install Base to receive-55');
3930: END IF;
3931: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3932: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3933: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3934: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3935: l_error_message := fnd_message.get;
3936: RAISE fnd_api.g_exc_error;

Line 3933: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

3929: csi_t_gen_utility_pvt.add('No Records were found in Install Base to receive-55');
3930: END IF;
3931: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3932: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3933: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3934: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3935: l_error_message := fnd_message.get;
3936: RAISE fnd_api.g_exc_error;
3937: END IF; -- End of Main Source Header Tbl IF

Line 3934: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

3930: END IF;
3931: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3932: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3933: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3934: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3935: l_error_message := fnd_message.get;
3936: RAISE fnd_api.g_exc_error;
3937: END IF; -- End of Main Source Header Tbl IF
3938: END LOOP; -- End of For Loop

Line 3935: l_error_message := fnd_message.get;

3931: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3932: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3933: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3934: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3935: l_error_message := fnd_message.get;
3936: RAISE fnd_api.g_exc_error;
3937: END IF; -- End of Main Source Header Tbl IF
3938: END LOOP; -- End of For Loop
3939:

Line 3984: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

3980: IF (l_debug > 0) THEN
3981: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Internal Order In Transit Receipt');
3982: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
3983: END IF;
3984: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3985: fnd_message.set_token('API_NAME',l_api_name);
3986: fnd_message.set_token('SQL_ERROR',SQLERRM);
3987: x_return_status := l_fnd_unexpected;
3988:

Line 3985: fnd_message.set_token('API_NAME',l_api_name);

3981: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Internal Order In Transit Receipt');
3982: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
3983: END IF;
3984: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3985: fnd_message.set_token('API_NAME',l_api_name);
3986: fnd_message.set_token('SQL_ERROR',SQLERRM);
3987: x_return_status := l_fnd_unexpected;
3988:
3989: IF l_mtl_item_tbl.count > 0 THEN

Line 3986: fnd_message.set_token('SQL_ERROR',SQLERRM);

3982: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
3983: END IF;
3984: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3985: fnd_message.set_token('API_NAME',l_api_name);
3986: fnd_message.set_token('SQL_ERROR',SQLERRM);
3987: x_return_status := l_fnd_unexpected;
3988:
3989: IF l_mtl_item_tbl.count > 0 THEN
3990: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 4006: x_trx_error_rec.error_text := fnd_message.get;

4002: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
4003: x_trx_error_rec.transaction_error_date := l_sysdate ;
4004: END IF;
4005:
4006: x_trx_error_rec.error_text := fnd_message.get;
4007: x_trx_error_rec.transaction_id := NULL;
4008: x_trx_error_rec.source_type := 'CSIINTSR';
4009: x_trx_error_rec.source_id := p_transaction_id;
4010: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 4598: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

4594: IF (l_debug > 0) THEN
4595: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
4596: END IF;
4597:
4598: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

Line 4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

4595: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
4596: END IF;
4597:
4598: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4603: l_error_message := fnd_message.get;

Line 4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

4596: END IF;
4597:
4598: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4603: l_error_message := fnd_message.get;
4604: RAISE fnd_api.g_exc_error;

Line 4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

4597:
4598: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4603: l_error_message := fnd_message.get;
4604: RAISE fnd_api.g_exc_error;
4605: END IF; -- End of 2,5 and 2,5 IF

Line 4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

4598: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4603: l_error_message := fnd_message.get;
4604: RAISE fnd_api.g_exc_error;
4605: END IF; -- End of 2,5 and 2,5 IF
4606:

Line 4603: l_error_message := fnd_message.get;

4599: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4600: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4601: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4602: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4603: l_error_message := fnd_message.get;
4604: RAISE fnd_api.g_exc_error;
4605: END IF; -- End of 2,5 and 2,5 IF
4606:
4607: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 1 AND -- Ship

Line 4713: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

4709: IF (l_debug > 0) THEN
4710: csi_t_gen_utility_pvt.add('No Records were found in Install Base - 11');
4711: END IF;
4712:
4713: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

Line 4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

4710: csi_t_gen_utility_pvt.add('No Records were found in Install Base - 11');
4711: END IF;
4712:
4713: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4718: l_error_message := fnd_message.get;

Line 4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

4711: END IF;
4712:
4713: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4718: l_error_message := fnd_message.get;
4719: RAISE fnd_api.g_exc_error;

Line 4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

4712:
4713: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4718: l_error_message := fnd_message.get;
4719: RAISE fnd_api.g_exc_error;
4720:

Line 4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

4713: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4718: l_error_message := fnd_message.get;
4719: RAISE fnd_api.g_exc_error;
4720:
4721: END IF; -- End of Neg Qty If

Line 4718: l_error_message := fnd_message.get;

4714: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4715: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4716: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4717: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4718: l_error_message := fnd_message.get;
4719: RAISE fnd_api.g_exc_error;
4720:
4721: END IF; -- End of Neg Qty If
4722:

Line 4798: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

4794: -- Multiple Instances were found so throw error
4795: IF (l_debug > 0) THEN
4796: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-11');
4797: END IF;
4798: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

4795: IF (l_debug > 0) THEN
4796: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-11');
4797: END IF;
4798: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4803: l_error_message := fnd_message.get;

Line 4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

4796: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-11');
4797: END IF;
4798: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4803: l_error_message := fnd_message.get;
4804: RAISE fnd_api.g_exc_error;

Line 4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

4797: END IF;
4798: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4803: l_error_message := fnd_message.get;
4804: RAISE fnd_api.g_exc_error;
4805:

Line 4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

4798: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4803: l_error_message := fnd_message.get;
4804: RAISE fnd_api.g_exc_error;
4805:
4806: END IF; -- End of If for Source Count

Line 4803: l_error_message := fnd_message.get;

4799: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4800: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4801: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4802: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4803: l_error_message := fnd_message.get;
4804: RAISE fnd_api.g_exc_error;
4805:
4806: END IF; -- End of If for Source Count
4807:

Line 5011: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

5007: -- Multiple Instances were found so throw error
5008: IF (l_debug > 0) THEN
5009: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
5010: END IF;
5011: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

5008: IF (l_debug > 0) THEN
5009: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
5010: END IF;
5011: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5016: l_error_message := fnd_message.get;

Line 5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

5009: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
5010: END IF;
5011: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5016: l_error_message := fnd_message.get;
5017: RAISE fnd_api.g_exc_error;

Line 5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

5010: END IF;
5011: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5016: l_error_message := fnd_message.get;
5017: RAISE fnd_api.g_exc_error;
5018:

Line 5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

5011: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5016: l_error_message := fnd_message.get;
5017: RAISE fnd_api.g_exc_error;
5018:
5019: END IF; -- End of Destination Record If

Line 5016: l_error_message := fnd_message.get;

5012: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5013: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5014: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5015: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5016: l_error_message := fnd_message.get;
5017: RAISE fnd_api.g_exc_error;
5018:
5019: END IF; -- End of Destination Record If
5020:

Line 5314: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

5310: -- Multiple Instances were found so throw error
5311: IF (l_debug > 0) THEN
5312: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-61');
5313: END IF;
5314: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

5311: IF (l_debug > 0) THEN
5312: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-61');
5313: END IF;
5314: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5319: l_error_message := fnd_message.get;

Line 5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

5312: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-61');
5313: END IF;
5314: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5319: l_error_message := fnd_message.get;
5320: RAISE fnd_api.g_exc_error;

Line 5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

5313: END IF;
5314: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5319: l_error_message := fnd_message.get;
5320: RAISE fnd_api.g_exc_error;
5321:

Line 5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

5314: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5319: l_error_message := fnd_message.get;
5320: RAISE fnd_api.g_exc_error;
5321:
5322: END IF; -- End of Destination Record If

Line 5319: l_error_message := fnd_message.get;

5315: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5316: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5317: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5318: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5319: l_error_message := fnd_message.get;
5320: RAISE fnd_api.g_exc_error;
5321:
5322: END IF; -- End of Destination Record If
5323: END IF; -- End of J Index Loop

Line 5637: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

5633: IF (l_debug > 0) THEN
5634: csi_t_gen_utility_pvt.add('No Records were found in Install Base-5');
5635: END IF;
5636:
5637: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5638: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5639: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5640: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5641: l_error_message := fnd_message.get;

Line 5638: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

5634: csi_t_gen_utility_pvt.add('No Records were found in Install Base-5');
5635: END IF;
5636:
5637: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5638: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5639: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5640: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5641: l_error_message := fnd_message.get;
5642: RAISE fnd_api.g_exc_error;

Line 5639: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);

5635: END IF;
5636:
5637: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5638: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5639: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5640: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5641: l_error_message := fnd_message.get;
5642: RAISE fnd_api.g_exc_error;
5643:

Line 5640: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);

5636:
5637: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5638: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5639: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5640: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5641: l_error_message := fnd_message.get;
5642: RAISE fnd_api.g_exc_error;
5643:
5644: END IF; -- End of inv or in rel IF

Line 5641: l_error_message := fnd_message.get;

5637: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5638: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5639: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5640: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5641: l_error_message := fnd_message.get;
5642: RAISE fnd_api.g_exc_error;
5643:
5644: END IF; -- End of inv or in rel IF
5645:

Line 5651: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

5647: -- Multiple Instances were found so throw error
5648: IF (l_debug > 0) THEN
5649: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-62');
5650: END IF;
5651: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

Line 5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);

5648: IF (l_debug > 0) THEN
5649: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-62');
5650: END IF;
5651: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5656: l_error_message := fnd_message.get;

Line 5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);

5649: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-62');
5650: END IF;
5651: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5656: l_error_message := fnd_message.get;
5657: RAISE fnd_api.g_exc_error;

Line 5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);

5650: END IF;
5651: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5656: l_error_message := fnd_message.get;
5657: RAISE fnd_api.g_exc_error;
5658:

Line 5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

5651: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5656: l_error_message := fnd_message.get;
5657: RAISE fnd_api.g_exc_error;
5658:
5659: END IF; -- End of Destination Record If

Line 5656: l_error_message := fnd_message.get;

5652: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5653: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5654: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5655: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5656: l_error_message := fnd_message.get;
5657: RAISE fnd_api.g_exc_error;
5658:
5659: END IF; -- End of Destination Record If
5660:

Line 5718: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

5714: IF (l_debug > 0) THEN
5715: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Direct ISO Transaction');
5716: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
5717: END IF;
5718: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5719: fnd_message.set_token('API_NAME',l_api_name);
5720: fnd_message.set_token('SQL_ERROR',SQLERRM);
5721: x_return_status := l_fnd_unexpected;
5722:

Line 5719: fnd_message.set_token('API_NAME',l_api_name);

5715: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Direct ISO Transaction');
5716: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
5717: END IF;
5718: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5719: fnd_message.set_token('API_NAME',l_api_name);
5720: fnd_message.set_token('SQL_ERROR',SQLERRM);
5721: x_return_status := l_fnd_unexpected;
5722:
5723: IF l_mtl_item_tbl.count > 0 THEN

Line 5720: fnd_message.set_token('SQL_ERROR',SQLERRM);

5716: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
5717: END IF;
5718: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5719: fnd_message.set_token('API_NAME',l_api_name);
5720: fnd_message.set_token('SQL_ERROR',SQLERRM);
5721: x_return_status := l_fnd_unexpected;
5722:
5723: IF l_mtl_item_tbl.count > 0 THEN
5724: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 5740: x_trx_error_rec.error_text := fnd_message.get;

5736: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
5737: x_trx_error_rec.transaction_error_date := l_sysdate ;
5738: END IF;
5739:
5740: x_trx_error_rec.error_text := fnd_message.get;
5741: x_trx_error_rec.transaction_id := NULL;
5742: x_trx_error_rec.source_type := 'CSIINTDS';
5743: x_trx_error_rec.source_id := p_transaction_id;
5744: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;