DBA Data[Home] [Help]

APPS.CSI_INV_ISO_PKG dependencies on FND_MESSAGE

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

825: ELSE -- Error No dest non serial recs round
826: IF (l_debug > 0) THEN
827: 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);
828: END IF;
829: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
830: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
831: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
832: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
833: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

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

826: IF (l_debug > 0) THEN
827: 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);
828: END IF;
829: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
830: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
831: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
832: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
833: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
834: l_error_message := fnd_message.get;

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

827: 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);
828: END IF;
829: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
830: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
831: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
832: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
833: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
834: l_error_message := fnd_message.get;
835: RAISE fnd_api.g_exc_error;

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

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

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

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

Line 834: l_error_message := fnd_message.get;

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

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

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

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

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

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

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

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

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

Line 850: l_error_message := fnd_message.get;

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

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

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

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

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

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

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

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

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

Line 950: l_error_message := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

Line 1034: l_error_message := fnd_message.get;

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

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

1307: ELSE -- Error No Src Recs with usage of In Transit or Returned
1308: IF (l_debug > 0) THEN
1309: 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);
1310: END IF;
1311: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1312: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1313: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1314: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1315: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

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

1308: IF (l_debug > 0) THEN
1309: 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);
1310: END IF;
1311: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1312: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1313: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1314: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1315: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1316: l_error_message := fnd_message.get;

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

1309: 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);
1310: END IF;
1311: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1312: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1313: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1314: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1315: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1316: l_error_message := fnd_message.get;
1317: RAISE fnd_api.g_exc_error;

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

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

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

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

Line 1316: l_error_message := fnd_message.get;

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

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

1912: ELSE -- Error No dest non serial recs round
1913: IF (l_debug > 0) THEN
1914: 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);
1915: END IF;
1916: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1917: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1918: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1919: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1920: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

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

1913: IF (l_debug > 0) THEN
1914: 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);
1915: END IF;
1916: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1917: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1918: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1919: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1920: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1921: l_error_message := fnd_message.get;

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

1914: 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);
1915: END IF;
1916: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1917: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1918: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1919: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1920: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1921: l_error_message := fnd_message.get;
1922: RAISE fnd_api.g_exc_error;

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

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

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

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

Line 1921: l_error_message := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

2908: -- Multiple Instances were found so throw error
2909: IF (l_debug > 0) THEN
2910: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-14');
2911: END IF;
2912: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2913: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2909: IF (l_debug > 0) THEN
2910: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-14');
2911: END IF;
2912: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2913: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2917: l_error_message := fnd_message.get;

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

2910: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-14');
2911: END IF;
2912: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2913: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2917: l_error_message := fnd_message.get;
2918: RAISE fnd_api.g_exc_error;

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

2911: END IF;
2912: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2913: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2917: l_error_message := fnd_message.get;
2918: RAISE fnd_api.g_exc_error;
2919:

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

2912: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2913: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2917: l_error_message := fnd_message.get;
2918: RAISE fnd_api.g_exc_error;
2919:
2920: END IF; -- End of Destination Record If

Line 2917: l_error_message := fnd_message.get;

2913: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2917: l_error_message := fnd_message.get;
2918: RAISE fnd_api.g_exc_error;
2919:
2920: END IF; -- End of Destination Record If
2921: --END IF; -- End of J Index Loop

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

3228: -- Multiple Instances were found so throw error
3229: IF (l_debug > 0) THEN
3230: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-28');
3231: END IF;
3232: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3233: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3234: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3235: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3236: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

3229: IF (l_debug > 0) THEN
3230: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-28');
3231: END IF;
3232: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3233: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3234: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3235: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3236: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3237: l_error_message := fnd_message.get;

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

3230: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-28');
3231: END IF;
3232: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3233: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3234: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3235: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3236: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3237: l_error_message := fnd_message.get;
3238: RAISE fnd_api.g_exc_error;

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

3231: END IF;
3232: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3233: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3234: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3235: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3236: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3237: l_error_message := fnd_message.get;
3238: RAISE fnd_api.g_exc_error;
3239:

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

3232: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3233: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3234: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3235: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3236: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3237: l_error_message := fnd_message.get;
3238: RAISE fnd_api.g_exc_error;
3239:
3240: END IF; -- End of Destination Record If

