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_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 149: RAISE fnd_api.g_exc_error;

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

Line 164: RAISE fnd_api.g_exc_error;

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

Line 189: l_instance_status := FND_API.G_FALSE;

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

Line 191: l_instance_status := FND_API.G_TRUE;

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

Line 229: RAISE fnd_api.g_exc_error;

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

Line 258: RAISE fnd_api.g_exc_error;

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

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

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

Line 363: RAISE fnd_api.g_exc_error;

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

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

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

Line 436: RAISE fnd_api.g_exc_error;

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

Line 449: RAISE fnd_api.g_exc_error;

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

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

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

Line 518: RAISE fnd_api.g_exc_error;

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

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

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

Line 581: RAISE fnd_api.g_exc_error;

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

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

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

Line 650: RAISE fnd_api.g_exc_error;

646: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
647: l_msg_index := l_msg_index + 1;
648: l_msg_count := l_msg_count - 1;
649: END LOOP;
650: RAISE fnd_api.g_exc_error;
651: END IF;
652:
653: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
654:

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

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

Line 720: RAISE fnd_api.g_exc_error;

716: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
717: l_msg_index := l_msg_index + 1;
718: l_msg_count := l_msg_count - 1;
719: END LOOP;
720: RAISE fnd_api.g_exc_error;
721: END IF;
722:
723: ELSE -- Error No dest non serial recs round
724: 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 731: RAISE fnd_api.g_exc_error;

727: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
728: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
729: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
730: l_error_message := fnd_message.get;
731: RAISE fnd_api.g_exc_error;
732: END IF; -- End of Destination Record If
733:
734: END IF; -- End of j=1 for Control Code 1
735:

Line 745: RAISE fnd_api.g_exc_error;

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

Line 760: RAISE fnd_api.g_exc_error;

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

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

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

Line 830: RAISE fnd_api.g_exc_error;

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

Line 842: RAISE fnd_api.g_exc_error;

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

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

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

Line 901: RAISE fnd_api.g_exc_error;

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

Line 913: RAISE fnd_api.g_exc_error;

909: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
910: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
911: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
912: l_error_message := fnd_message.get;
913: RAISE fnd_api.g_exc_error;
914: END IF; -- End of If for Source Count
915:
916: -- Get Destination Records
917:

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

968: IF NOT l_return_status = l_fnd_success then
969: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
970: l_msg_index := 1;
971: WHILE l_msg_count > 0 loop
972: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
973: l_msg_index := l_msg_index + 1;
974: l_msg_count := l_msg_count - 1;
975: END LOOP;
976: RAISE fnd_api.g_exc_error;

Line 976: RAISE fnd_api.g_exc_error;

972: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
973: l_msg_index := l_msg_index + 1;
974: l_msg_count := l_msg_count - 1;
975: END LOOP;
976: RAISE fnd_api.g_exc_error;
977: END IF;
978:
979: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
980:

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

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

Line 1043: RAISE fnd_api.g_exc_error;

1039: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1040: l_msg_index := l_msg_index + 1;
1041: l_msg_count := l_msg_count - 1;
1042: END LOOP;
1043: RAISE fnd_api.g_exc_error;
1044: END IF;
1045:
1046: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
1047:

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

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

Line 1098: RAISE fnd_api.g_exc_error;

1094: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1095: l_msg_index := l_msg_index + 1;
1096: l_msg_count := l_msg_count - 1;
1097: END LOOP;
1098: RAISE fnd_api.g_exc_error;
1099: END IF;
1100:
1101: ELSIF l_dest_instance_header_tbl.count > 1 THEN
1102: -- Multiple Instances were found so throw error

Line 1110: RAISE fnd_api.g_exc_error;

1106: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
1107: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
1108: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
1109: l_error_message := fnd_message.get;
1110: RAISE fnd_api.g_exc_error;
1111:
1112: END IF; -- End of Destination Record If
1113: END IF; -- End of Serial Control If
1114: END LOOP; -- End of For Loop

Line 1120: WHEN fnd_api.g_exc_error THEN

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

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

1117: debug('******End of csi_inv_interorg_pkg.intransit_shipment Transaction******');
1118:
1119: EXCEPTION
1120: WHEN fnd_api.g_exc_error THEN
1121: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction - In Transit Shipment');
1122: x_return_status := l_fnd_error;
1123:
1124: IF l_mtl_item_tbl.count > 0 THEN
1125: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

1195:
1196: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1198: l_api_version NUMBER := 1.0;
1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1202: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1203: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

1196: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1198: l_api_version NUMBER := 1.0;
1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1202: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1203: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1204: l_transaction_id NUMBER := NULL;

Line 1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1198: l_api_version NUMBER := 1.0;
1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1202: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1203: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1204: l_transaction_id NUMBER := NULL;
1205: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

1198: l_api_version NUMBER := 1.0;
1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1202: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1203: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1204: l_transaction_id NUMBER := NULL;
1205: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1206: l_object_version_number NUMBER := 1;

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

1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1202: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1203: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1204: l_transaction_id NUMBER := NULL;
1205: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1206: l_object_version_number NUMBER := 1;
1207: l_sysdate DATE := SYSDATE;

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

