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.

[Home] [Help]

APPS.CSI_INV_HZ_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_HZ_PKG.ISSUE_TO_HZ_LOC';
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_HZ_PKG.ISSUE_TO_HZ_LOC';
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_HZ_PKG.ISSUE_TO_HZ_LOC';
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 127: RAISE fnd_api.g_exc_error;

123: IF NOT l_return_status = l_fnd_success THEN
124: IF (l_debug > 0) THEN
125: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
126: END IF;
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:
130: -- Get the Master Organization ID
131: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 140: RAISE fnd_api.g_exc_error;

136: IF NOT l_return_status = l_fnd_success THEN
137: IF (l_debug > 0) THEN
138: 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);
139: END IF;
140: RAISE fnd_api.g_exc_error;
141: END IF;
142:
143: -- Call get_fnd_employee_id and get the employee id
144: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 183: l_instance_status := FND_API.G_FALSE;

179: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
180: l_mtl_item_tbl(i).organization_id);
181:
182: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
183: l_instance_status := FND_API.G_FALSE;
184: ELSE
185: l_instance_status := FND_API.G_TRUE;
186: END IF;
187:

Line 185: l_instance_status := FND_API.G_TRUE;

181:
182: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
183: l_instance_status := FND_API.G_FALSE;
184: ELSE
185: l_instance_status := FND_API.G_TRUE;
186: END IF;
187:
188: IF (l_debug > 0) THEN
189: csi_t_gen_utility_pvt.add('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 252: RAISE fnd_api.g_exc_error;

248: IF NOT l_return_status = l_fnd_success THEN
249: IF (l_debug > 0) THEN
250: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
251: END IF;
252: RAISE fnd_api.g_exc_error;
253: END IF;
254:
255: FOR j in l_mtl_item_tbl.FIRST .. l_mtl_item_tbl.LAST LOOP
256:

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

308: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
309: END IF;
310: l_msg_index := 1;
311: WHILE l_msg_count > 0 loop
312: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
313: l_msg_index := l_msg_index + 1;
314: l_msg_count := l_msg_count - 1;
315: END LOOP;
316: RAISE fnd_api.g_exc_error;

Line 316: RAISE fnd_api.g_exc_error;

312: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
313: l_msg_index := l_msg_index + 1;
314: l_msg_count := l_msg_count - 1;
315: END LOOP;
316: RAISE fnd_api.g_exc_error;
317: END IF;
318:
319:
320: IF l_mtl_item_tbl(j).serial_number is NULL THEN

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

390: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
391: END IF;
392: l_msg_index := 1;
393: WHILE l_msg_count > 0 loop
394: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
395: l_msg_index := l_msg_index + 1;
396: l_msg_count := l_msg_count - 1;
397: END LOOP;
398: RAISE fnd_api.g_exc_error;

Line 398: RAISE fnd_api.g_exc_error;

394: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
395: l_msg_index := l_msg_index + 1;
396: l_msg_count := l_msg_count - 1;
397: END LOOP;
398: RAISE fnd_api.g_exc_error;
399: END IF;
400:
401: ELSE -- No Records were found and Neg Qtys Not Allowed
402: IF (l_debug > 0) THEN

Line 407: RAISE fnd_api.g_exc_error;

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

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

468: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
469: END IF;
470: l_msg_index := 1;
471: WHILE l_msg_count > 0 loop
472: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
473: l_msg_index := l_msg_index + 1;
474: l_msg_count := l_msg_count - 1;
475: END LOOP;
476: RAISE fnd_api.g_exc_error;

Line 476: RAISE fnd_api.g_exc_error;

472: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
473: l_msg_index := l_msg_index + 1;
474: l_msg_count := l_msg_count - 1;
475: END LOOP;
476: RAISE fnd_api.g_exc_error;
477: END IF;
478:
479: ELSIF l_src_instance_header_tbl.count > 1 THEN
480: -- Multiple Instances were found so throw error

Line 490: RAISE fnd_api.g_exc_error;

486: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
487: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
488: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
489: l_error_message := fnd_message.get;
490: RAISE fnd_api.g_exc_error;
491:
492: END IF; -- End of Source Record IF
493:
494: -- Now query and get the destination record.

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

539: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
540: END IF;
541: l_msg_index := 1;
542: WHILE l_msg_count > 0 loop
543: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
544: l_msg_index := l_msg_index + 1;
545: l_msg_count := l_msg_count - 1;
546: END LOOP;
547: RAISE fnd_api.g_exc_error;

Line 547: RAISE fnd_api.g_exc_error;

543: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
544: l_msg_index := l_msg_index + 1;
545: l_msg_count := l_msg_count - 1;
546: END LOOP;
547: RAISE fnd_api.g_exc_error;
548: END IF;
549:
550: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found
551: IF (l_debug > 0) THEN

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

613: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
614: END IF;
615: l_msg_index := 1;
616: WHILE l_msg_count > 0 loop
617: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
618: l_msg_index := l_msg_index + 1;
619: l_msg_count := l_msg_count - 1;
620: END LOOP;
621: RAISE fnd_api.g_exc_error;

Line 621: RAISE fnd_api.g_exc_error;

617: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
618: l_msg_index := l_msg_index + 1;
619: l_msg_count := l_msg_count - 1;
620: END LOOP;
621: RAISE fnd_api.g_exc_error;
622: END IF;
623:
624: ELSIF l_dest_instance_header_tbl.count = 1 THEN-- Installed Base Destination Records Found
625:

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

676: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
677: END IF;
678: l_msg_index := 1;
679: WHILE l_msg_count > 0 loop
680: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
681: l_msg_index := l_msg_index + 1;
682: l_msg_count := l_msg_count - 1;
683: END LOOP;
684: RAISE fnd_api.g_exc_error;

Line 684: RAISE fnd_api.g_exc_error;

680: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
681: l_msg_index := l_msg_index + 1;
682: l_msg_count := l_msg_count - 1;
683: END LOOP;
684: RAISE fnd_api.g_exc_error;
685: END IF;
686:
687: ELSIF l_dest_instance_header_tbl.count > 1 THEN
688: -- Multiple Instances were found so throw error

Line 698: RAISE fnd_api.g_exc_error;

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

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

767: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
768: END IF;
769: l_msg_index := 1;
770: WHILE l_msg_count > 0 loop
771: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
772: l_msg_index := l_msg_index + 1;
773: l_msg_count := l_msg_count - 1;
774: END LOOP;
775: RAISE fnd_api.g_exc_error;

Line 775: RAISE fnd_api.g_exc_error;

771: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
772: l_msg_index := l_msg_index + 1;
773: l_msg_count := l_msg_count - 1;
774: END LOOP;
775: RAISE fnd_api.g_exc_error;
776: END IF;
777:
778: ELSIF l_src_instance_header_tbl.count = 0 THEN -- Serialized Item
779: IF (l_debug > 0) THEN

Line 787: RAISE fnd_api.g_exc_error;

783: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
784: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
785: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
786: l_error_message := fnd_message.get;
787: RAISE fnd_api.g_exc_error;
788:
789: ELSIF l_src_instance_header_tbl.count > 1 THEN -- Serialized Item
790:
791: -- Multiple Instances were found so throw error

Line 801: RAISE fnd_api.g_exc_error;

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

Line 813: WHEN fnd_api.g_exc_error THEN

809: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.issue_to_hz_loc Transaction procedure*****');
810: END IF;
811:
812: EXCEPTION
813: WHEN fnd_api.g_exc_error THEN
814: IF (l_debug > 0) THEN
815: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
816: END IF;
817: x_return_status := l_fnd_error;

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

811:
812: EXCEPTION
813: WHEN fnd_api.g_exc_error THEN
814: IF (l_debug > 0) THEN
815: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
816: END IF;
817: x_return_status := l_fnd_error;
818:
819: IF l_mtl_item_tbl.count > 0 THEN

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

879:
880: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
881: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';
882: l_api_version NUMBER := 1.0;
883: l_commit VARCHAR2(1) := FND_API.G_FALSE;
884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
886: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
887: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

880: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
881: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';
882: l_api_version NUMBER := 1.0;
883: l_commit VARCHAR2(1) := FND_API.G_FALSE;
884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
886: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
887: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
888: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

Line 885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

881: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';
882: l_api_version NUMBER := 1.0;
883: l_commit VARCHAR2(1) := FND_API.G_FALSE;
884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
886: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
887: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
888: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
889: l_transaction_id NUMBER := NULL;

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

882: l_api_version NUMBER := 1.0;
883: l_commit VARCHAR2(1) := FND_API.G_FALSE;
884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
886: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
887: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
888: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
889: l_transaction_id NUMBER := NULL;
890: l_object_version_number NUMBER := 1;

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

883: l_commit VARCHAR2(1) := FND_API.G_FALSE;
884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
886: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
887: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
888: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
889: l_transaction_id NUMBER := NULL;
890: l_object_version_number NUMBER := 1;
891: l_sysdate DATE := SYSDATE;

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

884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
886: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
887: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
888: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
889: l_transaction_id NUMBER := NULL;
890: l_object_version_number NUMBER := 1;
891: l_sysdate DATE := SYSDATE;
892: l_master_organization_id NUMBER;

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

914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
919: l_fnd_warning VARCHAR2(1) := 'W';
920: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
921: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
922: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

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

916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
919: l_fnd_warning VARCHAR2(1) := 'W';
920: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
921: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
922: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
923: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
924: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

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

917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
919: l_fnd_warning VARCHAR2(1) := 'W';
920: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
921: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
922: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
923: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
924: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
925: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 1002: RAISE fnd_api.g_exc_error;

998: IF NOT l_return_status = l_fnd_success THEN
999: IF (l_debug > 0) THEN
1000: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
1001: END IF;
1002: RAISE fnd_api.g_exc_error;
1003: END IF;
1004:
1005: -- Get the Master Organization ID
1006: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 1015: RAISE fnd_api.g_exc_error;

1011: IF NOT l_return_status = l_fnd_success THEN
1012: IF (l_debug > 0) THEN
1013: 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);
1014: END IF;
1015: RAISE fnd_api.g_exc_error;
1016: END IF;
1017:
1018: -- Call get_fnd_employee_id and get the employee id
1019: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 1076: -- RAISE fnd_api.g_exc_error;