Line 3237: l_error_message := fnd_message.get;

3233: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3234: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3235: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3236: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3237: l_error_message := fnd_message.get;
3238: RAISE fnd_api.g_exc_error;
3239:
3240: END IF; -- End of Destination Record If
3241: END IF; -- End J Loop IF

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

3506:
3507: IF (l_debug > 0) THEN
3508: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-43');
3509: END IF;
3510: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3511: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3512: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3513: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3514: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

3507: IF (l_debug > 0) THEN
3508: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-43');
3509: END IF;
3510: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3511: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3512: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3513: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3514: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3515: l_error_message := fnd_message.get;

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

3508: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-43');
3509: END IF;
3510: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3511: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3512: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3513: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3514: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3515: l_error_message := fnd_message.get;
3516: RAISE fnd_api.g_exc_error;

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

3509: END IF;
3510: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3511: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3512: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3513: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3514: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3515: l_error_message := fnd_message.get;
3516: RAISE fnd_api.g_exc_error;
3517: END IF; -- End of Destination Record If

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

3510: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3511: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3512: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3513: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3514: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3515: l_error_message := fnd_message.get;
3516: RAISE fnd_api.g_exc_error;
3517: END IF; -- End of Destination Record If
3518:

Line 3515: l_error_message := fnd_message.get;

3511: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3512: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3513: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3514: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3515: l_error_message := fnd_message.get;
3516: RAISE fnd_api.g_exc_error;
3517: END IF; -- End of Destination Record If
3518:
3519:

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

3917: IF (l_debug > 0) THEN
3918: csi_t_gen_utility_pvt.add('No Records were found in Install Base-55');
3919: END IF;
3920:
3921: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3922: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3923: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3924: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3925: l_error_message := fnd_message.get;

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

3918: csi_t_gen_utility_pvt.add('No Records were found in Install Base-55');
3919: END IF;
3920:
3921: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3922: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3923: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3924: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3925: l_error_message := fnd_message.get;
3926: RAISE fnd_api.g_exc_error;

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

3919: END IF;
3920:
3921: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3922: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3923: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3924: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3925: l_error_message := fnd_message.get;
3926: RAISE fnd_api.g_exc_error;
3927: END IF; -- Usage Code If

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

3920:
3921: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3922: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3923: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3924: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3925: l_error_message := fnd_message.get;
3926: RAISE fnd_api.g_exc_error;
3927: END IF; -- Usage Code If
3928:

Line 3925: l_error_message := fnd_message.get;

3921: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3922: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3923: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3924: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3925: l_error_message := fnd_message.get;
3926: RAISE fnd_api.g_exc_error;
3927: END IF; -- Usage Code If
3928:
3929: ELSIF l_dest_instance_header_tbl.count > 1 THEN

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

3931: -- Multiple Instances were found so throw error
3932: IF (l_debug > 0) THEN
3933: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-54');
3934: END IF;
3935: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3936: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3937: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3938: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3939: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

3932: IF (l_debug > 0) THEN
3933: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-54');
3934: END IF;
3935: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3936: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3937: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3938: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3939: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3940: l_error_message := fnd_message.get;

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

3933: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-54');
3934: END IF;
3935: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3936: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3937: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3938: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3939: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3940: l_error_message := fnd_message.get;
3941: RAISE fnd_api.g_exc_error;

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

3934: END IF;
3935: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3936: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3937: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3938: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3939: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3940: l_error_message := fnd_message.get;
3941: RAISE fnd_api.g_exc_error;
3942:

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

3935: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3936: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3937: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3938: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3939: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3940: l_error_message := fnd_message.get;
3941: RAISE fnd_api.g_exc_error;
3942:
3943: END IF; -- End of Destination Record If

Line 3940: l_error_message := fnd_message.get;

3936: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3937: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3938: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3939: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3940: l_error_message := fnd_message.get;
3941: RAISE fnd_api.g_exc_error;
3942:
3943: END IF; -- End of Destination Record If
3944:

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

3947: ELSE -- No IB Records Found So throw Error
3948: IF (l_debug > 0) THEN
3949: csi_t_gen_utility_pvt.add('No Records were found in Install Base to receive-55');
3950: END IF;
3951: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3952: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3953: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3954: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3955: l_error_message := fnd_message.get;

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

3948: IF (l_debug > 0) THEN
3949: csi_t_gen_utility_pvt.add('No Records were found in Install Base to receive-55');
3950: END IF;
3951: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3952: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3953: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3954: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3955: l_error_message := fnd_message.get;
3956: RAISE fnd_api.g_exc_error;

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

3949: csi_t_gen_utility_pvt.add('No Records were found in Install Base to receive-55');
3950: END IF;
3951: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3952: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3953: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3954: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3955: l_error_message := fnd_message.get;
3956: RAISE fnd_api.g_exc_error;
3957: END IF; -- End of Main Source Header Tbl IF

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

3950: END IF;
3951: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3952: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3953: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3954: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3955: l_error_message := fnd_message.get;
3956: RAISE fnd_api.g_exc_error;
3957: END IF; -- End of Main Source Header Tbl IF
3958: END LOOP; -- End of For Loop

Line 3955: l_error_message := fnd_message.get;

3951: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3952: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3953: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3954: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3955: l_error_message := fnd_message.get;
3956: RAISE fnd_api.g_exc_error;
3957: END IF; -- End of Main Source Header Tbl IF
3958: END LOOP; -- End of For Loop
3959:

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

4000: IF (l_debug > 0) THEN
4001: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Internal Order In Transit Receipt');
4002: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
4003: END IF;
4004: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4005: fnd_message.set_token('API_NAME',l_api_name);
4006: fnd_message.set_token('SQL_ERROR',SQLERRM);
4007: x_return_status := l_fnd_unexpected;
4008:

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

4001: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Internal Order In Transit Receipt');
4002: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
4003: END IF;
4004: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4005: fnd_message.set_token('API_NAME',l_api_name);
4006: fnd_message.set_token('SQL_ERROR',SQLERRM);
4007: x_return_status := l_fnd_unexpected;
4008:
4009: IF l_mtl_item_tbl.count > 0 THEN

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

4002: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
4003: END IF;
4004: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4005: fnd_message.set_token('API_NAME',l_api_name);
4006: fnd_message.set_token('SQL_ERROR',SQLERRM);
4007: x_return_status := l_fnd_unexpected;
4008:
4009: IF l_mtl_item_tbl.count > 0 THEN
4010: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

4022: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
4023: x_trx_error_rec.transaction_error_date := l_sysdate ;
4024: END IF;
4025:
4026: x_trx_error_rec.error_text := fnd_message.get;
4027: x_trx_error_rec.transaction_id := NULL;
4028: x_trx_error_rec.source_type := 'CSIINTSR';
4029: x_trx_error_rec.source_id := p_transaction_id;
4030: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

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

4618: IF (l_debug > 0) THEN
4619: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
4620: END IF;
4621:
4622: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4623: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4624: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4625: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4626: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

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

4619: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
4620: END IF;
4621:
4622: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4623: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4624: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4625: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4626: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4627: l_error_message := fnd_message.get;

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

4620: END IF;
4621:
4622: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4623: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4624: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4625: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4626: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4627: l_error_message := fnd_message.get;
4628: RAISE fnd_api.g_exc_error;

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

4621:
4622: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4623: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4624: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4625: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4626: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4627: l_error_message := fnd_message.get;
4628: RAISE fnd_api.g_exc_error;
4629: END IF; -- End of 2,5 and 2,5 IF

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

4622: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4623: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4624: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4625: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4626: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4627: l_error_message := fnd_message.get;
4628: RAISE fnd_api.g_exc_error;
4629: END IF; -- End of 2,5 and 2,5 IF
4630:

Line 4627: l_error_message := fnd_message.get;

4623: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4624: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4625: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4626: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4627: l_error_message := fnd_message.get;
4628: RAISE fnd_api.g_exc_error;
4629: END IF; -- End of 2,5 and 2,5 IF
4630:
4631: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 1 AND -- Ship

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

4733: IF (l_debug > 0) THEN
4734: csi_t_gen_utility_pvt.add('No Records were found in Install Base - 11');
4735: END IF;
4736:
4737: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4738: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4739: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4740: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4741: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);

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

