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

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

24: RETURN BOOLEAN
25: IS
26: l_activity_status VARCHAR2(8) := null;
27: --
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: BEGIN
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'ENTERING IS_SCHEDULING_ELIGIBLE: ' || P_LINE_ID , 1 ) ;

Line 32: oe_debug_pub.add( 'ENTERING IS_SCHEDULING_ELIGIBLE: ' || P_LINE_ID , 1 ) ;

28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: BEGIN
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'ENTERING IS_SCHEDULING_ELIGIBLE: ' || P_LINE_ID , 1 ) ;
33: END IF;
34: IF NOT OE_GLOBALS.Equal(p_line_id,
35: sch_elg_cached_line_id)
36: THEN

Line 52: oe_debug_pub.add( 'EXITING IS_SCHEDULING_ELIGIBLE ' , 1 ) ;

48: sch_cached_elg_status := l_activity_status;
49: END IF;
50:
51: IF l_debug_level > 0 THEN
52: oe_debug_pub.add( 'EXITING IS_SCHEDULING_ELIGIBLE ' , 1 ) ;
53: END IF;
54:
55: IF sch_cached_elg_status = 'NOTIFIED'
56: THEN

Line 58: oe_debug_pub.add( 'Line is in schedule Eligible stage ' , 1 ) ;

54:
55: IF sch_cached_elg_status = 'NOTIFIED'
56: THEN
57: IF l_debug_level > 0 THEN
58: oe_debug_pub.add( 'Line is in schedule Eligible stage ' , 1 ) ;
59: END IF;
60: RETURN TRUE;
61: ELSE
62: IF l_debug_level > 0 THEN

Line 63: oe_debug_pub.add( 'Line is not in schedule Eligible stage' , 1 ) ;

59: END IF;
60: RETURN TRUE;
61: ELSE
62: IF l_debug_level > 0 THEN
63: oe_debug_pub.add( 'Line is not in schedule Eligible stage' , 1 ) ;
64: END IF;
65: RETURN FALSE;
66: END IF;
67:

Line 71: oe_debug_pub.add( 'IN EXCEPTION OF IS_SCHEDULING_ELIGIBLE' , 1 ) ;

67:
68: EXCEPTION
69: WHEN OTHERS THEN
70: IF l_debug_level > 0 THEN
71: oe_debug_pub.add( 'IN EXCEPTION OF IS_SCHEDULING_ELIGIBLE' , 1 ) ;
72: END IF;
73: RETURN FALSE;
74: END Is_Scheduling_Eligible;
75:

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

82: IS
83: l_schedule_status_code VARCHAR2(30) := null;
84: l_source_type_code VARCHAR2(30) := null; -- Added for bug 5880264
85: --
86: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
87: --
88: BEGIN
89:
90: IF l_debug_level > 0 THEN

Line 91: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED: ' || P_LINE_ID , 1 ) ;

87: --
88: BEGIN
89:
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED: ' || P_LINE_ID , 1 ) ;
92: END IF;
93: IF NOT OE_GLOBALS.Equal(p_line_id,
94: sch_cached_line_id)
95: THEN

Line 110: oe_debug_pub.add( 'EXITING IS_LINE_SCHEDULED ' , 1 ) ;

106: sch_cached_source_type_code := l_source_type_code; -- Added for bug 5880264
107: END IF;
108:
109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add( 'EXITING IS_LINE_SCHEDULED ' , 1 ) ;
111: END IF;
112:
113: -- Added source_type_code condition in the below IF for bug 5880264
114: IF sch_cached_sch_status_code IS NOT NULL OR sch_cached_source_type_code = 'EXTERNAL'

Line 117: oe_debug_pub.add( 'Line is scheduled ' , 1 ) ;

113: -- Added source_type_code condition in the below IF for bug 5880264
114: IF sch_cached_sch_status_code IS NOT NULL OR sch_cached_source_type_code = 'EXTERNAL'
115: THEN
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( 'Line is scheduled ' , 1 ) ;
118: END IF;
119: RETURN TRUE;
120: ELSE
121: IF l_debug_level > 0 THEN

Line 122: oe_debug_pub.add( 'Line is not scheduled ' , 1 ) ;

118: END IF;
119: RETURN TRUE;
120: ELSE
121: IF l_debug_level > 0 THEN
122: oe_debug_pub.add( 'Line is not scheduled ' , 1 ) ;
123: END IF;
124: RETURN FALSE;
125: END IF;
126:

Line 131: oe_debug_pub.add( 'IN EXCEPTION OF IS_LINE_SCHEDULED' , 1 ) ;

127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'IN EXCEPTION OF IS_LINE_SCHEDULED' , 1 ) ;
132: END IF;
133: RETURN FALSE;
134:
135: END Is_Line_Scheduled;

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

152: l_where_clause VARCHAR2(200) := NULL;
153: l_line_id NUMBER;
154: l_model_id NUMBER;
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'ENTERING PROCESS_CHILD_LINES',0.5); -- debug level changed to 0.5 for bug 13435459

Line 160: oe_debug_pub.add( 'ENTERING PROCESS_CHILD_LINES',0.5); -- debug level changed to 0.5 for bug 13435459

156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'ENTERING PROCESS_CHILD_LINES',0.5); -- debug level changed to 0.5 for bug 13435459
161: END IF;
162:
163: IF NVL(p_ship_model_complete_flag,'N') = 'Y'
164: AND p_top_model_line_id = p_line_id

Line 207: oe_debug_pub.add( 'Processing Line '||l_line_id , 1 ) ;

203: EXIT WHEN l_ref_cur_line_id%NOTFOUND;
204:
205: -- Processing the lines
206: IF l_debug_level > 0 THEN
207: oe_debug_pub.add( 'Processing Line '||l_line_id , 1 ) ;
208: END IF;
209:
210: BEGIN --15870313
211: WF_ENGINE.CompleteActivityInternalName(

Line 219: oe_debug_pub.add('Workflow complete activity failed. Raising');

215: result => 'COMPLETED',
216: raise_engine_exception => TRUE );
217: EXCEPTION
218: WHEN OTHERS THEN
219: oe_debug_pub.add('Workflow complete activity failed. Raising');
220: RAISE ;
221: END ;
222: END LOOP;
223: CLOSE l_ref_cur_line_id;

Line 226: oe_debug_pub.add( 'EXITING PROCESS_CHILD_LINES' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

222: END LOOP;
223: CLOSE l_ref_cur_line_id;
224: END IF;
225: IF l_debug_level > 0 THEN
226: oe_debug_pub.add( 'EXITING PROCESS_CHILD_LINES' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
227: END IF;
228:
229:
230: END Process_Child_Lines;

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

260: l_request_date DATE;
261: l_sch_ship_date DATE;
262: l_ship_from_org_id NUMBER;
263: l_activity_status_code VARCHAR2(8);
264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
265: l_header_id NUMBER;
266: l_order_source_id NUMBER;
267: l_orig_sys_document_ref VARCHAR2(50);
268: l_orig_sys_line_ref VARCHAR2(50);

Line 293: oe_debug_pub.add( 'TST1: WITHIN SCHEDULE LINE WORKFLOW COVER ',0.5 ) ; -- debug level 0.5 added for bug 13435459

289:
290: if (funcmode = 'RUN') then
291:
292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'TST1: WITHIN SCHEDULE LINE WORKFLOW COVER ',0.5 ) ; -- debug level 0.5 added for bug 13435459
294: END IF;
295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
297: END IF;

Line 296: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;

292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'TST1: WITHIN SCHEDULE LINE WORKFLOW COVER ',0.5 ) ; -- debug level 0.5 added for bug 13435459
294: END IF;
295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
297: END IF;
298:
299: OE_STANDARD_WF.Set_Msg_Context(actid);
300:

Line 307: oe_debug_pub.add( 'SCH BULK MODE' , 5 ) ;

