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

APPS.CSI_INV_HZ_PKG dependencies on FND_MESSAGE

Line 405: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');

401: ELSE -- No Records were found and Neg Qtys Not Allowed
402: IF (l_debug > 0) THEN
403: csi_t_gen_utility_pvt.add('No Records were found in Install Base and Neg Qtys not allowed to error');
404: END IF;
405: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
406: l_error_message := fnd_message.get;
407: RAISE fnd_api.g_exc_error;
408:
409: END IF; -- End of Source Record If

Line 406: l_error_message := fnd_message.get;

402: IF (l_debug > 0) THEN
403: csi_t_gen_utility_pvt.add('No Records were found in Install Base and Neg Qtys not allowed to error');
404: END IF;
405: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
406: l_error_message := fnd_message.get;
407: RAISE fnd_api.g_exc_error;
408:
409: END IF; -- End of Source Record If
410:

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

480: -- Multiple Instances were found so throw error
481: IF (l_debug > 0) THEN
482: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
483: END IF;
484: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
485: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

481: IF (l_debug > 0) THEN
482: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
483: END IF;
484: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
485: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
489: l_error_message := fnd_message.get;

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

482: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
483: END IF;
484: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
485: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
489: l_error_message := fnd_message.get;
490: RAISE fnd_api.g_exc_error;

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

483: END IF;
484: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
485: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
489: l_error_message := fnd_message.get;
490: RAISE fnd_api.g_exc_error;
491:

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

484: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
485: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
489: l_error_message := fnd_message.get;
490: RAISE fnd_api.g_exc_error;
491:
492: END IF; -- End of Source Record IF

Line 489: l_error_message := fnd_message.get;

485: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
489: l_error_message := fnd_message.get;
490: RAISE fnd_api.g_exc_error;
491:
492: END IF; -- End of Source Record IF
493:

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

688: -- Multiple Instances were found so throw error
689: IF (l_debug > 0) THEN
690: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
691: END IF;
692: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
693: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
694: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
695: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
696: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

689: IF (l_debug > 0) THEN
690: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
691: END IF;
692: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
693: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
694: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
695: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
696: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
697: l_error_message := fnd_message.get;

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

690: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
691: END IF;
692: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
693: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
694: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
695: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
696: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
697: l_error_message := fnd_message.get;
698: RAISE fnd_api.g_exc_error;

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

691: END IF;
692: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
693: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
694: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
695: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
696: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
697: l_error_message := fnd_message.get;
698: RAISE fnd_api.g_exc_error;
699: END IF; -- End of Destination Record If

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

692: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
693: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
694: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
695: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
696: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
697: l_error_message := fnd_message.get;
698: RAISE fnd_api.g_exc_error;
699: END IF; -- End of Destination Record If
700:

Line 697: l_error_message := fnd_message.get;

693: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
694: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
695: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
696: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
697: l_error_message := fnd_message.get;
698: RAISE fnd_api.g_exc_error;
699: END IF; -- End of Destination Record If
700:
701: ELSIF l_mtl_item_tbl(j).serial_number is NOT NULL THEN

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

778: ELSIF l_src_instance_header_tbl.count = 0 THEN -- Serialized Item
779: IF (l_debug > 0) THEN
780: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
781: END IF;
782: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
783: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
784: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
785: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
786: l_error_message := fnd_message.get;

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

779: IF (l_debug > 0) THEN
780: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
781: END IF;
782: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
783: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
784: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
785: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
786: l_error_message := fnd_message.get;
787: RAISE fnd_api.g_exc_error;

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

780: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
781: END IF;
782: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
783: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
784: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
785: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
786: l_error_message := fnd_message.get;
787: RAISE fnd_api.g_exc_error;
788:

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

781: END IF;
782: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
783: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
784: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
785: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
786: l_error_message := fnd_message.get;
787: RAISE fnd_api.g_exc_error;
788:
789: ELSIF l_src_instance_header_tbl.count > 1 THEN -- Serialized Item

Line 786: l_error_message := fnd_message.get;

782: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
783: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
784: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
785: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
786: l_error_message := fnd_message.get;
787: RAISE fnd_api.g_exc_error;
788:
789: ELSIF l_src_instance_header_tbl.count > 1 THEN -- Serialized Item
790:

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

791: -- Multiple Instances were found so throw error
792: IF (l_debug > 0) THEN
793: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-56');
794: END IF;
795: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
796: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
797: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
798: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
799: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

792: IF (l_debug > 0) THEN
793: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-56');
794: END IF;
795: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
796: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
797: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
798: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
799: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
800: l_error_message := fnd_message.get;

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

793: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-56');
794: END IF;
795: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
796: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
797: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
798: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
799: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
800: l_error_message := fnd_message.get;
801: RAISE fnd_api.g_exc_error;

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

794: END IF;
795: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
796: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
797: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
798: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
799: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
800: l_error_message := fnd_message.get;
801: RAISE fnd_api.g_exc_error;
802:

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

795: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
796: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
797: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
798: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
799: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
800: l_error_message := fnd_message.get;
801: RAISE fnd_api.g_exc_error;
802:
803: END IF; -- End of Serial Number If

Line 800: l_error_message := fnd_message.get;

796: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
797: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
798: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
799: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
800: l_error_message := fnd_message.get;
801: RAISE fnd_api.g_exc_error;
802:
803: END IF; -- End of Serial Number If
804: END IF; -- End of Serial Number count IF

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

841: WHEN others THEN
842: IF (l_debug > 0) THEN
843: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
844: END IF;
845: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
846: fnd_message.set_token('API_NAME',l_api_name);
847: fnd_message.set_token('SQL_ERROR',SQLERRM);
848: x_return_status := l_fnd_unexpected;
849:

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

842: IF (l_debug > 0) THEN
843: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
844: END IF;
845: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
846: fnd_message.set_token('API_NAME',l_api_name);
847: fnd_message.set_token('SQL_ERROR',SQLERRM);
848: x_return_status := l_fnd_unexpected;
849:
850: IF l_mtl_item_tbl.count > 0 THEN

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

843: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
844: END IF;
845: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
846: fnd_message.set_token('API_NAME',l_api_name);
847: fnd_message.set_token('SQL_ERROR',SQLERRM);
848: x_return_status := l_fnd_unexpected;
849:
850: IF l_mtl_item_tbl.count > 0 THEN
851: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

859: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
860: x_trx_error_rec.transaction_error_date := l_sysdate ;
861: END IF;
862:
863: x_trx_error_rec.error_text := fnd_message.get;
864: x_trx_error_rec.transaction_id := NULL;
865: x_trx_error_rec.source_type := 'CSIISUHZ';
866: x_trx_error_rec.source_id := p_transaction_id;
867: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 1346: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');

