APPS.CSI_INV_INTERORG_PKG dependencies on FND_API

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

18:
19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
26: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
26: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
27: l_transaction_id NUMBER := NULL;

Line 24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
26: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
27: l_transaction_id NUMBER := NULL;
28: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
26: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
27: l_transaction_id NUMBER := NULL;
28: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
29: l_object_version_number NUMBER := 1;

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

22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
26: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
27: l_transaction_id NUMBER := NULL;
28: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
29: l_object_version_number NUMBER := 1;
30: l_sysdate DATE := SYSDATE;

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

24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
26: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
27: l_transaction_id NUMBER := NULL;
28: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
29: l_object_version_number NUMBER := 1;
30: l_sysdate DATE := SYSDATE;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);

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

57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);
60: l_trx_action_type VARCHAR2(50);
61: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
62: l_fnd_warning VARCHAR2(1) := 'W';
63: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

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

59: l_location_type VARCHAR2(20);
60: l_trx_action_type VARCHAR2(50);
61: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
62: l_fnd_warning VARCHAR2(1) := 'W';
63: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

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

60: l_trx_action_type VARCHAR2(50);
61: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
62: l_fnd_warning VARCHAR2(1) := 'W';
63: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
68: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

Line 65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

61: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
62: l_fnd_warning VARCHAR2(1) := 'W';
63: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
68: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
69: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

Line 66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

62: l_fnd_warning VARCHAR2(1) := 'W';
63: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
68: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
69: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
70: l_returned VARCHAR2(25) := 'RETURNED';

Line 67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

63: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
68: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
69: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
70: l_returned VARCHAR2(25) := 'RETURNED';
71: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';

Line 151: RAISE fnd_api.g_exc_error;

147: debug('Inventory Records Found: '||l_tbl_count);
148:
149: IF NOT l_return_status = l_fnd_success THEN
150: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: debug('Transaction Action ID: '||l_mtl_item_tbl(i).transaction_action_id);
155: debug('Transaction Source Type ID: '||l_mtl_item_tbl(i).transaction_source_type_id);

Line 166: RAISE fnd_api.g_exc_error;

162: l_error_message);
163:
164: IF NOT l_return_status = l_fnd_success THEN
165: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
166: RAISE fnd_api.g_exc_error;
167: END IF;
168:
169: -- Call get_fnd_employee_id and get the employee id
170: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 192: l_instance_status := FND_API.G_FALSE;

188: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
189: l_mtl_item_tbl(i).organization_id);
190:
191: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number_control_code in (1,6) THEN
192: l_instance_status := FND_API.G_FALSE;
193: ELSE
194: l_instance_status := FND_API.G_TRUE;
195: END IF;
196:

Line 194: l_instance_status := FND_API.G_TRUE;

