DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on CSD_LOGISTICS_UTIL

Line 2445: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

2441: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2442: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2443: l_tmp_char VARCHAR2(1); --R12 Development Changes
2444: /* R12 SN reservations integration change Begin */
2445: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
2446: l_auto_reserve_profile VARCHAR2(10);
2447: l_srl_reservation_id NUMBER;
2448: l_serial_rsv_rec CSD_LOGISTICS_UTIL.CSD_SERIAL_RESERVE_REC_TYPE ;
2449: /* R12 SN reservations integration change End */

Line 2448: l_serial_rsv_rec CSD_LOGISTICS_UTIL.CSD_SERIAL_RESERVE_REC_TYPE ;

2444: /* R12 SN reservations integration change Begin */
2445: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
2446: l_auto_reserve_profile VARCHAR2(10);
2447: l_srl_reservation_id NUMBER;
2448: l_serial_rsv_rec CSD_LOGISTICS_UTIL.CSD_SERIAL_RESERVE_REC_TYPE ;
2449: /* R12 SN reservations integration change End */
2450:
2451: -- swai bug 7572247/7628204: cursor to default account address for SR account
2452: CURSOR c_sr_primary_account_address(p_incident_id NUMBER, p_site_use_type VARCHAR2)

Line 3654: CSD_LOGISTICS_UTIL.Get_ItemAttributes(p_Inventory_Item_Id => x_Product_Txn_Rec.Inventory_Item_Id,

3650: l_order_rec.PICK_FROM_SUBINVENTORY := x_product_txn_rec.sub_inventory;
3651: END IF;
3652: /* R12 SN reservations change Begin */
3653: -- Get Item attributes in local variable
3654: CSD_LOGISTICS_UTIL.Get_ItemAttributes(p_Inventory_Item_Id => x_Product_Txn_Rec.Inventory_Item_Id,
3655: p_inv_org_id => x_Product_Txn_Rec.inventory_org_id,
3656: x_ItemAttributes => l_ItemAttributes);
3657: -- Get the default pick rule id
3658: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE', l_auto_reserve_profile);

Line 3698: CSD_LOGISTICS_UTIL.Reserve_serial_number(l_serial_rsv_rec, x_return_status);

3694: l_serial_rsv_rec.subinventory_code := x_Product_Txn_Rec.sub_inventory;
3695: l_serial_rsv_rec.reservation_uom_code := x_Product_Txn_Rec.Unit_Of_Measure_Code;
3696:
3697: Debug('Calling reserve serial..', l_mod_name, 1);
3698: CSD_LOGISTICS_UTIL.Reserve_serial_number(l_serial_rsv_rec, x_return_status);
3699:
3700: if(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3701: Fnd_Message.SET_NAME('CSD', 'CSD_SRL_RESERVE_FAILED');
3702: Fnd_Msg_Pub.ADD;

Line 4671: l_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;

4667: l_msg_data VARCHAR2(2000);
4668: l_msg_index NUMBER;
4669: l_return_status VARCHAR2(1);
4670: l_estimate_Rec Cs_Charge_Details_Pub.charges_rec_type;
4671: l_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;
4672: l_order_Rec Csd_Process_Pvt.om_interface_rec;
4673: l_est_detail_id NUMBER;
4674: l_add_to_order_id NUMBER;
4675: l_add_to_order_flag VARCHAR2(1);

Line 4720: l_prodtxn_db_attr := Csd_Logistics_Util.get_prodtxn_db_attr(x_product_txn_rec.product_transaction_id);

4716: Fnd_Msg_Pub.initialize;
4717: END IF;
4718:
4719:
4720: l_prodtxn_db_attr := Csd_Logistics_Util.get_prodtxn_db_attr(x_product_txn_rec.product_transaction_id);
4721:
4722: -----------------------------------------------------------------------------
4723: /*********************************************************************
4724: /* Code here got moved to CSD_LOGISTICS_UTIL.upd_prodtxn_n_chrgline

Line 4724: /* Code here got moved to CSD_LOGISTICS_UTIL.upd_prodtxn_n_chrgline

4720: l_prodtxn_db_attr := Csd_Logistics_Util.get_prodtxn_db_attr(x_product_txn_rec.product_transaction_id);
4721:
4722: -----------------------------------------------------------------------------
4723: /*********************************************************************
4724: /* Code here got moved to CSD_LOGISTICS_UTIL.upd_prodtxn_n_chrgline
4725: **********************************************************************/
4726: -----------------------------------------------------------------------------
4727: Csd_Logistics_Util.upd_prodtxn_n_chrgline(x_product_txn_rec ,
4728: l_prodtxn_db_attr,

Line 4727: Csd_Logistics_Util.upd_prodtxn_n_chrgline(x_product_txn_rec ,

4723: /*********************************************************************
4724: /* Code here got moved to CSD_LOGISTICS_UTIL.upd_prodtxn_n_chrgline
4725: **********************************************************************/
4726: -----------------------------------------------------------------------------
4727: Csd_Logistics_Util.upd_prodtxn_n_chrgline(x_product_txn_rec ,
4728: l_prodtxn_db_attr,
4729: l_est_detail_id,
4730: l_repair_line_id,
4731: l_add_to_order_flag,

Line 4770: Code here has been moved to CSD_LOGISTICS_UTIL.interface_prodtxn

4766: -- Define savepoint
4767: SAVEPOINT create_sales_order;
4768:
4769: /*******************************************************************
4770: Code here has been moved to CSD_LOGISTICS_UTIL.interface_prodtxn
4771: ********************************************************************/
4772:
4773: l_order_Rec := Csd_Logistics_Util.get_order_rec(x_product_txn_rec.repair_line_id);
4774:

Line 4773: l_order_Rec := Csd_Logistics_Util.get_order_rec(x_product_txn_rec.repair_line_id);

4769: /*******************************************************************
4770: Code here has been moved to CSD_LOGISTICS_UTIL.interface_prodtxn
4771: ********************************************************************/
4772:
4773: l_order_Rec := Csd_Logistics_Util.get_order_rec(x_product_txn_rec.repair_line_id);
4774:
4775: --bug#6071005
4776: if (x_product_txn_rec.order_line_id is not null) THEN
4777: l_order_Rec.order_line_id := x_product_txn_rec.order_line_id;

Line 4794: Csd_Logistics_Util.interface_prodtxn( x_return_status => l_return_status,

4790: l_order_Rec.party_id := x_product_txn_rec.bill_to_party_id;
4791: l_order_Rec.account_id := x_product_txn_rec.bill_to_account_id;
4792: END IF;
4793:
4794: Csd_Logistics_Util.interface_prodtxn( x_return_status => l_return_status,
4795: p_product_txn_rec => x_product_txn_rec,
4796: p_prodtxn_db_attr => l_prodtxn_db_attr,
4797: px_order_rec => l_order_rec);
4798:

Line 4811: Csd_Logistics_Util.book_prodtxn( x_return_status => l_return_status,

4807: SAVEPOINT book_sales_order;
4808: /***************************************************
4809: Code here has been moved to the api book_prodtxn
4810: ****************************************************/
4811: Csd_Logistics_Util.book_prodtxn( x_return_status => l_return_status,
4812: p_product_txn_rec => x_product_txn_rec,
4813: p_prodtxn_db_attr => l_prodtxn_db_attr,
4814: px_order_rec => l_order_rec);
4815: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4874: Code here has been moved to CSD_LOGISTICS_UTIL.pickrelease_prodtxn

4870: RAISE RELEASE_ORDER;
4871: end if;
4872: -- end bug fix #7355526, nnadig
4873: /*******************************************************************
4874: Code here has been moved to CSD_LOGISTICS_UTIL.pickrelease_prodtxn
4875: ********************************************************************/
4876: Csd_Logistics_Util.pickrelease_prodtxn(x_return_status => l_return_status,
4877: p_product_txn_rec => x_product_txn_rec,
4878: p_prodtxn_db_attr => l_prodtxn_db_attr,

Line 4876: Csd_Logistics_Util.pickrelease_prodtxn(x_return_status => l_return_status,

4872: -- end bug fix #7355526, nnadig
4873: /*******************************************************************
4874: Code here has been moved to CSD_LOGISTICS_UTIL.pickrelease_prodtxn
4875: ********************************************************************/
4876: Csd_Logistics_Util.pickrelease_prodtxn(x_return_status => l_return_status,
4877: p_product_txn_rec => x_product_txn_rec,
4878: p_prodtxn_db_attr => l_prodtxn_db_attr,
4879: px_order_rec => l_order_rec);
4880: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4893: Code here has been moved to CSD_LOGISTICS_UTIL.ship_prodtxn

4889: THEN
4890: -- Define savepoint
4891: SAVEPOINT ship_sales_order;
4892: /*******************************************************************
4893: Code here has been moved to CSD_LOGISTICS_UTIL.ship_prodtxn
4894: ********************************************************************/
4895: Csd_Logistics_Util.ship_prodtxn( x_return_status => l_return_status,
4896: p_product_txn_rec => x_product_txn_rec,
4897: p_prodtxn_db_attr => l_prodtxn_db_attr,

Line 4895: Csd_Logistics_Util.ship_prodtxn( x_return_status => l_return_status,

4891: SAVEPOINT ship_sales_order;
4892: /*******************************************************************
4893: Code here has been moved to CSD_LOGISTICS_UTIL.ship_prodtxn
4894: ********************************************************************/
4895: Csd_Logistics_Util.ship_prodtxn( x_return_status => l_return_status,
4896: p_product_txn_rec => x_product_txn_rec,
4897: p_prodtxn_db_attr => l_prodtxn_db_attr,
4898: px_order_rec => l_order_rec);
4899: