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

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

22: l_entity_type VARCHAR2(30);
23: l_set_rec OE_ORDER_CACHE.set_rec_type; -- 2887734
24: l_ship_set_id NUMBER :=0;
25: --
26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
27: --
28: BEGIN
29:
30: IF l_debug_level > 0 THEN

Line 31: oe_debug_pub.add( 'ENTERING SCHEDULE_SET_OF_LINES' , 1 ) ;

27: --
28: BEGIN
29:
30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add( 'ENTERING SCHEDULE_SET_OF_LINES' , 1 ) ;
32: END IF;
33:
34: -- This procedure is called from the SETS api. The sets API has taken
35: -- care of of validation that needed to be done for the lines

Line 54: oe_debug_pub.add( 'LINE IS A SERVICE OR INCLUDED ITEM' , 1 ) ;

50: -- Service items cannot be scheduled, so we will skip them.
51: -- Included items will be picked up by their parent, so we will
52: -- skip them.
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( 'LINE IS A SERVICE OR INCLUDED ITEM' , 1 ) ;
55: END IF;
56:
57: ELSE
58: K := K + 1;

Line 83: oe_debug_pub.add( 'AFTER CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;

79: p_freeze => FALSE,
80: p_process_requests => TRUE);
81:
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'AFTER CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
84: END IF;
85:
86: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 97: oe_debug_pub.add( 'MERGING INCLUDED ITEM TABLE WITH LINE TABLE' , 1 ) ;

93: (p_line_id => p_x_line_tbl(I).line_id,
94: x_line_tbl => l_ii_line_tbl);
95:
96: IF l_debug_level > 0 THEN
97: oe_debug_pub.add( 'MERGING INCLUDED ITEM TABLE WITH LINE TABLE' , 1 ) ;
98: END IF;
99:
100: -- Merge the Included Item table to the line table
101: FOR J IN 1..l_ii_line_tbl.count LOOP

Line 128: oe_debug_pub.add( 'CALLING PROCESS_SET_OF_LINES WITH : ' || L_LINE_TBL.COUNT , 1 ) ;

124: END;
125: END LOOP;
126:
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'CALLING PROCESS_SET_OF_LINES WITH : ' || L_LINE_TBL.COUNT , 1 ) ;
129: END IF;
130:
131: FOR I IN 1..l_line_tbl.count LOOP
132:

Line 208: oe_debug_pub.add( 'CALLING PROCESS_GROUP' || L_LINE_TBL ( 1 ) .SHIP_SET_ID , 1 ) ;

204: END LOOP;
205:
206: IF l_line_tbl.count > 0 THEN
207: IF l_debug_level > 0 THEN
208: oe_debug_pub.add( 'CALLING PROCESS_GROUP' || L_LINE_TBL ( 1 ) .SHIP_SET_ID , 1 ) ;
209: END IF;
210:
211: Oe_Config_Schedule_Pvt.Process_Group
212: (p_x_line_tbl => l_line_tbl

Line 219: oe_debug_pub.add( 'AFTER CALLING PROCESS_GROUP' || X_RETURN_STATUS , 1 ) ;

215: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
216: ,x_return_status => x_return_status);
217:
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'AFTER CALLING PROCESS_GROUP' || X_RETURN_STATUS , 1 ) ;
220: END IF;
221: END IF;
222:
223: p_x_line_tbl := l_line_tbl;

Line 225: oe_debug_pub.add( 'EXITING SCHEDULE_SET_OF_LINES' , 1 ) ;

221: END IF;
222:
223: p_x_line_tbl := l_line_tbl;
224: IF l_debug_level > 0 THEN
225: oe_debug_pub.add( 'EXITING SCHEDULE_SET_OF_LINES' , 1 ) ;
226: END IF;
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN

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

306: l_msg_data varchar2(32000);
307:
308:
309: --
310: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
311: --
312: BEGIN
313: --Initialze retcode #4220950
314: ERRBUF := '';

Line 335: oe_debug_pub.add( 'INSIDE THE RESCHEDULING SHIP SETS CONCURRENT PROGRAM' ) ;

331: fnd_file.put_line(FND_FILE.LOG, ' Ship Set Number = '||
332: p_set_id);
333:
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'INSIDE THE RESCHEDULING SHIP SETS CONCURRENT PROGRAM' ) ;
336: END IF;
337: IF p_set_id is not null then
338: OPEN Get_Set_Name;
339: FETCH Get_Set_Name

