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_JOB_TXN_STG_PKG dependencies on OPI_DBI_JOB_TXN_STG_PKG

Line 1: PACKAGE BODY OPI_DBI_JOB_TXN_STG_PKG AS

1: PACKAGE BODY OPI_DBI_JOB_TXN_STG_PKG AS
2: /*$Header: OPIDJOBTRB.pls 120.34 2006/09/20 23:58:22 asparama noship $*/
3:
4: /* Non planned items have an mrp_planning_code of 6 */
5: NON_PLANNED_ITEM CONSTANT NUMBER := 6;

Line 290: i_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES ('

286: EXCEPTION
287: WHEN OTHERS THEN
288: rollback;
289: i_err_num := SQLCODE;
290: i_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES ('
291: || to_char(l_stmt_num)
292: || '): '
293: || substr(SQLERRM, 1,200);
294:

Line 295: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES - Error at statement ('

291: || to_char(l_stmt_num)
292: || '): '
293: || substr(SQLERRM, 1,200);
294:
295: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES - Error at statement ('
296: || to_char(l_stmt_num)
297: || ')');
298:
299: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

Line 330: l_formatted_message := substr (('OPI_DBI_JOB_TXN_STG_PKG' || '.' || p_proc_name || ' #' ||

326: l_stmt_id := 0;
327: l_buffer_size := 300;
328:
329: l_stmt_id := 10;
330: l_formatted_message := substr (('OPI_DBI_JOB_TXN_STG_PKG' || '.' || p_proc_name || ' #' ||
331: to_char (p_stmt_id) || ': ' || p_mesg),
332: 1, l_buffer_size);
333:
334: commit;

Line 343: l_formatted_message := substr (('C_PKG_OPI_DBI_JOB_TXN_STG_PKG' || '.' || l_proc_name ||

339:
340: WHEN OTHERS THEN
341: -- the exception happened in the exception reporting function !!
342: -- return with ERROR.
343: l_formatted_message := substr (('C_PKG_OPI_DBI_JOB_TXN_STG_PKG' || '.' || l_proc_name ||
344: ' #' ||
345: to_char (l_stmt_id) || ': ' ||
346: SQLERRM),
347: 1, l_buffer_size);

Line 385: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV ('

381: EXCEPTION
382: WHEN OTHERS THEN
383:
384: l_err_num := SQLCODE;
385: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV ('
386: || to_char(l_stmt_num)
387: || '): '
388: || substr(SQLERRM, 1,200);
389:

Line 390: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV - Error at statement ('

386: || to_char(l_stmt_num)
387: || '): '
388: || substr(SQLERRM, 1,200);
389:
390: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV - Error at statement ('
391: || to_char(l_stmt_num)
392: || ')');
393:
394: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

Line 424: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MMT_STG';

420: l_opi_schema VARCHAR2(30);
421:
422: BEGIN
423:
424: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MMT_STG';
425:
426: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
427:
428: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load Start Time - ' ||

Line 571: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_ODM_INIT';

567: l_opi_schema VARCHAR2(30);
568:
569: BEGIN
570:
571: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_ODM_INIT';
572:
573: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
574:
575: /* Insert ODM data into Staging */

Line 812: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_ODM_INCR';

808: l_opi_schema VARCHAR2(30);
809:
810: BEGIN
811:
812: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_ODM_INCR';
813:
814: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
815:
816: /* Insert ODM data into Staging*/

Line 1064: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_OPM_INIT';

1060: source = 2;
1061:
1062: BEGIN
1063:
1064: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_OPM_INIT';
1065:
1066: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1067:
1068: l_stmt_num := 10;

Line 1285: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_OPM_INCR';

1281: source = 2;
1282:
1283: BEGIN
1284:
1285: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_OPM_INCR';
1286:
1287: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1288:
1289: l_stmt_num := 10;

Line 1487: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_PR12OPM_INIT';

1483: l_opi_schema VARCHAR2(30);
1484:
1485: BEGIN
1486:
1487: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_PR12OPM_INIT';
1488:
1489: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1490:
1491: /* Inserting Pre R12 OPM MU Actuals to Jobs Transaction Staging */

Line 1771: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_MTL_USAGE_ACT_INIT';

1767: l_opi_schema VARCHAR2(30);
1768:
1769: BEGIN
1770:
1771: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_MTL_USAGE_ACT_INIT';
1772:
1773: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1774:
1775: /* Extraction of MTL Usage Actuals fact */

Line 1896: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_MTL_USAGE_ACT_INCR';

1892: l_opi_schema VARCHAR2(30);
1893:
1894: BEGIN
1895:
1896: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_MTL_USAGE_ACT_INCR';
1897:
1898: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1899:
1900: /* Extraction of MTL Usage Actuals fact */

Line 2087: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_ODM_MTL_USAGE_STD_INIT';

2083: l_opi_schema VARCHAR2(30);
2084:
2085: BEGIN
2086:
2087: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_ODM_MTL_USAGE_STD_INIT';
2088:
2089: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2090:
2091: /* ODM insert into temp table */

Line 2314: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_ODM_MTL_USAGE_STD_INCR';

2310: l_opi_schema VARCHAR2(30);
2311:
2312: BEGIN
2313:
2314: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_ODM_MTL_USAGE_STD_INCR';
2315:
2316: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2317:
2318: /* ODM insert into temp table */

Line 2587: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_OPM_MTL_USAGE_STD_INIT';

2583: l_opi_schema VARCHAR2(30);
2584:
2585: BEGIN
2586:
2587: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_OPM_MTL_USAGE_STD_INIT';
2588:
2589: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2590:
2591: /* OPM Standards insert into fact table */

Line 2723: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_OPM_MTL_USAGE_STD_INCR';

2719: l_opi_schema VARCHAR2(30);
2720:
2721: BEGIN
2722:
2723: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_OPM_MTL_USAGE_STD_INCR';
2724:
2725: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2726:
2727: /* OPM Standards insert into fact table */

Line 2981: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INIT';

2977: gmd_common_scale_error EXCEPTION;
2978:
2979: BEGIN
2980:
2981: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INIT';
2982:
2983: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2984:
2985: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

Line 3235: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INCR';

3231:
3232:
3233: BEGIN
3234:
3235: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INCR';
3236:
3237: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3238:
3239: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

Line 3405: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_COMP_INIT';

3401: l_opi_schema VARCHAR2(30);
3402:
3403: BEGIN
3404:
3405: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_COMP_INIT';
3406:
3407: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3408:
3409: /* Extraction of WIP Completions fact */

Line 3533: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_COMP_INCR';

3529: l_opi_schema VARCHAR2(30);
3530:
3531: BEGIN
3532:
3533: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_COMP_INCR';
3534:
3535: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3536:
3537: /* Extraction of WIP Completions fact */

Line 3719: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_SCRAP_INIT';

3715: l_opi_schema VARCHAR2(30);
3716:
3717: BEGIN
3718:
3719: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_SCRAP_INIT';
3720:
3721: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3722:
3723: /* Extraction of Scrap fact */

Line 3836: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_SCRAP_INCR';

3832: l_opi_schema VARCHAR2(30);
3833:
3834: BEGIN
3835:
3836: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_SCRAP_INCR';
3837:
3838: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3839:
3840: /* Extraction of Scrap fact */

Line 4001: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_TRUNC_TEMP_TBLS';

3997: l_opi_schema VARCHAR2(30);
3998:
3999: BEGIN
4000:
4001: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_TRUNC_TEMP_TBLS';
4002:
4003: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4004:
4005: /* truncate all tables */

Line 4101: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP';

4097: l_err_msg VARCHAR2(255);
4098: l_proc_name VARCHAR2(255);
4099: BEGIN
4100:
4101: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP';
4102:
4103: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4104:
4105: l_stmt_num := 10;

Line 4159: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP ('

4155:
4156: WHEN OTHERS THEN
4157: rollback;
4158: l_err_num := SQLCODE;
4159: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP ('
4160: || to_char(l_stmt_num)
4161: || '): '
4162: || substr(SQLERRM, 1,200);
4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('

Line 4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('

4159: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP ('
4160: || to_char(l_stmt_num)
4161: || '): '
4162: || substr(SQLERRM, 1,200);
4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('
4164: || to_char(l_stmt_num)
4165: || ')');
4166: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4167: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 4194: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP';

4190: l_err_msg VARCHAR2(255);
4191: l_proc_name VARCHAR2(255);
4192: BEGIN
4193:
4194: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP';
4195:
4196: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4197:
4198: /* calling setup for all fact tables */

Line 4338: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP ('

4334:
4335: WHEN OTHERS THEN
4336: rollback;
4337: l_err_num := SQLCODE;
4338: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP ('
4339: || to_char(l_stmt_num)
4340: || '): '
4341: || substr(SQLERRM, 1,200);
4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('

Line 4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('

4338: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP ('
4339: || to_char(l_stmt_num)
4340: || '): '
4341: || substr(SQLERRM, 1,200);
4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('
4343: || to_char(l_stmt_num)
4344: || ')');
4345: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4346: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 4425: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV ('

4421: EXCEPTION
4422: WHEN OTHERS THEN
4423:
4424: l_err_num := SQLCODE;
4425: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV ('
4426: || to_char(l_stmt_num)
4427: || '): '
4428: || substr(SQLERRM, 1,200);
4429:

Line 4430: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV - Error at statement ('

4426: || to_char(l_stmt_num)
4427: || '): '
4428: || substr(SQLERRM, 1,200);
4429:
4430: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV - Error at statement ('
4431: || to_char(l_stmt_num)
4432: || ')');
4433:
4434: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

Line 4461: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT';

4457: r12upgrade_date DATE;
4458:
4459: BEGIN
4460:
4461: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT';
4462:
4463: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4464:
4465: -- WHO column variable initialization

Line 4559: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT ('

4555:
4556: WHEN OTHERS THEN
4557: rollback;
4558: l_err_num := SQLCODE;
4559: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT ('
4560: || to_char(l_stmt_num)
4561: || '): '
4562: || substr(SQLERRM, 1,200);
4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('

Line 4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('

4559: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT ('
4560: || to_char(l_stmt_num)
4561: || '): '
4562: || substr(SQLERRM, 1,200);
4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('
4564: || to_char(l_stmt_num)
4565: || ')');
4566: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4567: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 4594: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR';

4590: l_proc_name VARCHAR2(255);
4591:
4592: BEGIN
4593:
4594: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR';
4595:
4596: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4597:
4598: -- WHO column variable initialization

Line 4676: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR ('

4672:
4673: WHEN OTHERS THEN
4674: rollback;
4675: l_err_num := SQLCODE;
4676: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR ('
4677: || to_char(l_stmt_num)
4678: || '): '
4679: || substr(SQLERRM, 1,200);
4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('

Line 4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('

4676: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR ('
4677: || to_char(l_stmt_num)
4678: || '): '
4679: || substr(SQLERRM, 1,200);
4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('
4681: || to_char(l_stmt_num)
4682: || ')');
4683: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4684: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 4693: END OPI_DBI_JOB_TXN_STG_PKG;

4689: RAISE_APPLICATION_ERROR(-20000, errbuf);
4690:
4691: END GET_OPI_JOB_TXN_MUV_INCR;
4692:
4693: END OPI_DBI_JOB_TXN_STG_PKG;