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 129: FND_MESSAGE.Set_Name('GMI','MISSING');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1986: OR p_ic_tran_rec.trans_id = FND_API.G_MISS_NUM)
1987: THEN
1988: x_ic_tran_rec.trans_id := 0;
1989: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Set trans_id=0 ', 'pick_lots.log');
1990: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
1991: FND_MESSAGE.Set_Token('MISSING', 'trans_id');
1992: FND_MSG_PUB.Add;
1993: /* raise FND_API.G_EXC_ERROR; */
1994: END IF;

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

1987: THEN
1988: x_ic_tran_rec.trans_id := 0;
1989: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Set trans_id=0 ', 'pick_lots.log');
1990: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
1991: FND_MESSAGE.Set_Token('MISSING', 'trans_id');
1992: FND_MSG_PUB.Add;
1993: /* raise FND_API.G_EXC_ERROR; */
1994: END IF;
1995:

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

1997: IF ( p_ic_tran_rec.item_id = 0
1998: OR p_ic_tran_rec.item_id IS NULL
1999: OR p_ic_tran_rec.item_id = FND_API.G_MISS_NUM)
2000: THEN
2001: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2002: FND_MESSAGE.Set_Token('MISSING', 'item_id');
2003: FND_MSG_PUB.Add;
2004: /* raise FND_API.G_EXC_ERROR; */
2005: END IF;

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

1998: OR p_ic_tran_rec.item_id IS NULL
1999: OR p_ic_tran_rec.item_id = FND_API.G_MISS_NUM)
2000: THEN
2001: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2002: FND_MESSAGE.Set_Token('MISSING', 'item_id');
2003: FND_MSG_PUB.Add;
2004: /* raise FND_API.G_EXC_ERROR; */
2005: END IF;
2006:

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

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

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

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

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

2019: IF ( p_ic_tran_rec.whse_code = ''
2020: OR p_ic_tran_rec.whse_code IS NULL
2021: OR p_ic_tran_rec.whse_code = FND_API.G_MISS_CHAR)
2022: THEN
2023: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2024: FND_MESSAGE.Set_Token('MISSING', 'whse_code');
2025: FND_MSG_PUB.Add;
2026: raise FND_API.G_EXC_ERROR;
2027: END IF;

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

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

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

2041: x_ic_tran_rec.orgn_code;
2042:
2043: IF (Get_Orgn_Co_from_Whse%NOTFOUND)
2044: THEN
2045: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2046: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');
2047: FND_MSG_PUB.Add;
2048: CLOSE Get_Orgn_Co_from_Whse;
2049: raise FND_API.G_EXC_ERROR;

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

2042:
2043: IF (Get_Orgn_Co_from_Whse%NOTFOUND)
2044: THEN
2045: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2046: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');
2047: FND_MSG_PUB.Add;
2048: CLOSE Get_Orgn_Co_from_Whse;
2049: raise FND_API.G_EXC_ERROR;
2050: END IF;

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

2049: raise FND_API.G_EXC_ERROR;
2050: END IF;
2051: CLOSE Get_Orgn_Co_from_Whse;
2052:
2053: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2054: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');
2055: FND_MSG_PUB.Add;
2056: /* raise FND_API.G_EXC_ERROR; */
2057: END IF;

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

2050: END IF;
2051: CLOSE Get_Orgn_Co_from_Whse;
2052:
2053: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2054: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');
2055: FND_MSG_PUB.Add;
2056: /* raise FND_API.G_EXC_ERROR; */
2057: END IF;
2058:

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

2061: IF ( p_ic_tran_rec.lot_id = 0
2062: OR p_ic_tran_rec.lot_id IS NULL
2063: OR p_ic_tran_rec.lot_id = FND_API.G_MISS_NUM)
2064: THEN
2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2066: FND_MESSAGE.Set_Token('MISSING', 'lot_id');
2067: FND_MSG_PUB.Add;
2068: /* raise FND_API.G_EXC_ERROR; */
2069: END IF;

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