Line 352: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ) ;

348: LOOP
349:
350: SAVEPOINT Process_lines_in_set;
351: IF l_debug_level > 0 THEN
352: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ) ;
353: END IF;
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'SHIP SET ID:'||GET_LINE_SET.SHIP_SET_ID ) ;
356: END IF;

Line 355: oe_debug_pub.add( 'SHIP SET ID:'||GET_LINE_SET.SHIP_SET_ID ) ;

351: IF l_debug_level > 0 THEN
352: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ) ;
353: END IF;
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'SHIP SET ID:'||GET_LINE_SET.SHIP_SET_ID ) ;
356: END IF;
357:
358: -- With the above cursor we have got the list of all the Ship Sets
359: -- for the orders.

Line 368: oe_debug_pub.add( 'AFTER THE LINES ARE QUERIED' ) ;

364: ( p_set_id => Get_Line_set.ship_set_id
365: ,x_line_tbl => l_set_line_tbl );
366:
367: IF l_debug_level > 0 THEN
368: oe_debug_pub.add( 'AFTER THE LINES ARE QUERIED' ) ;
369: END IF;
370:
371: -- We need to set the Action on each line as OESCH_ACT_RESCHEDULE
372: -- The Scheduled Dates and the Arrival Date have to be set to NULl

Line 375: oe_debug_pub.add( 'AFTER SETTING THE SCHEDULE STATUS CODE' ) ;

371: -- We need to set the Action on each line as OESCH_ACT_RESCHEDULE
372: -- The Scheduled Dates and the Arrival Date have to be set to NULl
373: -- so that the lines get rescheduled.
374: IF l_debug_level > 0 THEN
375: oe_debug_pub.add( 'AFTER SETTING THE SCHEDULE STATUS CODE' ) ;
376: END IF;
377:
378: -- Code should change for re-structuring purpose. If it a old code
379: -- follow old path or else follow new path.

Line 388: oe_debug_pub.add( 'NEW CODE' , 1 ) ;

384: OPEN Lock_Lines_in_set(Get_Line_set.ship_set_id);
385: CLOSE Lock_Lines_in_set;
386:
387: IF l_debug_level > 0 THEN
388: oe_debug_pub.add( 'NEW CODE' , 1 ) ;
389: END IF;
390: Schedule_Set_Of_lines
391: ( p_x_line_tbl => l_set_line_tbl
392: ,x_old_line_tbl => l_old_line_tbl

Line 412: oe_debug_pub.add( 'INSIDE THE UNEXPECTED ERROR FOR THE FOLLOWING DATA:' ) ;

408: END LOOP;
409:
410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'INSIDE THE UNEXPECTED ERROR FOR THE FOLLOWING DATA:' ) ;
413: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
414: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;
415: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
416: END IF;

Line 413: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||

409:
410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'INSIDE THE UNEXPECTED ERROR FOR THE FOLLOWING DATA:' ) ;
413: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
414: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;
415: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
416: END IF;
417: ROLLBACK TO SAVEPOINT Process_lines_in_set;

Line 415: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;

411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'INSIDE THE UNEXPECTED ERROR FOR THE FOLLOWING DATA:' ) ;
413: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
414: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;
415: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
416: END IF;
417: ROLLBACK TO SAVEPOINT Process_lines_in_set;
418:
419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 421: oe_debug_pub.add( 'INSIDE THE EXPECTED ERROR FOR THE FOLLOWING DATA :' ) ;

417: ROLLBACK TO SAVEPOINT Process_lines_in_set;
418:
419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'INSIDE THE EXPECTED ERROR FOR THE FOLLOWING DATA :' ) ;
422: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
423: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;
424: END IF;
425: ROLLBACK TO SAVEPOINT Process_lines_in_set;

Line 422: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||

418:
419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'INSIDE THE EXPECTED ERROR FOR THE FOLLOWING DATA :' ) ;
422: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
423: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;
424: END IF;
425: ROLLBACK TO SAVEPOINT Process_lines_in_set;
426:

Line 462: oe_debug_pub.add( 'INSIDE THE WHEN OTHERS EXECPTION' ) ;

458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( 'INSIDE THE WHEN OTHERS EXECPTION' ) ;
463: END IF;
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
466: END IF;

Line 465: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;

461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( 'INSIDE THE WHEN OTHERS EXECPTION' ) ;
463: END IF;
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
466: END IF;
467:
468: END Reschedule_Ship_Set;
469: