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',1);

Line 160: oe_debug_pub.add( 'ENTERING PROCESS_CHILD_LINES',1);

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',1);
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: WF_ENGINE.CompleteActivityInternalName(
211: itemtype => 'OEOL',

Line 219: oe_debug_pub.add( 'EXITING PROCESS_CHILD_LINES' , 1 ) ;

215: END LOOP;
216: CLOSE l_ref_cur_line_id;
217: END IF;
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'EXITING PROCESS_CHILD_LINES' , 1 ) ;
220: END IF;
221:
222:
223: END Process_Child_Lines;

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

253: l_request_date DATE;
254: l_sch_ship_date DATE;
255: l_ship_from_org_id NUMBER;
256: l_activity_status_code VARCHAR2(8);
257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
258: l_header_id NUMBER;
259: l_order_source_id NUMBER;
260: l_orig_sys_document_ref VARCHAR2(50);
261: l_orig_sys_line_ref VARCHAR2(50);

Line 279: oe_debug_pub.add( 'TST1: WITHIN SCHEDULE LINE WORKFLOW COVER ' ) ;

275:
276: if (funcmode = 'RUN') then
277:
278: IF l_debug_level > 0 THEN
279: oe_debug_pub.add( 'TST1: WITHIN SCHEDULE LINE WORKFLOW COVER ' ) ;
280: END IF;
281: IF l_debug_level > 0 THEN
282: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
283: END IF;

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

278: IF l_debug_level > 0 THEN
279: oe_debug_pub.add( 'TST1: WITHIN SCHEDULE LINE WORKFLOW COVER ' ) ;
280: END IF;
281: IF l_debug_level > 0 THEN
282: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
283: END IF;
284:
285: OE_STANDARD_WF.Set_Msg_Context(actid);
286:

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

289: -- If it is BULK Mode then no need to query these values from Database
290:
291: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'SCH BULK MODE' , 5 ) ;
294: END IF;
295:
296: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
297:

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

340:
341: ELSE -- If not BULK mode.
342:
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'SCH NON-BULK MODE' , 5 ) ;
345: END IF;
346:
347: --Processing added for Locking
348:

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

399:
400: l_child_line_id := l_line_id;
401:
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'TOP MODEL LINE ID : '||L_TOP_MODEL_LINE_ID , 3 ) ;
404: END IF;
405:
406: IF nvl(l_top_model_line_id,0) <> 0 THEN
407:

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

405:
406: IF nvl(l_top_model_line_id,0) <> 0 THEN
407:
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add( 'LOCKING MODEL '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
410: END IF;
411:
412: SELECT line_id, top_model_line_id
413: INTO l_line_id, l_top_model_line_id

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

415: WHERE line_id = l_top_model_line_id
416: FOR UPDATE;
417:
418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add( 'MODEL LOCKED '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
420: END IF;
421:
422: END IF;
423: -- 3693569: Lock the child line

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

515: l_sch_ship_date is NULL THEN
516:
517: BEGIN
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add( 'CALLING HANDEL_EXTERNAL_LINES IN WF' , 4 ) ;
520: END IF;
521:
522: l_line_rec.line_id := l_line_id;
523: l_line_rec.ato_line_id := l_ato_line_id;

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

530:
531: EXCEPTION
532: WHEN OTHERS THEN
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'SCHEDULING WORFKLOW ERRORS' , 1 ) ;
535: END IF;
536:
537: resultout := 'COMPLETE:INCOMPLETE';
538:

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

678: END IF;
679: END IF; -- 3565621
680: --
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'CALLING CHECK HOLDS' , 1 ) ;
683: END IF;
684:
685: OE_Holds_PUB.Check_Holds
686: ( p_api_version => 1.0

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

700: , x_result_out => l_result
701: );
702:
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;
705: END IF;
706:
707: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
708: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN

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

715: END IF; -- End IF BULK Mode
716:
717: IF (l_result = FND_API.G_TRUE) THEN
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'LINE IS ON HOLD' , 1 ) ;
720: END IF;
721: ROLLBACK TO Before_Lock;
722:
723: -- Start modified for bug 2515791

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