1072: -- IF (l_debug > 0) THEN
1073: -- csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
1074: -- csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1075: -- END IF;
1076: -- RAISE fnd_api.g_exc_error;
1077: --END IF;
1078:
1079: IF (l_debug > 0) THEN
1080: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);

Line 1136: RAISE fnd_api.g_exc_error;

1132: IF NOT l_return_status = l_fnd_success THEN
1133: IF (l_debug > 0) THEN
1134: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1135: END IF;
1136: RAISE fnd_api.g_exc_error;
1137: END IF;
1138:
1139: -- Now loop through the PL/SQL Table.
1140: j := 1;

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

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

Line 1207: RAISE fnd_api.g_exc_error;

1203: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1204: l_msg_index := l_msg_index + 1;
1205: l_msg_count := l_msg_count - 1;
1206: END LOOP;
1207: RAISE fnd_api.g_exc_error;
1208: END IF;
1209:
1210: IF l_src_instance_header_tbl.count > 0 THEN -- Added if condition for bug 13646798
1211: --Added code for bug 12536407

Line 1225: RAISE fnd_api.g_exc_error;

1221: IF (l_debug > 0) THEN
1222: csi_t_gen_utility_pvt.add('You encountered an error in the se_inv_trxs_pkg.check_and_break_relation');
1223: END IF;
1224: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1225: RAISE fnd_api.g_exc_error;
1226: END IF;
1227: IF (l_debug > 0) THEN
1228: csi_t_gen_utility_pvt.add('Object Version originally from instance: '||l_src_instance_header_tbl(i).object_version_number);
1229: END IF;

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