1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1202: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
1203: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
1204: l_transaction_id NUMBER := NULL;
1205: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
1206: l_object_version_number NUMBER := 1;
1207: l_sysdate DATE := SYSDATE;
1208: l_master_organization_id NUMBER;
1209: l_depreciable VARCHAR2(1);

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

1234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1235: l_sub_inventory VARCHAR2(10);
1236: l_location_type VARCHAR2(20);
1237: l_trx_action_type VARCHAR2(50);
1238: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1239: l_fnd_warning VARCHAR2(1) := 'W';
1240: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

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

1236: l_location_type VARCHAR2(20);
1237: l_trx_action_type VARCHAR2(50);
1238: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1239: l_fnd_warning VARCHAR2(1) := 'W';
1240: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

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

1237: l_trx_action_type VARCHAR2(50);
1238: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1239: l_fnd_warning VARCHAR2(1) := 'W';
1240: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1245: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

Line 1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

1238: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1239: l_fnd_warning VARCHAR2(1) := 'W';
1240: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1245: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1246: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

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

1239: l_fnd_warning VARCHAR2(1) := 'W';
1240: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1245: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1246: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1247: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';

Line 1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

1240: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1245: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1246: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1247: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1248: l_returned VARCHAR2(25) := 'RETURNED';

Line 1334: RAISE fnd_api.g_exc_error;

1330: debug('Inventory Records Found: '||l_tbl_count);
1331:
1332: IF NOT l_return_status = l_fnd_success THEN
1333: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
1334: RAISE fnd_api.g_exc_error;
1335: END IF;
1336:
1337: debug('Transaction Action ID: '||l_mtl_item_tbl(i).transaction_action_id);
1338: debug('Transaction Source Type ID: '||l_mtl_item_tbl(i).transaction_source_type_id);

Line 1349: RAISE fnd_api.g_exc_error;

1345: l_error_message);
1346:
1347: IF NOT l_return_status = l_fnd_success THEN
1348: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351:
1352: -- Call get_fnd_employee_id and get the employee id
1353: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 1406: RAISE fnd_api.g_exc_error;

1402:
1403: IF NOT l_return_status = l_fnd_success THEN
1404: debug('Redeploy Flag: '||l_redeploy_flag);
1405: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1406: RAISE fnd_api.g_exc_error;
1407: END IF;
1408:
1409: debug('Redeploy Flag: '||l_redeploy_flag);
1410: debug('Trans Status Code: '||l_txn_rec.transaction_status_code);

Line 1435: RAISE fnd_api.g_exc_error;

1431: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
1432:
1433: IF NOT l_return_status = l_fnd_success THEN
1434: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1435: RAISE fnd_api.g_exc_error;
1436: END IF;
1437:
1438: -- Now loop through the PL/SQL Table.
1439: j := 1;

Line 1458: l_instance_status := FND_API.G_FALSE;

1454: FOR j in l_mtl_item_tbl.FIRST .. l_mtl_item_tbl.LAST LOOP
1455:
1456: IF (l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6)) OR
1457: (l_mtl_item_tbl(j).serial_number_control_code in (2,5)) THEN
1458: l_instance_status := FND_API.G_FALSE;
1459: ELSE
1460: l_instance_status := FND_API.G_TRUE;
1461: END IF;
1462:

Line 1460: l_instance_status := FND_API.G_TRUE;

1456: IF (l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6)) OR
1457: (l_mtl_item_tbl(j).serial_number_control_code in (2,5)) THEN
1458: l_instance_status := FND_API.G_FALSE;
1459: ELSE
1460: l_instance_status := FND_API.G_TRUE;
1461: END IF;
1462:
1463: debug('Primary UOM: '||l_mtl_item_tbl(j).primary_uom_code);
1464: debug('Primary Qty: '||l_mtl_item_tbl(j).primary_quantity);

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

1593: IF NOT l_return_status = l_fnd_success then
1594: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1595: l_msg_index := 1;
1596: WHILE l_msg_count > 0 loop
1597: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1598: l_msg_index := l_msg_index + 1;
1599: l_msg_count := l_msg_count - 1;
1600: END LOOP;
1601: RAISE fnd_api.g_exc_error;

Line 1601: RAISE fnd_api.g_exc_error;

1597: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1598: l_msg_index := l_msg_index + 1;
1599: l_msg_count := l_msg_count - 1;
1600: END LOOP;
1601: RAISE fnd_api.g_exc_error;
1602: END IF;
1603:
1604: IF l_src_instance_header_tbl.count > 0 OR
1605: l_12_loop = 1 THEN -- Installed Base Records Found

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

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

Line 1685: RAISE fnd_api.g_exc_error;

1681: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1682: l_msg_index := l_msg_index + 1;
1683: l_msg_count := l_msg_count - 1;
1684: END LOOP;
1685: RAISE fnd_api.g_exc_error;
1686: END IF;
1687:
1688:
1689: ELSIF l_mtl_item_tbl(j).serial_number_control_code in (2,5) AND

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

1740: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1741: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1742: l_msg_index := 1;
1743: WHILE l_msg_count > 0 loop
1744: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1745: l_msg_index := l_msg_index + 1;
1746: l_msg_count := l_msg_count - 1;
1747: END LOOP;
1748: RAISE fnd_api.g_exc_error;

Line 1748: RAISE fnd_api.g_exc_error;

1744: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1745: l_msg_index := l_msg_index + 1;
1746: l_msg_count := l_msg_count - 1;
1747: END LOOP;
1748: RAISE fnd_api.g_exc_error;
1749: END IF;
1750: END IF; -- End of J = 1 If to update Source 1 time
1751:
1752: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances

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

1802: IF NOT l_return_status = l_fnd_success then
1803: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1804: l_msg_index := 1;
1805: WHILE l_msg_count > 0 loop
1806: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1807: l_msg_index := l_msg_index + 1;
1808: l_msg_count := l_msg_count - 1;
1809: END LOOP;
1810: RAISE fnd_api.g_exc_error;

Line 1810: RAISE fnd_api.g_exc_error;

1806: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1807: l_msg_index := l_msg_index + 1;
1808: l_msg_count := l_msg_count - 1;
1809: END LOOP;
1810: RAISE fnd_api.g_exc_error;
1811: END IF;
1812:
1813: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
1814:

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

1871: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1872: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1873: l_msg_index := 1;
1874: WHILE l_msg_count > 0 loop
1875: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1876: l_msg_index := l_msg_index + 1;
1877: l_msg_count := l_msg_count - 1;
1878: END LOOP;
1879: RAISE fnd_api.g_exc_error;

Line 1879: RAISE fnd_api.g_exc_error;

1875: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1876: l_msg_index := l_msg_index + 1;
1877: l_msg_count := l_msg_count - 1;
1878: END LOOP;
1879: RAISE fnd_api.g_exc_error;
1880: END IF;
1881:
1882: ELSIF l_dest_instance_header_tbl.count > 0 THEN
1883: 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 1950: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1946: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1947: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
1948: l_msg_index := 1;
1949: WHILE l_msg_count > 0 loop
1950: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1951: l_msg_index := l_msg_index + 1;
1952: l_msg_count := l_msg_count - 1;
1953: END LOOP;
1954: RAISE fnd_api.g_exc_error;

Line 1954: RAISE fnd_api.g_exc_error;

1950: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1951: l_msg_index := l_msg_index + 1;
1952: l_msg_count := l_msg_count - 1;
1953: END LOOP;
1954: RAISE fnd_api.g_exc_error;
1955: END IF;
1956:
1957: ELSIF l_dest_instance_header_tbl(i).instance_usage_code = l_out_of_enterprise THEN
1958:

Line 2005: fnd_api.g_true, -- Get Parties

2001: l_commit,
2002: l_init_msg_list,
2003: l_validation_level,
2004: l_instance_header_rec,
2005: fnd_api.g_true, -- Get Parties
2006: l_party_header_tbl,
2007: fnd_api.g_false, -- Get Accounts
2008: l_account_header_tbl,
2009: fnd_api.g_false, -- Get Org Assi.

Line 2007: fnd_api.g_false, -- Get Accounts

2003: l_validation_level,
2004: l_instance_header_rec,
2005: fnd_api.g_true, -- Get Parties
2006: l_party_header_tbl,
2007: fnd_api.g_false, -- Get Accounts
2008: l_account_header_tbl,
2009: fnd_api.g_false, -- Get Org Assi.
2010: l_org_header_tbl,
2011: fnd_api.g_false, -- Get Price Att

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

2005: fnd_api.g_true, -- Get Parties
2006: l_party_header_tbl,
2007: fnd_api.g_false, -- Get Accounts
2008: l_account_header_tbl,
2009: fnd_api.g_false, -- Get Org Assi.
2010: l_org_header_tbl,
2011: fnd_api.g_false, -- Get Price Att
2012: l_pricing_header_tbl,
2013: fnd_api.g_false, -- Get Ext Attr

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

2007: fnd_api.g_false, -- Get Accounts
2008: l_account_header_tbl,
2009: fnd_api.g_false, -- Get Org Assi.
2010: l_org_header_tbl,
2011: fnd_api.g_false, -- Get Price Att
2012: l_pricing_header_tbl,
2013: fnd_api.g_false, -- Get Ext Attr
2014: l_ext_attrib_header_tbl,
2015: l_ext_attrib_def_tbl,

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

2009: fnd_api.g_false, -- Get Org Assi.
2010: l_org_header_tbl,
2011: fnd_api.g_false, -- Get Price Att
2012: l_pricing_header_tbl,
2013: fnd_api.g_false, -- Get Ext Attr
2014: l_ext_attrib_header_tbl,
2015: l_ext_attrib_def_tbl,
2016: fnd_api.g_false, -- Get Asset Assi
2017: l_asset_header_tbl,

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

2012: l_pricing_header_tbl,
2013: fnd_api.g_false, -- Get Ext Attr
2014: l_ext_attrib_header_tbl,
2015: l_ext_attrib_def_tbl,
2016: fnd_api.g_false, -- Get Asset Assi
2017: l_asset_header_tbl,
2018: fnd_api.g_false, -- Resolve IDs
2019: NULL, -- Time Stamp
2020: l_return_status,

Line 2018: fnd_api.g_false, -- Resolve IDs