808:
809: -- Parent line is in Schedule Eligible Status set the line status
810: -- to Schedule Eligible.
811: IF l_debug_level > 0 THEN
812: oe_debug_pub.add( 'SMC :PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
813: END IF;
814: ROLLBACK TO Before_Lock;
815: resultout := 'COMPLETE:INCOMPLETE';
816: OE_STANDARD_WF.Save_Messages;

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

851:
852: -- Parent is in Schedule Eligible Status set the line status
853: -- to Schedule Eligible.
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add( 'ATO: PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
856: END IF;
857: ROLLBACK TO Before_Lock;
858: resultout := 'COMPLETE:INCOMPLETE';
859: OE_STANDARD_WF.Save_Messages;

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

897: -- Added this savepoint logic to fix bug 2129583.
898: SAVEPOINT Schedule_line;
899:
900: IF l_debug_level > 0 THEN
901: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL ' , 1 ) ;
902: END IF;
903: OE_SCHEDULE_UTIL.Schedule_Line
904: (p_x_line_rec => l_line_rec
905: ,p_old_line_rec => l_old_line_rec

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

906: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
907: ,x_return_status => l_return_status);
908:
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'L_RETURN_STATUS IS ' || L_RETURN_STATUS , 1 ) ;
911: END IF;
912:
913: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
914: IF l_debug_level > 0 THEN

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

911: END IF;
912:
913: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add( 'SCHEDULING WORFKLOW EXP ERRORS' , 1 ) ;
916: END IF;
917: resultout := 'COMPLETE:INCOMPLETE';
918: -- moved this line up to for the bug fix 2884452
919: ROLLBACK TO SAVEPOINT Schedule_line;

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

932:
933: return;
934: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
935: IF l_debug_level > 0 THEN
936: oe_debug_pub.add( 'SCHEDULING WORFKLOW UN-EXP ERRORS' , 1 ) ;
937: END IF;
938: resultout := 'COMPLETE:INCOMPLETE';
939: -- moved this line up to for the bug fix 2884452
940: ROLLBACK TO SAVEPOINT Schedule_line;

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

1015: -----------------------------------------------------------------------*/
1016: PROCEDURE Bulk_Mode_Copy_Sch_Attribs
1017: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
1018: IS
1019: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1020: l_key NUMBER;
1021: BEGIN
1022:
1023: IF l_debug_level > 0 THEN

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

1020: l_key NUMBER;
1021: BEGIN
1022:
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.add('-- bulk mode set results on global record', 5);
1025: END IF;
1026:
1027: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
1028: -- shippable flag need to be checked based on ship from org.

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

1046: IF OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1047: (OE_BULK_WF_UTIL.G_LINE_INDEX) is NULL AND
1048: p_line_rec.schedule_status_code is not NULL
1049: THEN
1050: oe_debug_pub.add('2 sch bulk mode, set results wf sch',5);
1051: -- need not put original item
1052:
1053: OE_BULK_ORDER_PVT.G_LINE_REC.schedule_status_code
1054: (OE_BULK_WF_UTIL.G_LINE_INDEX) := p_line_rec.schedule_status_code;

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

1079:
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add('-- error in setting global record '|| sqlerrm, 5);
1084: END IF;
1085: RAISE;
1086: END Bulk_Mode_Copy_Sch_Attribs;
1087:

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

1102: l_item_type_code VARCHAR2(30);
1103: l_line_id NUMBER;
1104:
1105: --
1106: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1107: --
1108: BEGIN
1109: --
1110: -- RUN mode - normal process execution

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

1137: IF l_source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL AND
1138: nvl(l_ato_line_id, -1) <> l_line_id
1139: THEN
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'BRANCH: DROPSHIP '|| L_LINE_ID , 2 ) ;
1142: END IF;
1143: resultout := 'COMPLETE:DROPSHIP';
1144: return;
1145:

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

1148: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1149: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
1150: THEN
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1153: END IF;
1154: resultout := 'COMPLETE:BUILD';
1155: return;
1156: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

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

1156: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1157: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION)
1158: THEN
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1161: END IF;
1162: resultout := 'COMPLETE:ATO_ITEM';
1163: return;
1164: END IF;

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

