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

APPS.CSI_INV_HZ_PKG dependencies on FND_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 182: l_instance_status := FND_API.G_FALSE;

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

Line 184: l_instance_status := FND_API.G_TRUE;

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

Line 251: RAISE fnd_api.g_exc_error;

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

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

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

Line 315: RAISE fnd_api.g_exc_error;

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

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

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

Line 397: RAISE fnd_api.g_exc_error;

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

Line 406: RAISE fnd_api.g_exc_error;

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

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

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

Line 475: RAISE fnd_api.g_exc_error;

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

Line 489: RAISE fnd_api.g_exc_error;

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

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

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

Line 546: RAISE fnd_api.g_exc_error;

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

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

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

Line 620: RAISE fnd_api.g_exc_error;

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

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

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

Line 683: RAISE fnd_api.g_exc_error;

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

Line 697: RAISE fnd_api.g_exc_error;

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

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

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

Line 774: RAISE fnd_api.g_exc_error;

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

Line 786: RAISE fnd_api.g_exc_error;

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

Line 800: RAISE fnd_api.g_exc_error;

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

Line 812: WHEN fnd_api.g_exc_error THEN

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

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

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

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

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

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

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

Line 884: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 999: RAISE fnd_api.g_exc_error;

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

Line 1012: RAISE fnd_api.g_exc_error;

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

Line 1072: -- RAISE fnd_api.g_exc_error;

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

Line 1132: RAISE fnd_api.g_exc_error;

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

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

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

Line 1203: RAISE fnd_api.g_exc_error;