2014: l_ext_attrib_header_tbl,
2015: l_ext_attrib_def_tbl,
2016: fnd_api.g_false, -- Get Asset Assi
2017: l_asset_header_tbl,
2018: fnd_api.g_false, -- Resolve IDs
2019: NULL, -- Time Stamp
2020: l_return_status,
2021: l_msg_count,
2022: l_msg_data);

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

2089: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2090: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2091: l_msg_index := 1;
2092: WHILE l_msg_count > 0 loop
2093: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2094: l_msg_index := l_msg_index + 1;
2095: l_msg_count := l_msg_count - 1;
2096: END LOOP;
2097: RAISE fnd_api.g_exc_error;

Line 2097: RAISE fnd_api.g_exc_error;

2093: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2094: l_msg_index := l_msg_index + 1;
2095: l_msg_count := l_msg_count - 1;
2096: END LOOP;
2097: RAISE fnd_api.g_exc_error;
2098: END IF;
2099: ELSE
2100: l_status := 'In Inventory, Out of Service or Out of Enterprise';
2101: 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 2107: RAISE fnd_api.g_exc_error;

2103: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
2104: fnd_message.set_token('STATUS',l_status);
2105: l_error_message := fnd_message.get;
2106: l_return_status := l_fnd_error;
2107: RAISE fnd_api.g_exc_error;
2108: END IF;
2109:
2110: ELSE
2111: l_status := 'IN_INVENTORY OR IN_TRANSIT';

Line 2117: RAISE fnd_api.g_exc_error;

2113: debug('Instance Usage Code is: '||l_dest_instance_header_tbl(i).instance_usage_code);
2114: fnd_message.set_name('CSI','CSI_SERIALIZED_ITEM_EXISTS');
2115: fnd_message.set_token('STATUS',l_status);
2116: l_error_message := fnd_message.get;
2117: RAISE fnd_api.g_exc_error;
2118: END IF;
2119: END IF; -- End of Destination Record If
2120:
2121: ELSIF l_mtl_item_tbl(j).serial_number_control_code = 1 AND

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

2174: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2175: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2176: l_msg_index := 1;
2177: WHILE l_msg_count > 0 loop
2178: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2179: l_msg_index := l_msg_index + 1;
2180: l_msg_count := l_msg_count - 1;
2181: END LOOP;
2182: RAISE fnd_api.g_exc_error;

Line 2182: RAISE fnd_api.g_exc_error;

2178: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2179: l_msg_index := l_msg_index + 1;
2180: l_msg_count := l_msg_count - 1;
2181: END LOOP;
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2184:
2185: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2186: debug('J is 1 so query for Non Serialized item 1 time - 23');

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

2227: IF NOT l_return_status = l_fnd_success then
2228: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2229: l_msg_index := 1;
2230: WHILE l_msg_count > 0 loop
2231: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2232: l_msg_index := l_msg_index + 1;
2233: l_msg_count := l_msg_count - 1;
2234: END LOOP;
2235: RAISE fnd_api.g_exc_error;

Line 2235: RAISE fnd_api.g_exc_error;

2231: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2232: l_msg_index := l_msg_index + 1;
2233: l_msg_count := l_msg_count - 1;
2234: END LOOP;
2235: RAISE fnd_api.g_exc_error;
2236: END IF;
2237:
2238: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2239:

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

2294: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2295: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2296: l_msg_index := 1;
2297: WHILE l_msg_count > 0 loop
2298: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2299: l_msg_index := l_msg_index + 1;
2300: l_msg_count := l_msg_count - 1;
2301: END LOOP;
2302: RAISE fnd_api.g_exc_error;

Line 2302: RAISE fnd_api.g_exc_error;

2298: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2299: l_msg_index := l_msg_index + 1;
2300: l_msg_count := l_msg_count - 1;
2301: END LOOP;
2302: RAISE fnd_api.g_exc_error;
2303: END IF;
2304:
2305: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2306:

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

2350: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2351: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2352: l_msg_index := 1;
2353: WHILE l_msg_count > 0 loop
2354: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2355: l_msg_index := l_msg_index + 1;
2356: l_msg_count := l_msg_count - 1;
2357: END LOOP;
2358: RAISE fnd_api.g_exc_error;

Line 2358: RAISE fnd_api.g_exc_error;

2354: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2355: l_msg_index := l_msg_index + 1;
2356: l_msg_count := l_msg_count - 1;
2357: END LOOP;
2358: RAISE fnd_api.g_exc_error;
2359: END IF;
2360:
2361: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2362: -- Multiple Instances were found so throw error

Line 2370: RAISE fnd_api.g_exc_error;

2366: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2367: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2368: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2369: l_error_message := fnd_message.get;
2370: RAISE fnd_api.g_exc_error;
2371:
2372: END IF; -- End of Destination Record If
2373:
2374: ELSIF l_mtl_item_tbl(j).serial_number_control_code = 6 AND

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

2427: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2428: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2429: l_msg_index := 1;
2430: WHILE l_msg_count > 0 loop
2431: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2432: l_msg_index := l_msg_index + 1;
2433: l_msg_count := l_msg_count - 1;
2434: END LOOP;
2435: RAISE fnd_api.g_exc_error;