1330: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1331: END IF;
1332: l_msg_index := 1;
1333: WHILE l_msg_count > 0 loop
1334: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1335: l_msg_index := l_msg_index + 1;
1336: l_msg_count := l_msg_count - 1;
1337: END LOOP;
1338: RAISE fnd_api.g_exc_error;

Line 1338: RAISE fnd_api.g_exc_error;

1334: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1335: l_msg_index := l_msg_index + 1;
1336: l_msg_count := l_msg_count - 1;
1337: END LOOP;
1338: RAISE fnd_api.g_exc_error;
1339: END IF;
1340: ELSE
1341: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
1342: IF (l_debug > 0) THEN

Line 1350: RAISE fnd_api.g_exc_error;

1346: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1347: fnd_message.set_token('STATUS',l_status);
1348: l_error_message := fnd_message.get;
1349: l_return_status := l_fnd_error;
1350: RAISE fnd_api.g_exc_error;
1351: END IF;
1352:
1353: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
1354: csi_t_gen_utility_pvt.add('No Serialized Instances are found so we need to create one that we would have received from the HZ/HR Location');

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

1409: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1410: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1411: l_msg_index := 1;
1412: WHILE l_msg_count > 0 loop
1413: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1414: l_msg_index := l_msg_index + 1;
1415: l_msg_count := l_msg_count - 1;
1416: END LOOP;
1417: RAISE fnd_api.g_exc_error;