303: -- If it is BULK Mode then no need to query these values from Database
304:
305: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
306: IF l_debug_level > 0 THEN
307: oe_debug_pub.add( 'SCH BULK MODE' , 5 ) ;
308: END IF;
309:
310: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
311:

Line 358: oe_debug_pub.add( 'SCH NON-BULK MODE' , 5 ) ;

354:
355: ELSE -- If not BULK mode.
356:
357: IF l_debug_level > 0 THEN
358: oe_debug_pub.add( 'SCH NON-BULK MODE' , 5 ) ;
359: END IF;
360:
361: --Processing added for Locking
362:

Line 423: oe_debug_pub.add( 'TOP MODEL LINE ID : '||L_TOP_MODEL_LINE_ID , 3 ) ;

419:
420: l_child_line_id := l_line_id;
421:
422: IF l_debug_level > 0 THEN
423: oe_debug_pub.add( 'TOP MODEL LINE ID : '||L_TOP_MODEL_LINE_ID , 3 ) ;
424: END IF;
425:
426: IF nvl(l_top_model_line_id,0) <> 0 THEN
427:

Line 429: oe_debug_pub.add( 'LOCKING MODEL '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;

425:
426: IF nvl(l_top_model_line_id,0) <> 0 THEN
427:
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'LOCKING MODEL '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
430: END IF;
431:
432: BEGIN
433: SELECT line_id, top_model_line_id

Line 440: oe_debug_pub.add( 'MODEL LOCKED '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;

436: WHERE line_id = l_top_model_line_id
437: FOR UPDATE NOWAIT; --11868761
438:
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add( 'MODEL LOCKED '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
441: END IF;
442: EXCEPTION
443: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
444: IF l_debug_level > 0 THEN

Line 445: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the top model line:'||l_top_model_line_id,1);

441: END IF;
442: EXCEPTION
443: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the top model line:'||l_top_model_line_id,1);
446: END IF;
447: resultout := 'COMPLETE:INCOMPLETE';
448: OE_STANDARD_WF.Clear_Msg_Context;
449: RETURN;

Line 463: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the line:'||l_child_line_id,1);

459:
460: EXCEPTION
461: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the line:'||l_child_line_id,1);
464: END IF;
465: resultout := 'COMPLETE:INCOMPLETE';
466: OE_STANDARD_WF.Clear_Msg_Context;
467: RETURN;

Line 560: oe_debug_pub.add( 'CALLING HANDEL_EXTERNAL_LINES IN WF' , 4 ) ;

556: l_sch_ship_date is NULL THEN
557:
558: BEGIN
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add( 'CALLING HANDEL_EXTERNAL_LINES IN WF' , 4 ) ;
561: END IF;
562:
563: l_line_rec.line_id := l_line_id;
564: l_line_rec.ato_line_id := l_ato_line_id;

Line 575: oe_debug_pub.add( 'SCHEDULING WORFKLOW ERRORS' , 1 ) ;

571:
572: EXCEPTION
573: WHEN OTHERS THEN
574: IF l_debug_level > 0 THEN
575: oe_debug_pub.add( 'SCHEDULING WORFKLOW ERRORS' , 1 ) ;
576: END IF;
577:
578: resultout := 'COMPLETE:INCOMPLETE';
579:

Line 611: oe_debug_pub.add( '..SMC=Y, Line not Top Model..' , 3 ) ;

607: AND NOT OE_GLOBALS.Equal(l_top_model_line_id,
608: l_line_id)
609: THEN -- SMC
610: IF l_debug_level > 0 THEN
611: oe_debug_pub.add( '..SMC=Y, Line not Top Model..' , 3 ) ;
612: END IF;
613:
614: l_scheduled := Is_Line_Scheduled(l_top_model_line_id);
615:

Line 653: oe_debug_pub.add( '..ATO Line, Line not Top Model..' , 3 ) ;

649: AND NOT OE_GLOBALS.Equal(l_ato_line_id,
650: l_line_id)
651: THEN -- ATO
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( '..ATO Line, Line not Top Model..' , 3 ) ;
654: END IF;
655: l_scheduled := Is_Line_Scheduled(l_ato_line_id);
656: IF NOT l_scheduled
657: THEN

Line 693: oe_debug_pub.add( '..SMC=N, Included Item..' , 3 ) ;

689: AND l_item_type_code ='INCLUDED'
690: AND NOT oe_line_util.Is_Subscription_Service_Line(l_link_to_line_id) -- sol_ord_er #16014165
691: THEN -- Non SMC
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( '..SMC=N, Included Item..' , 3 ) ;
694: END IF;
695: l_scheduled := Is_Line_Scheduled(l_link_to_line_id);
696: IF NOT l_scheduled
697: THEN

Line 734: oe_debug_pub.add( 'CALLING CHECK HOLDS' , 1 ) ;

730: END IF; -- 3565621
731: --
732: IF NVL(OE_SCH_CONC_REQUESTS.g_checked_for_holds, 'N') <> 'Y' THEN -- ER 13114460
733: IF l_debug_level > 0 THEN
734: oe_debug_pub.add( 'CALLING CHECK HOLDS' , 1 ) ;
735: END IF;
736:
737: OE_Holds_PUB.Check_Holds
738: ( p_api_version => 1.0

Line 756: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;

752: , x_result_out => l_result
753: );
754:
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;
757: END IF;
758:
759: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN

Line 768: oe_debug_pub.add('Coming from CP, Line checked for holds already');

764: END IF;
765: END IF;
766: ELSE -- ER 13114460
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add('Coming from CP, Line checked for holds already');
769: END IF;
770: END IF;
771:
772: END IF; -- End IF BULK Mode

Line 776: oe_debug_pub.add( 'LINE IS ON HOLD' , 1 ) ;

772: END IF; -- End IF BULK Mode
773:
774: IF (l_result = FND_API.G_TRUE) THEN
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'LINE IS ON HOLD' , 1 ) ;
777: END IF;
778: ROLLBACK TO Before_Lock;
779:
780: -- Start modified for bug 2515791

Line 869: oe_debug_pub.add( 'SMC :PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;

865:
866: -- Parent line is in Schedule Eligible Status set the line status
867: -- to Schedule Eligible.
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( 'SMC :PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
870: END IF;
871: ROLLBACK TO Before_Lock;
872: resultout := 'COMPLETE:INCOMPLETE';
873: OE_STANDARD_WF.Save_Messages;

Line 912: oe_debug_pub.add( 'ATO: PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;

908:
909: -- Parent is in Schedule Eligible Status set the line status
910: -- to Schedule Eligible.
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add( 'ATO: PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
913: END IF;
914: ROLLBACK TO Before_Lock;
915: resultout := 'COMPLETE:INCOMPLETE';
916: OE_STANDARD_WF.Save_Messages;

Line 968: oe_debug_pub.add( 'BEFORE CALLING Schedule_Multi_lines ' , 1 ) ;

964: OR l_item_type_code IN('MODEL','CLASS','KIT'))
965: AND NVL(l_line_rec.subscription_enable_flag,'N')='N') THEN -- sol_ord_er #16014165
966:
967: IF l_debug_level > 0 THEN
968: oe_debug_pub.add( 'BEFORE CALLING Schedule_Multi_lines ' , 1 ) ;
969: END IF;
970: l_selected_line_tbl(1).id1 :=l_line_rec.line_id;
971: l_selected_line_tbl(1).org_id :=l_line_rec.org_id;
972: l_line_count := 1;

Line 984: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL ' , 1 ) ;

980: x_msg_data => l_msg_data);
981:
982: ELSIF l_schedule_status_code is null THEN
983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL ' , 1 ) ;
985: END IF;
986: OE_SCHEDULE_UTIL.Schedule_Line
987: (p_x_line_rec => l_line_rec
988: ,p_old_line_rec => l_old_line_rec

Line 993: oe_debug_pub.add( 'L_RETURN_STATUS IS ' || L_RETURN_STATUS , 1 ) ;

989: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
990: ,x_return_status => l_return_status);
991: END IF;
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( 'L_RETURN_STATUS IS ' || L_RETURN_STATUS , 1 ) ;
994: END IF;
995: --11825106
996: IF l_ship_set_id IS NULL AND
997: l_Arrival_set_id IS NULL AND

Line 1005: oe_debug_pub.add( 'DELETING oe_schedule_lines_temp ' , 1 ) ;

1001: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1002: -- Clear oe_schedule_lines_temp table.
1003: BEGIN
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add( 'DELETING oe_schedule_lines_temp ' , 1 ) ;
1006: END IF;
1007: DELETE FROM oe_schedule_lines_temp;
1008: EXCEPTION
1009: WHEN OTHERS THEN

Line 1014: oe_debug_pub.add( 'SCHEDULING WORFKLOW EXP ERRORS' , 1 ) ;

1010: NULL;
1011: END;
1012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'SCHEDULING WORFKLOW EXP ERRORS' , 1 ) ;
1015: END IF;
1016: resultout := 'COMPLETE:INCOMPLETE';
1017: --8731703
1018: -- Rollback the demand for success lines.

Line 1021: oe_debug_pub.add( 'MRP Rollback result '||l_return_status , 1 ) ;

1017: --8731703
1018: -- Rollback the demand for success lines.
1019: OE_SCHEDULE_UTIL.CALL_MRP_ROLLBACK (x_return_status => l_return_status);
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( 'MRP Rollback result '||l_return_status , 1 ) ;
1022: END IF;
1023: -- moved this line up to for the bug fix 2884452
1024: ROLLBACK TO SAVEPOINT Schedule_line;
1025: OE_STANDARD_WF.Save_Messages;

Line 1041: oe_debug_pub.add( 'SCHEDULING WORFKLOW UN-EXP ERRORS' , 1 ) ;

1037:
1038: return;
1039: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1040: IF l_debug_level > 0 THEN
1041: oe_debug_pub.add( 'SCHEDULING WORFKLOW UN-EXP ERRORS' , 1 ) ;
1042: END IF;
1043: resultout := 'COMPLETE:INCOMPLETE';
1044: -- moved this line up to for the bug fix 2884452
1045: ROLLBACK TO SAVEPOINT Schedule_line;

Line 1111: oe_debug_pub.add( 'Exiting TST1: SCHEDULE LINE WORKFLOW COVER ',0.5 ) ;

1107: null;
1108: return;
1109: END IF;
1110: IF l_debug_level > 0 THEN -- Added debug for bug 13435459
1111: oe_debug_pub.add( 'Exiting TST1: SCHEDULE LINE WORKFLOW COVER ',0.5 ) ;
1112: END IF;
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN

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

1135: -----------------------------------------------------------------------*/
1136: PROCEDURE Bulk_Mode_Copy_Sch_Attribs
1137: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
1138: IS
1139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1140: l_key NUMBER;
1141: BEGIN
1142:
1143: IF l_debug_level > 0 THEN

Line 1144: oe_debug_pub.add('-- bulk mode set results on global record', 5);

1140: l_key NUMBER;
1141: BEGIN
1142:
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('-- bulk mode set results on global record', 5);
1145: END IF;
1146:
1147: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
1148: -- shippable flag need to be checked based on ship from org.

Line 1170: oe_debug_pub.add('2 sch bulk mode, set results wf sch',5);

1166: IF OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1167: (OE_BULK_WF_UTIL.G_LINE_INDEX) is NULL AND
1168: p_line_rec.schedule_status_code is not NULL
1169: THEN
1170: oe_debug_pub.add('2 sch bulk mode, set results wf sch',5);
1171: -- need not put original item
1172:
1173: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1174: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_status_code;

Line 1203: oe_debug_pub.add('-- error in setting global record '|| sqlerrm, 5);

1199:
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: IF l_debug_level > 0 THEN
1203: oe_debug_pub.add('-- error in setting global record '|| sqlerrm, 5);
1204: END IF;
1205: RAISE;
1206: END Bulk_Mode_Copy_Sch_Attribs;
1207:

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

1222: l_item_type_code VARCHAR2(30);
1223: l_line_id NUMBER;
1224:
1225: --
1226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1227: --
1228: BEGIN
1229: --
1230: -- RUN mode - normal process execution

Line 1261: oe_debug_pub.add( 'BRANCH: DROPSHIP '|| L_LINE_ID , 2 ) ;

1257: IF l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND
1258: nvl(l_ato_line_id, -1) <> l_line_id
1259: THEN
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add( 'BRANCH: DROPSHIP '|| L_LINE_ID , 2 ) ;
1262: END IF;
1263: resultout := 'COMPLETE:DROPSHIP';
1264: return;
1265:

Line 1272: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;

1268: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1269: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
1270: THEN
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1273: END IF;
1274: resultout := 'COMPLETE:BUILD';
1275: return;
1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

Line 1281: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;

1277: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1278: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
1279: THEN
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1282: END IF;
1283: resultout := 'COMPLETE:ATO_ITEM';
1284: return;
1285: END IF;

Line 1291: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;

1287: ELSIF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG
1288: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
1289: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
1290: IF l_debug_level > 0 THEN
1291: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1292: END IF;
1293: resultout := 'COMPLETE:ATO_ITEM';
1294: return;
1295: ELSE

Line 1297: oe_debug_pub.add( 'BRANCH: STOCK '|| L_LINE_ID , 2 ) ;

1293: resultout := 'COMPLETE:ATO_ITEM';
1294: return;
1295: ELSE
1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add( 'BRANCH: STOCK '|| L_LINE_ID , 2 ) ;
1298: END IF;
1299: resultout := 'COMPLETE:STOCK';
1300: return;
1301: END IF;

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

1362: l_allow_item_desc_update VARCHAR2(1);
1363: l_line_id NUMBER;
1364:
1365: --
1366: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1367: --
1368: BEGIN
1369:
1370: --

Line 1376: oe_debug_pub.add('Entering Release to Purchasing line',1);

1372: --
1373: if (funcmode = 'RUN') then
1374:
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add('Entering Release to Purchasing line',1);
1377: END IF;
1378:
1379: OE_STANDARD_WF.Set_Msg_Context(actid);
1380:

Line 1417: oe_debug_pub.add( 'P1' , 1 ) ;

1413: END IF;
1414:
1415: BEGIN
1416: IF l_debug_level > 0 THEN
1417: oe_debug_pub.add( 'P1' , 1 ) ;
1418: END IF;
1419: SELECT name
1420: INTO l_order_type_name
1421: FROM oe_order_types_v

Line 1425: oe_debug_pub.add( 'P2' , 1 ) ;

1421: FROM oe_order_types_v
1422: WHERE order_type_id = l_header_rec.order_type_id;
1423:
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'P2' , 1 ) ;
1426: END IF;
1427: SELECT fu.user_name,nvl(fu.employee_id, -99)
1428: INTO l_user_name,l_employee_id
1429: FROM fnd_user fu

Line 1433: oe_debug_pub.add( 'P3' , 1 ) ;

1429: FROM fnd_user fu
1430: WHERE fu.user_id = l_line_rec.created_by; --bug 4682158
1431:
1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add( 'P3' , 1 ) ;
1434: END IF;
1435: SELECT inventory_asset_flag,expense_account,allow_item_desc_update_flag
1436: into item_asset_flag,item_expense_account,l_allow_item_desc_update
1437: FROM mtl_system_items

Line 1442: oe_debug_pub.add( 'P4' , 1 ) ;

1438: WHERE inventory_item_id = l_line_rec.inventory_item_id
1439: AND organization_id = l_line_rec.ship_from_org_id;
1440:
1441: IF l_debug_level > 0 THEN
1442: oe_debug_pub.add( 'P4' , 1 ) ;
1443: END IF;
1444: SELECT material_account,expense_account
1445: into org_material_account,org_expense_account
1446: FROM mtl_parameters

Line 1450: oe_debug_pub.add( 'P5' , 1 ) ;

1446: FROM mtl_parameters
1447: WHERE organization_id = l_line_rec.ship_from_org_id;
1448:
1449: IF l_debug_level > 0 THEN
1450: oe_debug_pub.add( 'P5' , 1 ) ;
1451: END IF;
1452: BEGIN
1453: /* MOAC_SQL_CHANGE */
1454: SELECT LOC.LOCATION_ID

Line 1471: oe_debug_pub.add( 'UNABLE TO ASSOCIATE RECEIVING LOCATION ; OEXWSCHB.PLS ' , 1 ) ;

1467:
1468: EXCEPTION
1469: WHEN NO_DATA_FOUND THEN
1470: IF l_debug_level > 0 THEN
1471: oe_debug_pub.add( 'UNABLE TO ASSOCIATE RECEIVING LOCATION ; OEXWSCHB.PLS ' , 1 ) ;
1472: END IF;
1473: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1474: OE_MSG_PUB.Add;
1475: resultout := 'COMPLETE:INCOMPLETE';

Line 1495: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);

