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_PROJECT_PKG dependencies on FND_API

Line 15: l_commit VARCHAR2(1) := FND_API.G_FALSE;

11:
12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
13: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.ISSUE_TO_PROJECT';
14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

Line 16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
13: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.ISSUE_TO_PROJECT';
14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
20: l_transaction_id NUMBER := NULL;

Line 17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

13: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.ISSUE_TO_PROJECT';
14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
20: l_transaction_id NUMBER := NULL;
21: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

Line 18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;

14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
20: l_transaction_id NUMBER := NULL;
21: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
22: l_object_version_number NUMBER := 1;

Line 19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
20: l_transaction_id NUMBER := NULL;
21: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
22: l_object_version_number NUMBER := 1;
23: l_sysdate DATE := SYSDATE;

Line 21: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
18: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
19: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
20: l_transaction_id NUMBER := NULL;
21: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
22: l_object_version_number NUMBER := 1;
23: l_sysdate DATE := SYSDATE;
24: l_master_organization_id NUMBER;
25: l_depreciable VARCHAR2(1);

Line 48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

Line 50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

Line 51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 111: RAISE fnd_api.g_exc_error;

107: IF NOT l_return_status = l_fnd_success THEN
108: IF (l_debug > 0) THEN
109: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
110: END IF;
111: RAISE fnd_api.g_exc_error;
112: END IF;
113:
114: -- Get the Master Organization ID
115: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 124: RAISE fnd_api.g_exc_error;

120: IF NOT l_return_status = l_fnd_success THEN
121: IF (l_debug > 0) THEN
122: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
123: END IF;
124: RAISE fnd_api.g_exc_error;
125: END IF;
126:
127: -- Call get_fnd_employee_id and get the employee id
128: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 166: l_instance_status := FND_API.G_FALSE;

162: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
163: l_mtl_item_tbl(i).organization_id);
164:
165: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
166: l_instance_status := FND_API.G_FALSE;
167: ELSE
168: l_instance_status := FND_API.G_TRUE;
169: END IF;
170:

Line 168: l_instance_status := FND_API.G_TRUE;

164:
165: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
166: l_instance_status := FND_API.G_FALSE;
167: ELSE
168: l_instance_status := FND_API.G_TRUE;
169: END IF;
170:
171: IF (l_debug > 0) THEN
172: csi_t_gen_utility_pvt.add('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 206: RAISE fnd_api.g_exc_error;

202: IF (l_debug > 0) THEN
203: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
204: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
205: END IF;
206: RAISE fnd_api.g_exc_error;
207: END IF;
208:
209: IF (l_debug > 0) THEN
210: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);

Line 245: RAISE fnd_api.g_exc_error;

241: IF NOT l_return_status = l_fnd_success THEN
242: IF (l_debug > 0) THEN
243: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
244: END IF;
245: RAISE fnd_api.g_exc_error;
246: END IF;
247:
248: FOR j in l_mtl_item_tbl.FIRST .. l_mtl_item_tbl.LAST LOOP
249:

Line 302: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

298: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
299: END IF;
300: l_msg_index := 1;
301: WHILE l_msg_count > 0 loop
302: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
303: l_msg_index := l_msg_index + 1;
304: l_msg_count := l_msg_count - 1;
305: END LOOP;
306: RAISE fnd_api.g_exc_error;

Line 306: RAISE fnd_api.g_exc_error;

302: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
303: l_msg_index := l_msg_index + 1;
304: l_msg_count := l_msg_count - 1;
305: END LOOP;
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309:
310: IF l_mtl_item_tbl(j).serial_number is NULL THEN

Line 381: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

377: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
378: END IF;
379: l_msg_index := 1;
380: WHILE l_msg_count > 0 loop
381: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
382: l_msg_index := l_msg_index + 1;
383: l_msg_count := l_msg_count - 1;
384: END LOOP;
385: RAISE fnd_api.g_exc_error;

Line 385: RAISE fnd_api.g_exc_error;

381: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
382: l_msg_index := l_msg_index + 1;
383: l_msg_count := l_msg_count - 1;
384: END LOOP;
385: RAISE fnd_api.g_exc_error;
386: END IF;
387:
388: ELSE -- No Records were found and Neg Qtys Not Allowed
389: IF (l_debug > 0) THEN

Line 394: RAISE fnd_api.g_exc_error;

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

Line 460: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

456: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
457: END IF;
458: l_msg_index := 1;
459: WHILE l_msg_count > 0 loop
460: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
461: l_msg_index := l_msg_index + 1;
462: l_msg_count := l_msg_count - 1;
463: END LOOP;
464: RAISE fnd_api.g_exc_error;

Line 464: RAISE fnd_api.g_exc_error;

460: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
461: l_msg_index := l_msg_index + 1;
462: l_msg_count := l_msg_count - 1;
463: END LOOP;
464: RAISE fnd_api.g_exc_error;
465: END IF;
466:
467: ELSIF l_src_instance_header_tbl.count > 1 THEN
468: -- Multiple Instances were found so throw error

Line 477: RAISE fnd_api.g_exc_error;

473: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
474: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
475: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
476: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
477: RAISE fnd_api.g_exc_error;
478:
479: END IF; -- End of Source Record IF
480:
481: -- Now query and get the destination record.

Line 525: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

521: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
522: END IF;
523: l_msg_index := 1;
524: WHILE l_msg_count > 0 loop
525: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
526: l_msg_index := l_msg_index + 1;
527: l_msg_count := l_msg_count - 1;
528: END LOOP;
529: RAISE fnd_api.g_exc_error;

Line 529: RAISE fnd_api.g_exc_error;

525: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
526: l_msg_index := l_msg_index + 1;
527: l_msg_count := l_msg_count - 1;
528: END LOOP;
529: RAISE fnd_api.g_exc_error;
530: END IF;
531:
532: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found
533: IF (l_debug > 0) THEN

Line 599: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

595: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
596: END IF;
597: l_msg_index := 1;
598: WHILE l_msg_count > 0 loop
599: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
600: l_msg_index := l_msg_index + 1;
601: l_msg_count := l_msg_count - 1;
602: END LOOP;
603: RAISE fnd_api.g_exc_error;

Line 603: RAISE fnd_api.g_exc_error;

599: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
600: l_msg_index := l_msg_index + 1;
601: l_msg_count := l_msg_count - 1;
602: END LOOP;
603: RAISE fnd_api.g_exc_error;
604: END IF;
605:
606: ELSIF l_dest_instance_header_tbl.count = 1 THEN-- Installed Base Destination Records Found
607:

Line 662: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

658: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
659: END IF;
660: l_msg_index := 1;
661: WHILE l_msg_count > 0 loop
662: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
663: l_msg_index := l_msg_index + 1;
664: l_msg_count := l_msg_count - 1;
665: END LOOP;
666: RAISE fnd_api.g_exc_error;

Line 666: RAISE fnd_api.g_exc_error;

662: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
663: l_msg_index := l_msg_index + 1;
664: l_msg_count := l_msg_count - 1;
665: END LOOP;
666: RAISE fnd_api.g_exc_error;
667: END IF;
668:
669: ELSIF l_dest_instance_header_tbl.count > 1 THEN
670: -- Multiple Instances were found so throw error

Line 679: RAISE fnd_api.g_exc_error;

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

Line 750: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

746: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
747: END IF;
748: l_msg_index := 1;
749: WHILE l_msg_count > 0 loop
750: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
751: l_msg_index := l_msg_index + 1;
752: l_msg_count := l_msg_count - 1;
753: END LOOP;
754: RAISE fnd_api.g_exc_error;

Line 754: RAISE fnd_api.g_exc_error;

750: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
751: l_msg_index := l_msg_index + 1;
752: l_msg_count := l_msg_count - 1;
753: END LOOP;
754: RAISE fnd_api.g_exc_error;
755: END IF;
756: ELSIF l_src_instance_header_tbl.count = 0 THEN
757: IF (l_debug > 0) THEN
758: csi_t_gen_utility_pvt.add('No Records were found in Install Base');

Line 765: RAISE fnd_api.g_exc_error;

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

Line 777: RAISE fnd_api.g_exc_error;

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

Line 788: WHEN fnd_api.g_exc_error THEN

784: csi_t_gen_utility_pvt.add('*****End of csi_inv_trxs_pkg.issue_to_project Transaction procedure*****');
785: END IF;
786:
787: EXCEPTION
788: WHEN fnd_api.g_exc_error THEN
789: IF (l_debug > 0) THEN
790: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
791: END IF;
792: x_return_status := l_fnd_error;

Line 790: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');

786:
787: EXCEPTION
788: WHEN fnd_api.g_exc_error THEN
789: IF (l_debug > 0) THEN
790: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
791: END IF;
792: x_return_status := l_fnd_error;
793:
794: IF l_mtl_item_tbl.count > 0 THEN

Line 857: l_commit VARCHAR2(1) := FND_API.G_FALSE;

853:
854: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
855: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_RECEIPT_PROJTASK';
856: l_api_version NUMBER := 1.0;
857: l_commit VARCHAR2(1) := FND_API.G_FALSE;
858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

Line 858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

854: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
855: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_RECEIPT_PROJTASK';
856: l_api_version NUMBER := 1.0;
857: l_commit VARCHAR2(1) := FND_API.G_FALSE;
858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
862: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

Line 859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

855: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_RECEIPT_PROJTASK';
856: l_api_version NUMBER := 1.0;
857: l_commit VARCHAR2(1) := FND_API.G_FALSE;
858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
862: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
863: l_transaction_id NUMBER := NULL;

Line 860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;

856: l_api_version NUMBER := 1.0;
857: l_commit VARCHAR2(1) := FND_API.G_FALSE;
858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
862: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
863: l_transaction_id NUMBER := NULL;
864: l_object_version_number NUMBER := 1;

Line 861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

857: l_commit VARCHAR2(1) := FND_API.G_FALSE;
858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
862: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
863: l_transaction_id NUMBER := NULL;
864: l_object_version_number NUMBER := 1;
865: l_sysdate DATE := SYSDATE;

Line 862: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

858: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
859: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
860: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
861: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
862: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
863: l_transaction_id NUMBER := NULL;
864: l_object_version_number NUMBER := 1;
865: l_sysdate DATE := SYSDATE;
866: l_master_organization_id NUMBER;

Line 892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
893: l_fnd_warning VARCHAR2(1) := 'W';
894: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
895: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
896: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

Line 894: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
893: l_fnd_warning VARCHAR2(1) := 'W';
894: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
895: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
896: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
897: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
898: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

Line 895: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
893: l_fnd_warning VARCHAR2(1) := 'W';
894: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
895: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
896: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
897: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
898: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
899: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 954: RAISE fnd_api.g_exc_error;

950: IF NOT l_return_status = l_fnd_success THEN
951: IF (l_debug > 0) THEN
952: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
953: END IF;
954: RAISE fnd_api.g_exc_error;
955: END IF;
956:
957: -- Get the Master Organization ID
958: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 967: RAISE fnd_api.g_exc_error;

963: IF NOT l_return_status = l_fnd_success THEN
964: IF (l_debug > 0) THEN
965: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
966: END IF;
967: RAISE fnd_api.g_exc_error;
968: END IF;
969:
970: -- Call get_fnd_employee_id and get the employee id
971: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 1024: RAISE fnd_api.g_exc_error;

1020: IF (l_debug > 0) THEN
1021: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
1022: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1023: END IF;
1024: RAISE fnd_api.g_exc_error;
1025: END IF;
1026:
1027: IF (l_debug > 0) THEN
1028: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);

Line 1061: RAISE fnd_api.g_exc_error;

1057: IF NOT l_return_status = l_fnd_success THEN
1058: IF (l_debug > 0) THEN
1059: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1060: END IF;
1061: RAISE fnd_api.g_exc_error;
1062: END IF;
1063:
1064: -- Now loop through the PL/SQL Table.
1065: j := 1;

Line 1125: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1121: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1122: END IF;
1123: l_msg_index := 1;
1124: WHILE l_msg_count > 0 loop
1125: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1126: l_msg_index := l_msg_index + 1;
1127: l_msg_count := l_msg_count - 1;
1128: END LOOP;
1129: RAISE fnd_api.g_exc_error;

Line 1129: RAISE fnd_api.g_exc_error;

1125: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1126: l_msg_index := l_msg_index + 1;
1127: l_msg_count := l_msg_count - 1;
1128: END LOOP;
1129: RAISE fnd_api.g_exc_error;
1130: END IF;
1131:
1132: IF l_src_instance_header_tbl.count = 1 THEN -- Records found so update either Serialized or Non Serialized
1133: IF l_src_instance_header_tbl(i).instance_usage_code in (l_out_of_service,

Line 1207: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1203: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1204: END IF;
1205: l_msg_index := 1;
1206: WHILE l_msg_count > 0 loop
1207: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1208: l_msg_index := l_msg_index + 1;
1209: l_msg_count := l_msg_count - 1;
1210: END LOOP;
1211: RAISE fnd_api.g_exc_error;

Line 1211: RAISE fnd_api.g_exc_error;

1207: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1208: l_msg_index := l_msg_index + 1;
1209: l_msg_count := l_msg_count - 1;
1210: END LOOP;
1211: RAISE fnd_api.g_exc_error;
1212: END IF;
1213: ELSE
1214: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
1215: IF (l_debug > 0) THEN

Line 1223: RAISE fnd_api.g_exc_error;

1219: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1220: fnd_message.set_token('STATUS',l_status);
1221: l_error_message := fnd_message.get;
1222: l_return_status := l_fnd_error;
1223: RAISE fnd_api.g_exc_error;
1224: END IF;
1225:
1226: ELSIF l_src_instance_header_tbl.count = 0 THEN
1227:

Line 1287: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1283: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1284: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1285: l_msg_index := 1;
1286: WHILE l_msg_count > 0 loop
1287: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1288: l_msg_index := l_msg_index + 1;
1289: l_msg_count := l_msg_count - 1;
1290: END LOOP;
1291: RAISE fnd_api.g_exc_error;

Line 1291: RAISE fnd_api.g_exc_error;

1287: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1288: l_msg_index := l_msg_index + 1;
1289: l_msg_count := l_msg_count - 1;
1290: END LOOP;
1291: RAISE fnd_api.g_exc_error;
1292: END IF;
1293:
1294: csi_t_gen_utility_pvt.add('Item Instance Created: '||l_new_instance_rec.instance_id);
1295:

Line 1305: -- RAISE fnd_api.g_exc_error;

1301: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1302: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1303: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1304: -- l_error_message := fnd_message.get;
1305: -- RAISE fnd_api.g_exc_error;
1306:
1307: ELSIF l_src_instance_header_tbl.count > 1 THEN
1308: -- Multiple Instances were found so throw error
1309: IF (l_debug > 0) THEN

Line 1317: RAISE fnd_api.g_exc_error;

1313: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1314: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1315: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1316: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1317: RAISE fnd_api.g_exc_error;
1318: END IF; -- No Records Found
1319:
1320: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized
1321:

Line 1367: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1363: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1364: END IF;
1365: l_msg_index := 1;
1366: WHILE l_msg_count > 0 loop
1367: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1368: l_msg_index := l_msg_index + 1;
1369: l_msg_count := l_msg_count - 1;
1370: END LOOP;
1371: RAISE fnd_api.g_exc_error;

Line 1371: RAISE fnd_api.g_exc_error;

1367: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1368: l_msg_index := l_msg_index + 1;
1369: l_msg_count := l_msg_count - 1;
1370: END LOOP;
1371: RAISE fnd_api.g_exc_error;
1372: END IF;
1373:
1374: IF l_src_instance_header_tbl.count = 1 THEN -- Records found so update either Serialized or Non Serialized
1375:

Line 1424: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1420: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1421: END IF;
1422: l_msg_index := 1;
1423: WHILE l_msg_count > 0 loop
1424: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1425: l_msg_index := l_msg_index + 1;
1426: l_msg_count := l_msg_count - 1;
1427: END LOOP;
1428: RAISE fnd_api.g_exc_error;

Line 1428: RAISE fnd_api.g_exc_error;

1424: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1425: l_msg_index := l_msg_index + 1;
1426: l_msg_count := l_msg_count - 1;
1427: END LOOP;
1428: RAISE fnd_api.g_exc_error;
1429: END IF;
1430:
1431: -- Now query and get the destination record.
1432: l_instance_dest_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

Line 1477: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1473: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1474: END IF;
1475: l_msg_index := 1;
1476: WHILE l_msg_count > 0 loop
1477: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1478: l_msg_index := l_msg_index + 1;
1479: l_msg_count := l_msg_count - 1;
1480: END LOOP;
1481: RAISE fnd_api.g_exc_error;

Line 1481: RAISE fnd_api.g_exc_error;

1477: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1478: l_msg_index := l_msg_index + 1;
1479: l_msg_count := l_msg_count - 1;
1480: END LOOP;
1481: RAISE fnd_api.g_exc_error;
1482: END IF;
1483:
1484: IF l_dest_instance_header_tbl.count = 0 THEN
1485:

Line 1550: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1546: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1547: END IF;
1548: l_msg_index := 1;
1549: WHILE l_msg_count > 0 loop
1550: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1551: l_msg_index := l_msg_index + 1;
1552: l_msg_count := l_msg_count - 1;
1553: END LOOP;
1554: RAISE fnd_api.g_exc_error;

Line 1554: RAISE fnd_api.g_exc_error;

1550: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1551: l_msg_index := l_msg_index + 1;
1552: l_msg_count := l_msg_count - 1;
1553: END LOOP;
1554: RAISE fnd_api.g_exc_error;
1555: END IF;
1556:
1557: ELSIF l_dest_instance_header_tbl.count = 1 THEN
1558:

Line 1610: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1606: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1607: END IF;
1608: l_msg_index := 1;
1609: WHILE l_msg_count > 0 loop
1610: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1611: l_msg_index := l_msg_index + 1;
1612: l_msg_count := l_msg_count - 1;
1613: END LOOP;
1614: RAISE fnd_api.g_exc_error;

Line 1614: RAISE fnd_api.g_exc_error;

1610: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1611: l_msg_index := l_msg_index + 1;
1612: l_msg_count := l_msg_count - 1;
1613: END LOOP;
1614: RAISE fnd_api.g_exc_error;
1615: END IF;
1616:
1617: ELSIF l_dest_instance_header_tbl.count > 1 THEN
1618: -- Multiple Instances were found so throw error

Line 1627: RAISE fnd_api.g_exc_error;

1623: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1624: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1625: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1626: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1627: RAISE fnd_api.g_exc_error;
1628:
1629: END IF; -- End of Destination Record If
1630:
1631: ELSIF l_src_instance_header_tbl.count = 0 THEN

Line 1681: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1677: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1678: END IF;
1679: l_msg_index := 1;
1680: WHILE l_msg_count > 0 loop
1681: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1682: l_msg_index := l_msg_index + 1;
1683: l_msg_count := l_msg_count - 1;
1684: END LOOP;
1685: RAISE fnd_api.g_exc_error;

Line 1685: RAISE fnd_api.g_exc_error;

1681: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1682: l_msg_index := l_msg_index + 1;
1683: l_msg_count := l_msg_count - 1;
1684: END LOOP;
1685: RAISE fnd_api.g_exc_error;
1686: END IF;
1687:
1688: IF l_dest_instance_header_tbl.count = 0 THEN
1689:

Line 1756: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1752: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1753: END IF;
1754: l_msg_index := 1;
1755: WHILE l_msg_count > 0 loop
1756: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1757: l_msg_index := l_msg_index + 1;
1758: l_msg_count := l_msg_count - 1;
1759: END LOOP;
1760: RAISE fnd_api.g_exc_error;

Line 1760: RAISE fnd_api.g_exc_error;

1756: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1757: l_msg_index := l_msg_index + 1;
1758: l_msg_count := l_msg_count - 1;
1759: END LOOP;
1760: RAISE fnd_api.g_exc_error;
1761: END IF;
1762:
1763: ELSIF l_dest_instance_header_tbl.count = 1 THEN
1764:

Line 1818: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1814: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1815: END IF;
1816: l_msg_index := 1;
1817: WHILE l_msg_count > 0 loop
1818: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1819: l_msg_index := l_msg_index + 1;
1820: l_msg_count := l_msg_count - 1;
1821: END LOOP;
1822: RAISE fnd_api.g_exc_error;

Line 1822: RAISE fnd_api.g_exc_error;

1818: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1819: l_msg_index := l_msg_index + 1;
1820: l_msg_count := l_msg_count - 1;
1821: END LOOP;
1822: RAISE fnd_api.g_exc_error;
1823: END IF;
1824:
1825: ELSIF l_dest_instance_header_tbl.count > 1 THEN
1826: -- Multiple Instances were found so throw error

Line 1835: RAISE fnd_api.g_exc_error;

1831: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1832: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1833: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1834: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1835: RAISE fnd_api.g_exc_error;
1836:
1837: END IF; -- End of Destination Record If for checking for In Inventory Records because the Project/Source Instance was not there.
1838:
1839: -- Bug 4378656 - If the instance is not there then we still need to create one that is In Inventory.

Line 1848: -- RAISE fnd_api.g_exc_error;

1844: -- fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
1845: -- fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
1846: -- fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
1847: -- l_error_message := fnd_message.get;
1848: -- RAISE fnd_api.g_exc_error;
1849:
1850: ELSIF l_src_instance_header_tbl.count > 1 THEN
1851: -- Multiple Instances were found so throw error
1852: IF (l_debug > 0) THEN

Line 1860: RAISE fnd_api.g_exc_error;

1856: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
1857: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1858: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1859: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1860: RAISE fnd_api.g_exc_error;
1861:
1862: END IF; -- End of No Records Found If
1863: END IF; -- End of Serial Number If
1864: END LOOP; -- End of For Loop

Line 1871: WHEN fnd_api.g_exc_error THEN

1867: csi_t_gen_utility_pvt.add('*****End of csi_inv_trxs_pkg.misc_receipt_projtask Transaction procedure*****');
1868: END IF;
1869:
1870: EXCEPTION
1871: WHEN fnd_api.g_exc_error THEN
1872: IF (l_debug > 0) THEN
1873: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
1874: END IF;
1875: x_return_status := l_fnd_error;

Line 1873: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');

1869:
1870: EXCEPTION
1871: WHEN fnd_api.g_exc_error THEN
1872: IF (l_debug > 0) THEN
1873: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
1874: END IF;
1875: x_return_status := l_fnd_error;
1876:
1877: IF l_mtl_item_tbl.count > 0 THEN

Line 1941: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1937:
1938: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1939: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_PROJTASK';
1940: l_api_version NUMBER := 1.0;
1941: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1942: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

Line 1942: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

1938: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1939: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_PROJTASK';
1940: l_api_version NUMBER := 1.0;
1941: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1942: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1946: l_transaction_id NUMBER := NULL;

Line 1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1939: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_PROJTASK';
1940: l_api_version NUMBER := 1.0;
1941: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1942: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1946: l_transaction_id NUMBER := NULL;
1947: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

Line 1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;

1940: l_api_version NUMBER := 1.0;
1941: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1942: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1946: l_transaction_id NUMBER := NULL;
1947: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1948: l_object_version_number NUMBER := 1;

Line 1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

1941: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1942: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1946: l_transaction_id NUMBER := NULL;
1947: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1948: l_object_version_number NUMBER := 1;
1949: l_sysdate DATE := SYSDATE;

Line 1947: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

1943: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1944: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1945: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1946: l_transaction_id NUMBER := NULL;
1947: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1948: l_object_version_number NUMBER := 1;
1949: l_sysdate DATE := SYSDATE;
1950: l_master_organization_id NUMBER;
1951: l_depreciable VARCHAR2(1);

Line 1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1975: l_fnd_warning VARCHAR2(1) := 'W';
1976: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1977: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1978: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

Line 1976: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1975: l_fnd_warning VARCHAR2(1) := 'W';
1976: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1977: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1978: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1979: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
1980: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

Line 1977: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1975: l_fnd_warning VARCHAR2(1) := 'W';
1976: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1977: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1978: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1979: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
1980: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
1981: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 2037: RAISE fnd_api.g_exc_error;

2033: IF NOT l_return_status = l_fnd_success THEN
2034: IF (l_debug > 0) THEN
2035: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2036: END IF;
2037: RAISE fnd_api.g_exc_error;
2038: END IF;
2039:
2040: -- Get the Master Organization ID
2041: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 2050: RAISE fnd_api.g_exc_error;

2046: IF NOT l_return_status = l_fnd_success THEN
2047: IF (l_debug > 0) THEN
2048: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
2049: END IF;
2050: RAISE fnd_api.g_exc_error;
2051: END IF;
2052:
2053: -- Call get_fnd_employee_id and get the employee id
2054: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 2090: l_instance_status := FND_API.G_FALSE;

2086: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
2087: l_mtl_item_tbl(i).organization_id);
2088:
2089: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2090: l_instance_status := FND_API.G_FALSE;
2091: ELSE
2092: l_instance_status := FND_API.G_TRUE;
2093: END IF;
2094:

Line 2092: l_instance_status := FND_API.G_TRUE;

2088:
2089: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2090: l_instance_status := FND_API.G_FALSE;
2091: ELSE
2092: l_instance_status := FND_API.G_TRUE;
2093: END IF;
2094:
2095: IF (l_debug > 0) THEN
2096: csi_t_gen_utility_pvt.add('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 2126: RAISE fnd_api.g_exc_error;

2122: IF (l_debug > 0) THEN
2123: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
2124: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
2125: END IF;
2126: RAISE fnd_api.g_exc_error;
2127: END IF;
2128:
2129: IF (l_debug > 0) THEN
2130: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);

Line 2163: RAISE fnd_api.g_exc_error;

2159: IF NOT l_return_status = l_fnd_success THEN
2160: IF (l_debug > 0) THEN
2161: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2162: END IF;
2163: RAISE fnd_api.g_exc_error;
2164: END IF;
2165:
2166: -- Now loop through the PL/SQL Table.
2167: j := 1;

Line 2228: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2224: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2225: END IF;
2226: l_msg_index := 1;
2227: WHILE l_msg_count > 0 loop
2228: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2229: l_msg_index := l_msg_index + 1;
2230: l_msg_count := l_msg_count - 1;
2231: END LOOP;
2232: RAISE fnd_api.g_exc_error;