2062: OR p_ic_tran_rec.lot_id IS NULL
2063: OR p_ic_tran_rec.lot_id = FND_API.G_MISS_NUM)
2064: THEN
2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2066: FND_MESSAGE.Set_Token('MISSING', 'lot_id');
2067: FND_MSG_PUB.Add;
2068: /* raise FND_API.G_EXC_ERROR; */
2069: END IF;
2070:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2389:
2390: IF (NVL(ll_ic_tran_rec.line_id, 0) <= 0)
2391: THEN
2392: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2393: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2394: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2395: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2396: FND_MSG_PUB.ADD;
2397: RAISE FND_API.G_EXC_ERROR;

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

2390: IF (NVL(ll_ic_tran_rec.line_id, 0) <= 0)
2391: THEN
2392: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2393: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2394: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2395: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2396: FND_MSG_PUB.ADD;
2397: RAISE FND_API.G_EXC_ERROR;
2398: ELSE

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

2391: THEN
2392: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2393: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2394: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2395: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2396: FND_MSG_PUB.ADD;
2397: RAISE FND_API.G_EXC_ERROR;
2398: ELSE
2399: /* ================================================================ */

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

2413: IF (c_sales_order_info%NOTFOUND)
2414: THEN
2415: CLOSE c_sales_order_info;
2416: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2417: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2418: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2419: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2420: FND_MSG_PUB.Add;
2421: RAISE FND_API.G_EXC_ERROR;

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

2414: THEN
2415: CLOSE c_sales_order_info;
2416: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2417: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2418: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2419: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2420: FND_MSG_PUB.Add;
2421: RAISE FND_API.G_EXC_ERROR;
2422: ELSE

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

2415: CLOSE c_sales_order_info;
2416: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2417: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2418: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2419: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2420: FND_MSG_PUB.Add;
2421: RAISE FND_API.G_EXC_ERROR;
2422: ELSE
2423: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots FOUND: line_id='||ll_ic_tran_rec.line_id||'.', 'pick_lots.log');

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

2447: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2448: OR (l_whse_code <> ll_ic_tran_rec.whse_code)
2449: THEN
2450: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Set_Pick_Lots ERROR:Returned by Get_Process_Org.');
2451: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
2452: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2453: FND_MSG_PUB.Add;
2454: RAISE FND_API.G_EXC_ERROR;
2455: END IF;

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

2448: OR (l_whse_code <> ll_ic_tran_rec.whse_code)
2449: THEN
2450: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Set_Pick_Lots ERROR:Returned by Get_Process_Org.');
2451: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
2452: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2453: FND_MSG_PUB.Add;
2454: RAISE FND_API.G_EXC_ERROR;
2455: END IF;
2456:

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

2467: , x_msg_count => x_msg_count
2468: , x_msg_data => x_msg_data);
2469:
2470: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2471: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2472: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2473: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2474: FND_MSG_PUB.Add;
2475: raise FND_API.G_EXC_ERROR;

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

2468: , x_msg_data => x_msg_data);
2469:
2470: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2471: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2472: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2473: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2474: FND_MSG_PUB.Add;
2475: raise FND_API.G_EXC_ERROR;
2476: END IF;

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

2469:
2470: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2471: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2472: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2473: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2474: FND_MSG_PUB.Add;
2475: raise FND_API.G_EXC_ERROR;
2476: END IF;
2477:

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

2503: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR
2504: (l_op_alot_prm_rec.delete_mark = 1))
2505: THEN
2506: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2507: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2508: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
2509: FND_MSG_PUB.Add;
2510: RAISE FND_API.G_EXC_ERROR;
2511: END IF;

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

2504: (l_op_alot_prm_rec.delete_mark = 1))
2505: THEN
2506: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2507: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2508: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
2509: FND_MSG_PUB.Add;
2510: RAISE FND_API.G_EXC_ERROR;
2511: END IF;
2512:

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