1491: FOR UPDATE NOWAIT;
1492: EXCEPTION
1493: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1494: IF l_debug_level > 0 THEN
1495: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
1496: END IF;
1497: resultout := 'DEFERRED';
1498: OE_STANDARD_WF.Clear_Msg_Context;
1499: RETURN;

Line 1527: oe_debug_pub.add('Charge account id : ' ||l_charge_account_id,1);

1523: --
1524: END IF; */
1525:
1526: IF l_debug_level > 0 THEN
1527: oe_debug_pub.add('Charge account id : ' ||l_charge_account_id,1);
1528: END IF;
1529:
1530: l_drop_ship_line_rec.header_id := l_line_rec.header_id;
1531: l_drop_ship_line_rec.order_type_name := l_order_type_name;

Line 1568: oe_debug_pub.add('Calling Purchase Release' ) ;

1564:
1565: l_drop_ship_tbl(1) := l_drop_ship_line_rec;
1566:
1567: IF l_debug_level > 0 THEN
1568: oe_debug_pub.add('Calling Purchase Release' ) ;
1569: END IF;
1570:
1571: OE_Purchase_Release_PVT.Purchase_Release
1572: (p_api_version_number => 1.0

Line 1582: OE_DEBUG_PUB.add('Return status : '||ll_drop_ship_tbl(1).return_status,1);

1578: ,x_msg_data => l_msg_data
1579: );
1580:
1581: IF l_debug_level > 0 THEN
1582: OE_DEBUG_PUB.add('Return status : '||ll_drop_ship_tbl(1).return_status,1);
1583: END IF;
1584:
1585:
1586: -- Fix for the bug2097383

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

