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.OE_SHIPPING_TOLERANCES_PUB dependencies on OE_DEBUG_PUB

Line 79: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

75: l_primary_quantity NUMBER;
76: l_qty_return_status VARCHAR2(1);
77:
78: --
79: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
80: --
81: BEGIN
82:
83: IF l_debug_level > 0 THEN

Line 84: oe_debug_pub.add( 'ENTERING OE_SHIPPING_TOLERANCES_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;

80: --
81: BEGIN
82:
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'ENTERING OE_SHIPPING_TOLERANCES_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
85: END IF;
86:
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: /*

Line 130: oe_debug_pub.add('It is a ATO MODEL ',3);

126: /* Comented for bug 2193139
127: IF nvl(l_top_model_line_id,-1) = nvl(l_ato_line_id,-1) AND
128: l_top_model_line_id IS NOT NULL THEN
129:
130: oe_debug_pub.add('It is a ATO MODEL ',3);
131:
132: SELECT line_set_id
133: INTO l_line_set_id
134: FROM OE_ORDER_LINES_ALL

Line 137: oe_debug_pub.add('Line set id : '||l_line_set_id,3);

133: INTO l_line_set_id
134: FROM OE_ORDER_LINES_ALL
135: WHERE line_id = l_top_model_line_id;
136:
137: oe_debug_pub.add('Line set id : '||l_line_set_id,3);
138:
139: END IF;
140: */
141: IF l_line_set_id IS NOT NULL THEN

Line 144: oe_debug_pub.add( 'LINE SET ID : '||L_LINE_SET_ID , 3 ) ;

140: */
141: IF l_line_set_id IS NOT NULL THEN
142: -- HW Sum qty2 for OPM
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'LINE SET ID : '||L_LINE_SET_ID , 3 ) ;
145: END IF;
146: SELECT SUM(ordered_quantity)
147: , SUM(nvl(shipped_quantity,0))
148: , SUM(nvl(shipping_quantity,0))

Line 162: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY '||L_SHIPPED_QUANTITY , 3 ) ;

158: FROM oe_order_lines_all
159: WHERE line_set_id = l_line_set_id;
160:
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY '||L_SHIPPED_QUANTITY , 3 ) ;
163: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY2 '||L_SHIPPED_QUANTITY2 , 3 ) ; -- INVCONV
164: END IF;
165: SELECT count(*)
166: INTO l_count_unshipped

Line 163: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY2 '||L_SHIPPED_QUANTITY2 , 3 ) ; -- INVCONV

159: WHERE line_set_id = l_line_set_id;
160:
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY '||L_SHIPPED_QUANTITY , 3 ) ;
163: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY2 '||L_SHIPPED_QUANTITY2 , 3 ) ; -- INVCONV
164: END IF;
165: SELECT count(*)
166: INTO l_count_unshipped
167: FROM oe_order_lines_all

Line 173: oe_debug_pub.add( 'COUNT '||L_COUNT_UNSHIPPED , 3 ) ;

169: AND shipped_quantity IS NULL
170: AND line_id <> p_line_id ;
171:
172: IF l_debug_level > 0 THEN
173: oe_debug_pub.add( 'COUNT '||L_COUNT_UNSHIPPED , 3 ) ;
174: END IF;
175:
176: IF nvl(l_count_unshipped,0) > 0 THEN
177:

Line 200: oe_debug_pub.add( 'DELIVERY SHIPPING QUANTITY/UOM '||L_DEL_SHIPPING_QUANTITY||'/'||L_SHIPPING_QUANTITY_UOM , 3 ) ;

196:
197: END;
198:
199: IF l_debug_level > 0 THEN
200: oe_debug_pub.add( 'DELIVERY SHIPPING QUANTITY/UOM '||L_DEL_SHIPPING_QUANTITY||'/'||L_SHIPPING_QUANTITY_UOM , 3 ) ;
201: END IF;
202:
203:
204: IF l_order_quantity_uom <> l_shipping_quantity_uom AND

Line 223: oe_debug_pub.add('OPM shipped quantity in proc Get_Min_Max_Tolerance_Quantity after new get_opm_converted_qty is '||l_OPM_shipped_quantity, 5);

219: p_apps_from_uom => l_shipping_quantity_uom,
220: p_apps_to_uom => l_order_quantity_uom,
221: p_original_qty => l_del_shipping_quantity);
222:
223: oe_debug_pub.add('OPM shipped quantity in proc Get_Min_Max_Tolerance_Quantity after new get_opm_converted_qty is '||l_OPM_shipped_quantity, 5);
224:
225: l_del_shipped_quantity := l_OPM_shipped_quantity ;
226:
227: -- HW This line is discrete

Line 237: oe_debug_pub.add( 'CONVERTED SHIPPED QUANTITY : '|| L_DEL_SHIPPED_QUANTITY , 3 ) ;

233: l_order_quantity_uom,
234: l_del_shipping_quantity
235: );
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( 'CONVERTED SHIPPED QUANTITY : '|| L_DEL_SHIPPED_QUANTITY , 3 ) ;
238: END IF;
239:
240: -- END IF; -- HW end of branching INVCONV
241:

Line 256: oe_debug_pub.add( 'RETURN STATUS FROM INV API : '||L_QTY_RETURN_STATUS , 1 ) ;

252: x_return_status => l_qty_return_status
253: );
254:
255: IF l_debug_level > 0 THEN
256: oe_debug_pub.add( 'RETURN STATUS FROM INV API : '||L_QTY_RETURN_STATUS , 1 ) ;
257: END IF;
258: IF l_qty_return_status = 'W' THEN
259:
260: l_del_shipped_quantity := l_validated_quantity;

Line 278: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;

274:
275: END IF;/*line set */
276:
277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
279: END IF;
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
282: END IF;

Line 281: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;

277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add( 'TOTAL ORDERED QUANTITY : '||TO_CHAR ( L_ORDERED_QUANTITY ) , 3 ) ;
279: END IF;
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'TOTAL SHIPPED QUANTITY : '||TO_CHAR ( L_SHIPPED_QUANTITY ) , 3 ) ;
282: END IF;
283:
284: l_tolerance_quantity_below := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_below,0)/100;
285: l_tolerance_quantity_above := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_above,0)/100;

Line 288: oe_debug_pub.add( 'TOLERANCE QUANTITY BELOW : '||L_TOLERANCE_QUANTITY_BELOW , 3 ) ;

284: l_tolerance_quantity_below := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_below,0)/100;
285: l_tolerance_quantity_above := nvl(l_ordered_quantity,0)*nvl(l_ship_tolerance_above,0)/100;
286:
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add( 'TOLERANCE QUANTITY BELOW : '||L_TOLERANCE_QUANTITY_BELOW , 3 ) ;
289: END IF;
290: IF l_debug_level > 0 THEN
291: oe_debug_pub.add( 'TOLERANCE QUANTITY ABOVE : '||L_TOLERANCE_QUANTITY_ABOVE , 3 ) ;
292: END IF;

Line 291: oe_debug_pub.add( 'TOLERANCE QUANTITY ABOVE : '||L_TOLERANCE_QUANTITY_ABOVE , 3 ) ;

287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add( 'TOLERANCE QUANTITY BELOW : '||L_TOLERANCE_QUANTITY_BELOW , 3 ) ;
289: END IF;
290: IF l_debug_level > 0 THEN
291: oe_debug_pub.add( 'TOLERANCE QUANTITY ABOVE : '||L_TOLERANCE_QUANTITY_ABOVE , 3 ) ;
292: END IF;
293:
294: l_min_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) - l_tolerance_quantity_below;
295: l_max_quantity_remaining := l_ordered_quantity - nvl(l_shipped_quantity,0) + l_tolerance_quantity_above;

Line 302: oe_debug_pub.add( 'MIN REMAINING QUANTITY : '||L_MIN_QUANTITY_REMAINING , 3 ) ;

298: l_min_quantity_remaining2 := nvl(l_ordered_quantity2,0) - nvl(l_shipped_quantity2,0) - l_tolerance_quantity_below;
299: l_max_quantity_remaining2 := nvl(l_ordered_quantity2,0) - nvl(l_shipped_quantity2,0) + l_tolerance_quantity_above;
300:
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'MIN REMAINING QUANTITY : '||L_MIN_QUANTITY_REMAINING , 3 ) ;
303: END IF;
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add( 'MAX REMAINING QUANTITY : '||L_MAX_QUANTITY_REMAINING , 3 ) ;
306: END IF;

Line 305: oe_debug_pub.add( 'MAX REMAINING QUANTITY : '||L_MAX_QUANTITY_REMAINING , 3 ) ;

301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'MIN REMAINING QUANTITY : '||L_MIN_QUANTITY_REMAINING , 3 ) ;
303: END IF;
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add( 'MAX REMAINING QUANTITY : '||L_MAX_QUANTITY_REMAINING , 3 ) ;
306: END IF;
307:
308: -- HW Print Qty2 for OPM
309: IF l_debug_level > 0 THEN

Line 310: oe_debug_pub.add( 'MIN REMAINING QUANTITY2 : '||L_MIN_QUANTITY_REMAINING2 , 3 ) ;

306: END IF;
307:
308: -- HW Print Qty2 for OPM
309: IF l_debug_level > 0 THEN
310: oe_debug_pub.add( 'MIN REMAINING QUANTITY2 : '||L_MIN_QUANTITY_REMAINING2 , 3 ) ;
311: END IF;
312: IF l_debug_level > 0 THEN
313: oe_debug_pub.add( 'MAX REMAINING QUANTITY2 : '||L_MAX_QUANTITY_REMAINING2 , 3 ) ;
314: END IF;