2518: THEN
2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2521: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2522: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2523: FND_MSG_PUB.Add;
2524: RAISE FND_API.G_EXC_ERROR;
2525: END IF;
2526:

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

2606: , x_msg_data => x_msg_data);
2607:
2608: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2609: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2610: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2611: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2612: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;

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

2607:
2608: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2609: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2610: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2611: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2612: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;

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

2608: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2609: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2610: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2611: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2612: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616: l_need_update_default_lot := FALSE;

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

2625: /* There may have been a problem getting the rows */
2626: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2627: THEN
2628: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2629: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2630: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2631: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2632: FND_MSG_PUB.ADD;
2633: RAISE FND_API.G_EXC_ERROR;

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

2626: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2627: THEN
2628: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2629: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2630: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2631: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2632: FND_MSG_PUB.ADD;
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;

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

2627: THEN
2628: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2629: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2630: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2631: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2632: FND_MSG_PUB.ADD;
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;
2635:

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

2645: , x_msg_data => x_msg_data);
2646:
2647: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2648: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2649: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2650: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2651: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2652: FND_MSG_PUB.ADD;
2653: RAISE FND_API.G_EXC_ERROR;

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

2646:
2647: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2648: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2649: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2650: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2651: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2652: FND_MSG_PUB.ADD;
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;

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

2647: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2648: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2649: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2650: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2651: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2652: FND_MSG_PUB.ADD;
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655:

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

2665: );
2666:
2667: IF (l_lock_status = FALSE) THEN
2668: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2669: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2670: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2671: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2672: FND_MSG_PUB.Add;
2673: RAISE FND_API.G_EXC_ERROR;

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

2666:
2667: IF (l_lock_status = FALSE) THEN
2668: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2669: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2670: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2671: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2672: FND_MSG_PUB.Add;
2673: RAISE FND_API.G_EXC_ERROR;
2674: END IF;

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

2667: IF (l_lock_status = FALSE) THEN
2668: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2669: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2670: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2671: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2672: FND_MSG_PUB.Add;
2673: RAISE FND_API.G_EXC_ERROR;
2674: END IF;
2675: */

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

2689: , x_msg_data => x_msg_data);
2690:
2691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2692: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2693: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2694: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2695: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2696: FND_MSG_PUB.ADD;
2697: RAISE FND_API.G_EXC_ERROR;

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

2690:
2691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2692: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2693: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2694: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2695: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2696: FND_MSG_PUB.ADD;
2697: RAISE FND_API.G_EXC_ERROR;
2698: END IF;

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

2691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2692: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2693: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2694: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2695: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2696: FND_MSG_PUB.ADD;
2697: RAISE FND_API.G_EXC_ERROR;
2698: END IF;
2699: l_need_update_default_lot := FALSE;

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

2736: ,x_msg_data => x_msg_data);
2737:
2738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2739: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2740: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2741: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2742: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2743: FND_MSG_PUB.ADD;
2744: RAISE FND_API.G_EXC_ERROR;

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

2737:
2738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2739: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2740: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2741: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2742: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2743: FND_MSG_PUB.ADD;
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;

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

2738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2739: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2740: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2741: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2742: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2743: FND_MSG_PUB.ADD;
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;
2746:

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

2764: ,x_msg_data => x_msg_data);
2765:
2766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2767: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2768: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2769: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2770: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2771: FND_MSG_PUB.ADD;
2772: RAISE FND_API.G_EXC_ERROR;

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

2765:
2766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2767: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2768: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2769: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2770: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2771: FND_MSG_PUB.ADD;
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;

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

2766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2767: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2768: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2769: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2770: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2771: FND_MSG_PUB.ADD;
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;
2774:

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

2834: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2835: THEN
2836: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2837: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2838: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2839: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2840: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2841: FND_MSG_PUB.Add;
2842: RAISE FND_API.G_EXC_ERROR;

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

