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_LINE_STATUS_PUB dependencies on OE_DEBUG_PUB

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

23:
24: l_cancel_flag VARCHAR2(1);
25:
26: --
27: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
28: --
29: BEGIN
30:
31: SELECT cancelled_flag

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

72:
73: IS
74:
75: --
76: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
77: --
78: BEGIN
79:
80: Get_Cancelled_Status(p_line_id => p_line_id, x_result => x_result);

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

122:
123: l_open_flag VARCHAR2(1);
124:
125: --
126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
127: --
128: BEGIN
129:
130: SELECT nvl(open_flag, 'Y')

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

171:
172: IS
173:
174: --
175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
176: --
177: BEGIN
178:
179: Get_Closed_Status(p_line_id => p_line_id, x_result => x_result);

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

221:
222: l_result_date DATE;
223:
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --
227: BEGIN
228:
229: Get_Purchase_Release_Status(p_line_id => p_line_id, x_result => x_result, x_result_date => l_result_date);

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

261:
262: IS
263:
264: --
265: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
266: --
267: BEGIN
268:
269: SELECT nvl(wias.activity_result_code, 'N'), wias.end_date

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

321:
322: l_shipped_quantity NUMBER;
323:
324: --
325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
326: --
327: BEGIN
328:
329: SELECT nvl(shipped_quantity, 0)

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

370:
371: IS
372: l_shipped_quantity NUMBER;
373: --
374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
375: --
376: BEGIN
377:
378: -- Get_Ship_Status(p_line_id => p_line_id, x_result => x_result);

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

439: l_picked_quantity NUMBER;
440: l_picked_quantity_uom VARCHAR2(3);
441:
442: --
443: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
444: --
445: BEGIN
446:
447:

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

497: l_pick_status VARCHAR2(1) := 'X';
498: l_picked_quantity NUMBER := 0;
499:
500: --
501: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
502: --
503: BEGIN
504:
505: FOR l_pick_data IN c_pick LOOP

Line 508: oe_debug_pub.add( 'PICK STATUS/QUANTITY :'||L_PICK_DATA.PICK_STATUS||'/'||TO_CHAR ( L_PICK_DATA.REQUESTED_QUANTITY ) , 2 ) ;

504:
505: FOR l_pick_data IN c_pick LOOP
506:
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'PICK STATUS/QUANTITY :'||L_PICK_DATA.PICK_STATUS||'/'||TO_CHAR ( L_PICK_DATA.REQUESTED_QUANTITY ) , 2 ) ;
509: END IF;
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add( 'L_PICK_STATUS : '||L_PICK_STATUS , 2 ) ;
512: END IF;

Line 511: oe_debug_pub.add( 'L_PICK_STATUS : '||L_PICK_STATUS , 2 ) ;

507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'PICK STATUS/QUANTITY :'||L_PICK_DATA.PICK_STATUS||'/'||TO_CHAR ( L_PICK_DATA.REQUESTED_QUANTITY ) , 2 ) ;
509: END IF;
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add( 'L_PICK_STATUS : '||L_PICK_STATUS , 2 ) ;
512: END IF;
513: IF l_pick_data.pick_status = 'Y' THEN
514: IF l_pick_status = 'X' OR
515: l_pick_status = 'Y' THEN

Line 523: oe_debug_pub.add( 'PICK STATUS/QUANTITY IN THE IF :'||L_PICK_STATUS||'/'||TO_CHAR ( L_PICKED_QUANTITY ) , 2 ) ;

519: END IF;
520: l_picked_quantity := l_picked_quantity + l_pick_data.requested_quantity;
521: x_picked_quantity_uom := l_pick_data.requested_quantity_uom;
522: IF l_debug_level > 0 THEN
523: oe_debug_pub.add( 'PICK STATUS/QUANTITY IN THE IF :'||L_PICK_STATUS||'/'||TO_CHAR ( L_PICKED_QUANTITY ) , 2 ) ;
524: END IF;
525: ELSIF l_pick_data.pick_status <> 'Y' THEN
526: IF l_pick_status = 'N' OR
527: l_pick_status = 'X' THEN

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

572:
573: IS
574: l_received_quantity NUMBER;
575: --
576: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
577: --
578: BEGIN
579:
580:

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

623:
624: IS
625:
626: --
627: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
628: --
629: BEGIN
630:
631: Get_Received_Status(p_line_id => p_line_id, x_result => x_result);

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

672:
673: l_invoice_interface_status VARCHAR2(30);
674:
675: --
676: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
677: --
678: BEGIN
679:
680: SELECT invoice_interface_status_code

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

721: IS
722: l_count NUMBER;
723: l_header_id NUMBER;
724: --
725: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
726: --
727: BEGIN
728:
729: Get_Invoiced_Status(p_line_id => p_line_id, x_result => x_result);

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

781: l_flow_status_code VARCHAR2(80);
782: l_flow_meaning VARCHAR2(80);
783: released_count NUMBER;
784: total_count NUMBER;
785: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
786: BEGIN
787:
788:
789: IF l_debug_level > 0 THEN

Line 790: OE_DEBUG_PUB.Add('Entering OE_LINE_STATUS_PUB.Get_Line_Status...',1);

786: BEGIN
787:
788:
789: IF l_debug_level > 0 THEN
790: OE_DEBUG_PUB.Add('Entering OE_LINE_STATUS_PUB.Get_Line_Status...',1);
791: OE_DEBUG_PUB.Add('Flow Status Code:'||p_flow_status_code,1);
792: END IF;
793:
794: l_flow_status_code := p_flow_status_code;

Line 791: OE_DEBUG_PUB.Add('Flow Status Code:'||p_flow_status_code,1);

787:
788:
789: IF l_debug_level > 0 THEN
790: OE_DEBUG_PUB.Add('Entering OE_LINE_STATUS_PUB.Get_Line_Status...',1);
791: OE_DEBUG_PUB.Add('Flow Status Code:'||p_flow_status_code,1);
792: END IF;
793:
794: l_flow_status_code := p_flow_status_code;
795:

Line 875: OE_DEBUG_PUB.Add('Exiting Get_Line_Status:'||l_flow_meaning,1);

871: END IF;
872: END IF;
873:
874: IF l_debug_level > 0 THEN
875: OE_DEBUG_PUB.Add('Exiting Get_Line_Status:'||l_flow_meaning,1);
876: END IF;
877:
878: RETURN l_flow_meaning;
879: