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 332: csi_item_instance_pub.get_item_instances(l_api_version,

328:
329: debug('Transaction Action Type:'|| l_trx_action_type);
330: debug('Before Get Item Instance - 1');
331:
332: csi_item_instance_pub.get_item_instances(l_api_version,
333: l_commit,
334: l_init_msg_list,
335: l_validation_level,
336: l_instance_query_rec,

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

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

Line 403: csi_item_instance_pub.update_item_instance(l_api_version,

399: l_asset_assignment_tbl.delete;
400:
401: debug('Before Update Item Instance - 5');
402:
403: csi_item_instance_pub.update_item_instance(l_api_version,
404: l_commit,
405: l_init_msg_list,
406: l_validation_level,
407: l_update_instance_rec,

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

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

Line 485: csi_item_instance_pub.update_item_instance(l_api_version,

481: l_asset_assignment_tbl.delete;
482:
483: debug('Before Update Item Instance - 9');
484:
485: csi_item_instance_pub.update_item_instance(l_api_version,
486: l_commit,
487: l_init_msg_list,
488: l_validation_level,
489: l_update_instance_rec,

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

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

Line 550: csi_item_instance_pub.get_item_instances(l_api_version,

546: csi_t_gen_utility_pvt.dump_instance_query_rec(l_instance_query_rec);
547:
548: debug('Before Get Item Instance for Dest Non Serialized Instance-11');
549:
550: csi_item_instance_pub.get_item_instances(l_api_version,
551: l_commit,
552: l_init_msg_list,
553: l_validation_level,
554: l_instance_query_rec,

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

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

Line 621: csi_item_instance_pub.create_item_instance(l_api_version,

617: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
618:
619: debug('Before Create Item Instance-14');
620:
621: csi_item_instance_pub.create_item_instance(l_api_version,
622: l_commit,
623: l_init_msg_list,
624: l_validation_level,
625: l_new_dest_instance_rec,

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

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

Line 687: csi_item_instance_pub.update_item_instance(l_api_version,

683:
684: debug('Before Update Item Instance-16');
685: debug('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);
686:
687: csi_item_instance_pub.update_item_instance(l_api_version,
688: l_commit,
689: l_init_msg_list,
690: l_validation_level,
691: l_update_dest_instance_rec,

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

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

Line 801: csi_item_instance_pub.create_item_instance(l_api_version,

797: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
798:
799: debug('Before Create Source Item Instance - 9');
800:
801: csi_item_instance_pub.create_item_instance(l_api_version,
802: l_commit,
803: l_init_msg_list,
804: l_validation_level,
805: l_new_src_instance_rec,

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

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

Line 868: csi_item_instance_pub.update_item_instance(l_api_version,

864: 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);
865:
866: debug('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
867:
868: csi_item_instance_pub.update_item_instance(l_api_version,
869: l_commit,
870: l_init_msg_list,
871: l_validation_level,
872: l_upd_src_dest_instance_rec,

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

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

Line 946: csi_item_instance_pub.get_item_instances(l_api_version,

942: l_locator_id := NULL;
943:
944: debug('Before Get Item Instance - 17');
945:
946: csi_item_instance_pub.get_item_instances(l_api_version,
947: l_commit,
948: l_init_msg_list,
949: l_validation_level,
950: l_instance_query_rec,

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

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

Line 1014: csi_item_instance_pub.create_item_instance(l_api_version,

1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1011:
1012: debug('Before Create Item Instance - 20');
1013:
1014: csi_item_instance_pub.create_item_instance(l_api_version,
1015: l_commit,
1016: l_init_msg_list,
1017: l_validation_level,
1018: l_new_dest_instance_rec,

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

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

Line 1065: csi_item_instance_pub.update_item_instance(l_api_version,

1061:
1062: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1063: debug('Before Update Item Instance - 23');
1064:
1065: csi_item_instance_pub.update_item_instance(l_api_version,
1066: l_commit,
1067: l_init_msg_list,
1068: l_validation_level,
1069: l_update_dest_instance_rec,

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

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

Line 1569: csi_item_instance_pub.get_item_instances(l_api_version,

1565:
1566: debug('Transaction Action Type:'|| l_trx_action_type);
1567: debug('Before Get Item Instance - 1');
1568:
1569: csi_item_instance_pub.get_item_instances(l_api_version,
1570: l_commit,
1571: l_init_msg_list,
1572: l_validation_level,
1573: l_instance_query_rec,

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

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

Line 1652: csi_item_instance_pub.update_item_instance(l_api_version,

1648: l_asset_assignment_tbl.delete;
1649:
1650: debug('Before Update Item Instance - 4');
1651:
1652: csi_item_instance_pub.update_item_instance(l_api_version,
1653: l_commit,
1654: l_init_msg_list,
1655: l_validation_level,
1656: l_update_instance_rec,

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

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

Line 1715: csi_item_instance_pub.update_item_instance(l_api_version,

1711: l_asset_assignment_tbl.delete;
1712:
1713: debug('Before Update Item Instance - 6');
1714:
1715: csi_item_instance_pub.update_item_instance(l_api_version,
1716: l_commit,
1717: l_init_msg_list,
1718: l_validation_level,
1719: l_upd_src_dest_instance_rec,

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

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

Line 1779: csi_item_instance_pub.get_item_instances(l_api_version,

1775: debug('Locator ID: '||l_instance_query_rec.inv_locator_id);
1776:
1777: debug('Before Get Dest Item Instance - 8');
1778:
1779: csi_item_instance_pub.get_item_instances(l_api_version,
1780: l_commit,
1781: l_init_msg_list,
1782: l_validation_level,
1783: l_instance_query_rec,

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

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

Line 1850: csi_item_instance_pub.create_item_instance(l_api_version,

1846:
1847: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
1848: debug('Before Create Item Instance - 10');
1849:
1850: csi_item_instance_pub.create_item_instance(l_api_version,
1851: l_commit,
1852: l_init_msg_list,
1853: l_validation_level,
1854: l_new_dest_instance_rec,

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

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

Line 1921: csi_item_instance_pub.update_item_instance(l_api_version,

1917:
1918: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1919: debug('Before Update Item Instance - 13');
1920:
1921: csi_item_instance_pub.update_item_instance(l_api_version,
1922: l_commit,
1923: l_init_msg_list,
1924: l_validation_level,
1925: l_update_dest_instance_rec,

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

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

Line 1999: csi_item_instance_pub.get_item_instance_details

1995: -- Instance.
1996:
1997: l_instance_header_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1998: -- Call details to get Party Information
1999: csi_item_instance_pub.get_item_instance_details
2000: (l_api_version,
2001: l_commit,
2002: l_init_msg_list,
2003: l_validation_level,

Line 2063: csi_item_instance_pub.update_item_instance(l_api_version,

2059:
2060: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2061: debug('Before Update Item Instance - 13');
2062:
2063: csi_item_instance_pub.update_item_instance(l_api_version,
2064: l_commit,
2065: l_init_msg_list,
2066: l_validation_level,
2067: l_update_dest_instance_rec,

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

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

Line 2148: csi_item_instance_pub.update_item_instance(l_api_version,

2144: l_asset_assignment_tbl.delete;
2145:
2146: debug('Before Update Item Instance - 21');
2147:
2148: csi_item_instance_pub.update_item_instance(l_api_version,
2149: l_commit,
2150: l_init_msg_list,
2151: l_validation_level,
2152: l_update_instance_rec,

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

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

Line 2204: csi_item_instance_pub.get_item_instances(l_api_version,

2200: l_locator_id := l_mtl_item_tbl(j).locator_id;
2201:
2202: debug('Before Get Dest Item Instance - 24');
2203:
2204: csi_item_instance_pub.get_item_instances(l_api_version,
2205: l_commit,
2206: l_init_msg_list,
2207: l_validation_level,
2208: l_instance_query_rec,

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

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

Line 2274: csi_item_instance_pub.create_item_instance(l_api_version,

2270:
2271: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2272: debug('Before Create Item Instance - 26');
2273:
2274: csi_item_instance_pub.create_item_instance(l_api_version,
2275: l_commit,
2276: l_init_msg_list,
2277: l_validation_level,
2278: l_new_dest_instance_rec,

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

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

Line 2325: csi_item_instance_pub.update_item_instance(l_api_version,

2321: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2322: debug('Before Update Item Instance - 29');
2323: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);
2324:
2325: csi_item_instance_pub.update_item_instance(l_api_version,
2326: l_commit,
2327: l_init_msg_list,
2328: l_validation_level,
2329: l_update_dest_instance_rec,

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

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

Line 2401: csi_item_instance_pub.update_item_instance(l_api_version,

2397: l_asset_assignment_tbl.delete;
2398:
2399: debug('Before Update Item Instance - 21');
2400:
2401: csi_item_instance_pub.update_item_instance(l_api_version,
2402: l_commit,
2403: l_init_msg_list,
2404: l_validation_level,
2405: l_update_instance_rec,

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

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

Line 2459: csi_item_instance_pub.get_item_instances(l_api_version,

2455: l_locator_id := l_mtl_item_tbl(j).locator_id;
2456:
2457: debug('Before Get Dest Item Instance - 24');
2458:
2459: csi_item_instance_pub.get_item_instances(l_api_version,
2460: l_commit,
2461: l_init_msg_list,
2462: l_validation_level,
2463: l_instance_query_rec,

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

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

Line 2529: csi_item_instance_pub.create_item_instance(l_api_version,

2525:
2526: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2527: debug('Before Create Item Instance - 26');
2528:
2529: csi_item_instance_pub.create_item_instance(l_api_version,
2530: l_commit,
2531: l_init_msg_list,
2532: l_validation_level,
2533: l_new_dest_instance_rec,

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

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

Line 2580: csi_item_instance_pub.update_item_instance(l_api_version,

2576: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2577: debug('Before Update Item Instance - 29');
2578: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);
2579:
2580: csi_item_instance_pub.update_item_instance(l_api_version,
2581: l_commit,
2582: l_init_msg_list,
2583: l_validation_level,
2584: l_update_dest_instance_rec,

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

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

Line 2649: csi_item_instance_pub.update_item_instance(l_api_version,

2645: l_asset_assignment_tbl.delete;
2646:
2647: debug('Before Update Item Instance - 35');
2648:
2649: csi_item_instance_pub.update_item_instance(l_api_version,
2650: l_commit,
2651: l_init_msg_list,
2652: l_validation_level,
2653: l_upd_src_dest_instance_rec,

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

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

Line 2703: csi_item_instance_pub.get_item_instances(l_api_version,

2699: l_locator_id := l_mtl_item_tbl(j).locator_id;
2700:
2701: debug('Before Get Dest Item Instance - 37');
2702:
2703: csi_item_instance_pub.get_item_instances(l_api_version,
2704: l_commit,
2705: l_init_msg_list,
2706: l_validation_level,
2707: l_instance_query_rec,

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

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

Line 2773: csi_item_instance_pub.create_item_instance(l_api_version,

2769:
2770: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2771: debug('Before Create Item Instance - 39');
2772:
2773: csi_item_instance_pub.create_item_instance(l_api_version,
2774: l_commit,
2775: l_init_msg_list,
2776: l_validation_level,
2777: l_new_dest_instance_rec,

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

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

Line 2823: csi_item_instance_pub.update_item_instance(l_api_version,

2819:
2820: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2821: debug('Before Update Item Instance - 42');
2822:
2823: csi_item_instance_pub.update_item_instance(l_api_version,
2824: l_commit,
2825: l_init_msg_list,
2826: l_validation_level,
2827: l_update_dest_instance_rec,

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

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

Line 3336: csi_item_instance_pub.get_item_instances(l_api_version,

3332:
3333: debug('Transaction Action Type:'|| l_trx_action_type);
3334: debug('Before Get Item Instance');
3335:
3336: csi_item_instance_pub.get_item_instances(l_api_version,
3337: l_commit,
3338: l_init_msg_list,
3339: l_validation_level,
3340: l_instance_query_rec,

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

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

Line 3406: csi_item_instance_pub.update_item_instance(l_api_version,

3402: l_asset_assignment_tbl.delete;
3403:
3404: debug('Before Update Item Instance - 3');
3405:
3406: csi_item_instance_pub.update_item_instance(l_api_version,
3407: l_commit,
3408: l_init_msg_list,
3409: l_validation_level,
3410: l_update_instance_rec,

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

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

Line 3499: csi_item_instance_pub.create_item_instance(l_api_version,

3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3496:
3497: debug('Before Create Source Item Instance - 7');
3498:
3499: csi_item_instance_pub.create_item_instance(l_api_version,
3500: l_commit,
3501: l_init_msg_list,
3502: l_validation_level,
3503: l_new_src_instance_rec,

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

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

Line 3573: csi_item_instance_pub.update_item_instance(l_api_version,

3569: debug(l_upd_src_dest_instance_rec.instance_status_id);
3570:
3571: debug('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
3572:
3573: csi_item_instance_pub.update_item_instance(l_api_version,
3574: l_commit,
3575: l_init_msg_list,
3576: l_validation_level,
3577: l_upd_src_dest_instance_rec,

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

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

Line 3639: csi_item_instance_pub.get_item_instances(l_api_version,

3635: l_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
3636:
3637: debug('Before Get Item Instance - 13');
3638:
3639: csi_item_instance_pub.get_item_instances(l_api_version,
3640: l_commit,
3641: l_init_msg_list,
3642: l_validation_level,
3643: l_instance_query_rec,

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

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

Line 3708: csi_item_instance_pub.create_item_instance(l_api_version,

3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3705:
3706: debug('Before Create Item Instance - 16');
3707:
3708: csi_item_instance_pub.create_item_instance(l_api_version,
3709: l_commit,
3710: l_init_msg_list,
3711: l_validation_level,
3712: l_new_dest_instance_rec,

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

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

Line 3760: csi_item_instance_pub.update_item_instance(l_api_version,

3756: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3757: debug('Before Update Item Instance - 19');
3758:
3759:
3760: csi_item_instance_pub.update_item_instance(l_api_version,
3761: l_commit,
3762: l_init_msg_list,
3763: l_validation_level,
3764: l_update_dest_instance_rec,

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

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

Line 3838: csi_item_instance_pub.update_item_instance(l_api_version,

3834: l_asset_assignment_tbl.delete;
3835:
3836: debug('Before Update Item Instance - 25');
3837:
3838: csi_item_instance_pub.update_item_instance(l_api_version,
3839: l_commit,
3840: l_init_msg_list,
3841: l_validation_level,
3842: l_update_instance_rec,

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

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

Line 3895: csi_item_instance_pub.get_item_instances(l_api_version,

3891: l_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
3892:
3893: debug('Before Get Item Instance - 27');
3894:
3895: csi_item_instance_pub.get_item_instances(l_api_version,
3896: l_commit,
3897: l_init_msg_list,
3898: l_validation_level,
3899: l_instance_query_rec,

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

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

Line 3964: csi_item_instance_pub.create_item_instance(l_api_version,

3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3961:
3962: debug('Before Create Item Instance - 30');
3963:
3964: csi_item_instance_pub.create_item_instance(l_api_version,
3965: l_commit,
3966: l_init_msg_list,
3967: l_validation_level,
3968: l_new_dest_instance_rec,

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

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

Line 4015: csi_item_instance_pub.update_item_instance(l_api_version,

4011:
4012: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
4013: debug('Before Update Item Instance - 32');
4014:
4015: csi_item_instance_pub.update_item_instance(l_api_version,
4016: l_commit,
4017: l_init_msg_list,
4018: l_validation_level,
4019: l_update_dest_instance_rec,

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

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