DBA Data[Home] [Help]

APPS.CSI_INV_PROJECT_PKG dependencies on FND_MESSAGE

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

389: ELSE -- No Records were found and Neg Qtys Not Allowed
390: IF (l_debug > 0) THEN
391: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
392: END IF;
393: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
394: l_error_message := fnd_message.get;
395: RAISE fnd_api.g_exc_error;
396:
397: END IF; -- Neg Qty If

Line 394: l_error_message := fnd_message.get;

390: IF (l_debug > 0) THEN
391: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
392: END IF;
393: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
394: l_error_message := fnd_message.get;
395: RAISE fnd_api.g_exc_error;
396:
397: END IF; -- Neg Qty If
398:

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

469: -- Multiple Instances were found so throw error
470: IF (l_debug > 0) THEN
471: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
472: END IF;
473: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
474: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
475: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
476: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
477: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

470: IF (l_debug > 0) THEN
471: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
472: END IF;
473: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
474: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
475: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
476: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
477: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
478: RAISE fnd_api.g_exc_error;

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

471: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
472: END IF;
473: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
474: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
475: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
476: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
477: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
478: RAISE fnd_api.g_exc_error;
479:

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

472: END IF;
473: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
474: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
475: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
476: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
477: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
478: RAISE fnd_api.g_exc_error;
479:
480: END IF; -- End of Source Record IF

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

473: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
474: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
475: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
476: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
477: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
478: RAISE fnd_api.g_exc_error;
479:
480: END IF; -- End of Source Record IF
481:

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

671: -- Multiple Instances were found so throw error
672: IF (l_debug > 0) THEN
673: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
674: END IF;
675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

672: IF (l_debug > 0) THEN
673: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
674: END IF;
675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
680: RAISE fnd_api.g_exc_error;

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

673: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
674: END IF;
675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
680: RAISE fnd_api.g_exc_error;
681:

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

674: END IF;
675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
680: RAISE fnd_api.g_exc_error;
681:
682: END IF; -- End of Destination Non Serial IF

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

675: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
676: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
677: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
678: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
679: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
680: RAISE fnd_api.g_exc_error;
681:
682: END IF; -- End of Destination Non Serial IF
683:

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

757: ELSIF l_src_instance_header_tbl.count = 0 THEN
758: IF (l_debug > 0) THEN
759: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
760: END IF;
761: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
762: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
763: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
764: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
765: l_error_message := fnd_message.get;

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

758: IF (l_debug > 0) THEN
759: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
760: END IF;
761: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
762: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
763: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
764: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
765: l_error_message := fnd_message.get;
766: RAISE fnd_api.g_exc_error;

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

759: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
760: END IF;
761: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
762: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
763: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
764: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
765: l_error_message := fnd_message.get;
766: RAISE fnd_api.g_exc_error;
767:

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

760: END IF;
761: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
762: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
763: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
764: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
765: l_error_message := fnd_message.get;
766: RAISE fnd_api.g_exc_error;
767:
768: ELSIF l_src_instance_header_tbl.count > 1 THEN

Line 765: l_error_message := fnd_message.get;

761: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
762: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
763: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
764: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
765: l_error_message := fnd_message.get;
766: RAISE fnd_api.g_exc_error;
767:
768: ELSIF l_src_instance_header_tbl.count > 1 THEN
769: -- Multiple Instances were found so throw error

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

769: -- Multiple Instances were found so throw error
770: IF (l_debug > 0) THEN
771: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-40');
772: END IF;
773: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
774: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
775: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
776: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
777: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

770: IF (l_debug > 0) THEN
771: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-40');
772: END IF;
773: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
774: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
775: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
776: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
777: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
778: RAISE fnd_api.g_exc_error;

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

771: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-40');
772: END IF;
773: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
774: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
775: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
776: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
777: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
778: RAISE fnd_api.g_exc_error;
779: END IF; -- End of Source Record IF for Serialized

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

772: END IF;
773: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
774: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
775: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
776: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
777: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
778: RAISE fnd_api.g_exc_error;
779: END IF; -- End of Source Record IF for Serialized
780:

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

773: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
774: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
775: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
776: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
777: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
778: RAISE fnd_api.g_exc_error;
779: END IF; -- End of Source Record IF for Serialized
780:
781: END IF; -- End of Serial Number If

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

