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 344: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(

340: DEBUG('Single Quantity Instances Table Count'|| l_single_cps_tbl.count);
341:
342: IF l_single_cps_tbl.count > 0 THEN
343:
344: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(
345: p_order_line_rec => l_ship_order_line_rec);
346:
347: IF l_bom_explode_flag THEN
348:

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

348:
349: FOR l_scp_ind IN l_single_cps_tbl.FIRST .. l_single_cps_tbl.LAST
350: LOOP
351:
352: IF NOT(csi_utl_pkg.wip_config_exists(l_single_cps_tbl(l_scp_ind).instance_id)) THEN
353:
354: l_bom_std_item_rec.instance_id := l_single_cps_tbl(l_scp_ind).instance_id ;
355: l_bom_std_item_rec.inventory_item_id := l_ship_order_line_rec.inv_item_id ;
356: l_bom_std_item_rec.vld_organization_id := l_ship_order_line_rec.inv_org_id ;

Line 8029: csi_utl_pkg.get_pricing_attribs(

8025: END IF;
8026: END LOOP;
8027: END IF;
8028:
8029: csi_utl_pkg.get_pricing_attribs(
8030: p_line_id => p_order_line_rec.order_line_id,
8031: x_pricing_attb_tbl => l_p_pa_tbl,
8032: x_return_status => l_return_status);
8033:

Line 8302: csi_utl_pkg.get_dflt_sub_type_id(

8298: l_default_info_rec.ownership_cascade_at_txn :=
8299: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
8300:
8301: /* get the default sub type id */
8302: csi_utl_pkg.get_dflt_sub_type_id(
8303: p_transaction_type_id => l_txn_type_id,
8304: x_sub_type_id => l_txn_sub_type_id,
8305: x_return_status => l_return_status);
8306:

Line 9253: csi_utl_pkg.build_txn_relations(

9249: raise fnd_api.g_exc_error;
9250: END IF;
9251:
9252: ---added (start) for m-to-m enhancements
9253: csi_utl_pkg.build_txn_relations(
9254: l_line_dtl_tbl,
9255: l_temp_txn_ii_rltns_tbl,
9256: x_return_status);
9257:

Line 9408: csi_utl_pkg.update_txn_line_dtl (

9404: SET processing_status = 'ERROR'
9405: WHERE source_transaction_id = p_order_line_id
9406: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
9407:
9408: csi_utl_pkg.update_txn_line_dtl (
9409: p_source_trx_id => p_order_line_id,
9410: p_source_trx_table => 'OE_ORDER_LINES_ALL',
9411: p_api_name => l_api_name,
9412: p_error_message => l_error_message );

Line 9431: csi_utl_pkg.update_txn_line_dtl (

9427: SET processing_status = 'ERROR'
9428: WHERE source_transaction_id = p_order_line_id
9429: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
9430:
9431: csi_utl_pkg.update_txn_line_dtl (
9432: p_source_trx_id => p_order_line_id,
9433: p_source_trx_table => 'OE_ORDER_LINES_ALL',
9434: p_api_name => l_api_name,
9435: p_error_message => l_error_message );

Line 9492: csi_utl_pkg.get_dflt_sub_type_id(

9488: l_c_tl_rec.processing_status := 'IN_PROCESS';
9489: l_c_tl_rec.object_version_number := 1;
9490:
9491: /* getting the default sub type id */
9492: csi_utl_pkg.get_dflt_sub_type_id(
9493: p_transaction_type_id => 51,
9494: x_sub_type_id => l_sub_type_id,
9495: x_return_status => l_return_status);
9496:

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

9668: THEN
9669: l_c_tld_tbl(i).instance_id := x_order_shipment_tbl(i).instance_id;
9670: l_c_tld_tbl(i).instance_exists_flag := 'Y';
9671:
9672: l_inst_party_id := csi_utl_pkg.get_instance_party_id(x_order_shipment_tbl(i).instance_id);
9673:
9674: IF l_inst_party_id = -1 THEN
9675: raise fnd_api.g_exc_error;
9676: END IF;

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

9706: ELSE
9707: l_c_tld_tbl(i).mfg_serial_number_flag := 'N';
9708: END IF;
9709:
9710: -- l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);
9711:
9712: -- IF l_inst_party_id = -1 THEN
9713: -- raise fnd_api.g_exc_error;
9714: -- END IF;

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

9725:
9726: /* get ip_account_id if instance_party_id exist */
9727:
9728: IF l_inst_party_id is not null THEN
9729: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);
9730:
9731: -- /* If ip_account_id is -1 then */
9732: -- /* party account does not exist in IB */
9733:

Line 10026: csi_utl_pkg.get_order_line_dtls(

10022: /* this routine checks if ib is active */
10023: csi_utility_grp.check_ib_active;
10024:
10025: -- Get the order line details
10026: csi_utl_pkg.get_order_line_dtls(
10027: p_mtl_transaction_id => p_mtl_txn_id,
10028: x_order_line_rec => l_order_line_rec,
10029: x_return_status => l_return_status);
10030:

Line 10241: csi_utl_pkg.get_party_id(

10237: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
10238: END IF;
10239:
10240:
10241: csi_utl_pkg.get_party_id(
10242: p_cust_acct_id => mmt_rec.end_customer_id, -- mmt_rec.sold_to_org_id,
10243: x_party_id => l_party_id,
10244: x_return_status => l_return_status);
10245:

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

10341: p_instance_rec.instance_id := l_exp_instance_id;
10342: p_instance_rec.object_version_number := l_exp_obj_ver_num;
10343: p_instance_rec.active_end_date := sysdate;
10344:
10345: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_exp_instance_id);
10346:
10347: IF l_inst_party_id = -1 THEN
10348: raise fnd_api.g_exc_error;
10349: END IF;