APPS.GMI_AUTO_ALLOCATE_PUB dependencies on IC_ITEM_MST

Line 63: l_ic_item_mst_rec ic_item_mst%ROWTYPE;

59: l_return_status VARCHAR2(1);
60: l_allocation_rec gmi_allocation_rec;
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:

Line 116: x_ic_item_mst_rec => l_ic_item_mst_rec,

112: oe_debug_pub.add('OPM allocation engine validate input parms',1);
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,

Line 141: p_lot_ctl => l_ic_item_mst_rec.lot_ctl,

137: oe_debug_pub.add('OPM allocation engine check for existing txns',1);
138: /*IF GMI_ALLOCATE_INVENTORY_PVT.CHECK_EXISTING_ALLOCATIONS
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);

Line 142: p_item_loct_ctl => l_ic_item_mst_rec.loct_ctl,

138: /*IF GMI_ALLOCATE_INVENTORY_PVT.CHECK_EXISTING_ALLOCATIONS
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');

Line 147: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);

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);
148: FND_MSG_PUB.Add;
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;*/
151:

Line 157: ( p_alloc_class => l_ic_item_mst_rec.alloc_class,

153: ==========================================================*/
154: oe_debug_pub.add('OPM allocation main - about to fetch allocation parms',1);
155: -- HW BUG#:2643440 chaged l_allocation_rec to ll_allocation_rec
156: GMI_ALLOCATION_RULES_PVT.GET_ALLOCATION_PARMS
157: ( p_alloc_class => l_ic_item_mst_rec.alloc_class,
158: p_org_id => ll_allocation_rec.org_id,
159: p_of_cust_id => ll_allocation_rec.of_cust_id,
160: p_ship_to_org_id=> ll_allocation_rec.ship_to_org_id,
161: x_return_status => l_return_status,

Line 173: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);

169: --B1655007 Update exception handling
170: If (l_return_status = FND_API.G_RET_STS_ERROR)
171: THEN
172: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS'); /* NEW */
173: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
174: FND_MSG_PUB.Add;
175: RAISE FND_API.G_EXC_ERROR;
176: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
177: THEN

Line 207: p_ic_item_mst => l_ic_item_mst_rec,

203: oe_debug_pub.add('OPM allocation engine - now allocate the line',1);
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,