190:
191: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number_control_code in (1,6) THEN
192: l_instance_status := FND_API.G_FALSE;
193: ELSE
194: l_instance_status := FND_API.G_TRUE;
195: END IF;
196:
197: debug('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);
198:

Line 232: RAISE fnd_api.g_exc_error;

228:
229: IF NOT l_return_status = l_fnd_success THEN
230: debug('Redeploy Flag: '||l_redeploy_flag);
231: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
232: RAISE fnd_api.g_exc_error;
233: END IF;
234:
235: debug('Redeploy Flag: '||l_redeploy_flag);
236: debug('Trans Status Code: '||l_txn_rec.transaction_status_code);

Line 261: RAISE fnd_api.g_exc_error;

257: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
258:
259: IF NOT l_return_status = l_fnd_success THEN
260: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
261: RAISE fnd_api.g_exc_error;
262: END IF;
263:
264: -- Now loop through the PL/SQL Table.
265: j := 1;

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

359: IF NOT l_return_status = l_fnd_success then
360: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
361: l_msg_index := 1;
362: WHILE l_msg_count > 0 loop
363: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
364: l_msg_index := l_msg_index + 1;
365: l_msg_count := l_msg_count - 1;
366: END LOOP;
367: RAISE fnd_api.g_exc_error;

Line 367: RAISE fnd_api.g_exc_error;

363: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
364: l_msg_index := l_msg_index + 1;
365: l_msg_count := l_msg_count - 1;
366: END LOOP;
367: RAISE fnd_api.g_exc_error;
368: END IF;
369:
370: debug('Before checking to see if Source records Exist - 3');
371:

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

432: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
433: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
434: l_msg_index := 1;
435: WHILE l_msg_count > 0 loop
436: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
437: l_msg_index := l_msg_index + 1;
438: l_msg_count := l_msg_count - 1;
439: END LOOP;
440: RAISE fnd_api.g_exc_error;

Line 440: RAISE fnd_api.g_exc_error;

436: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
437: l_msg_index := l_msg_index + 1;
438: l_msg_count := l_msg_count - 1;
439: END LOOP;
440: RAISE fnd_api.g_exc_error;
441: END IF;
442:
443: ELSE -- No Serialized Instances found so Error.
444:

Line 453: RAISE fnd_api.g_exc_error;

449: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
450: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
451: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
452: l_error_message := fnd_message.get;
453: RAISE fnd_api.g_exc_error;
454: END IF; -- End of Usage Code Check
455:
456: ELSE -- -- Serial Control is 1 ( No Control ) so set to Out Of Enterprise
457:

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

515: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
516: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
517: l_msg_index := 1;
518: WHILE l_msg_count > 0 loop
519: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
520: l_msg_index := l_msg_index + 1;
521: l_msg_count := l_msg_count - 1;
522: END LOOP;
523: RAISE fnd_api.g_exc_error;

Line 523: RAISE fnd_api.g_exc_error;

519: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
520: l_msg_index := l_msg_index + 1;
521: l_msg_count := l_msg_count - 1;
522: END LOOP;
523: RAISE fnd_api.g_exc_error;
524: END IF;
525:
526: IF j = 1 THEN -- Look for IN Transit Non Serial If not there create or Update only 1 time
527: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

578: IF NOT l_return_status = l_fnd_success then
579: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
580: l_msg_index := 1;
581: WHILE l_msg_count > 0 loop
582: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
583: l_msg_index := l_msg_index + 1;
584: l_msg_count := l_msg_count - 1;
585: END LOOP;
586: RAISE fnd_api.g_exc_error;

Line 586: RAISE fnd_api.g_exc_error;

582: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
583: l_msg_index := l_msg_index + 1;
584: l_msg_count := l_msg_count - 1;
585: END LOOP;
586: RAISE fnd_api.g_exc_error;
587: END IF;
588:
589: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
590:

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

647: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
648: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
649: l_msg_index := 1;
650: WHILE l_msg_count > 0 loop
651: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
652: l_msg_index := l_msg_index + 1;
653: l_msg_count := l_msg_count - 1;
654: END LOOP;
655: RAISE fnd_api.g_exc_error;

Line 655: RAISE fnd_api.g_exc_error;

651: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
652: l_msg_index := l_msg_index + 1;
653: l_msg_count := l_msg_count - 1;
654: END LOOP;
655: RAISE fnd_api.g_exc_error;
656: END IF;
657:
658: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
659:

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

717: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
718: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
719: l_msg_index := 1;
720: WHILE l_msg_count > 0 loop
721: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
722: l_msg_index := l_msg_index + 1;
723: l_msg_count := l_msg_count - 1;
724: END LOOP;
725: RAISE fnd_api.g_exc_error;

Line 725: RAISE fnd_api.g_exc_error;

721: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
722: l_msg_index := l_msg_index + 1;
723: l_msg_count := l_msg_count - 1;
724: END LOOP;
725: RAISE fnd_api.g_exc_error;
726: END IF;
727:
728: ELSE -- Error No dest non serial recs round
729: debug('No Records were found in Install Base but the usage is not correct-14, The Usage is: '||l_dest_instance_header_tbl(i).instance_usage_code);

Line 736: RAISE fnd_api.g_exc_error;

732: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
733: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
734: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
735: l_error_message := fnd_message.get;
736: RAISE fnd_api.g_exc_error;
737: END IF; -- End of Destination Record If
738:
739: END IF; -- End of j=1 for Control Code 1
740:

Line 750: RAISE fnd_api.g_exc_error;

746: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
747: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
748: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
749: l_error_message := fnd_message.get;
750: RAISE fnd_api.g_exc_error;
751: END IF; -- End of Usage Code Check if Ship is 2,5 and Rec is 1
752:
753: END IF; -- End of If for Rec Serial Code Check
754:

Line 765: RAISE fnd_api.g_exc_error;

761: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
762: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
763: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
764: l_error_message := fnd_message.get;
765: RAISE fnd_api.g_exc_error;
766:
767: END IF; -- End of 2,5 Serial Control
768:
769: ELSIF l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN

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

827: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
828: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
829: l_msg_index := 1;
830: WHILE l_msg_count > 0 loop
831: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
832: l_msg_index := l_msg_index + 1;
833: l_msg_count := l_msg_count - 1;
834: END LOOP;
835: RAISE fnd_api.g_exc_error;

Line 835: RAISE fnd_api.g_exc_error;

831: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
832: l_msg_index := l_msg_index + 1;
833: l_msg_count := l_msg_count - 1;
834: END LOOP;
835: RAISE fnd_api.g_exc_error;
836: END IF;
837:
838: ELSE -- Neg Code is <> 1 so Neg Qtys are not allowed so error
839: debug('No Records were found in Install Base - 11');

Line 847: RAISE fnd_api.g_exc_error;

843: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
844: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
845: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
846: l_error_message := fnd_message.get;
847: RAISE fnd_api.g_exc_error;
848:
849: END IF; -- End of Neg Qty If
850:
851: ELSIF l_src_instance_header_tbl.count = 1 THEN

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

898: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
899: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
900: l_msg_index := 1;
901: WHILE l_msg_count > 0 loop
902: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
903: l_msg_index := l_msg_index + 1;
904: l_msg_count := l_msg_count - 1;
905: END LOOP;
906: RAISE fnd_api.g_exc_error;

Line 906: RAISE fnd_api.g_exc_error;

902: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
903: l_msg_index := l_msg_index + 1;
904: l_msg_count := l_msg_count - 1;
905: END LOOP;
906: RAISE fnd_api.g_exc_error;
907: END IF;
908:
909: ELSIF l_src_instance_header_tbl.count > 1 THEN
910: -- Multiple Instances were found so throw error

Line 918: RAISE fnd_api.g_exc_error;

914: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
915: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
916: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
917: l_error_message := fnd_message.get;
918: RAISE fnd_api.g_exc_error;
919: END IF; -- End of If for Source Count
920:
921: -- Get Destination Records
922:

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

974: IF NOT l_return_status = l_fnd_success then
975: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
976: l_msg_index := 1;
977: WHILE l_msg_count > 0 loop
978: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
979: l_msg_index := l_msg_index + 1;
980: l_msg_count := l_msg_count - 1;
981: END LOOP;
982: RAISE fnd_api.g_exc_error;

Line 982: RAISE fnd_api.g_exc_error;

978: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
979: l_msg_index := l_msg_index + 1;
980: l_msg_count := l_msg_count - 1;
981: END LOOP;
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
986:

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

1041: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1042: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1043: l_msg_index := 1;
1044: WHILE l_msg_count > 0 loop
1045: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1046: l_msg_index := l_msg_index + 1;
1047: l_msg_count := l_msg_count - 1;
1048: END LOOP;
1049: RAISE fnd_api.g_exc_error;

Line 1049: RAISE fnd_api.g_exc_error;

1045: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1046: l_msg_index := l_msg_index + 1;
1047: l_msg_count := l_msg_count - 1;
1048: END LOOP;
1049: RAISE fnd_api.g_exc_error;
1050: END IF;
1051:
1052: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
1053:

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

1096: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1097: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
1098: l_msg_index := 1;
1099: WHILE l_msg_count > 0 loop
1100: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1101: l_msg_index := l_msg_index + 1;
1102: l_msg_count := l_msg_count - 1;
1103: END LOOP;
1104: RAISE fnd_api.g_exc_error;

Line 1104: RAISE fnd_api.g_exc_error;

1100: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1101: l_msg_index := l_msg_index + 1;
1102: l_msg_count := l_msg_count - 1;
1103: END LOOP;
1104: RAISE fnd_api.g_exc_error;
1105: END IF;
1106:
1107: ELSIF l_dest_instance_header_tbl.count > 1 THEN
1108: -- Multiple Instances were found so throw error

Line 1116: RAISE fnd_api.g_exc_error;

1112: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1113: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1114: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1115: l_error_message := fnd_message.get;
1116: RAISE fnd_api.g_exc_error;
1117:
1118: END IF; -- End of Destination Record If
1119: END IF; -- End of Serial Control If
1120: END LOOP; -- End of For Loop

Line 1126: WHEN fnd_api.g_exc_error THEN

1122: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1123: debug('******End of csi_inv_interorg_pkg.intransit_shipment Transaction******');
1124:
1125: EXCEPTION
1126: WHEN fnd_api.g_exc_error THEN
1127: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction - In Transit Shipment');
1128: x_return_status := l_fnd_error;
1129:
1130: IF l_mtl_item_tbl.count > 0 THEN

Line 1127: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction - In Transit Shipment');

1123: debug('******End of csi_inv_interorg_pkg.intransit_shipment Transaction******');
1124:
1125: EXCEPTION
1126: WHEN fnd_api.g_exc_error THEN
1127: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction - In Transit Shipment');
1128: x_return_status := l_fnd_error;
1129:
1130: IF l_mtl_item_tbl.count > 0 THEN
1131: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

1201:
1202: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1203: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1204: l_api_version NUMBER := 1.0;
1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1208: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1209: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

1202: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1203: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1204: l_api_version NUMBER := 1.0;
1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1208: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1209: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1210: l_transaction_id NUMBER := NULL;

Line 1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1203: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1204: l_api_version NUMBER := 1.0;
1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1208: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1209: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1210: l_transaction_id NUMBER := NULL;
1211: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

1204: l_api_version NUMBER := 1.0;
1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1208: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1209: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1210: l_transaction_id NUMBER := NULL;
1211: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1212: l_object_version_number NUMBER := 1;

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

1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1208: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1209: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1210: l_transaction_id NUMBER := NULL;
1211: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1212: l_object_version_number NUMBER := 1;
1213: l_sysdate DATE := SYSDATE;

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

1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1208: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1209: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1210: l_transaction_id NUMBER := NULL;
1211: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1212: l_object_version_number NUMBER := 1;
1213: l_sysdate DATE := SYSDATE;
1214: l_master_organization_id NUMBER;
1215: l_depreciable VARCHAR2(1);

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

1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1241: l_sub_inventory VARCHAR2(10);
1242: l_location_type VARCHAR2(20);
1243: l_trx_action_type VARCHAR2(50);
1244: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1245: l_fnd_warning VARCHAR2(1) := 'W';
1246: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

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

1242: l_location_type VARCHAR2(20);
1243: l_trx_action_type VARCHAR2(50);
1244: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1245: l_fnd_warning VARCHAR2(1) := 'W';
1246: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

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

1243: l_trx_action_type VARCHAR2(50);
1244: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1245: l_fnd_warning VARCHAR2(1) := 'W';
1246: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1251: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

Line 1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

1244: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1245: l_fnd_warning VARCHAR2(1) := 'W';
1246: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1251: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1252: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

Line 1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

1245: l_fnd_warning VARCHAR2(1) := 'W';
1246: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1251: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1252: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1253: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';

Line 1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

1246: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1251: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1252: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1253: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1254: l_returned VARCHAR2(25) := 'RETURNED';

Line 1342: RAISE fnd_api.g_exc_error;

1338: debug('Inventory Records Found: '||l_tbl_count);
1339:
1340: IF NOT l_return_status = l_fnd_success THEN
1341: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
1342: RAISE fnd_api.g_exc_error;
1343: END IF;
1344:
1345: debug('Transaction Action ID: '||l_mtl_item_tbl(i).transaction_action_id);
1346: debug('Transaction Source Type ID: '||l_mtl_item_tbl(i).transaction_source_type_id);

Line 1357: RAISE fnd_api.g_exc_error;

1353: l_error_message);
1354:
1355: IF NOT l_return_status = l_fnd_success THEN
1356: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
1357: RAISE fnd_api.g_exc_error;
1358: END IF;
1359:
1360: -- Call get_fnd_employee_id and get the employee id
1361: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 1415: RAISE fnd_api.g_exc_error;

