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_UTL_PKG

Line 367: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(

363: DEBUG('Single Quantity Instances Table Count'|| l_single_cps_tbl.count);
364:
365: IF l_single_cps_tbl.count > 0 THEN
366:
367: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(
368: p_order_line_rec => l_ship_order_line_rec);
369:
370: IF l_bom_explode_flag THEN
371:

Line 375: IF NOT(csi_utl_pkg.wip_config_exists(l_single_cps_tbl(l_scp_ind).instance_id)) THEN

371:
372: FOR l_scp_ind IN l_single_cps_tbl.FIRST .. l_single_cps_tbl.LAST
373: LOOP
374:
375: IF NOT(csi_utl_pkg.wip_config_exists(l_single_cps_tbl(l_scp_ind).instance_id)) THEN
376:
377: l_bom_std_item_rec.instance_id := l_single_cps_tbl(l_scp_ind).instance_id ;
378: l_bom_std_item_rec.inventory_item_id := l_ship_order_line_rec.inv_item_id ;
379: l_bom_std_item_rec.vld_organization_id := l_ship_order_line_rec.inv_org_id ;

Line 8879: csi_utl_pkg.get_pricing_attribs(

8875: END IF;
8876: END LOOP;
8877: END IF;
8878:
8879: csi_utl_pkg.get_pricing_attribs(
8880: p_line_id => p_order_line_rec.order_line_id,
8881: x_pricing_attb_tbl => l_p_pa_tbl,
8882: x_return_status => l_return_status);
8883:

Line 9223: csi_utl_pkg.get_dflt_sub_type_id(

9219: l_default_info_rec.ownership_cascade_at_txn :=
9220: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
9221:
9222: /* get the default sub type id */
9223: csi_utl_pkg.get_dflt_sub_type_id(
9224: p_transaction_type_id => l_txn_type_id,
9225: x_sub_type_id => l_txn_sub_type_id,
9226: x_return_status => l_return_status);
9227:

Line 10263: csi_utl_pkg.build_txn_relations(

10259: raise fnd_api.g_exc_error;
10260: END IF;
10261:
10262: ---added (start) for m-to-m enhancements
10263: csi_utl_pkg.build_txn_relations(
10264: l_line_dtl_tbl,
10265: l_temp_txn_ii_rltns_tbl,
10266: x_return_status);
10267:

Line 10424: csi_utl_pkg.update_txn_line_dtl (

10420: SET processing_status = 'ERROR'
10421: WHERE source_transaction_id = p_order_line_id
10422: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10423:
10424: csi_utl_pkg.update_txn_line_dtl (
10425: p_source_trx_id => p_order_line_id,
10426: p_source_trx_table => 'OE_ORDER_LINES_ALL',
10427: p_api_name => l_api_name,
10428: p_error_message => l_error_message );

Line 10447: csi_utl_pkg.update_txn_line_dtl (

10443: SET processing_status = 'ERROR'
10444: WHERE source_transaction_id = p_order_line_id
10445: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10446:
10447: csi_utl_pkg.update_txn_line_dtl (
10448: p_source_trx_id => p_order_line_id,
10449: p_source_trx_table => 'OE_ORDER_LINES_ALL',
10450: p_api_name => l_api_name,
10451: p_error_message => l_error_message );

Line 10508: csi_utl_pkg.get_dflt_sub_type_id(

10504: l_c_tl_rec.processing_status := 'IN_PROCESS';
10505: l_c_tl_rec.object_version_number := 1;
10506:
10507: /* getting the default sub type id */
10508: csi_utl_pkg.get_dflt_sub_type_id(
10509: p_transaction_type_id => 51,
10510: x_sub_type_id => l_sub_type_id,
10511: x_return_status => l_return_status);
10512:

Line 10688: l_inst_party_id := csi_utl_pkg.get_instance_party_id(x_order_shipment_tbl(i).instance_id);

10684: THEN
10685: l_c_tld_tbl(i).instance_id := x_order_shipment_tbl(i).instance_id;
10686: l_c_tld_tbl(i).instance_exists_flag := 'Y';
10687:
10688: l_inst_party_id := csi_utl_pkg.get_instance_party_id(x_order_shipment_tbl(i).instance_id);
10689:
10690: IF l_inst_party_id = -1 THEN
10691: raise fnd_api.g_exc_error;
10692: END IF;

Line 10726: -- l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);

10722: ELSE
10723: l_c_tld_tbl(i).mfg_serial_number_flag := 'N';
10724: END IF;
10725:
10726: -- l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);
10727:
10728: -- IF l_inst_party_id = -1 THEN
10729: -- raise fnd_api.g_exc_error;
10730: -- END IF;

Line 10745: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);

10741:
10742: /* get ip_account_id if instance_party_id exist */
10743:
10744: IF l_inst_party_id is not null THEN
10745: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);
10746:
10747: -- /* If ip_account_id is -1 then */
10748: -- /* party account does not exist in IB */
10749:

Line 11042: csi_utl_pkg.get_order_line_dtls(

11038: /* this routine checks if ib is active */
11039: csi_utility_grp.check_ib_active;
11040:
11041: -- Get the order line details
11042: csi_utl_pkg.get_order_line_dtls(
11043: p_mtl_transaction_id => p_mtl_txn_id,
11044: x_order_line_rec => l_order_line_rec,
11045: x_return_status => l_return_status);
11046:

Line 11257: csi_utl_pkg.get_party_id(

11253: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
11254: END IF;
11255:
11256:
11257: csi_utl_pkg.get_party_id(
11258: p_cust_acct_id => mmt_rec.end_customer_id, -- mmt_rec.sold_to_org_id,
11259: x_party_id => l_party_id,
11260: x_return_status => l_return_status);
11261:

Line 11361: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_exp_instance_id);

11357: p_instance_rec.instance_id := l_exp_instance_id;
11358: p_instance_rec.object_version_number := l_exp_obj_ver_num;
11359: p_instance_rec.active_end_date := sysdate;
11360:
11361: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_exp_instance_id);
11362:
11363: IF l_inst_party_id = -1 THEN
11364: raise fnd_api.g_exc_error;
11365: END IF;