eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_RESERVATION_UTIL dependencies on FND_MESSAGE

Line 133: FND_MESSAGE.Set_Name('GMI','MISSING');

129: OR p_rec_to_check.organization_id = 0
130: OR p_rec_to_check.organization_id = FND_API.G_MISS_NUM )
131: THEN
132: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, organization_id missing ');
133: FND_MESSAGE.Set_Name('GMI','MISSING');
134: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');
135: FND_MSG_PUB.Add;
136: raise FND_API.G_EXC_ERROR;
137: END IF;

Line 134: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');

130: OR p_rec_to_check.organization_id = FND_API.G_MISS_NUM )
131: THEN
132: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, organization_id missing ');
133: FND_MESSAGE.Set_Name('GMI','MISSING');
134: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');
135: FND_MSG_PUB.Add;
136: raise FND_API.G_EXC_ERROR;
137: END IF;
138:

Line 146: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

142: OR p_rec_to_check.demand_source_header_id = 0
143: OR p_rec_to_check.demand_source_header_id = FND_API.G_MISS_NUM )
144: THEN
145: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, demand_source_header_id missing ');
146: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
147: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');
148: FND_MSG_PUB.Add;
149: raise FND_API.G_EXC_ERROR;
150: END IF;

Line 147: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');

143: OR p_rec_to_check.demand_source_header_id = FND_API.G_MISS_NUM )
144: THEN
145: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, demand_source_header_id missing ');
146: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
147: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');
148: FND_MSG_PUB.Add;
149: raise FND_API.G_EXC_ERROR;
150: END IF;
151: */

Line 159: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

155: OR p_rec_to_check.demand_source_line_id = 0
156: OR p_rec_to_check.demand_source_line_id = FND_API.G_MISS_NUM )
157: THEN
158: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, demand_source_line_id missing ');
159: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
160: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');
161: FND_MSG_PUB.Add;
162: raise FND_API.G_EXC_ERROR;
163: END IF;

Line 160: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');

156: OR p_rec_to_check.demand_source_line_id = FND_API.G_MISS_NUM )
157: THEN
158: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, demand_source_line_id missing ');
159: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
160: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');
161: FND_MSG_PUB.Add;
162: raise FND_API.G_EXC_ERROR;
163: END IF;
164: ELSIF p_event = 'CREATE' THEN

Line 183: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

179: IF ( p_rec_to_check.organization_id IS NULL
180: OR p_rec_to_check.organization_id = 0
181: OR p_rec_to_check.organization_id = FND_API.G_MISS_NUM )
182: THEN
183: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
184: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');
185: FND_MSG_PUB.Add;
186: raise FND_API.G_EXC_ERROR;
187: END IF;

Line 184: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');

180: OR p_rec_to_check.organization_id = 0
181: OR p_rec_to_check.organization_id = FND_API.G_MISS_NUM )
182: THEN
183: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
184: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');
185: FND_MSG_PUB.Add;
186: raise FND_API.G_EXC_ERROR;
187: END IF;
188:

Line 196: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

192: IF ( p_rec_to_check.demand_source_header_id IS NULL
193: OR p_rec_to_check.demand_source_header_id = 0
194: OR p_rec_to_check.demand_source_header_id = FND_API.G_MISS_NUM )
195: THEN
196: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
197: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');
198: FND_MSG_PUB.Add;
199: raise FND_API.G_EXC_ERROR;
200: END IF;

Line 197: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');

193: OR p_rec_to_check.demand_source_header_id = 0
194: OR p_rec_to_check.demand_source_header_id = FND_API.G_MISS_NUM )
195: THEN
196: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
197: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');
198: FND_MSG_PUB.Add;
199: raise FND_API.G_EXC_ERROR;
200: END IF;
201: */

Line 209: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

205: IF ( p_rec_to_check.demand_source_line_id IS NULL
206: OR p_rec_to_check.demand_source_line_id = 0
207: OR p_rec_to_check.demand_source_line_id = FND_API.G_MISS_NUM )
208: THEN
209: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
210: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');
211: FND_MSG_PUB.Add;
212: raise FND_API.G_EXC_ERROR;
213: END IF;

Line 210: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');

206: OR p_rec_to_check.demand_source_line_id = 0
207: OR p_rec_to_check.demand_source_line_id = FND_API.G_MISS_NUM )
208: THEN
209: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
210: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');
211: FND_MSG_PUB.Add;
212: raise FND_API.G_EXC_ERROR;
213: END IF;
214:

Line 220: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

216: IF ( p_rec_to_check.demand_source_type_id IS NULL
217: OR p_rec_to_check.demand_source_type_id = 0
218: OR p_rec_to_check.demand_source_type_id = FND_API.G_MISS_NUM )
219: THEN
220: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
221: FND_MESSAGE.Set_Token('MISSING', 'demand_source_type_id');
222: FND_MSG_PUB.Add;
223: raise FND_API.G_EXC_ERROR;
224: END IF;

Line 221: FND_MESSAGE.Set_Token('MISSING', 'demand_source_type_id');

217: OR p_rec_to_check.demand_source_type_id = 0
218: OR p_rec_to_check.demand_source_type_id = FND_API.G_MISS_NUM )
219: THEN
220: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
221: FND_MESSAGE.Set_Token('MISSING', 'demand_source_type_id');
222: FND_MSG_PUB.Add;
223: raise FND_API.G_EXC_ERROR;
224: END IF;
225:

Line 231: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

227: IF ( p_rec_to_check.inventory_item_id IS NULL
228: OR p_rec_to_check.inventory_item_id = 0
229: OR p_rec_to_check.inventory_item_id = FND_API.G_MISS_NUM )
230: THEN
231: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
232: FND_MESSAGE.Set_Token('MISSING', 'inventory_item_id');
233: FND_MSG_PUB.Add;
234: raise FND_API.G_EXC_ERROR;
235: END IF;

Line 232: FND_MESSAGE.Set_Token('MISSING', 'inventory_item_id');

228: OR p_rec_to_check.inventory_item_id = 0
229: OR p_rec_to_check.inventory_item_id = FND_API.G_MISS_NUM )
230: THEN
231: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
232: FND_MESSAGE.Set_Token('MISSING', 'inventory_item_id');
233: FND_MSG_PUB.Add;
234: raise FND_API.G_EXC_ERROR;
235: END IF;
236:

Line 241: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

237: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check reservation_uom_code ');
238: IF ( p_rec_to_check.reservation_uom_code IS NULL
239: OR p_rec_to_check.reservation_uom_code = FND_API.G_MISS_CHAR )
240: THEN
241: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
242: FND_MESSAGE.Set_Token('MISSING', 'reservation_uom_code');
243: FND_MSG_PUB.Add;
244: raise FND_API.G_EXC_ERROR;
245: END IF;

Line 242: FND_MESSAGE.Set_Token('MISSING', 'reservation_uom_code');

238: IF ( p_rec_to_check.reservation_uom_code IS NULL
239: OR p_rec_to_check.reservation_uom_code = FND_API.G_MISS_CHAR )
240: THEN
241: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
242: FND_MESSAGE.Set_Token('MISSING', 'reservation_uom_code');
243: FND_MSG_PUB.Add;
244: raise FND_API.G_EXC_ERROR;
245: END IF;
246:

Line 252: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

248: IF ( p_rec_to_check.reservation_quantity IS NULL
249: OR p_rec_to_check.reservation_quantity = 0
250: OR p_rec_to_check.reservation_quantity = FND_API.G_MISS_NUM )
251: THEN
252: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
253: FND_MESSAGE.Set_Token('MISSING', 'reservation_quantity');
254: FND_MSG_PUB.Add;
255: raise FND_API.G_EXC_ERROR;
256: END IF;

Line 253: FND_MESSAGE.Set_Token('MISSING', 'reservation_quantity');

249: OR p_rec_to_check.reservation_quantity = 0
250: OR p_rec_to_check.reservation_quantity = FND_API.G_MISS_NUM )
251: THEN
252: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
253: FND_MESSAGE.Set_Token('MISSING', 'reservation_quantity');
254: FND_MSG_PUB.Add;
255: raise FND_API.G_EXC_ERROR;
256: END IF;
257:

Line 262: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

258: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check requirement_date ');
259: IF ( p_rec_to_check.requirement_date IS NULL
260: OR p_rec_to_check.requirement_date = FND_API.G_MISS_DATE )
261: THEN
262: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
263: FND_MESSAGE.Set_Token('MISSING', 'requirement_date');
264: FND_MSG_PUB.Add;
265: raise FND_API.G_EXC_ERROR;
266: END IF;

Line 263: FND_MESSAGE.Set_Token('MISSING', 'requirement_date');

259: IF ( p_rec_to_check.requirement_date IS NULL
260: OR p_rec_to_check.requirement_date = FND_API.G_MISS_DATE )
261: THEN
262: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
263: FND_MESSAGE.Set_Token('MISSING', 'requirement_date');
264: FND_MSG_PUB.Add;
265: raise FND_API.G_EXC_ERROR;
266: END IF;
267: END IF;

Line 348: /* FND_MESSAGE.Set_Name('GMI','SO_Not_Found'); */

344: /* Don't raise any error here, because no reservation has been created for that line (anyway) */
345: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: om_line_id=NOTFOUND='
346: ||p_query_input.demand_source_line_id||'.');
347: /* ================================================================*/
348: /* FND_MESSAGE.Set_Name('GMI','SO_Not_Found'); */
349: /* FND_MESSAGE.Set_Token('LINE_ID', p_query_input.demand_source_line_id); */
350: /* FND_MSG_PUB.Add; */
351: /* RAISE FND_API.G_EXC_ERROR; */
352: ELSE

Line 349: /* FND_MESSAGE.Set_Token('LINE_ID', p_query_input.demand_source_line_id); */

345: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: om_line_id=NOTFOUND='
346: ||p_query_input.demand_source_line_id||'.');
347: /* ================================================================*/
348: /* FND_MESSAGE.Set_Name('GMI','SO_Not_Found'); */
349: /* FND_MESSAGE.Set_Token('LINE_ID', p_query_input.demand_source_line_id); */
350: /* FND_MSG_PUB.Add; */
351: /* RAISE FND_API.G_EXC_ERROR; */
352: ELSE
353: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: inv_item_id='||l_inventory_item_id||'.');

Line 369: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

365: , x_msg_count => x_msg_count
366: , x_msg_data => x_msg_data);
367:
368: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
369: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
370: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_query_input.organization_id);
371: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
372: FND_MSG_PUB.Add;
373: CLOSE c_sales_order; -- Bug 3598280

Line 370: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_query_input.organization_id);

366: , x_msg_data => x_msg_data);
367:
368: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
369: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
370: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_query_input.organization_id);
371: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
372: FND_MSG_PUB.Add;
373: CLOSE c_sales_order; -- Bug 3598280
374: raise FND_API.G_EXC_ERROR;

Line 371: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);

367:
368: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
369: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
370: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_query_input.organization_id);
371: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
372: FND_MSG_PUB.Add;
373: CLOSE c_sales_order; -- Bug 3598280
374: raise FND_API.G_EXC_ERROR;
375: END IF;

Line 394: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

390:
391:
392: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
393: THEN
394: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
395: FND_MESSAGE.Set_Token('APPS_UOM_CODE', l_order_quantity_uom);
396: FND_MSG_PUB.Add;
397: CLOSE c_sales_order; -- Bug 3598280
398: RAISE FND_API.G_EXC_ERROR;

Line 395: FND_MESSAGE.Set_Token('APPS_UOM_CODE', l_order_quantity_uom);

391:
392: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
393: THEN
394: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
395: FND_MESSAGE.Set_Token('APPS_UOM_CODE', l_order_quantity_uom);
396: FND_MSG_PUB.Add;
397: CLOSE c_sales_order; -- Bug 3598280
398: RAISE FND_API.G_EXC_ERROR;
399: ELSE

Line 670: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

666: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
667: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
668: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
669: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
670: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
671: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
672: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
673: FND_MSG_PUB.Add;
674: raise FND_API.G_EXC_ERROR;

Line 671: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

667: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
668: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
669: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
670: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
671: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
672: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
673: FND_MSG_PUB.Add;
674: raise FND_API.G_EXC_ERROR;
675: END IF;

Line 672: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');

668: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
669: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
670: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
671: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
672: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
673: FND_MSG_PUB.Add;
674: raise FND_API.G_EXC_ERROR;
675: END IF;
676: ELSE

Line 703: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

699: THEN
700: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Default_Lot:
701: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
702: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
703: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
704: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
705: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;

Line 704: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

700: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Default_Lot:
701: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
702: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
703: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
704: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
705: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;

Line 705: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');

701: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
702: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
703: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
704: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
705: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:

Line 826: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');

822: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
823: THEN
824: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Validation_Before_Allocate
825: ERROR:Returned by Get_Process_Org.');
826: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
827: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;

Line 827: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);

823: THEN
824: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Validation_Before_Allocate
825: ERROR:Returned by Get_Process_Org.');
826: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
827: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:

Line 852: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

848: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
849: THEN
850: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Validation_Before_Allocate
851: ERROR:Returned by Get_OPM_item_from_Apps.');
852: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
853: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
854: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_mtl_rsv_rec.inventory_item_id);
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;

Line 853: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);

849: THEN
850: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Validation_Before_Allocate
851: ERROR:Returned by Get_OPM_item_from_Apps.');
852: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
853: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
854: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_mtl_rsv_rec.inventory_item_id);
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: ELSE

Line 854: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_mtl_rsv_rec.inventory_item_id);

850: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Validation_Before_Allocate
851: ERROR:Returned by Get_OPM_item_from_Apps.');
852: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
853: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
854: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_mtl_rsv_rec.inventory_item_id);
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: ELSE
858: x_allocation_rec.item_no := x_ic_item_mst_rec.item_no;

Line 881: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');

877:
878: IF (c_customer_and_so_info%NOTFOUND) THEN
879: CLOSE c_customer_and_so_info;
880: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: cust_no=NOTFOUND');
881: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');
882: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
883: FND_MSG_PUB.Add;
884: RAISE FND_API.G_EXC_ERROR;
885: ELSE

Line 882: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);

878: IF (c_customer_and_so_info%NOTFOUND) THEN
879: CLOSE c_customer_and_so_info;
880: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: cust_no=NOTFOUND');
881: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');
882: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
883: FND_MSG_PUB.Add;
884: RAISE FND_API.G_EXC_ERROR;
885: ELSE
886: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: cust_no='||x_allocation_rec.cust_no||',

Line 911: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

907:
908:
909: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
910: THEN
911: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
912: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_mtl_rsv_rec.reservation_uom_code);
913: FND_MSG_PUB.Add;
914: RAISE FND_API.G_EXC_ERROR;
915: ELSE

Line 912: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_mtl_rsv_rec.reservation_uom_code);

908:
909: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
910: THEN
911: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
912: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_mtl_rsv_rec.reservation_uom_code);
913: FND_MSG_PUB.Add;
914: RAISE FND_API.G_EXC_ERROR;
915: ELSE
916: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: uom1='||x_allocation_rec.order_um1||'.');

Line 1125: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

1121: FETCH c_uom
1122: INTO x_OPM_UOM;
1123:
1124: IF c_uom%NOTFOUND THEN
1125: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1126: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_Apps_UOM);
1127: FND_MSG_PUB.Add;
1128: CLOSE c_uom; -- Bug 3598280
1129: RAISE FND_API.G_EXC_ERROR;

Line 1126: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_Apps_UOM);

1122: INTO x_OPM_UOM;
1123:
1124: IF c_uom%NOTFOUND THEN
1125: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1126: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_Apps_UOM);
1127: FND_MSG_PUB.Add;
1128: CLOSE c_uom; -- Bug 3598280
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;