1411:
1412: IF NOT l_return_status = l_fnd_success THEN
1413: debug('Redeploy Flag: '||l_redeploy_flag);
1414: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417:
1418: debug('Redeploy Flag: '||l_redeploy_flag);
1419: debug('Trans Status Code: '||l_txn_rec.transaction_status_code);

Line 1444: RAISE fnd_api.g_exc_error;

1440: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
1441:
1442: IF NOT l_return_status = l_fnd_success THEN
1443: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1444: RAISE fnd_api.g_exc_error;
1445: END IF;
1446:
1447: -- Now loop through the PL/SQL Table.
1448: j := 1;

Line 1467: l_instance_status := FND_API.G_FALSE;

1463: FOR j in l_mtl_item_tbl.FIRST .. l_mtl_item_tbl.LAST LOOP
1464:
1465: IF (l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6)) OR
1466: (l_mtl_item_tbl(j).serial_number_control_code in (2,5)) THEN
1467: l_instance_status := FND_API.G_FALSE;
1468: ELSE
1469: l_instance_status := FND_API.G_TRUE;
1470: END IF;
1471:

Line 1469: l_instance_status := FND_API.G_TRUE;

1465: IF (l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6)) OR
1466: (l_mtl_item_tbl(j).serial_number_control_code in (2,5)) THEN
1467: l_instance_status := FND_API.G_FALSE;
1468: ELSE
1469: l_instance_status := FND_API.G_TRUE;
1470: END IF;
1471:
1472: debug('Primary UOM: '||l_mtl_item_tbl(j).primary_uom_code);
1473: debug('Primary Qty: '||l_mtl_item_tbl(j).primary_quantity);

Line 1527: l_instance_status := FND_API.G_TRUE;

1523:
1524: debug('Set Serial Number to G MISS');
1525:
1526: --bug 12420630 - Consider only valid item instances as we need to expire them again.
1527: l_instance_status := FND_API.G_TRUE;
1528: debug('l_instance_status: '||l_instance_status);
1529:
1530: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 1 AND
1531: l_sr_control in (2,5)) OR

Line 1550: l_instance_status := FND_API.G_TRUE;

1546: l_instance_usage_code := l_instance_query_rec.instance_usage_code;
1547:
1548: debug('Set Serial Number to NULL-1');
1549: --bug 13359345&13393687 - Consider only valid item instances as we need to expire them again.
1550: l_instance_status := FND_API.G_TRUE;
1551: debug('l_instance_status: '||l_instance_status);
1552:
1553: ELSIF (l_mtl_item_tbl(j).serial_number_control_code in (6,1) AND
1554: l_sr_control in (6,1)) THEN

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

1616: IF NOT l_return_status = l_fnd_success then
1617: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1618: l_msg_index := 1;
1619: WHILE l_msg_count > 0 loop
1620: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1621: l_msg_index := l_msg_index + 1;
1622: l_msg_count := l_msg_count - 1;
1623: END LOOP;
1624: RAISE fnd_api.g_exc_error;

Line 1624: RAISE fnd_api.g_exc_error;

1620: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1621: l_msg_index := l_msg_index + 1;
1622: l_msg_count := l_msg_count - 1;
1623: END LOOP;
1624: RAISE fnd_api.g_exc_error;
1625: END IF;
1626:
1627: IF l_src_instance_header_tbl.count > 0 OR
1628: l_12_loop = 1 THEN -- Installed Base Records Found

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

1704: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1705: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1706: l_msg_index := 1;
1707: WHILE l_msg_count > 0 loop
1708: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1709: l_msg_index := l_msg_index + 1;
1710: l_msg_count := l_msg_count - 1;
1711: END LOOP;
1712: RAISE fnd_api.g_exc_error;

Line 1712: RAISE fnd_api.g_exc_error;

1708: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1709: l_msg_index := l_msg_index + 1;
1710: l_msg_count := l_msg_count - 1;
1711: END LOOP;
1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714:
1715:
1716: ELSIF l_mtl_item_tbl(j).serial_number_control_code in (2,5) AND

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

1772: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1773: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
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: END IF; -- End of J = 1 If to update Source 1 time
1783:
1784: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances

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

1834: IF NOT l_return_status = l_fnd_success then
1835: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1836: l_msg_index := 1;
1837: WHILE l_msg_count > 0 loop
1838: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1839: l_msg_index := l_msg_index + 1;
1840: l_msg_count := l_msg_count - 1;
1841: END LOOP;
1842: RAISE fnd_api.g_exc_error;

Line 1842: RAISE fnd_api.g_exc_error;

1838: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1839: l_msg_index := l_msg_index + 1;
1840: l_msg_count := l_msg_count - 1;
1841: END LOOP;
1842: RAISE fnd_api.g_exc_error;
1843: END IF;
1844:
1845: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
1846:

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

1903: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1904: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1905: l_msg_index := 1;
1906: WHILE l_msg_count > 0 loop
1907: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1908: l_msg_index := l_msg_index + 1;
1909: l_msg_count := l_msg_count - 1;
1910: END LOOP;
1911: RAISE fnd_api.g_exc_error;

Line 1911: RAISE fnd_api.g_exc_error;

1907: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1908: l_msg_index := l_msg_index + 1;
1909: l_msg_count := l_msg_count - 1;
1910: END LOOP;
1911: RAISE fnd_api.g_exc_error;
1912: END IF;
1913:
1914: ELSIF l_dest_instance_header_tbl.count > 0 THEN
1915: IF l_dest_instance_header_tbl(i).instance_usage_code in (l_in_inventory,l_in_transit,l_returned) THEN -- Installed Base Destination Records Found

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

1978: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1979: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
1980: l_msg_index := 1;
1981: WHILE l_msg_count > 0 loop
1982: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1983: l_msg_index := l_msg_index + 1;
1984: l_msg_count := l_msg_count - 1;
1985: END LOOP;
1986: RAISE fnd_api.g_exc_error;

Line 1986: RAISE fnd_api.g_exc_error;

1982: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1983: l_msg_index := l_msg_index + 1;
1984: l_msg_count := l_msg_count - 1;
1985: END LOOP;
1986: RAISE fnd_api.g_exc_error;
1987: END IF;
1988:
1989: ELSIF l_dest_instance_header_tbl(i).instance_usage_code = l_out_of_enterprise THEN
1990:

Line 2037: fnd_api.g_true, -- Get Parties

2033: l_commit,
2034: l_init_msg_list,
2035: l_validation_level,
2036: l_instance_header_rec,
2037: fnd_api.g_true, -- Get Parties
2038: l_party_header_tbl,
2039: fnd_api.g_false, -- Get Accounts
2040: l_account_header_tbl,
2041: fnd_api.g_false, -- Get Org Assi.

Line 2039: fnd_api.g_false, -- Get Accounts

2035: l_validation_level,
2036: l_instance_header_rec,
2037: fnd_api.g_true, -- Get Parties
2038: l_party_header_tbl,
2039: fnd_api.g_false, -- Get Accounts
2040: l_account_header_tbl,
2041: fnd_api.g_false, -- Get Org Assi.
2042: l_org_header_tbl,
2043: fnd_api.g_false, -- Get Price Att

Line 2041: fnd_api.g_false, -- Get Org Assi.

2037: fnd_api.g_true, -- Get Parties
2038: l_party_header_tbl,
2039: fnd_api.g_false, -- Get Accounts
2040: l_account_header_tbl,
2041: fnd_api.g_false, -- Get Org Assi.
2042: l_org_header_tbl,
2043: fnd_api.g_false, -- Get Price Att
2044: l_pricing_header_tbl,
2045: fnd_api.g_false, -- Get Ext Attr

Line 2043: fnd_api.g_false, -- Get Price Att

2039: fnd_api.g_false, -- Get Accounts
2040: l_account_header_tbl,
2041: fnd_api.g_false, -- Get Org Assi.
2042: l_org_header_tbl,
2043: fnd_api.g_false, -- Get Price Att
2044: l_pricing_header_tbl,
2045: fnd_api.g_false, -- Get Ext Attr
2046: l_ext_attrib_header_tbl,
2047: l_ext_attrib_def_tbl,

Line 2045: fnd_api.g_false, -- Get Ext Attr

2041: fnd_api.g_false, -- Get Org Assi.
2042: l_org_header_tbl,
2043: fnd_api.g_false, -- Get Price Att
2044: l_pricing_header_tbl,
2045: fnd_api.g_false, -- Get Ext Attr
2046: l_ext_attrib_header_tbl,
2047: l_ext_attrib_def_tbl,
2048: fnd_api.g_false, -- Get Asset Assi
2049: l_asset_header_tbl,

Line 2048: fnd_api.g_false, -- Get Asset Assi

2044: l_pricing_header_tbl,
2045: fnd_api.g_false, -- Get Ext Attr
2046: l_ext_attrib_header_tbl,
2047: l_ext_attrib_def_tbl,
2048: fnd_api.g_false, -- Get Asset Assi
2049: l_asset_header_tbl,
2050: fnd_api.g_false, -- Resolve IDs
2051: NULL, -- Time Stamp
2052: l_return_status,

Line 2050: fnd_api.g_false, -- Resolve IDs

2046: l_ext_attrib_header_tbl,
2047: l_ext_attrib_def_tbl,
2048: fnd_api.g_false, -- Get Asset Assi
2049: l_asset_header_tbl,
2050: fnd_api.g_false, -- Resolve IDs
2051: NULL, -- Time Stamp
2052: l_return_status,
2053: l_msg_count,
2054: l_msg_data);

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