1199: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1200: l_msg_index := l_msg_index + 1;
1201: l_msg_count := l_msg_count - 1;
1202: END LOOP;
1203: RAISE fnd_api.g_exc_error;
1204: END IF;
1205:
1206: IF l_src_instance_header_tbl.count = 1 THEN -- Records found so update either Serialized or Non Serialized
1207: IF l_src_instance_header_tbl(i).instance_usage_code in (l_out_of_service,

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

1278: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1279: END IF;
1280: l_msg_index := 1;
1281: WHILE l_msg_count > 0 loop
1282: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1283: l_msg_index := l_msg_index + 1;
1284: l_msg_count := l_msg_count - 1;
1285: END LOOP;
1286: RAISE fnd_api.g_exc_error;

Line 1286: RAISE fnd_api.g_exc_error;

1282: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1283: l_msg_index := l_msg_index + 1;
1284: l_msg_count := l_msg_count - 1;
1285: END LOOP;
1286: RAISE fnd_api.g_exc_error;
1287: END IF;
1288: ELSE
1289: l_status := 'In Inventory, Out of Service, Installed, In Service or In Process';
1290: IF (l_debug > 0) THEN

Line 1298: RAISE fnd_api.g_exc_error;

1294: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
1295: fnd_message.set_token('STATUS',l_status);
1296: l_error_message := fnd_message.get;
1297: l_return_status := l_fnd_error;
1298: RAISE fnd_api.g_exc_error;
1299: END IF;
1300:
1301: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
1302: 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 1361: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1357: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1358: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1359: l_msg_index := 1;
1360: WHILE l_msg_count > 0 loop
1361: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1362: l_msg_index := l_msg_index + 1;
1363: l_msg_count := l_msg_count - 1;
1364: END LOOP;
1365: RAISE fnd_api.g_exc_error;

Line 1365: RAISE fnd_api.g_exc_error;

1361: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1362: l_msg_index := l_msg_index + 1;
1363: l_msg_count := l_msg_count - 1;
1364: END LOOP;
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367:
1368: csi_t_gen_utility_pvt.add('Item Instance Created: '||l_new_instance_rec.instance_id);
1369:

Line 1381: RAISE fnd_api.g_exc_error;

1377: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1378: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1379: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1380: l_error_message := fnd_message.get;
1381: RAISE fnd_api.g_exc_error;
1382: END IF; -- Serialized Source IF
1383:
1384: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized
1385:

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

1432: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1433: END IF;
1434: l_msg_index := 1;
1435: WHILE l_msg_count > 0 loop
1436: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1437: l_msg_index := l_msg_index + 1;
1438: l_msg_count := l_msg_count - 1;
1439: END LOOP;
1440: RAISE fnd_api.g_exc_error;

Line 1440: RAISE fnd_api.g_exc_error;

1436: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1437: l_msg_index := l_msg_index + 1;
1438: l_msg_count := l_msg_count - 1;
1439: END LOOP;
1440: RAISE fnd_api.g_exc_error;
1441: END IF;
1442:
1443: l_bypass_qty := 'N';
1444:

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

1517: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1518: END IF;
1519: l_msg_index := 1;
1520: WHILE l_msg_count > 0 loop
1521: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1522: l_msg_index := l_msg_index + 1;
1523: l_msg_count := l_msg_count - 1;
1524: END LOOP;
1525: RAISE fnd_api.g_exc_error;

Line 1525: RAISE fnd_api.g_exc_error;

1521: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1522: l_msg_index := l_msg_index + 1;
1523: l_msg_count := l_msg_count - 1;
1524: END LOOP;
1525: RAISE fnd_api.g_exc_error;
1526: END IF;
1527:
1528: END IF;
1529: END LOOP; -- Out of Service

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

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

Line 1615: RAISE fnd_api.g_exc_error;

1611: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1612: l_msg_index := l_msg_index + 1;
1613: l_msg_count := l_msg_count - 1;
1614: END LOOP;
1615: RAISE fnd_api.g_exc_error;
1616: END IF;
1617:
1618: END IF;
1619: END LOOP; -- Installed

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

1697: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1698: END IF;
1699: l_msg_index := 1;
1700: WHILE l_msg_count > 0 loop
1701: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1702: l_msg_index := l_msg_index + 1;
1703: l_msg_count := l_msg_count - 1;
1704: END LOOP;
1705: RAISE fnd_api.g_exc_error;

Line 1705: RAISE fnd_api.g_exc_error;

1701: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1702: l_msg_index := l_msg_index + 1;
1703: l_msg_count := l_msg_count - 1;
1704: END LOOP;
1705: RAISE fnd_api.g_exc_error;
1706: END IF;
1707:
1708: END IF;
1709: END LOOP; -- In Service

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

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

Line 1762: RAISE fnd_api.g_exc_error;

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

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

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

Line 1833: RAISE fnd_api.g_exc_error;

1829: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1830: l_msg_index := l_msg_index + 1;
1831: l_msg_count := l_msg_count - 1;
1832: END LOOP;
1833: RAISE fnd_api.g_exc_error;
1834: END IF;
1835:
1836: ELSIF l_dest_instance_header_tbl.count = 1 THEN
1837:

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

1885: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1886: END IF;
1887: l_msg_index := 1;
1888: WHILE l_msg_count > 0 loop
1889: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1890: l_msg_index := l_msg_index + 1;
1891: l_msg_count := l_msg_count - 1;
1892: END LOOP;
1893: RAISE fnd_api.g_exc_error;

Line 1893: RAISE fnd_api.g_exc_error;

1889: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1890: l_msg_index := l_msg_index + 1;
1891: l_msg_count := l_msg_count - 1;
1892: END LOOP;
1893: RAISE fnd_api.g_exc_error;
1894: END IF;
1895:
1896: ELSIF l_dest_instance_header_tbl.count > 1 THEN
1897:

Line 1908: RAISE fnd_api.g_exc_error;

1904: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1905: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1906: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1907: l_error_message := fnd_message.get;
1908: RAISE fnd_api.g_exc_error;
1909:
1910: END IF; -- End of Destination Record If
1911: /***
1912: ELSIF l_src_instance_header_tbl.count > 1 THEN

Line 1923: RAISE fnd_api.g_exc_error;

1919: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1920: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1921: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1922: l_error_message := fnd_message.get;
1923: RAISE fnd_api.g_exc_error;
1924: ***/
1925: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
1926:
1927: 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 1974: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1970: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1971: END IF;
1972: l_msg_index := 1;
1973: WHILE l_msg_count > 0 loop
1974: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1975: l_msg_index := l_msg_index + 1;
1976: l_msg_count := l_msg_count - 1;
1977: END LOOP;
1978: RAISE fnd_api.g_exc_error;

Line 1978: RAISE fnd_api.g_exc_error;

1974: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1975: l_msg_index := l_msg_index + 1;
1976: l_msg_count := l_msg_count - 1;
1977: END LOOP;
1978: RAISE fnd_api.g_exc_error;
1979: END IF;
1980:
1981: IF l_dest_instance_header_tbl.count = 0 THEN
1982:

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

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

Line 2049: RAISE fnd_api.g_exc_error;

2045: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2046: l_msg_index := l_msg_index + 1;
2047: l_msg_count := l_msg_count - 1;
2048: END LOOP;
2049: RAISE fnd_api.g_exc_error;
2050: END IF;
2051:
2052: ELSIF l_dest_instance_header_tbl.count = 1 THEN
2053:

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

2101: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2102: END IF;
2103: l_msg_index := 1;
2104: WHILE l_msg_count > 0 loop
2105: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2106: l_msg_index := l_msg_index + 1;
2107: l_msg_count := l_msg_count - 1;
2108: END LOOP;
2109: RAISE fnd_api.g_exc_error;

Line 2109: RAISE fnd_api.g_exc_error;

2105: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2106: l_msg_index := l_msg_index + 1;
2107: l_msg_count := l_msg_count - 1;
2108: END LOOP;
2109: RAISE fnd_api.g_exc_error;
2110: END IF;
2111:
2112: ELSIF l_src_instance_header_tbl.count > 1 THEN
2113: -- Multiple Instances were found so throw error

Line 2123: RAISE fnd_api.g_exc_error;

2119: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2120: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2121: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2122: l_error_message := fnd_message.get;
2123: RAISE fnd_api.g_exc_error;
2124:
2125: END IF; -- End of Destination Record If for checking for In Inventory Records because the Project/Source Instance was not there.
2126: END IF; -- End of No Records Found If
2127: END IF; -- End of Serial Number If

Line 2136: WHEN fnd_api.g_exc_error THEN

2132: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_receipt_hz_loc Transaction procedure*****');
2133: END IF;
2134:
2135: EXCEPTION
2136: WHEN fnd_api.g_exc_error THEN
2137: IF (l_debug > 0) THEN
2138: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2139: END IF;
2140: x_return_status := l_fnd_error;

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

2134:
2135: EXCEPTION
2136: WHEN fnd_api.g_exc_error THEN
2137: IF (l_debug > 0) THEN
2138: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2139: END IF;
2140: x_return_status := l_fnd_error;
2141: x_trx_error_rec.error_text := l_error_message;
2142:

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

2202:
2203: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2204: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2205: l_api_version NUMBER := 1.0;
2206: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2207: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2209: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2210: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

2203: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2204: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2205: l_api_version NUMBER := 1.0;
2206: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2207: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2209: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2210: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2211: l_transaction_id NUMBER := NULL;

Line 2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

2204: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2205: l_api_version NUMBER := 1.0;
2206: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2207: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2209: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2210: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2211: l_transaction_id NUMBER := NULL;
2212: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

2205: l_api_version NUMBER := 1.0;
2206: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2207: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2209: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2210: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2211: l_transaction_id NUMBER := NULL;
2212: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2213: l_object_version_number NUMBER := 1;

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

2206: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2207: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2209: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2210: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2211: l_transaction_id NUMBER := NULL;
2212: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2213: l_object_version_number NUMBER := 1;
2214: l_sysdate DATE := SYSDATE;

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

2208: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2209: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2210: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2211: l_transaction_id NUMBER := NULL;
2212: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2213: l_object_version_number NUMBER := 1;
2214: l_sysdate DATE := SYSDATE;
2215: l_master_organization_id NUMBER;
2216: l_depreciable VARCHAR2(1);

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

2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

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

2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

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

2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 2318: RAISE fnd_api.g_exc_error;

2314: IF NOT l_return_status = l_fnd_success THEN
2315: IF (l_debug > 0) THEN
2316: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2317: END IF;
2318: RAISE fnd_api.g_exc_error;
2319: END IF;
2320:
2321: -- Get the Master Organization ID
2322: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 2331: RAISE fnd_api.g_exc_error;

2327: IF NOT l_return_status = l_fnd_success THEN
2328: IF (l_debug > 0) THEN
2329: 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);
2330: END IF;
2331: RAISE fnd_api.g_exc_error;
2332: END IF;
2333:
2334: -- Call get_fnd_employee_id and get the employee id
2335: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 2371: l_instance_status := FND_API.G_FALSE;

