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 : ER 13114460
85: l_msg_count NUMBER;
86: l_msg_data VARCHAR2(2000);
87: l_result VARCHAR2(30);

Line 127: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS: ' ||

123: , x_result_out => l_result
124: );
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS: ' ||
128: L_OUT_RETURN_STATUS , 1 ) ;
129: END IF;
130:
131: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;
150: END IF;
151: RETURN FALSE;
152: WHEN OTHERS THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

207: l_atp_tbl OE_ATP.Atp_Tbl_Type;
208: l_booked_flag VARCHAR2(1);
209: l_control_rec OE_GLOBALS.Control_Rec_Type;
210: l_cursor_id INTEGER;
211: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
212: l_found BOOLEAN;
213: l_header_id NUMBER;
214: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
215: l_item_type_code VARCHAR2(30);

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

392: 'ONT_SCH_INVALID_MODE_ATTRB');
393: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
394: ERRBUF := 'ONT_SCH_INVALID_MODE_ATTRB';
395: IF l_debug_level > 0 THEN
396: OE_DEBUG_PUB.Add('Error : Schedule date supplied for wrong mode.',1);
397: END IF;
398: RETCODE := 2;
399: RETURN;
400: END IF;

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

428: INTO l_apply_sch_date
429: FROM dual;
430:
431: IF l_debug_level > 0 THEN
432: OE_DEBUG_PUB.Add('Schedule date'||l_apply_sch_date,1);
433: END IF;
434: /* When user does not specifiy any parameters, we drive the scheduling
435: * through workflow. Pick up all the lines which are schedule eligible
436: * and notified status, call wf_engine to complete the activity.

Line 472: oe_debug_pub.add('commit_threshold '||l_commit_threshold,1);

468: -- Have bulk collect with limit as commit threshold
469: -- Commit and close the cursor after each set execution
470: BEGIN
471: IF l_debug_level > 0 THEN
472: oe_debug_pub.add('commit_threshold '||l_commit_threshold,1);
473: END IF;
474: --LOOP
475: OPEN wf_item;
476: Loop -- 16467034

Line 481: oe_debug_pub.add('* 1. Processing item key '||l_wf_item_rec(k).item_key ||' *', 1);

477: FETCH wf_item BULK COLLECT INTO l_wf_item_rec LIMIT l_commit_threshold;
478: EXIT WHEN l_wf_item_rec.count = 0;
479: FOR k IN 1..l_wf_item_rec.count LOOP
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add('***** 1. Processing item key '||l_wf_item_rec(k).item_key ||' *****', 1);
482: END IF;
483:
484: -- Moac Start
485: IF NOT l_single_org and l_wf_item_rec(k).org_id <> l_old_org_id THEN

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

494: g_conc_program := 'Y';
495: g_recorded := 'N';
496:
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || l_wf_item_rec(K).ITEM_KEY , 1 ) ;
499: END IF;
500:
501: g_process_records := 0;
502: g_failed_records := 0;

Line 521: oe_debug_pub.add('OEXCSCHB.pls: unable to lock the line:'||l_wf_item_rec(K).ITEM_KEY,1);

517: TRUE ); -- 15870313
518: EXCEPTION
519: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add('OEXCSCHB.pls: unable to lock the line:'||l_wf_item_rec(K).ITEM_KEY,1);
522: END IF;
523: wf_item_activity_status.create_status('OEOL',
524: l_wf_item_rec(K).ITEM_KEY,
525: l_wf_item_rec(K).process_activity,

Line 532: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);

528: SYSDATE,
529: null);--13542899
530: WHEN OTHERS THEN
531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);
533: END IF;
534: END;
535: /* --8448911
536: OE_MSG_PUB.Count_And_Get

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

552: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_wf_item_rec(k).item_key)= 'N' THEN
553: l_failure := TRUE;
554: END IF;
555: IF l_debug_level > 0 THEN
556: oe_debug_pub.add( 'R1 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure , 1 ) ;
557: END IF;
558:
559: -- Moac
560: END IF;

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

732: l_stmt := l_stmt ||' ORDER BY L.top_model_line_id,l.line_id' ;
733: END IF;
734:
735: IF l_debug_level > 0 THEN
736: oe_debug_pub.add('Query : ' || l_stmt, 1 ) ;
737: END IF;
738:
739: -- Parse statement.
740: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);

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

855: DBMS_SQL.Define_Column(l_cursor_id, 2, l_line_id);
856: DBMS_SQL.Define_Column(l_cursor_id, 3, l_org_id); -- Moac
857:
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add('Before executing query.',1);
860: END IF;
861:
862: -- Execute query.
863: l_retval := DBMS_SQL.Execute(l_cursor_id);

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

862: -- Execute query.
863: l_retval := DBMS_SQL.Execute(l_cursor_id);
864:
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;
867: END IF;
868:
869: -- Process each row retrieved.
870: LOOP

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

869: -- Process each row retrieved.
870: LOOP
871:
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add('Execution Result : ' || l_retval, 2) ;
874: END IF;
875:
876: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 THEN
877: EXIT;

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

882: DBMS_SQL.Column_Value(l_cursor_id, 3, l_org_id); -- Moac
883:
884:
885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add('***** 1. Processing Line Id '||
887: l_line_id ||' *****', 1);
888: END IF;
889: --4777400: Context set is Moved up to set before call to get_date_type
890: -- Moac Start

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

943: --5166476
944: IF Line_Eligible(p_line_id => l_line_id) THEN
945:
946: IF l_debug_level > 0 THEN
947: oe_debug_pub.add(to_char(l_line_id) || ' - Line Eligible', 1);
948: END IF;
949:
950: --l_found := FALSE;
951:

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

980: */
981: EXCEPTION
982: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
985: END IF;
986: WHEN OTHERS THEN
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);