4734: csi_t_gen_utility_pvt.add('No Records were found in Install Base - 11');
4735: END IF;
4736:
4737: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4738: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4739: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4740: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4741: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4742: l_error_message := fnd_message.get;

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

4735: END IF;
4736:
4737: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4738: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4739: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4740: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4741: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4742: l_error_message := fnd_message.get;
4743: RAISE fnd_api.g_exc_error;

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

4736:
4737: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4738: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4739: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4740: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4741: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4742: l_error_message := fnd_message.get;
4743: RAISE fnd_api.g_exc_error;
4744:

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

4737: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
4738: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4739: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4740: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4741: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4742: l_error_message := fnd_message.get;
4743: RAISE fnd_api.g_exc_error;
4744:
4745: END IF; -- End of Neg Qty If

Line 4742: l_error_message := fnd_message.get;

4738: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4739: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
4740: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
4741: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4742: l_error_message := fnd_message.get;
4743: RAISE fnd_api.g_exc_error;
4744:
4745: END IF; -- End of Neg Qty If
4746:

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

4818: -- Multiple Instances were found so throw error
4819: IF (l_debug > 0) THEN
4820: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-11');
4821: END IF;
4822: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4823: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4824: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4825: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4826: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

4819: IF (l_debug > 0) THEN
4820: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-11');
4821: END IF;
4822: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4823: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4824: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4825: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4826: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4827: l_error_message := fnd_message.get;

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

4820: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install BaseBase-11');
4821: END IF;
4822: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4823: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4824: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4825: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4826: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4827: l_error_message := fnd_message.get;
4828: RAISE fnd_api.g_exc_error;

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

4821: END IF;
4822: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4823: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4824: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4825: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4826: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4827: l_error_message := fnd_message.get;
4828: RAISE fnd_api.g_exc_error;
4829:

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

4822: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
4823: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4824: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4825: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4826: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4827: l_error_message := fnd_message.get;
4828: RAISE fnd_api.g_exc_error;
4829:
4830: END IF; -- End of If for Source Count

Line 4827: l_error_message := fnd_message.get;

4823: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
4824: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4825: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4826: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4827: l_error_message := fnd_message.get;
4828: RAISE fnd_api.g_exc_error;
4829:
4830: END IF; -- End of If for Source Count
4831:

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

5031: -- Multiple Instances were found so throw error
5032: IF (l_debug > 0) THEN
5033: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
5034: END IF;
5035: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5036: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5037: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5038: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5039: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

5032: IF (l_debug > 0) THEN
5033: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
5034: END IF;
5035: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5036: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5037: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5038: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5039: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5040: l_error_message := fnd_message.get;

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

5033: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
5034: END IF;
5035: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5036: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5037: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5038: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5039: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5040: l_error_message := fnd_message.get;
5041: RAISE fnd_api.g_exc_error;

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

5034: END IF;
5035: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5036: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5037: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5038: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5039: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5040: l_error_message := fnd_message.get;
5041: RAISE fnd_api.g_exc_error;
5042:

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

5035: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5036: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5037: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5038: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5039: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5040: l_error_message := fnd_message.get;
5041: RAISE fnd_api.g_exc_error;
5042:
5043: END IF; -- End of Destination Record If

Line 5040: l_error_message := fnd_message.get;

5036: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5037: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5038: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5039: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5040: l_error_message := fnd_message.get;
5041: RAISE fnd_api.g_exc_error;
5042:
5043: END IF; -- End of Destination Record If
5044:

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

5334: -- Multiple Instances were found so throw error
5335: IF (l_debug > 0) THEN
5336: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-61');
5337: END IF;
5338: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5339: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5340: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5341: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5342: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

5335: IF (l_debug > 0) THEN
5336: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-61');
5337: END IF;
5338: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5339: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5340: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5341: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5342: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5343: l_error_message := fnd_message.get;

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

5336: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-61');
5337: END IF;
5338: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5339: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5340: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5341: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5342: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5343: l_error_message := fnd_message.get;
5344: RAISE fnd_api.g_exc_error;

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

5337: END IF;
5338: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5339: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5340: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5341: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5342: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5343: l_error_message := fnd_message.get;
5344: RAISE fnd_api.g_exc_error;
5345:

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