Line 2435: RAISE fnd_api.g_exc_error;

2431: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2432: l_msg_index := l_msg_index + 1;
2433: l_msg_count := l_msg_count - 1;
2434: END LOOP;
2435: RAISE fnd_api.g_exc_error;
2436: END IF;
2437: END LOOP; -- End Header Tbl and Trans Qty Loop
2438:
2439: -- Now Query for Non Serialized In Inventory Record 1 Time Only

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

2482: IF NOT l_return_status = l_fnd_success then
2483: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2484: l_msg_index := 1;
2485: WHILE l_msg_count > 0 loop
2486: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2487: l_msg_index := l_msg_index + 1;
2488: l_msg_count := l_msg_count - 1;
2489: END LOOP;
2490: RAISE fnd_api.g_exc_error;

Line 2490: RAISE fnd_api.g_exc_error;

2486: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2487: l_msg_index := l_msg_index + 1;
2488: l_msg_count := l_msg_count - 1;
2489: END LOOP;
2490: RAISE fnd_api.g_exc_error;
2491: END IF;
2492:
2493: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2494:

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

2549: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2550: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2551: l_msg_index := 1;
2552: WHILE l_msg_count > 0 loop
2553: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2554: l_msg_index := l_msg_index + 1;
2555: l_msg_count := l_msg_count - 1;
2556: END LOOP;
2557: RAISE fnd_api.g_exc_error;

Line 2557: RAISE fnd_api.g_exc_error;

2553: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2554: l_msg_index := l_msg_index + 1;
2555: l_msg_count := l_msg_count - 1;
2556: END LOOP;
2557: RAISE fnd_api.g_exc_error;
2558: END IF;
2559:
2560: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2561:

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

2605: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2606: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);
2607: l_msg_index := 1;
2608: WHILE l_msg_count > 0 loop
2609: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2610: l_msg_index := l_msg_index + 1;
2611: l_msg_count := l_msg_count - 1;
2612: END LOOP;
2613: RAISE fnd_api.g_exc_error;

Line 2613: RAISE fnd_api.g_exc_error;

2609: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2610: l_msg_index := l_msg_index + 1;
2611: l_msg_count := l_msg_count - 1;
2612: END LOOP;
2613: RAISE fnd_api.g_exc_error;
2614: END IF;
2615:
2616: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2617: -- Multiple Instances were found so throw error

Line 2625: RAISE fnd_api.g_exc_error;

2621: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2622: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2623: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2624: l_error_message := fnd_message.get;
2625: RAISE fnd_api.g_exc_error;
2626:
2627: END IF; -- End of Destination Record If
2628: END IF; -- End of J Index Loop
2629:

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

2674: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2675: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2676: l_msg_index := 1;
2677: WHILE l_msg_count > 0 loop
2678: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2679: l_msg_index := l_msg_index + 1;
2680: l_msg_count := l_msg_count - 1;
2681: END LOOP;
2682: RAISE fnd_api.g_exc_error;

Line 2682: RAISE fnd_api.g_exc_error;

2678: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2679: l_msg_index := l_msg_index + 1;
2680: l_msg_count := l_msg_count - 1;
2681: END LOOP;
2682: RAISE fnd_api.g_exc_error;
2683: END IF;
2684:
2685: -- Get Destination Record
2686:

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

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

Line 2734: RAISE fnd_api.g_exc_error;

2730: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2731: l_msg_index := l_msg_index + 1;
2732: l_msg_count := l_msg_count - 1;
2733: END LOOP;
2734: RAISE fnd_api.g_exc_error;
2735: END IF;
2736:
2737: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2738:

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

2793: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2794: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2795: l_msg_index := 1;
2796: WHILE l_msg_count > 0 loop
2797: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2798: l_msg_index := l_msg_index + 1;
2799: l_msg_count := l_msg_count - 1;
2800: END LOOP;
2801: RAISE fnd_api.g_exc_error;

Line 2801: RAISE fnd_api.g_exc_error;

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

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

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

Line 2856: RAISE fnd_api.g_exc_error;

2852: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2853: l_msg_index := l_msg_index + 1;
2854: l_msg_count := l_msg_count - 1;
2855: END LOOP;
2856: RAISE fnd_api.g_exc_error;
2857: END IF;
2858:
2859: ELSIF l_dest_instance_header_tbl.count > 1 THEN
2860: -- Multiple Instances were found so throw error

Line 2868: RAISE fnd_api.g_exc_error;

2864: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
2865: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
2866: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
2867: l_error_message := fnd_message.get;
2868: RAISE fnd_api.g_exc_error;
2869: END IF; -- End of Destination Record If
2870:
2871: ELSE -- No Records Found So throw Error
2872: debug('No Records were found in Install Base - 48');

Line 2880: RAISE fnd_api.g_exc_error;

2876: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2877: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2878: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2879: l_error_message := fnd_message.get;
2880: RAISE fnd_api.g_exc_error;
2881:
2882: END IF; -- Serial Control IF
2883:
2884: ELSE

Line 2893: RAISE fnd_api.g_exc_error;