1650: l_line_category_code VARCHAR2(30);
1651: l_subscription_enable_flag CHAR(1) := ''; --sol_ord_er #16014165
1652:
1653: --
1654: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1655: --
1656: BEGIN
1657: --
1658: -- RUN mode - normal process execution

Line 1664: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED WORKFLOW COVER ' ) ;

1660:
1661: if (funcmode = 'RUN') then
1662:
1663: IF l_debug_level > 0 THEN
1664: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED WORKFLOW COVER ' ) ;
1665: END IF;
1666:
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;

Line 1668: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;

1664: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED WORKFLOW COVER ' ) ;
1665: END IF;
1666:
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
1669: END IF;
1670:
1671: OE_STANDARD_WF.Set_Msg_Context(actid);
1672:

Line 1752: oe_debug_pub.add('Entering Is_Line_Firmed Workflow cover ',1 );

1748: --
1749: -- RUN mode - normal process execution
1750: --
1751:
1752: oe_debug_pub.add('Entering Is_Line_Firmed Workflow cover ',1 );
1753: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1754: if (funcmode = 'RUN') then
1755:
1756:

Line 1757: oe_debug_pub.add('Item Key is ' || itemkey );

1753: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1754: if (funcmode = 'RUN') then
1755:
1756:
1757: oe_debug_pub.add('Item Key is ' || itemkey );
1758: OE_STANDARD_WF.Set_Msg_Context(actid);
1759:
1760:
1761: BEGIN