Line 1417: RAISE fnd_api.g_exc_error;

1413: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1414: l_msg_index := l_msg_index + 1;
1415: l_msg_count := l_msg_count - 1;
1416: END LOOP;
1417: RAISE fnd_api.g_exc_error;
1418: END IF;
1419:
1420: csi_t_gen_utility_pvt.add('Item Instance Created: '||l_new_instance_rec.instance_id);
1421:

Line 1433: RAISE fnd_api.g_exc_error;

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

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

1484: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1485: END IF;
1486: l_msg_index := 1;
1487: WHILE l_msg_count > 0 loop
1488: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1489: l_msg_index := l_msg_index + 1;
1490: l_msg_count := l_msg_count - 1;
1491: END LOOP;
1492: RAISE fnd_api.g_exc_error;

Line 1492: RAISE fnd_api.g_exc_error;

1488: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1489: l_msg_index := l_msg_index + 1;
1490: l_msg_count := l_msg_count - 1;
1491: END LOOP;
1492: RAISE fnd_api.g_exc_error;
1493: END IF;
1494:
1495: l_bypass_qty := 'N';
1496:

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

1577: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1578: END IF;
1579: l_msg_index := 1;
1580: WHILE l_msg_count > 0 loop
1581: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1582: l_msg_index := l_msg_index + 1;
1583: l_msg_count := l_msg_count - 1;
1584: END LOOP;
1585: RAISE fnd_api.g_exc_error;

Line 1585: RAISE fnd_api.g_exc_error;

1581: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1582: l_msg_index := l_msg_index + 1;
1583: l_msg_count := l_msg_count - 1;
1584: END LOOP;
1585: RAISE fnd_api.g_exc_error;
1586: END IF;
1587:
1588: END IF;
1589: END LOOP; -- Out of Service

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

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

Line 1683: RAISE fnd_api.g_exc_error;

1679: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1680: l_msg_index := l_msg_index + 1;
1681: l_msg_count := l_msg_count - 1;
1682: END LOOP;
1683: RAISE fnd_api.g_exc_error;
1684: END IF;
1685:
1686: END IF;
1687: END LOOP; -- Installed

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