2121: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2122: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2123: l_msg_index := 1;
2124: WHILE l_msg_count > 0 loop
2125: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2126: l_msg_index := l_msg_index + 1;
2127: l_msg_count := l_msg_count - 1;
2128: END LOOP;
2129: RAISE fnd_api.g_exc_error;

Line 2129: RAISE fnd_api.g_exc_error;

2125: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2126: l_msg_index := l_msg_index + 1;
2127: l_msg_count := l_msg_count - 1;
2128: END LOOP;
2129: RAISE fnd_api.g_exc_error;
2130: END IF;
2131: ELSE
2132: l_status := 'In Inventory, Out of Service or Out of Enterprise';
2133: debug('Serialized Item with Out of Enterprise exists however the ownership_override_at_txn flag is set to N so we will NOT bring this back into inventory');

Line 2139: RAISE fnd_api.g_exc_error;

2135: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
2136: fnd_message.set_token('STATUS',l_status);
2137: l_error_message := fnd_message.get;
2138: l_return_status := l_fnd_error;
2139: RAISE fnd_api.g_exc_error;
2140: END IF;
2141:
2142: ELSE
2143: l_status := 'IN_INVENTORY OR IN_TRANSIT';

Line 2149: RAISE fnd_api.g_exc_error;

2145: debug('Instance Usage Code is: '||l_dest_instance_header_tbl(i).instance_usage_code);
2146: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
2147: fnd_message.set_token('STATUS',l_status);
2148: l_error_message := fnd_message.get;
2149: RAISE fnd_api.g_exc_error;
2150: END IF;
2151: END IF; -- End of Destination Record If
2152:
2153: ELSIF l_mtl_item_tbl(j).serial_number_control_code = 1 AND

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

2210: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2211: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2212: l_msg_index := 1;
2213: WHILE l_msg_count > 0 loop
2214: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2215: l_msg_index := l_msg_index + 1;
2216: l_msg_count := l_msg_count - 1;
2217: END LOOP;
2218: RAISE fnd_api.g_exc_error;

Line 2218: RAISE fnd_api.g_exc_error;

2214: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2215: l_msg_index := l_msg_index + 1;
2216: l_msg_count := l_msg_count - 1;
2217: END LOOP;
2218: RAISE fnd_api.g_exc_error;
2219: END IF;
2220:
2221: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2222: debug('J is 1 so query for Non Serialized item 1 time - 23');

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

2263: IF NOT l_return_status = l_fnd_success then
2264: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2265: l_msg_index := 1;
2266: WHILE l_msg_count > 0 loop
2267: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2268: l_msg_index := l_msg_index + 1;
2269: l_msg_count := l_msg_count - 1;
2270: END LOOP;
2271: RAISE fnd_api.g_exc_error;

Line 2271: RAISE fnd_api.g_exc_error;

2267: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2268: l_msg_index := l_msg_index + 1;
2269: l_msg_count := l_msg_count - 1;
2270: END LOOP;
2271: RAISE fnd_api.g_exc_error;
2272: END IF;
2273:
2274: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2275:

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

2330: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2331: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2332: l_msg_index := 1;
2333: WHILE l_msg_count > 0 loop
2334: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2335: l_msg_index := l_msg_index + 1;
2336: l_msg_count := l_msg_count - 1;
2337: END LOOP;
2338: RAISE fnd_api.g_exc_error;

Line 2338: RAISE fnd_api.g_exc_error;

2334: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2335: l_msg_index := l_msg_index + 1;
2336: l_msg_count := l_msg_count - 1;
2337: END LOOP;
2338: RAISE fnd_api.g_exc_error;
2339: END IF;
2340:
2341: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2342:

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

2386: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2387: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2388: l_msg_index := 1;
2389: WHILE l_msg_count > 0 loop
2390: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2391: l_msg_index := l_msg_index + 1;
2392: l_msg_count := l_msg_count - 1;
2393: END LOOP;
2394: RAISE fnd_api.g_exc_error;

Line 2394: RAISE fnd_api.g_exc_error;

2390: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2391: l_msg_index := l_msg_index + 1;
2392: l_msg_count := l_msg_count - 1;
2393: END LOOP;
2394: RAISE fnd_api.g_exc_error;
2395: END IF;
2396:
2397: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2398: -- Multiple Instances were found so throw error

Line 2406: RAISE fnd_api.g_exc_error;

2402: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2403: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2404: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2405: l_error_message := fnd_message.get;
2406: RAISE fnd_api.g_exc_error;
2407:
2408: END IF; -- End of Destination Record If
2409:
2410: ELSIF l_mtl_item_tbl(j).serial_number_control_code = 6 AND

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

2469: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2470: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2471: l_msg_index := 1;
2472: WHILE l_msg_count > 0 loop
2473: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2474: l_msg_index := l_msg_index + 1;
2475: l_msg_count := l_msg_count - 1;
2476: END LOOP;
2477: RAISE fnd_api.g_exc_error;

Line 2477: RAISE fnd_api.g_exc_error;

2473: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2474: l_msg_index := l_msg_index + 1;
2475: l_msg_count := l_msg_count - 1;
2476: END LOOP;
2477: RAISE fnd_api.g_exc_error;
2478: END IF;
2479: END LOOP; -- End Header Tbl and Trans Qty Loop
2480:
2481: -- Now Query for Non Serialized In Inventory Record 1 Time Only

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

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

Line 2532: RAISE fnd_api.g_exc_error;

2528: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2529: l_msg_index := l_msg_index + 1;
2530: l_msg_count := l_msg_count - 1;
2531: END LOOP;
2532: RAISE fnd_api.g_exc_error;
2533: END IF;
2534:
2535: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2536:

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

2591: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2592: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2593: l_msg_index := 1;
2594: WHILE l_msg_count > 0 loop
2595: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2596: l_msg_index := l_msg_index + 1;
2597: l_msg_count := l_msg_count - 1;
2598: END LOOP;
2599: RAISE fnd_api.g_exc_error;

Line 2599: RAISE fnd_api.g_exc_error;

2595: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2596: l_msg_index := l_msg_index + 1;
2597: l_msg_count := l_msg_count - 1;
2598: END LOOP;
2599: RAISE fnd_api.g_exc_error;
2600: END IF;
2601:
2602: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2603:

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

2647: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2648: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2649: l_msg_index := 1;
2650: WHILE l_msg_count > 0 loop
2651: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2652: l_msg_index := l_msg_index + 1;
2653: l_msg_count := l_msg_count - 1;
2654: END LOOP;
2655: RAISE fnd_api.g_exc_error;

Line 2655: RAISE fnd_api.g_exc_error;

