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_SCH_CONC_REQUESTS

Line 1: PACKAGE BODY OE_SCH_CONC_REQUESTS AS

1: PACKAGE BODY OE_SCH_CONC_REQUESTS AS
2: /* $Header: OEXCSCHB.pls 120.20 2006/07/13 11:32:53 rmoharan noship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SCH_CONC_REQUESTS';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SCH_CONC_REQUESTS';

1: PACKAGE BODY OE_SCH_CONC_REQUESTS AS
2: /* $Header: OEXCSCHB.pls 120.20 2006/07/13 11:32:53 rmoharan noship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SCH_CONC_REQUESTS';
6: --5166476
7: /*
8: TYPE status_arr IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
9: OE_line_status_Tbl status_arr;

Line 438: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(k.item_key) AND

434: END LOOP;
435: --5166476
436:
437: --IF g_failed_records > 0 THEN
438: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(k.item_key) AND
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

Line 439: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(k.item_key)= 'N' THEN

435: --5166476
436:
437: --IF g_failed_records > 0 THEN
438: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(k.item_key) AND
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 ) ;

Line 816: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND

812: END LOOP;
813: --5166476
814:
815: --IF g_failed_records > 0 THEN
816: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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

Line 817: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) ='N' THEN

813: --5166476
814:
815: --IF g_failed_records > 0 THEN
816: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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 ) ;

Line 840: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN

836: l_found := model_processed(l_top_model_line_id,l_top_model_line_id);
837: --5166476
838: IF l_found AND
839: oe_line_status_tbl.EXISTS(l_top_model_line_id) THEN
840: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN
841: --5166476
842: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
843: ELSE
844: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';

Line 842: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

838: IF l_found AND
839: oe_line_status_tbl.EXISTS(l_top_model_line_id) THEN
840: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN
841: --5166476
842: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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

Line 844: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';

840: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN
841: --5166476
842: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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;

Line 856: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_ato_line_id) ='N' THEN

852: l_found := model_processed(l_ato_line_id,l_ato_line_id);
853: --5166476
854: IF l_found AND
855: oe_line_status_tbl.EXISTS(l_ato_line_id) THEN
856: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_ato_line_id) ='N' THEN
857: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
858: ELSE
859: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';
860: END IF;

Line 857: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

853: --5166476
854: IF l_found AND
855: oe_line_status_tbl.EXISTS(l_ato_line_id) THEN
856: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_ato_line_id) ='N' THEN
857: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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

Line 859: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';

855: oe_line_status_tbl.EXISTS(l_ato_line_id) THEN
856: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_ato_line_id) ='N' THEN
857: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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;

Line 993: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) :='N';

989: END IF;
990: --5166476
991: IF g_recorded = 'N' THEN
992: --5166476
993: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) :='N';
994: g_recorded := 'Y';
995: END IF;
996: --5166476
997: --IF l_smc_flag = 'Y' AND

Line 1105: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND

1101: END IF;
1102: --5166476
1103:
1104: --IF g_failed_records > 0 THEN
1105: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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

Line 1106: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN

1102: --5166476
1103:
1104: --IF g_failed_records > 0 THEN
1105: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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 ) ;

Line 1147: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) := 'Y';

1143:
1144: IF l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
1145: --5166476
1146: --g_process_records := g_process_records + 1;
1147: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) := 'Y';
1148: END IF;
1149: --R12.MOAC
1150: l_selected_line_tbl(1).id1 := l_line_id;
1151: OE_GROUP_SCH_UTIL.Schedule_Multi_lines

Line 1162: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND

1158: x_msg_data => l_msg_data);
1159: --5166476
1160:
1161: --IF g_failed_records > 0 THEN
1162: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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

Line 1163: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN

1159: --5166476
1160:
1161: --IF g_failed_records > 0 THEN
1162: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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 ) ;

Line 1298: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) := 'N';

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';
1299: --516476
1300: IF l_smc_flag = 'Y' AND
1301: l_top_model_line_id IS NOT NULL THEN
1302: OE_line_status_Tbl(l_top_model_line_id) := 'N';

Line 1394: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.FIRST;

1390: --l_rec_success := l_rec_processed - l_rec_failure;
1391: l_rec_success :=0;
1392: l_rec_processed := 0;
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

Line 1398: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_index) = 'Y' THEN

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;
1402: END IF;

Line 1404: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);

1400: ELSE
1401: l_rec_failure := l_rec_failure + 1;
1402: END IF;
1403: l_rec_processed := l_rec_processed +1;
1404: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);
1405: END LOOP;
1406:
1407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);

Line 1425: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');

1421: fnd_file.put_line(FND_FILE.LOG,
1422: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1423:
1424: WHEN OTHERS THEN
1425: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1426: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1427: DBMS_SQL.Close_Cursor(l_cursor_id);
1428:
1429: END Request;

Line 1431: END OE_SCH_CONC_REQUESTS;

1427: DBMS_SQL.Close_Cursor(l_cursor_id);
1428:
1429: END Request;
1430:
1431: END OE_SCH_CONC_REQUESTS;