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 CSI_ITEM_INSTANCE_PUB

Line 336: csi_item_instance_pub.get_item_instances(l_api_version,

332:
333: debug('Transaction Action Type:'|| l_trx_action_type);
334: debug('Before Get Item Instance - 1');
335:
336: csi_item_instance_pub.get_item_instances(l_api_version,
337: l_commit,
338: l_init_msg_list,
339: l_validation_level,
340: l_instance_query_rec,

Line 360: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

356: debug('Source Records Found: '||l_tbl_count);
357:
358: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 407: csi_item_instance_pub.update_item_instance(l_api_version,

403: l_asset_assignment_tbl.delete;
404:
405: debug('Before Update Item Instance - 5');
406:
407: csi_item_instance_pub.update_item_instance(l_api_version,
408: l_commit,
409: l_init_msg_list,
410: l_validation_level,
411: l_update_instance_rec,

Line 433: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

429: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
430:
431: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 490: csi_item_instance_pub.update_item_instance(l_api_version,

486: l_asset_assignment_tbl.delete;
487:
488: debug('Before Update Item Instance - 9');
489:
490: csi_item_instance_pub.update_item_instance(l_api_version,
491: l_commit,
492: l_init_msg_list,
493: l_validation_level,
494: l_update_instance_rec,

Line 516: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

512: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
513:
514: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 555: csi_item_instance_pub.get_item_instances(l_api_version,

551: csi_t_gen_utility_pvt.dump_instance_query_rec(l_instance_query_rec);
552:
553: debug('Before Get Item Instance for Dest Non Serialized Instance-11');
554:
555: csi_item_instance_pub.get_item_instances(l_api_version,
556: l_commit,
557: l_init_msg_list,
558: l_validation_level,
559: l_instance_query_rec,

Line 579: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

575: debug('Source Records Found: '||l_tbl_count);
576:
577: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 626: csi_item_instance_pub.create_item_instance(l_api_version,

622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
623:
624: debug('Before Create Item Instance-14');
625:
626: csi_item_instance_pub.create_item_instance(l_api_version,
627: l_commit,
628: l_init_msg_list,
629: l_validation_level,
630: l_new_dest_instance_rec,

Line 648: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

644:
645: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
646:
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;

Line 692: csi_item_instance_pub.update_item_instance(l_api_version,

688:
689: debug('Before Update Item Instance-16');
690: debug('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);
691:
692: csi_item_instance_pub.update_item_instance(l_api_version,
693: l_commit,
694: l_init_msg_list,
695: l_validation_level,
696: l_update_dest_instance_rec,

Line 718: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

714: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
715:
716: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 806: csi_item_instance_pub.create_item_instance(l_api_version,

802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
803:
804: debug('Before Create Source Item Instance - 9');
805:
806: csi_item_instance_pub.create_item_instance(l_api_version,
807: l_commit,
808: l_init_msg_list,
809: l_validation_level,
810: l_new_src_instance_rec,

Line 828: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

824:
825: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
826:
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;

Line 873: csi_item_instance_pub.update_item_instance(l_api_version,

869: l_upd_src_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
870:
871: debug('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
872:
873: csi_item_instance_pub.update_item_instance(l_api_version,
874: l_commit,
875: l_init_msg_list,
876: l_validation_level,
877: l_upd_src_dest_instance_rec,

Line 899: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

895: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
896:
897: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 952: csi_item_instance_pub.get_item_instances(l_api_version,

948: l_locator_id := NULL;
949:
950: debug('Before Get Item Instance - 17');
951:
952: csi_item_instance_pub.get_item_instances(l_api_version,
953: l_commit,
954: l_init_msg_list,
955: l_validation_level,
956: l_instance_query_rec,

Line 975: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

971: debug('Source Records Found: '||l_tbl_count);
972:
973: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 1020: csi_item_instance_pub.create_item_instance(l_api_version,

1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1017:
1018: debug('Before Create Item Instance - 20');
1019:
1020: csi_item_instance_pub.create_item_instance(l_api_version,
1021: l_commit,
1022: l_init_msg_list,
1023: l_validation_level,
1024: l_new_dest_instance_rec,

Line 1042: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

1038:
1039: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1040:
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;

Line 1071: csi_item_instance_pub.update_item_instance(l_api_version,

1067:
1068: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1069: debug('Before Update Item Instance - 23');
1070:
1071: csi_item_instance_pub.update_item_instance(l_api_version,
1072: l_commit,
1073: l_init_msg_list,
1074: l_validation_level,
1075: l_update_dest_instance_rec,

Line 1097: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

1093: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
1094:
1095: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 1592: csi_item_instance_pub.get_item_instances(l_api_version,

1588: debug('Transaction Action Type:'|| l_trx_action_type);
1589: debug('Before Get Item Instance - 1');
1590: --Bug 12420630, Need to clear the records obtained in the previous iteration.
1591: l_src_instance_header_tbl := l_instance_header_tbl;
1592: csi_item_instance_pub.get_item_instances(l_api_version,
1593: l_commit,
1594: l_init_msg_list,
1595: l_validation_level,
1596: l_instance_query_rec,

Line 1617: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1613: debug('Source Records Found: '||l_tbl_count);
1614:
1615: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 1679: csi_item_instance_pub.update_item_instance(l_api_version,

1675: l_asset_assignment_tbl.delete;
1676:
1677: debug('Before Update Item Instance - 4');
1678:
1679: csi_item_instance_pub.update_item_instance(l_api_version,
1680: l_commit,
1681: l_init_msg_list,
1682: l_validation_level,
1683: l_update_instance_rec,

Line 1705: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1701: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
1702:
1703: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 1747: csi_item_instance_pub.update_item_instance(l_api_version,

1743: -- end bug 9801681
1744:
1745: debug('Before Update Item Instance - 6');
1746:
1747: csi_item_instance_pub.update_item_instance(l_api_version,
1748: l_commit,
1749: l_init_msg_list,
1750: l_validation_level,
1751: l_upd_src_dest_instance_rec,

Line 1773: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1769: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
1770:
1771: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 1811: csi_item_instance_pub.get_item_instances(l_api_version,

1807: debug('Locator ID: '||l_instance_query_rec.inv_locator_id);
1808:
1809: debug('Before Get Dest Item Instance - 8');
1810:
1811: csi_item_instance_pub.get_item_instances(l_api_version,
1812: l_commit,
1813: l_init_msg_list,
1814: l_validation_level,
1815: l_instance_query_rec,

Line 1835: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1831: debug('Source Records Found: '||l_tbl_count);
1832:
1833: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 1882: csi_item_instance_pub.create_item_instance(l_api_version,

1878:
1879: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
1880: debug('Before Create Item Instance - 10');
1881:
1882: csi_item_instance_pub.create_item_instance(l_api_version,
1883: l_commit,
1884: l_init_msg_list,
1885: l_validation_level,
1886: l_new_dest_instance_rec,

Line 1904: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

1900:
1901: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1902:
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;

Line 1953: csi_item_instance_pub.update_item_instance(l_api_version,

1949:
1950: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1951: debug('Before Update Item Instance - 13');
1952:
1953: csi_item_instance_pub.update_item_instance(l_api_version,
1954: l_commit,
1955: l_init_msg_list,
1956: l_validation_level,
1957: l_update_dest_instance_rec,

Line 1979: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

1975: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
1976:
1977: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2031: csi_item_instance_pub.get_item_instance_details

2027: -- Instance.
2028:
2029: l_instance_header_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2030: -- Call details to get Party Information
2031: csi_item_instance_pub.get_item_instance_details
2032: (l_api_version,
2033: l_commit,
2034: l_init_msg_list,
2035: l_validation_level,

Line 2095: csi_item_instance_pub.update_item_instance(l_api_version,

2091:
2092: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2093: debug('Before Update Item Instance - 13');
2094:
2095: csi_item_instance_pub.update_item_instance(l_api_version,
2096: l_commit,
2097: l_init_msg_list,
2098: l_validation_level,
2099: l_update_dest_instance_rec,

Line 2122: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

2118: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2119:
2120: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2184: csi_item_instance_pub.update_item_instance(l_api_version,

2180: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2181: debug('Instance Status - 9801681: '||l_update_instance_rec.instance_status_id);
2182: -- end bug 9801681
2183:
2184: csi_item_instance_pub.update_item_instance(l_api_version,
2185: l_commit,
2186: l_init_msg_list,
2187: l_validation_level,
2188: l_update_instance_rec,

Line 2211: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2207: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2208:
2209: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2240: csi_item_instance_pub.get_item_instances(l_api_version,

2236: l_locator_id := l_mtl_item_tbl(j).locator_id;
2237:
2238: debug('Before Get Dest Item Instance - 24');
2239:
2240: csi_item_instance_pub.get_item_instances(l_api_version,
2241: l_commit,
2242: l_init_msg_list,
2243: l_validation_level,
2244: l_instance_query_rec,

Line 2264: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

2260: debug('Source Records Found: '||l_tbl_count);
2261:
2262: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2310: csi_item_instance_pub.create_item_instance(l_api_version,

2306:
2307: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2308: debug('Before Create Item Instance - 26');
2309:
2310: csi_item_instance_pub.create_item_instance(l_api_version,
2311: l_commit,
2312: l_init_msg_list,
2313: l_validation_level,
2314: l_new_dest_instance_rec,

Line 2331: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2327: debug('You are Creating Instance: '||l_new_dest_instance_rec.instance_id);
2328:
2329: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2361: csi_item_instance_pub.update_item_instance(l_api_version,

2357: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2358: debug('Before Update Item Instance - 29');
2359: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);
2360:
2361: csi_item_instance_pub.update_item_instance(l_api_version,
2362: l_commit,
2363: l_init_msg_list,
2364: l_validation_level,
2365: l_update_dest_instance_rec,

Line 2387: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

2383: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2384:
2385: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2443: csi_item_instance_pub.update_item_instance(l_api_version,

2439: -- end bug 9801681
2440:
2441: debug('Before Update Item Instance - 21');
2442:
2443: csi_item_instance_pub.update_item_instance(l_api_version,
2444: l_commit,
2445: l_init_msg_list,
2446: l_validation_level,
2447: l_update_instance_rec,

Line 2470: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2466: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2467:
2468: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2501: csi_item_instance_pub.get_item_instances(l_api_version,

2497: l_locator_id := l_mtl_item_tbl(j).locator_id;
2498:
2499: debug('Before Get Dest Item Instance - 24');
2500:
2501: csi_item_instance_pub.get_item_instances(l_api_version,
2502: l_commit,
2503: l_init_msg_list,
2504: l_validation_level,
2505: l_instance_query_rec,

Line 2525: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

2521: debug('Source Records Found: '||l_tbl_count);
2522:
2523: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2571: csi_item_instance_pub.create_item_instance(l_api_version,

2567:
2568: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2569: debug('Before Create Item Instance - 26');
2570:
2571: csi_item_instance_pub.create_item_instance(l_api_version,
2572: l_commit,
2573: l_init_msg_list,
2574: l_validation_level,
2575: l_new_dest_instance_rec,

Line 2592: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2588: debug('You are Creating Instance: '||l_new_dest_instance_rec.instance_id);
2589:
2590: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2622: csi_item_instance_pub.update_item_instance(l_api_version,

2618: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2619: debug('Before Update Item Instance - 29');
2620: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);
2621:
2622: csi_item_instance_pub.update_item_instance(l_api_version,
2623: l_commit,
2624: l_init_msg_list,
2625: l_validation_level,
2626: l_update_dest_instance_rec,

Line 2648: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

2644: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2645:
2646: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2705: csi_item_instance_pub.update_item_instance(l_api_version,

2701: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2702: debug('Instance Status - 9801681: '||l_update_instance_rec.instance_status_id);
2703: -- end bug 9801681
2704:
2705: csi_item_instance_pub.update_item_instance(l_api_version,
2706: l_commit,
2707: l_init_msg_list,
2708: l_validation_level,
2709: l_upd_src_dest_instance_rec,

Line 2731: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2727: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2728:
2729: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2759: csi_item_instance_pub.get_item_instances(l_api_version,

2755: l_locator_id := l_mtl_item_tbl(j).locator_id;
2756:
2757: debug('Before Get Dest Item Instance - 37');
2758:
2759: csi_item_instance_pub.get_item_instances(l_api_version,
2760: l_commit,
2761: l_init_msg_list,
2762: l_validation_level,
2763: l_instance_query_rec,

Line 2783: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

2779: debug('Source Records Found: '||l_tbl_count);
2780:
2781: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2829: csi_item_instance_pub.create_item_instance(l_api_version,

2825:
2826: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2827: debug('Before Create Item Instance - 39');
2828:
2829: csi_item_instance_pub.create_item_instance(l_api_version,
2830: l_commit,
2831: l_init_msg_list,
2832: l_validation_level,
2833: l_new_dest_instance_rec,

Line 2850: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2846: debug('You are Creating Instance: '||l_new_dest_instance_rec.instance_id);
2847:
2848: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 2879: csi_item_instance_pub.update_item_instance(l_api_version,

2875:
2876: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2877: debug('Before Update Item Instance - 42');
2878:
2879: csi_item_instance_pub.update_item_instance(l_api_version,
2880: l_commit,
2881: l_init_msg_list,
2882: l_validation_level,
2883: l_update_dest_instance_rec,

Line 2905: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

2901: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2902:
2903: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3396: csi_item_instance_pub.get_item_instances(l_api_version,

3392:
3393: debug('Transaction Action Type:'|| l_trx_action_type);
3394: debug('Before Get Item Instance');
3395:
3396: csi_item_instance_pub.get_item_instances(l_api_version,
3397: l_commit,
3398: l_init_msg_list,
3399: l_validation_level,
3400: l_instance_query_rec,

Line 3420: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

3416: debug('Source Records Found: '||l_tbl_count);
3417:
3418: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3466: csi_item_instance_pub.update_item_instance(l_api_version,

3462: l_asset_assignment_tbl.delete;
3463:
3464: debug('Before Update Item Instance - 3');
3465:
3466: csi_item_instance_pub.update_item_instance(l_api_version,
3467: l_commit,
3468: l_init_msg_list,
3469: l_validation_level,
3470: l_update_instance_rec,

Line 3492: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

3488: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
3489:
3490: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3559: csi_item_instance_pub.create_item_instance(l_api_version,

3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3556:
3557: debug('Before Create Source Item Instance - 7');
3558:
3559: csi_item_instance_pub.create_item_instance(l_api_version,
3560: l_commit,
3561: l_init_msg_list,
3562: l_validation_level,
3563: l_new_src_instance_rec,

Line 3582: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

3578:
3579: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
3580:
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;

Line 3633: csi_item_instance_pub.update_item_instance(l_api_version,

3629: debug(l_upd_src_dest_instance_rec.instance_status_id);
3630:
3631: debug('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
3632:
3633: csi_item_instance_pub.update_item_instance(l_api_version,
3634: l_commit,
3635: l_init_msg_list,
3636: l_validation_level,
3637: l_upd_src_dest_instance_rec,

Line 3659: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

3655: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
3656:
3657: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3699: csi_item_instance_pub.get_item_instances(l_api_version,

3695: l_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
3696:
3697: debug('Before Get Item Instance - 13');
3698:
3699: csi_item_instance_pub.get_item_instances(l_api_version,
3700: l_commit,
3701: l_init_msg_list,
3702: l_validation_level,
3703: l_instance_query_rec,

Line 3723: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

3719: debug('Source Records Found: '||l_tbl_count);
3720:
3721: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3768: csi_item_instance_pub.create_item_instance(l_api_version,

3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3765:
3766: debug('Before Create Item Instance - 16');
3767:
3768: csi_item_instance_pub.create_item_instance(l_api_version,
3769: l_commit,
3770: l_init_msg_list,
3771: l_validation_level,
3772: l_new_dest_instance_rec,

Line 3790: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

3786:
3787: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
3788:
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;

Line 3820: csi_item_instance_pub.update_item_instance(l_api_version,

3816: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3817: debug('Before Update Item Instance - 19');
3818:
3819:
3820: csi_item_instance_pub.update_item_instance(l_api_version,
3821: l_commit,
3822: l_init_msg_list,
3823: l_validation_level,
3824: l_update_dest_instance_rec,

Line 3846: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

3842: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
3843:
3844: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3898: csi_item_instance_pub.update_item_instance(l_api_version,

3894: l_asset_assignment_tbl.delete;
3895:
3896: debug('Before Update Item Instance - 25');
3897:
3898: csi_item_instance_pub.update_item_instance(l_api_version,
3899: l_commit,
3900: l_init_msg_list,
3901: l_validation_level,
3902: l_update_instance_rec,

Line 3925: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

3921: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
3922:
3923: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 3955: csi_item_instance_pub.get_item_instances(l_api_version,

3951: l_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
3952:
3953: debug('Before Get Item Instance - 27');
3954:
3955: csi_item_instance_pub.get_item_instances(l_api_version,
3956: l_commit,
3957: l_init_msg_list,
3958: l_validation_level,
3959: l_instance_query_rec,

Line 3979: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

3975: debug('Source Records Found: '||l_tbl_count);
3976:
3977: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;

Line 4024: csi_item_instance_pub.create_item_instance(l_api_version,

4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4021:
4022: debug('Before Create Item Instance - 30');
4023:
4024: csi_item_instance_pub.create_item_instance(l_api_version,
4025: l_commit,
4026: l_init_msg_list,
4027: l_validation_level,
4028: l_new_dest_instance_rec,

Line 4046: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

4042:
4043: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
4044:
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;

Line 4075: csi_item_instance_pub.update_item_instance(l_api_version,

4071:
4072: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
4073: debug('Before Update Item Instance - 32');
4074:
4075: csi_item_instance_pub.update_item_instance(l_api_version,
4076: l_commit,
4077: l_init_msg_list,
4078: l_validation_level,
4079: l_update_dest_instance_rec,

Line 4101: debug('You encountered an error in the csi_item_instance_pub.c API '||l_msg_data);

4097: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
4098:
4099: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
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;