DBA Data[Home] [Help]

APPS.CSI_INV_HZ_PKG dependencies on CSI_ITEM_INSTANCE_PUB

Line 281: csi_item_instance_pub.get_item_instances(l_api_version,

277: csi_t_gen_utility_pvt.add('Ship to Location ID: '||l_mtl_item_tbl(j).ship_to_location_id);
278: csi_t_gen_utility_pvt.add('Before Get Item Instance');
279: END IF;
280:
281: csi_item_instance_pub.get_item_instances(l_api_version,
282: l_commit,
283: l_init_msg_list,
284: l_validation_level,
285: l_instance_query_rec,

Line 308: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

304: -- Check for any errors and add them to the message stack to pass out to be put into the
305: -- error log table.
306: IF NOT l_return_status = l_fnd_success then
307: IF (l_debug > 0) THEN
308: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
309: END IF;
310: l_msg_index := 1;
311: WHILE l_msg_count > 0 loop
312: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 361: csi_item_instance_pub.create_item_instance(l_api_version,

357: IF (l_debug > 0) THEN
358: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');
359: END IF;
360:
361: csi_item_instance_pub.create_item_instance(l_api_version,
362: l_commit,
363: l_init_msg_list,
364: l_validation_level,
365: l_new_src_instance_rec,

Line 390: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

386: -- Check for any errors and add them to the message stack to pass out to be put into the
387: -- error log table.
388: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
389: IF (l_debug > 0) THEN
390: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
391: END IF;
392: l_msg_index := 1;
393: WHILE l_msg_count > 0 loop
394: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 435: csi_item_instance_pub.update_item_instance(l_api_version,

431: IF (l_debug > 0) THEN
432: csi_t_gen_utility_pvt.add('Before Update Item Instance');
433: END IF;
434:
435: csi_item_instance_pub.update_item_instance(l_api_version,
436: l_commit,
437: l_init_msg_list,
438: l_validation_level,
439: l_update_source_instance_rec,

Line 468: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

464: -- Check for any errors and add them to the message stack to pass out to be put into the
465: -- error log table.
466: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
467: IF (l_debug > 0) THEN
468: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
469: END IF;
470: l_msg_index := 1;
471: WHILE l_msg_count > 0 loop
472: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 512: csi_item_instance_pub.get_item_instances(l_api_version,

508: csi_t_gen_utility_pvt.add('Ship to Location ID: '||l_mtl_item_tbl(j).ship_to_location_id);
509: csi_t_gen_utility_pvt.add('Location Type Code: '||l_location_type);
510: END IF;
511:
512: csi_item_instance_pub.get_item_instances(l_api_version,
513: l_commit,
514: l_init_msg_list,
515: l_validation_level,
516: l_instance_query_rec,

Line 539: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

535:
536: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
537: IF NOT l_return_status = l_fnd_success then
538: IF (l_debug > 0) THEN
539: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
540: END IF;
541: l_msg_index := 1;
542: WHILE l_msg_count > 0 loop
543: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 590: csi_item_instance_pub.create_item_instance(l_api_version,

586: IF (l_debug > 0) THEN
587: csi_t_gen_utility_pvt.add('Before Create Item Instance - 45');
588: END IF;
589:
590: csi_item_instance_pub.create_item_instance(l_api_version,
591: l_commit,
592: l_init_msg_list,
593: l_validation_level,
594: l_new_dest_instance_rec,

Line 613: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

609:
610: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
611: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
612: IF (l_debug > 0) THEN
613: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
614: END IF;
615: l_msg_index := 1;
616: WHILE l_msg_count > 0 loop
617: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 648: csi_item_instance_pub.update_item_instance(l_api_version,

644: IF (l_debug > 0) THEN
645: csi_t_gen_utility_pvt.add('Before Update Item Instance - Neg Qty');
646: END IF;
647:
648: csi_item_instance_pub.update_item_instance(l_api_version,
649: l_commit,
650: l_init_msg_list,
651: l_validation_level,
652: l_update_dest_instance_rec,

Line 676: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

672:
673: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
674: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
675: IF (l_debug > 0) THEN
676: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
677: END IF;
678: l_msg_index := 1;
679: WHILE l_msg_count > 0 loop
680: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 738: csi_item_instance_pub.update_item_instance(l_api_version,

734: IF (l_debug > 0) THEN
735: csi_t_gen_utility_pvt.add('Before Update Item Instance');
736: END IF;
737:
738: csi_item_instance_pub.update_item_instance(l_api_version,
739: l_commit,
740: l_init_msg_list,
741: l_validation_level,
742: l_update_instance_rec,

Line 767: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

763: -- Check for any errors and add them to the message stack to pass out to be put into the
764: -- error log table.
765: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
766: IF (l_debug > 0) THEN
767: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
768: END IF;
769: l_msg_index := 1;
770: WHILE l_msg_count > 0 loop
771: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1171: csi_item_instance_pub.get_item_instances(l_api_version,

1167: csi_t_gen_utility_pvt.add('Before Get Item Instance');
1168: csi_t_gen_utility_pvt.add('Ship to Location ID: '||l_mtl_item_tbl(j).ship_to_location_id);
1169: END IF;
1170:
1171: csi_item_instance_pub.get_item_instances(l_api_version,
1172: l_commit,
1173: l_init_msg_list,
1174: l_validation_level,
1175: l_instance_query_rec,

Line 1199: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1195: -- Check for any errors and add them to the message stack to pass out to be put into the
1196: -- error log table.
1197: IF NOT l_return_status = l_fnd_success then
1198: IF (l_debug > 0) THEN
1199: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1200: END IF;
1201: l_msg_index := 1;
1202: WHILE l_msg_count > 0 loop
1203: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1300: csi_item_instance_pub.update_item_instance(l_api_version,

1296: IF (l_debug > 0) THEN
1297: csi_t_gen_utility_pvt.add('Before Update Item Instance');
1298: END IF;
1299:
1300: csi_item_instance_pub.update_item_instance(l_api_version,
1301: l_commit,
1302: l_init_msg_list,
1303: l_validation_level,
1304: l_update_instance_rec,

Line 1330: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1326: -- Check for any errors and add them to the message stack to pass out to be put into the
1327: -- error log table.
1328: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1329: IF (l_debug > 0) THEN
1330: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1331: END IF;
1332: l_msg_index := 1;
1333: WHILE l_msg_count > 0 loop
1334: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1391: csi_item_instance_pub.create_item_instance(l_api_version,

1387: csi_t_gen_utility_pvt.add('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));
1388: csi_t_gen_utility_pvt.add('You will now Create a new Item Instance Record');
1389: csi_t_gen_utility_pvt.add('Serial Number: '||l_new_instance_rec.serial_number);
1390:
1391: csi_item_instance_pub.create_item_instance(l_api_version,
1392: l_commit,
1393: l_init_msg_list,
1394: l_validation_level,
1395: l_new_instance_rec,

Line 1410: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

1406:
1407: -- Check for any errors and add them to the message stack to pass out to be put into the
1408: -- error log table.
1409: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1410: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1411: l_msg_index := 1;
1412: WHILE l_msg_count > 0 loop
1413: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1414: l_msg_index := l_msg_index + 1;

Line 1456: csi_item_instance_pub.get_item_instances(l_api_version,

1452: csi_t_gen_utility_pvt.add('Ship to Location ID Non Ser: '||l_mtl_item_tbl(j).ship_to_location_id);
1453: csi_t_gen_utility_pvt.add('Location Type Code: '||l_location_type);
1454: END IF;
1455:
1456: csi_item_instance_pub.get_item_instances(l_api_version,
1457: l_commit,
1458: l_init_msg_list,
1459: l_validation_level,
1460: l_instance_query_rec,

Line 1484: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1480: -- Check for any errors and add them to the message stack to pass out to be put into the
1481: -- error log table.
1482: IF NOT l_return_status = l_fnd_success then
1483: IF (l_debug > 0) THEN
1484: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1485: END IF;
1486: l_msg_index := 1;
1487: WHILE l_msg_count > 0 loop
1488: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1549: csi_item_instance_pub.update_item_instance(l_api_version,

1545: IF (l_debug > 0) THEN
1546: csi_t_gen_utility_pvt.add('Before Update Item Instance: '||l_src_instance_header_tbl(oos).instance_id);
1547: END IF;
1548:
1549: csi_item_instance_pub.update_item_instance(l_api_version,
1550: l_commit,
1551: l_init_msg_list,
1552: l_validation_level,
1553: l_upd_src_dest_instance_rec,

Line 1577: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1573:
1574: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1575: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1576: IF (l_debug > 0) THEN
1577: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1578: END IF;
1579: l_msg_index := 1;
1580: WHILE l_msg_count > 0 loop
1581: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1647: csi_item_instance_pub.update_item_instance(l_api_version,

1643: IF (l_debug > 0) THEN
1644: csi_t_gen_utility_pvt.add('Before Update Item Instance: '||l_src_instance_header_tbl(ins).instance_id);
1645: END IF;
1646:
1647: csi_item_instance_pub.update_item_instance(l_api_version,
1648: l_commit,
1649: l_init_msg_list,
1650: l_validation_level,
1651: l_upd_src_dest_instance_rec,

Line 1675: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1671:
1672: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1673: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1674: IF (l_debug > 0) THEN
1675: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1676: END IF;
1677: l_msg_index := 1;
1678: WHILE l_msg_count > 0 loop
1679: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1744: csi_item_instance_pub.update_item_instance(l_api_version,

1740: IF (l_debug > 0) THEN
1741: csi_t_gen_utility_pvt.add('Before Update Item Instance: '||l_src_instance_header_tbl(inser).instance_id);
1742: END IF;
1743:
1744: csi_item_instance_pub.update_item_instance(l_api_version,
1745: l_commit,
1746: l_init_msg_list,
1747: l_validation_level,
1748: l_upd_src_dest_instance_rec,

Line 1772: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1768:
1769: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1770: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1771: IF (l_debug > 0) THEN
1772: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1773: END IF;
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);

Line 1802: csi_item_instance_pub.get_item_instances(l_api_version,

1798: IF (l_debug > 0) THEN
1799: csi_t_gen_utility_pvt.add('Before Get Item Instance');
1800: END IF;
1801:
1802: csi_item_instance_pub.get_item_instances(l_api_version,
1803: l_commit,
1804: l_init_msg_list,
1805: l_validation_level,
1806: l_instance_dest_query_rec,

Line 1829: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1825:
1826: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1827: IF NOT l_return_status = l_fnd_success then
1828: IF (l_debug > 0) THEN
1829: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1830: END IF;
1831: l_msg_index := 1;
1832: WHILE l_msg_count > 0 loop
1833: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1877: csi_item_instance_pub.create_item_instance(l_api_version,

1873: IF (l_debug > 0) THEN
1874: csi_t_gen_utility_pvt.add('Before Create Item Instance');
1875: END IF;
1876:
1877: csi_item_instance_pub.create_item_instance(l_api_version,
1878: l_commit,
1879: l_init_msg_list,
1880: l_validation_level,
1881: l_new_dest_instance_rec,

Line 1900: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

1896:
1897: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1898: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1899: IF (l_debug > 0) THEN
1900: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1901: END IF;
1902: l_msg_index := 1;
1903: WHILE l_msg_count > 0 loop
1904: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 1931: csi_item_instance_pub.update_item_instance(l_api_version,

1927: IF (l_debug > 0) THEN
1928: csi_t_gen_utility_pvt.add('Before Update Item Instance');
1929: END IF;
1930:
1931: csi_item_instance_pub.update_item_instance(l_api_version,
1932: l_commit,
1933: l_init_msg_list,
1934: l_validation_level,
1935: l_update_instance_rec,

Line 1960: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1956: -- Check for any errors and add them to the message stack to pass out to be put into the
1957: -- error log table.
1958: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1959: IF (l_debug > 0) THEN
1960: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1961: END IF;
1962: l_msg_index := 1;
1963: WHILE l_msg_count > 0 loop
1964: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2018: csi_item_instance_pub.get_item_instances(l_api_version,

2014: IF (l_debug > 0) THEN
2015: csi_t_gen_utility_pvt.add('Before Get Item Instance');
2016: END IF;
2017:
2018: csi_item_instance_pub.get_item_instances(l_api_version,
2019: l_commit,
2020: l_init_msg_list,
2021: l_validation_level,
2022: l_instance_dest_query_rec,

Line 2045: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

2041:
2042: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2043: IF NOT l_return_status = l_fnd_success then
2044: IF (l_debug > 0) THEN
2045: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2046: END IF;
2047: l_msg_index := 1;
2048: WHILE l_msg_count > 0 loop
2049: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2093: csi_item_instance_pub.create_item_instance(l_api_version,

2089: IF (l_debug > 0) THEN
2090: csi_t_gen_utility_pvt.add('Before Create Item Instance');
2091: END IF;
2092:
2093: csi_item_instance_pub.create_item_instance(l_api_version,
2094: l_commit,
2095: l_init_msg_list,
2096: l_validation_level,
2097: l_new_dest_instance_rec,

Line 2116: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2112:
2113: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2114: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2115: IF (l_debug > 0) THEN
2116: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2117: END IF;
2118: l_msg_index := 1;
2119: WHILE l_msg_count > 0 loop
2120: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2147: csi_item_instance_pub.update_item_instance(l_api_version,

2143: IF (l_debug > 0) THEN
2144: csi_t_gen_utility_pvt.add('Before Update Item Instance');
2145: END IF;
2146:
2147: csi_item_instance_pub.update_item_instance(l_api_version,
2148: l_commit,
2149: l_init_msg_list,
2150: l_validation_level,
2151: l_update_instance_rec,

Line 2176: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2172: -- Check for any errors and add them to the message stack to pass out to be put into the
2173: -- error log table.
2174: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2175: IF (l_debug > 0) THEN
2176: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2177: END IF;
2178: l_msg_index := 1;
2179: WHILE l_msg_count > 0 loop
2180: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2545: csi_item_instance_pub.get_item_instances(l_api_version,

2541: csi_t_gen_utility_pvt.add('Before Get Item Instance');
2542: csi_t_gen_utility_pvt.add('Ship to Location ID: '||l_mtl_item_tbl(j).ship_to_location_id);
2543: END IF;
2544:
2545: csi_item_instance_pub.get_item_instances(l_api_version,
2546: l_commit,
2547: l_init_msg_list,
2548: l_validation_level,
2549: l_instance_query_rec,

Line 2573: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

2569: -- Check for any errors and add them to the message stack to pass out to be put into the
2570: -- error log table.
2571: IF NOT l_return_status = l_fnd_success then
2572: IF (l_debug > 0) THEN
2573: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2574: END IF;
2575: l_msg_index := 1;
2576: WHILE l_msg_count > 0 loop
2577: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2625: csi_item_instance_pub.create_item_instance(l_api_version,

2621: IF (l_debug > 0) THEN
2622: csi_t_gen_utility_pvt.add('Before Create Transaction - Neg Qty');
2623: END IF;
2624:
2625: csi_item_instance_pub.create_item_instance(l_api_version,
2626: l_commit,
2627: l_init_msg_list,
2628: l_validation_level,
2629: l_new_src_instance_rec,

Line 2650: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2646: -- Check for any errors and add them to the message stack to pass out to be put into the
2647: -- error log table.
2648: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2649: IF (l_debug > 0) THEN
2650: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2651: END IF;
2652: l_msg_index := 1;
2653: WHILE l_msg_count > 0 loop
2654: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2698: csi_item_instance_pub.update_item_instance(l_api_version,

2694: IF (l_debug > 0) THEN
2695: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_source_instance_rec.instance_status_id);
2696: END IF;
2697:
2698: csi_item_instance_pub.update_item_instance(l_api_version,
2699: l_commit,
2700: l_init_msg_list,
2701: l_validation_level,
2702: l_update_source_instance_rec,

Line 2726: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2722:
2723: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2724: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2725: IF (l_debug > 0) THEN
2726: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2727: END IF;
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);

Line 2772: csi_item_instance_pub.get_item_instances(l_api_version,

2768: csi_t_gen_utility_pvt.add('Ship to Location ID Non Ser: '||l_mtl_item_tbl(j).ship_to_location_id);
2769: csi_t_gen_utility_pvt.add('Location Type Code: '||l_location_type);
2770: END IF;
2771:
2772: csi_item_instance_pub.get_item_instances(l_api_version,
2773: l_commit,
2774: l_init_msg_list,
2775: l_validation_level,
2776: l_instance_query_rec,

Line 2800: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

2796: -- Check for any errors and add them to the message stack to pass out to be put into the
2797: -- error log table.
2798: IF NOT l_return_status = l_fnd_success then
2799: IF (l_debug > 0) THEN
2800: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
2801: END IF;
2802: l_msg_index := 1;
2803: WHILE l_msg_count > 0 loop
2804: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2850: csi_item_instance_pub.create_item_instance(l_api_version,

2846: IF (l_debug > 0) THEN
2847: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');
2848: END IF;
2849:
2850: csi_item_instance_pub.create_item_instance(l_api_version,
2851: l_commit,
2852: l_init_msg_list,
2853: l_validation_level,
2854: l_new_dest_instance_rec,

Line 2874: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2870: -- Check for any errors and add them to the message stack to pass out to be put into the
2871: -- error log table.
2872: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2873: IF (l_debug > 0) THEN
2874: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2875: END IF;
2876: l_msg_index := 1;
2877: WHILE l_msg_count > 0 loop
2878: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2909: csi_item_instance_pub.update_item_instance(l_api_version,

2905: IF (l_debug > 0) THEN
2906: csi_t_gen_utility_pvt.add('Before Update Transaction - Neg Qty');
2907: END IF;
2908:
2909: csi_item_instance_pub.update_item_instance(l_api_version,
2910: l_commit,
2911: l_init_msg_list,
2912: l_validation_level,
2913: l_update_dest_instance_rec,

Line 2938: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2934: -- Check for any errors and add them to the message stack to pass out to be put into the
2935: -- error log table.
2936: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2937: IF (l_debug > 0) THEN
2938: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2939: END IF;
2940: l_msg_index := 1;
2941: WHILE l_msg_count > 0 loop
2942: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

Line 2996: csi_item_instance_pub.update_item_instance(l_api_version,

2992: csi_t_gen_utility_pvt.add('Before Update Item Instance');
2993: csi_t_gen_utility_pvt.add('Ship to Location ID Serialized: '||l_mtl_item_tbl(j).ship_to_location_id);
2994: END IF;
2995:
2996: csi_item_instance_pub.update_item_instance(l_api_version,
2997: l_commit,
2998: l_init_msg_list,
2999: l_validation_level,
3000: l_update_instance_rec,

Line 3025: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

3021: -- Check for any errors and add them to the message stack to pass out to be put into the
3022: -- error log table.
3023: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3024: IF (l_debug > 0) THEN
3025: csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3026: END IF;
3027: l_msg_index := 1;
3028: WHILE l_msg_count > 0 loop
3029: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);