2835: THEN
2836: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2837: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2838: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2839: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2840: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2841: FND_MSG_PUB.Add;
2842: RAISE FND_API.G_EXC_ERROR;
2843: END IF;

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

2836: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2837: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2838: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2839: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2840: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2841: FND_MSG_PUB.Add;
2842: RAISE FND_API.G_EXC_ERROR;
2843: END IF;
2844: ELSE

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

2872:
2873: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2874: THEN
2875: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2876: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2877: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2878: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2879: FND_MSG_PUB.Add;
2880: RAISE FND_API.G_EXC_ERROR;

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

2873: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2874: THEN
2875: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2876: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2877: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2878: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2879: FND_MSG_PUB.Add;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;

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

2874: THEN
2875: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2876: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2877: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2878: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2879: FND_MSG_PUB.Add;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:

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

2932: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2933: THEN
2934: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2935: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2936: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2937: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2938: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2939: FND_MSG_PUB.Add;
2940: RAISE FND_API.G_EXC_ERROR;

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

2933: THEN
2934: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2935: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2936: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2937: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2938: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2939: FND_MSG_PUB.Add;
2940: RAISE FND_API.G_EXC_ERROR;
2941: END IF;

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

2934: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2935: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2936: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2937: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2938: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2939: FND_MSG_PUB.Add;
2940: RAISE FND_API.G_EXC_ERROR;
2941: END IF;
2942:

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

2948:
2949: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2950: THEN
2951: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2952: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2953: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2954: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2955: FND_MSG_PUB.Add;
2956: RAISE FND_API.G_EXC_ERROR;

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

2949: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2950: THEN
2951: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2952: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2953: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2954: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2955: FND_MSG_PUB.Add;
2956: RAISE FND_API.G_EXC_ERROR;
2957: END IF;

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

2950: THEN
2951: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2952: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2953: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2954: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2955: FND_MSG_PUB.Add;
2956: RAISE FND_API.G_EXC_ERROR;
2957: END IF;
2958:

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

3076: WHEN FND_API.G_EXC_ERROR THEN
3077: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3078:
3079: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3080: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3081: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3082: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3083: FND_MSG_PUB.Add;
3084: x_return_status := FND_API.G_RET_STS_ERROR;

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

3077: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3078:
3079: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3080: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3081: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3082: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3083: FND_MSG_PUB.Add;
3084: x_return_status := FND_API.G_RET_STS_ERROR;
3085:

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

3078:
3079: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3080: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3081: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3082: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3083: FND_MSG_PUB.Add;
3084: x_return_status := FND_API.G_RET_STS_ERROR;
3085:
3086: /* Get message count and data */

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

3092: WHEN locked_by_other_user
3093: THEN
3094: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3095: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3096: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3097: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3098: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3099: FND_MSG_PUB.Add;
3100: x_return_status := FND_API.G_RET_STS_ERROR;

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

3093: THEN
3094: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3095: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3096: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3097: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3098: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3099: FND_MSG_PUB.Add;
3100: x_return_status := FND_API.G_RET_STS_ERROR;
3101:

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

3094: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;
3095: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3096: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3097: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3098: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3099: FND_MSG_PUB.Add;
3100: x_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: WHEN OTHERS THEN

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

3324: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3325: THEN
3326: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3327: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3328: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3329: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3330: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3331: FND_MSG_PUB.Add;
3332: RAISE FND_API.G_EXC_ERROR;

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

3325: THEN
3326: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3327: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3328: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3329: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3330: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3331: FND_MSG_PUB.Add;
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;

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

3326: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3327: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3328: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3329: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3330: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3331: FND_MSG_PUB.Add;
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:

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

3353: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3354: THEN
3355: 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');
3356: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3357: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3358: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3359: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3360: FND_MSG_PUB.Add;
3361: RAISE FND_API.G_EXC_ERROR;

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