2651: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2652: l_msg_index := l_msg_index + 1;
2653: l_msg_count := l_msg_count - 1;
2654: END LOOP;
2655: RAISE fnd_api.g_exc_error;
2656: END IF;
2657:
2658: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2659: -- Multiple Instances were found so throw error

Line 2667: RAISE fnd_api.g_exc_error;

2663: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2664: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2665: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2666: l_error_message := fnd_message.get;
2667: RAISE fnd_api.g_exc_error;
2668:
2669: END IF; -- End of Destination Record If
2670: END IF; -- End of J Index Loop
2671:

Line 2688: l_upd_src_dest_instance_rec.check_for_instance_expiry := fnd_api.g_false;

2684: -- If the org can accept negative quantity
2685: -- then instances with zero can be updated
2686: IF l_neg_code = 1 THEN
2687: debug('The Org accepts negative quantity. Setting the check_for_instance_expiry to False');
2688: l_upd_src_dest_instance_rec.check_for_instance_expiry := fnd_api.g_false;
2689: END IF; -- l_neg_code = 1
2690: -- End of Bug 12420630
2691:
2692:

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

2730: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2731: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2732: l_msg_index := 1;
2733: WHILE l_msg_count > 0 loop
2734: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2735: l_msg_index := l_msg_index + 1;
2736: l_msg_count := l_msg_count - 1;
2737: END LOOP;
2738: RAISE fnd_api.g_exc_error;

Line 2738: RAISE fnd_api.g_exc_error;

2734: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2735: l_msg_index := l_msg_index + 1;
2736: l_msg_count := l_msg_count - 1;
2737: END LOOP;
2738: RAISE fnd_api.g_exc_error;
2739: END IF;
2740:
2741: -- Get Destination Record
2742:

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

2782: IF NOT l_return_status = l_fnd_success then
2783: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2784: l_msg_index := 1;
2785: WHILE l_msg_count > 0 loop
2786: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2787: l_msg_index := l_msg_index + 1;
2788: l_msg_count := l_msg_count - 1;
2789: END LOOP;
2790: RAISE fnd_api.g_exc_error;

Line 2790: RAISE fnd_api.g_exc_error;

2786: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2787: l_msg_index := l_msg_index + 1;
2788: l_msg_count := l_msg_count - 1;
2789: END LOOP;
2790: RAISE fnd_api.g_exc_error;
2791: END IF;
2792:
2793: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2794:

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

2849: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2850: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2851: l_msg_index := 1;
2852: WHILE l_msg_count > 0 loop
2853: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2854: l_msg_index := l_msg_index + 1;
2855: l_msg_count := l_msg_count - 1;
2856: END LOOP;
2857: RAISE fnd_api.g_exc_error;

Line 2857: RAISE fnd_api.g_exc_error;

2853: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2854: l_msg_index := l_msg_index + 1;
2855: l_msg_count := l_msg_count - 1;
2856: END LOOP;
2857: RAISE fnd_api.g_exc_error;
2858: END IF;
2859:
2860: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2861:

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

2904: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2905: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2906: l_msg_index := 1;
2907: WHILE l_msg_count > 0 loop
2908: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2909: l_msg_index := l_msg_index + 1;
2910: l_msg_count := l_msg_count - 1;
2911: END LOOP;
2912: RAISE fnd_api.g_exc_error;

Line 2912: RAISE fnd_api.g_exc_error;

2908: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2909: l_msg_index := l_msg_index + 1;
2910: l_msg_count := l_msg_count - 1;
2911: END LOOP;
2912: RAISE fnd_api.g_exc_error;
2913: END IF;
2914:
2915: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2916: -- Multiple Instances were found so throw error

Line 2924: RAISE fnd_api.g_exc_error;

2920: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2921: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2922: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2923: l_error_message := fnd_message.get;
2924: RAISE fnd_api.g_exc_error;
2925: END IF; -- End of Destination Record If
2926:
2927: ELSE -- No Records Found So throw Error
2928: debug('No Records were found in Install Base - 48');

Line 2936: RAISE fnd_api.g_exc_error;

2932: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2933: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2934: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2935: l_error_message := fnd_message.get;
2936: RAISE fnd_api.g_exc_error;
2937:
2938: END IF; -- Serial Control IF
2939:
2940: ELSE

Line 2949: RAISE fnd_api.g_exc_error;

2945: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2946: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2947: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2948: l_error_message := fnd_message.get;
2949: RAISE fnd_api.g_exc_error;
2950:
2951: END IF; -- End of Main Source Header Tbl IF
2952: END LOOP; -- End of For Loop
2953:

Line 2959: WHEN fnd_api.g_exc_error THEN

2955: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2956: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');
2957:
2958: EXCEPTION
2959: WHEN fnd_api.g_exc_error THEN
2960: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');
2961: x_return_status := l_fnd_error;
2962:
2963: IF l_mtl_item_tbl.count > 0 THEN

Line 2960: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');

2956: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');
2957:
2958: EXCEPTION
2959: WHEN fnd_api.g_exc_error THEN
2960: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');
2961: x_return_status := l_fnd_error;
2962:
2963: IF l_mtl_item_tbl.count > 0 THEN
2964: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

3032:
3033: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
3034: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
3035: l_api_version NUMBER := 1.0;
3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3039: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
3040: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

3033: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
3034: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
3035: l_api_version NUMBER := 1.0;
3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3039: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
3040: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
3041: l_transaction_id NUMBER := NULL;

Line 3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

3034: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
3035: l_api_version NUMBER := 1.0;
3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3039: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
3040: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
3041: l_transaction_id NUMBER := NULL;
3042: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

3035: l_api_version NUMBER := 1.0;
3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3039: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
3040: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
3041: l_transaction_id NUMBER := NULL;
3042: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
3043: l_object_version_number NUMBER := 1;

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

3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3039: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
3040: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
3041: l_transaction_id NUMBER := NULL;
3042: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
3043: l_object_version_number NUMBER := 1;
3044: l_sysdate DATE := SYSDATE;

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

3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3039: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
3040: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
3041: l_transaction_id NUMBER := NULL;
3042: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
3043: l_object_version_number NUMBER := 1;
3044: l_sysdate DATE := SYSDATE;
3045: l_master_organization_id NUMBER;
3046: l_depreciable VARCHAR2(1);

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

3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3072: l_sub_inventory VARCHAR2(10);
3073: l_location_type VARCHAR2(20);
3074: l_trx_action_type VARCHAR2(50);
3075: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3076: l_fnd_warning VARCHAR2(1) := 'W';
3077: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

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