1166: ELSIF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG
1167: AND OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
1168: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
1169: IF l_debug_level > 0 THEN
1170: oe_debug_pub.add( 'BRANCH: ATO ITEM '|| L_LINE_ID , 2 ) ;
1171: END IF;
1172: resultout := 'COMPLETE:ATO_ITEM';
1173: return;
1174: ELSE

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

1172: resultout := 'COMPLETE:ATO_ITEM';
1173: return;
1174: ELSE
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( 'BRANCH: STOCK '|| L_LINE_ID , 2 ) ;
1177: END IF;
1178: resultout := 'COMPLETE:STOCK';
1179: return;
1180: END IF;

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

1241: l_allow_item_desc_update VARCHAR2(1);
1242: l_line_id NUMBER;
1243:
1244: --
1245: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1246: --
1247: BEGIN
1248:
1249: --

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

1251: --
1252: if (funcmode = 'RUN') then
1253:
1254: IF l_debug_level > 0 THEN
1255: oe_debug_pub.add('Entering Release to Purchasing line',1);
1256: END IF;
1257:
1258: OE_STANDARD_WF.Set_Msg_Context(actid);
1259:

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

1292: END IF;
1293:
1294: BEGIN
1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'P1' , 1 ) ;
1297: END IF;
1298: SELECT name
1299: INTO l_order_type_name
1300: FROM oe_order_types_v

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

1300: FROM oe_order_types_v
1301: WHERE order_type_id = l_header_rec.order_type_id;
1302:
1303: IF l_debug_level > 0 THEN
1304: oe_debug_pub.add( 'P2' , 1 ) ;
1305: END IF;
1306: SELECT fu.user_name,nvl(fu.employee_id, -99)
1307: INTO l_user_name,l_employee_id
1308: FROM fnd_user fu

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

1308: FROM fnd_user fu
1309: WHERE fu.user_id = l_line_rec.created_by; --bug 4682158
1310:
1311: IF l_debug_level > 0 THEN
1312: oe_debug_pub.add( 'P3' , 1 ) ;
1313: END IF;
1314: SELECT inventory_asset_flag,expense_account,allow_item_desc_update_flag
1315: into item_asset_flag,item_expense_account,l_allow_item_desc_update
1316: FROM mtl_system_items

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

1317: WHERE inventory_item_id = l_line_rec.inventory_item_id
1318: AND organization_id = l_line_rec.ship_from_org_id;
1319:
1320: IF l_debug_level > 0 THEN
1321: oe_debug_pub.add( 'P4' , 1 ) ;
1322: END IF;
1323: SELECT material_account,expense_account
1324: into org_material_account,org_expense_account
1325: FROM mtl_parameters

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

1325: FROM mtl_parameters
1326: WHERE organization_id = l_line_rec.ship_from_org_id;
1327:
1328: IF l_debug_level > 0 THEN
1329: oe_debug_pub.add( 'P5' , 1 ) ;
1330: END IF;
1331: BEGIN
1332: /* MOAC_SQL_CHANGE */
1333: SELECT LOC.LOCATION_ID

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

1346:
1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'UNABLE TO ASSOCIATE RECEIVING LOCATION ; OEXWSCHB.PLS ' , 1 ) ;
1351: END IF;
1352: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1353: OE_MSG_PUB.Add;
1354: resultout := 'COMPLETE:INCOMPLETE';

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

1370: FOR UPDATE NOWAIT;
1371: EXCEPTION
1372: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
1375: END IF;
1376: resultout := 'DEFERRED';
1377: OE_STANDARD_WF.Clear_Msg_Context;
1378: RETURN;

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

1402: --
1403: END IF; */
1404:
1405: IF l_debug_level > 0 THEN
1406: oe_debug_pub.add('Charge account id : ' ||l_charge_account_id,1);
1407: END IF;
1408:
1409: l_drop_ship_line_rec.header_id := l_line_rec.header_id;
1410: l_drop_ship_line_rec.order_type_name := l_order_type_name;

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

1443:
1444: l_drop_ship_tbl(1) := l_drop_ship_line_rec;
1445:
1446: IF l_debug_level > 0 THEN
1447: oe_debug_pub.add('Calling Purchase Release' ) ;
1448: END IF;
1449:
1450: OE_Purchase_Release_PVT.Purchase_Release
1451: (p_api_version_number => 1.0

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

1457: ,x_msg_data => l_msg_data
1458: );
1459:
1460: IF l_debug_level > 0 THEN
1461: OE_DEBUG_PUB.add('Return status : '||ll_drop_ship_tbl(1).return_status,1);
1462: END IF;
1463:
1464:
1465: -- Fix for the bug2097383

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