3354: THEN
3355: 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');
3356: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3357: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3358: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3359: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3360: FND_MSG_PUB.Add;
3361: RAISE FND_API.G_EXC_ERROR;
3362: END IF;

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

3355: 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');
3356: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3357: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3358: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3359: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3360: FND_MSG_PUB.Add;
3361: RAISE FND_API.G_EXC_ERROR;
3362: END IF;
3363: /* cancel all the reservations for GME */

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

3386: );
3387: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3388: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3389: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3390: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3391: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3392: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3393: FND_MSG_PUB.Add;
3394: RAISE FND_API.G_EXC_ERROR;

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

3387: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3388: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3389: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3390: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3391: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3392: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3393: FND_MSG_PUB.Add;
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;

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

3388: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3389: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3390: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3391: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3392: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3393: FND_MSG_PUB.Add;
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396: END IF;

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

3466: );
3467:
3468: IF (l_lock_status = FALSE) THEN
3469: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3470: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3471: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3472: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3473: FND_MSG_PUB.Add;
3474: RAISE FND_API.G_EXC_ERROR;

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

3467:
3468: IF (l_lock_status = FALSE) THEN
3469: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3470: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3471: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3472: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3473: FND_MSG_PUB.Add;
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;

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

3468: IF (l_lock_status = FALSE) THEN
3469: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3470: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3471: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3472: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3473: FND_MSG_PUB.Add;
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:

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

3543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3544: THEN
3545: 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');
3546: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3547: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3548: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3549: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3550: FND_MSG_PUB.Add;
3551: RAISE FND_API.G_EXC_ERROR;

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

3544: THEN
3545: 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');
3546: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3547: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3548: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3549: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3550: FND_MSG_PUB.Add;
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;

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

3545: 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');
3546: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3547: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3548: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3549: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3550: FND_MSG_PUB.Add;
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;
3553: ELSE

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

3584: /* There may not be any rows, and it should be possible ! (if not auto-allocate before) */
3585: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)
3586: THEN
3587: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3588: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3589: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3590: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3591: FND_MSG_PUB.ADD;
3592: RAISE FND_API.G_EXC_ERROR;

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

3585: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)
3586: THEN
3587: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3588: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3589: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3590: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3591: FND_MSG_PUB.ADD;
3592: RAISE FND_API.G_EXC_ERROR;
3593: END IF;

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

3586: THEN
3587: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3588: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3589: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3590: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3591: FND_MSG_PUB.ADD;
3592: RAISE FND_API.G_EXC_ERROR;
3593: END IF;
3594:

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

3595: /* There may have been a problem getting the rows */
3596: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3597: THEN
3598: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3599: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3600: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3601: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3602: FND_MSG_PUB.ADD;
3603: RAISE FND_API.G_EXC_ERROR;

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

3596: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3597: THEN
3598: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3599: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3600: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3601: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3602: FND_MSG_PUB.ADD;
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;

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

3597: THEN
3598: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3599: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3600: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3601: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3602: FND_MSG_PUB.ADD;
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605:

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

3611: , x_msg_data => x_msg_data);
3612:
3613: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3614: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3615: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3616: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3617: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3618: FND_MSG_PUB.ADD;
3619: RAISE FND_API.G_EXC_ERROR;

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

3612:
3613: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3614: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3615: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3616: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3617: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3618: FND_MSG_PUB.ADD;
3619: RAISE FND_API.G_EXC_ERROR;
3620: END IF;

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

3613: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3614: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3615: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3616: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3617: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3618: FND_MSG_PUB.ADD;
3619: RAISE FND_API.G_EXC_ERROR;
3620: END IF;
3621:

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

3622: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: default_lot_index='||x_default_lot_index, 'pick_lots.log');
3623: IF (x_default_lot_index=0)
3624: THEN
3625: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3626: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3627: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3628: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3629: FND_MSG_PUB.ADD;
3630: RAISE FND_API.G_EXC_ERROR;

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