Line 1202: FND_MESSAGE.Set_Name('GMI','GMI_APPS_UOM_NOT_FOUND');

1198: FETCH c_uom
1199: INTO x_Apps_UOM;
1200:
1201: IF c_uom%NOTFOUND THEN
1202: FND_MESSAGE.Set_Name('GMI','GMI_APPS_UOM_NOT_FOUND');
1203: FND_MESSAGE.Set_Token('OPM_UOM_CODE', p_OPM_UOM);
1204: FND_MSG_PUB.Add;
1205: CLOSE c_uom; -- Bug 3598280
1206: RAISE FND_API.G_EXC_ERROR;

Line 1203: FND_MESSAGE.Set_Token('OPM_UOM_CODE', p_OPM_UOM);

1199: INTO x_Apps_UOM;
1200:
1201: IF c_uom%NOTFOUND THEN
1202: FND_MESSAGE.Set_Name('GMI','GMI_APPS_UOM_NOT_FOUND');
1203: FND_MESSAGE.Set_Token('OPM_UOM_CODE', p_OPM_UOM);
1204: FND_MSG_PUB.Add;
1205: CLOSE c_uom; -- Bug 3598280
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

Line 1264: FND_MESSAGE.Set_Name('GMI','GMI_ORG_NOT_FOUND_IN_OE');

1260: FETCH c_org
1261: INTO x_organization_id;
1262:
1263: IF c_org%NOTFOUND THEN
1264: FND_MESSAGE.Set_Name('GMI','GMI_ORG_NOT_FOUND_IN_OE');
1265: FND_MESSAGE.Set_Token('SO_LINE_ID', p_oe_line_id);
1266: FND_MSG_PUB.Add;
1267: CLOSE c_org; -- Bug 3598280
1268: RAISE FND_API.G_EXC_ERROR;

Line 1265: FND_MESSAGE.Set_Token('SO_LINE_ID', p_oe_line_id);

1261: INTO x_organization_id;
1262:
1263: IF c_org%NOTFOUND THEN
1264: FND_MESSAGE.Set_Name('GMI','GMI_ORG_NOT_FOUND_IN_OE');
1265: FND_MESSAGE.Set_Token('SO_LINE_ID', p_oe_line_id);
1266: FND_MSG_PUB.Add;
1267: CLOSE c_org; -- Bug 3598280
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;

Line 1350: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

1346:
1347: IF c_item%NOTFOUND THEN
1348: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: item_no=NOTFOUND inv_item_id='
1349: ||p_inventory_item_id||', org_id='||p_organization_id);
1350: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1351: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1352: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1353: FND_MSG_PUB.Add;
1354: CLOSE c_item; -- Bug 3598280

Line 1351: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

1347: IF c_item%NOTFOUND THEN
1348: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: item_no=NOTFOUND inv_item_id='
1349: ||p_inventory_item_id||', org_id='||p_organization_id);
1350: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1351: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1352: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1353: FND_MSG_PUB.Add;
1354: CLOSE c_item; -- Bug 3598280
1355: RAISE FND_API.G_EXC_ERROR;

Line 1352: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

1348: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: item_no=NOTFOUND inv_item_id='
1349: ||p_inventory_item_id||', org_id='||p_organization_id);
1350: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1351: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1352: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1353: FND_MSG_PUB.Add;
1354: CLOSE c_item; -- Bug 3598280
1355: RAISE FND_API.G_EXC_ERROR;
1356: ELSE

Line 1469: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');

1465: IF (c_sales_order_line%NOTFOUND)
1466: THEN
1467: GMI_Reservation_Util.printLn('Query SO_line failed with so_line_id='||p_query_input.demand_source_line_id);
1468:
1469: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
1470: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1471: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1472: FND_MSG_PUB.Add;
1473: CLOSE c_sales_order_line; -- Bug 3598280

Line 1470: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);

1466: THEN
1467: GMI_Reservation_Util.printLn('Query SO_line failed with so_line_id='||p_query_input.demand_source_line_id);
1468:
1469: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
1470: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1471: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1472: FND_MSG_PUB.Add;
1473: CLOSE c_sales_order_line; -- Bug 3598280
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1471: FND_MESSAGE.Set_Token('WHERE', l_api_name);

1467: GMI_Reservation_Util.printLn('Query SO_line failed with so_line_id='||p_query_input.demand_source_line_id);
1468:
1469: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
1470: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1471: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1472: FND_MSG_PUB.Add;
1473: CLOSE c_sales_order_line; -- Bug 3598280
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475: END IF;

Line 1580: FND_MESSAGE.Set_Name('GMI','GMI_QRY_RSV_FAILED');

1576: /* Return an error if the query reservations call failed */
1577: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1578: THEN
1579: GMI_Reservation_Util.printLn('return error from query reservation');
1580: FND_MESSAGE.Set_Name('GMI','GMI_QRY_RSV_FAILED');
1581: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1582: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1583: FND_MSG_PUB.Add;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1581: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);

1577: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1578: THEN
1579: GMI_Reservation_Util.printLn('return error from query reservation');
1580: FND_MESSAGE.Set_Name('GMI','GMI_QRY_RSV_FAILED');
1581: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1582: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1583: FND_MSG_PUB.Add;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;

Line 1582: FND_MESSAGE.Set_Token('WHERE', l_api_name);

1578: THEN
1579: GMI_Reservation_Util.printLn('return error from query reservation');
1580: FND_MESSAGE.Set_Name('GMI','GMI_QRY_RSV_FAILED');
1581: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1582: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1583: FND_MSG_PUB.Add;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;
1586:

Line 1593: FND_MESSAGE.Set_Name('INV','INV_INVALID_COUNT');

1589: THEN
1590: IF (l_reservation_count < 0)
1591: THEN
1592: GMI_Reservation_Util.printLn('Invalid value for reservation_count='||l_reservation_count);
1593: FND_MESSAGE.Set_Name('INV','INV_INVALID_COUNT');
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1596: END IF;
1597:

Line 1629: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

1625: , x_msg_data => x_msg_data);
1626: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1627: THEN
1628: GMI_reservation_Util.PrintLn('(opm_dbg) in Reallocate, ERROR:Returned by Get_Default_Lot.');
1629: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1630: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1631: FND_MESSAGE.Set_Token('WHERE','Reallocate');
1632: FND_MSG_PUB.Add;
1633: RAISE FND_API.G_EXC_ERROR;

Line 1630: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');

1626: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1627: THEN
1628: GMI_reservation_Util.PrintLn('(opm_dbg) in Reallocate, ERROR:Returned by Get_Default_Lot.');
1629: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1630: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1631: FND_MESSAGE.Set_Token('WHERE','Reallocate');
1632: FND_MSG_PUB.Add;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;

Line 1631: FND_MESSAGE.Set_Token('WHERE','Reallocate');

1627: THEN
1628: GMI_reservation_Util.PrintLn('(opm_dbg) in Reallocate, ERROR:Returned by Get_Default_Lot.');
1629: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1630: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1631: FND_MESSAGE.Set_Token('WHERE','Reallocate');
1632: FND_MSG_PUB.Add;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:

Line 1770: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

1766:
1767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1768: THEN
1769: GMI_reservation_Util.PrintLn('(opm_dbg) in Get_DefaultLot_from_ItemCtl, ERROR:Returned by Get_Default_Lot.');
1770: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1771: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1772: FND_MESSAGE.Set_Token('WHERE','Get_DefaultLot_from_ItemCtl');
1773: FND_MSG_PUB.Add;
1774: RAISE FND_API.G_EXC_ERROR;

Line 1771: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');

1767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1768: THEN
1769: GMI_reservation_Util.PrintLn('(opm_dbg) in Get_DefaultLot_from_ItemCtl, ERROR:Returned by Get_Default_Lot.');
1770: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1771: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1772: FND_MESSAGE.Set_Token('WHERE','Get_DefaultLot_from_ItemCtl');
1773: FND_MSG_PUB.Add;
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;

