[Home] [Help]
583: /* this routine checks if ib is active */
584: csi_utility_grp.check_ib_active;
585:
586: /* get internal party id */
587: csi_utl_pkg.get_int_party(
588: x_int_party_id => l_internal_party_id,
589: x_return_status => l_return_status);
590:
591: IF l_return_status <> fnd_api.g_ret_sts_success THEN
592: raise fnd_api.g_exc_error;
593: END IF;
594:
595: -- Get the order line details
596: csi_utl_pkg.get_order_line_dtls(
597: p_mtl_transaction_id => p_mtl_transaction_id,
598: x_order_line_rec => l_order_line_rec,
599: x_return_status => l_return_status);
600:
627:
628:
629: dbms_application_info.set_client_info(l_order_line_rec.org_id);
630:
631: csi_utl_pkg.get_item_control_rec(
632: p_mtl_txn_id => p_mtl_transaction_id,
633: x_item_control_rec => l_item_control_rec,
634: x_return_status => l_return_status);
635:
658: l_error_rec.comms_nl_trackable_flag := l_item_control_rec.ib_trackable_flag;
659:
660: IF NVL(l_order_line_rec.link_to_line_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
661:
662: csi_utl_pkg.get_link_to_line_id (
663: x_link_to_line_id => l_order_line_rec.link_to_line_id,
664: x_return_status => l_return_status );
665:
666: IF l_return_status <> fnd_api.g_ret_sts_success THEN
669:
670: END IF;
671:
672: -- check if there is any ib trackable children for the current order line
673: csi_utl_pkg.get_ib_trackable_children(
674: p_order_line_rec => l_order_line_rec,
675: x_trackable_line_tbl => l_trk_oe_line_tbl,
676: x_return_status => l_return_status);
677:
683: l_trackable_parent := TRUE;
684: END IF;
685:
686: /* getting the default sub type id */
687: csi_utl_pkg.get_dflt_sub_type_id(
688: p_transaction_type_id => g_txn_type_id,
689: x_sub_type_id => g_dflt_sub_type_id,
690: x_return_status => l_return_status);
691:
692: IF l_return_status <> fnd_api.g_ret_sts_success THEN
693: raise fnd_api.g_exc_error;
694: END IF;
695:
696: csi_utl_pkg.get_sub_type_rec(
697: p_sub_type_id => g_dflt_sub_type_id,
698: p_trx_type_id => g_txn_type_id,
699: x_trx_sub_type_rec => x_trx_sub_type_rec,
700: x_return_status => l_return_status) ;
735: IF NVL(l_order_line_rec.link_to_line_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
736:
737: debug('This is a child order line. Check model and cascade installation details.');
738:
739: csi_utl_pkg.get_qty_ratio(
740: p_order_line_qty => l_order_line_rec.ordered_quantity,
741: p_order_item_id => l_order_line_rec.inv_item_id,
742: p_model_remnant_flag => l_order_line_rec.model_remnant_flag, --added for bug5096435
743: p_link_to_line_id => l_order_line_rec.link_to_line_id,
747: IF x_return_status <> fnd_api.g_ret_sts_success THEN
748: raise fnd_api.g_exc_error;
749: END IF;
750:
751: csi_utl_pkg.cascade_txn_dtls(
752: p_source_trx_id => l_order_line_rec.order_line_id,
753: p_source_trx_table => 'OE_ORDER_LINES_ALL',
754: p_ratio => l_qty_ratio,
755: x_return_status => x_return_status);
838:
839: debug('splitting the WSH txn details in to one each.' );
840:
841: -- shegde 2769321 oe_orderlines_all changed to wsh_delivery_details
842: csi_utl_pkg.create_txn_dtls(
843: p_source_trx_id => l_order_line_rec.order_line_id,
844: p_source_trx_table => 'WSH_DELIVERY_DETAILS',
845: x_return_status => x_return_status );
846:
894: /* -----------------------------------------------*/
895:
896: IF NVL(l_order_line_rec.link_to_line_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
897:
898: csi_utl_pkg.get_qty_ratio(
899: p_order_line_qty => l_order_line_rec.ordered_quantity,
900: p_order_item_id => l_order_line_rec.inv_item_id,
901: p_model_remnant_flag => l_order_line_rec.model_remnant_flag, --added for bug5096435
902: p_link_to_line_id => l_order_line_rec.link_to_line_id,
906: IF l_return_status <> fnd_api.g_ret_sts_success THEN
907: raise fnd_api.g_exc_error;
908: END IF;
909:
910: csi_utl_pkg.cascade_txn_dtls(
911: p_source_trx_id => l_order_line_rec.order_line_id,
912: p_source_trx_table => 'OE_ORDER_LINES_ALL',
913: p_ratio => l_qty_ratio ,
914: x_return_status => l_return_status );
990: IF l_item_control_rec.serial_control_code <> 1 OR l_trackable_parent THEN
991:
992: debug('splitting the WSH txn details in to one each' );
993: -- shegde 2769321 oe_orderlines_all changed to wsh_delivery_details
994: csi_utl_pkg.create_txn_dtls(
995: p_source_trx_id => l_order_line_rec.order_line_id,
996: p_source_trx_table => 'WSH_DELIVERY_DETAILS',
997: x_return_status => l_return_status );
998:
1012: IF l_trx_detail_exist then
1013:
1014: debug('check if this is a partial shipment case.');
1015:
1016: csi_utl_pkg.get_split_order_line(
1017: l_order_line_rec.order_line_id,
1018: l_order_line_rec.header_id,
1019: l_split_ord_line_id,
1020: l_return_status);
1212: /* Get the pricing attributes for the order line and */
1213: /* pass it to update_install_base */
1214: /*---------------------------------------------------*/
1215:
1216: csi_utl_pkg.Get_Pricing_Attribs(
1217: p_line_id => l_order_line_rec.order_line_id,
1218: x_pricing_attb_tbl => x_pricing_attb_tbl,
1219: x_return_status => x_return_status );
1220:
1238: END IF;
1239: -- End bug 5101635
1240:
1241: IF l_conv_to_prim_uom_req = 'Y' THEN -- Added for bug 5101635
1242: csi_utl_pkg.conv_to_prim_uom(
1243: p_inv_organization_id => l_order_line_rec.inv_org_id,
1244: p_inventory_item_id => l_order_line_rec.inv_item_id,
1245: p_uom => l_order_line_rec.order_quantity_uom,
1246: x_txn_line_dtl_tbl => l_txn_line_detail_tbl,
1967:
1968:
1969: /* Derive the party_id from hz_cust_accounts table */
1970:
1971: csi_utl_pkg.get_party_id(
1972: p_cust_acct_id => mmt_rec.end_customer_id, --mmt_rec.sold_to_org_id,
1973: x_party_id => l_party_id,
1974: x_return_status => l_return_status);
1975:
2401: RAISE fnd_api.g_exc_error;
2402: END IF;
2403: --
2404: IF NOT l_macd_processing THEN
2405: csi_utl_pkg.get_model_inst_lst(
2406: p_parent_line_id => p_order_line_rec.link_to_line_id,
2407: x_model_inst_tbl => x_model_inst_tbl,
2408: x_return_status => l_return_status);
2409:
2572: --Added (Start) for m-to-m enhancements
2573: --05/20 For each TLD in ,l_txn_line_detail_tbl
2574: --get the relations and append these relations to l_txn_ii_rltns_tbl.
2575:
2576: csi_utl_pkg.build_txn_relations(
2577: l_txn_line_detail_tbl,
2578: l_temp_txn_ii_rltns_tbl,
2579: l_return_status);
2580:
2702: END IF;
2703:
2704: debug('l_txn_line_detail_tbl.count ='||l_txn_line_detail_tbl.count );
2705:
2706: csi_utl_pkg.get_qty_ratio(
2707: p_order_line_qty => p_order_line_rec.ordered_quantity,
2708: p_link_to_line_id => p_order_line_rec.link_to_line_id,
2709: p_order_item_id => p_order_line_rec.inv_item_id,
2710: p_model_remnant_flag => p_order_line_rec.model_remnant_flag, --added for bug5096435
2724: x_model_inst_tbl(i).process_flag := 'N';
2725: END LOOP;
2726: END IF;
2727:
2728: csi_utl_pkg.build_parent_relation(
2729: p_order_line_rec => p_order_line_rec,
2730: x_model_inst_tbl => x_model_inst_tbl,
2731: x_txn_line_dtl_tbl => l_txn_line_detail_tbl,
2732: x_txn_ii_rltns_tbl => l_txn_ii_rltns_tbl,
2766: null;
2767: END;
2768:
2769: IF NVL(p_order_line_rec.model_remnant_flag,'N') <> 'Y' THEN
2770: csi_utl_pkg.build_child_relation(
2771: p_order_line_rec => p_order_line_rec,
2772: p_model_txn_line_rec => l_txn_line_rec,
2773: px_csi_txn_rec => l_trx_rec,
2774: x_return_status => l_return_status);
3176: THEN
3177:
3178: debug('Checking if Config exists.. ');
3179:
3180: l_config_exists := csi_utl_pkg.Check_config_exists(
3181: x_txn_ii_rltns_tbl,
3182: x_txn_line_detail_tbl(j).txn_line_detail_id);
3183:
3184: IF l_config_exists AND
3190:
3191: l_upd_txn_line_dtl_tbl(l_upd).txn_line_detail_id := x_txn_line_detail_tbl(j).txn_line_detail_id;
3192: l_upd_txn_line_dtl_tbl(l_upd).processing_status := 'ERROR';
3193:
3194: csi_utl_pkg.create_txn_details(
3195: x_txn_line_dtl_rec => x_txn_line_detail_tbl(j),
3196: p_txn_sub_type_rec => p_txn_sub_type_rec,
3197: p_order_shipment_rec => x_order_shipment_tbl(i),
3198: p_order_line_rec => p_order_line_rec,
3249: x_txn_line_detail_tbl(j).processing_status := 'IN_PROCESS';
3250:
3251: debug('Remaining qty to process ='||l_proc_qty);
3252:
3253: csi_utl_pkg.split_ship_rec(
3254: x_upd_txn_line_dtl_tbl => l_upd_txn_line_dtl_tbl,
3255: x_txn_line_detail_tbl => x_txn_line_detail_tbl,
3256: x_txn_line_detail_rec => x_txn_line_detail_tbl(j),
3257: p_txn_sub_type_rec => p_txn_sub_type_rec,
3314: debug('shipped_qty ='||x_order_shipment_tbl(i).shipped_quantity);
3315: debug('txn_qty ='||x_txn_line_detail_tbl(j).quantity);
3316:
3317: /* create_txn_line_dtls with the shipped qty */
3318: csi_utl_pkg.create_txn_details(
3319: x_txn_line_dtl_rec => x_txn_line_detail_tbl(j),
3320: p_txn_sub_type_rec => p_txn_sub_type_rec,
3321: p_order_shipment_rec => x_order_shipment_tbl(i),
3322: p_order_line_rec => p_order_line_rec,
3469: ELSE
3470:
3471: debug('Checking if config exists ');
3472:
3473: l_config_exists := csi_utl_pkg.Check_config_exists(
3474: x_txn_ii_rltns_tbl,
3475: x_txn_line_detail_tbl(j).txn_line_detail_id);
3476: IF l_config_exists
3477: AND
3485: l_upd := l_upd +1;
3486:
3487: debug('Config exists so ignoring the txn_line_dtl and creating one');
3488:
3489: csi_utl_pkg.create_txn_details(
3490: x_txn_line_dtl_rec => x_txn_line_detail_tbl(j),
3491: p_txn_sub_type_rec => p_txn_sub_type_rec,
3492: p_order_shipment_rec => x_order_shipment_tbl(i),
3493: p_order_line_rec => p_order_line_rec,
3566: IF x_txn_line_detail_tbl(j).instance_exists_flag = 'N' THEN
3567:
3568: debug('Checking if config exists ');
3569:
3570: l_config_exists := csi_utl_pkg.Check_config_exists
3571: (x_txn_ii_rltns_tbl,
3572: x_txn_line_detail_tbl(j).txn_line_detail_id);
3573: IF l_config_exists AND
3574: x_txn_line_detail_tbl(j).preserve_detail_flag = 'N' THEN
3581: x_order_shipment_tbl(i).quantity_match := 'Y';
3582: x_order_shipment_tbl(i).instance_match := 'Y';
3583: x_txn_line_detail_tbl(j).processing_status := 'ERROR';
3584:
3585: csi_utl_pkg.create_txn_details
3586: (x_txn_line_dtl_rec => x_txn_line_detail_tbl(j)
3587: ,p_txn_sub_type_rec => p_txn_sub_type_rec
3588: ,p_order_shipment_rec => x_order_shipment_tbl(i)
3589: ,p_order_line_rec => p_order_line_rec
3626: ELSIF l_total_proc_qty < x_txn_line_detail_tbl(j).quantity THEN
3627: l_upd_txn_line_dtl_tbl(l_upd).quantity := l_total_proc_qty;
3628: l_rem_qty := x_txn_line_detail_tbl(j).quantity - l_total_proc_qty;
3629: debug('Installation line detail quantity > mtl transaction quantity,so split line dtls');
3630: csi_utl_pkg.split_txn_dtls_with_qty(
3631: split_txn_dtl_id => x_txn_line_detail_tbl(j).txn_line_detail_id,
3632: p_split_qty => l_rem_qty,
3633: x_return_status => l_return_status );
3634: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3657:
3658: l_upd_txn_line_dtl_tbl(l_upd).txn_line_detail_id := x_txn_line_detail_tbl(j).txn_line_detail_id;
3659: l_upd_txn_line_dtl_tbl(l_upd).processing_status := 'ERROR' ;
3660:
3661: csi_utl_pkg.create_txn_details
3662: (x_txn_line_dtl_rec => x_txn_line_detail_tbl(j)
3663: ,p_txn_sub_type_rec => p_txn_sub_type_rec
3664: ,p_order_shipment_rec => x_order_shipment_tbl(i)
3665: ,p_order_line_rec => p_order_line_rec
3850:
3851:
3852: l_instance_hdr_tbl(1) := p_instance_hdr_rec;
3853:
3854: csi_utl_pkg.make_non_header_tbl(
3855: p_instance_header_tbl => l_instance_hdr_tbl,
3856: x_instance_tbl => l_instance_tbl,
3857: x_return_status => l_return_status);
3858:
4659: RAISE fnd_api.g_exc_error;
4660: END;
4661:
4662: IF NOT(l_system_exist) THEN
4663: csi_utl_pkg.get_system_tbl(
4664: p_txn_systems_rec => px_txn_systems_tbl(ind),
4665: x_cre_systems_rec => l_system_rec );
4666:
4667: csi_t_gen_utility_pvt.dump_api_info(
5197: RAISE fnd_api.g_exc_error;
5198: END IF;
5199: END IF; -- end if for system table count > 0
5200:
5201: csi_utl_pkg.get_dflt_inst_status_id(
5202: x_instance_status_id => l_dflt_inst_status_id,
5203: x_return_status => l_return_status);
5204:
5205: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5267: l_total_qty_processed := l_total_qty_processed + l_tld_rec.quantity;
5268:
5269: /* Get the sub_type_rec from the txn line_dtls */
5270:
5271: csi_utl_pkg.get_sub_type_rec(
5272: p_sub_type_id => l_tld_rec.sub_type_id,
5273: p_trx_type_id => p_txn_line_rec.source_transaction_type_id,
5274: x_trx_sub_type_rec => x_trx_sub_type_rec,
5275: x_return_status => x_return_status) ;
5277: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5278: raise fnd_api.g_exc_error;
5279: END IF;
5280:
5281: csi_utl_pkg.get_org_assignment_tbl(
5282: p_txn_line_detail_rec => l_tld_rec,
5283: p_txn_org_assgn_tbl => l_tld_oa_tbl,
5284: x_cre_org_units_tbl => l_cre_org_units_tbl,
5285: x_upd_org_units_tbl => l_upd_org_units_tbl,
5288: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5289: raise fnd_api.g_exc_error;
5290: END IF;
5291:
5292: csi_utl_pkg.get_ext_attribs_tbl(
5293: p_txn_line_detail_rec => l_tld_rec,
5294: p_txn_ext_attrib_vals_tbl => l_tld_ea_tbl,
5295: x_cre_ext_attrib_val_tbl => l_cre_ext_attrib_val_tbl,
5296: x_upd_ext_attrib_val_tbl => l_upd_ext_attrib_val_tbl,
5299: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
5300: raise fnd_api.g_exc_error;
5301: END IF;
5302:
5303: csi_utl_pkg.get_party_owner(
5304: p_txn_line_detail_rec => l_tld_rec,
5305: p_txn_party_detail_tbl => l_tld_party_tbl,
5306: p_txn_pty_acct_dtl_tbl => l_tld_account_tbl,
5307: x_trx_sub_type_rec => x_trx_sub_type_rec,
5414: IF NVL(l_tld_rec.instance_id,fnd_api.g_miss_num ) <> fnd_api.g_miss_num THEN
5415:
5416: l_upd_instance_rec := l_tmp_instance_rec;
5417:
5418: csi_utl_pkg.get_instance(
5419: p_instance_id => l_tld_rec.instance_id,
5420: x_obj_version_number => l_inst_obj_ver_num,
5421: x_inst_qty => l_curr_instance_qty,
5422: x_return_status => x_return_status);
5475: l_curr_instance_qty := l_so_qty ;
5476: l_inst_obj_ver_num := l_so_obj_ver_num;
5477: l_instance_id := l_so_instance_id;
5478:
5479: csi_utl_pkg.rebuild_tbls(
5480: p_new_instance_id => l_so_instance_id,
5481: x_upd_party_tbl => l_upd_party_tbl,
5482: x_upd_party_acct_tbl => l_upd_party_acct_tbl,
5483: x_upd_org_units_tbl => l_upd_org_units_tbl,
5532: INTO l_inst_obj_ver_num
5533: FROM csi_item_instances
5534: WHERE instance_id = l_tld_rec.changed_instance_id;
5535:
5536: csi_utl_pkg.rebuild_tbls(
5537: p_new_instance_id => l_instance_id,
5538: x_upd_party_tbl => l_upd_party_tbl,
5539: x_upd_party_acct_tbl => l_upd_party_acct_tbl,
5540: x_upd_org_units_tbl => l_upd_org_units_tbl,
5688: debug(' New Instance_ID :' ||l_split_new_inst_rec.instance_id );
5689:
5690: debug('Rebuilding the TD tables for the newly created instance.');
5691:
5692: csi_utl_pkg.rebuild_tbls(
5693: p_new_instance_id => l_instance_id,
5694: x_upd_party_tbl => l_upd_party_tbl,
5695: x_upd_party_acct_tbl => l_upd_party_acct_tbl,
5696: x_upd_org_units_tbl => l_upd_org_units_tbl,
5854:
5855:
5856: /* check if this is a replacement instnace. If this is replacement
5857: then pass the call_contracts flag as false . bug 2298453*/
5858: csi_utl_pkg.call_contracts_chk(
5859: p_txn_line_detail_id => l_tld_rec.txn_line_detail_id,
5860: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
5861: x_call_contracts => l_call_contracts,
5862: x_return_status => l_return_status);
6002:
6003: END IF;
6004: /* End Of Code fix as part of ER 2581101 */
6005:
6006: csi_utl_pkg.get_parties_and_accounts(
6007: p_instance_id => l_upd_instance_rec.instance_id,
6008: p_tld_rec => l_tld_rec,
6009: p_t_pty_tbl => l_tld_party_tbl,
6010: p_t_pty_acct_tbl => l_tld_account_tbl,
6033: l_item_control_rec.inventory_item_id := l_order_line_rec.inv_item_id;
6034: l_item_control_rec.organization_id := l_order_line_rec.inv_org_id;
6035: l_item_control_rec.primary_uom_code := l_order_line_rec.primary_uom;
6036:
6037: csi_utl_pkg.get_unit_price_in_primary_uom(
6038: p_unit_price => l_order_line_rec.unit_price,
6039: p_unit_price_uom => l_order_line_rec.order_quantity_uom,
6040: px_item_control_rec => l_item_control_rec,
6041: x_unit_price_in_primary_uom => l_upd_instance_rec.sales_unit_price,
6242:
6243: END IF;
6244:
6245: /*
6246: csi_utl_pkg.create_party_and_acct(
6247: p_instance_id => l_instance_id,
6248: p_txn_line_detail_rec => l_tld_rec,
6249: p_txn_party_detail_tbl => l_tld_party_tbl,
6250: p_txn_pty_acct_dtl_tbl => l_tld_account_tbl,
6471: END IF;
6472:
6473: IF p_txn_ii_rltns_tbl.count > 0 THEN
6474:
6475: csi_utl_pkg.build_inst_ii_tbl(
6476: p_orig_inst_id => l_upd_instance_rec.instance_id,
6477: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl ,
6478: p_new_instance_tbl => l_auto_split_instances,
6479: x_return_status => x_return_status );
6489:
6490: l_cre_instance_rec := l_tmp_instance_rec;
6491:
6492: /* get the master organization */
6493: csi_utl_pkg.get_master_organization(
6494: p_organization_id => l_tld_rec.inv_organization_id,
6495: p_master_organization_id => x_master_org_id,
6496: x_return_status => x_return_status);
6497:
6641:
6642: l_owner_pty_rec := l_cre_party_tbl(1);
6643: l_owner_acct_rec := l_cre_party_acct_tbl(1);
6644:
6645: csi_utl_pkg.get_parties_and_accounts(
6646: p_instance_id => l_cre_instance_rec.instance_id,
6647: p_tld_rec => l_tld_rec,
6648: p_t_pty_tbl => l_tld_party_tbl,
6649: p_t_pty_acct_tbl => l_tld_account_tbl,
6676: l_item_control_rec.inventory_item_id := l_order_line_rec.inv_item_id;
6677: l_item_control_rec.organization_id := l_order_line_rec.inv_org_id;
6678: l_item_control_rec.primary_uom_code := l_order_line_rec.primary_uom;
6679:
6680: csi_utl_pkg.get_unit_price_in_primary_uom(
6681: p_unit_price => l_order_line_rec.unit_price,
6682: p_unit_price_uom => l_order_line_rec.order_quantity_uom,
6683: px_item_control_rec => l_item_control_rec,
6684: x_unit_price_in_primary_uom => l_cre_instance_rec.sales_unit_price,
6754: debug(' txn_party_detail_tbl.count :'||p_txn_party_detail_tbl.count);
6755: debug(' txn_pty_acct_dtl_tbl.count :'||p_txn_pty_acct_dtl_tbl.count);
6756:
6757: /*
6758: csi_utl_pkg.create_party_and_acct(
6759: p_instance_id => l_cre_instance_rec.instance_id,
6760: p_txn_line_detail_rec => l_tld_rec ,
6761: p_txn_party_detail_tbl => p_txn_party_detail_tbl ,
6762: p_txn_pty_acct_dtl_tbl => p_txn_pty_acct_dtl_tbl,
6808: END IF;
6809:
6810: IF p_txn_ii_rltns_tbl.count > 0 THEN
6811:
6812: csi_utl_pkg.build_inst_ii_tbl(
6813: p_orig_inst_id => l_cre_instance_rec.instance_id,
6814: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
6815: p_new_instance_tbl => l_auto_split_instances,
6816: x_return_status => x_return_status);
6855: x_single_cps_tbl => l_single_cps_tbl);
6856:
6857: IF l_single_cps_tbl.count > 0 THEN
6858:
6859: l_bom_explode_flag := csi_utl_pkg.check_standard_bom(
6860: p_order_line_rec => l_order_line_rec);
6861:
6862: IF l_bom_explode_flag THEN
6863:
6863:
6864: FOR l_scp_ind IN l_single_cps_tbl.FIRST .. l_single_cps_tbl.LAST
6865: LOOP
6866:
6867: IF NOT(csi_utl_pkg.wip_config_exists(l_single_cps_tbl(l_scp_ind).instance_id)) THEN
6868:
6869: l_bom_std_item_rec.instance_id := l_single_cps_tbl(l_scp_ind).instance_id ;
6870: l_bom_std_item_rec.inventory_item_id := l_order_line_rec.inv_item_id ;
6871: l_bom_std_item_rec.vld_organization_id := l_order_line_rec.inv_org_id ;
7011: END IF;
7012: ELSE
7013: /* Added p_trx_rec for ER 2581101 */
7014:
7015: csi_utl_pkg.get_ii_relation_tbl(
7016: p_txn_line_detail_tbl => p_txn_line_detail_tbl,
7017: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl ,
7018: p_trx_rec => l_trx_rec,
7019: p_order_line_rec => l_order_line_rec,
7094: /* check if this is a replacement instnace. If this is replacement
7095: then pass the call_contracts flag as false . bug 2298453*/
7096: l_call_contracts := fnd_api.g_true;
7097:
7098: csi_utl_pkg.call_contracts_chk(
7099: p_txn_line_detail_id => l_tld_rec.txn_line_detail_id,
7100: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
7101: x_call_contracts => l_call_contracts,
7102: x_return_status => l_return_status);
7328: debug(' instance_id :'||p_txn_line_detail_tbl(i).instance_id);
7329: debug(' quantity :'||p_txn_line_detail_tbl(i).quantity);
7330:
7331: /* Derive the trx_sub_type from the txn details */
7332: csi_utl_pkg.get_sub_type_rec(
7333: p_sub_type_id => p_txn_line_detail_tbl(i).sub_type_id,
7334: p_trx_type_id => p_txn_line_rec.source_transaction_type_id,
7335: x_trx_sub_type_rec => x_txn_sub_type_rec,
7336: x_return_status => x_return_status) ;
7560: p_txn_party_detail_tbl(l_pty).instance_party_id := fnd_api.g_miss_num;
7561: p_txn_party_detail_tbl(l_pty).txn_party_detail_id := l_txn_party_detail_id;
7562: p_txn_party_detail_tbl(l_pty).relationship_type_code := 'SOLD_TO';
7563:
7564: csi_utl_pkg.get_party_id(
7565: p_cust_acct_id => p_order_line_rec.sold_to_org_id,
7566: x_party_id => l_party_id,
7567: x_return_status => l_return_status);
7568:
7571: END IF;
7572:
7573: p_txn_party_detail_tbl(l_pty).party_source_id := l_party_id;
7574:
7575: csi_utl_pkg.get_party_id(
7576: p_cust_acct_id => p_order_line_rec.end_customer_id,
7577: x_party_id => l_owner_party,
7578: x_return_status => l_return_status);
7579:
7674: IF NVL(p_txn_line_detail_tbl(i).instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num AND
7675: NVL(p_txn_party_detail_tbl(j).instance_party_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
7676:
7677: /* validate if the instance_party_id is for that instance_id */
7678: l_found := csi_utl_pkg.validate_inst_party
7679: (p_txn_line_detail_tbl(i).instance_id,
7680: p_txn_party_detail_tbl(j).instance_party_id,
7681: p_txn_party_detail_tbl(j).relationship_type_code);
7682:
7749: /* If src_reference_reqd = 'Y' then the relationship should be defined in the txn_ii_rltns_tbl */
7750:
7751: IF x_txn_sub_type_rec.src_reference_reqd = 'Y'
7752: AND
7753: NOT(csi_utl_pkg.check_relation_exists(
7754: p_txn_ii_rltns_tbl,
7755: p_txn_line_detail_tbl(i).txn_line_detail_id))
7756: THEN
7757: fnd_message.set_name('CSI','CSI_INT_NSRC_REL_MISSING');
7768: NVL(p_txn_party_detail_tbl(j).instance_party_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
7769:
7770: /* validate if the instance_party_id is for that instance_id */
7771:
7772: l_found := csi_utl_pkg.validate_inst_party
7773: (p_txn_line_detail_tbl(i).instance_id,
7774: p_txn_party_detail_tbl(j).instance_party_id,
7775: p_txn_party_detail_tbl(j).relationship_type_code);
7776: IF NOT(l_found) THEN
7827: debug('Validating ii_relationships .. ' );
7828:
7829: IF NVL(p_txn_ii_rltns_tbl(j).csi_inst_relationship_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
7830:
7831: csi_utl_pkg.get_inst_relation(
7832: p_ii_relationship_id => p_txn_ii_rltns_tbl(j).csi_inst_relationship_id,
7833: x_object_id => l_curr_object_id,
7834: x_subject_id => l_curr_subject_id,
7835: x_return_status => x_return_status);
7991: END ;
7992:
7993: x_trx_line_id := l_trx_line_id;
7994:
7995: csi_utl_pkg.get_qty_ratio(
7996: p_order_line_qty => p_order_line_rec.ordered_quantity,
7997: p_order_item_id => p_order_line_rec.inv_item_id,
7998: p_model_remnant_flag => p_order_line_rec.model_remnant_flag, --added for bug5096435
7999: p_link_to_line_id => p_order_line_rec.link_to_line_id,
8104: ELSE
8105: x_cre_txn_line_dtls_tbl(i).mfg_serial_number_flag := 'N';
8106: END IF;
8107:
8108: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);
8109:
8110: IF l_inst_party_id = -1 THEN
8111: raise fnd_api.g_exc_error;
8112: END IF;
8124:
8125: /* get ip_account_id only if instance_party_id does not exist */
8126:
8127: IF l_inst_party_id is not null THEN
8128: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);
8129: END IF;
8130:
8131: /* If ip_account_id is -1 then account does not exist in IB */
8132:
8202: --4483052
8203: IF p_trackable_parent
8204: THEN
8205: debug('Splitting the created installation details in to one each if it is a parent' );
8206: csi_utl_pkg.create_txn_dtls(
8207: p_source_trx_id => p_order_line_rec.order_line_id,
8208: p_source_trx_table => 'WSH_DELIVERY_DETAILS',
8209: x_return_status => l_return_status );
8210: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8376: (l_mtl_txn_id = fnd_api.g_miss_num) THEN
8377: raise fnd_api.g_exc_error;
8378: END IF;
8379:
8380: csi_utl_pkg.get_source_trx_dtls(
8381: p_mtl_transaction_id => l_mtl_txn_id,
8382: x_mtl_txn_rec => X_MTL_TRX_REC,
8383: x_error_message => x_error_message,
8384: x_return_status => l_return_status);