Line 988: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);

984: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
985: END IF;
986: WHEN OTHERS THEN
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);
989: END IF;
990: END;
991:
992: --5166476

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

996: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) ='N' THEN
997: l_failure := TRUE;
998: END IF;
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.add( 'R2 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1001: END IF;
1002:
1003: --END IF;
1004: END IF;

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

1012: ELSIF p_sch_mode = 'SCHEDULE' AND
1013: l_schedule_status_code IS NULL THEN
1014:
1015: IF l_debug_level > 0 THEN
1016: oe_debug_pub.add(to_char(l_line_id) || ' - Schedule', 1);
1017: END IF;
1018: l_found := FALSE;
1019:
1020: IF l_smc_flag = 'Y' AND

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

1029: ELSE
1030: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';
1031: END IF;
1032: IF l_debug_level > 0 THEN
1033: oe_debug_pub.add( 'R3.1 PROCESSED: '||l_line_id, 1 ) ;
1034: END IF;
1035: END IF;
1036: ELSIF l_ato_line_id IS NOT NULL THEN
1037: --l_top_model_line_id = l_ato_line_id THEN --5166476

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

1044: ELSE
1045: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';
1046: END IF;
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'R3.2 PROCESSED: '||l_line_id, 1 ) ;
1049: END IF;
1050: END IF;
1051: IF NOT l_found AND
1052: l_top_model_line_id IS NOT NULL AND

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

1061: p_apply_sch_date IS NOT NULL) AND
1062: l_item_type_code NOT IN (OE_GLOBALS.G_ITEM_INCLUDED) THEN
1063: l_found := model_processed(l_line_id,l_line_id);
1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'R3.4 PROCESSED '||l_line_id,1);
1066: END IF;
1067: --5166476
1068: ELSIF l_top_model_line_id <> l_link_to_line_id AND
1069: l_item_type_code = (OE_GLOBALS.G_ITEM_INCLUDED) AND

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