Line 1772: FND_MESSAGE.Set_Token('WHERE','Get_DefaultLot_from_ItemCtl');

1768: THEN
1769: GMI_reservation_Util.PrintLn('(opm_dbg) in Get_DefaultLot_from_ItemCtl, ERROR:Returned by Get_Default_Lot.');
1770: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1771: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1772: FND_MESSAGE.Set_Token('WHERE','Get_DefaultLot_from_ItemCtl');
1773: FND_MSG_PUB.Add;
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;
1776:

Line 1794: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

1790:
1791: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1792: THEN
1793: GMI_Reservation_Util.printLn('(opm_dbg) in end of Get_DefaultLot_from_ItemCtl ERROR:Returned by Get_OPM_item_from_Apps.');
1794: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1795: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1796: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1797: FND_MSG_PUB.Add;
1798: RAISE FND_API.G_EXC_ERROR;

Line 1795: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

1791: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1792: THEN
1793: GMI_Reservation_Util.printLn('(opm_dbg) in end of Get_DefaultLot_from_ItemCtl ERROR:Returned by Get_OPM_item_from_Apps.');
1794: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1795: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1796: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1797: FND_MSG_PUB.Add;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;

Line 1796: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

1792: THEN
1793: GMI_Reservation_Util.printLn('(opm_dbg) in end of Get_DefaultLot_from_ItemCtl ERROR:Returned by Get_OPM_item_from_Apps.');
1794: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1795: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1796: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1797: FND_MSG_PUB.Add;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:

Line 2002: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

1998: OR p_ic_tran_rec.trans_id = FND_API.G_MISS_NUM)
1999: THEN
2000: x_ic_tran_rec.trans_id := 0;
2001: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Set trans_id=0 ', 'pick_lots.log');
2002: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2003: FND_MESSAGE.Set_Token('MISSING', 'trans_id');
2004: FND_MSG_PUB.Add;
2005: /* raise FND_API.G_EXC_ERROR; */
2006: END IF;

Line 2003: FND_MESSAGE.Set_Token('MISSING', 'trans_id');

1999: THEN
2000: x_ic_tran_rec.trans_id := 0;
2001: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Set trans_id=0 ', 'pick_lots.log');
2002: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2003: FND_MESSAGE.Set_Token('MISSING', 'trans_id');
2004: FND_MSG_PUB.Add;
2005: /* raise FND_API.G_EXC_ERROR; */
2006: END IF;
2007:

Line 2013: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2009: IF ( p_ic_tran_rec.item_id = 0
2010: OR p_ic_tran_rec.item_id IS NULL
2011: OR p_ic_tran_rec.item_id = FND_API.G_MISS_NUM)
2012: THEN
2013: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2014: FND_MESSAGE.Set_Token('MISSING', 'item_id');
2015: FND_MSG_PUB.Add;
2016: /* raise FND_API.G_EXC_ERROR; */
2017: END IF;

Line 2014: FND_MESSAGE.Set_Token('MISSING', 'item_id');

2010: OR p_ic_tran_rec.item_id IS NULL
2011: OR p_ic_tran_rec.item_id = FND_API.G_MISS_NUM)
2012: THEN
2013: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2014: FND_MESSAGE.Set_Token('MISSING', 'item_id');
2015: FND_MSG_PUB.Add;
2016: /* raise FND_API.G_EXC_ERROR; */
2017: END IF;
2018:

Line 2024: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2020: IF ( p_ic_tran_rec.line_id = 0
2021: OR p_ic_tran_rec.line_id IS NULL
2022: OR p_ic_tran_rec.line_id = FND_API.G_MISS_NUM)
2023: THEN
2024: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2025: FND_MESSAGE.Set_Token('MISSING', 'line_id');
2026: FND_MSG_PUB.Add;
2027: /* raise FND_API.G_EXC_ERROR; */
2028: END IF;

Line 2025: FND_MESSAGE.Set_Token('MISSING', 'line_id');

2021: OR p_ic_tran_rec.line_id IS NULL
2022: OR p_ic_tran_rec.line_id = FND_API.G_MISS_NUM)
2023: THEN
2024: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2025: FND_MESSAGE.Set_Token('MISSING', 'line_id');
2026: FND_MSG_PUB.Add;
2027: /* raise FND_API.G_EXC_ERROR; */
2028: END IF;
2029:

Line 2035: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2031: IF ( p_ic_tran_rec.whse_code = ''
2032: OR p_ic_tran_rec.whse_code IS NULL
2033: OR p_ic_tran_rec.whse_code = FND_API.G_MISS_CHAR)
2034: THEN
2035: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2036: FND_MESSAGE.Set_Token('MISSING', 'whse_code');
2037: FND_MSG_PUB.Add;
2038: raise FND_API.G_EXC_ERROR;
2039: END IF;

Line 2036: FND_MESSAGE.Set_Token('MISSING', 'whse_code');

2032: OR p_ic_tran_rec.whse_code IS NULL
2033: OR p_ic_tran_rec.whse_code = FND_API.G_MISS_CHAR)
2034: THEN
2035: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2036: FND_MESSAGE.Set_Token('MISSING', 'whse_code');
2037: FND_MSG_PUB.Add;
2038: raise FND_API.G_EXC_ERROR;
2039: END IF;
2040:

Line 2057: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2053: x_ic_tran_rec.orgn_code;
2054:
2055: IF (Get_Orgn_Co_from_Whse%NOTFOUND)
2056: THEN
2057: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2058: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');
2059: FND_MSG_PUB.Add;
2060: CLOSE Get_Orgn_Co_from_Whse;
2061: raise FND_API.G_EXC_ERROR;

Line 2058: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');

2054:
2055: IF (Get_Orgn_Co_from_Whse%NOTFOUND)
2056: THEN
2057: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2058: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');
2059: FND_MSG_PUB.Add;
2060: CLOSE Get_Orgn_Co_from_Whse;
2061: raise FND_API.G_EXC_ERROR;
2062: END IF;

Line 2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2061: raise FND_API.G_EXC_ERROR;
2062: END IF;
2063: CLOSE Get_Orgn_Co_from_Whse;
2064:
2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2066: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');
2067: FND_MSG_PUB.Add;
2068: /* raise FND_API.G_EXC_ERROR; */
2069: END IF;

Line 2066: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');

2062: END IF;
2063: CLOSE Get_Orgn_Co_from_Whse;
2064:
2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2066: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');
2067: FND_MSG_PUB.Add;
2068: /* raise FND_API.G_EXC_ERROR; */
2069: END IF;
2070:

Line 2077: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2073: IF ( p_ic_tran_rec.lot_id = 0
2074: OR p_ic_tran_rec.lot_id IS NULL
2075: OR p_ic_tran_rec.lot_id = FND_API.G_MISS_NUM)
2076: THEN
2077: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2078: FND_MESSAGE.Set_Token('MISSING', 'lot_id');
2079: FND_MSG_PUB.Add;
2080: /* raise FND_API.G_EXC_ERROR; */
2081: END IF;

Line 2078: FND_MESSAGE.Set_Token('MISSING', 'lot_id');

2074: OR p_ic_tran_rec.lot_id IS NULL
2075: OR p_ic_tran_rec.lot_id = FND_API.G_MISS_NUM)
2076: THEN
2077: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2078: FND_MESSAGE.Set_Token('MISSING', 'lot_id');
2079: FND_MSG_PUB.Add;
2080: /* raise FND_API.G_EXC_ERROR; */
2081: END IF;
2082:

Line 2088: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2084: IF ( p_ic_tran_rec.location = ''
2085: OR p_ic_tran_rec.location IS NULL
2086: OR p_ic_tran_rec.location = FND_API.G_MISS_CHAR)
2087: THEN
2088: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2089: FND_MESSAGE.Set_Token('MISSING', 'location');
2090: FND_MSG_PUB.Add;
2091: /* raise FND_API.G_EXC_ERROR; */
2092: END IF;

