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

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

13: ,p_line_id IN NUMBER)
14: RETURN BOOLEAN
15: IS
16: l_found BOOLEAN:= FALSE;
17: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18: BEGIN
19:
20: /* If many of the lines selected are part of a smc/ato/non-smc model, then delayed
21: * request must get logged only for one of the lines.

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

31: FUNCTION included_processed(p_inc_item_id IN NUMBER)
32: RETURN BOOLEAN
33: IS
34: l_found BOOLEAN:= FALSE;
35: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
36: BEGIN
37:
38: /* to list the included items processed alone
39: */

Line 41: OE_DEBUG_PUB.Add('INSIDE INCLUDED_PROCESSED',1);

37:
38: /* to list the included items processed alone
39: */
40: IF l_debug_level > 0 THEN
41: OE_DEBUG_PUB.Add('INSIDE INCLUDED_PROCESSED',1);
42: END IF;
43:
44: IF oe_included_id_tbl.EXISTS(p_inc_item_id) THEN
45: l_found := TRUE;

Line 51: OE_DEBUG_PUB.Add('INCLIDED ITEM LISTED',1);

47: oe_included_id_tbl(p_inc_item_id) := p_inc_item_id;
48: END IF;
49: IF l_found THEN
50: IF l_debug_level > 0 THEN
51: OE_DEBUG_PUB.Add('INCLIDED ITEM LISTED',1);
52: END IF;
53: ELSE
54: IF l_debug_level > 0 THEN
55: OE_DEBUG_PUB.Add('INCLIDED ITEM NOT LISTED',1);

Line 55: OE_DEBUG_PUB.Add('INCLIDED ITEM NOT LISTED',1);

51: OE_DEBUG_PUB.Add('INCLIDED ITEM LISTED',1);
52: END IF;
53: ELSE
54: IF l_debug_level > 0 THEN
55: OE_DEBUG_PUB.Add('INCLIDED ITEM NOT LISTED',1);
56: END IF;
57: END IF;
58: RETURN (l_found);
59: END included_processed;

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

