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_TRXS_PKG dependencies on CSI_ITEM_INSTANCE_PUB

Line 371: csi_item_instance_pub.get_item_instances(l_api_version,

367: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
368:
369: debug('Calling get_item_instance');
370:
371: csi_item_instance_pub.get_item_instances(l_api_version,
372: l_commit,
373: l_init_msg_list,
374: l_validation_level,
375: l_instance_query_rec,

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

392:
393: -- Check for any errors and add them to the message stack to pass out to be put into the
394: -- error log table.
395: IF NOT l_return_status = l_fnd_success then
396: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
397: l_msg_index := 1;
398: WHILE l_msg_count > 0 loop
399: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
400: l_msg_index := l_msg_index + 1;

Line 444: csi_item_instance_pub.create_item_instance(l_api_version,

440: debug('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));
441: debug('You will now Create a new Item Instance Record');
442: debug('Serial Number: '||l_new_instance_rec.serial_number);
443:
444: csi_item_instance_pub.create_item_instance(l_api_version,
445: l_commit,
446: l_init_msg_list,
447: l_validation_level,
448: l_new_instance_rec,

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

459:
460: -- Check for any errors and add them to the message stack to pass out to be put into the
461: -- error log table.
462: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
463: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
464: l_msg_index := 1;
465: WHILE l_msg_count > 0 loop
466: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
467: l_msg_index := l_msg_index + 1;

Line 520: csi_item_instance_pub.update_item_instance(l_api_version,

516: 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);
517:
518: debug('Before Update Item Instance');
519:
520: csi_item_instance_pub.update_item_instance(l_api_version,
521: l_commit,
522: l_init_msg_list,
523: l_validation_level,
524: l_update_instance_rec,

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

543:
544: -- Check for any errors and add them to the message stack to pass out to be put into the
545: -- error log table.
546: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
547: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
548: l_msg_index := 1;
549: WHILE l_msg_count > 0 loop
550: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
551: l_msg_index := l_msg_index + 1;

Line 647: csi_item_instance_pub.get_item_instance_details

643: -- Instance.
644:
645: l_instance_header_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
646: -- Call details to get Party Information
647: csi_item_instance_pub.get_item_instance_details
648: (l_api_version,
649: l_commit,
650: l_init_msg_list,
651: l_validation_level,

Line 752: csi_item_instance_pub.update_item_instance(l_api_version,

748: 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);
749:
750: debug('Before Update Item Instance');
751:
752: csi_item_instance_pub.update_item_instance(l_api_version,
753: l_commit,
754: l_init_msg_list,
755: l_validation_level,
756: l_update_instance_rec,

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

774: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
775:
776: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
777: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
778: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
779: l_msg_index := 1;
780: WHILE l_msg_count > 0 loop
781: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
782: l_msg_index := l_msg_index + 1;

Line 841: csi_item_instance_pub.create_item_instance(l_api_version,

837: l_new_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);
838:
839: debug('You will now Create a new Item Instance Record');
840:
841: csi_item_instance_pub.create_item_instance(l_api_version,
842: l_commit,
843: l_init_msg_list,
844: l_validation_level,
845: l_new_instance_rec,

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

856:
857: -- Check for any errors and add them to the message stack to pass out to be put into the
858: -- error log table.
859: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
860: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
861: l_msg_index := 1;
862: WHILE l_msg_count > 0 loop
863: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
864: l_msg_index := l_msg_index + 1;

Line 891: csi_item_instance_pub.get_item_instances(l_api_version,

887:
888:
889: debug('Calling get_item_instance');
890:
891: csi_item_instance_pub.get_item_instances(l_api_version,
892: l_commit,
893: l_init_msg_list,
894: l_validation_level,
895: l_instance_query_rec,

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

912:
913: -- Check for any errors and add them to the message stack to pass out to be put into the
914: -- error log table.
915: IF NOT l_return_status = l_fnd_success then
916: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
917: l_msg_index := 1;
918: WHILE l_msg_count > 0 loop
919: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
920: l_msg_index := l_msg_index + 1;

Line 961: csi_item_instance_pub.create_item_instance(l_api_version,

957: l_new_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);
958:
959: debug('You will now Create a new Item Instance Record');
960:
961: csi_item_instance_pub.create_item_instance(l_api_version,
962: l_commit,
963: l_init_msg_list,
964: l_validation_level,
965: l_new_instance_rec,

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

976:
977: -- Check for any errors and add them to the message stack to pass out to be put into the
978: -- error log table.
979: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
980: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
981: l_msg_index := 1;
982: WHILE l_msg_count > 0 loop
983: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
984: l_msg_index := l_msg_index + 1;

Line 1013: csi_item_instance_pub.update_item_instance(l_api_version,

1009: 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);
1010:
1011: debug('Before Update Item Instance');
1012:
1013: csi_item_instance_pub.update_item_instance(l_api_version,
1014: l_commit,
1015: l_init_msg_list,
1016: l_validation_level,
1017: l_update_instance_rec,

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

1035:
1036: -- Check for any errors and add them to the message stack to pass out to be put into the
1037: -- error log table.
1038: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1039: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1040: l_msg_index := 1;
1041: WHILE l_msg_count > 0 loop
1042: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1043: l_msg_index := l_msg_index + 1;

Line 1426: csi_item_instance_pub.get_item_instances(l_api_version,

1422: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
1423:
1424: debug('Before Get Item Instance');
1425:
1426: csi_item_instance_pub.get_item_instances(l_api_version,
1427: l_commit,
1428: l_init_msg_list,
1429: l_validation_level,
1430: l_instance_query_rec,

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

1447:
1448: -- Check for any errors and add them to the message stack to pass out to be put into the
1449: -- error log table.
1450: IF NOT l_return_status = l_fnd_success then
1451: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1452: l_msg_index := 1;
1453: WHILE l_msg_count > 0 loop
1454: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1455: l_msg_index := l_msg_index + 1;

Line 1501: csi_item_instance_pub.create_item_instance(l_api_version,

1497: l_new_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);
1498:
1499: debug('Before Create of new source Item Instance');
1500:
1501: csi_item_instance_pub.create_item_instance(l_api_version,
1502: l_commit,
1503: l_init_msg_list,
1504: l_validation_level,
1505: l_new_instance_rec,

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

1520:
1521: -- Check for any errors and add them to the message stack to pass out to be put into the
1522: -- error log table.
1523: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1524: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1525: l_msg_index := 1;
1526: WHILE l_msg_count > 0 loop
1527: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1528: l_msg_index := l_msg_index + 1;

Line 1583: csi_item_instance_pub.update_item_instance(l_api_version,

1579:
1580: debug('Right after setting instance status');
1581: debug('Before Update item instance');
1582:
1583: csi_item_instance_pub.update_item_instance(l_api_version,
1584: l_commit,
1585: l_init_msg_list,
1586: l_validation_level,
1587: l_update_instance_rec,

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

1604:
1605: -- Check for any errors and add them to the message stack to pass out to be put into the
1606: -- error log table.
1607: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1608: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1609: debug('Message Count: '||l_msg_count);
1610: debug('Return Status: '||l_return_status);
1611: l_msg_index := 1;
1612: WHILE l_msg_count > 0 loop

Line 1687: csi_item_instance_pub.get_item_instance_details

1683: -- Instance.
1684:
1685: l_instance_header_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1686: -- Call details to get Party Information
1687: csi_item_instance_pub.get_item_instance_details
1688: (l_api_version,
1689: l_commit,
1690: l_init_msg_list,
1691: l_validation_level,

Line 1789: csi_item_instance_pub.update_item_instance(l_api_version,

1785:
1786: debug('Right after setting instance status');
1787: debug('Before Update item instance');
1788:
1789: csi_item_instance_pub.update_item_instance(l_api_version,
1790: l_commit,
1791: l_init_msg_list,
1792: l_validation_level,
1793: l_update_instance_rec,

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

1811: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
1812:
1813: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1814: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1815: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1816: debug('Message Count: '||l_msg_count);
1817: debug('Return Status: '||l_return_status);
1818: l_msg_index := 1;
1819: WHILE l_msg_count > 0 loop

Line 1867: csi_item_instance_pub.get_item_instances(l_api_version,

1863:
1864:
1865: debug('Before Get Item Instance');
1866:
1867: csi_item_instance_pub.get_item_instances(l_api_version,
1868: l_commit,
1869: l_init_msg_list,
1870: l_validation_level,
1871: l_instance_query_rec,

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

1888:
1889: -- Check for any errors and add them to the message stack to pass out to be put into the
1890: -- error log table.
1891: IF NOT l_return_status = l_fnd_success then
1892: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1893: l_msg_index := 1;
1894: WHILE l_msg_count > 0 loop
1895: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1896: l_msg_index := l_msg_index + 1;

Line 1939: csi_item_instance_pub.create_item_instance(l_api_version,

1935: l_new_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);
1936:
1937: debug('Before Create of new source Item Instance');
1938:
1939: csi_item_instance_pub.create_item_instance(l_api_version,
1940: l_commit,
1941: l_init_msg_list,
1942: l_validation_level,
1943: l_new_instance_rec,

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

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

Line 1997: csi_item_instance_pub.update_item_instance(l_api_version,

1993:
1994: debug('Right after setting instance status');
1995: debug('Before Update item instance');
1996:
1997: csi_item_instance_pub.update_item_instance(l_api_version,
1998: l_commit,
1999: l_init_msg_list,
2000: l_validation_level,
2001: l_update_instance_rec,

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

2018:
2019: -- Check for any errors and add them to the message stack to pass out to be put into the
2020: -- error log table.
2021: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2022: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2023: debug('Message Count: '||l_msg_count);
2024: debug('Return Status: '||l_return_status);
2025: l_msg_index := 1;
2026: WHILE l_msg_count > 0 loop

Line 2457: csi_item_instance_pub.get_item_instances(l_api_version,

2453: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
2454:
2455: debug('Before Get Item Instance');
2456:
2457: csi_item_instance_pub.get_item_instances(l_api_version,
2458: l_commit,
2459: l_init_msg_list,
2460: l_validation_level,
2461: l_instance_query_rec,

Line 2528: csi_item_instance_pub.create_item_instance(l_api_version,

2524: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2525:
2526: debug('Before Create of source Instance - Neg Qty');
2527:
2528: csi_item_instance_pub.create_item_instance(l_api_version,
2529: l_commit,
2530: l_init_msg_list,
2531: l_validation_level,
2532: l_new_src_instance_rec,

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

2546:
2547: -- Check for any errors and add them to the message stack to pass out to be put into the
2548: -- 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 2591: csi_item_instance_pub.update_item_instance(l_api_version,

2587: 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);
2588:
2589: debug('Instance Status Id: '||l_update_instance_rec.instance_status_id);
2590:
2591: csi_item_instance_pub.update_item_instance(l_api_version,
2592: l_commit,
2593: l_init_msg_list,
2594: l_validation_level,
2595: l_update_instance_rec,

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

2612: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2613:
2614: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2615: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2616: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2617: l_msg_index := 1;
2618: WHILE l_msg_count > 0 loop
2619: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2620: l_msg_index := l_msg_index + 1;

Line 2667: csi_item_instance_pub.update_item_instance(l_api_version,

2663: l_asset_assignment_tbl.delete;
2664:
2665: debug('Before Update of Serialized Item Instance');
2666:
2667: csi_item_instance_pub.update_item_instance(l_api_version,
2668: l_commit,
2669: l_init_msg_list,
2670: l_validation_level,
2671: l_update_instance_rec,

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

2689: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2690:
2691: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2692: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2693: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2694: l_msg_index := 1;
2695: WHILE l_msg_count > 0 loop
2696: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2697: l_msg_index := l_msg_index + 1;