Line 2089: FND_MESSAGE.Set_Token('MISSING', 'location');

2085: OR p_ic_tran_rec.location IS NULL
2086: OR p_ic_tran_rec.location = FND_API.G_MISS_CHAR)
2087: THEN
2088: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2089: FND_MESSAGE.Set_Token('MISSING', 'location');
2090: FND_MSG_PUB.Add;
2091: /* raise FND_API.G_EXC_ERROR; */
2092: END IF;
2093:

Line 2099: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2095: IF ( p_ic_tran_rec.doc_id = 0
2096: OR p_ic_tran_rec.doc_id IS NULL
2097: OR p_ic_tran_rec.doc_id = FND_API.G_MISS_NUM)
2098: THEN
2099: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2100: FND_MESSAGE.Set_Token('MISSING', 'doc_id');
2101: FND_MSG_PUB.Add;
2102: /* raise FND_API.G_EXC_ERROR; */
2103: END IF;

Line 2100: FND_MESSAGE.Set_Token('MISSING', 'doc_id');

2096: OR p_ic_tran_rec.doc_id IS NULL
2097: OR p_ic_tran_rec.doc_id = FND_API.G_MISS_NUM)
2098: THEN
2099: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2100: FND_MESSAGE.Set_Token('MISSING', 'doc_id');
2101: FND_MSG_PUB.Add;
2102: /* raise FND_API.G_EXC_ERROR; */
2103: END IF;
2104:

Line 2110: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2106: IF ( p_ic_tran_rec.doc_type = ''
2107: OR p_ic_tran_rec.doc_type IS NULL
2108: OR p_ic_tran_rec.doc_type = FND_API.G_MISS_CHAR)
2109: THEN
2110: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2111: FND_MESSAGE.Set_Token('MISSING', 'doc_type');
2112: FND_MSG_PUB.Add;
2113: /* raise FND_API.G_EXC_ERROR; */
2114: END IF;

Line 2111: FND_MESSAGE.Set_Token('MISSING', 'doc_type');

2107: OR p_ic_tran_rec.doc_type IS NULL
2108: OR p_ic_tran_rec.doc_type = FND_API.G_MISS_CHAR)
2109: THEN
2110: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2111: FND_MESSAGE.Set_Token('MISSING', 'doc_type');
2112: FND_MSG_PUB.Add;
2113: /* raise FND_API.G_EXC_ERROR; */
2114: END IF;
2115:

Line 2121: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2117: IF ( p_ic_tran_rec.doc_line = 0
2118: OR p_ic_tran_rec.doc_line IS NULL
2119: OR p_ic_tran_rec.doc_line = FND_API.G_MISS_NUM)
2120: THEN
2121: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2122: FND_MESSAGE.Set_Token('MISSING', 'doc_line');
2123: FND_MSG_PUB.Add;
2124: /* raise FND_API.G_EXC_ERROR; */
2125: END IF;

Line 2122: FND_MESSAGE.Set_Token('MISSING', 'doc_line');

2118: OR p_ic_tran_rec.doc_line IS NULL
2119: OR p_ic_tran_rec.doc_line = FND_API.G_MISS_NUM)
2120: THEN
2121: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2122: FND_MESSAGE.Set_Token('MISSING', 'doc_line');
2123: FND_MSG_PUB.Add;
2124: /* raise FND_API.G_EXC_ERROR; */
2125: END IF;
2126:

Line 2132: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2128: IF ( p_ic_tran_rec.line_type = 0
2129: OR p_ic_tran_rec.line_type IS NULL
2130: OR p_ic_tran_rec.line_type = FND_API.G_MISS_NUM)
2131: THEN
2132: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2133: FND_MESSAGE.Set_Token('MISSING', 'line_type');
2134: FND_MSG_PUB.Add;
2135: /* raise FND_API.G_EXC_ERROR; */
2136: END IF;

Line 2133: FND_MESSAGE.Set_Token('MISSING', 'line_type');

2129: OR p_ic_tran_rec.line_type IS NULL
2130: OR p_ic_tran_rec.line_type = FND_API.G_MISS_NUM)
2131: THEN
2132: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2133: FND_MESSAGE.Set_Token('MISSING', 'line_type');
2134: FND_MSG_PUB.Add;
2135: /* raise FND_API.G_EXC_ERROR; */
2136: END IF;
2137:

Line 2143: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2139: IF ( p_ic_tran_rec.trans_qty = 0
2140: OR p_ic_tran_rec.trans_qty IS NULL
2141: OR p_ic_tran_rec.trans_qty = FND_API.G_MISS_NUM)
2142: THEN
2143: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2144: FND_MESSAGE.Set_Token('MISSING', 'trans_qty');
2145: FND_MSG_PUB.Add;
2146: /* raise FND_API.G_EXC_ERROR; */
2147: END IF;

Line 2144: FND_MESSAGE.Set_Token('MISSING', 'trans_qty');

2140: OR p_ic_tran_rec.trans_qty IS NULL
2141: OR p_ic_tran_rec.trans_qty = FND_API.G_MISS_NUM)
2142: THEN
2143: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2144: FND_MESSAGE.Set_Token('MISSING', 'trans_qty');
2145: FND_MSG_PUB.Add;
2146: /* raise FND_API.G_EXC_ERROR; */
2147: END IF;
2148:

Line 2154: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2150: IF ( p_ic_tran_rec.trans_qty2 = 0
2151: OR p_ic_tran_rec.trans_qty2 IS NULL
2152: OR p_ic_tran_rec.trans_qty2 = FND_API.G_MISS_NUM)
2153: THEN
2154: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2155: FND_MESSAGE.Set_Token('MISSING', 'trans_qty2');
2156: FND_MSG_PUB.Add;
2157: /* raise FND_API.G_EXC_ERROR; */
2158: END IF;

Line 2155: FND_MESSAGE.Set_Token('MISSING', 'trans_qty2');

2151: OR p_ic_tran_rec.trans_qty2 IS NULL
2152: OR p_ic_tran_rec.trans_qty2 = FND_API.G_MISS_NUM)
2153: THEN
2154: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2155: FND_MESSAGE.Set_Token('MISSING', 'trans_qty2');
2156: FND_MSG_PUB.Add;
2157: /* raise FND_API.G_EXC_ERROR; */
2158: END IF;
2159:

Line 2165: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2161: IF ( p_ic_tran_rec.trans_um = ''
2162: OR p_ic_tran_rec.trans_um IS NULL
2163: OR p_ic_tran_rec.trans_um = FND_API.G_MISS_CHAR)
2164: THEN
2165: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2166: FND_MESSAGE.Set_Token('MISSING', 'trans_um');
2167: FND_MSG_PUB.Add;
2168: /* raise FND_API.G_EXC_ERROR; */
2169: END IF;

Line 2166: FND_MESSAGE.Set_Token('MISSING', 'trans_um');

2162: OR p_ic_tran_rec.trans_um IS NULL
2163: OR p_ic_tran_rec.trans_um = FND_API.G_MISS_CHAR)
2164: THEN
2165: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2166: FND_MESSAGE.Set_Token('MISSING', 'trans_um');
2167: FND_MSG_PUB.Add;
2168: /* raise FND_API.G_EXC_ERROR; */
2169: END IF;
2170:

Line 2176: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2172: IF ( p_ic_tran_rec.trans_um2 = ''
2173: OR p_ic_tran_rec.trans_um2 IS NULL
2174: OR p_ic_tran_rec.trans_um2 = FND_API.G_MISS_CHAR)
2175: THEN
2176: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2177: FND_MESSAGE.Set_Token('MISSING', 'trans_um2');
2178: FND_MSG_PUB.Add;
2179: /* raise FND_API.G_EXC_ERROR; */
2180: END IF;

Line 2177: FND_MESSAGE.Set_Token('MISSING', 'trans_um2');

