DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on CSD_LOGISTICS_UTIL

Line 2362: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

2358: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2359: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2360: l_tmp_char VARCHAR2(1); --R12 Development Changes
2361: /* R12 SN reservations integration change Begin */
2362: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
2363: l_auto_reserve_profile VARCHAR2(10);
2364: l_srl_reservation_id NUMBER;
2365: l_serial_rsv_rec CSD_LOGISTICS_UTIL.CSD_SERIAL_RESERVE_REC_TYPE ;
2366: /* R12 SN reservations integration change End */

Line 2365: l_serial_rsv_rec CSD_LOGISTICS_UTIL.CSD_SERIAL_RESERVE_REC_TYPE ;

2361: /* R12 SN reservations integration change Begin */
2362: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
2363: l_auto_reserve_profile VARCHAR2(10);
2364: l_srl_reservation_id NUMBER;
2365: l_serial_rsv_rec CSD_LOGISTICS_UTIL.CSD_SERIAL_RESERVE_REC_TYPE ;
2366: /* R12 SN reservations integration change End */
2367:
2368: -- swai bug 7572247/7628204: cursor to default account address for SR account
2369: CURSOR c_sr_primary_account_address(p_incident_id NUMBER, p_site_use_type VARCHAR2)

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

3554: l_order_rec.PICK_FROM_SUBINVENTORY := x_product_txn_rec.sub_inventory;
3555: END IF;
3556: /* R12 SN reservations change Begin */
3557: -- Get Item attributes in local variable
3558: CSD_LOGISTICS_UTIL.Get_ItemAttributes(p_Inventory_Item_Id => x_Product_Txn_Rec.Inventory_Item_Id,
3559: p_inv_org_id => x_Product_Txn_Rec.inventory_org_id,
3560: x_ItemAttributes => l_ItemAttributes);
3561: -- Get the default pick rule id
3562: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE', l_auto_reserve_profile);

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