1772: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1773: END IF;
1774: l_msg_index := 1;
1775: WHILE l_msg_count > 0 loop
1776: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1777: l_msg_index := l_msg_index + 1;
1778: l_msg_count := l_msg_count - 1;
1779: END LOOP;
1780: RAISE fnd_api.g_exc_error;

Line 1780: RAISE fnd_api.g_exc_error;

1776: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1777: l_msg_index := l_msg_index + 1;
1778: l_msg_count := l_msg_count - 1;
1779: END LOOP;
1780: RAISE fnd_api.g_exc_error;
1781: END IF;
1782:
1783: END IF;
1784: END LOOP; -- In Service

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

1829: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1830: END IF;
1831: l_msg_index := 1;
1832: WHILE l_msg_count > 0 loop
1833: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1834: l_msg_index := l_msg_index + 1;
1835: l_msg_count := l_msg_count - 1;
1836: END LOOP;
1837: RAISE fnd_api.g_exc_error;

Line 1837: RAISE fnd_api.g_exc_error;

1833: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1834: l_msg_index := l_msg_index + 1;
1835: l_msg_count := l_msg_count - 1;
1836: END LOOP;
1837: RAISE fnd_api.g_exc_error;
1838: END IF;
1839:
1840: IF l_dest_instance_header_tbl.count = 0 THEN
1841:

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

1900: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1901: END IF;
1902: l_msg_index := 1;
1903: WHILE l_msg_count > 0 loop
1904: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1905: l_msg_index := l_msg_index + 1;
1906: l_msg_count := l_msg_count - 1;
1907: END LOOP;
1908: RAISE fnd_api.g_exc_error;

Line 1908: RAISE fnd_api.g_exc_error;

1904: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1905: l_msg_index := l_msg_index + 1;
1906: l_msg_count := l_msg_count - 1;
1907: END LOOP;
1908: RAISE fnd_api.g_exc_error;
1909: END IF;
1910:
1911: ELSIF l_dest_instance_header_tbl.count = 1 THEN
1912:

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

1960: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1961: END IF;
1962: l_msg_index := 1;
1963: WHILE l_msg_count > 0 loop
1964: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1965: l_msg_index := l_msg_index + 1;
1966: l_msg_count := l_msg_count - 1;
1967: END LOOP;
1968: RAISE fnd_api.g_exc_error;

Line 1968: RAISE fnd_api.g_exc_error;

1964: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1965: l_msg_index := l_msg_index + 1;
1966: l_msg_count := l_msg_count - 1;
1967: END LOOP;
1968: RAISE fnd_api.g_exc_error;
1969: END IF;
1970:
1971: ELSIF l_dest_instance_header_tbl.count > 1 THEN
1972:

Line 1983: RAISE fnd_api.g_exc_error;

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

Line 1998: RAISE fnd_api.g_exc_error;

1994: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1995: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1996: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1997: l_error_message := fnd_message.get;
1998: RAISE fnd_api.g_exc_error;
1999: ***/
2000: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
2001:
2002: csi_t_gen_utility_pvt.add('No Source Records in a HZ/HR Location Exist. Query for the inventory record in the Org to see if it exists. If it does then add to that instance otherwise create a new instance that is located in Inventory');

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

2045: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2046: END IF;
2047: l_msg_index := 1;
2048: WHILE l_msg_count > 0 loop
2049: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2050: l_msg_index := l_msg_index + 1;
2051: l_msg_count := l_msg_count - 1;
2052: END LOOP;
2053: RAISE fnd_api.g_exc_error;

Line 2053: RAISE fnd_api.g_exc_error;

2049: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2050: l_msg_index := l_msg_index + 1;
2051: l_msg_count := l_msg_count - 1;
2052: END LOOP;
2053: RAISE fnd_api.g_exc_error;
2054: END IF;
2055:
2056: IF l_dest_instance_header_tbl.count = 0 THEN
2057:

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