Line 313: oe_debug_pub.add( 'MAX REMAINING QUANTITY2 : '||L_MAX_QUANTITY_REMAINING2 , 3 ) ;

309: IF l_debug_level > 0 THEN
310: oe_debug_pub.add( 'MIN REMAINING QUANTITY2 : '||L_MIN_QUANTITY_REMAINING2 , 3 ) ;
311: END IF;
312: IF l_debug_level > 0 THEN
313: oe_debug_pub.add( 'MAX REMAINING QUANTITY2 : '||L_MAX_QUANTITY_REMAINING2 , 3 ) ;
314: END IF;
315:
316: IF l_min_quantity_remaining < 0 THEN
317:

Line 347: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;

343: x_min_remaining_quantity2 := nvl(l_min_quantity_remaining2,0);
344: x_max_remaining_quantity2 := nvl(l_max_quantity_remaining2,0);
345:
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
348: END IF;
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
351: END IF;

Line 350: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;

346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
348: END IF;
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
351: END IF;
352:
353: -- HW print qty2 for OPM
354: IF l_debug_level > 0 THEN

Line 355: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;

351: END IF;
352:
353: -- HW print qty2 for OPM
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
356: END IF;
357: IF l_debug_level > 0 THEN
358: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
359: END IF;

Line 358: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;

354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
356: END IF;
357: IF l_debug_level > 0 THEN
358: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
359: END IF;
360:
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add( 'EXITING OE_SHIPPING_TOLERANCES_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;

Line 362: oe_debug_pub.add( 'EXITING OE_SHIPPING_TOLERANCES_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;

358: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
359: END IF;
360:
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add( 'EXITING OE_SHIPPING_TOLERANCES_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;
363: END IF;
364:
365: EXCEPTION
366:

Line 384: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: IF l_debug_level > 0 THEN
384: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
385: END IF;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387:
388: -- Get message count and data

Line 398: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

394:
395: WHEN OTHERS THEN
396:
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
399: END IF;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

432: )
433: IS
434:
435: --
436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN

Line 441: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_QUANTITY_UOM' , 1 ) ;

437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_QUANTITY_UOM' , 1 ) ;
442: END IF;
443:
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445:

Line 467: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;

463: FROM oe_order_lines_all
464: WHERE line_id = p_line_id;
465:
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
468: END IF;
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
471: END IF;

Line 470: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;

466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;
468: END IF;
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
471: END IF;
472: IF l_debug_level > 0 THEN
473: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
474: END IF;

Line 473: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;

469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY : '||X_MAX_REMAINING_QUANTITY , 3 ) ;
471: END IF;
472: IF l_debug_level > 0 THEN
473: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
474: END IF;
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
477: END IF;

Line 476: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;

472: IF l_debug_level > 0 THEN
473: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY2 : '||X_MIN_REMAINING_QUANTITY2 , 3 ) ;
474: END IF;
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
477: END IF;
478: IF l_debug_level > 0 THEN
479: oe_debug_pub.add( 'RETURN QUANTITY UOM : '||X_QUANTITY_UOM , 3 ) ;
480: END IF;

Line 479: oe_debug_pub.add( 'RETURN QUANTITY UOM : '||X_QUANTITY_UOM , 3 ) ;

475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
477: END IF;
478: IF l_debug_level > 0 THEN
479: oe_debug_pub.add( 'RETURN QUANTITY UOM : '||X_QUANTITY_UOM , 3 ) ;
480: END IF;
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( 'RETURN QUANTITY UOM2 : '||X_QUANTITY_UOM2 , 3 ) ;
483: END IF;

Line 482: oe_debug_pub.add( 'RETURN QUANTITY UOM2 : '||X_QUANTITY_UOM2 , 3 ) ;

478: IF l_debug_level > 0 THEN
479: oe_debug_pub.add( 'RETURN QUANTITY UOM : '||X_QUANTITY_UOM , 3 ) ;
480: END IF;
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( 'RETURN QUANTITY UOM2 : '||X_QUANTITY_UOM2 , 3 ) ;
483: END IF;
484:
485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_QUANTITY_UOM '||X_RETURN_STATUS , 1 ) ;

Line 486: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_QUANTITY_UOM '||X_RETURN_STATUS , 1 ) ;

482: oe_debug_pub.add( 'RETURN QUANTITY UOM2 : '||X_QUANTITY_UOM2 , 3 ) ;
483: END IF;
484:
485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_QUANTITY_UOM '||X_RETURN_STATUS , 1 ) ;
487: END IF;
488:
489: EXCEPTION
490:

Line 510: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
511: END IF;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513:
514: -- Get message count and data

Line 524: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;

520:
521: WHEN OTHERS THEN
522:
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
525: END IF;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527:
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)