1083: oe_line_status_tbl.EXISTS(l_top_model_line_id) AND
1084: oe_line_status_tbl(l_top_model_line_id) ='N' THEN
1085: oe_line_status_tbl(l_line_id) := 'N';
1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'R3.5 PROCESSED: '||l_line_id, 1 ) ;
1088: END IF;
1089: END IF;
1090:
1091: END IF;

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

1162: p_x_old_line_tbl => l_old_line_tbl,
1163: x_return_status => l_return_status);
1164:
1165: IF l_debug_level > 0 THEN
1166: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '
1167: || l_return_status);
1168: END IF;
1169:
1170: IF l_return_status IN (FND_API.G_RET_STS_ERROR,

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

1169:
1170: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1171: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1172: IF l_debug_level > 0 THEN
1173: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1174: || to_char(l_line_id) || ' ####');
1175: END IF;
1176: --5166476
1177: IF g_recorded = 'N' THEN

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

1196:
1197: END IF;
1198:
1199: IF l_debug_level > 0 THEN
1200: oe_debug_pub.add( 'R3 PROCESSED: '||l_line_id,1);
1201: END IF;
1202:
1203: ELSE -- No scheduling attributes are provided
1204:

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

1205: --Define a savepoint Bug 13810638
1206: SAVEPOINT Schedule_Line;
1207:
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add('No scheduling attributes. Booked flag - '
1210: || l_booked_flag);
1211: END IF;
1212:
1213: g_process_records := 0;

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

1228: x_msg_data => l_msg_data);
1229:
1230: --ELSE
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add('Return Status After Schedule_Multi_lines '||l_return_status,1);
1233: END IF;
1234:
1235: IF NVL(l_booked_flag,'N') ='Y'
1236: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

1235: IF NVL(l_booked_flag,'N') ='Y'
1236: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1237:
1238: IF l_debug_level > 0 THEN
1239: oe_debug_pub.add('It is a Booked Order' );
1240: END IF;
1241: -- Added PTO Logic as part of bug 5186581
1242: IF l_top_model_line_id is not null
1243: AND l_top_model_line_id = l_line_id

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

1245: AND l_smc_flag = 'N' THEN
1246:
1247: IF l_debug_level > 0 THEN
1248:
1249: oe_debug_pub.add('It is a PTO Model' );
1250: END IF;
1251:
1252: -- Workflow wont progress all child lines for the Non SMC PTO model scenario. We have to progress all the
1253: -- child lines if the to Model is NON SMC

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

1255: FOR M IN progress_pto LOOP
1256:
1257:
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add('Progressing Line ' || M.line_id, 1);
1260: END IF;
1261:
1262: BEGIN
1263: -- COMPLETING ACTIVITY

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

1305: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1306: THEN
1307: ROLLBACK TO SAVEPOINT Schedule_Line;
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1310: || to_char(l_line_id) || ' ####');
1311: END IF;
1312: l_failure := TRUE;
1313: END IF;

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

1312: l_failure := TRUE;
1313: END IF;
1314:
1315: IF l_debug_level > 0 THEN
1316: oe_debug_pub.add( 'R4 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1317: END IF;
1318: END IF;
1319: END IF;
1320:

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

1322: ELSIF p_sch_mode = 'UNSCHEDULE' AND
1323: l_schedule_status_code IS NOT NULL THEN
1324:
1325: IF l_debug_level > 0 THEN
1326: oe_debug_pub.add(to_char(l_line_id) || ' - Unschedule', 1);
1327: END IF;
1328:
1329: l_found := FALSE;
1330:

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

1380: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1381: THEN
1382: ROLLBACK TO SAVEPOINT Schedule_Line;
1383: IF l_debug_level > 0 THEN
1384: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1385: || to_char(l_line_id) || ' ####');
1386: END IF;
1387: l_failure := TRUE;
1388: END IF;

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

1387: l_failure := TRUE;
1388: END IF;
1389:
1390: IF l_debug_level > 0 THEN
1391: oe_debug_pub.add( 'R5 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1392: END IF;
1393:
1394: END IF;
1395: ELSIF p_sch_mode IN ('RESCHEDULE','RESCHEDULE_RD') THEN

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

1396:
1397: l_temp_flag := FALSE;
1398:
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add(to_char(l_line_id) || ' - Reschedule', 1);
1401: END IF;
1402:
1403: IF l_smc_flag = 'Y' AND
1404: l_top_model_line_id IS NOT NULL THEN

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

1412: l_rec_processed := l_rec_processed + 1;
1413: l_rec_failure := l_rec_failure + 1;
1414: */
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'R6.1 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1417: END IF;
1418: END IF;
1419: ELSIF l_ato_line_id IS NOT NULL THEN
1420: --l_ato_line_id = l_top_model_line_id THEN

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

1428: l_rec_processed := l_rec_processed + 1;
1429: l_rec_failure := l_rec_failure + 1;
1430: */
1431: IF l_debug_level > 0 THEN
1432: oe_debug_pub.add( 'R6.2 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1433: END IF;
1434: END IF;
1435:
1436: END IF;

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

1505: p_x_old_line_tbl => l_old_line_tbl,
1506: x_return_status => l_return_status);
1507:
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '
1510: || l_return_status);
1511: END IF;
1512:
1513: IF l_return_status IN

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

1514: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1515: THEN
1516: ROLLBACK TO SAVEPOINT Schedule_Line;
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1519: || to_char(l_line_id) || ' ####');
1520: END IF;
1521: --5166476
1522: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) := 'N';

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

1529: END IF;
1530: l_failure := TRUE;
1531: END IF;
1532: IF l_debug_level > 0 THEN
1533: oe_debug_pub.add( 'R6 PROCESSED: '||l_rec_processed||' FAILED: '||l_rec_failure, 1 ) ;
1534: END IF;
1535:
1536: END IF;
1537: END IF; -- line eligible

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

1538:
1539: IF l_process_order = TRUE
1540: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('After Call to Process Order ',1);
1543: END IF;
1544: BEGIN
1545:
1546: l_control_rec.controlled_operation := TRUE;

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

1563: g_process_records := 0;
1564: g_failed_records := 0;
1565:
1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add('GOING TO EXECUTE DELAYED REQUESTS ', 2);
1568: END IF;
1569:
1570: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
1571: (x_return_status => l_return_status);

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

1572:
1573: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1574: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1575: IF l_debug_level > 0 THEN
1576: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1577: || to_char(l_line_id) || ' ####');
1578: END IF;
1579:
1580: l_failure := TRUE;

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

1581:
1582: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1583:
1584: IF l_debug_level > 0 THEN
1585: oe_debug_pub.add('AFTER CLEARING DELAYED REQUESTS: '|| l_return_status, 2);
1586: END IF;
1587:
1588: ROLLBACK TO SAVEPOINT Schedule_Line;
1589: END IF;

Line 1593: oe_debug_pub.add('IN WHEN OTHERS, Error:'|| SQLERRM, 2);

1589: END IF;
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: IF l_debug_level > 0 THEN
1593: oe_debug_pub.add('IN WHEN OTHERS, Error:'|| SQLERRM, 2);
1594: END IF;
1595: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add('IN WHEN OTHERS '|| l_return_status, 2);

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

1593: oe_debug_pub.add('IN WHEN OTHERS, Error:'|| SQLERRM, 2);
1594: END IF;
1595: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add('IN WHEN OTHERS '|| l_return_status, 2);
1598: END IF;
1599: END;
1600:
1601: l_process_order := FALSE;

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

1620: l_rec_failure := 0;
1621: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.FIRST;
1622: WHILE l_index is not null
1623: LOOP
1624: --oe_debug_pub.add( 'R7 : '||l_index||' Status: '||oe_line_status_tbl(l_index), 1 ) ;
1625: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_index) = 'Y' THEN
1626: l_rec_success := l_rec_success + 1;
1627: ELSE
1628: l_rec_failure := l_rec_failure + 1;