1342: IF (l_debug > 0) THEN
1343: csi_t_gen_utility_pvt.add('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
1344: csi_t_gen_utility_pvt.add('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1345: END IF;
1346: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1347: fnd_message.set_token('STATUS',l_status);
1348: l_error_message := fnd_message.get;
1349: l_return_status := l_fnd_error;
1350: RAISE fnd_api.g_exc_error;

Line 1347: fnd_message.set_token('STATUS',l_status);

1343: csi_t_gen_utility_pvt.add('Serialized Item with Status other then Out Of Service, In Inventory, Installed, or In Process already exists in Install Base');
1344: csi_t_gen_utility_pvt.add('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1345: END IF;
1346: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1347: fnd_message.set_token('STATUS',l_status);
1348: l_error_message := fnd_message.get;
1349: l_return_status := l_fnd_error;
1350: RAISE fnd_api.g_exc_error;
1351: END IF;

Line 1348: l_error_message := fnd_message.get;

1344: csi_t_gen_utility_pvt.add('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1345: END IF;
1346: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1347: fnd_message.set_token('STATUS',l_status);
1348: l_error_message := fnd_message.get;
1349: l_return_status := l_fnd_error;
1350: RAISE fnd_api.g_exc_error;
1351: END IF;
1352:

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

1423: -- Multiple Instances were found so throw error
1424: IF (l_debug > 0) THEN
1425: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1426: END IF;
1427: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1428: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1429: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1430: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1431: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1424: IF (l_debug > 0) THEN
1425: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1426: END IF;
1427: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1428: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1429: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1430: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1431: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1432: l_error_message := fnd_message.get;

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

1425: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1426: END IF;
1427: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1428: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1429: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1430: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1431: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1432: l_error_message := fnd_message.get;
1433: RAISE fnd_api.g_exc_error;

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

1426: END IF;
1427: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1428: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1429: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1430: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1431: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1432: l_error_message := fnd_message.get;
1433: RAISE fnd_api.g_exc_error;
1434: END IF; -- Serialized Source IF

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

1427: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1428: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1429: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1430: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1431: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1432: l_error_message := fnd_message.get;
1433: RAISE fnd_api.g_exc_error;
1434: END IF; -- Serialized Source IF
1435:

Line 1432: l_error_message := fnd_message.get;

1428: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1429: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1430: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1431: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1432: l_error_message := fnd_message.get;
1433: RAISE fnd_api.g_exc_error;
1434: END IF; -- Serialized Source IF
1435:
1436: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized

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

1973: -- Multiple Instances were found so throw error
1974: IF (l_debug > 0) THEN
1975: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1976: END IF;
1977: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1978: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1979: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1980: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1981: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1974: IF (l_debug > 0) THEN
1975: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1976: END IF;
1977: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1978: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1979: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1980: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1981: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1982: l_error_message := fnd_message.get;

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

1975: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1976: END IF;
1977: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1978: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1979: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1980: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1981: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1982: l_error_message := fnd_message.get;
1983: RAISE fnd_api.g_exc_error;

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

1976: END IF;
1977: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1978: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1979: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1980: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1981: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1982: l_error_message := fnd_message.get;
1983: RAISE fnd_api.g_exc_error;
1984:

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

1977: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1978: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1979: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1980: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1981: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1982: l_error_message := fnd_message.get;
1983: RAISE fnd_api.g_exc_error;
1984:
1985: END IF; -- End of Destination Record If

Line 1982: l_error_message := fnd_message.get;

1978: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1979: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1980: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1981: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1982: l_error_message := fnd_message.get;
1983: RAISE fnd_api.g_exc_error;
1984:
1985: END IF; -- End of Destination Record If
1986: /***

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

1988: -- Multiple Instances were found so throw error
1989: IF (l_debug > 0) THEN
1990: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1991: END IF;
1992: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1993: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1989: IF (l_debug > 0) THEN
1990: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1991: END IF;
1992: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1993: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1997: l_error_message := fnd_message.get;

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

1990: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
1991: END IF;
1992: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1993: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1997: l_error_message := fnd_message.get;
1998: RAISE fnd_api.g_exc_error;

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

1991: END IF;
1992: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1993: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1997: l_error_message := fnd_message.get;
1998: RAISE fnd_api.g_exc_error;
1999: ***/

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

1992: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1993: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1997: l_error_message := fnd_message.get;
1998: RAISE fnd_api.g_exc_error;
1999: ***/
2000: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found

Line 1997: l_error_message := fnd_message.get;

1993: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1997: l_error_message := fnd_message.get;
1998: RAISE fnd_api.g_exc_error;
1999: ***/
2000: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
2001:

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

2188: -- Multiple Instances were found so throw error
2189: IF (l_debug > 0) THEN
2190: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2191: END IF;
2192: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2193: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2194: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2195: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2196: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2189: IF (l_debug > 0) THEN
2190: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2191: END IF;
2192: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2193: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2194: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2195: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2196: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2197: l_error_message := fnd_message.get;

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

2190: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2191: END IF;
2192: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2193: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2194: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2195: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2196: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2197: l_error_message := fnd_message.get;
2198: RAISE fnd_api.g_exc_error;

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

2191: END IF;
2192: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2193: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2194: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2195: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2196: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2197: l_error_message := fnd_message.get;
2198: RAISE fnd_api.g_exc_error;
2199:

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

2192: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2193: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2194: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2195: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2196: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2197: l_error_message := fnd_message.get;
2198: RAISE fnd_api.g_exc_error;
2199:
2200: END IF; -- End of Destination Record If for checking for In Inventory Records because the Project/Source Instance was not there.

Line 2197: l_error_message := fnd_message.get;

2193: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2194: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2195: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2196: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2197: l_error_message := fnd_message.get;
2198: RAISE fnd_api.g_exc_error;
2199:
2200: END IF; -- End of Destination Record If for checking for In Inventory Records because the Project/Source Instance was not there.
2201: END IF; -- End of No Records Found If

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

2239: WHEN others THEN
2240: IF (l_debug > 0) THEN
2241: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
2242: END IF;
2243: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2244: fnd_message.set_token('API_NAME',l_api_name);
2245: fnd_message.set_token('SQL_ERROR',SQLERRM);
2246: x_return_status := l_fnd_unexpected;
2247:

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

2240: IF (l_debug > 0) THEN
2241: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
2242: END IF;
2243: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2244: fnd_message.set_token('API_NAME',l_api_name);
2245: fnd_message.set_token('SQL_ERROR',SQLERRM);
2246: x_return_status := l_fnd_unexpected;
2247:
2248: IF l_mtl_item_tbl.count > 0 THEN

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

2241: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
2242: END IF;
2243: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2244: fnd_message.set_token('API_NAME',l_api_name);
2245: fnd_message.set_token('SQL_ERROR',SQLERRM);
2246: x_return_status := l_fnd_unexpected;
2247:
2248: IF l_mtl_item_tbl.count > 0 THEN
2249: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

2257: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
2258: x_trx_error_rec.transaction_error_date := l_sysdate ;
2259: END IF;
2260:
2261: x_trx_error_rec.error_text := fnd_message.get;
2262: x_trx_error_rec.transaction_id := NULL;
2263: x_trx_error_rec.source_type := 'CSIMSRHZ';
2264: x_trx_error_rec.source_id := p_transaction_id;
2265: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 2665: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');

2661: ELSE -- No Records were found and Neg Qtys Not Allowed
2662: IF (l_debug > 0) THEN
2663: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
2664: END IF;
2665: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2666: l_error_message := fnd_message.get;
2667: RAISE fnd_api.g_exc_error;
2668:
2669: END IF; -- Neg Qty IF

Line 2666: l_error_message := fnd_message.get;

2662: IF (l_debug > 0) THEN
2663: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
2664: END IF;
2665: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2666: l_error_message := fnd_message.get;
2667: RAISE fnd_api.g_exc_error;
2668:
2669: END IF; -- Neg Qty IF
2670:

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

2738: -- Multiple Instances were found so throw error
2739: IF (l_debug > 0) THEN
2740: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2741: END IF;
2742: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2743: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2739: IF (l_debug > 0) THEN
2740: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2741: END IF;
2742: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2743: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2747: l_error_message := fnd_message.get;

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

2740: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2741: END IF;
2742: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2743: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2747: l_error_message := fnd_message.get;
2748: RAISE fnd_api.g_exc_error;

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

2741: END IF;
2742: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2743: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2747: l_error_message := fnd_message.get;
2748: RAISE fnd_api.g_exc_error;
2749:

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

2742: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2743: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2747: l_error_message := fnd_message.get;
2748: RAISE fnd_api.g_exc_error;
2749:
2750: END IF; -- End of Source Record If

Line 2747: l_error_message := fnd_message.get;

2743: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2747: l_error_message := fnd_message.get;
2748: RAISE fnd_api.g_exc_error;
2749:
2750: END IF; -- End of Source Record If
2751:

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

2951: -- Multiple Instances were found so throw error
2952: IF (l_debug > 0) THEN
2953: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-90');
2954: END IF;
2955: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2956: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2952: IF (l_debug > 0) THEN
2953: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-90');
2954: END IF;
2955: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2956: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2960: l_error_message := fnd_message.get;

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

2953: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-90');
2954: END IF;
2955: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2956: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2960: l_error_message := fnd_message.get;
2961: RAISE fnd_api.g_exc_error;

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

2954: END IF;
2955: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2956: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2960: l_error_message := fnd_message.get;
2961: RAISE fnd_api.g_exc_error;
2962:

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

2955: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2956: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2960: l_error_message := fnd_message.get;
2961: RAISE fnd_api.g_exc_error;
2962:
2963: END IF; -- End of Destination Record If

Line 2960: l_error_message := fnd_message.get;

2956: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2960: l_error_message := fnd_message.get;
2961: RAISE fnd_api.g_exc_error;
2962:
2963: END IF; -- End of Destination Record If
2964:

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

3036: ELSIF l_src_instance_header_tbl.count = 0 THEN
3037: IF (l_debug > 0) THEN
3038: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
3039: END IF;
3040: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3041: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3042: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3043: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3044: l_error_message := fnd_message.get;

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

3037: IF (l_debug > 0) THEN
3038: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
3039: END IF;
3040: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3041: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3042: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3043: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3044: l_error_message := fnd_message.get;
3045: RAISE fnd_api.g_exc_error;

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

3038: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
3039: END IF;
3040: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3041: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3042: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3043: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3044: l_error_message := fnd_message.get;
3045: RAISE fnd_api.g_exc_error;
3046:

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

3039: END IF;
3040: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3041: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3042: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3043: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3044: l_error_message := fnd_message.get;
3045: RAISE fnd_api.g_exc_error;
3046:
3047: ELSIF l_src_instance_header_tbl.count > 1 THEN

Line 3044: l_error_message := fnd_message.get;

3040: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
3041: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3042: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3043: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3044: l_error_message := fnd_message.get;
3045: RAISE fnd_api.g_exc_error;
3046:
3047: ELSIF l_src_instance_header_tbl.count > 1 THEN
3048: -- Multiple Instances were found so throw error

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

3048: -- Multiple Instances were found so throw error
3049: IF (l_debug > 0) THEN
3050: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-65');
3051: END IF;
3052: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3053: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3054: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3055: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3056: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

3049: IF (l_debug > 0) THEN
3050: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-65');
3051: END IF;
3052: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3053: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3054: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3055: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3056: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3057: l_error_message := fnd_message.get;

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

3050: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-65');
3051: END IF;
3052: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3053: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3054: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3055: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3056: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3057: l_error_message := fnd_message.get;
3058: RAISE fnd_api.g_exc_error;

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

3051: END IF;
3052: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3053: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3054: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3055: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3056: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3057: l_error_message := fnd_message.get;
3058: RAISE fnd_api.g_exc_error;
3059:

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

3052: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
3053: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3054: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3055: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3056: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3057: l_error_message := fnd_message.get;
3058: RAISE fnd_api.g_exc_error;
3059:
3060: END IF; -- End of Source Record IF for Serialized

Line 3057: l_error_message := fnd_message.get;

3053: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
3054: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3055: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3056: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3057: l_error_message := fnd_message.get;
3058: RAISE fnd_api.g_exc_error;
3059:
3060: END IF; -- End of Source Record IF for Serialized
3061: END IF; -- End of Source Record If

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

3098: WHEN others THEN
3099: IF (l_debug > 0) THEN
3100: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
3101: END IF;
3102: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3103: fnd_message.set_token('API_NAME',l_api_name);
3104: fnd_message.set_token('SQL_ERROR',SQLERRM);
3105: x_return_status := l_fnd_unexpected;
3106:

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

3099: IF (l_debug > 0) THEN
3100: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
3101: END IF;
3102: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3103: fnd_message.set_token('API_NAME',l_api_name);
3104: fnd_message.set_token('SQL_ERROR',SQLERRM);
3105: x_return_status := l_fnd_unexpected;
3106:
3107: IF l_mtl_item_tbl.count > 0 THEN

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

3100: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
3101: END IF;
3102: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
3103: fnd_message.set_token('API_NAME',l_api_name);
3104: fnd_message.set_token('SQL_ERROR',SQLERRM);
3105: x_return_status := l_fnd_unexpected;
3106:
3107: IF l_mtl_item_tbl.count > 0 THEN
3108: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

3116: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
3117: x_trx_error_rec.transaction_error_date := l_sysdate ;
3118: END IF;
3119:
3120: x_trx_error_rec.error_text := fnd_message.get;
3121: x_trx_error_rec.transaction_id := NULL;
3122: x_trx_error_rec.source_type := 'CSIMSIHZ';
3123: x_trx_error_rec.source_id := p_transaction_id;
3124: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;