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_SHIP_PUB dependencies on CSI_UTL_PKG

Line 589: csi_utl_pkg.get_int_party(

585: /* this routine checks if ib is active */
586: csi_utility_grp.check_ib_active;
587:
588: /* get internal party id */
589: csi_utl_pkg.get_int_party(
590: x_int_party_id => l_internal_party_id,
591: x_return_status => l_return_status);
592:
593: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 598: csi_utl_pkg.get_order_line_dtls(

594: raise fnd_api.g_exc_error;
595: END IF;
596:
597: -- Get the order line details
598: csi_utl_pkg.get_order_line_dtls(
599: p_mtl_transaction_id => p_mtl_transaction_id,
600: x_order_line_rec => l_order_line_rec,
601: x_return_status => l_return_status);
602:

Line 688: csi_utl_pkg.get_item_control_rec(

684:
685:
686: dbms_application_info.set_client_info(l_order_line_rec.org_id);
687:
688: csi_utl_pkg.get_item_control_rec(
689: p_mtl_txn_id => p_mtl_transaction_id,
690: x_item_control_rec => l_item_control_rec,
691: x_return_status => l_return_status);
692:

Line 719: csi_utl_pkg.get_link_to_line_id (

715: l_error_rec.comms_nl_trackable_flag := l_item_control_rec.ib_trackable_flag;
716:
717: IF NVL(l_order_line_rec.link_to_line_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
718:
719: csi_utl_pkg.get_link_to_line_id (
720: x_link_to_line_id => l_order_line_rec.link_to_line_id,
721: x_return_status => l_return_status );
722:
723: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 730: csi_utl_pkg.get_ib_trackable_children(

726:
727: END IF;
728:
729: -- check if there is any ib trackable children for the current order line
730: csi_utl_pkg.get_ib_trackable_children(
731: p_order_line_rec => l_order_line_rec,
732: x_trackable_line_tbl => l_trk_oe_line_tbl,
733: x_return_status => l_return_status);
734:

Line 744: csi_utl_pkg.get_dflt_sub_type_id(

740: l_trackable_parent := TRUE;
741: END IF;
742:
743: /* getting the default sub type id */
744: csi_utl_pkg.get_dflt_sub_type_id(
745: p_transaction_type_id => g_txn_type_id,
746: x_sub_type_id => g_dflt_sub_type_id,
747: x_return_status => l_return_status);
748:

Line 753: csi_utl_pkg.get_sub_type_rec(

749: IF l_return_status <> fnd_api.g_ret_sts_success THEN
750: raise fnd_api.g_exc_error;
751: END IF;
752:
753: csi_utl_pkg.get_sub_type_rec(
754: p_sub_type_id => g_dflt_sub_type_id,
755: p_trx_type_id => g_txn_type_id,
756: x_trx_sub_type_rec => x_trx_sub_type_rec,
757: x_return_status => l_return_status) ;

Line 796: csi_utl_pkg.get_qty_ratio(

792: IF NVL(l_order_line_rec.link_to_line_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
793:
794: debug('This is a child order line. Check model and cascade installation details.');
795:
796: csi_utl_pkg.get_qty_ratio(
797: p_order_line_qty => l_order_line_rec.ordered_quantity,
798: p_order_item_id => l_order_line_rec.inv_item_id,
799: p_model_remnant_flag => l_order_line_rec.model_remnant_flag, --added for bug5096435
800: p_link_to_line_id => l_order_line_rec.link_to_line_id,

Line 808: csi_utl_pkg.cascade_txn_dtls(

804: IF x_return_status <> fnd_api.g_ret_sts_success THEN
805: raise fnd_api.g_exc_error;
806: END IF;
807:
808: csi_utl_pkg.cascade_txn_dtls(
809: p_source_trx_id => l_order_line_rec.order_line_id,
810: p_source_trx_table => 'OE_ORDER_LINES_ALL',
811: p_ratio => l_qty_ratio,
812: x_return_status => x_return_status);

Line 899: csi_utl_pkg.create_txn_dtls(

895:
896: debug('splitting the WSH txn details in to one each.' );
897:
898: -- shegde 2769321 oe_orderlines_all changed to wsh_delivery_details
899: csi_utl_pkg.create_txn_dtls(
900: p_source_trx_id => l_order_line_rec.order_line_id,
901: p_source_trx_table => 'WSH_DELIVERY_DETAILS',
902: x_return_status => x_return_status );
903:

Line 955: csi_utl_pkg.get_qty_ratio(

951: /* -----------------------------------------------*/
952:
953: IF NVL(l_order_line_rec.link_to_line_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
954:
955: csi_utl_pkg.get_qty_ratio(
956: p_order_line_qty => l_order_line_rec.ordered_quantity,
957: p_order_item_id => l_order_line_rec.inv_item_id,
958: p_model_remnant_flag => l_order_line_rec.model_remnant_flag, --added for bug5096435
959: p_link_to_line_id => l_order_line_rec.link_to_line_id,

Line 967: csi_utl_pkg.cascade_txn_dtls(

963: IF l_return_status <> fnd_api.g_ret_sts_success THEN
964: raise fnd_api.g_exc_error;
965: END IF;
966:
967: csi_utl_pkg.cascade_txn_dtls(
968: p_source_trx_id => l_order_line_rec.order_line_id,
969: p_source_trx_table => 'OE_ORDER_LINES_ALL',
970: p_ratio => l_qty_ratio ,
971: x_return_status => l_return_status );

Line 1051: csi_utl_pkg.create_txn_dtls(

1047: IF l_item_control_rec.serial_control_code <> 1 OR l_trackable_parent THEN
1048:
1049: debug('splitting the WSH txn details in to one each' );
1050: -- shegde 2769321 oe_orderlines_all changed to wsh_delivery_details
1051: csi_utl_pkg.create_txn_dtls(
1052: p_source_trx_id => l_order_line_rec.order_line_id,
1053: p_source_trx_table => 'WSH_DELIVERY_DETAILS',
1054: x_return_status => l_return_status );
1055:

Line 1073: csi_utl_pkg.get_split_order_line(

1069: IF l_trx_detail_exist then
1070:
1071: debug('check if this is a partial shipment case.');
1072:
1073: csi_utl_pkg.get_split_order_line(
1074: l_order_line_rec.order_line_id,
1075: l_order_line_rec.header_id,
1076: l_split_ord_line_id,
1077: l_return_status);

Line 1273: csi_utl_pkg.Get_Pricing_Attribs(

1269: /* Get the pricing attributes for the order line and */
1270: /* pass it to update_install_base */
1271: /*---------------------------------------------------*/
1272:
1273: csi_utl_pkg.Get_Pricing_Attribs(
1274: p_line_id => l_order_line_rec.order_line_id,
1275: x_pricing_attb_tbl => x_pricing_attb_tbl,
1276: x_return_status => x_return_status );
1277:

Line 1299: csi_utl_pkg.conv_to_prim_uom(

1295: END IF;
1296: -- End bug 5101635
1297:
1298: IF l_conv_to_prim_uom_req = 'Y' THEN -- Added for bug 5101635
1299: csi_utl_pkg.conv_to_prim_uom(
1300: p_inv_organization_id => l_order_line_rec.inv_org_id,
1301: p_inventory_item_id => l_order_line_rec.inv_item_id,
1302: p_uom => l_order_line_rec.order_quantity_uom,
1303: x_txn_line_dtl_tbl => l_txn_line_detail_tbl,

Line 1769: nvl(csi_utl_pkg.get_lot_ctrl_code(p_trx_id),lot_control_code) lot_control_code,-- Added for bug#14835893

1765: abs(mmt.transaction_quantity) shipped_quantity,
1766: mmt.transaction_uom,
1767: mmt.transaction_date,
1768: -- msi.lot_control_code,
1769: nvl(csi_utl_pkg.get_lot_ctrl_code(p_trx_id),lot_control_code) lot_control_code,-- Added for bug#14835893
1770: msi.serial_number_control_code,
1771: msi.reservable_type,
1772: haou.location_id hr_location_id,
1773: msei.location_id subinv_location_id,

Line 1829: nvl(csi_utl_pkg.get_lot_ctrl_code(p_trx_id),lot_control_code) lot_control_code,-- Added for bug#14835893

1825: abs(mtln.transaction_quantity) shipped_quantity,
1826: mmt.transaction_uom,
1827: mmt.transaction_date,
1828: -- msi.lot_control_code,
1829: nvl(csi_utl_pkg.get_lot_ctrl_code(p_trx_id),lot_control_code) lot_control_code,-- Added for bug#14835893
1830: msi.serial_number_control_code,
1831: msi.reservable_type,
1832: haou.location_id hr_location_id,
1833: msei.location_id subinv_location_id,

Line 2030: csi_utl_pkg.get_party_id(

2026:
2027:
2028: /* Derive the party_id from hz_cust_accounts table */
2029:
2030: csi_utl_pkg.get_party_id(
2031: p_cust_acct_id => mmt_rec.end_customer_id, --mmt_rec.sold_to_org_id,
2032: x_party_id => l_party_id,
2033: x_return_status => l_return_status);
2034:

Line 2464: csi_utl_pkg.get_model_inst_lst(

2460: RAISE fnd_api.g_exc_error;
2461: END IF;
2462: --
2463: IF NOT l_macd_processing THEN
2464: csi_utl_pkg.get_model_inst_lst(
2465: p_parent_line_id => p_order_line_rec.link_to_line_id,
2466: x_model_inst_tbl => x_model_inst_tbl,
2467: x_return_status => l_return_status);
2468:

Line 2635: csi_utl_pkg.build_txn_relations(

2631: --Added (Start) for m-to-m enhancements
2632: --05/20 For each TLD in ,l_txn_line_detail_tbl
2633: --get the relations and append these relations to l_txn_ii_rltns_tbl.
2634:
2635: csi_utl_pkg.build_txn_relations(
2636: l_txn_line_detail_tbl,
2637: l_temp_txn_ii_rltns_tbl,
2638: l_return_status);
2639:

Line 2765: csi_utl_pkg.get_qty_ratio(

2761: END IF;
2762:
2763: debug('l_txn_line_detail_tbl.count ='||l_txn_line_detail_tbl.count );
2764:
2765: csi_utl_pkg.get_qty_ratio(
2766: p_order_line_qty => p_order_line_rec.ordered_quantity,
2767: p_link_to_line_id => p_order_line_rec.link_to_line_id,
2768: p_order_item_id => p_order_line_rec.inv_item_id,
2769: p_model_remnant_flag => p_order_line_rec.model_remnant_flag, --added for bug5096435

Line 2787: csi_utl_pkg.build_parent_relation(

2783: x_model_inst_tbl(i).process_flag := 'N';
2784: END LOOP;
2785: END IF;
2786:
2787: csi_utl_pkg.build_parent_relation(
2788: p_order_line_rec => p_order_line_rec,
2789: x_model_inst_tbl => x_model_inst_tbl,
2790: x_txn_line_dtl_tbl => l_txn_line_detail_tbl,
2791: x_txn_ii_rltns_tbl => l_txn_ii_rltns_tbl,

Line 2829: csi_utl_pkg.build_child_relation(

2825: null;
2826: END;
2827:
2828: IF NVL(p_order_line_rec.model_remnant_flag,'N') <> 'Y' THEN
2829: csi_utl_pkg.build_child_relation(
2830: p_order_line_rec => p_order_line_rec,
2831: p_model_txn_line_rec => l_txn_line_rec,
2832: px_csi_txn_rec => l_trx_rec,
2833: x_return_status => l_return_status);

Line 3239: l_config_exists := csi_utl_pkg.Check_config_exists(

3235: THEN
3236:
3237: debug('Checking if Config exists.. ');
3238:
3239: l_config_exists := csi_utl_pkg.Check_config_exists(
3240: x_txn_ii_rltns_tbl,
3241: x_txn_line_detail_tbl(j).txn_line_detail_id);
3242:
3243: IF l_config_exists AND

Line 3253: csi_utl_pkg.create_txn_details(

3249:
3250: l_upd_txn_line_dtl_tbl(l_upd).txn_line_detail_id := x_txn_line_detail_tbl(j).txn_line_detail_id;
3251: l_upd_txn_line_dtl_tbl(l_upd).processing_status := 'ERROR';
3252:
3253: csi_utl_pkg.create_txn_details(
3254: x_txn_line_dtl_rec => x_txn_line_detail_tbl(j),
3255: p_txn_sub_type_rec => p_txn_sub_type_rec,
3256: p_order_shipment_rec => x_order_shipment_tbl(i),
3257: p_order_line_rec => p_order_line_rec,

Line 3312: csi_utl_pkg.split_ship_rec(

3308: x_txn_line_detail_tbl(j).processing_status := 'IN_PROCESS';
3309:
3310: debug('Remaining qty to process ='||l_proc_qty);
3311:
3312: csi_utl_pkg.split_ship_rec(
3313: x_upd_txn_line_dtl_tbl => l_upd_txn_line_dtl_tbl,
3314: x_txn_line_detail_tbl => x_txn_line_detail_tbl,
3315: x_txn_line_detail_rec => x_txn_line_detail_tbl(j),
3316: p_txn_sub_type_rec => p_txn_sub_type_rec,

Line 3377: csi_utl_pkg.create_txn_details(

3373: debug('shipped_qty ='||x_order_shipment_tbl(i).shipped_quantity);
3374: debug('txn_qty ='||x_txn_line_detail_tbl(j).quantity);
3375:
3376: /* create_txn_line_dtls with the shipped qty */
3377: csi_utl_pkg.create_txn_details(
3378: x_txn_line_dtl_rec => x_txn_line_detail_tbl(j),
3379: p_txn_sub_type_rec => p_txn_sub_type_rec,
3380: p_order_shipment_rec => x_order_shipment_tbl(i),
3381: p_order_line_rec => p_order_line_rec,

Line 3532: l_config_exists := csi_utl_pkg.Check_config_exists(

3528: ELSE
3529:
3530: debug('Checking if config exists ');
3531:
3532: l_config_exists := csi_utl_pkg.Check_config_exists(
3533: x_txn_ii_rltns_tbl,
3534: x_txn_line_detail_tbl(j).txn_line_detail_id);
3535: IF l_config_exists
3536: AND

Line 3548: csi_utl_pkg.create_txn_details(

3544: l_upd := l_upd +1;
3545:
3546: debug('Config exists so ignoring the txn_line_dtl and creating one');
3547:
3548: csi_utl_pkg.create_txn_details(
3549: x_txn_line_dtl_rec => x_txn_line_detail_tbl(j),
3550: p_txn_sub_type_rec => p_txn_sub_type_rec,
3551: p_order_shipment_rec => x_order_shipment_tbl(i),
3552: p_order_line_rec => p_order_line_rec,

Line 3629: l_config_exists := csi_utl_pkg.Check_config_exists

3625: IF x_txn_line_detail_tbl(j).instance_exists_flag = 'N' THEN
3626:
3627: debug('Checking if config exists ');
3628:
3629: l_config_exists := csi_utl_pkg.Check_config_exists
3630: (x_txn_ii_rltns_tbl,
3631: x_txn_line_detail_tbl(j).txn_line_detail_id);
3632: IF l_config_exists AND
3633: x_txn_line_detail_tbl(j).preserve_detail_flag = 'N' THEN

Line 3644: csi_utl_pkg.create_txn_details

3640: x_order_shipment_tbl(i).quantity_match := 'Y';
3641: x_order_shipment_tbl(i).instance_match := 'Y';
3642: x_txn_line_detail_tbl(j).processing_status := 'ERROR';
3643:
3644: csi_utl_pkg.create_txn_details
3645: (x_txn_line_dtl_rec => x_txn_line_detail_tbl(j)
3646: ,p_txn_sub_type_rec => p_txn_sub_type_rec
3647: ,p_order_shipment_rec => x_order_shipment_tbl(i)
3648: ,p_order_line_rec => p_order_line_rec

Line 3689: csi_utl_pkg.split_txn_dtls_with_qty(

3685: ELSIF l_total_proc_qty < x_txn_line_detail_tbl(j).quantity THEN
3686: l_upd_txn_line_dtl_tbl(l_upd).quantity := l_total_proc_qty;
3687: l_rem_qty := x_txn_line_detail_tbl(j).quantity - l_total_proc_qty;
3688: debug('Installation line detail quantity > mtl transaction quantity,so split line dtls');
3689: csi_utl_pkg.split_txn_dtls_with_qty(
3690: split_txn_dtl_id => x_txn_line_detail_tbl(j).txn_line_detail_id,
3691: p_split_qty => l_rem_qty,
3692: x_return_status => l_return_status );
3693: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 3720: csi_utl_pkg.create_txn_details

3716:
3717: l_upd_txn_line_dtl_tbl(l_upd).txn_line_detail_id := x_txn_line_detail_tbl(j).txn_line_detail_id;
3718: l_upd_txn_line_dtl_tbl(l_upd).processing_status := 'ERROR' ;
3719:
3720: csi_utl_pkg.create_txn_details
3721: (x_txn_line_dtl_rec => x_txn_line_detail_tbl(j)
3722: ,p_txn_sub_type_rec => p_txn_sub_type_rec
3723: ,p_order_shipment_rec => x_order_shipment_tbl(i)
3724: ,p_order_line_rec => p_order_line_rec

Line 3933: csi_utl_pkg.make_non_header_tbl(

3929:
3930:
3931: l_instance_hdr_tbl(1) := p_instance_hdr_rec;
3932:
3933: csi_utl_pkg.make_non_header_tbl(
3934: p_instance_header_tbl => l_instance_hdr_tbl,
3935: x_instance_tbl => l_instance_tbl,
3936: x_return_status => l_return_status);
3937:

Line 4742: csi_utl_pkg.get_system_tbl(

4738: RAISE fnd_api.g_exc_error;
4739: END;
4740:
4741: IF NOT(l_system_exist) THEN
4742: csi_utl_pkg.get_system_tbl(
4743: p_txn_systems_rec => px_txn_systems_tbl(ind),
4744: x_cre_systems_rec => l_system_rec );
4745:
4746: csi_t_gen_utility_pvt.dump_api_info(

Line 5417: csi_utl_pkg.get_dflt_inst_status_id(

5413: RAISE fnd_api.g_exc_error;
5414: END IF;
5415: END IF; -- end if for system table count > 0
5416:
5417: csi_utl_pkg.get_dflt_inst_status_id(
5418: x_instance_status_id => l_dflt_inst_status_id,
5419: x_return_status => l_return_status);
5420:
5421: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 5487: csi_utl_pkg.get_sub_type_rec(

5483: l_total_qty_processed := l_total_qty_processed + l_tld_rec.quantity;
5484:
5485: /* Get the sub_type_rec from the txn line_dtls */
5486:
5487: csi_utl_pkg.get_sub_type_rec(
5488: p_sub_type_id => l_tld_rec.sub_type_id,
5489: p_trx_type_id => p_txn_line_rec.source_transaction_type_id,
5490: x_trx_sub_type_rec => x_trx_sub_type_rec,
5491: x_return_status => x_return_status) ;

Line 5497: csi_utl_pkg.get_org_assignment_tbl(

5493: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5494: raise fnd_api.g_exc_error;
5495: END IF;
5496:
5497: csi_utl_pkg.get_org_assignment_tbl(
5498: p_txn_line_detail_rec => l_tld_rec,
5499: p_txn_org_assgn_tbl => l_tld_oa_tbl,
5500: x_cre_org_units_tbl => l_cre_org_units_tbl,
5501: x_upd_org_units_tbl => l_upd_org_units_tbl,

Line 5508: csi_utl_pkg.get_ext_attribs_tbl(

5504: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5505: raise fnd_api.g_exc_error;
5506: END IF;
5507:
5508: csi_utl_pkg.get_ext_attribs_tbl(
5509: p_txn_line_detail_rec => l_tld_rec,
5510: p_txn_ext_attrib_vals_tbl => l_tld_ea_tbl,
5511: x_cre_ext_attrib_val_tbl => l_cre_ext_attrib_val_tbl,
5512: x_upd_ext_attrib_val_tbl => l_upd_ext_attrib_val_tbl,

Line 5519: csi_utl_pkg.get_party_owner(

5515: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5516: raise fnd_api.g_exc_error;
5517: END IF;
5518:
5519: csi_utl_pkg.get_party_owner(
5520: p_txn_line_detail_rec => l_tld_rec,
5521: p_txn_party_detail_tbl => l_tld_party_tbl,
5522: p_txn_pty_acct_dtl_tbl => l_tld_account_tbl,
5523: x_trx_sub_type_rec => x_trx_sub_type_rec,

Line 5668: csi_utl_pkg.get_instance(

5664: IF NVL(l_tld_rec.instance_id,fnd_api.g_miss_num ) <> fnd_api.g_miss_num THEN
5665:
5666: l_upd_instance_rec := l_tmp_instance_rec;
5667:
5668: csi_utl_pkg.get_instance(
5669: p_instance_id => l_tld_rec.instance_id,
5670: x_obj_version_number => l_inst_obj_ver_num,
5671: x_inst_qty => l_curr_instance_qty,
5672: x_return_status => x_return_status);

Line 5736: csi_utl_pkg.rebuild_tbls(

5732: l_curr_instance_qty := l_so_qty ;
5733: l_inst_obj_ver_num := l_so_obj_ver_num;
5734: l_instance_id := l_so_instance_id;
5735:
5736: csi_utl_pkg.rebuild_tbls(
5737: p_new_instance_id => l_so_instance_id,
5738: x_upd_party_tbl => l_upd_party_tbl,
5739: x_upd_party_acct_tbl => l_upd_party_acct_tbl,
5740: x_upd_org_units_tbl => l_upd_org_units_tbl,

Line 5793: csi_utl_pkg.rebuild_tbls(

5789: INTO l_inst_obj_ver_num
5790: FROM csi_item_instances
5791: WHERE instance_id = l_tld_rec.changed_instance_id;
5792:
5793: csi_utl_pkg.rebuild_tbls(
5794: p_new_instance_id => l_instance_id,
5795: x_upd_party_tbl => l_upd_party_tbl,
5796: x_upd_party_acct_tbl => l_upd_party_acct_tbl,
5797: x_upd_org_units_tbl => l_upd_org_units_tbl,

Line 5949: csi_utl_pkg.rebuild_tbls(

5945: debug(' New Instance_ID :' ||l_split_new_inst_rec.instance_id );
5946:
5947: debug('Rebuilding the TD tables for the newly created instance.');
5948:
5949: csi_utl_pkg.rebuild_tbls(
5950: p_new_instance_id => l_instance_id,
5951: x_upd_party_tbl => l_upd_party_tbl,
5952: x_upd_party_acct_tbl => l_upd_party_acct_tbl,
5953: x_upd_org_units_tbl => l_upd_org_units_tbl,

Line 6118: csi_utl_pkg.call_contracts_chk(

6114:
6115:
6116: /* check if this is a replacement instnace. If this is replacement
6117: then pass the call_contracts flag as false . bug 2298453*/
6118: csi_utl_pkg.call_contracts_chk(
6119: p_txn_line_detail_id => l_tld_rec.txn_line_detail_id,
6120: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
6121: x_call_contracts => l_call_contracts,
6122: x_return_status => l_return_status);

Line 6266: csi_utl_pkg.get_parties_and_accounts(

6262:
6263: END IF;
6264: /* End Of Code fix as part of ER 2581101 */
6265:
6266: csi_utl_pkg.get_parties_and_accounts(
6267: p_instance_id => l_upd_instance_rec.instance_id,
6268: p_tld_rec => l_tld_rec,
6269: p_t_pty_tbl => l_tld_party_tbl,
6270: p_t_pty_acct_tbl => l_tld_account_tbl,

Line 6297: csi_utl_pkg.get_unit_price_in_primary_uom(

6293: l_item_control_rec.inventory_item_id := l_order_line_rec.inv_item_id;
6294: l_item_control_rec.organization_id := l_order_line_rec.inv_org_id;
6295: l_item_control_rec.primary_uom_code := l_order_line_rec.primary_uom;
6296:
6297: csi_utl_pkg.get_unit_price_in_primary_uom(
6298: p_unit_price => l_order_line_rec.unit_price,
6299: p_unit_price_uom => l_order_line_rec.order_quantity_uom,
6300: px_item_control_rec => l_item_control_rec,
6301: x_unit_price_in_primary_uom => l_upd_instance_rec.sales_unit_price,

Line 6508: csi_utl_pkg.create_party_and_acct(

6504:
6505: END IF;
6506:
6507: /*
6508: csi_utl_pkg.create_party_and_acct(
6509: p_instance_id => l_instance_id,
6510: p_txn_line_detail_rec => l_tld_rec,
6511: p_txn_party_detail_tbl => l_tld_party_tbl,
6512: p_txn_pty_acct_dtl_tbl => l_tld_account_tbl,

Line 6737: csi_utl_pkg.build_inst_ii_tbl(

6733: END IF;
6734:
6735: IF p_txn_ii_rltns_tbl.count > 0 THEN
6736:
6737: csi_utl_pkg.build_inst_ii_tbl(
6738: p_orig_inst_id => l_upd_instance_rec.instance_id,
6739: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl ,
6740: p_new_instance_tbl => l_auto_split_instances,
6741: x_return_status => x_return_status );

Line 6755: csi_utl_pkg.get_master_organization(

6751:
6752: l_cre_instance_rec := l_tmp_instance_rec;
6753:
6754: /* get the master organization */
6755: csi_utl_pkg.get_master_organization(
6756: p_organization_id => l_tld_rec.inv_organization_id,
6757: p_master_organization_id => x_master_org_id,
6758: x_return_status => x_return_status);
6759:

Line 6931: csi_utl_pkg.get_parties_and_accounts(

6927: l_owner_acct_rec := NULL;
6928: END IF;
6929: -- End Bug 9588170
6930:
6931: csi_utl_pkg.get_parties_and_accounts(
6932: p_instance_id => l_cre_instance_rec.instance_id,
6933: p_tld_rec => l_tld_rec,
6934: p_t_pty_tbl => l_tld_party_tbl,
6935: p_t_pty_acct_tbl => l_tld_account_tbl,

Line 6966: csi_utl_pkg.get_unit_price_in_primary_uom(

6962: l_item_control_rec.inventory_item_id := l_order_line_rec.inv_item_id;
6963: l_item_control_rec.organization_id := l_order_line_rec.inv_org_id;
6964: l_item_control_rec.primary_uom_code := l_order_line_rec.primary_uom;
6965:
6966: csi_utl_pkg.get_unit_price_in_primary_uom(
6967: p_unit_price => l_order_line_rec.unit_price,
6968: p_unit_price_uom => l_order_line_rec.order_quantity_uom,
6969: px_item_control_rec => l_item_control_rec,
6970: x_unit_price_in_primary_uom => l_cre_instance_rec.sales_unit_price,

Line 7044: csi_utl_pkg.create_party_and_acct(

7040: debug(' txn_party_detail_tbl.count :'||p_txn_party_detail_tbl.count);
7041: debug(' txn_pty_acct_dtl_tbl.count :'||p_txn_pty_acct_dtl_tbl.count);
7042:
7043: /*
7044: csi_utl_pkg.create_party_and_acct(
7045: p_instance_id => l_cre_instance_rec.instance_id,
7046: p_txn_line_detail_rec => l_tld_rec ,
7047: p_txn_party_detail_tbl => p_txn_party_detail_tbl ,
7048: p_txn_pty_acct_dtl_tbl => p_txn_pty_acct_dtl_tbl,

Line 7098: csi_utl_pkg.build_inst_ii_tbl(

7094: END IF;
7095:
7096: IF p_txn_ii_rltns_tbl.count > 0 THEN
7097:
7098: csi_utl_pkg.build_inst_ii_tbl(
7099: p_orig_inst_id => l_cre_instance_rec.instance_id,
7100: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
7101: p_new_instance_tbl => l_auto_split_instances,
7102: x_return_status => x_return_status);

Line 7145: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(

7141: x_single_cps_tbl => l_single_cps_tbl);
7142:
7143: IF l_single_cps_tbl.count > 0 THEN
7144:
7145: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(
7146: p_order_line_rec => l_order_line_rec);
7147:
7148: IF l_bom_explode_flag THEN
7149:

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

7149:
7150: FOR l_scp_ind IN l_single_cps_tbl.FIRST .. l_single_cps_tbl.LAST
7151: LOOP
7152:
7153: IF NOT(csi_utl_pkg.wip_config_exists(l_single_cps_tbl(l_scp_ind).instance_id)) THEN
7154:
7155: l_relationship_exist := check_option_relationship (
7156: p_option_object_id => l_single_cps_tbl(l_scp_ind).instance_id,
7157: p_source => p_source,

Line 7316: csi_utl_pkg.get_ii_relation_tbl(

7312: END IF;
7313: ELSE
7314: /* Added p_trx_rec for ER 2581101 */
7315:
7316: csi_utl_pkg.get_ii_relation_tbl(
7317: p_txn_line_detail_tbl => p_txn_line_detail_tbl,
7318: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl ,
7319: p_trx_rec => l_trx_rec,
7320: p_order_line_rec => l_order_line_rec,

Line 7417: csi_utl_pkg.call_contracts_chk(

7413: /* check if this is a replacement instnace. If this is replacement
7414: then pass the call_contracts flag as false . bug 2298453*/
7415: l_call_contracts := fnd_api.g_true;
7416:
7417: csi_utl_pkg.call_contracts_chk(
7418: p_txn_line_detail_id => l_tld_rec.txn_line_detail_id,
7419: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
7420: x_call_contracts => l_call_contracts,
7421: x_return_status => l_return_status);

Line 7651: csi_utl_pkg.get_sub_type_rec(

7647: debug(' instance_id :'||p_txn_line_detail_tbl(i).instance_id);
7648: debug(' quantity :'||p_txn_line_detail_tbl(i).quantity);
7649:
7650: /* Derive the trx_sub_type from the txn details */
7651: csi_utl_pkg.get_sub_type_rec(
7652: p_sub_type_id => p_txn_line_detail_tbl(i).sub_type_id,
7653: p_trx_type_id => p_txn_line_rec.source_transaction_type_id,
7654: x_trx_sub_type_rec => x_txn_sub_type_rec,
7655: x_return_status => x_return_status) ;

Line 7883: csi_utl_pkg.get_party_id(

7879: p_txn_party_detail_tbl(l_pty).instance_party_id := fnd_api.g_miss_num;
7880: p_txn_party_detail_tbl(l_pty).txn_party_detail_id := l_txn_party_detail_id;
7881: p_txn_party_detail_tbl(l_pty).relationship_type_code := 'SOLD_TO';
7882:
7883: csi_utl_pkg.get_party_id(
7884: p_cust_acct_id => p_order_line_rec.sold_to_org_id,
7885: x_party_id => l_party_id,
7886: x_return_status => l_return_status);
7887:

Line 7894: csi_utl_pkg.get_party_id(

7890: END IF;
7891:
7892: p_txn_party_detail_tbl(l_pty).party_source_id := l_party_id;
7893:
7894: csi_utl_pkg.get_party_id(
7895: p_cust_acct_id => p_order_line_rec.end_customer_id,
7896: x_party_id => l_owner_party,
7897: x_return_status => l_return_status);
7898:

Line 7997: l_found := csi_utl_pkg.validate_inst_party

7993: IF NVL(p_txn_line_detail_tbl(i).instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num AND
7994: NVL(p_txn_party_detail_tbl(j).instance_party_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
7995:
7996: /* validate if the instance_party_id is for that instance_id */
7997: l_found := csi_utl_pkg.validate_inst_party
7998: (p_txn_line_detail_tbl(i).instance_id,
7999: p_txn_party_detail_tbl(j).instance_party_id,
8000: p_txn_party_detail_tbl(j).relationship_type_code);
8001:

Line 8072: NOT(csi_utl_pkg.check_relation_exists(

8068: /* If src_reference_reqd = 'Y' then the relationship should be defined in the txn_ii_rltns_tbl */
8069:
8070: IF x_txn_sub_type_rec.src_reference_reqd = 'Y'
8071: AND
8072: NOT(csi_utl_pkg.check_relation_exists(
8073: p_txn_ii_rltns_tbl,
8074: p_txn_line_detail_tbl(i).txn_line_detail_id))
8075: THEN
8076: fnd_message.set_name('CSI','CSI_INT_NSRC_REL_MISSING');

Line 8091: l_found := csi_utl_pkg.validate_inst_party

8087: NVL(p_txn_party_detail_tbl(j).instance_party_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
8088:
8089: /* validate if the instance_party_id is for that instance_id */
8090:
8091: l_found := csi_utl_pkg.validate_inst_party
8092: (p_txn_line_detail_tbl(i).instance_id,
8093: p_txn_party_detail_tbl(j).instance_party_id,
8094: p_txn_party_detail_tbl(j).relationship_type_code);
8095: IF NOT(l_found) THEN

Line 8150: csi_utl_pkg.get_inst_relation(

8146: debug('Validating ii_relationships .. ' );
8147:
8148: IF NVL(p_txn_ii_rltns_tbl(j).csi_inst_relationship_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
8149:
8150: csi_utl_pkg.get_inst_relation(
8151: p_ii_relationship_id => p_txn_ii_rltns_tbl(j).csi_inst_relationship_id,
8152: x_object_id => l_curr_object_id,
8153: x_subject_id => l_curr_subject_id,
8154: x_return_status => x_return_status);

Line 8314: csi_utl_pkg.get_qty_ratio(

8310: END ;
8311:
8312: x_trx_line_id := l_trx_line_id;
8313:
8314: csi_utl_pkg.get_qty_ratio(
8315: p_order_line_qty => p_order_line_rec.ordered_quantity,
8316: p_order_item_id => p_order_line_rec.inv_item_id,
8317: p_model_remnant_flag => p_order_line_rec.model_remnant_flag, --added for bug5096435
8318: p_link_to_line_id => p_order_line_rec.link_to_line_id,

Line 8427: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);

8423: ELSE
8424: x_cre_txn_line_dtls_tbl(i).mfg_serial_number_flag := 'N';
8425: END IF;
8426:
8427: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);
8428:
8429: IF l_inst_party_id = -1 THEN
8430: raise fnd_api.g_exc_error;
8431: END IF;

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

8443:
8444: /* get ip_account_id only if instance_party_id does not exist */
8445:
8446: IF l_inst_party_id is not null THEN
8447: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);
8448: END IF;
8449:
8450: /* If ip_account_id is -1 then account does not exist in IB */
8451:

Line 8525: csi_utl_pkg.create_txn_dtls(

8521: --4483052
8522: IF p_trackable_parent
8523: THEN
8524: debug('Splitting the created installation details in to one each if it is a parent' );
8525: csi_utl_pkg.create_txn_dtls(
8526: p_source_trx_id => p_order_line_rec.order_line_id,
8527: p_source_trx_table => 'WSH_DELIVERY_DETAILS',
8528: x_return_status => l_return_status );
8529: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 8699: csi_utl_pkg.get_source_trx_dtls(

8695: (l_mtl_txn_id = fnd_api.g_miss_num) THEN
8696: raise fnd_api.g_exc_error;
8697: END IF;
8698:
8699: csi_utl_pkg.get_source_trx_dtls(
8700: p_mtl_transaction_id => l_mtl_txn_id,
8701: x_mtl_txn_rec => X_MTL_TRX_REC,
8702: x_error_message => x_error_message,
8703: x_return_status => l_return_status);