2116: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2117: END IF;
2118: l_msg_index := 1;
2119: WHILE l_msg_count > 0 loop
2120: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2121: l_msg_index := l_msg_index + 1;
2122: l_msg_count := l_msg_count - 1;
2123: END LOOP;
2124: RAISE fnd_api.g_exc_error;

Line 2124: RAISE fnd_api.g_exc_error;

2120: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2121: l_msg_index := l_msg_index + 1;
2122: l_msg_count := l_msg_count - 1;
2123: END LOOP;
2124: RAISE fnd_api.g_exc_error;
2125: END IF;
2126:
2127: ELSIF l_dest_instance_header_tbl.count = 1 THEN
2128:

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

2176: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2177: END IF;
2178: l_msg_index := 1;
2179: WHILE l_msg_count > 0 loop
2180: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2181: l_msg_index := l_msg_index + 1;
2182: l_msg_count := l_msg_count - 1;
2183: END LOOP;
2184: RAISE fnd_api.g_exc_error;

Line 2184: RAISE fnd_api.g_exc_error;

2180: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2181: l_msg_index := l_msg_index + 1;
2182: l_msg_count := l_msg_count - 1;
2183: END LOOP;
2184: RAISE fnd_api.g_exc_error;
2185: END IF;
2186:
2187: ELSIF l_src_instance_header_tbl.count > 1 THEN
2188: -- Multiple Instances were found so throw error

Line 2198: RAISE fnd_api.g_exc_error;

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

Line 2211: WHEN fnd_api.g_exc_error THEN

2207: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_receipt_hz_loc Transaction procedure*****');
2208: END IF;
2209:
2210: EXCEPTION
2211: WHEN fnd_api.g_exc_error THEN
2212: IF (l_debug > 0) THEN
2213: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2214: END IF;
2215: x_return_status := l_fnd_error;

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

2209:
2210: EXCEPTION
2211: WHEN fnd_api.g_exc_error THEN
2212: IF (l_debug > 0) THEN
2213: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2214: END IF;
2215: x_return_status := l_fnd_error;
2216: x_trx_error_rec.error_text := l_error_message;
2217:

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

2277:
2278: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2279: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2280: l_api_version NUMBER := 1.0;
2281: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2282: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2284: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2285: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

2278: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2279: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2280: l_api_version NUMBER := 1.0;
2281: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2282: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2284: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2285: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2286: l_transaction_id NUMBER := NULL;

Line 2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

2279: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2280: l_api_version NUMBER := 1.0;
2281: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2282: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2284: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2285: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2286: l_transaction_id NUMBER := NULL;
2287: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

2280: l_api_version NUMBER := 1.0;
2281: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2282: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2284: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2285: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2286: l_transaction_id NUMBER := NULL;
2287: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2288: l_object_version_number NUMBER := 1;

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

2281: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2282: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2284: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2285: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2286: l_transaction_id NUMBER := NULL;
2287: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2288: l_object_version_number NUMBER := 1;
2289: l_sysdate DATE := SYSDATE;

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

2283: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2284: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2285: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2286: l_transaction_id NUMBER := NULL;
2287: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2288: l_object_version_number NUMBER := 1;
2289: l_sysdate DATE := SYSDATE;
2290: l_master_organization_id NUMBER;
2291: l_depreciable VARCHAR2(1);

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

2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2315: l_fnd_warning VARCHAR2(1) := 'W';
2316: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2317: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2318: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

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

2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2315: l_fnd_warning VARCHAR2(1) := 'W';
2316: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2317: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2318: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2319: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2320: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

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

2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2315: l_fnd_warning VARCHAR2(1) := 'W';
2316: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2317: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2318: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2319: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2320: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2321: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 2393: RAISE fnd_api.g_exc_error;

2389: IF NOT l_return_status = l_fnd_success THEN
2390: IF (l_debug > 0) THEN
2391: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2392: END IF;
2393: RAISE fnd_api.g_exc_error;
2394: END IF;
2395:
2396: -- Get the Master Organization ID
2397: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 2406: RAISE fnd_api.g_exc_error;

2402: IF NOT l_return_status = l_fnd_success THEN
2403: IF (l_debug > 0) THEN
2404: 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);
2405: END IF;
2406: RAISE fnd_api.g_exc_error;
2407: END IF;
2408:
2409: -- Call get_fnd_employee_id and get the employee id
2410: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 2447: l_instance_status := FND_API.G_FALSE;

2443: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
2444: l_mtl_item_tbl(i).organization_id);
2445:
2446: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2447: l_instance_status := FND_API.G_FALSE;
2448: ELSE
2449: l_instance_status := FND_API.G_TRUE;
2450: END IF;
2451:

Line 2449: l_instance_status := FND_API.G_TRUE;

2445:
2446: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2447: l_instance_status := FND_API.G_FALSE;
2448: ELSE
2449: l_instance_status := FND_API.G_TRUE;
2450: END IF;
2451:
2452: IF (l_debug > 0) THEN
2453: csi_t_gen_utility_pvt.add('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 2510: RAISE fnd_api.g_exc_error;

2506: IF NOT l_return_status = l_fnd_success THEN
2507: IF (l_debug > 0) THEN
2508: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2509: END IF;
2510: RAISE fnd_api.g_exc_error;
2511: END IF;
2512:
2513: -- Now loop through the PL/SQL Table.
2514: j := 1;

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

2573: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2574: END IF;
2575: l_msg_index := 1;
2576: WHILE l_msg_count > 0 loop
2577: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2578: l_msg_index := l_msg_index + 1;
2579: l_msg_count := l_msg_count - 1;
2580: END LOOP;
2581: RAISE fnd_api.g_exc_error;

Line 2581: RAISE fnd_api.g_exc_error;

2577: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2578: l_msg_index := l_msg_index + 1;
2579: l_msg_count := l_msg_count - 1;
2580: END LOOP;
2581: RAISE fnd_api.g_exc_error;
2582: END IF;
2583:
2584:
2585: IF l_mtl_item_tbl(j).serial_number is NULL THEN

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

2650: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2651: END IF;
2652: l_msg_index := 1;
2653: WHILE l_msg_count > 0 loop
2654: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2655: l_msg_index := l_msg_index + 1;
2656: l_msg_count := l_msg_count - 1;
2657: END LOOP;
2658: RAISE fnd_api.g_exc_error;

Line 2658: RAISE fnd_api.g_exc_error;

2654: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2655: l_msg_index := l_msg_index + 1;
2656: l_msg_count := l_msg_count - 1;
2657: END LOOP;
2658: RAISE fnd_api.g_exc_error;
2659: END IF;
2660:
2661: ELSE -- No Records were found and Neg Qtys Not Allowed
2662: IF (l_debug > 0) THEN

Line 2667: RAISE fnd_api.g_exc_error;

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

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

2726: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2727: END IF;
2728: l_msg_index := 1;
2729: WHILE l_msg_count > 0 loop
2730: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2731: l_msg_index := l_msg_index + 1;
2732: l_msg_count := l_msg_count - 1;
2733: END LOOP;
2734: RAISE fnd_api.g_exc_error;

Line 2734: RAISE fnd_api.g_exc_error;

2730: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2731: l_msg_index := l_msg_index + 1;
2732: l_msg_count := l_msg_count - 1;
2733: END LOOP;
2734: RAISE fnd_api.g_exc_error;
2735: END IF;
2736:
2737: ELSIF l_src_instance_header_tbl.count > 1 THEN
2738: -- Multiple Instances were found so throw error

Line 2748: RAISE fnd_api.g_exc_error;

2744: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2745: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2746: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2747: l_error_message := fnd_message.get;
2748: RAISE fnd_api.g_exc_error;
2749:
2750: END IF; -- End of Source Record If
2751:
2752: -- Now query and get the destination record.

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

2800: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2801: END IF;
2802: l_msg_index := 1;
2803: WHILE l_msg_count > 0 loop
2804: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2805: l_msg_index := l_msg_index + 1;
2806: l_msg_count := l_msg_count - 1;
2807: END LOOP;
2808: RAISE fnd_api.g_exc_error;

Line 2808: RAISE fnd_api.g_exc_error;

2804: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2805: l_msg_index := l_msg_index + 1;
2806: l_msg_count := l_msg_count - 1;
2807: END LOOP;
2808: RAISE fnd_api.g_exc_error;
2809: END IF;
2810:
2811: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found
2812: IF (l_debug > 0) THEN

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

2874: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2875: END IF;
2876: l_msg_index := 1;
2877: WHILE l_msg_count > 0 loop
2878: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2879: l_msg_index := l_msg_index + 1;
2880: l_msg_count := l_msg_count - 1;
2881: END LOOP;
2882: RAISE fnd_api.g_exc_error;

Line 2882: RAISE fnd_api.g_exc_error;

2878: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2879: l_msg_index := l_msg_index + 1;
2880: l_msg_count := l_msg_count - 1;
2881: END LOOP;
2882: RAISE fnd_api.g_exc_error;
2883: END IF;
2884:
2885: ELSIF l_dest_instance_header_tbl.count = 1 THEN-- Installed Base Destination Records Found
2886:

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

2938: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2939: END IF;
2940: l_msg_index := 1;
2941: WHILE l_msg_count > 0 loop
2942: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2943: l_msg_index := l_msg_index + 1;
2944: l_msg_count := l_msg_count - 1;
2945: END LOOP;
2946: RAISE fnd_api.g_exc_error;

Line 2946: RAISE fnd_api.g_exc_error;

2942: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2943: l_msg_index := l_msg_index + 1;
2944: l_msg_count := l_msg_count - 1;
2945: END LOOP;
2946: RAISE fnd_api.g_exc_error;
2947: END IF;
2948:
2949: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2950:

Line 2961: RAISE fnd_api.g_exc_error;

2957: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2958: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2959: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2960: l_error_message := fnd_message.get;
2961: RAISE fnd_api.g_exc_error;
2962:
2963: END IF; -- End of Destination Record If
2964:
2965: ELSIF l_mtl_item_tbl(j).serial_number is NOT NULL THEN

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

3025: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3026: END IF;
3027: l_msg_index := 1;
3028: WHILE l_msg_count > 0 loop
3029: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3030: l_msg_index := l_msg_index + 1;
3031: l_msg_count := l_msg_count - 1;
3032: END LOOP;
3033: RAISE fnd_api.g_exc_error;

Line 3033: RAISE fnd_api.g_exc_error;

3029: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3030: l_msg_index := l_msg_index + 1;
3031: l_msg_count := l_msg_count - 1;
3032: END LOOP;
3033: RAISE fnd_api.g_exc_error;
3034: END IF;
3035:
3036: ELSIF l_src_instance_header_tbl.count = 0 THEN
3037: IF (l_debug > 0) THEN

Line 3045: RAISE fnd_api.g_exc_error;

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

Line 3058: RAISE fnd_api.g_exc_error;

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

Line 3070: WHEN fnd_api.g_exc_error THEN

3066: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_issue_hz_loc Transaction procedure*****');
3067: END IF;
3068:
3069: EXCEPTION
3070: WHEN fnd_api.g_exc_error THEN
3071: IF (l_debug > 0) THEN
3072: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
3073: END IF;
3074: x_return_status := l_fnd_error;

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

3068:
3069: EXCEPTION
3070: WHEN fnd_api.g_exc_error THEN
3071: IF (l_debug > 0) THEN
3072: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
3073: END IF;
3074: x_return_status := l_fnd_error;
3075:
3076: IF l_mtl_item_tbl.count > 0 THEN