2889: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
2890: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
2891: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
2892: l_error_message := fnd_message.get;
2893: RAISE fnd_api.g_exc_error;
2894:
2895: END IF; -- End of Main Source Header Tbl IF
2896: END LOOP; -- End of For Loop
2897:

Line 2903: WHEN fnd_api.g_exc_error THEN

2899: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2900: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');
2901:
2902: EXCEPTION
2903: WHEN fnd_api.g_exc_error THEN
2904: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');
2905: x_return_status := l_fnd_error;
2906:
2907: IF l_mtl_item_tbl.count > 0 THEN

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

2900: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');
2901:
2902: EXCEPTION
2903: WHEN fnd_api.g_exc_error THEN
2904: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');
2905: x_return_status := l_fnd_error;
2906:
2907: IF l_mtl_item_tbl.count > 0 THEN
2908: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;

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

2976:
2977: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
2979: l_api_version NUMBER := 1.0;
2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2983: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2984: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;

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

2977: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
2979: l_api_version NUMBER := 1.0;
2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2983: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2984: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2985: l_transaction_id NUMBER := NULL;

Line 2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
2979: l_api_version NUMBER := 1.0;
2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2983: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2984: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2985: l_transaction_id NUMBER := NULL;
2986: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;

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

2979: l_api_version NUMBER := 1.0;
2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2983: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2984: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2985: l_transaction_id NUMBER := NULL;
2986: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2987: l_object_version_number NUMBER := 1;

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

2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2983: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2984: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2985: l_transaction_id NUMBER := NULL;
2986: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2987: l_object_version_number NUMBER := 1;
2988: l_sysdate DATE := SYSDATE;

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

2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2983: l_active_instance_only VARCHAR2(10) := FND_API.G_TRUE;
2984: l_inactive_instance_only VARCHAR2(10) := FND_API.G_FALSE;
2985: l_transaction_id NUMBER := NULL;
2986: l_resolve_id_columns VARCHAR2(10) := FND_API.G_FALSE;
2987: l_object_version_number NUMBER := 1;
2988: l_sysdate DATE := SYSDATE;
2989: l_master_organization_id NUMBER;
2990: l_depreciable VARCHAR2(1);

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

3015: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3016: l_sub_inventory VARCHAR2(10);
3017: l_location_type VARCHAR2(20);
3018: l_trx_action_type VARCHAR2(50);
3019: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3020: l_fnd_warning VARCHAR2(1) := 'W';
3021: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

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

3017: l_location_type VARCHAR2(20);
3018: l_trx_action_type VARCHAR2(50);
3019: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3020: l_fnd_warning VARCHAR2(1) := 'W';
3021: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

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

3018: l_trx_action_type VARCHAR2(50);
3019: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3020: l_fnd_warning VARCHAR2(1) := 'W';
3021: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

Line 3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3030: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3031: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3032: l_instance_usage_code VARCHAR2(25);
3033: l_organization_id NUMBER;

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

3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3030: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3031: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3032: l_instance_usage_code VARCHAR2(25);
3033: l_organization_id NUMBER;
3034: l_subinventory_name VARCHAR2(10);

Line 3031: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3030: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3031: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3032: l_instance_usage_code VARCHAR2(25);
3033: l_organization_id NUMBER;
3034: l_subinventory_name VARCHAR2(10);
3035: l_locator_id NUMBER;

Line 3141: RAISE fnd_api.g_exc_error;

3137: debug('Inventory Records Found: '||l_tbl_count);
3138:
3139: IF NOT l_return_status = l_fnd_success THEN
3140: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);
3141: RAISE fnd_api.g_exc_error;
3142: END IF;
3143:
3144: -- Get the Master Organization ID
3145: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

Line 3152: RAISE fnd_api.g_exc_error;

3148: l_error_message);
3149:
3150: IF NOT l_return_status = l_fnd_success THEN
3151: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
3152: RAISE fnd_api.g_exc_error;
3153: END IF;
3154:
3155: -- Call get_fnd_employee_id and get the employee id
3156: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);

Line 3219: RAISE fnd_api.g_exc_error;

3215:
3216: IF NOT l_return_status = l_fnd_success THEN
3217: debug('Redeploy Flag: '||l_redeploy_flag);
3218: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
3219: RAISE fnd_api.g_exc_error;
3220: END IF;
3221:
3222: debug('Redeploy Flag: '||l_redeploy_flag);
3223: debug('Trans Status Code: '||l_txn_rec.transaction_status_code);

Line 3254: RAISE fnd_api.g_exc_error;

3250: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
3251:
3252: IF NOT l_return_status = l_fnd_success THEN
3253: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
3254: RAISE fnd_api.g_exc_error;
3255: END IF;
3256:
3257: -- Now loop through the PL/SQL Table.
3258: j := 1;

Line 3294: l_instance_status := FND_API.G_FALSE;

3290: debug('Receiving Org Trackable Flag: '||r_item_control.comms_nl_trackable_flag);
3291:
3292: -- Set Query Instance Status
3293: IF l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN
3294: l_instance_status := FND_API.G_FALSE;
3295: ELSE
3296: l_instance_status := FND_API.G_TRUE;
3297: END IF;
3298:

Line 3296: l_instance_status := FND_API.G_TRUE;

3292: -- Set Query Instance Status
3293: IF l_neg_code = 1 AND l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN
3294: l_instance_status := FND_API.G_FALSE;
3295: ELSE
3296: l_instance_status := FND_API.G_TRUE;
3297: END IF;
3298:
3299: debug('Query Inst Status : '||l_instance_status);
3300:

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

3359: IF NOT l_return_status = l_fnd_success then
3360: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
3361: l_msg_index := 1;
3362: WHILE l_msg_count > 0 loop
3363: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3364: l_msg_index := l_msg_index + 1;
3365: l_msg_count := l_msg_count - 1;
3366: END LOOP;
3367: RAISE fnd_api.g_exc_error;

Line 3367: RAISE fnd_api.g_exc_error;

3363: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3364: l_msg_index := l_msg_index + 1;
3365: l_msg_count := l_msg_count - 1;
3366: END LOOP;
3367: RAISE fnd_api.g_exc_error;
3368: END IF;
3369:
3370: debug('Before checking to see if Source records Exist - 1');
3371:

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

3431: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3432: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3433: l_msg_index := 1;
3434: WHILE l_msg_count > 0 loop
3435: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3436: l_msg_index := l_msg_index + 1;
3437: l_msg_count := l_msg_count - 1;
3438: END LOOP;
3439: RAISE fnd_api.g_exc_error;

Line 3439: RAISE fnd_api.g_exc_error;

3435: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3436: l_msg_index := l_msg_index + 1;
3437: l_msg_count := l_msg_count - 1;
3438: END LOOP;
3439: RAISE fnd_api.g_exc_error;
3440: END IF;
3441:
3442: ELSE -- No Src Records found so error
3443:

Line 3451: RAISE fnd_api.g_exc_error;

3447: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3448: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3449: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3450: l_error_message := fnd_message.get;
3451: RAISE fnd_api.g_exc_error;
3452: END IF; -- End of 5 and 2,5 IF
3453:
3454: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 6 AND -- Ship
3455: l_sr_control = 6) OR -- Rec

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

3521: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3522: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
3523: l_msg_index := 1;
3524: WHILE l_msg_count > 0 loop
3525: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3526: l_msg_index := l_msg_index + 1;
3527: l_msg_count := l_msg_count - 1;
3528: END LOOP;
3529: RAISE fnd_api.g_exc_error;

Line 3529: RAISE fnd_api.g_exc_error;

3525: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3526: l_msg_index := l_msg_index + 1;
3527: l_msg_count := l_msg_count - 1;
3528: END LOOP;
3529: RAISE fnd_api.g_exc_error;
3530: END IF;
3531: ELSE -- Inv Does not allowe neg qty and source is not found
3532: debug('No Records were found in Install Base - 9');
3533: fnd_message.set_name('CSI','CSI_IB_RECORD_NOTFOUND');

Line 3539: RAISE fnd_api.g_exc_error;

3535: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3536: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3537: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3538: l_error_message := fnd_message.get;
3539: RAISE fnd_api.g_exc_error;
3540:
3541: END IF; -- End of Neg Qty IF
3542: ELSIF l_src_instance_header_tbl.count = 1 THEN -- Source Records are found
3543:

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

3598: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3599: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3600: l_msg_index := 1;
3601: WHILE l_msg_count > 0 loop
3602: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3603: l_msg_index := l_msg_index + 1;
3604: l_msg_count := l_msg_count - 1;
3605: END LOOP;
3606: RAISE fnd_api.g_exc_error;

Line 3606: RAISE fnd_api.g_exc_error;

3602: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3603: l_msg_index := l_msg_index + 1;
3604: l_msg_count := l_msg_count - 1;
3605: END LOOP;
3606: RAISE fnd_api.g_exc_error;
3607: END IF;
3608:
3609: ELSE -- Error No Src Recs and Inv Does not allow neg qtys
3610: debug('No Records were found in Install Base - 12');

Line 3617: RAISE fnd_api.g_exc_error;

3613: fnd_message.set_token('SUBINVENTORY',l_mtl_item_tbl(j).subinventory_code);
3614: fnd_message.set_token('ORG_ID',l_mtl_item_tbl(j).organization_id);
3615: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
3616: l_error_message := fnd_message.get;
3617: RAISE fnd_api.g_exc_error;
3618: END IF; -- End of If for Main Source
3619:
3620: -- Get Destination Records
3621:

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

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

Line 3670: RAISE fnd_api.g_exc_error;

3666: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3667: l_msg_index := l_msg_index + 1;
3668: l_msg_count := l_msg_count - 1;
3669: END LOOP;
3670: RAISE fnd_api.g_exc_error;
3671: END IF;
3672:
3673: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3674:

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

3729: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3730: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
3731: l_msg_index := 1;
3732: WHILE l_msg_count > 0 loop
3733: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3734: l_msg_index := l_msg_index + 1;
3735: l_msg_count := l_msg_count - 1;
3736: END LOOP;
3737: RAISE fnd_api.g_exc_error;

Line 3737: RAISE fnd_api.g_exc_error;

3733: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3734: l_msg_index := l_msg_index + 1;
3735: l_msg_count := l_msg_count - 1;
3736: END LOOP;
3737: RAISE fnd_api.g_exc_error;
3738: END IF;
3739:
3740: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3741:

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

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