Line 1815: oe_debug_pub.add('Error in Workflow',1);

1811: END IF; -- Relase control.
1812: return;
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: oe_debug_pub.add('Error in Workflow',1);
1816: wf_core.context('OE_OEOL_SCH', 'Is_Line_Firmed',
1817: itemtype, itemkey, to_char(actid), funcmode);
1818: -- start data fix project
1819: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

Line 1861: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );

1857:
1858: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1859: IF (funcmode = 'RUN') THEN
1860:
1861: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );
1862: oe_debug_pub.add('Item Key is ' || itemkey );
1863:
1864: OE_STANDARD_WF.Set_Msg_Context(actid);
1865:

Line 1862: oe_debug_pub.add('Item Key is ' || itemkey );

1858: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1859: IF (funcmode = 'RUN') THEN
1860:
1861: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );
1862: oe_debug_pub.add('Item Key is ' || itemkey );
1863:
1864: OE_STANDARD_WF.Set_Msg_Context(actid);
1865:
1866: Select firm_demand_flag, top_model_line_id, ato_line_id,

Line 1876: oe_debug_pub.add('Top model' || l_top_model_line_id );

1872:
1873: IF Nvl(l_firm_demand_flag,'N') = 'N' THEN
1874: IF l_ship_model_complete_flag= 'Y' THEN
1875:
1876: oe_debug_pub.add('Top model' || l_top_model_line_id );
1877: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1878: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1879: Select firm_demand_flag
1880: Into l_firm_demand_flag