Line 2232: RAISE fnd_api.g_exc_error;

2228: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2229: l_msg_index := l_msg_index + 1;
2230: l_msg_count := l_msg_count - 1;
2231: END LOOP;
2232: RAISE fnd_api.g_exc_error;
2233: END IF;
2234:
2235:
2236: IF l_mtl_item_tbl(j).serial_number is NULL THEN

Line 2306: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2302: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2303: END IF;
2304: l_msg_index := 1;
2305: WHILE l_msg_count > 0 loop
2306: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2307: l_msg_index := l_msg_index + 1;
2308: l_msg_count := l_msg_count - 1;
2309: END LOOP;
2310: RAISE fnd_api.g_exc_error;

Line 2310: RAISE fnd_api.g_exc_error;

2306: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2307: l_msg_index := l_msg_index + 1;
2308: l_msg_count := l_msg_count - 1;
2309: END LOOP;
2310: RAISE fnd_api.g_exc_error;
2311: END IF;
2312:
2313: ELSE -- No Records were found and Neg Qtys Not Allowed
2314: IF (l_debug > 0) THEN

Line 2319: RAISE fnd_api.g_exc_error;

2315: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
2316: END IF;
2317: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2318: l_error_message := fnd_message.get;
2319: RAISE fnd_api.g_exc_error;
2320:
2321: END IF; -- Neg Qty If
2322:
2323: ELSIF l_src_instance_header_tbl.count = 1 THEN

Line 2385: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2381: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2382: END IF;
2383: l_msg_index := 1;
2384: WHILE l_msg_count > 0 loop
2385: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2386: l_msg_index := l_msg_index + 1;
2387: l_msg_count := l_msg_count - 1;
2388: END LOOP;
2389: RAISE fnd_api.g_exc_error;

Line 2389: RAISE fnd_api.g_exc_error;

2385: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2386: l_msg_index := l_msg_index + 1;
2387: l_msg_count := l_msg_count - 1;
2388: END LOOP;
2389: RAISE fnd_api.g_exc_error;
2390: END IF;
2391:
2392: ELSIF l_src_instance_header_tbl.count > 1 THEN
2393: -- Multiple Instances were found so throw error

Line 2402: RAISE fnd_api.g_exc_error;

2398: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2399: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2400: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2401: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2402: RAISE fnd_api.g_exc_error;
2403:
2404: END IF; -- End of Source Record If
2405:
2406: -- Now query and get the destination record.

Line 2452: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2448: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2449: END IF;
2450: l_msg_index := 1;
2451: WHILE l_msg_count > 0 loop
2452: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2453: l_msg_index := l_msg_index + 1;
2454: l_msg_count := l_msg_count - 1;
2455: END LOOP;
2456: RAISE fnd_api.g_exc_error;

Line 2456: RAISE fnd_api.g_exc_error;

