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

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

766: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
767: AND nvl(active_end_date, sysdate+1);
768: END IF;
769:
770: debug(' Inside API :csi_item_instance_pub.update_item_instance');
771: debug(' instance_id : '||l_u_instance_rec.instance_id);
772: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
773: debug(' quantity : '||l_u_instance_rec.quantity);
774:

Line 775: csi_item_instance_pub.update_item_instance(

771: debug(' instance_id : '||l_u_instance_rec.instance_id);
772: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
773: debug(' quantity : '||l_u_instance_rec.quantity);
774:
775: csi_item_instance_pub.update_item_instance(
776: p_api_version => 1.0,
777: p_commit => fnd_api.g_false,
778: p_init_msg_list => fnd_api.g_true,
779: p_validation_level => fnd_api.g_valid_level_full,

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

803:
804: l_instance_rec.quantity := 1;
805: l_instance_rec.instance_usage_code := 'RETURNED';
806:
807: debug(' Inside API :csi_item_instance_pub.copy_item_instance');
808:
809: csi_item_instance_pub.copy_item_instance(
810: p_api_version => 1.0,
811: p_commit => fnd_api.g_false,

Line 809: csi_item_instance_pub.copy_item_instance(

805: l_instance_rec.instance_usage_code := 'RETURNED';
806:
807: debug(' Inside API :csi_item_instance_pub.copy_item_instance');
808:
809: csi_item_instance_pub.copy_item_instance(
810: p_api_version => 1.0,
811: p_commit => fnd_api.g_false,
812: p_init_msg_list => fnd_api.g_true,
813: p_validation_level => fnd_api.g_valid_level_full,

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

1032: l_s_ind := 0;
1033:
1034: l_g_instance_rec.instance_id := p_instance_id;
1035:
1036: debug(' Inside API :csi_item_instance_pub.get_item_instance_details');
1037:
1038: -- get the instance party and party account info
1039: csi_item_instance_pub.get_item_instance_details(
1040: p_api_version => 1.0,

Line 1039: csi_item_instance_pub.get_item_instance_details(

1035:
1036: debug(' Inside API :csi_item_instance_pub.get_item_instance_details');
1037:
1038: -- get the instance party and party account info
1039: csi_item_instance_pub.get_item_instance_details(
1040: p_api_version => 1.0,
1041: p_commit => fnd_api.g_false,
1042: p_init_msg_list => fnd_api.g_true,
1043: p_validation_level => fnd_api.g_valid_level_full,

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

1155:
1156: debug(' alloc_qty(new) : '||l_c_instance_rec.quantity);
1157:
1158: -- create a new instance for the decremented qty
1159: debug(' Inside API :csi_item_instance_pub.create_item_instance');
1160:
1161: csi_item_instance_pub.create_item_instance(
1162: p_api_version => 1.0,
1163: p_commit => fnd_api.g_false,

Line 1161: csi_item_instance_pub.create_item_instance(

1157:
1158: -- create a new instance for the decremented qty
1159: debug(' Inside API :csi_item_instance_pub.create_item_instance');
1160:
1161: csi_item_instance_pub.create_item_instance(
1162: p_api_version => 1.0,
1163: p_commit => fnd_api.g_false,
1164: p_init_msg_list => fnd_api.g_true,
1165: p_validation_level => fnd_api.g_valid_level_full,

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

1222: FROM csi_item_instances
1223: WHERE instance_id = l_u_instance_rec.instance_id;
1224:
1225: debug(' remain_qty(upd) : '||l_u_instance_rec.quantity);
1226: debug(' Inside API :csi_item_instance_pub.update_item_instance');
1227: debug(' old_instance_id : '||l_u_instance_rec.instance_id);
1228:
1229: csi_item_instance_pub.update_item_instance(
1230: p_api_version => 1.0,

Line 1229: csi_item_instance_pub.update_item_instance(

1225: debug(' remain_qty(upd) : '||l_u_instance_rec.quantity);
1226: debug(' Inside API :csi_item_instance_pub.update_item_instance');
1227: debug(' old_instance_id : '||l_u_instance_rec.instance_id);
1228:
1229: csi_item_instance_pub.update_item_instance(
1230: p_api_version => 1.0,
1231: p_commit => fnd_api.g_false,
1232: p_init_msg_list => fnd_api.g_true,
1233: p_validation_level => fnd_api.g_valid_level_full,

Line 2077: p_pkg_name => 'csi_item_instance_pub',

2073:
2074: IF nvl(p_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2075:
2076: csi_t_gen_utility_pvt.dump_api_info(
2077: p_pkg_name => 'csi_item_instance_pub',
2078: p_api_name => 'get_item_instance_details');
2079:
2080: -- get the instance party and party account info
2081: csi_item_instance_pub.get_item_instance_details(

Line 2081: csi_item_instance_pub.get_item_instance_details(

2077: p_pkg_name => 'csi_item_instance_pub',
2078: p_api_name => 'get_item_instance_details');
2079:
2080: -- get the instance party and party account info
2081: csi_item_instance_pub.get_item_instance_details(
2082: p_api_version => 1.0,
2083: p_commit => fnd_api.g_false,
2084: p_init_msg_list => fnd_api.g_true,
2085: p_validation_level => fnd_api.g_valid_level_full,

Line 2853: p_pkg_name => 'csi_item_instance_pub');

2849: p_csi_instance_rec => l_u_instance_rec);
2850:
2851: csi_t_gen_utility_pvt.dump_api_info(
2852: p_api_name => 'update_item_instance',
2853: p_pkg_name => 'csi_item_instance_pub');
2854:
2855: csi_item_instance_pub.update_item_instance(
2856: p_api_version => 1.0,
2857: p_commit => fnd_api.g_false,

Line 2855: csi_item_instance_pub.update_item_instance(

2851: csi_t_gen_utility_pvt.dump_api_info(
2852: p_api_name => 'update_item_instance',
2853: p_pkg_name => 'csi_item_instance_pub');
2854:
2855: csi_item_instance_pub.update_item_instance(
2856: p_api_version => 1.0,
2857: p_commit => fnd_api.g_false,
2858: p_init_msg_list => fnd_api.g_true,
2859: p_validation_level => fnd_api.g_valid_level_full,

Line 4491: p_pkg_name => 'csi_item_instance_pub');

4487: l_u_instance_rec.object_version_number := l_inst_object_ver_num;
4488:
4489: csi_t_gen_utility_pvt.dump_api_info(
4490: p_api_name => 'update_item_instance',
4491: p_pkg_name => 'csi_item_instance_pub');
4492:
4493: debug(' instance_id : '||l_u_instance_rec.instance_id);
4494: debug(' last_oe_line_id : '||l_u_instance_rec.last_oe_order_line_id);
4495: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);

Line 4497: csi_item_instance_pub.update_item_instance(

4493: debug(' instance_id : '||l_u_instance_rec.instance_id);
4494: debug(' last_oe_line_id : '||l_u_instance_rec.last_oe_order_line_id);
4495: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
4496:
4497: csi_item_instance_pub.update_item_instance(
4498: p_api_version => 1.0,
4499: p_commit => fnd_api.g_false,
4500: p_init_msg_list => fnd_api.g_true,
4501: p_validation_level => fnd_api.g_valid_level_full,

Line 6380: p_pkg_name => 'csi_item_instance_pub');

6376: debug(' last_oe_order_line_id : '||l_inst_query_rec.last_oe_order_line_id);
6377:
6378: csi_t_gen_utility_pvt.dump_api_info(
6379: p_api_name => 'get_item_instances',
6380: p_pkg_name => 'csi_item_instance_pub');
6381:
6382: csi_item_instance_pub.get_item_instances(
6383: p_api_version => 1.0,
6384: p_commit => fnd_api.g_false,

Line 6382: csi_item_instance_pub.get_item_instances(

6378: csi_t_gen_utility_pvt.dump_api_info(
6379: p_api_name => 'get_item_instances',
6380: p_pkg_name => 'csi_item_instance_pub');
6381:
6382: csi_item_instance_pub.get_item_instances(
6383: p_api_version => 1.0,
6384: p_commit => fnd_api.g_false,
6385: p_init_msg_list => fnd_api.g_true,
6386: p_validation_level => fnd_api.g_valid_level_full,

Line 6716: p_pkg_name => 'csi_item_instance_pub');

6712: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
6713:
6714: csi_t_gen_utility_pvt.dump_api_info(
6715: p_api_name => 'get_item_instances',
6716: p_pkg_name => 'csi_item_instance_pub');
6717:
6718: csi_item_instance_pub.get_item_instances(
6719: p_api_version => 1.0,
6720: p_commit => fnd_api.g_false,

Line 6718: csi_item_instance_pub.get_item_instances(

6714: csi_t_gen_utility_pvt.dump_api_info(
6715: p_api_name => 'get_item_instances',
6716: p_pkg_name => 'csi_item_instance_pub');
6717:
6718: csi_item_instance_pub.get_item_instances(
6719: p_api_version => 1.0,
6720: p_commit => fnd_api.g_false,
6721: p_init_msg_list => fnd_api.g_true,
6722: p_validation_level => fnd_api.g_valid_level_full,

Line 7010: p_pkg_name => 'csi_item_instance_pub');

7006: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
7007:
7008: csi_t_gen_utility_pvt.dump_api_info(
7009: p_api_name => 'get_item_instances',
7010: p_pkg_name => 'csi_item_instance_pub');
7011:
7012: csi_item_instance_pub.get_item_instances(
7013: p_api_version => 1.0,
7014: p_commit => fnd_api.g_false,

Line 7012: csi_item_instance_pub.get_item_instances(

7008: csi_t_gen_utility_pvt.dump_api_info(
7009: p_api_name => 'get_item_instances',
7010: p_pkg_name => 'csi_item_instance_pub');
7011:
7012: csi_item_instance_pub.get_item_instances(
7013: p_api_version => 1.0,
7014: p_commit => fnd_api.g_false,
7015: p_init_msg_list => fnd_api.g_true,
7016: p_validation_level => fnd_api.g_valid_level_full,

Line 8196: csi_item_instance_pub.get_item_instance_details(

8192: END IF;
8193:
8194: l_instance_rec.instance_id := l_line_dtl_tbl(1).instance_id;
8195:
8196: csi_item_instance_pub.get_item_instance_details(
8197: p_api_version => 1.0,
8198: p_commit => fnd_api.g_false,
8199: p_init_msg_list => fnd_api.g_true,
8200: p_validation_level => fnd_api.g_valid_level_full,

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

9574:
9575: l_csi_txn_rec.transaction_date := sysdate;
9576: l_csi_txn_rec.source_transaction_date := nvl(l_order_line_rec.fulfillment_date, sysdate);
9577: --
9578: debug(' Inside API :csi_item_instance_pub.update_item_instance');
9579: debug(' instance_id : '||l_ul_instance_rec.instance_id);
9580: debug(' Order Line ID : '||l_ul_instance_rec.last_oe_order_line_id);
9581: --
9582: csi_item_instance_pub.update_item_instance(

Line 9582: csi_item_instance_pub.update_item_instance(

9578: debug(' Inside API :csi_item_instance_pub.update_item_instance');
9579: debug(' instance_id : '||l_ul_instance_rec.instance_id);
9580: debug(' Order Line ID : '||l_ul_instance_rec.last_oe_order_line_id);
9581: --
9582: csi_item_instance_pub.update_item_instance(
9583: p_api_version => 1.0,
9584: p_commit => fnd_api.g_false,
9585: p_init_msg_list => fnd_api.g_true,
9586: p_validation_level => fnd_api.g_valid_level_full,

Line 11397: p_pkg_name => 'csi_item_instance_pub');

11393: l_trx_rec.transaction_id := fnd_api.g_miss_num;
11394:
11395: csi_t_gen_utility_pvt.dump_api_info(
11396: p_api_name => 'update_item_instance',
11397: p_pkg_name => 'csi_item_instance_pub');
11398:
11399: csi_item_instance_pub.update_item_instance(
11400: p_api_version => 1.0,
11401: p_commit => fnd_api.g_false,

Line 11399: csi_item_instance_pub.update_item_instance(

11395: csi_t_gen_utility_pvt.dump_api_info(
11396: p_api_name => 'update_item_instance',
11397: p_pkg_name => 'csi_item_instance_pub');
11398:
11399: csi_item_instance_pub.update_item_instance(
11400: p_api_version => 1.0,
11401: p_commit => fnd_api.g_false,
11402: p_init_msg_list => fnd_api.g_true,
11403: p_validation_level => fnd_api.g_valid_level_full,

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

11414: x_msg_count => x_msg_count,
11415: x_msg_data => x_msg_data );
11416:
11417: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
11418: debug('csi_item_instance_pub.expire_item_instance');
11419: raise fnd_api.g_exc_error;
11420: END IF;
11421:
11422: BEGIN