817: WHEN others THEN
818: IF (l_debug > 0) THEN
819: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
820: END IF;
821: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
822: fnd_message.set_token('API_NAME',l_api_name);
823: fnd_message.set_token('SQL_ERROR',SQLERRM);
824: x_return_status := l_fnd_unexpected;
825:

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

818: IF (l_debug > 0) THEN
819: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
820: END IF;
821: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
822: fnd_message.set_token('API_NAME',l_api_name);
823: fnd_message.set_token('SQL_ERROR',SQLERRM);
824: x_return_status := l_fnd_unexpected;
825:
826: IF l_mtl_item_tbl.count > 0 THEN

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

819: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
820: END IF;
821: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
822: fnd_message.set_token('API_NAME',l_api_name);
823: fnd_message.set_token('SQL_ERROR',SQLERRM);
824: x_return_status := l_fnd_unexpected;
825:
826: IF l_mtl_item_tbl.count > 0 THEN
827: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

835: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
836: x_trx_error_rec.transaction_error_date := l_sysdate ;
837: END IF;
838:
839: x_trx_error_rec.error_text := fnd_message.get;
840: x_trx_error_rec.transaction_id := NULL;
841: x_trx_error_rec.source_type := 'CSIISUPT';
842: x_trx_error_rec.source_id := p_transaction_id;
843: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

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

1253: IF (l_debug > 0) THEN
1254: 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');
1255: csi_t_gen_utility_pvt.add('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1256: END IF;
1257: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1258: fnd_message.set_token('STATUS',l_status);
1259: l_error_message := fnd_message.get;
1260: l_return_status := l_fnd_error;
1261: RAISE fnd_api.g_exc_error;

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

1254: 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');
1255: csi_t_gen_utility_pvt.add('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1256: END IF;
1257: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1258: fnd_message.set_token('STATUS',l_status);
1259: l_error_message := fnd_message.get;
1260: l_return_status := l_fnd_error;
1261: RAISE fnd_api.g_exc_error;
1262: END IF;

Line 1259: l_error_message := fnd_message.get;

1255: csi_t_gen_utility_pvt.add('Instance Usage Code is: '||l_src_instance_header_tbl(i).instance_usage_code);
1256: END IF;
1257: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1258: fnd_message.set_token('STATUS',l_status);
1259: l_error_message := fnd_message.get;
1260: l_return_status := l_fnd_error;
1261: RAISE fnd_api.g_exc_error;
1262: END IF;
1263:

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

1334: -- Bug 4378656 - If the instance is not there then we still need to create one that is In Inventory.
1335: -- IF (l_debug > 0) THEN
1336: -- csi_t_gen_utility_pvt.add('No Records were found in Install Base');
1337: -- END IF;
1338: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1339: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1340: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1341: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1342: -- l_error_message := fnd_message.get;

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

1335: -- IF (l_debug > 0) THEN
1336: -- csi_t_gen_utility_pvt.add('No Records were found in Install Base');
1337: -- END IF;
1338: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1339: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1340: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1341: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1342: -- l_error_message := fnd_message.get;
1343: -- RAISE fnd_api.g_exc_error;

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

1336: -- csi_t_gen_utility_pvt.add('No Records were found in Install Base');
1337: -- END IF;
1338: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1339: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1340: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1341: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1342: -- l_error_message := fnd_message.get;
1343: -- RAISE fnd_api.g_exc_error;
1344:

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

1337: -- END IF;
1338: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1339: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1340: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1341: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1342: -- l_error_message := fnd_message.get;
1343: -- RAISE fnd_api.g_exc_error;
1344:
1345: ELSIF l_src_instance_header_tbl.count > 1 THEN

Line 1342: -- l_error_message := fnd_message.get;

1338: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1339: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1340: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1341: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1342: -- l_error_message := fnd_message.get;
1343: -- RAISE fnd_api.g_exc_error;
1344:
1345: ELSIF l_src_instance_header_tbl.count > 1 THEN
1346: -- Multiple Instances were found so throw error

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

1346: -- Multiple Instances were found so throw error
1347: IF (l_debug > 0) THEN
1348: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-55');
1349: END IF;
1350: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1351: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1352: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1353: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1354: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1347: IF (l_debug > 0) THEN
1348: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-55');
1349: END IF;
1350: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1351: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1352: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1353: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1354: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1355: RAISE fnd_api.g_exc_error;

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

1348: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-55');
1349: END IF;
1350: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1351: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1352: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1353: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1354: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1355: RAISE fnd_api.g_exc_error;
1356: END IF; -- No Records Found

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

1349: END IF;
1350: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1351: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1352: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1353: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1354: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1355: RAISE fnd_api.g_exc_error;
1356: END IF; -- No Records Found
1357:

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

1350: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1351: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1352: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1353: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1354: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1355: RAISE fnd_api.g_exc_error;
1356: END IF; -- No Records Found
1357:
1358: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized

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

1656: -- Multiple Instances were found so throw error
1657: IF (l_debug > 0) THEN
1658: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-50');
1659: END IF;
1660: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1661: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1662: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1663: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1664: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1657: IF (l_debug > 0) THEN
1658: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-50');
1659: END IF;
1660: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1661: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1662: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1663: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1664: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1665: RAISE fnd_api.g_exc_error;

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

1658: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-50');
1659: END IF;
1660: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1661: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1662: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1663: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1664: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1665: RAISE fnd_api.g_exc_error;
1666:

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

1659: END IF;
1660: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1661: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1662: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1663: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1664: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1665: RAISE fnd_api.g_exc_error;
1666:
1667: END IF; -- End of Destination Record If

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

1660: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1661: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1662: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1663: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1664: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1665: RAISE fnd_api.g_exc_error;
1666:
1667: END IF; -- End of Destination Record If
1668:

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

1864: -- Multiple Instances were found so throw error
1865: IF (l_debug > 0) THEN
1866: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base so error-90');
1867: END IF;
1868: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1869: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1870: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1871: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1872: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1865: IF (l_debug > 0) THEN
1866: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base so error-90');
1867: END IF;
1868: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1869: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1870: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1871: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1872: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1873: RAISE fnd_api.g_exc_error;

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

1866: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base so error-90');
1867: END IF;
1868: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1869: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1870: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1871: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1872: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1873: RAISE fnd_api.g_exc_error;
1874:

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

1867: END IF;
1868: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1869: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1870: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1871: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1872: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1873: RAISE fnd_api.g_exc_error;
1874:
1875: END IF; -- End of Destination Record If for checking for In Inventory Records because the Project/Source Instance was not there.

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

1868: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1869: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1870: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1871: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1872: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1873: RAISE fnd_api.g_exc_error;
1874:
1875: END IF; -- End of Destination Record If for checking for In Inventory Records because the Project/Source Instance was not there.
1876:

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

1877: -- Bug 4378656 - If the instance is not there then we still need to create one that is In Inventory.
1878: -- IF (l_debug > 0) THEN
1879: -- csi_t_gen_utility_pvt.add('No Records were found in Install Base');
1880: -- END IF;
1881: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1882: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1883: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1884: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1885: -- l_error_message := fnd_message.get;

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

1878: -- IF (l_debug > 0) THEN
1879: -- csi_t_gen_utility_pvt.add('No Records were found in Install Base');
1880: -- END IF;
1881: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1882: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1883: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1884: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1885: -- l_error_message := fnd_message.get;
1886: -- RAISE fnd_api.g_exc_error;

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

1879: -- csi_t_gen_utility_pvt.add('No Records were found in Install Base');
1880: -- END IF;
1881: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1882: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1883: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1884: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1885: -- l_error_message := fnd_message.get;
1886: -- RAISE fnd_api.g_exc_error;
1887:

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

1880: -- END IF;
1881: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1882: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1883: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1884: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1885: -- l_error_message := fnd_message.get;
1886: -- RAISE fnd_api.g_exc_error;
1887:
1888: ELSIF l_src_instance_header_tbl.count > 1 THEN

Line 1885: -- l_error_message := fnd_message.get;

1881: -- fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
1882: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1883: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1884: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1885: -- l_error_message := fnd_message.get;
1886: -- RAISE fnd_api.g_exc_error;
1887:
1888: ELSIF l_src_instance_header_tbl.count > 1 THEN
1889: -- Multiple Instances were found so throw error

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

1889: -- Multiple Instances were found so throw error
1890: IF (l_debug > 0) THEN
1891: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-75');
1892: END IF;
1893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

1890: IF (l_debug > 0) THEN
1891: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-75');
1892: END IF;
1893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1898: RAISE fnd_api.g_exc_error;

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

1891: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-75');
1892: END IF;
1893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1898: RAISE fnd_api.g_exc_error;
1899:

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

1892: END IF;
1893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1898: RAISE fnd_api.g_exc_error;
1899:
1900: END IF; -- End of No Records Found If

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

1893: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1894: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1895: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1896: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1897: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1898: RAISE fnd_api.g_exc_error;
1899:
1900: END IF; -- End of No Records Found If
1901: END IF; -- End of Serial Number If

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

1937: WHEN others THEN
1938: IF (l_debug > 0) THEN
1939: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
1940: END IF;
1941: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1942: fnd_message.set_token('API_NAME',l_api_name);
1943: fnd_message.set_token('SQL_ERROR',SQLERRM);
1944: x_return_status := l_fnd_unexpected;
1945:

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

1938: IF (l_debug > 0) THEN
1939: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
1940: END IF;
1941: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1942: fnd_message.set_token('API_NAME',l_api_name);
1943: fnd_message.set_token('SQL_ERROR',SQLERRM);
1944: x_return_status := l_fnd_unexpected;
1945:
1946: IF l_mtl_item_tbl.count > 0 THEN

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

1939: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
1940: END IF;
1941: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1942: fnd_message.set_token('API_NAME',l_api_name);
1943: fnd_message.set_token('SQL_ERROR',SQLERRM);
1944: x_return_status := l_fnd_unexpected;
1945:
1946: IF l_mtl_item_tbl.count > 0 THEN
1947: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

1955: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
1956: x_trx_error_rec.transaction_error_date := l_sysdate ;
1957: END IF;
1958:
1959: x_trx_error_rec.error_text := fnd_message.get;
1960: x_trx_error_rec.transaction_id := NULL;
1961: x_trx_error_rec.source_type := 'CSIMSRPT';
1962: x_trx_error_rec.source_id := p_transaction_id;
1963: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

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

2352: ELSE -- No Records were found and Neg Qtys Not Allowed
2353: IF (l_debug > 0) THEN
2354: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
2355: END IF;
2356: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2357: l_error_message := fnd_message.get;
2358: RAISE fnd_api.g_exc_error;
2359:
2360: END IF; -- Neg Qty If

Line 2357: l_error_message := fnd_message.get;

2353: IF (l_debug > 0) THEN
2354: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
2355: END IF;
2356: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2357: l_error_message := fnd_message.get;
2358: RAISE fnd_api.g_exc_error;
2359:
2360: END IF; -- Neg Qty If
2361:

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

2432: -- Multiple Instances were found so throw error
2433: IF (l_debug > 0) THEN
2434: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2435: END IF;
2436: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2437: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2438: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2439: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2440: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2433: IF (l_debug > 0) THEN
2434: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2435: END IF;
2436: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2437: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2438: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2439: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2440: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2441: RAISE fnd_api.g_exc_error;

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

2434: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-30');
2435: END IF;
2436: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2437: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2438: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2439: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2440: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2441: RAISE fnd_api.g_exc_error;
2442:

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

2435: END IF;
2436: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2437: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2438: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2439: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2440: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2441: RAISE fnd_api.g_exc_error;
2442:
2443: END IF; -- End of Source Record If

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

2436: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2437: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2438: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2439: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2440: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2441: RAISE fnd_api.g_exc_error;
2442:
2443: END IF; -- End of Source Record If
2444:

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

2639: -- Multiple Instances were found so throw error
2640: IF (l_debug > 0) THEN
2641: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
2642: END IF;
2643: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2644: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2645: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2646: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2647: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2640: IF (l_debug > 0) THEN
2641: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
2642: END IF;
2643: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2644: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2645: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2646: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2647: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2648: RAISE fnd_api.g_exc_error;

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

2641: csi_t_gen_utility_pvt.add('Multiple Instances were Found in Install Base-60');
2642: END IF;
2643: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2644: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2645: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2646: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2647: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2648: RAISE fnd_api.g_exc_error;
2649:

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

2642: END IF;
2643: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2644: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2645: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2646: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2647: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2648: RAISE fnd_api.g_exc_error;
2649:
2650: END IF; -- End of Destination Record If

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

2643: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2644: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2645: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2646: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2647: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2648: RAISE fnd_api.g_exc_error;
2649:
2650: END IF; -- End of Destination Record If
2651:

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

2720: ELSIF l_src_instance_header_tbl.count = 0 THEN
2721: IF (l_debug > 0) THEN
2722: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
2723: END IF;
2724: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2725: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2726: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2727: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2728: l_error_message := fnd_message.get;

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

2721: IF (l_debug > 0) THEN
2722: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
2723: END IF;
2724: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2725: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2726: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2727: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2728: l_error_message := fnd_message.get;
2729: RAISE fnd_api.g_exc_error;

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

2722: csi_t_gen_utility_pvt.add('No Records were found in Install Base');
2723: END IF;
2724: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2725: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2726: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2727: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2728: l_error_message := fnd_message.get;
2729: RAISE fnd_api.g_exc_error;
2730:

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

2723: END IF;
2724: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2725: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2726: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2727: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2728: l_error_message := fnd_message.get;
2729: RAISE fnd_api.g_exc_error;
2730:
2731: ELSIF l_src_instance_header_tbl.count > 1 THEN

Line 2728: l_error_message := fnd_message.get;

2724: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');
2725: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2726: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2727: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2728: l_error_message := fnd_message.get;
2729: RAISE fnd_api.g_exc_error;
2730:
2731: ELSIF l_src_instance_header_tbl.count > 1 THEN
2732: -- Multiple Instances were found so throw error

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

2732: -- Multiple Instances were found so throw error
2733: IF (l_debug > 0) THEN
2734: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-65');
2735: END IF;
2736: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2737: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2738: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2739: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2740: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);

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

2733: IF (l_debug > 0) THEN
2734: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-65');
2735: END IF;
2736: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2737: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2738: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2739: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2740: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2741: RAISE fnd_api.g_exc_error;

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

2734: csi_t_gen_utility_pvt.add('Multiple Instances were Found in InstallBase-65');
2735: END IF;
2736: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2737: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2738: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2739: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2740: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2741: RAISE fnd_api.g_exc_error;
2742: END IF; -- End of Source Record IF for Serialized

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

2735: END IF;
2736: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2737: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2738: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2739: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2740: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2741: RAISE fnd_api.g_exc_error;
2742: END IF; -- End of Source Record IF for Serialized
2743: END IF; -- End of Serial Number If

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

2736: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
2737: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2738: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2739: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2740: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2741: RAISE fnd_api.g_exc_error;
2742: END IF; -- End of Source Record IF for Serialized
2743: END IF; -- End of Serial Number If
2744: END LOOP; -- End of For Loop

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

2779: WHEN others THEN
2780: IF (l_debug > 0) THEN
2781: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
2782: END IF;
2783: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2784: fnd_message.set_token('API_NAME',l_api_name);
2785: fnd_message.set_token('SQL_ERROR',SQLERRM);
2786: x_return_status := l_fnd_unexpected;
2787:

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

2780: IF (l_debug > 0) THEN
2781: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
2782: END IF;
2783: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2784: fnd_message.set_token('API_NAME',l_api_name);
2785: fnd_message.set_token('SQL_ERROR',SQLERRM);
2786: x_return_status := l_fnd_unexpected;
2787:
2788: IF l_mtl_item_tbl.count > 0 THEN

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

2781: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');
2782: END IF;
2783: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
2784: fnd_message.set_token('API_NAME',l_api_name);
2785: fnd_message.set_token('SQL_ERROR',SQLERRM);
2786: x_return_status := l_fnd_unexpected;
2787:
2788: IF l_mtl_item_tbl.count > 0 THEN
2789: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

2797: x_trx_error_rec.comms_nl_trackable_flag := l_mtl_item_tbl(j).comms_nl_trackable_flag;
2798: x_trx_error_rec.transaction_error_date := l_sysdate ;
2799: END IF;
2800:
2801: x_trx_error_rec.error_text := fnd_message.get;
2802: x_trx_error_rec.transaction_id := NULL;
2803: x_trx_error_rec.source_type := 'CSIMSIPT';
2804: x_trx_error_rec.source_id := p_transaction_id;
2805: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;