1528: l_schedule_status_code VARCHAR2(30);
1529: l_line_category_code VARCHAR2(30);
1530:
1531: --
1532: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1533: --
1534: BEGIN
1535: --
1536: -- RUN mode - normal process execution

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

1538:
1539: if (funcmode = 'RUN') then
1540:
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED WORKFLOW COVER ' ) ;
1543: END IF;
1544:
1545: IF l_debug_level > 0 THEN
1546: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;

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

1542: oe_debug_pub.add( 'ENTERING IS_LINE_SCHEDULED WORKFLOW COVER ' ) ;
1543: END IF;
1544:
1545: IF l_debug_level > 0 THEN
1546: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
1547: END IF;
1548:
1549: OE_STANDARD_WF.Set_Msg_Context(actid);
1550:

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

1621: --
1622: -- RUN mode - normal process execution
1623: --
1624:
1625: oe_debug_pub.add('Entering Is_Line_Firmed Workflow cover ',1 );
1626: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1627: if (funcmode = 'RUN') then
1628:
1629:

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

1626: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1627: if (funcmode = 'RUN') then
1628:
1629:
1630: oe_debug_pub.add('Item Key is ' || itemkey );
1631: OE_STANDARD_WF.Set_Msg_Context(actid);
1632:
1633:
1634: BEGIN

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

1680: END IF; -- Relase control.
1681: return;
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: oe_debug_pub.add('Error in Workflow',1);
1685: wf_core.context('OE_OEOL_SCH', 'Is_Line_Firmed',
1686: itemtype, itemkey, to_char(actid), funcmode);
1687: -- start data fix project
1688: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

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

1726:
1727: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1728: IF (funcmode = 'RUN') THEN
1729:
1730: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );
1731: oe_debug_pub.add('Item Key is ' || itemkey );
1732:
1733: OE_STANDARD_WF.Set_Msg_Context(actid);
1734:

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

1727: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
1728: IF (funcmode = 'RUN') THEN
1729:
1730: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );
1731: oe_debug_pub.add('Item Key is ' || itemkey );
1732:
1733: OE_STANDARD_WF.Set_Msg_Context(actid);
1734:
1735: Select firm_demand_flag, top_model_line_id, ato_line_id,

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

1741:
1742: IF Nvl(l_firm_demand_flag,'N') = 'N' THEN
1743: IF l_ship_model_complete_flag= 'Y' THEN
1744:
1745: oe_debug_pub.add('Top model' || l_top_model_line_id );
1746: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1747: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1748: Select firm_demand_flag
1749: Into l_firm_demand_flag

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

1742: IF Nvl(l_firm_demand_flag,'N') = 'N' THEN
1743: IF l_ship_model_complete_flag= 'Y' THEN
1744:
1745: oe_debug_pub.add('Top model' || l_top_model_line_id );
1746: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1747: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1748: Select firm_demand_flag
1749: Into l_firm_demand_flag
1750: From oe_order_lines

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

1743: IF l_ship_model_complete_flag= 'Y' THEN
1744:
1745: oe_debug_pub.add('Top model' || l_top_model_line_id );
1746: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1747: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1748: Select firm_demand_flag
1749: Into l_firm_demand_flag
1750: From oe_order_lines
1751: Where line_id = l_top_model_line_id

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

1818: END IF;
1819:
1820: ELSE
1821:
1822: oe_debug_pub.add('Line is already firmed' );
1823:
1824: END IF;
1825: resultout := 'COMPLETE:COMPLETE';
1826: OE_STANDARD_WF.Clear_Msg_Context;

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

1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: wf_core.context('OE_OEOL_SCH', 'Firm_Demand',
1839: itemtype, itemkey, to_char(actid), funcmode);
1840: oe_debug_pub.add('error in workflow');
1841: -- start data fix project
1842: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1843: p_itemtype => itemtype,
1844: p_itemkey => itemkey);