3598: l_serial_rsv_rec.subinventory_code := x_Product_Txn_Rec.sub_inventory;
3599: l_serial_rsv_rec.reservation_uom_code := x_Product_Txn_Rec.Unit_Of_Measure_Code;
3600:
3601: Debug('Calling reserve serial..', l_mod_name, 1);
3602: CSD_LOGISTICS_UTIL.Reserve_serial_number(l_serial_rsv_rec, x_return_status);
3603:
3604: if(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3605: Fnd_Message.SET_NAME('CSD', 'CSD_SRL_RESERVE_FAILED');
3606: Fnd_Msg_Pub.ADD;

Line 4575: l_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;

4571: l_msg_data VARCHAR2(2000);
4572: l_msg_index NUMBER;
4573: l_return_status VARCHAR2(1);
4574: l_estimate_Rec Cs_Charge_Details_Pub.charges_rec_type;
4575: l_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;
4576: l_order_Rec Csd_Process_Pvt.om_interface_rec;
4577: l_est_detail_id NUMBER;
4578: l_add_to_order_id NUMBER;
4579: l_add_to_order_flag VARCHAR2(1);

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

4619: Fnd_Msg_Pub.initialize;
4620: END IF;
4621:
4622:
4623: l_prodtxn_db_attr := Csd_Logistics_Util.get_prodtxn_db_attr(x_product_txn_rec.product_transaction_id);
4624:
4625: -- Debug message
4626: -----------------------------------------------------------------------------
4627: /*********************************************************************

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

4624:
4625: -- Debug message
4626: -----------------------------------------------------------------------------
4627: /*********************************************************************
4628: /* Code here got moved to CSD_LOGISTICS_UTIL.upd_prodtxn_n_chrgline
4629: **********************************************************************/
4630: -----------------------------------------------------------------------------
4631: Csd_Logistics_Util.upd_prodtxn_n_chrgline(x_product_txn_rec ,
4632: l_prodtxn_db_attr,

Line 4631: Csd_Logistics_Util.upd_prodtxn_n_chrgline(x_product_txn_rec ,

4627: /*********************************************************************
4628: /* Code here got moved to CSD_LOGISTICS_UTIL.upd_prodtxn_n_chrgline
4629: **********************************************************************/
4630: -----------------------------------------------------------------------------
4631: Csd_Logistics_Util.upd_prodtxn_n_chrgline(x_product_txn_rec ,
4632: l_prodtxn_db_attr,
4633: l_est_detail_id,
4634: l_repair_line_id,
4635: l_add_to_order_flag,

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

4671: -- Define savepoint
4672: SAVEPOINT create_sales_order;
4673:
4674: /*******************************************************************
4675: Code here has been moved to CSD_LOGISTICS_UTIL.interface_prodtxn
4676: ********************************************************************/
4677:
4678: l_order_Rec := Csd_Logistics_Util.get_order_rec(x_product_txn_rec.repair_line_id);
4679:

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

4674: /*******************************************************************
4675: Code here has been moved to CSD_LOGISTICS_UTIL.interface_prodtxn
4676: ********************************************************************/
4677:
4678: l_order_Rec := Csd_Logistics_Util.get_order_rec(x_product_txn_rec.repair_line_id);
4679:
4680: --bug#6071005
4681: if (x_product_txn_rec.order_line_id is not null) THEN
4682: l_order_Rec.order_line_id := x_product_txn_rec.order_line_id;

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

4693: l_order_Rec.party_id := x_product_txn_rec.bill_to_party_id;
4694: l_order_Rec.account_id := x_product_txn_rec.bill_to_account_id;
4695: END IF;
4696:
4697: Csd_Logistics_Util.interface_prodtxn( x_return_status => l_return_status,
4698: p_product_txn_rec => x_product_txn_rec,
4699: p_prodtxn_db_attr => l_prodtxn_db_attr,
4700: px_order_rec => l_order_rec);
4701:

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

4710: SAVEPOINT book_sales_order;
4711: /***************************************************
4712: Code here has been moved to the api book_prodtxn
4713: ****************************************************/
4714: Csd_Logistics_Util.book_prodtxn( x_return_status => l_return_status,
4715: p_product_txn_rec => x_product_txn_rec,
4716: p_prodtxn_db_attr => l_prodtxn_db_attr,
4717: px_order_rec => l_order_rec);
4718: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

4728: THEN
4729: -- Define savepoint
4730: SAVEPOINT release_sales_order;
4731: /*******************************************************************
4732: Code here has been moved to CSD_LOGISTICS_UTIL.pickrelease_prodtxn
4733: ********************************************************************/
4734: Csd_Logistics_Util.pickrelease_prodtxn(x_return_status => l_return_status,
4735: p_product_txn_rec => x_product_txn_rec,
4736: p_prodtxn_db_attr => l_prodtxn_db_attr,

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

4730: SAVEPOINT release_sales_order;
4731: /*******************************************************************
4732: Code here has been moved to CSD_LOGISTICS_UTIL.pickrelease_prodtxn
4733: ********************************************************************/
4734: Csd_Logistics_Util.pickrelease_prodtxn(x_return_status => l_return_status,
4735: p_product_txn_rec => x_product_txn_rec,
4736: p_prodtxn_db_attr => l_prodtxn_db_attr,
4737: px_order_rec => l_order_rec);
4738: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

4746: THEN
4747: -- Define savepoint
4748: SAVEPOINT ship_sales_order;
4749: /*******************************************************************
4750: Code here has been moved to CSD_LOGISTICS_UTIL.ship_prodtxn
4751: ********************************************************************/
4752: Csd_Logistics_Util.ship_prodtxn( x_return_status => l_return_status,
4753: p_product_txn_rec => x_product_txn_rec,
4754: p_prodtxn_db_attr => l_prodtxn_db_attr,

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

4748: SAVEPOINT ship_sales_order;
4749: /*******************************************************************
4750: Code here has been moved to CSD_LOGISTICS_UTIL.ship_prodtxn
4751: ********************************************************************/
4752: Csd_Logistics_Util.ship_prodtxn( x_return_status => l_return_status,
4753: p_product_txn_rec => x_product_txn_rec,
4754: p_prodtxn_db_attr => l_prodtxn_db_attr,
4755: px_order_rec => l_order_rec);
4756: