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);
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;
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;
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
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:
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
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;
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;
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:
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
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:
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;
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;
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:
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
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
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);
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;
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;
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
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
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:
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);
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;
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;
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
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
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:
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);
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;
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;
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:
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
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:
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:
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
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;
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;
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);
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;
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;
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:
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
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
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);
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;
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;
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:
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
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
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);
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;
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;
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
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:
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:
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;
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;
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
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:
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
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);
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;
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;
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:
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
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:
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;
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;
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
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
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:
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:
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
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;
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;
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);
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;
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;
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
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:
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
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);
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;
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;
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:
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
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:
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);
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;
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;
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:
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
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:
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);
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;
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;
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:
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
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:
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);
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;
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;
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:
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
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
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;
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;
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:
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
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:
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);
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;
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;
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:
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
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:
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:
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
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;
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;