DBA Data[Home] [Help]

APPS.GMI_AUTO_ALLOCATE_PUB dependencies on IC_WHSE_MST

Line 65: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;

61: -- HW BUG#:2643440 Need to change out parameter name
62: ll_allocation_rec gmi_allocation_rec;
63: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
64: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
65: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
66: l_op_alot_prm_rec op_alot_prm%ROWTYPE;
67:
68:
69: /* B1731567 - identify co_code associated with whse and orgn_code

Line 74: WHERE orgn_code = l_ic_whse_mst_rec.orgn_code;

70: ================================================================*/
71: CURSOR sy_orgn_mst_c1 is
72: SELECT co_code
73: FROM sy_orgn_mst
74: WHERE orgn_code = l_ic_whse_mst_rec.orgn_code;
75:
76:
77: BEGIN
78:

Line 117: x_ic_whse_mst_rec => l_ic_whse_mst_rec,

113: -- HW BUG#: 2643440 pass ll_allocation_rec as out
114: GMI_VALIDATE_ALLOCATION_PVT.VALIDATE_INPUT_PARMS
115: (p_allocation_rec => l_allocation_rec,
116: x_ic_item_mst_rec => l_ic_item_mst_rec,
117: x_ic_whse_mst_rec => l_ic_whse_mst_rec,
118: x_allocation_rec => ll_allocation_rec,
119: x_return_status => l_return_status,
120: x_msg_count => l_msg_count,
121: x_msg_data => l_msg_data);

Line 143: p_whse_loct_ctl => l_ic_whse_mst_rec.loct_ctl )

139: (p_doc_id => l_allocation_rec.doc_id,
140: p_line_id => l_allocation_rec.line_id,
141: p_lot_ctl => l_ic_item_mst_rec.lot_ctl,
142: p_item_loct_ctl => l_ic_item_mst_rec.loct_ctl,
143: p_whse_loct_ctl => l_ic_whse_mst_rec.loct_ctl )
144: THEN
145: oe_debug_pub.add('OPM allocation exit because allocations exist',1);
146: FND_MESSAGE.SET_NAME('GML','GML_CANNOT_AUTO_ALLOC');
147: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);

Line 194: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_ic_whse_mst_rec.orgn_code);

190: IF (sy_orgn_mst_c1%NOTFOUND)
191: THEN
192: CLOSE sy_orgn_mst_c1;
193: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
194: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_ic_whse_mst_rec.orgn_code);
195: FND_MSG_PUB.Add;
196: RAISE FND_API.G_EXC_ERROR;
197: ELSE
198: CLOSE sy_orgn_mst_c1;

Line 208: p_ic_whse_mst => l_ic_whse_mst_rec,

204: -- HW BUG#:2643440 Use ll_allocation_rec instead of l_allocation_rec
205: GMI_ALLOCATE_INVENTORY_PVT.ALLOCATE_LINE
206: ( p_allocation_rec => ll_allocation_rec,
207: p_ic_item_mst => l_ic_item_mst_rec,
208: p_ic_whse_mst => l_ic_whse_mst_rec,
209: p_op_alot_prm => l_op_alot_prm_rec,
210: x_allocated_qty1 => l_allocated_qty1,
211: x_allocated_qty2 => l_allocated_qty2,
212: x_return_status => l_return_status,