2173: OR p_ic_tran_rec.trans_um2 IS NULL
2174: OR p_ic_tran_rec.trans_um2 = FND_API.G_MISS_CHAR)
2175: THEN
2176: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2177: FND_MESSAGE.Set_Token('MISSING', 'trans_um2');
2178: FND_MSG_PUB.Add;
2179: /* raise FND_API.G_EXC_ERROR; */
2180: END IF;
2181:

Line 2187: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');

2183: IF ( p_ic_tran_rec.trans_date IS NULL
2184: OR p_ic_tran_rec.trans_date = FND_API.G_MISS_DATE)
2185: THEN
2186: /* x_ic_tran_rec.trans_date := sysdate; */
2187: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2188: FND_MESSAGE.Set_Token('MISSING', 'trans_date');
2189: FND_MSG_PUB.Add;
2190: /* raise FND_API.G_EXC_ERROR; */
2191: END IF;

Line 2188: FND_MESSAGE.Set_Token('MISSING', 'trans_date');

2184: OR p_ic_tran_rec.trans_date = FND_API.G_MISS_DATE)
2185: THEN
2186: /* x_ic_tran_rec.trans_date := sysdate; */
2187: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2188: FND_MESSAGE.Set_Token('MISSING', 'trans_date');
2189: FND_MSG_PUB.Add;
2190: /* raise FND_API.G_EXC_ERROR; */
2191: END IF;
2192:

Line 2405: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2401:
2402: IF (NVL(ll_ic_tran_rec.line_id, 0) <= 0)
2403: THEN
2404: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2405: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2406: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2407: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;

Line 2406: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');

2402: IF (NVL(ll_ic_tran_rec.line_id, 0) <= 0)
2403: THEN
2404: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2405: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2406: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2407: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: ELSE

Line 2407: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2403: THEN
2404: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2405: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2406: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2407: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: ELSE
2411: /* ================================================================ */

Line 2429: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');

2425: IF (c_sales_order_info%NOTFOUND)
2426: THEN
2427: CLOSE c_sales_order_info;
2428: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2429: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2430: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2431: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2432: FND_MSG_PUB.Add;
2433: RAISE FND_API.G_EXC_ERROR;

Line 2430: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2426: THEN
2427: CLOSE c_sales_order_info;
2428: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2429: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2430: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2431: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2432: FND_MSG_PUB.Add;
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSE

Line 2431: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);

2427: CLOSE c_sales_order_info;
2428: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2429: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2430: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2431: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2432: FND_MSG_PUB.Add;
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSE
2435: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots FOUND: line_id='||ll_ic_tran_rec.line_id||'.', 'pick_lots.log');

Line 2463: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');

2459: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2460: OR (l_whse_code <> ll_ic_tran_rec.whse_code)
2461: THEN
2462: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Set_Pick_Lots ERROR:Returned by Get_Process_Org.');
2463: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
2464: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2465: FND_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;

Line 2464: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);

2460: OR (l_whse_code <> ll_ic_tran_rec.whse_code)
2461: THEN
2462: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Set_Pick_Lots ERROR:Returned by Get_Process_Org.');
2463: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
2464: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2465: FND_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468:

Line 2483: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

2479: , x_msg_count => x_msg_count
2480: , x_msg_data => x_msg_data);
2481:
2482: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2483: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2484: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2485: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2486: FND_MSG_PUB.Add;
2487: raise FND_API.G_EXC_ERROR;

Line 2484: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);

2480: , x_msg_data => x_msg_data);
2481:
2482: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2483: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2484: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2485: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2486: FND_MSG_PUB.Add;
2487: raise FND_API.G_EXC_ERROR;
2488: END IF;

Line 2485: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);

2481:
2482: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2483: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2484: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2485: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2486: FND_MSG_PUB.Add;
2487: raise FND_API.G_EXC_ERROR;
2488: END IF;
2489:

Line 2519: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');

2515: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR
2516: (l_op_alot_prm_rec.delete_mark = 1))
2517: THEN
2518: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2519: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2520: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
2521: FND_MSG_PUB.Add;
2522: RAISE FND_API.G_EXC_ERROR;
2523: END IF;

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

2516: (l_op_alot_prm_rec.delete_mark = 1))
2517: THEN
2518: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2519: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2520: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
2521: FND_MSG_PUB.Add;
2522: RAISE FND_API.G_EXC_ERROR;
2523: END IF;
2524:

Line 2534: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');

2530: THEN
2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2534: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2535: FND_MSG_PUB.Add;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538:

Line 2622: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2618: , x_msg_data => x_msg_data);
2619:
2620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2621: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2622: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2623: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2624: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;

Line 2623: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');

2619:
2620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2621: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2622: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2623: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2624: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;

Line 2624: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2621: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2622: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2623: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2624: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;
2628: l_need_update_default_lot := FALSE;

Line 2641: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');

2637: /* There may have been a problem getting the rows */
2638: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2639: THEN
2640: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2641: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2642: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2643: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2644: FND_MSG_PUB.ADD;
2645: RAISE FND_API.G_EXC_ERROR;

Line 2642: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2638: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2639: THEN
2640: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2641: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2642: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2643: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2644: FND_MSG_PUB.ADD;
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;

Line 2643: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);

2639: THEN
2640: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2641: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2642: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2643: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2644: FND_MSG_PUB.ADD;
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;
2647:

Line 2661: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2657: , x_msg_data => x_msg_data);
2658:
2659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2660: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2661: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2662: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2663: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2664: FND_MSG_PUB.ADD;
2665: RAISE FND_API.G_EXC_ERROR;

Line 2662: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');

2658:
2659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2660: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2661: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2662: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2663: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2664: FND_MSG_PUB.ADD;
2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;

Line 2663: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2660: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2661: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2662: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2663: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2664: FND_MSG_PUB.ADD;
2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;
2667:

Line 2681: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

2677: );
2678:
2679: IF (l_lock_status = FALSE) THEN
2680: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2681: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2682: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2683: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2684: FND_MSG_PUB.Add;
2685: RAISE FND_API.G_EXC_ERROR;

Line 2682: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');

2678:
2679: IF (l_lock_status = FALSE) THEN
2680: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2681: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2682: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2683: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2684: FND_MSG_PUB.Add;
2685: RAISE FND_API.G_EXC_ERROR;
2686: END IF;

Line 2683: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2679: IF (l_lock_status = FALSE) THEN
2680: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2681: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2682: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2683: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2684: FND_MSG_PUB.Add;
2685: RAISE FND_API.G_EXC_ERROR;
2686: END IF;
2687: */

Line 2705: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2701: , x_msg_data => x_msg_data);
2702:
2703: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2704: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2705: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2706: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2707: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2708: FND_MSG_PUB.ADD;
2709: RAISE FND_API.G_EXC_ERROR;

Line 2706: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');

2702:
2703: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2704: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2705: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2706: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2707: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2708: FND_MSG_PUB.ADD;
2709: RAISE FND_API.G_EXC_ERROR;
2710: END IF;

Line 2707: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2703: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2704: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2705: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2706: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2707: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2708: FND_MSG_PUB.ADD;
2709: RAISE FND_API.G_EXC_ERROR;
2710: END IF;
2711: l_need_update_default_lot := FALSE;

Line 2752: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2748: ,x_msg_data => x_msg_data);
2749:
2750: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2751: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2752: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2753: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2754: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;

Line 2753: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');

2749:
2750: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2751: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2752: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2753: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2754: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;

Line 2754: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2750: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2751: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2752: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2753: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2754: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;
2758:

Line 2780: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2776: ,x_msg_data => x_msg_data);
2777:
2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2780: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2781: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2782: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2783: FND_MSG_PUB.ADD;
2784: RAISE FND_API.G_EXC_ERROR;

Line 2781: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');

2777:
2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2780: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2781: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2782: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2783: FND_MSG_PUB.ADD;
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;

Line 2782: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2780: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2781: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2782: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2783: FND_MSG_PUB.ADD;
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786:

Line 2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2846: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2847: THEN
2848: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2849: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2853: FND_MSG_PUB.Add;
2854: RAISE FND_API.G_EXC_ERROR;

Line 2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2847: THEN
2848: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2849: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2853: FND_MSG_PUB.Add;
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;

Line 2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2848: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2849: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2853: FND_MSG_PUB.Add;
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;
2856: ELSE

Line 2888: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2884:
2885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2886: THEN
2887: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2888: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2889: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2890: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2891: FND_MSG_PUB.Add;
2892: RAISE FND_API.G_EXC_ERROR;

Line 2889: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');

2885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2886: THEN
2887: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2888: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2889: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2890: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2891: FND_MSG_PUB.Add;
2892: RAISE FND_API.G_EXC_ERROR;
2893: END IF;

Line 2890: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2886: THEN
2887: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2888: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2889: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2890: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2891: FND_MSG_PUB.Add;
2892: RAISE FND_API.G_EXC_ERROR;
2893: END IF;
2894:

Line 2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2944: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2945: THEN
2946: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2947: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2951: FND_MSG_PUB.Add;
2952: RAISE FND_API.G_EXC_ERROR;

Line 2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2945: THEN
2946: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2947: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2951: FND_MSG_PUB.Add;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;

Line 2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2946: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2947: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2951: FND_MSG_PUB.Add;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;
2954:

Line 2964: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

2960:
2961: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2962: THEN
2963: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2964: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2965: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2966: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2967: FND_MSG_PUB.Add;
2968: RAISE FND_API.G_EXC_ERROR;

Line 2965: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');

2961: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2962: THEN
2963: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2964: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2965: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2966: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2967: FND_MSG_PUB.Add;
2968: RAISE FND_API.G_EXC_ERROR;
2969: END IF;

Line 2966: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

2962: THEN
2963: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2964: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2965: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2966: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2967: FND_MSG_PUB.Add;
2968: RAISE FND_API.G_EXC_ERROR;
2969: END IF;
2970:

Line 3092: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');

3088: WHEN FND_API.G_EXC_ERROR THEN
3089: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3090:
3091: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3092: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3093: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3094: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3093: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

3089: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3090:
3091: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3092: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3093: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3094: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_ERROR;
3097:

Line 3094: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');

3090:
3091: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3092: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3093: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3094: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_ERROR;
3097:
3098: /* Get message count and data */

Line 3108: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');

3104: WHEN locked_by_other_user
3105: THEN
3106: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3107: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3108: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3109: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3110: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3111: FND_MSG_PUB.Add;
3112: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3109: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

3105: THEN
3106: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3107: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3108: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3109: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3110: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3111: FND_MSG_PUB.Add;
3112: x_return_status := FND_API.G_RET_STS_ERROR;
3113:

Line 3110: FND_MESSAGE.Set_Token('WHAT', 'LockError');

3106: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3107: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3108: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3109: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3110: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3111: FND_MSG_PUB.Add;
3112: x_return_status := FND_API.G_RET_STS_ERROR;
3113:
3114: WHEN OTHERS THEN

Line 3340: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

3336: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3337: THEN
3338: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3339: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3340: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3342: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3343: FND_MSG_PUB.Add;
3344: RAISE FND_API.G_EXC_ERROR;

Line 3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');

3337: THEN
3338: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3339: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3340: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3342: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3343: FND_MSG_PUB.Add;
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;

Line 3342: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');

3338: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3339: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3340: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3342: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3343: FND_MSG_PUB.Add;
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346:

Line 3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

3365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3366: THEN
3367: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3368: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3372: FND_MSG_PUB.Add;
3373: RAISE FND_API.G_EXC_ERROR;

Line 3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

3366: THEN
3367: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3368: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3372: FND_MSG_PUB.Add;
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;

Line 3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3367: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3368: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3372: FND_MSG_PUB.Add;
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375: /* cancel all the reservations for GME */

Line 3402: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

3398: );
3399: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3400: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3401: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3402: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3403: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3404: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3405: FND_MSG_PUB.Add;
3406: RAISE FND_API.G_EXC_ERROR;

Line 3403: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

3399: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3400: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3401: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3402: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3403: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3404: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3405: FND_MSG_PUB.Add;
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;

Line 3404: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

3400: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3401: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3402: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3403: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3404: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3405: FND_MSG_PUB.Add;
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;
3408: END IF;

Line 3482: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

3478: );
3479:
3480: IF (l_lock_status = FALSE) THEN
3481: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3482: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3483: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3484: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3485: FND_MSG_PUB.Add;
3486: RAISE FND_API.G_EXC_ERROR;

Line 3483: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');

3479:
3480: IF (l_lock_status = FALSE) THEN
3481: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3482: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3483: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3484: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3485: FND_MSG_PUB.Add;
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;

Line 3484: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3480: IF (l_lock_status = FALSE) THEN
3481: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3482: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3483: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3484: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3485: FND_MSG_PUB.Add;
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;
3488:

Line 3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

3555: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3556: THEN
3557: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3558: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3562: FND_MSG_PUB.Add;
3563: RAISE FND_API.G_EXC_ERROR;

Line 3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

3556: THEN
3557: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3558: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3562: FND_MSG_PUB.Add;
3563: RAISE FND_API.G_EXC_ERROR;
3564: END IF;

Line 3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3557: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3558: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3562: FND_MSG_PUB.Add;
3563: RAISE FND_API.G_EXC_ERROR;
3564: END IF;
3565: ELSE

Line 3600: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');

3596: /* There may not be any rows, and it should be possible ! (if not auto-allocate before) */
3597: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)
3598: THEN
3599: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3600: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3601: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3602: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3603: FND_MSG_PUB.ADD;
3604: RAISE FND_API.G_EXC_ERROR;

Line 3601: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3597: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)
3598: THEN
3599: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3600: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3601: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3602: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3603: FND_MSG_PUB.ADD;
3604: RAISE FND_API.G_EXC_ERROR;
3605: END IF;

Line 3602: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);

3598: THEN
3599: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3600: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3601: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3602: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3603: FND_MSG_PUB.ADD;
3604: RAISE FND_API.G_EXC_ERROR;
3605: END IF;
3606:

Line 3611: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');

3607: /* There may have been a problem getting the rows */
3608: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3609: THEN
3610: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3611: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3612: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3613: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;

Line 3612: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3608: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3609: THEN
3610: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3611: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3612: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3613: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;

Line 3613: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);

3609: THEN
3610: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3611: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3612: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3613: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;
3617:

Line 3627: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

3623: , x_msg_data => x_msg_data);
3624:
3625: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3626: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3627: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3628: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3629: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3630: FND_MSG_PUB.ADD;
3631: RAISE FND_API.G_EXC_ERROR;

Line 3628: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');

3624:
3625: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3626: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3627: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3628: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3629: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3630: FND_MSG_PUB.ADD;
3631: RAISE FND_API.G_EXC_ERROR;
3632: END IF;

Line 3629: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3625: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3626: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3627: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3628: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3629: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3630: FND_MSG_PUB.ADD;
3631: RAISE FND_API.G_EXC_ERROR;
3632: END IF;
3633:

Line 3638: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

3634: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: default_lot_index='||x_default_lot_index, 'pick_lots.log');
3635: IF (x_default_lot_index=0)
3636: THEN
3637: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3638: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3639: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3641: FND_MSG_PUB.ADD;
3642: RAISE FND_API.G_EXC_ERROR;

Line 3639: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');

3635: IF (x_default_lot_index=0)
3636: THEN
3637: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3638: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3639: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3641: FND_MSG_PUB.ADD;
3642: RAISE FND_API.G_EXC_ERROR;
3643: END IF;

Line 3640: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3636: THEN
3637: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3638: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3639: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3641: FND_MSG_PUB.ADD;
3642: RAISE FND_API.G_EXC_ERROR;
3643: END IF;
3644:

Line 3650: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');

3646: WHEN FND_API.G_EXC_ERROR THEN
3647: ROLLBACK TO SAVEPOINT Empty_Default_lot;
3648:
3649: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3650: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3651: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3652: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3653: FND_MSG_PUB.Add;
3654: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3651: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3647: ROLLBACK TO SAVEPOINT Empty_Default_lot;
3648:
3649: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3650: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3651: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3652: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3653: FND_MSG_PUB.Add;
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655:

Line 3652: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');

3648:
3649: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3650: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3651: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3652: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3653: FND_MSG_PUB.Add;
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655:
3656: /* Get message count and data */

Line 3726: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');

3722:
3723: EXCEPTION
3724: WHEN FND_API.G_EXC_ERROR THEN
3725: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3726: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3727: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3728: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3729: FND_MSG_PUB.Add;
3730: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3727: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');

3723: EXCEPTION
3724: WHEN FND_API.G_EXC_ERROR THEN
3725: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3726: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3727: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3728: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3729: FND_MSG_PUB.Add;
3730: x_return_status := FND_API.G_RET_STS_ERROR;
3731:

Line 3728: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');

3724: WHEN FND_API.G_EXC_ERROR THEN
3725: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3726: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3727: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3728: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3729: FND_MSG_PUB.Add;
3730: x_return_status := FND_API.G_RET_STS_ERROR;
3731:
3732: /* Get message count and data */

Line 3874: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

3870: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3871: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
3872: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3873: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3874: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3875: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3876: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3877: FND_MSG_PUB.Add;
3878: raise FND_API.G_EXC_ERROR;

Line 3875: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

3871: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
3872: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3873: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3874: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3875: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3876: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3877: FND_MSG_PUB.Add;
3878: raise FND_API.G_EXC_ERROR;
3879: END IF;

Line 3876: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');

3872: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3873: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3874: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3875: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3876: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3877: FND_MSG_PUB.Add;
3878: raise FND_API.G_EXC_ERROR;
3879: END IF;
3880: END create_dflt_lot_from_scratch;

Line 4161: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

4157: GMI_reservation_Util.PrintLn('(opm_dbg) Error in creating transaction for receiving');
4158: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4159: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4160: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4161: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4162: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4163: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4164: FND_MSG_PUB.Add;
4165: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4162: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

4158: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4159: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4160: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4161: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4162: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4163: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4164: FND_MSG_PUB.Add;
4165: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4166: END IF;

Line 4163: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');

4159: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4160: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4161: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4162: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4163: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4164: FND_MSG_PUB.Add;
4165: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4166: END IF;
4167:

Line 4191: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

4187:
4188: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
4189: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4190: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4191: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4193: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4194: FND_MSG_PUB.Add;
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');

4188: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
4189: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4190: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4191: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4193: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4194: FND_MSG_PUB.Add;
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4196: END IF;

Line 4193: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');

4189: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4190: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4191: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4193: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4194: FND_MSG_PUB.Add;
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4196: END IF;
4197:

Line 4442: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

4438: x_return_status =>l_return_status,
4439: x_msg_count =>l_msg_count,
4440: x_msg_data =>l_msg_data);
4441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4442: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4443: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
4444: FND_MSG_PUB.Add;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;

Line 4443: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);

4439: x_msg_count =>l_msg_count,
4440: x_msg_data =>l_msg_data);
4441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4442: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4443: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
4444: FND_MSG_PUB.Add;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;
4447: GMI_reservation_Util.PrintLn('from uom (OPM) '||l_opm_from_uom);

Line 4455: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');

4451: x_return_status =>l_return_status,
4452: x_msg_count =>l_msg_count,
4453: x_msg_data =>l_msg_data);
4454: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4455: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4456: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);
4457: FND_MSG_PUB.Add;
4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;

Line 4456: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);

4452: x_msg_count =>l_msg_count,
4453: x_msg_data =>l_msg_data);
4454: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4455: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4456: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);
4457: FND_MSG_PUB.Add;
4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;
4460: GMI_reservation_Util.PrintLn('to uom (OPM) '||l_opm_to_uom);

Line 4471: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');

4467: pnew_uom =>l_opm_to_uom,
4468: onew_qty =>l_converted_qty);
4469: IF l_converted_qty < 0 THEN
4470: GMI_reservation_Util.PrintLn('conversion error code'|| l_converted_qty);
4471: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');
4472: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);
4473: FND_MSG_PUB.Add;
4474: RAISE FND_API.G_EXC_ERROR;
4475: END IF;

Line 4472: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);

4468: onew_qty =>l_converted_qty);
4469: IF l_converted_qty < 0 THEN
4470: GMI_reservation_Util.PrintLn('conversion error code'|| l_converted_qty);
4471: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');
4472: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);
4473: FND_MSG_PUB.Add;
4474: RAISE FND_API.G_EXC_ERROR;
4475: END IF;
4476:

Line 4785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

4781: GMI_reservation_Util.PrintLn('(opm_dbg) Error in creating default transaction ');
4782: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4783: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4784: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4786: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4787: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4788: FND_MSG_PUB.Add;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4786: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

4782: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4783: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4784: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4786: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4787: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4788: FND_MSG_PUB.Add;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: END IF;

Line 4787: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');

4783: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4784: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4786: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4787: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4788: FND_MSG_PUB.Add;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: END IF;
4791: END IF;

Line 4849: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

4845: GMI_reservation_Util.PrintLn('(opm_dbg) Error in creating transaction ');
4846: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4847: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4848: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4849: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4850: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4851: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4852: FND_MSG_PUB.Add;
4853:

Line 4850: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

4846: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4847: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4848: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4849: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4850: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4851: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4852: FND_MSG_PUB.Add;
4853:
4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4851: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');

4847: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4848: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4849: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4850: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4851: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4852: FND_MSG_PUB.Add;
4853:
4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4855: END IF;

Line 5047: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

5043: GMI_reservation_Util.PrintLn('(opm_dbg) Error in updating transaction ');
5044: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
5045: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5046: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5047: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5049: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5050: FND_MSG_PUB.Add;
5051: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');

5044: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
5045: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5046: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5047: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5049: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5050: FND_MSG_PUB.Add;
5051: x_return_status := FND_API.G_RET_STS_ERROR;
5052: RETURN;

Line 5049: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');

5045: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5046: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5047: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5049: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5050: FND_MSG_PUB.Add;
5051: x_return_status := FND_API.G_RET_STS_ERROR;
5052: RETURN;
5053: END IF; -- of update

Line 5401: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

5397: , x_msg_count => x_msg_count
5398: , x_msg_data => x_msg_data);
5399:
5400: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5401: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5402: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5403: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5404: FND_MSG_PUB.Add;
5405: raise FND_API.G_EXC_ERROR;

Line 5402: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

5398: , x_msg_data => x_msg_data);
5399:
5400: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5401: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5402: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5403: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5404: FND_MSG_PUB.Add;
5405: raise FND_API.G_EXC_ERROR;
5406: END IF;

Line 5403: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

5399:
5400: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5401: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5402: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5403: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5404: FND_MSG_PUB.Add;
5405: raise FND_API.G_EXC_ERROR;
5406: END IF;
5407:

Line 5556: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');

5552: , x_msg_data => x_msg_data);
5553: gmi_reservation_util.println('BaCK FROM Get_OPM_item_from_Apps IN validate_opm_quantities');
5554:
5555: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5556: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5557: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5558: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5559: FND_MSG_PUB.Add;
5560: x_check_status := 0;

Line 5557: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

5553: gmi_reservation_util.println('BaCK FROM Get_OPM_item_from_Apps IN validate_opm_quantities');
5554:
5555: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5556: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5557: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5558: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5559: FND_MSG_PUB.Add;
5560: x_check_status := 0;
5561: raise FND_API.G_EXC_ERROR;

Line 5558: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

5554:
5555: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5556: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5557: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5558: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5559: FND_MSG_PUB.Add;
5560: x_check_status := 0;
5561: raise FND_API.G_EXC_ERROR;
5562: END IF;