2367: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
2368: l_mtl_item_tbl(i).organization_id);
2369:
2370: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2371: l_instance_status := FND_API.G_FALSE;
2372: ELSE
2373: l_instance_status := FND_API.G_TRUE;
2374: END IF;
2375:

Line 2373: l_instance_status := FND_API.G_TRUE;

2369:
2370: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2371: l_instance_status := FND_API.G_FALSE;
2372: ELSE
2373: l_instance_status := FND_API.G_TRUE;
2374: END IF;
2375:
2376: IF (l_debug > 0) THEN
2377: csi_t_gen_utility_pvt.add('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 2434: RAISE fnd_api.g_exc_error;

2430: IF NOT l_return_status = l_fnd_success THEN
2431: IF (l_debug > 0) THEN
2432: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2433: END IF;
2434: RAISE fnd_api.g_exc_error;
2435: END IF;
2436:
2437: -- Now loop through the PL/SQL Table.
2438: j := 1;

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

2497: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2498: END IF;
2499: l_msg_index := 1;
2500: WHILE l_msg_count > 0 loop
2501: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2502: l_msg_index := l_msg_index + 1;
2503: l_msg_count := l_msg_count - 1;
2504: END LOOP;
2505: RAISE fnd_api.g_exc_error;

Line 2505: RAISE fnd_api.g_exc_error;

2501: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2502: l_msg_index := l_msg_index + 1;
2503: l_msg_count := l_msg_count - 1;
2504: END LOOP;
2505: RAISE fnd_api.g_exc_error;
2506: END IF;
2507:
2508:
2509: IF l_mtl_item_tbl(j).serial_number is NULL THEN

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

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

Line 2582: RAISE fnd_api.g_exc_error;

2578: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2579: l_msg_index := l_msg_index + 1;
2580: l_msg_count := l_msg_count - 1;
2581: END LOOP;
2582: RAISE fnd_api.g_exc_error;
2583: END IF;
2584:
2585: ELSE -- No Records were found and Neg Qtys Not Allowed
2586: IF (l_debug > 0) THEN

Line 2591: RAISE fnd_api.g_exc_error;

2587: csi_t_gen_utility_pvt.add('No Records were found in Install Base andNeg Qtys not allowed to error');
2588: END IF;
2589: fnd_message.set_name('CSI','CSI_NO_NEG_BAL_ALLOWED');
2590: l_error_message := fnd_message.get;
2591: RAISE fnd_api.g_exc_error;
2592:
2593: END IF; -- Neg Qty IF
2594:
2595: ELSIF l_src_instance_header_tbl.count = 1 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.update_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: ELSIF l_src_instance_header_tbl.count > 1 THEN
2662: -- Multiple Instances were found so throw error

Line 2672: RAISE fnd_api.g_exc_error;

2668: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2669: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2670: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2671: l_error_message := fnd_message.get;
2672: RAISE fnd_api.g_exc_error;
2673:
2674: END IF; -- End of Source Record If
2675:
2676: -- Now query and get the destination record.

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

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

Line 2731: RAISE fnd_api.g_exc_error;

2727: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2728: l_msg_index := l_msg_index + 1;
2729: l_msg_count := l_msg_count - 1;
2730: END LOOP;
2731: RAISE fnd_api.g_exc_error;
2732: END IF;
2733:
2734: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found
2735: IF (l_debug > 0) THEN

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

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

Line 2805: RAISE fnd_api.g_exc_error;

2801: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2802: l_msg_index := l_msg_index + 1;
2803: l_msg_count := l_msg_count - 1;
2804: END LOOP;
2805: RAISE fnd_api.g_exc_error;
2806: END IF;
2807:
2808: ELSIF l_dest_instance_header_tbl.count = 1 THEN-- Installed Base Destination Records Found
2809:

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

2861: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2862: END IF;
2863: l_msg_index := 1;
2864: WHILE l_msg_count > 0 loop
2865: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2866: l_msg_index := l_msg_index + 1;
2867: l_msg_count := l_msg_count - 1;
2868: END LOOP;
2869: RAISE fnd_api.g_exc_error;

Line 2869: RAISE fnd_api.g_exc_error;

2865: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2866: l_msg_index := l_msg_index + 1;
2867: l_msg_count := l_msg_count - 1;
2868: END LOOP;
2869: RAISE fnd_api.g_exc_error;
2870: END IF;
2871:
2872: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2873:

Line 2884: RAISE fnd_api.g_exc_error;

2880: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2881: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2882: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2883: l_error_message := fnd_message.get;
2884: RAISE fnd_api.g_exc_error;
2885:
2886: END IF; -- End of Destination Record If
2887:
2888: ELSIF l_mtl_item_tbl(j).serial_number is NOT NULL THEN

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

2948: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2949: END IF;
2950: l_msg_index := 1;
2951: WHILE l_msg_count > 0 loop
2952: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2953: l_msg_index := l_msg_index + 1;
2954: l_msg_count := l_msg_count - 1;
2955: END LOOP;
2956: RAISE fnd_api.g_exc_error;

Line 2956: RAISE fnd_api.g_exc_error;

2952: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2953: l_msg_index := l_msg_index + 1;
2954: l_msg_count := l_msg_count - 1;
2955: END LOOP;
2956: RAISE fnd_api.g_exc_error;
2957: END IF;
2958:
2959: ELSIF l_src_instance_header_tbl.count = 0 THEN
2960: IF (l_debug > 0) THEN

Line 2968: RAISE fnd_api.g_exc_error;

2964: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2965: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2966: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2967: l_error_message := fnd_message.get;
2968: RAISE fnd_api.g_exc_error;
2969:
2970: ELSIF l_src_instance_header_tbl.count > 1 THEN
2971: -- Multiple Instances were found so throw error
2972: IF (l_debug > 0) THEN

Line 2981: RAISE fnd_api.g_exc_error;

2977: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2978: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2979: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2980: l_error_message := fnd_message.get;
2981: RAISE fnd_api.g_exc_error;
2982:
2983: END IF; -- End of Source Record IF for Serialized
2984: END IF; -- End of Source Record If
2985: END LOOP; -- End of For Loop

Line 2993: WHEN fnd_api.g_exc_error THEN

2989: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_issue_hz_loc Transaction procedure*****');
2990: END IF;
2991:
2992: EXCEPTION
2993: WHEN fnd_api.g_exc_error THEN
2994: IF (l_debug > 0) THEN
2995: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2996: END IF;
2997: x_return_status := l_fnd_error;

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

2991:
2992: EXCEPTION
2993: WHEN fnd_api.g_exc_error THEN
2994: IF (l_debug > 0) THEN
2995: csi_t_gen_utility_pvt.add('You have encountered a "fnd_api.g_exc_error" exception');
2996: END IF;
2997: x_return_status := l_fnd_error;
2998:
2999: IF l_mtl_item_tbl.count > 0 THEN