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.OPI_DBI_JOBS_PKG dependencies on OPI_DBI_JOBS_PKG

Line 1: Package Body OPI_DBI_JOBS_PKG AS

1: Package Body OPI_DBI_JOBS_PKG AS
2: /*$Header: OPIDJOBSB.pls 120.16 2007/04/04 05:28:57 sdiwakar ship $ */
3:
4: -- Standard WHO column information
5: g_sysdate DATE;

Line 343: i_err_msg := 'OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE ('

339: EXCEPTION
340: WHEN OTHERS THEN
341: rollback;
342: i_err_num := SQLCODE;
343: i_err_msg := 'OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE ('
344: || to_char(l_stmt_num)
345: || '): '
346: || substr(SQLERRM, 1,200);
347:

Line 348: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE - Error at statement ('

344: || to_char(l_stmt_num)
345: || '): '
346: || substr(SQLERRM, 1,200);
347:
348: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE - Error at statement ('
349: || to_char(l_stmt_num)
350: || ')');
351:
352: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

Line 623: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD';

619: source = 2;
620:
621: BEGIN
622:
623: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD';
624: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
625:
626: l_stmt_num := 2;
627: --Calling Common Module Log

Line 960: sum (dtl.plan_qty) * OPI_DBI_JOBS_PKG.GET_OPM_ITEM_COST(hdr.organization_id,

956: 2, 3,
957: 3, 4,
958: 4, 12,
959: -1, 7) job_status_code,
960: sum (dtl.plan_qty) * OPI_DBI_JOBS_PKG.GET_OPM_ITEM_COST(hdr.organization_id,
961: dtl.inventory_item_id,
962: l_to_date) job_start_value,
963: g_program_id,
964: g_program_login_id,

Line 1050: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD ('

1046: WHEN OTHERS THEN
1047: rollback;
1048:
1049: l_err_num := SQLCODE;
1050: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD ('
1051: || to_char(l_stmt_num)
1052: || '): '
1053: || substr(SQLERRM, 1,200);
1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('

Line 1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('

1050: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD ('
1051: || to_char(l_stmt_num)
1052: || '): '
1053: || substr(SQLERRM, 1,200);
1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('
1055: || to_char(l_stmt_num)
1056: || ')');
1057: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1058: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1281: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD ('

1277: WHEN OTHERS THEN
1278: rollback;
1279:
1280: l_err_num := SQLCODE;
1281: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD ('
1282: || to_char(l_stmt_num)
1283: || '): '
1284: || substr(SQLERRM, 1,200);
1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('

Line 1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('

1281: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD ('
1282: || to_char(l_stmt_num)
1283: || '): '
1284: || substr(SQLERRM, 1,200);
1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('
1286: || to_char(l_stmt_num)
1287: || ')');
1288: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1289: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1439: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD ('

1435: WHEN OTHERS THEN
1436: rollback;
1437:
1438: l_err_num := SQLCODE;
1439: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD ('
1440: || to_char(l_stmt_num)
1441: || '): '
1442: || substr(SQLERRM, 1,200);
1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('

Line 1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('

1439: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD ('
1440: || to_char(l_stmt_num)
1441: || '): '
1442: || substr(SQLERRM, 1,200);
1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('
1444: || to_char(l_stmt_num)
1445: || ')');
1446: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1472: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD';

1468: l_industry VARCHAR2(30);
1469: l_list dbms_sql.varchar2_table;
1470: BEGIN
1471:
1472: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD';
1473: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1474:
1475: l_stmt_num := 2;
1476: --Calling Common Module Log

Line 1634: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD ('

1630: WHEN OTHERS THEN
1631: rollback;
1632:
1633: l_err_num := SQLCODE;
1634: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD ('
1635: || to_char(l_stmt_num)
1636: || '): '
1637: || substr(SQLERRM, 1,200);
1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('

Line 1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('

1634: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD ('
1635: || to_char(l_stmt_num)
1636: || '): '
1637: || substr(SQLERRM, 1,200);
1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('
1639: || to_char(l_stmt_num)
1640: || ')');
1641: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1759: l_err_msg := 'OPI_DBI_JOBS_PKG.REFRESH_MV ('

1755: EXCEPTION
1756: WHEN OTHERS THEN
1757:
1758: l_err_num := SQLCODE;
1759: l_err_msg := 'OPI_DBI_JOBS_PKG.REFRESH_MV ('
1760: || to_char(l_stmt_num)
1761: || '): '
1762: || substr(SQLERRM, 1,200);
1763:

Line 1764: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.REFRESH_MV - Error at statement ('

1760: || to_char(l_stmt_num)
1761: || '): '
1762: || substr(SQLERRM, 1,200);
1763:
1764: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.REFRESH_MV - Error at statement ('
1765: || to_char(l_stmt_num)
1766: || ')');
1767:
1768: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

Line 1776: End OPI_DBI_JOBS_PKG;

1772: /*please note that this api will commit!!*/
1773:
1774: END REFRESH_MV;
1775:
1776: End OPI_DBI_JOBS_PKG;