3623: IF (x_default_lot_index=0)
3624: THEN
3625: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3626: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3627: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3628: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3629: FND_MSG_PUB.ADD;
3630: RAISE FND_API.G_EXC_ERROR;
3631: END IF;

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

3624: THEN
3625: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3626: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3627: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3628: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3629: FND_MSG_PUB.ADD;
3630: RAISE FND_API.G_EXC_ERROR;
3631: END IF;
3632:

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

3634: WHEN FND_API.G_EXC_ERROR THEN
3635: ROLLBACK TO SAVEPOINT Empty_Default_lot;
3636:
3637: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3638: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3639: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3641: FND_MSG_PUB.Add;
3642: x_return_status := FND_API.G_RET_STS_ERROR;

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

3635: ROLLBACK TO SAVEPOINT Empty_Default_lot;
3636:
3637: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3638: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3639: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3641: FND_MSG_PUB.Add;
3642: x_return_status := FND_API.G_RET_STS_ERROR;
3643:

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

3636:
3637: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3638: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3639: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3641: FND_MSG_PUB.Add;
3642: x_return_status := FND_API.G_RET_STS_ERROR;
3643:
3644: /* Get message count and data */

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

3710:
3711: EXCEPTION
3712: WHEN FND_API.G_EXC_ERROR THEN
3713: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3714: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3715: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3716: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3717: FND_MSG_PUB.Add;
3718: x_return_status := FND_API.G_RET_STS_ERROR;

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

3711: EXCEPTION
3712: WHEN FND_API.G_EXC_ERROR THEN
3713: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3714: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3715: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3716: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3717: FND_MSG_PUB.Add;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719:

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

3712: WHEN FND_API.G_EXC_ERROR THEN
3713: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3714: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3715: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3716: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3717: FND_MSG_PUB.Add;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719:
3720: /* Get message count and data */

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

3858: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3859: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
3860: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3861: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3862: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3863: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3864: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3865: FND_MSG_PUB.Add;
3866: raise FND_API.G_EXC_ERROR;

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

3859: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
3860: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3861: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3862: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3863: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3864: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3865: FND_MSG_PUB.Add;
3866: raise FND_API.G_EXC_ERROR;
3867: END IF;

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

3860: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3861: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3862: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3863: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3864: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3865: FND_MSG_PUB.Add;
3866: raise FND_API.G_EXC_ERROR;
3867: END IF;
3868: END create_dflt_lot_from_scratch;

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

4145: GMI_reservation_Util.PrintLn('(opm_dbg) Error in creating transaction for receiving');
4146: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4147: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4148: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4149: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4150: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4151: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4152: FND_MSG_PUB.Add;
4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

4146: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4147: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4148: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4149: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4150: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4151: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4152: FND_MSG_PUB.Add;
4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4154: END IF;

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

4147: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4148: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4149: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4150: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4151: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4152: FND_MSG_PUB.Add;
4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4154: END IF;
4155:

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

4175:
4176: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
4177: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4178: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4179: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4180: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4181: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4182: FND_MSG_PUB.Add;
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4176: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
4177: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4178: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4179: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4180: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4181: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4182: FND_MSG_PUB.Add;
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: END IF;

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

4177: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4178: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4179: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4180: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4181: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4182: FND_MSG_PUB.Add;
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: END IF;
4185:

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

4426: x_return_status =>l_return_status,
4427: x_msg_count =>l_msg_count,
4428: x_msg_data =>l_msg_data);
4429: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4430: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4431: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
4432: FND_MSG_PUB.Add;
4433: RAISE FND_API.G_EXC_ERROR;
4434: END IF;

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

4427: x_msg_count =>l_msg_count,
4428: x_msg_data =>l_msg_data);
4429: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4430: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4431: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
4432: FND_MSG_PUB.Add;
4433: RAISE FND_API.G_EXC_ERROR;
4434: END IF;
4435: GMI_reservation_Util.PrintLn('from uom (OPM) '||l_opm_from_uom);

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

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

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

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

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

