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.

[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_ITEM_INSTANCE_PUB

Line 730: debug(' Inside API :csi_item_instance_pub.update_item_instance');

726: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
727: AND nvl(active_end_date, sysdate+1);
728: END IF;
729:
730: debug(' Inside API :csi_item_instance_pub.update_item_instance');
731: debug(' instance_id : '||l_u_instance_rec.instance_id);
732: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
733: debug(' quantity : '||l_u_instance_rec.quantity);
734:

Line 735: csi_item_instance_pub.update_item_instance(

731: debug(' instance_id : '||l_u_instance_rec.instance_id);
732: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
733: debug(' quantity : '||l_u_instance_rec.quantity);
734:
735: csi_item_instance_pub.update_item_instance(
736: p_api_version => 1.0,
737: p_commit => fnd_api.g_false,
738: p_init_msg_list => fnd_api.g_true,
739: p_validation_level => fnd_api.g_valid_level_full,

Line 767: debug(' Inside API :csi_item_instance_pub.copy_item_instance');

763:
764: l_instance_rec.quantity := 1;
765: l_instance_rec.instance_usage_code := 'RETURNED';
766:
767: debug(' Inside API :csi_item_instance_pub.copy_item_instance');
768:
769: csi_item_instance_pub.copy_item_instance(
770: p_api_version => 1.0,
771: p_commit => fnd_api.g_false,

Line 769: csi_item_instance_pub.copy_item_instance(

765: l_instance_rec.instance_usage_code := 'RETURNED';
766:
767: debug(' Inside API :csi_item_instance_pub.copy_item_instance');
768:
769: csi_item_instance_pub.copy_item_instance(
770: p_api_version => 1.0,
771: p_commit => fnd_api.g_false,
772: p_init_msg_list => fnd_api.g_true,
773: p_validation_level => fnd_api.g_valid_level_full,

Line 996: debug(' Inside API :csi_item_instance_pub.get_item_instance_details');

992: l_s_ind := 0;
993:
994: l_g_instance_rec.instance_id := p_instance_id;
995:
996: debug(' Inside API :csi_item_instance_pub.get_item_instance_details');
997:
998: -- get the instance party and party account info
999: csi_item_instance_pub.get_item_instance_details(
1000: p_api_version => 1.0,

Line 999: csi_item_instance_pub.get_item_instance_details(

995:
996: debug(' Inside API :csi_item_instance_pub.get_item_instance_details');
997:
998: -- get the instance party and party account info
999: csi_item_instance_pub.get_item_instance_details(
1000: p_api_version => 1.0,
1001: p_commit => fnd_api.g_false,
1002: p_init_msg_list => fnd_api.g_true,
1003: p_validation_level => fnd_api.g_valid_level_full,

Line 1119: debug(' Inside API :csi_item_instance_pub.create_item_instance');

1115:
1116: debug(' alloc_qty(new) : '||l_c_instance_rec.quantity);
1117:
1118: -- create a new instance for the decremented qty
1119: debug(' Inside API :csi_item_instance_pub.create_item_instance');
1120:
1121: csi_item_instance_pub.create_item_instance(
1122: p_api_version => 1.0,
1123: p_commit => fnd_api.g_false,

Line 1121: csi_item_instance_pub.create_item_instance(

1117:
1118: -- create a new instance for the decremented qty
1119: debug(' Inside API :csi_item_instance_pub.create_item_instance');
1120:
1121: csi_item_instance_pub.create_item_instance(
1122: p_api_version => 1.0,
1123: p_commit => fnd_api.g_false,
1124: p_init_msg_list => fnd_api.g_true,
1125: p_validation_level => fnd_api.g_valid_level_full,

Line 1186: debug(' Inside API :csi_item_instance_pub.update_item_instance');

1182: FROM csi_item_instances
1183: WHERE instance_id = l_u_instance_rec.instance_id;
1184:
1185: debug(' remain_qty(upd) : '||l_u_instance_rec.quantity);
1186: debug(' Inside API :csi_item_instance_pub.update_item_instance');
1187: debug(' old_instance_id : '||l_u_instance_rec.instance_id);
1188:
1189: csi_item_instance_pub.update_item_instance(
1190: p_api_version => 1.0,

Line 1189: csi_item_instance_pub.update_item_instance(

1185: debug(' remain_qty(upd) : '||l_u_instance_rec.quantity);
1186: debug(' Inside API :csi_item_instance_pub.update_item_instance');
1187: debug(' old_instance_id : '||l_u_instance_rec.instance_id);
1188:
1189: csi_item_instance_pub.update_item_instance(
1190: p_api_version => 1.0,
1191: p_commit => fnd_api.g_false,
1192: p_init_msg_list => fnd_api.g_true,
1193: p_validation_level => fnd_api.g_valid_level_full,

Line 2037: p_pkg_name => 'csi_item_instance_pub',

2033:
2034: IF nvl(p_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2035:
2036: csi_t_gen_utility_pvt.dump_api_info(
2037: p_pkg_name => 'csi_item_instance_pub',
2038: p_api_name => 'get_item_instance_details');
2039:
2040: -- get the instance party and party account info
2041: csi_item_instance_pub.get_item_instance_details(

Line 2041: csi_item_instance_pub.get_item_instance_details(

2037: p_pkg_name => 'csi_item_instance_pub',
2038: p_api_name => 'get_item_instance_details');
2039:
2040: -- get the instance party and party account info
2041: csi_item_instance_pub.get_item_instance_details(
2042: p_api_version => 1.0,
2043: p_commit => fnd_api.g_false,
2044: p_init_msg_list => fnd_api.g_true,
2045: p_validation_level => fnd_api.g_valid_level_full,

Line 2813: p_pkg_name => 'csi_item_instance_pub');

2809: p_csi_instance_rec => l_u_instance_rec);
2810:
2811: csi_t_gen_utility_pvt.dump_api_info(
2812: p_api_name => 'update_item_instance',
2813: p_pkg_name => 'csi_item_instance_pub');
2814:
2815: csi_item_instance_pub.update_item_instance(
2816: p_api_version => 1.0,
2817: p_commit => fnd_api.g_false,

Line 2815: csi_item_instance_pub.update_item_instance(

2811: csi_t_gen_utility_pvt.dump_api_info(
2812: p_api_name => 'update_item_instance',
2813: p_pkg_name => 'csi_item_instance_pub');
2814:
2815: csi_item_instance_pub.update_item_instance(
2816: p_api_version => 1.0,
2817: p_commit => fnd_api.g_false,
2818: p_init_msg_list => fnd_api.g_true,
2819: p_validation_level => fnd_api.g_valid_level_full,

Line 4443: p_pkg_name => 'csi_item_instance_pub');

4439: l_u_instance_rec.object_version_number := l_inst_object_ver_num;
4440:
4441: csi_t_gen_utility_pvt.dump_api_info(
4442: p_api_name => 'update_item_instance',
4443: p_pkg_name => 'csi_item_instance_pub');
4444:
4445: debug(' instance_id : '||l_u_instance_rec.instance_id);
4446: debug(' last_oe_line_id : '||l_u_instance_rec.last_oe_order_line_id);
4447: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);

Line 4449: csi_item_instance_pub.update_item_instance(

4445: debug(' instance_id : '||l_u_instance_rec.instance_id);
4446: debug(' last_oe_line_id : '||l_u_instance_rec.last_oe_order_line_id);
4447: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
4448:
4449: csi_item_instance_pub.update_item_instance(
4450: p_api_version => 1.0,
4451: p_commit => fnd_api.g_false,
4452: p_init_msg_list => fnd_api.g_true,
4453: p_validation_level => fnd_api.g_valid_level_full,

Line 5883: p_pkg_name => 'csi_item_instance_pub');

5879: debug(' last_oe_order_line_id : '||l_inst_query_rec.last_oe_order_line_id);
5880:
5881: csi_t_gen_utility_pvt.dump_api_info(
5882: p_api_name => 'get_item_instances',
5883: p_pkg_name => 'csi_item_instance_pub');
5884:
5885: csi_item_instance_pub.get_item_instances(
5886: p_api_version => 1.0,
5887: p_commit => fnd_api.g_false,

Line 5885: csi_item_instance_pub.get_item_instances(

5881: csi_t_gen_utility_pvt.dump_api_info(
5882: p_api_name => 'get_item_instances',
5883: p_pkg_name => 'csi_item_instance_pub');
5884:
5885: csi_item_instance_pub.get_item_instances(
5886: p_api_version => 1.0,
5887: p_commit => fnd_api.g_false,
5888: p_init_msg_list => fnd_api.g_true,
5889: p_validation_level => fnd_api.g_valid_level_full,

Line 6240: p_pkg_name => 'csi_item_instance_pub');

6236: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
6237:
6238: csi_t_gen_utility_pvt.dump_api_info(
6239: p_api_name => 'get_item_instances',
6240: p_pkg_name => 'csi_item_instance_pub');
6241:
6242: csi_item_instance_pub.get_item_instances(
6243: p_api_version => 1.0,
6244: p_commit => fnd_api.g_false,

Line 6242: csi_item_instance_pub.get_item_instances(

6238: csi_t_gen_utility_pvt.dump_api_info(
6239: p_api_name => 'get_item_instances',
6240: p_pkg_name => 'csi_item_instance_pub');
6241:
6242: csi_item_instance_pub.get_item_instances(
6243: p_api_version => 1.0,
6244: p_commit => fnd_api.g_false,
6245: p_init_msg_list => fnd_api.g_true,
6246: p_validation_level => fnd_api.g_valid_level_full,

Line 7399: csi_item_instance_pub.get_item_instance_details(

7395: END IF;
7396:
7397: l_instance_rec.instance_id := l_line_dtl_tbl(1).instance_id;
7398:
7399: csi_item_instance_pub.get_item_instance_details(
7400: p_api_version => 1.0,
7401: p_commit => fnd_api.g_false,
7402: p_init_msg_list => fnd_api.g_true,
7403: p_validation_level => fnd_api.g_valid_level_full,

Line 8623: debug(' Inside API :csi_item_instance_pub.update_item_instance');

8619:
8620: l_csi_txn_rec.transaction_date := sysdate;
8621: l_csi_txn_rec.source_transaction_date := nvl(l_order_line_rec.fulfillment_date, sysdate);
8622: --
8623: debug(' Inside API :csi_item_instance_pub.update_item_instance');
8624: debug(' instance_id : '||l_ul_instance_rec.instance_id);
8625: debug(' Order Line ID : '||l_ul_instance_rec.last_oe_order_line_id);
8626: --
8627: csi_item_instance_pub.update_item_instance(

Line 8627: csi_item_instance_pub.update_item_instance(

8623: debug(' Inside API :csi_item_instance_pub.update_item_instance');
8624: debug(' instance_id : '||l_ul_instance_rec.instance_id);
8625: debug(' Order Line ID : '||l_ul_instance_rec.last_oe_order_line_id);
8626: --
8627: csi_item_instance_pub.update_item_instance(
8628: p_api_version => 1.0,
8629: p_commit => fnd_api.g_false,
8630: p_init_msg_list => fnd_api.g_true,
8631: p_validation_level => fnd_api.g_valid_level_full,

Line 10381: p_pkg_name => 'csi_item_instance_pub');

10377: l_trx_rec.transaction_id := fnd_api.g_miss_num;
10378:
10379: csi_t_gen_utility_pvt.dump_api_info(
10380: p_api_name => 'update_item_instance',
10381: p_pkg_name => 'csi_item_instance_pub');
10382:
10383: csi_item_instance_pub.update_item_instance(
10384: p_api_version => 1.0,
10385: p_commit => fnd_api.g_false,

Line 10383: csi_item_instance_pub.update_item_instance(

10379: csi_t_gen_utility_pvt.dump_api_info(
10380: p_api_name => 'update_item_instance',
10381: p_pkg_name => 'csi_item_instance_pub');
10382:
10383: csi_item_instance_pub.update_item_instance(
10384: p_api_version => 1.0,
10385: p_commit => fnd_api.g_false,
10386: p_init_msg_list => fnd_api.g_true,
10387: p_validation_level => fnd_api.g_valid_level_full,

Line 10402: debug('csi_item_instance_pub.expire_item_instance');

10398: x_msg_count => x_msg_count,
10399: x_msg_data => x_msg_data );
10400:
10401: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
10402: debug('csi_item_instance_pub.expire_item_instance');
10403: raise fnd_api.g_exc_error;
10404: END IF;
10405:
10406: BEGIN