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.30.12020000.7 2013/04/09 08:03:44 spothula ship $ */
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.30.12020000.7 2013/04/09 08:03:44 spothula ship $ */
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 551: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_wf_item_rec(k).item_key) AND

547: */
548: --5166476
549:
550: --IF g_failed_records > 0 THEN
551: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_wf_item_rec(k).item_key) AND
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

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

548: --5166476
549:
550: --IF g_failed_records > 0 THEN
551: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_wf_item_rec(k).item_key) AND
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 ) ;

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

991:
992: --5166476
993:
994: --IF g_failed_records > 0 THEN
995: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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

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

992: --5166476
993:
994: --IF g_failed_records > 0 THEN
995: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
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 ) ;

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

1022: l_found := model_processed(l_top_model_line_id,l_top_model_line_id);
1023: --5166476
1024: IF l_found AND
1025: oe_line_status_tbl.EXISTS(l_top_model_line_id) THEN
1026: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN
1027: --5166476
1028: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
1029: ELSE
1030: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';

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

1024: IF l_found AND
1025: oe_line_status_tbl.EXISTS(l_top_model_line_id) THEN
1026: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN
1027: --5166476
1028: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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

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

1026: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_top_model_line_id) = 'N' THEN
1027: --5166476
1028: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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;

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

1038: l_found := model_processed(l_ato_line_id,l_ato_line_id);
1039: --5166476
1040: IF l_found AND
1041: oe_line_status_tbl.EXISTS(l_ato_line_id) THEN
1042: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_ato_line_id) ='N' THEN
1043: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
1044: ELSE
1045: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'Y';
1046: END IF;

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

1039: --5166476
1040: IF l_found AND
1041: oe_line_status_tbl.EXISTS(l_ato_line_id) THEN
1042: IF OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_ato_line_id) ='N' THEN
1043: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
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

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

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

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

1175: END IF;
1176: --5166476
1177: IF g_recorded = 'N' THEN
1178: --5166476
1179: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) :='N';
1180: g_recorded := 'Y';
1181: END IF;
1182: --5166476
1183: --IF l_smc_flag = 'Y' AND

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

1294: END IF;
1295: --5166476
1296:
1297: --IF g_failed_records > 0 THEN
1298: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
1299: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN
1300: l_failure := TRUE;
1301: END IF;
1302:

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

1295: --5166476
1296:
1297: --IF g_failed_records > 0 THEN
1298: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
1299: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN
1300: l_failure := TRUE;
1301: END IF;
1302:
1303: --Bug 13810638

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

1353:
1354: IF l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
1355: --5166476
1356: --g_process_records := g_process_records + 1;
1357: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) := 'Y';
1358: END IF;
1359: --R12.MOAC
1360: l_selected_line_tbl(1).id1 := l_line_id;
1361: l_process_order := TRUE; --Bug 13810638

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

1369: x_msg_data => l_msg_data);
1370: --5166476
1371:
1372: --IF g_failed_records > 0 THEN
1373: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
1374: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN
1375: l_failure := TRUE;
1376: END IF;
1377:

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

1370: --5166476
1371:
1372: --IF g_failed_records > 0 THEN
1373: IF OE_SCH_CONC_REQUESTS.oe_line_status_tbl.EXISTS(l_line_id) AND
1374: OE_SCH_CONC_REQUESTS.oe_line_status_tbl(l_line_id) = 'N' THEN
1375: l_failure := TRUE;
1376: END IF;
1377:
1378: --Bug 13810638

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

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';
1523: --516476
1524: IF l_smc_flag = 'Y' AND
1525: l_top_model_line_id IS NOT NULL THEN
1526: OE_line_status_Tbl(l_top_model_line_id) := 'N';

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

1617: --l_rec_success := l_rec_processed - l_rec_failure;
1618: l_rec_success :=0;
1619: l_rec_processed := 0;
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

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

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

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

1627: ELSE
1628: l_rec_failure := l_rec_failure + 1;
1629: END IF;
1630: l_rec_processed := l_rec_processed +1;
1631: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);
1632: END LOOP;
1633:
1634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);

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

1648: fnd_file.put_line(FND_FILE.LOG,
1649: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1650:
1651: WHEN OTHERS THEN
1652: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1653: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1654: DBMS_SQL.Close_Cursor(l_cursor_id);
1655:
1656: END Request;

Line 1658: END OE_SCH_CONC_REQUESTS;

1654: DBMS_SQL.Close_Cursor(l_cursor_id);
1655:
1656: END Request;
1657:
1658: END OE_SCH_CONC_REQUESTS;