Line 1877: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );

1873: IF Nvl(l_firm_demand_flag,'N') = 'N' THEN
1874: IF l_ship_model_complete_flag= 'Y' THEN
1875:
1876: oe_debug_pub.add('Top model' || l_top_model_line_id );
1877: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1878: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1879: Select firm_demand_flag
1880: Into l_firm_demand_flag
1881: From oe_order_lines

Line 1878: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );

1874: IF l_ship_model_complete_flag= 'Y' THEN
1875:
1876: oe_debug_pub.add('Top model' || l_top_model_line_id );
1877: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1878: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1879: Select firm_demand_flag
1880: Into l_firm_demand_flag
1881: From oe_order_lines
1882: Where line_id = l_top_model_line_id

Line 1902: oe_debug_pub.add('Workflow complete activity failed. Raising');

1898: result => 'COMPLETED',
1899: raise_engine_exception => TRUE );
1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: oe_debug_pub.add('Workflow complete activity failed. Raising');
1903: RAISE ;
1904: END ;
1905: END IF;
1906: END LOOP;

Line 1937: oe_debug_pub.add('Workflow complete activity failed. Raising');

1933: result => 'COMPLETED',
1934: raise_engine_exception => TRUE);
1935: exception
1936: WHEN OTHERS THEN
1937: oe_debug_pub.add('Workflow complete activity failed. Raising');
1938: RAISE ;
1939: END ;
1940: END IF;
1941: END LOOP;

Line 1967: oe_debug_pub.add('Line is already firmed' );

1963: END IF;
1964:
1965: ELSE
1966:
1967: oe_debug_pub.add('Line is already firmed' );
1968:
1969: END IF;
1970: resultout := 'COMPLETE:COMPLETE';
1971: OE_STANDARD_WF.Clear_Msg_Context;

Line 1985: oe_debug_pub.add('error in workflow');

1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: wf_core.context('OE_OEOL_SCH', 'Firm_Demand',
1984: itemtype, itemkey, to_char(actid), funcmode);
1985: oe_debug_pub.add('error in workflow');
1986: -- start data fix project
1987: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1988: p_itemtype => itemtype,
1989: p_itemkey => itemkey);