4455: pnew_uom =>l_opm_to_uom,
4456: onew_qty =>l_converted_qty);
4457: IF l_converted_qty < 0 THEN
4458: GMI_reservation_Util.PrintLn('conversion error code'|| l_converted_qty);
4459: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');
4460: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);
4461: FND_MSG_PUB.Add;
4462: RAISE FND_API.G_EXC_ERROR;
4463: END IF;

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

4456: onew_qty =>l_converted_qty);
4457: IF l_converted_qty < 0 THEN
4458: GMI_reservation_Util.PrintLn('conversion error code'|| l_converted_qty);
4459: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');
4460: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);
4461: FND_MSG_PUB.Add;
4462: RAISE FND_API.G_EXC_ERROR;
4463: END IF;
4464:

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

4769: GMI_reservation_Util.PrintLn('(opm_dbg) Error in creating default transaction ');
4770: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4771: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4772: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4773: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4774: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4775: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4776: FND_MSG_PUB.Add;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4770: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4771: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4772: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4773: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4774: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4775: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4776: FND_MSG_PUB.Add;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4778: END IF;

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

4771: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4772: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4773: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4774: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4775: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4776: FND_MSG_PUB.Add;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4778: END IF;
4779: END IF;

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

4833: GMI_reservation_Util.PrintLn('(opm_dbg) Error in creating transaction ');
4834: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4835: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4836: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4837: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4838: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4839: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4840: FND_MSG_PUB.Add;
4841:

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

4834: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4835: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4836: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4837: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4838: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4839: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4840: FND_MSG_PUB.Add;
4841:
4842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4835: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4836: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4837: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4838: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4839: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4840: FND_MSG_PUB.Add;
4841:
4842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4843: END IF;

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

5031: GMI_reservation_Util.PrintLn('(opm_dbg) Error in updating transaction ');
5032: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
5033: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5034: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5035: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5036: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5037: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5038: FND_MSG_PUB.Add;
5039: x_return_status := FND_API.G_RET_STS_ERROR;

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

5032: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
5033: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5034: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5035: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5036: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5037: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5038: FND_MSG_PUB.Add;
5039: x_return_status := FND_API.G_RET_STS_ERROR;
5040: RETURN;

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

5033: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5034: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5035: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5036: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5037: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5038: FND_MSG_PUB.Add;
5039: x_return_status := FND_API.G_RET_STS_ERROR;
5040: RETURN;
5041: END IF; -- of update

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

5385: , x_msg_count => x_msg_count
5386: , x_msg_data => x_msg_data);
5387:
5388: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5389: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5390: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5391: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5392: FND_MSG_PUB.Add;
5393: raise FND_API.G_EXC_ERROR;

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

5386: , x_msg_data => x_msg_data);
5387:
5388: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5389: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5390: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5391: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5392: FND_MSG_PUB.Add;
5393: raise FND_API.G_EXC_ERROR;
5394: END IF;

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

5387:
5388: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5389: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5390: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5391: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5392: FND_MSG_PUB.Add;
5393: raise FND_API.G_EXC_ERROR;
5394: END IF;
5395:

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

5540: , x_msg_data => x_msg_data);
5541: gmi_reservation_util.println('BaCK FROM Get_OPM_item_from_Apps IN validate_opm_quantities');
5542:
5543: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5544: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5545: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5546: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5547: FND_MSG_PUB.Add;
5548: x_check_status := 0;

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

5541: gmi_reservation_util.println('BaCK FROM Get_OPM_item_from_Apps IN validate_opm_quantities');
5542:
5543: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5544: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5545: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5546: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5547: FND_MSG_PUB.Add;
5548: x_check_status := 0;
5549: raise FND_API.G_EXC_ERROR;

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

5542:
5543: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5544: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5545: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5546: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5547: FND_MSG_PUB.Add;
5548: x_check_status := 0;
5549: raise FND_API.G_EXC_ERROR;
5550: END IF;