Line 3793: RAISE fnd_api.g_exc_error;

3789: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3790: l_msg_index := l_msg_index + 1;
3791: l_msg_count := l_msg_count - 1;
3792: END LOOP;
3793: RAISE fnd_api.g_exc_error;
3794: END IF;
3795:
3796: ELSIF l_dest_instance_header_tbl.count > 1 THEN
3797: -- Multiple Instances were found so throw error

Line 3805: RAISE fnd_api.g_exc_error;

3801: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
3802: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
3803: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
3804: l_error_message := fnd_message.get;
3805: RAISE fnd_api.g_exc_error;
3806: END IF; -- End of Destination Record If
3807:
3808: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 5 AND -- Ship
3809: l_sr_control = 1) OR -- Rec

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

3864: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3865: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3866: l_msg_index := 1;
3867: WHILE l_msg_count > 0 loop
3868: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3869: l_msg_index := l_msg_index + 1;
3870: l_msg_count := l_msg_count - 1;
3871: END LOOP;
3872: RAISE fnd_api.g_exc_error;

Line 3872: RAISE fnd_api.g_exc_error;

3868: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3869: l_msg_index := l_msg_index + 1;
3870: l_msg_count := l_msg_count - 1;
3871: END LOOP;
3872: RAISE fnd_api.g_exc_error;
3873: END IF;
3874: -- END LOOP; -- End For Loop for Update of Sr Instances
3875:
3876: -- Now Query for Non Serialized In Inventory Record 1 Time Only

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

3918: IF NOT l_return_status = l_fnd_success then
3919: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
3920: l_msg_index := 1;
3921: WHILE l_msg_count > 0 loop
3922: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3923: l_msg_index := l_msg_index + 1;
3924: l_msg_count := l_msg_count - 1;
3925: END LOOP;
3926: RAISE fnd_api.g_exc_error;

Line 3926: RAISE fnd_api.g_exc_error;

3922: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3923: l_msg_index := l_msg_index + 1;
3924: l_msg_count := l_msg_count - 1;
3925: END LOOP;
3926: RAISE fnd_api.g_exc_error;
3927: END IF;
3928:
3929: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3930:

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

3985: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3986: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
3987: l_msg_index := 1;
3988: WHILE l_msg_count > 0 loop
3989: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3990: l_msg_index := l_msg_index + 1;
3991: l_msg_count := l_msg_count - 1;
3992: END LOOP;
3993: RAISE fnd_api.g_exc_error;

Line 3993: RAISE fnd_api.g_exc_error;

3989: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3990: l_msg_index := l_msg_index + 1;
3991: l_msg_count := l_msg_count - 1;
3992: END LOOP;
3993: RAISE fnd_api.g_exc_error;
3994: END IF;
3995:
3996: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3997:

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

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

Line 4048: RAISE fnd_api.g_exc_error;

4044: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
4045: l_msg_index := l_msg_index + 1;
4046: l_msg_count := l_msg_count - 1;
4047: END LOOP;
4048: RAISE fnd_api.g_exc_error;
4049: END IF;
4050:
4051: ELSIF l_dest_instance_header_tbl.count > 1 THEN
4052: -- Multiple Instances were found so throw error

Line 4060: RAISE fnd_api.g_exc_error;

4056: fnd_message.set_token('SUBINV',l_mtl_item_tbl(j).subinventory_code);
4057: fnd_message.set_token('INV_ORG_ID',l_mtl_item_tbl(j).organization_id);
4058: fnd_message.set_token('LOCATOR',l_mtl_item_tbl(j).locator_id);
4059: l_error_message := fnd_message.get;
4060: RAISE fnd_api.g_exc_error;
4061: END IF; -- End of Destination Record If
4062: END IF; -- End of J Index Loop
4063:
4064: ELSIF (l_mtl_item_tbl(j).serial_number_control_code = 5 AND -- Ship

Line 4093: RAISE fnd_api.g_exc_error;

4089: fnd_message.set_token('REC_ORG',l_mtl_item_tbl(j).transfer_organization_id);
4090: fnd_message.set_token('REC_SC',l_sr_control);
4091: fnd_message.set_token('ITEM',l_mtl_item_tbl(j).inventory_item_id);
4092: l_error_message := fnd_message.get;
4093: RAISE fnd_api.g_exc_error;
4094: END IF; -- End of Serial Control IF
4095: END LOOP; -- End of main For Inv Loop
4096:
4097: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

Line 4101: WHEN fnd_api.g_exc_error THEN

4097: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
4098: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');
4099:
4100: EXCEPTION
4101: WHEN fnd_api.g_exc_error THEN
4102: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');
4103: x_return_status := l_fnd_error;
4104:
4105: IF l_mtl_item_tbl.count > 0 THEN

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

4098: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');
4099:
4100: EXCEPTION
4101: WHEN fnd_api.g_exc_error THEN
4102: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');
4103: x_return_status := l_fnd_error;
4104:
4105: IF l_mtl_item_tbl.count > 0 THEN
4106: x_trx_error_rec.serial_number := l_mtl_item_tbl(j).serial_number;