61: FUNCTION set_processed(p_set_id IN NUMBER)
62: RETURN BOOLEAN
63: IS
64: l_found BOOLEAN:= FALSE;
65: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
66: BEGIN
67:
68: /* If many of the lines selected are part of a ship set / Arrival set, then delayed
69: * request must get logged only for one of the lines.

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

79: FUNCTION Line_Eligible (p_line_id IN NUMBER)
80: RETURN BOOLEAN
81: IS
82: l_activity_status_code VARCHAR2(8);
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: BEGIN
85:
86: -- Check for workflow status to be Purchase Release Eligible
87: SELECT ACTIVITY_STATUS

Line 103: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;

99:
100: EXCEPTION
101: WHEN NO_DATA_FOUND THEN
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;
104: END IF;
105: RETURN FALSE;
106: WHEN OTHERS THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

153: l_atp_tbl OE_ATP.Atp_Tbl_Type;
154: l_booked_flag VARCHAR2(1);
155: l_control_rec OE_GLOBALS.Control_Rec_Type;
156: l_cursor_id INTEGER;
157: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
158: l_found BOOLEAN;
159: l_header_id NUMBER;
160: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
161: l_item_type_code VARCHAR2(30);

Line 323: OE_DEBUG_PUB.Add('Error : Schedule date supplied for wrong mode.',1);

319: 'ONT_SCH_INVALID_MODE_ATTRB');
320: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
321: ERRBUF := 'ONT_SCH_INVALID_MODE_ATTRB';
322: IF l_debug_level > 0 THEN
323: OE_DEBUG_PUB.Add('Error : Schedule date supplied for wrong mode.',1);
324: END IF;
325: RETCODE := 2;
326: RETURN;
327: END IF;

Line 359: OE_DEBUG_PUB.Add('Schedule date'||l_apply_sch_date,1);

355: INTO l_apply_sch_date
356: FROM dual;
357:
358: IF l_debug_level > 0 THEN
359: OE_DEBUG_PUB.Add('Schedule date'||l_apply_sch_date,1);
360: END IF;
361: /* When user does not specifiy any parameters, we drive the scheduling
362: * through workflow. Pick up all the lines which are schedule eligible
363: * and notified status, call wf_engine to complete the activity.

Line 395: oe_debug_pub.add('***** 1. Processing item key '||

391: nvl(p_booked, 'Y') = 'Y'
392: THEN
393: FOR k IN wf_item LOOP
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add('***** 1. Processing item key '||
396: k.item_key ||' *****', 1);
397: END IF;
398:
399: -- Moac Start

Line 410: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || K.ITEM_KEY , 1 ) ;

406: -- Need to check whether still line is eligible for processing
407: IF Line_Eligible(p_line_id => to_number(K.ITEM_KEY)) THEN
408:
409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || K.ITEM_KEY , 1 ) ;
411: END IF;
412:
413:
414:

Line 443: oe_debug_pub.add( 'R1 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure , 1 ) ;

439: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(k.item_key)= 'N' THEN
440: l_failure := TRUE;
441: END IF;
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add( 'R1 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure , 1 ) ;
444: END IF;
445:
446: -- Moac
447: END IF;

Line 592: oe_debug_pub.add('Query : ' || l_stmt, 1 ) ;

588: l_stmt := l_stmt ||' ORDER BY L.top_model_line_id,l.line_id' ;
589: END IF;
590:
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add('Query : ' || l_stmt, 1 ) ;
593: END IF;
594:
595: -- Parse statement.
596: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);

Line 701: oe_debug_pub.add('Before executing query.',1);

697: DBMS_SQL.Define_Column(l_cursor_id, 2, l_line_id);
698: DBMS_SQL.Define_Column(l_cursor_id, 3, l_org_id); -- Moac
699:
700: IF l_debug_level > 0 THEN
701: oe_debug_pub.add('Before executing query.',1);
702: END IF;
703:
704: -- Execute query.
705: l_retval := DBMS_SQL.Execute(l_cursor_id);

Line 708: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;

704: -- Execute query.
705: l_retval := DBMS_SQL.Execute(l_cursor_id);
706:
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;
709: END IF;
710:
711: -- Process each row retrieved.
712: LOOP

Line 715: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;

711: -- Process each row retrieved.
712: LOOP
713:
714: IF l_debug_level > 0 THEN
715: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;
716: END IF;
717:
718: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 THEN
719: EXIT;

Line 728: oe_debug_pub.add('***** 1. Processing Line Id '||

724: DBMS_SQL.Column_Value(l_cursor_id, 3, l_org_id); -- Moac
725:
726:
727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('***** 1. Processing Line Id '||
729: l_line_id ||' *****', 1);
730: END IF;
731: --4777400: Context set is Moved up to set before call to get_date_type
732: -- Moac Start

Line 789: oe_debug_pub.add(to_char(l_line_id) || ' - Line Eligible', 1);

785: --5166476
786: IF Line_Eligible(p_line_id => l_line_id) THEN
787:
788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add(to_char(l_line_id) || ' - Line Eligible', 1);
790: END IF;
791:
792: --l_found := FALSE;
793:

Line 821: oe_debug_pub.add( 'R2 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;

817: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) ='N' THEN
818: l_failure := TRUE;
819: END IF;
820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add( 'R2 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
822: END IF;
823:
824: --END IF;
825: END IF;

Line 830: oe_debug_pub.add(to_char(l_line_id) || ' - Schedule', 1);

826: ELSIF p_sch_mode = 'SCHEDULE' AND
827: l_schedule_status_code IS NULL THEN
828:
829: IF l_debug_level > 0 THEN
830: oe_debug_pub.add(to_char(l_line_id) || ' - Schedule', 1);
831: END IF;
832: l_found := FALSE;
833:
834: IF l_smc_flag = 'Y' AND

Line 847: oe_debug_pub.add( 'R3.1 PROCESSED: '||l_line_id, 1 ) ;

843: ELSE
844: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';
845: END IF;
846: IF l_debug_level > 0 THEN
847: oe_debug_pub.add( 'R3.1 PROCESSED: '||l_line_id, 1 ) ;
848: END IF;
849: END IF;
850: ELSIF l_ato_line_id IS NOT NULL THEN
851: --l_top_model_line_id = l_ato_line_id THEN --5166476

Line 862: oe_debug_pub.add( 'R3.2 PROCESSED: '||l_line_id, 1 ) ;

858: ELSE
859: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';
860: END IF;
861: IF l_debug_level > 0 THEN
862: oe_debug_pub.add( 'R3.2 PROCESSED: '||l_line_id, 1 ) ;
863: END IF;
864: END IF;
865: IF NOT l_found AND
866: l_top_model_line_id IS NOT NULL AND

Line 879: oe_debug_pub.add( 'R3.4 PROCESSED '||l_line_id,1);

875: p_apply_sch_date IS NOT NULL) AND
876: l_item_type_code NOT IN (OE_GLOBALS.G_ITEM_INCLUDED) THEN
877: l_found := model_processed(l_line_id,l_line_id);
878: IF l_debug_level > 0 THEN
879: oe_debug_pub.add( 'R3.4 PROCESSED '||l_line_id,1);
880: END IF;
881: --5166476
882: ELSIF l_top_model_line_id <> l_link_to_line_id AND
883: l_item_type_code = (OE_GLOBALS.G_ITEM_INCLUDED) AND

Line 901: oe_debug_pub.add( 'R3.5 PROCESSED: '||l_line_id, 1 ) ;

897: oe_line_status_tbl.EXISTS(l_top_model_line_id) AND
898: oe_line_status_tbl(l_top_model_line_id) ='N' THEN
899: oe_line_status_tbl(l_line_id) := 'N';
900: IF l_debug_level > 0 THEN
901: oe_debug_pub.add( 'R3.5 PROCESSED: '||l_line_id, 1 ) ;
902: END IF;
903: END IF;
904:
905: END IF;

Line 980: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '

976: p_x_old_line_tbl => l_old_line_tbl,
977: x_return_status => l_return_status);
978:
979: IF l_debug_level > 0 THEN
980: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '
981: || l_return_status);
982: END IF;
983:
984: IF l_return_status IN (FND_API.G_RET_STS_ERROR,

Line 987: oe_debug_pub.add('#### FAILURE #### LINE_ID - '

983:
984: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
985: FND_API.G_RET_STS_UNEXP_ERROR) THEN
986: IF l_debug_level > 0 THEN
987: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
988: || to_char(l_line_id) || ' ####');
989: END IF;
990: --5166476
991: IF g_recorded = 'N' THEN

Line 1014: oe_debug_pub.add( 'R3 PROCESSED: '||l_line_id,1);

1010:
1011: END IF;
1012:
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'R3 PROCESSED: '||l_line_id,1);
1015: END IF;
1016:
1017: ELSE -- No scheduling attributes are provided
1018:

Line 1020: oe_debug_pub.add('No scheduling attributes. Booked flag - '

1016:
1017: ELSE -- No scheduling attributes are provided
1018:
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add('No scheduling attributes. Booked flag - '
1021: || l_booked_flag);
1022: END IF;
1023:
1024: g_process_records := 0;

Line 1041: oe_debug_pub.add('Return Status After Schedule_Multi_lines '||l_return_status,1);

1037: x_msg_data => l_msg_data);
1038:
1039: --ELSE
1040: IF l_debug_level > 0 THEN
1041: oe_debug_pub.add('Return Status After Schedule_Multi_lines '||l_return_status,1);
1042: END IF;
1043:
1044: IF NVL(l_booked_flag,'N') ='Y'
1045: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1048: oe_debug_pub.add('It is a Booked Order' );

1044: IF NVL(l_booked_flag,'N') ='Y'
1045: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1046:
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add('It is a Booked Order' );
1049: END IF;
1050: -- Added PTO Logic as part of bug 5186581
1051: IF l_top_model_line_id is not null
1052: AND l_top_model_line_id = l_line_id

Line 1058: oe_debug_pub.add('It is a PTO Model' );

1054: AND l_smc_flag = 'N' THEN
1055:
1056: IF l_debug_level > 0 THEN
1057:
1058: oe_debug_pub.add('It is a PTO Model' );
1059: END IF;
1060:
1061: -- Workflow wont progress all child lines for the Non SMC PTO model scenario. We have to progress all the
1062: -- child lines if the to Model is NON SMC

Line 1068: oe_debug_pub.add('Progressing Line ' || M.line_id, 1);

1064: FOR M IN progress_pto LOOP
1065:
1066:
1067: IF l_debug_level > 0 THEN
1068: oe_debug_pub.add('Progressing Line ' || M.line_id, 1);
1069: END IF;
1070:
1071: BEGIN
1072: -- COMPLETING ACTIVITY

Line 1110: oe_debug_pub.add( 'R4 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;

1106: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN
1107: l_failure := TRUE;
1108: END IF;
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.add( 'R4 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1111: END IF;
1112: END IF;
1113: END IF;
1114:

Line 1120: oe_debug_pub.add(to_char(l_line_id) || ' - Unschedule', 1);

1116: ELSIF p_sch_mode = 'UNSCHEDULE' AND
1117: l_schedule_status_code IS NOT NULL THEN
1118:
1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add(to_char(l_line_id) || ' - Unschedule', 1);
1121: END IF;
1122:
1123: l_found := FALSE;
1124:

Line 1167: oe_debug_pub.add( 'R5 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;

1163: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN
1164: l_failure := TRUE;
1165: END IF;
1166: IF l_debug_level > 0 THEN
1167: oe_debug_pub.add( 'R5 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1168: END IF;
1169:
1170: END IF;
1171: ELSIF p_sch_mode IN ('RESCHEDULE','RESCHEDULE_RD') THEN

Line 1176: oe_debug_pub.add(to_char(l_line_id) || ' - Reschedule', 1);

1172:
1173: l_temp_flag := FALSE;
1174:
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add(to_char(l_line_id) || ' - Reschedule', 1);
1177: END IF;
1178:
1179: IF l_smc_flag = 'Y' AND
1180: l_top_model_line_id IS NOT NULL THEN

Line 1192: oe_debug_pub.add( 'R6.1 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;

1188: l_rec_processed := l_rec_processed + 1;
1189: l_rec_failure := l_rec_failure + 1;
1190: */
1191: IF l_debug_level > 0 THEN
1192: oe_debug_pub.add( 'R6.1 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1193: END IF;
1194: END IF;
1195: ELSIF l_ato_line_id IS NOT NULL THEN
1196: --l_ato_line_id = l_top_model_line_id THEN

Line 1208: oe_debug_pub.add( 'R6.2 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;

1204: l_rec_processed := l_rec_processed + 1;
1205: l_rec_failure := l_rec_failure + 1;
1206: */
1207: IF l_debug_level > 0 THEN
1208: oe_debug_pub.add( 'R6.2 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1209: END IF;
1210: END IF;
1211:
1212: END IF;

Line 1285: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '

1281: p_x_old_line_tbl => l_old_line_tbl,
1282: x_return_status => l_return_status);
1283:
1284: IF l_debug_level > 0 THEN
1285: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '
1286: || l_return_status);
1287: END IF;
1288:
1289: IF l_return_status IN

Line 1294: oe_debug_pub.add('#### FAILURE #### LINE_ID - '

1290: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1291: THEN
1292: ROLLBACK TO SAVEPOINT Schedule_Line;
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1295: || to_char(l_line_id) || ' ####');
1296: END IF;
1297: --5166476
1298: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) := 'N';

Line 1309: oe_debug_pub.add( 'R6 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;

1305: END IF;
1306: l_failure := TRUE;
1307: END IF;
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add( 'R6 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1310: END IF;
1311:
1312: END IF;
1313: END IF; -- line eligible

Line 1318: oe_debug_pub.add('After Call to Process Order ',1);

1314:
1315: IF l_process_order = TRUE
1316: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add('After Call to Process Order ',1);
1319: END IF;
1320: BEGIN
1321:
1322: l_control_rec.controlled_operation := TRUE;

Line 1343: oe_debug_pub.add('GOING TO EXECUTE DELAYED REQUESTS ', 2);

1339: g_process_records := 0;
1340: g_failed_records := 0;
1341:
1342: IF l_debug_level > 0 THEN
1343: oe_debug_pub.add('GOING TO EXECUTE DELAYED REQUESTS ', 2);
1344: END IF;
1345:
1346: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
1347: (x_return_status => l_return_status);

Line 1352: oe_debug_pub.add('#### FAILURE #### LINE_ID - '

1348:
1349: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1350: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1351: IF l_debug_level > 0 THEN
1352: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1353: || to_char(l_line_id) || ' ####');
1354: END IF;
1355:
1356: l_failure := TRUE;

Line 1361: oe_debug_pub.add('AFTER CLEARING DELAYED REQUESTS: '|| l_return_status, 2);

1357:
1358: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1359:
1360: IF l_debug_level > 0 THEN
1361: oe_debug_pub.add('AFTER CLEARING DELAYED REQUESTS: '|| l_return_status, 2);
1362: END IF;
1363:
1364: ROLLBACK TO SAVEPOINT Schedule_Line;
1365: END IF;

Line 1370: oe_debug_pub.add('IN WHEN OTHERS '|| l_return_status, 2);

1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1369: IF l_debug_level > 0 THEN
1370: oe_debug_pub.add('IN WHEN OTHERS '|| l_return_status, 2);
1371: END IF;
1372: END;
1373:
1374: l_process_order := FALSE;

Line 1397: --oe_debug_pub.add( 'R7 : '||l_index||' Status: '||oe_line_status_tbl(l_index), 1 ) ;

1393: l_rec_failure := 0;
1394: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.FIRST;
1395: WHILE l_index is not null
1396: LOOP
1397: --oe_debug_pub.add( 'R7 : '||l_index||' Status: '||oe_line_status_tbl(l_index), 1 ) ;
1398: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_index) = 'Y' THEN
1399: l_rec_success := l_rec_success + 1;
1400: ELSE
1401: l_rec_failure := l_rec_failure + 1;