2452: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2453: l_msg_index := l_msg_index + 1;
2454: l_msg_count := l_msg_count - 1;
2455: END LOOP;
2456: RAISE fnd_api.g_exc_error;
2457: END IF;
2458:
2459: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found
2460: IF (l_debug > 0) THEN

Line 2527: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2523: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2524: END IF;
2525: l_msg_index := 1;
2526: WHILE l_msg_count > 0 loop
2527: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2528: l_msg_index := l_msg_index + 1;
2529: l_msg_count := l_msg_count - 1;
2530: END LOOP;
2531: RAISE fnd_api.g_exc_error;

Line 2531: RAISE fnd_api.g_exc_error;

2527: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2528: l_msg_index := l_msg_index + 1;
2529: l_msg_count := l_msg_count - 1;
2530: END LOOP;
2531: RAISE fnd_api.g_exc_error;
2532: END IF;
2533:
2534: ELSIF l_dest_instance_header_tbl.count = 1 THEN
2535: -- Installed Base Destination Records Found

Line 2592: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2588: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2589: END IF;
2590: l_msg_index := 1;
2591: WHILE l_msg_count > 0 loop
2592: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2593: l_msg_index := l_msg_index + 1;
2594: l_msg_count := l_msg_count - 1;
2595: END LOOP;
2596: RAISE fnd_api.g_exc_error;

Line 2596: RAISE fnd_api.g_exc_error;

2592: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2593: l_msg_index := l_msg_index + 1;
2594: l_msg_count := l_msg_count - 1;
2595: END LOOP;
2596: RAISE fnd_api.g_exc_error;
2597: END IF;
2598:
2599: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2600: -- Multiple Instances were found so throw error

Line 2609: RAISE fnd_api.g_exc_error;

2605: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2606: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2607: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2608: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2609: RAISE fnd_api.g_exc_error;
2610:
2611: END IF; -- End of Destination Record If
2612:
2613: ELSIF l_mtl_item_tbl(j).serial_number is NOT NULL THEN

Line 2674: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

2670: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2671: END IF;
2672: l_msg_index := 1;
2673: WHILE l_msg_count > 0 loop
2674: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2675: l_msg_index := l_msg_index + 1;
2676: l_msg_count := l_msg_count - 1;
2677: END LOOP;
2678: RAISE fnd_api.g_exc_error;

Line 2678: RAISE fnd_api.g_exc_error;

2674: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2675: l_msg_index := l_msg_index + 1;
2676: l_msg_count := l_msg_count - 1;
2677: END LOOP;
2678: RAISE fnd_api.g_exc_error;
2679: END IF;
2680:
2681: ELSIF l_src_instance_header_tbl.count = 0 THEN
2682: IF (l_debug > 0) THEN

Line 2690: RAISE fnd_api.g_exc_error;

2686: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2687: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2688: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2689: l_error_message := fnd_message.get;
2690: RAISE fnd_api.g_exc_error;
2691:
2692: ELSIF l_src_instance_header_tbl.count > 1 THEN
2693: -- Multiple Instances were found so throw error
2694: IF (l_debug > 0) THEN

Line 2702: RAISE fnd_api.g_exc_error;

2698: fnd_message.set_token('INV_ITEM_ID',l_mtl_item_tbl(j).inventory_item_id);
2699: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2700: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2701: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2702: RAISE fnd_api.g_exc_error;
2703: END IF; -- End of Source Record IF for Serialized
2704: END IF; -- End of Serial Number If
2705: END LOOP; -- End of For Loop
2706:

Line 2712: WHEN fnd_api.g_exc_error THEN

2708: csi_t_gen_utility_pvt.add('*****End of csi_inv_trxs_pkg.misc_issue_projtask Transaction procedure*****');
2709: END IF;
2710:
2711: EXCEPTION
2712: WHEN fnd_api.g_exc_error THEN
2713: IF (l_debug > 0) THEN
2714: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2715: END IF;
2716: x_return_status := l_fnd_error;

Line 2714: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');

2710:
2711: EXCEPTION
2712: WHEN fnd_api.g_exc_error THEN
2713: IF (l_debug > 0) THEN
2714: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2715: END IF;
2716: x_return_status := l_fnd_error;
2717:
2718: IF l_mtl_item_tbl.count > 0 THEN