5338: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5339: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5340: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5341: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5342: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5343: l_error_message := fnd_message.get;
5344: RAISE fnd_api.g_exc_error;
5345:
5346: END IF; -- End of Destination Record If

Line 5343: l_error_message := fnd_message.get;

5339: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5340: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5341: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5342: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5343: l_error_message := fnd_message.get;
5344: RAISE fnd_api.g_exc_error;
5345:
5346: END IF; -- End of Destination Record If
5347: END IF; -- End of J Index Loop

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

5657: IF (l_debug > 0) THEN
5658: csi_t_gen_utility_pvt.add('No Records were found in Install Base-5');
5659: END IF;
5660:
5661: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5662: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5663: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5664: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5665: l_error_message := fnd_message.get;

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

5658: csi_t_gen_utility_pvt.add('No Records were found in Install Base-5');
5659: END IF;
5660:
5661: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5662: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5663: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5664: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5665: l_error_message := fnd_message.get;
5666: RAISE fnd_api.g_exc_error;

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

5659: END IF;
5660:
5661: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5662: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5663: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5664: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5665: l_error_message := fnd_message.get;
5666: RAISE fnd_api.g_exc_error;
5667:

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

5660:
5661: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5662: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5663: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5664: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5665: l_error_message := fnd_message.get;
5666: RAISE fnd_api.g_exc_error;
5667:
5668: END IF; -- End of inv or in rel IF

Line 5665: l_error_message := fnd_message.get;

5661: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
5662: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
5663: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
5664: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
5665: l_error_message := fnd_message.get;
5666: RAISE fnd_api.g_exc_error;
5667:
5668: END IF; -- End of inv or in rel IF
5669:

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

5671: -- Multiple Instances were found so throw error
5672: IF (l_debug > 0) THEN
5673: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-62');
5674: END IF;
5675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

5672: IF (l_debug > 0) THEN
5673: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-62');
5674: END IF;
5675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5680: l_error_message := fnd_message.get;

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

5673: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-62');
5674: END IF;
5675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5680: l_error_message := fnd_message.get;
5681: RAISE fnd_api.g_exc_error;

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

5674: END IF;
5675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5680: l_error_message := fnd_message.get;
5681: RAISE fnd_api.g_exc_error;
5682:

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

5675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5680: l_error_message := fnd_message.get;
5681: RAISE fnd_api.g_exc_error;
5682:
5683: END IF; -- End of Destination Record If

Line 5680: l_error_message := fnd_message.get;

5676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
5677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
5678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
5679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
5680: l_error_message := fnd_message.get;
5681: RAISE fnd_api.g_exc_error;
5682:
5683: END IF; -- End of Destination Record If
5684:

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

5738: IF (l_debug > 0) THEN
5739: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Direct ISO Transaction');
5740: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
5741: END IF;
5742: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5743: fnd_message.set_token('API_NAME',l_api_name);
5744: fnd_message.set_token('SQL_ERROR',SQLERRM);
5745: x_return_status := l_fnd_unexpected;
5746:

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

5739: csi_t_gen_utility_pvt.add('You have encountered a "when others" exception in the Direct ISO Transaction');
5740: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
5741: END IF;
5742: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5743: fnd_message.set_token('API_NAME',l_api_name);
5744: fnd_message.set_token('SQL_ERROR',SQLERRM);
5745: x_return_status := l_fnd_unexpected;
5746:
5747: IF l_mtl_item_tbl.count > 0 THEN

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

5740: csi_t_gen_utility_pvt.add('SQL Error: '||l_sql_error);
5741: END IF;
5742: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5743: fnd_message.set_token('API_NAME',l_api_name);
5744: fnd_message.set_token('SQL_ERROR',SQLERRM);
5745: x_return_status := l_fnd_unexpected;
5746:
5747: IF l_mtl_item_tbl.count > 0 THEN
5748: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

5760: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
5761: x_trx_error_rec.transaction_error_date := l_sysdate ;
5762: END IF;
5763:
5764: x_trx_error_rec.error_text := fnd_message.get;
5765: x_trx_error_rec.transaction_id := NULL;
5766: x_trx_error_rec.source_type := 'CSIINTDS';
5767: x_trx_error_rec.source_id := p_transaction_id;
5768: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;