3073: l_location_type VARCHAR2(20);
3074: l_trx_action_type VARCHAR2(50);
3075: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3076: l_fnd_warning VARCHAR2(1) := 'W';
3077: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

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

3074: l_trx_action_type VARCHAR2(50);
3075: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3076: l_fnd_warning VARCHAR2(1) := 'W';
3077: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3088: l_instance_usage_code VARCHAR2(25);
3089: l_organization_id NUMBER;

Line 3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3088: l_instance_usage_code VARCHAR2(25);
3089: l_organization_id NUMBER;
3090: l_subinventory_name VARCHAR2(10);

Line 3087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3088: l_instance_usage_code VARCHAR2(25);
3089: l_organization_id NUMBER;
3090: l_subinventory_name VARCHAR2(10);
3091: l_locator_id NUMBER;

Line 3199: RAISE fnd_api.g_exc_error;

3195: debug('Inventory Records Found: '||l_tbl_count);
3196:
3197: IF NOT l_return_status = l_fnd_success THEN
3198: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);
3199: RAISE fnd_api.g_exc_error;
3200: END IF;
3201:
3202: -- Get the Master Organization ID
3203: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 3210: RAISE fnd_api.g_exc_error;

3206: l_error_message);
3207:
3208: IF NOT l_return_status = l_fnd_success THEN
3209: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
3210: RAISE fnd_api.g_exc_error;
3211: END IF;
3212:
3213: -- Call get_fnd_employee_id and get the employee id
3214: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 3278: RAISE fnd_api.g_exc_error;

3274:
3275: IF NOT l_return_status = l_fnd_success THEN
3276: debug('Redeploy Flag: '||l_redeploy_flag);
3277: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
3278: RAISE fnd_api.g_exc_error;
3279: END IF;
3280:
3281: debug('Redeploy Flag: '||l_redeploy_flag);
3282: debug('Trans Status Code: '||l_txn_rec.transaction_status_code);

Line 3313: RAISE fnd_api.g_exc_error;

3309: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
3310:
3311: IF NOT l_return_status = l_fnd_success THEN
3312: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
3313: RAISE fnd_api.g_exc_error;
3314: END IF;
3315:
3316: -- Now loop through the PL/SQL Table.
3317: j := 1;

Line 3354: l_instance_status := FND_API.G_FALSE;

3350: debug('Receiving Org Trackable Flag: '||r_item_control.comms_nl_trackable_flag);
3351:
3352: -- Set Query Instance Status
3353: IF l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN
3354: l_instance_status := FND_API.G_FALSE;
3355: ELSE
3356: l_instance_status := FND_API.G_TRUE;
3357: END IF;
3358:

Line 3356: l_instance_status := FND_API.G_TRUE;

3352: -- Set Query Instance Status
3353: IF l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN
3354: l_instance_status := FND_API.G_FALSE;
3355: ELSE
3356: l_instance_status := FND_API.G_TRUE;
3357: END IF;
3358:
3359: debug('Query Inst Status : '||l_instance_status);
3360:

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

3419: IF NOT l_return_status = l_fnd_success then
3420: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
3421: l_msg_index := 1;
3422: WHILE l_msg_count > 0 loop
3423: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3424: l_msg_index := l_msg_index + 1;
3425: l_msg_count := l_msg_count - 1;
3426: END LOOP;
3427: RAISE fnd_api.g_exc_error;

Line 3427: RAISE fnd_api.g_exc_error;

3423: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3424: l_msg_index := l_msg_index + 1;
3425: l_msg_count := l_msg_count - 1;
3426: END LOOP;
3427: RAISE fnd_api.g_exc_error;
3428: END IF;
3429:
3430: debug('Before checking to see if Source records Exist - 1');
3431:

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

3491: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3492: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3493: l_msg_index := 1;
3494: WHILE l_msg_count > 0 loop
3495: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3496: l_msg_index := l_msg_index + 1;
3497: l_msg_count := l_msg_count - 1;
3498: END LOOP;
3499: RAISE fnd_api.g_exc_error;

Line 3499: RAISE fnd_api.g_exc_error;

3495: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3496: l_msg_index := l_msg_index + 1;
3497: l_msg_count := l_msg_count - 1;
3498: END LOOP;
3499: RAISE fnd_api.g_exc_error;
3500: END IF;
3501:
3502: ELSE -- No Src Records found so error
3503:

Line 3511: RAISE fnd_api.g_exc_error;

3507: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3508: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3509: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3510: l_error_message := fnd_message.get;
3511: RAISE fnd_api.g_exc_error;
3512: END IF; -- End of 5 and 2,5 IF
3513:
3514: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 6 AND -- Ship
3515: l_sr_control = 6) OR -- Rec

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

3581: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3582: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
3583: l_msg_index := 1;
3584: WHILE l_msg_count > 0 loop
3585: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3586: l_msg_index := l_msg_index + 1;
3587: l_msg_count := l_msg_count - 1;
3588: END LOOP;
3589: RAISE fnd_api.g_exc_error;

Line 3589: RAISE fnd_api.g_exc_error;

3585: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3586: l_msg_index := l_msg_index + 1;
3587: l_msg_count := l_msg_count - 1;
3588: END LOOP;
3589: RAISE fnd_api.g_exc_error;
3590: END IF;
3591: ELSE -- Inv Does not allowe neg qty and source is not found
3592: debug('No Records were found in Install Base - 9');
3593: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

Line 3599: RAISE fnd_api.g_exc_error;

3595: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3596: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3597: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3598: l_error_message := fnd_message.get;
3599: RAISE fnd_api.g_exc_error;
3600:
3601: END IF; -- End of Neg Qty IF
3602: ELSIF l_src_instance_header_tbl.count = 1 THEN -- Source Records are found
3603:

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

3658: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3659: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3660: l_msg_index := 1;
3661: WHILE l_msg_count > 0 loop
3662: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3663: l_msg_index := l_msg_index + 1;
3664: l_msg_count := l_msg_count - 1;
3665: END LOOP;
3666: RAISE fnd_api.g_exc_error;

Line 3666: RAISE fnd_api.g_exc_error;

3662: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3663: l_msg_index := l_msg_index + 1;
3664: l_msg_count := l_msg_count - 1;
3665: END LOOP;
3666: RAISE fnd_api.g_exc_error;
3667: END IF;
3668:
3669: ELSE -- Error No Src Recs and Inv Does not allow neg qtys
3670: debug('No Records were found in Install Base - 12');

Line 3677: RAISE fnd_api.g_exc_error;

3673: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3674: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3675: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3676: l_error_message := fnd_message.get;
3677: RAISE fnd_api.g_exc_error;
3678: END IF; -- End of If for Main Source
3679:
3680: -- Get Destination Records
3681:

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

3722: IF NOT l_return_status = l_fnd_success then
3723: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
3724: l_msg_index := 1;
3725: WHILE l_msg_count > 0 loop
3726: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3727: l_msg_index := l_msg_index + 1;
3728: l_msg_count := l_msg_count - 1;
3729: END LOOP;
3730: RAISE fnd_api.g_exc_error;

Line 3730: RAISE fnd_api.g_exc_error;

3726: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3727: l_msg_index := l_msg_index + 1;
3728: l_msg_count := l_msg_count - 1;
3729: END LOOP;
3730: RAISE fnd_api.g_exc_error;
3731: END IF;
3732:
3733: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3734:

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

3789: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3790: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
3791: l_msg_index := 1;
3792: WHILE l_msg_count > 0 loop
3793: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3794: l_msg_index := l_msg_index + 1;
3795: l_msg_count := l_msg_count - 1;
3796: END LOOP;
3797: RAISE fnd_api.g_exc_error;

Line 3797: RAISE fnd_api.g_exc_error;

3793: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3794: l_msg_index := l_msg_index + 1;
3795: l_msg_count := l_msg_count - 1;
3796: END LOOP;
3797: RAISE fnd_api.g_exc_error;
3798: END IF;
3799:
3800: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3801:

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

3845: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3846: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
3847: l_msg_index := 1;
3848: WHILE l_msg_count > 0 loop
3849: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3850: l_msg_index := l_msg_index + 1;
3851: l_msg_count := l_msg_count - 1;
3852: END LOOP;
3853: RAISE fnd_api.g_exc_error;

Line 3853: RAISE fnd_api.g_exc_error;

3849: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3850: l_msg_index := l_msg_index + 1;
3851: l_msg_count := l_msg_count - 1;
3852: END LOOP;
3853: RAISE fnd_api.g_exc_error;
3854: END IF;
3855:
3856: ELSIF l_dest_instance_header_tbl.count > 1 THEN
3857: -- Multiple Instances were found so throw error

Line 3865: RAISE fnd_api.g_exc_error;

3861: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3862: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3863: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3864: l_error_message := fnd_message.get;
3865: RAISE fnd_api.g_exc_error;
3866: END IF; -- End of Destination Record If
3867:
3868: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 5 AND -- Ship
3869: l_sr_control = 1) OR -- Rec

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

3924: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3925: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3926: l_msg_index := 1;
3927: WHILE l_msg_count > 0 loop
3928: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3929: l_msg_index := l_msg_index + 1;
3930: l_msg_count := l_msg_count - 1;
3931: END LOOP;
3932: RAISE fnd_api.g_exc_error;

Line 3932: RAISE fnd_api.g_exc_error;

3928: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3929: l_msg_index := l_msg_index + 1;
3930: l_msg_count := l_msg_count - 1;
3931: END LOOP;
3932: RAISE fnd_api.g_exc_error;
3933: END IF;
3934: -- END LOOP; -- End For Loop for Update of Sr Instances
3935:
3936: -- Now Query for Non Serialized In Inventory Record 1 Time Only

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

3978: IF NOT l_return_status = l_fnd_success then
3979: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
3980: l_msg_index := 1;
3981: WHILE l_msg_count > 0 loop
3982: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3983: l_msg_index := l_msg_index + 1;
3984: l_msg_count := l_msg_count - 1;
3985: END LOOP;
3986: RAISE fnd_api.g_exc_error;

Line 3986: RAISE fnd_api.g_exc_error;

3982: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3983: l_msg_index := l_msg_index + 1;
3984: l_msg_count := l_msg_count - 1;
3985: END LOOP;
3986: RAISE fnd_api.g_exc_error;
3987: END IF;
3988:
3989: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3990:

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

4045: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
4046: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
4047: l_msg_index := 1;
4048: WHILE l_msg_count > 0 loop
4049: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
4050: l_msg_index := l_msg_index + 1;
4051: l_msg_count := l_msg_count - 1;
4052: END LOOP;
4053: RAISE fnd_api.g_exc_error;

Line 4053: RAISE fnd_api.g_exc_error;

4049: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
4050: l_msg_index := l_msg_index + 1;
4051: l_msg_count := l_msg_count - 1;
4052: END LOOP;
4053: RAISE fnd_api.g_exc_error;
4054: END IF;
4055:
4056: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
4057:

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

4100: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
4101: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
4102: l_msg_index := 1;
4103: WHILE l_msg_count > 0 loop
4104: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
4105: l_msg_index := l_msg_index + 1;
4106: l_msg_count := l_msg_count - 1;
4107: END LOOP;
4108: RAISE fnd_api.g_exc_error;

Line 4108: RAISE fnd_api.g_exc_error;

4104: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
4105: l_msg_index := l_msg_index + 1;
4106: l_msg_count := l_msg_count - 1;
4107: END LOOP;
4108: RAISE fnd_api.g_exc_error;
4109: END IF;
4110:
4111: ELSIF l_dest_instance_header_tbl.count > 1 THEN
4112: -- Multiple Instances were found so throw error

Line 4120: RAISE fnd_api.g_exc_error;

4116: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4117: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4118: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4119: l_error_message := fnd_message.get;
4120: RAISE fnd_api.g_exc_error;
4121: END IF; -- End of Destination Record If
4122: END IF; -- End of J Index Loop
4123:
4124: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 5 AND -- Ship

Line 4153: RAISE fnd_api.g_exc_error;

4149: fnd_message.set_token('REC_ORG',l_mtl_item_tbl(j).transfer_organization_id);
4150: fnd_message.set_token('REC_SC',l_sr_control);
4151: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4152: l_error_message := fnd_message.get;
4153: RAISE fnd_api.g_exc_error;
4154: END IF; -- End of Serial Control IF
4155: END LOOP; -- End of main For Inv Loop
4156:
4157: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

Line 4161: WHEN fnd_api.g_exc_error THEN

4157: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
4158: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');
4159:
4160: EXCEPTION
4161: WHEN fnd_api.g_exc_error THEN
4162: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');
4163: x_return_status := l_fnd_error;
4164:
4165: IF l_mtl_item_tbl.count > 0 THEN

Line 4162: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');

4158: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');
4159:
4160: EXCEPTION
4161: WHEN fnd_api.g_exc_error THEN
4162: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');
4163: x_return_status := l_fnd_error;
4164:
4165: IF l_mtl_item_tbl.count > 0 THEN
4166: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;