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_WMS_WAA_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 119: bis_collection_utilities.put_line('Error Number: ' || retcode);

115: errbuf := 'Warning in '||g_package||l_procedure||' at line#: '
116: ||l_stmt_num||' - '
117: ||'No data avialble for extraction';
118: --
119: bis_collection_utilities.put_line('Error Number: ' || retcode);
120: bis_collection_utilities.put_line('Error Message: '|| errbuf);
121: --
122: WHEN OTHERS THEN
123: retcode := SQLCODE;

Line 120: bis_collection_utilities.put_line('Error Message: '|| errbuf);

116: ||l_stmt_num||' - '
117: ||'No data avialble for extraction';
118: --
119: bis_collection_utilities.put_line('Error Number: ' || retcode);
120: bis_collection_utilities.put_line('Error Message: '|| errbuf);
121: --
122: WHEN OTHERS THEN
123: retcode := SQLCODE;
124: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '

Line 127: bis_collection_utilities.put_line('Error Number: ' || retcode);

123: retcode := SQLCODE;
124: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
125: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
126: --
127: bis_collection_utilities.put_line('Error Number: ' || retcode);
128: bis_collection_utilities.put_line('Error Message: '|| errbuf);
129: --
130: END get_wms_gsd;
131: --

Line 128: bis_collection_utilities.put_line('Error Message: '|| errbuf);

124: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
125: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
126: --
127: bis_collection_utilities.put_line('Error Number: ' || retcode);
128: bis_collection_utilities.put_line('Error Message: '|| errbuf);
129: --
130: END get_wms_gsd;
131: --
132: /****************************** SET_LAST_RUN_DATE ****************************/

Line 169: bis_collection_utilities.put_line('Updated the information of '

165: ,g_login_id
166: ,g_program_application_id
167: ,g_request_id);
168: --
169: bis_collection_utilities.put_line('Updated the information of '
170: ||'Last Collection Date');
171: --
172: l_stmt_num := 20;
173: EXCEPTION

Line 180: bis_collection_utilities.put_line('Failed to update collection date'

176: retcode := SQLCODE;
177: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
178: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
179: --
180: bis_collection_utilities.put_line('Failed to update collection date'
181: ||' in log table. Aborting');
182: bis_collection_utilities.put_line('Error Number: ' || retcode);
183: bis_collection_utilities.put_line('Error Message: '|| errbuf);
184: --

Line 182: bis_collection_utilities.put_line('Error Number: ' || retcode);

178: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
179: --
180: bis_collection_utilities.put_line('Failed to update collection date'
181: ||' in log table. Aborting');
182: bis_collection_utilities.put_line('Error Number: ' || retcode);
183: bis_collection_utilities.put_line('Error Message: '|| errbuf);
184: --
185: END set_last_run_date;
186: --

Line 183: bis_collection_utilities.put_line('Error Message: '|| errbuf);

179: --
180: bis_collection_utilities.put_line('Failed to update collection date'
181: ||' in log table. Aborting');
182: bis_collection_utilities.put_line('Error Number: ' || retcode);
183: bis_collection_utilities.put_line('Error Message: '|| errbuf);
184: --
185: END set_last_run_date;
186: --
187: /****************************** RESET_LAST_RUN_DATE **************************/

Line 219: bis_collection_utilities.put_line('Failed to update collection date'

215: retcode := SQLCODE;
216: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
217: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
218: --
219: bis_collection_utilities.put_line('Failed to update collection date'
220: ||' in log table. Aborting');
221: bis_collection_utilities.put_line('Error Number: ' || retcode);
222: bis_collection_utilities.put_line('Error Message: '|| errbuf);
223: --

Line 221: bis_collection_utilities.put_line('Error Number: ' || retcode);

217: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
218: --
219: bis_collection_utilities.put_line('Failed to update collection date'
220: ||' in log table. Aborting');
221: bis_collection_utilities.put_line('Error Number: ' || retcode);
222: bis_collection_utilities.put_line('Error Message: '|| errbuf);
223: --
224: END reset_last_run_date;
225: --

Line 222: bis_collection_utilities.put_line('Error Message: '|| errbuf);

218: --
219: bis_collection_utilities.put_line('Failed to update collection date'
220: ||' in log table. Aborting');
221: bis_collection_utilities.put_line('Error Number: ' || retcode);
222: bis_collection_utilities.put_line('Error Message: '|| errbuf);
223: --
224: END reset_last_run_date;
225: --
226: /*************************** CLEANUP_STAGING_INDEX ***************************/

Line 262: bis_collection_utilities.put_line('Dropped the Indexes on Staging Tables');

258: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_ex_stg'
259: ,p_owner => l_schema
260: ,p_retcode => retcode);
261: --
262: bis_collection_utilities.put_line('Dropped the Indexes on Staging Tables');
263: l_stmt_num := 50;
264: END IF;
265: l_stmt_num := 60;
266: EXCEPTION

Line 272: bis_collection_utilities.put_line('Error Number: ' || retcode);

268: retcode := SQLCODE;
269: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
270: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
271: --
272: bis_collection_utilities.put_line('Error Number: ' || retcode);
273: bis_collection_utilities.put_line('Error Message: '|| errbuf);
274: --
275: END cleanup_staging_index;
276: --

Line 273: bis_collection_utilities.put_line('Error Message: '|| errbuf);

269: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
270: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
271: --
272: bis_collection_utilities.put_line('Error Number: ' || retcode);
273: bis_collection_utilities.put_line('Error Message: '|| errbuf);
274: --
275: END cleanup_staging_index;
276: --
277: /*************************** RESET_STAGING_INDEX *****************************/

Line 316: bis_collection_utilities.put_line('Recreated the Indexes on the '

312: ,p_retcode =>retcode);
313: --
314: l_stmt_num := 50;
315: --
316: bis_collection_utilities.put_line('Recreated the Indexes on the '
317: ||'Staging Tables');
318: END IF;
319: l_stmt_num := 60;
320: --

Line 327: bis_collection_utilities.put_line('Error Number: ' || retcode);

323: retcode := SQLCODE;
324: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
325: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
326: --
327: bis_collection_utilities.put_line('Error Number: ' || retcode);
328: bis_collection_utilities.put_line('Error Message: '|| errbuf);
329: --
330: END reset_staging_index;
331: /*************************** CLEANUP_INITIAL_DATA ****************************/

Line 328: bis_collection_utilities.put_line('Error Message: '|| errbuf);

324: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
325: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
326: --
327: bis_collection_utilities.put_line('Error Number: ' || retcode);
328: bis_collection_utilities.put_line('Error Message: '|| errbuf);
329: --
330: END reset_staging_index;
331: /*************************** CLEANUP_INITIAL_DATA ****************************/
332: PROCEDURE cleanup_initial_data(errbuf IN OUT NOCOPY VARCHAR2

Line 367: bis_collection_utilities.put_line('Truncated the Staging Tables');

363: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_tasks_stg';
364: l_stmt_num := 50;
365: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_ex_stg';
366: l_stmt_num := 60;
367: bis_collection_utilities.put_line('Truncated the Staging Tables');
368: --Truncate Fact Tables along with MV Logs
369: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema
370: ||'.opi_dbi_wms_op_f PURGE MATERIALIZED VIEW LOG';
371: l_stmt_num := 70;

Line 378: bis_collection_utilities.put_line('Truncated the Fact Tables');

374: l_stmt_num := 80;
375: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema
376: ||'.opi_dbi_wms_ex_f PURGE MATERIALIZED VIEW LOG';
377: --
378: bis_collection_utilities.put_line('Truncated the Fact Tables');
379: l_stmt_num := 90;
380: END IF;
381: EXCEPTION
382: WHEN OTHERS THEN

Line 387: bis_collection_utilities.put_line('Error Number: ' || retcode);

383: retcode := SQLCODE;
384: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
385: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
386: --
387: bis_collection_utilities.put_line('Error Number: ' || retcode);
388: bis_collection_utilities.put_line('Error Message: '|| errbuf);
389: --
390: END cleanup_initial_data;
391: --

Line 388: bis_collection_utilities.put_line('Error Message: '|| errbuf);

384: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
385: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
386: --
387: bis_collection_utilities.put_line('Error Number: ' || retcode);
388: bis_collection_utilities.put_line('Error Message: '|| errbuf);
389: --
390: END cleanup_initial_data;
391: --
392: /*************************** CLEANUP_STAGING_DATA ****************************/

Line 429: bis_collection_utilities.put_line('Error Number: ' || retcode);

425: retcode := SQLCODE;
426: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
427: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
428: --
429: bis_collection_utilities.put_line('Error Number: ' || retcode);
430: bis_collection_utilities.put_line('Error Message: '|| errbuf);
431: --
432: END cleanup_staging_data;
433: --

Line 430: bis_collection_utilities.put_line('Error Message: '|| errbuf);

426: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
427: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
428: --
429: bis_collection_utilities.put_line('Error Number: ' || retcode);
430: bis_collection_utilities.put_line('Error Message: '|| errbuf);
431: --
432: END cleanup_staging_data;
433: --
434: /*************************** WRAPUP_SUCCESS **********************************/

Line 458: bis_collection_utilities.wrapup(p_status => TRUE

454: ELSIF program_type = 'INCR' THEN
455: l_message := 'Successful in Incremental Load';
456: END IF;
457: --
458: bis_collection_utilities.wrapup(p_status => TRUE
459: ,p_count => g_row_count
460: ,p_message => l_message
461: );
462: l_stmt_num := 20;

Line 472: bis_collection_utilities.put_line('Error Number: ' || retcode);

468: retcode := SQLCODE;
469: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
470: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
471: --
472: bis_collection_utilities.put_line('Error Number: ' || retcode);
473: bis_collection_utilities.put_line('Error Message: '|| errbuf);
474: --
475: END wrapup_success;
476: --

Line 473: bis_collection_utilities.put_line('Error Message: '|| errbuf);

469: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
470: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
471: --
472: bis_collection_utilities.put_line('Error Number: ' || retcode);
473: bis_collection_utilities.put_line('Error Message: '|| errbuf);
474: --
475: END wrapup_success;
476: --
477: /*************************** WRAPUP_FAILURE **********************************/

Line 498: bis_collection_utilities.wrapup(p_status => FALSE

494: ELSIF program_type = 'INCR' THEN
495: l_message := 'Failed in Incremental Load';
496: END IF;
497: --
498: bis_collection_utilities.wrapup(p_status => FALSE
499: ,p_count => 0
500: ,p_message => l_message
501: );
502: l_stmt_num := 20;

Line 571: bis_collection_utilities.put_line('Error Number: ' || retcode);

567: retcode := SQLCODE;
568: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
569: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
570: --
571: bis_collection_utilities.put_line('Error Number: ' || retcode);
572: bis_collection_utilities.put_line('Error Message: '|| errbuf);
573: --
574: END staging_gather_stats;
575: --

Line 572: bis_collection_utilities.put_line('Error Message: '|| errbuf);

568: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
569: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
570: --
571: bis_collection_utilities.put_line('Error Number: ' || retcode);
572: bis_collection_utilities.put_line('Error Message: '|| errbuf);
573: --
574: END staging_gather_stats;
575: --
576: /*********************** PRINT_GSD_MESSAGE ***********************************/

Line 579: BIS_COLLECTION_UTILITIES.put_line(

575: --
576: /*********************** PRINT_GSD_MESSAGE ***********************************/
577: PROCEDURE print_gsd_message(p_gsd IN DATE) IS
578: BEGIN
579: BIS_COLLECTION_UTILITIES.put_line(
580: '*****************************************'
581: ||'*************************************');
582: BIS_COLLECTION_UTILITIES.put_line(
583: 'The Picks '||fnd_global.local_chr(38)

Line 582: BIS_COLLECTION_UTILITIES.put_line(

578: BEGIN
579: BIS_COLLECTION_UTILITIES.put_line(
580: '*****************************************'
581: ||'*************************************');
582: BIS_COLLECTION_UTILITIES.put_line(
583: 'The Picks '||fnd_global.local_chr(38)
584: ||' Exception Analysis reports as well as the '
585: ||'Operation Plan');
586: BIS_COLLECTION_UTILITIES.put_line(

Line 586: BIS_COLLECTION_UTILITIES.put_line(

582: BIS_COLLECTION_UTILITIES.put_line(
583: 'The Picks '||fnd_global.local_chr(38)
584: ||' Exception Analysis reports as well as the '
585: ||'Operation Plan');
586: BIS_COLLECTION_UTILITIES.put_line(
587: 'Performance reports are suppported only from the date the '
588: ||'WMS CU1 patch was');
589: BIS_COLLECTION_UTILITIES.put_line(
590: 'applied. Hence, this extraction includes data from '

Line 589: BIS_COLLECTION_UTILITIES.put_line(

585: ||'Operation Plan');
586: BIS_COLLECTION_UTILITIES.put_line(
587: 'Performance reports are suppported only from the date the '
588: ||'WMS CU1 patch was');
589: BIS_COLLECTION_UTILITIES.put_line(
590: 'applied. Hence, this extraction includes data from '
591: ||to_char(p_gsd,'MM/DD/YYYY HH24:MI:SS')||' to '
592: ||to_char(g_sysdate,'MM/DD/YYYY HH24:MI:SS')||'. ');
593: BIS_COLLECTION_UTILITIES.put_line(

Line 593: BIS_COLLECTION_UTILITIES.put_line(

589: BIS_COLLECTION_UTILITIES.put_line(
590: 'applied. Hence, this extraction includes data from '
591: ||to_char(p_gsd,'MM/DD/YYYY HH24:MI:SS')||' to '
592: ||to_char(g_sysdate,'MM/DD/YYYY HH24:MI:SS')||'. ');
593: BIS_COLLECTION_UTILITIES.put_line(
594: 'The following are the reports affected by '
595: ||'this restriction:');
596: BIS_COLLECTION_UTILITIES.put_line(' ');
597: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)

Line 596: BIS_COLLECTION_UTILITIES.put_line(' ');

592: ||to_char(g_sysdate,'MM/DD/YYYY HH24:MI:SS')||'. ');
593: BIS_COLLECTION_UTILITIES.put_line(
594: 'The following are the reports affected by '
595: ||'this restriction:');
596: BIS_COLLECTION_UTILITIES.put_line(' ');
597: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
598: ||' Exceptions Analysis ');
599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
600: ||' Exceptions Trend ');

Line 597: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)

593: BIS_COLLECTION_UTILITIES.put_line(
594: 'The following are the reports affected by '
595: ||'this restriction:');
596: BIS_COLLECTION_UTILITIES.put_line(' ');
597: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
598: ||' Exceptions Analysis ');
599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
600: ||' Exceptions Trend ');
601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');

Line 599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)

595: ||'this restriction:');
596: BIS_COLLECTION_UTILITIES.put_line(' ');
597: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
598: ||' Exceptions Analysis ');
599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
600: ||' Exceptions Trend ');
601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');
602: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Performance ');
603: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Exceptions By Reason');

Line 601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');

597: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
598: ||' Exceptions Analysis ');
599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
600: ||' Exceptions Trend ');
601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');
602: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Performance ');
603: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Exceptions By Reason');
604: BIS_COLLECTION_UTILITIES.put_line(
605: '*****************************************'

Line 602: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Performance ');

598: ||' Exceptions Analysis ');
599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
600: ||' Exceptions Trend ');
601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');
602: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Performance ');
603: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Exceptions By Reason');
604: BIS_COLLECTION_UTILITIES.put_line(
605: '*****************************************'
606: ||'*************************************');

Line 603: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Exceptions By Reason');

599: BIS_COLLECTION_UTILITIES.put_line('Picks '||fnd_global.local_chr(38)
600: ||' Exceptions Trend ');
601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');
602: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Performance ');
603: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Exceptions By Reason');
604: BIS_COLLECTION_UTILITIES.put_line(
605: '*****************************************'
606: ||'*************************************');
607: END print_gsd_message;

Line 604: BIS_COLLECTION_UTILITIES.put_line(

600: ||' Exceptions Trend ');
601: BIS_COLLECTION_UTILITIES.put_line('Pick Exceptions By Reason ');
602: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Performance ');
603: BIS_COLLECTION_UTILITIES.put_line('Operation Plan Exceptions By Reason');
604: BIS_COLLECTION_UTILITIES.put_line(
605: '*****************************************'
606: ||'*************************************');
607: END print_gsd_message;
608: --

Line 649: bis_collection_utilities.put_line(errbuf);

645: retcode := -1;
646: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
647: ||l_stmt_num
648: ||errbuf;
649: bis_collection_utilities.put_line(errbuf);
650: RAISE no_initial_data;
651: WHEN OTHERS THEN
652: retcode := SQLCODE;
653: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '

Line 656: bis_collection_utilities.put_line('Error Number: ' || retcode);

652: retcode := SQLCODE;
653: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
654: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
655: --
656: bis_collection_utilities.put_line('Error Number: ' || retcode);
657: bis_collection_utilities.put_line('Error Message: '|| errbuf);
658: --
659: END check_last_run_date;
660: --

Line 657: bis_collection_utilities.put_line('Error Message: '|| errbuf);

653: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
654: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
655: --
656: bis_collection_utilities.put_line('Error Number: ' || retcode);
657: bis_collection_utilities.put_line('Error Message: '|| errbuf);
658: --
659: END check_last_run_date;
660: --
661: /*************************** INIT_TASKS **************************************

Line 722: bis_collection_utilities.put_line('Finished collection of Tasks '

718: AND wdth.status in (6,11);
719: --
720: l_stmt_num := 20;
721: l_row_count := sql%rowcount;
722: bis_collection_utilities.put_line('Finished collection of Tasks '
723: ||'into Tasks Staging Table : '
724: ||l_row_count||' row(s) processed');
725: --
726: l_stmt_num := 30;

Line 736: bis_collection_utilities.put_line('Error Number: ' || retcode);

732: retcode := SQLCODE;
733: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
734: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
735: --
736: bis_collection_utilities.put_line('Error Number: ' || retcode);
737: bis_collection_utilities.put_line('Error Message: '|| errbuf);
738: --
739: END init_tasks;
740: --

Line 737: bis_collection_utilities.put_line('Error Message: '|| errbuf);

733: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
734: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
735: --
736: bis_collection_utilities.put_line('Error Number: ' || retcode);
737: bis_collection_utilities.put_line('Error Message: '|| errbuf);
738: --
739: END init_tasks;
740: --
741: /*************************** INIT_OPS ****************************************/

Line 804: bis_collection_utilities.put_line('Finished collection of Operation Plans '

800: AND tasks.task_type in (2,8);
801: --
802: l_stmt_num := 20;
803: l_row_count := sql%rowcount;
804: bis_collection_utilities.put_line('Finished collection of Operation Plans '
805: ||'into OP Staging Table : '
806: ||l_row_count||' row(s) processed');
807: --
808: l_stmt_num := 30;

Line 818: bis_collection_utilities.put_line('Error Number: ' || retcode);

814: retcode := SQLCODE;
815: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
816: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
817: --
818: bis_collection_utilities.put_line('Error Number: ' || retcode);
819: bis_collection_utilities.put_line('Error Message: '|| errbuf);
820: --
821: END init_ops;
822: --

Line 819: bis_collection_utilities.put_line('Error Message: '|| errbuf);

815: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
816: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
817: --
818: bis_collection_utilities.put_line('Error Number: ' || retcode);
819: bis_collection_utilities.put_line('Error Message: '|| errbuf);
820: --
821: END init_ops;
822: --
823: /*************************** INIT_EXS ****************************************/

Line 901: bis_collection_utilities.put_line('Finished collection of Exceptions '

897: AND mtr.reason_id = wmx.reason_id;
898: --
899: l_stmt_num := 20;
900: l_row_count := sql%rowcount;
901: bis_collection_utilities.put_line('Finished collection of Exceptions '
902: ||'into Exceptions Staging Table : '
903: ||l_row_count||' row(s) processed');
904: --
905: l_stmt_num := 30;

Line 915: bis_collection_utilities.put_line('Error Number: ' || retcode);

911: retcode := SQLCODE;
912: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
913: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
914: --
915: bis_collection_utilities.put_line('Error Number: ' || retcode);
916: bis_collection_utilities.put_line('Error Message: '|| errbuf);
917: --
918: END init_exs;
919: --

Line 916: bis_collection_utilities.put_line('Error Message: '|| errbuf);

912: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
913: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
914: --
915: bis_collection_utilities.put_line('Error Number: ' || retcode);
916: bis_collection_utilities.put_line('Error Message: '|| errbuf);
917: --
918: END init_exs;
919: --
920: /*************************** INIT_TASKF **************************************/

Line 990: bis_collection_utilities.put_line('Finished Loading Pick Tasks '

986: --
987: l_stmt_num := 20;
988: l_row_count := sql%rowcount;
989: g_row_count := nvl(g_row_count,0) + l_row_count;
990: bis_collection_utilities.put_line('Finished Loading Pick Tasks '
991: ||'into Tasks Fact Table : '
992: ||l_row_count||' row(s) processed');
993: --
994: l_stmt_num := 40;

Line 1001: bis_collection_utilities.put_line('Tasks Fact Initial '

997: l_stmt_num := 50;
998: EXCEPTION
999: WHEN OTHERS THEN
1000: retcode := SQLCODE;
1001: bis_collection_utilities.put_line('Tasks Fact Initial '
1002: ||'Load Failed.');
1003: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1004: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1005: --

Line 1006: bis_collection_utilities.put_line('Error Number: ' || retcode);

1002: ||'Load Failed.');
1003: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1004: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1005: --
1006: bis_collection_utilities.put_line('Error Number: ' || retcode);
1007: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1008: --
1009: END init_taskf;
1010: --

Line 1007: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1003: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1004: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1005: --
1006: bis_collection_utilities.put_line('Error Number: ' || retcode);
1007: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1008: --
1009: END init_taskf;
1010: --
1011: /*************************** INIT_OPF ****************************************/

Line 1088: bis_collection_utilities.put_line('Finished Loading Operation Plans '

1084: --
1085: l_stmt_num := 20;
1086: l_row_count := sql%rowcount;
1087: g_row_count := nvl(g_row_count,0) + l_row_count;
1088: bis_collection_utilities.put_line('Finished Loading Operation Plans '
1089: ||'into OP Fact Table : '
1090: ||l_row_count||' row(s) processed');
1091: --
1092: l_stmt_num := 30;

Line 1099: bis_collection_utilities.put_line('Operation Plans Fact Initial '

1095: l_stmt_num := 40;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: retcode := SQLCODE;
1099: bis_collection_utilities.put_line('Operation Plans Fact Initial '
1100: ||'Load Failed.');
1101: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1102: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1103: --

Line 1104: bis_collection_utilities.put_line('Error Number: ' || retcode);

1100: ||'Load Failed.');
1101: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1102: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1103: --
1104: bis_collection_utilities.put_line('Error Number: ' || retcode);
1105: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1106: --
1107: END init_opf;
1108: --

Line 1105: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1101: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1102: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1103: --
1104: bis_collection_utilities.put_line('Error Number: ' || retcode);
1105: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1106: --
1107: END init_opf;
1108: --
1109: /*************************** INIT_EXF ****************************************/

Line 1177: bis_collection_utilities.put_line('Finished Loading Exceptions '

1173: --
1174: l_stmt_num := 20;
1175: l_row_count := sql%rowcount;
1176: g_row_count := nvl(g_row_count,0) + l_row_count;
1177: bis_collection_utilities.put_line('Finished Loading Exceptions '
1178: ||'into Exceptions Fact Table : '
1179: ||l_row_count||' row(s) processed');
1180: --
1181: l_stmt_num := 30;

Line 1187: bis_collection_utilities.put_line('Exceptions Fact Initial '

1183: --
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: retcode := SQLCODE;
1187: bis_collection_utilities.put_line('Exceptions Fact Initial '
1188: ||'Load Failed.');
1189: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1190: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1191: --

Line 1192: bis_collection_utilities.put_line('Error Number: ' || retcode);

1188: ||'Load Failed.');
1189: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1190: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1191: --
1192: bis_collection_utilities.put_line('Error Number: ' || retcode);
1193: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1194: --
1195: END init_exf;
1196: --

Line 1193: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1189: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1190: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1191: --
1192: bis_collection_utilities.put_line('Error Number: ' || retcode);
1193: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1194: --
1195: END init_exf;
1196: --
1197: /*************************** INCR_TASKS **************************************/

Line 1255: bis_collection_utilities.put_line('Finished collection of Tasks '

1251: AND wdth.status in (6,11);
1252: --
1253: l_stmt_num := 20;
1254: l_row_count := sql%rowcount;
1255: bis_collection_utilities.put_line('Finished collection of Tasks '
1256: ||'into Tasks Staging Table : '
1257: ||l_row_count||' row(s) processed');
1258: --
1259: l_stmt_num := 30;

Line 1268: bis_collection_utilities.put_line('Error Number: ' || retcode);

1264: retcode := SQLCODE;
1265: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1266: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1267: --
1268: bis_collection_utilities.put_line('Error Number: ' || retcode);
1269: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1270: --
1271: END incr_tasks;
1272: --

Line 1269: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1265: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1266: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1267: --
1268: bis_collection_utilities.put_line('Error Number: ' || retcode);
1269: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1270: --
1271: END incr_tasks;
1272: --
1273: /*************************** INCR_OPS ****************************************/

Line 1336: bis_collection_utilities.put_line('Finished collection of Operation Plans '

1332: AND wdth.task_type in (2,8);
1333: --
1334: l_stmt_num := 20;
1335: l_row_count := sql%rowcount;
1336: bis_collection_utilities.put_line('Finished collection of Operation Plans '
1337: ||'into OP Staging Table : '
1338: ||l_row_count||' row(s) processed');
1339: --
1340: l_stmt_num := 30;

Line 1349: bis_collection_utilities.put_line('Error Number: ' || retcode);

1345: retcode := SQLCODE;
1346: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1347: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1348: --
1349: bis_collection_utilities.put_line('Error Number: ' || retcode);
1350: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1351: --
1352: END incr_ops;
1353: --

Line 1350: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1346: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1347: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1348: --
1349: bis_collection_utilities.put_line('Error Number: ' || retcode);
1350: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1351: --
1352: END incr_ops;
1353: --
1354: /*************************** INCR_EXS ****************************************/

Line 1428: bis_collection_utilities.put_line('Finished collection of Exceptions '

1424: AND mtr.reason_id = wmx.reason_id;
1425: --
1426: l_stmt_num := 20;
1427: l_row_count := sql%rowcount;
1428: bis_collection_utilities.put_line('Finished collection of Exceptions '
1429: ||'into Exceptions Staging Table : '
1430: ||l_row_count||' row(s) processed');
1431: --
1432: l_stmt_num := 30;

Line 1441: bis_collection_utilities.put_line('Error Number: ' || retcode);

1437: retcode := SQLCODE;
1438: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1439: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1440: --
1441: bis_collection_utilities.put_line('Error Number: ' || retcode);
1442: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1443: --
1444: END incr_exs;
1445: --

Line 1442: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1438: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1439: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1440: --
1441: bis_collection_utilities.put_line('Error Number: ' || retcode);
1442: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1443: --
1444: END incr_exs;
1445: --
1446: /*************************** INCR_TASKF **************************************/

Line 1537: bis_collection_utilities.put_line('Finished Loading Pick Tasks '

1533: --
1534: l_stmt_num := 20;
1535: l_row_count := sql%rowcount;
1536: g_row_count := nvl(g_row_count,0) + l_row_count;
1537: bis_collection_utilities.put_line('Finished Loading Pick Tasks '
1538: ||'into Tasks Fact Table : '
1539: ||l_row_count||' row(s) processed');
1540: --
1541: l_stmt_num := 40;

Line 1547: bis_collection_utilities.put_line('Tasks Fact Incremental '

1543: l_stmt_num := 50;
1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: retcode := SQLCODE;
1547: bis_collection_utilities.put_line('Tasks Fact Incremental '
1548: ||'Load Failed.');
1549: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1550: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1551: --

Line 1552: bis_collection_utilities.put_line('Error Number: ' || retcode);

1548: ||'Load Failed.');
1549: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1550: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1551: --
1552: bis_collection_utilities.put_line('Error Number: ' || retcode);
1553: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1554: --
1555: END incr_taskf;
1556: --

Line 1553: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1549: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1550: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1551: --
1552: bis_collection_utilities.put_line('Error Number: ' || retcode);
1553: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1554: --
1555: END incr_taskf;
1556: --
1557: /*************************** INCR_OPF ****************************************/

Line 1664: bis_collection_utilities.put_line('Finished Loading Operation Plans '

1660: --
1661: l_stmt_num := 20;
1662: l_row_count := sql%rowcount;
1663: g_row_count := nvl(g_row_count,0) + l_row_count;
1664: bis_collection_utilities.put_line('Finished Loading Operation Plans '
1665: ||'into OP Fact Table : '
1666: ||l_row_count||' row(s) processed');
1667: --
1668: l_stmt_num := 30;

Line 1675: bis_collection_utilities.put_line('Operation Plans Fact Incremental '

1671: l_stmt_num := 40;
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: retcode := SQLCODE;
1675: bis_collection_utilities.put_line('Operation Plans Fact Incremental '
1676: ||'Load Failed.');
1677: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1678: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1679: --

Line 1680: bis_collection_utilities.put_line('Error Number: ' || retcode);

1676: ||'Load Failed.');
1677: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1678: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1679: --
1680: bis_collection_utilities.put_line('Error Number: ' || retcode);
1681: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1682: --
1683: END incr_opf;
1684: --

Line 1681: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1677: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1678: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1679: --
1680: bis_collection_utilities.put_line('Error Number: ' || retcode);
1681: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1682: --
1683: END incr_opf;
1684: --
1685: /*************************** INCR_EXF ****************************************/

Line 1777: bis_collection_utilities.put_line('Finished Loading Exceptions '

1773: --
1774: l_stmt_num := 20;
1775: l_row_count := sql%rowcount;
1776: g_row_count := nvl(g_row_count,0) + l_row_count;
1777: bis_collection_utilities.put_line('Finished Loading Exceptions '
1778: ||'into Exceptions Fact Table : '
1779: ||l_row_count||' row(s) processed');
1780: --
1781: l_stmt_num := 30;

Line 1787: bis_collection_utilities.put_line('Exceptions Fact Incremental '

1783: --
1784: EXCEPTION
1785: WHEN OTHERS THEN
1786: retcode := SQLCODE;
1787: bis_collection_utilities.put_line('Exceptions Fact Incremental '
1788: ||'Load Failed.');
1789: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1790: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1791: --

Line 1792: bis_collection_utilities.put_line('Error Number: ' || retcode);

1788: ||'Load Failed.');
1789: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1790: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1791: --
1792: bis_collection_utilities.put_line('Error Number: ' || retcode);
1793: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1794: --
1795: END incr_exf;
1796: --

Line 1793: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1789: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1790: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1791: --
1792: bis_collection_utilities.put_line('Error Number: ' || retcode);
1793: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1794: --
1795: END incr_exf;
1796: --
1797: --Public Procedures

Line 1860: bis_collection_utilities.put_line('Error Number: ' || retcode);

1856: errbuf := 'Warning in '||g_package||l_procedure||' at line#: '
1857: ||l_stmt_num||' - '
1858: ||'No data avialble for extraction';
1859: --
1860: bis_collection_utilities.put_line('Error Number: ' || retcode);
1861: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1862: --
1863: END;
1864: --

Line 1861: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1857: ||l_stmt_num||' - '
1858: ||'No data avialble for extraction';
1859: --
1860: bis_collection_utilities.put_line('Error Number: ' || retcode);
1861: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1862: --
1863: END;
1864: --
1865: print_gsd_message(l_wms_gsd);

Line 1876: bis_collection_utilities.put_line

1872: END IF;
1873: --
1874: l_stmt_num := 100;
1875: --
1876: bis_collection_utilities.put_line
1877: ('Initial Load starts at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1878: --
1879: l_stmt_num := 110;
1880: --

Line 1881: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN

1877: ('Initial Load starts at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1878: --
1879: l_stmt_num := 110;
1880: --
1881: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN
1882: --
1883: l_stmt_num := 120;
1884: RAISE_APPLICATION_ERROR(-20000, errbuf);
1885: END IF;

Line 1939: bis_collection_utilities.put_line('Global Parameters are not setup.');

1935: --
1936: ELSE
1937: l_stmt_num := 280;
1938: retcode := g_error;
1939: bis_collection_utilities.put_line('Global Parameters are not setup.');
1940: bis_collection_utilities.put_line('Please check that the profile option '
1941: ||'BIS_GLOBAL_START_DATE is setup.');
1942: wrapup_failure('INIT');
1943: l_stmt_num := 290;

Line 1940: bis_collection_utilities.put_line('Please check that the profile option '

1936: ELSE
1937: l_stmt_num := 280;
1938: retcode := g_error;
1939: bis_collection_utilities.put_line('Global Parameters are not setup.');
1940: bis_collection_utilities.put_line('Please check that the profile option '
1941: ||'BIS_GLOBAL_START_DATE is setup.');
1942: wrapup_failure('INIT');
1943: l_stmt_num := 290;
1944: END IF;

Line 1949: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1945: EXCEPTION
1946: WHEN GSD_NOT_AVAILABLE THEN
1947: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1948: ||l_stmt_num;
1949: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1950: bis_collection_utilities.put_line('Global start date'
1951: ||' is not available.'
1952: ||' Aborting.');
1953: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

Line 1950: bis_collection_utilities.put_line('Global start date'

1946: WHEN GSD_NOT_AVAILABLE THEN
1947: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1948: ||l_stmt_num;
1949: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1950: bis_collection_utilities.put_line('Global start date'
1951: ||' is not available.'
1952: ||' Aborting.');
1953: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
1954: retcode := SQLCODE;

Line 1953: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

1949: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1950: bis_collection_utilities.put_line('Global start date'
1951: ||' is not available.'
1952: ||' Aborting.');
1953: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
1954: retcode := SQLCODE;
1955: errbuf := SQLERRM;
1956: WHEN OTHERS THEN
1957: retcode := SQLCODE;

Line 1958: bis_collection_utilities.put_line('Initial Load Failed.');

1954: retcode := SQLCODE;
1955: errbuf := SQLERRM;
1956: WHEN OTHERS THEN
1957: retcode := SQLCODE;
1958: bis_collection_utilities.put_line('Initial Load Failed.');
1959: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1960: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1961: --
1962: bis_collection_utilities.put_line('Error Number: ' || retcode);

Line 1962: bis_collection_utilities.put_line('Error Number: ' || retcode);

1958: bis_collection_utilities.put_line('Initial Load Failed.');
1959: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1960: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1961: --
1962: bis_collection_utilities.put_line('Error Number: ' || retcode);
1963: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1964: --
1965: wrapup_failure('INIT');
1966: --

Line 1963: bis_collection_utilities.put_line('Error Message: '|| errbuf);

1959: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
1960: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
1961: --
1962: bis_collection_utilities.put_line('Error Number: ' || retcode);
1963: bis_collection_utilities.put_line('Error Message: '|| errbuf);
1964: --
1965: wrapup_failure('INIT');
1966: --
1967: RAISE_APPLICATION_ERROR(-20000,errbuf);

Line 2026: bis_collection_utilities.put_line('Error Number: ' || retcode);

2022: errbuf := 'Warning in '||g_package||l_procedure||' at line#: '
2023: ||l_stmt_num||' - '
2024: ||'No data avialble for extraction';
2025: --
2026: bis_collection_utilities.put_line('Error Number: ' || retcode);
2027: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2028: --
2029: END;
2030: --

Line 2027: bis_collection_utilities.put_line('Error Message: '|| errbuf);

2023: ||l_stmt_num||' - '
2024: ||'No data avialble for extraction';
2025: --
2026: bis_collection_utilities.put_line('Error Number: ' || retcode);
2027: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2028: --
2029: END;
2030: --
2031: print_gsd_message(l_wms_gsd);

Line 2043: bis_collection_utilities.put_line

2039: END IF;
2040: --
2041: l_stmt_num := 100;
2042: --
2043: bis_collection_utilities.put_line
2044: ('Incremental Load starts at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2045: --
2046: l_stmt_num := 110;
2047: --

Line 2048: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN

2044: ('Incremental Load starts at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2045: --
2046: l_stmt_num := 110;
2047: --
2048: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WMS_TASKS_F') = FALSE THEN
2049: --
2050: l_stmt_num := 120;
2051: RAISE_APPLICATION_ERROR(-20000, errbuf);
2052: END IF;

Line 2093: bis_collection_utilities.put_line('Global Parameters are not setup.');

2089: l_stmt_num := 270;
2090: ELSE
2091: l_stmt_num := 280;
2092: retcode := g_error;
2093: bis_collection_utilities.put_line('Global Parameters are not setup.');
2094: bis_collection_utilities.put_line('Please check that the profile option '
2095: ||'BIS_GLOBAL_START_DATE is setup.');
2096: wrapup_failure('INCR');
2097: l_stmt_num := 290;

Line 2094: bis_collection_utilities.put_line('Please check that the profile option '

2090: ELSE
2091: l_stmt_num := 280;
2092: retcode := g_error;
2093: bis_collection_utilities.put_line('Global Parameters are not setup.');
2094: bis_collection_utilities.put_line('Please check that the profile option '
2095: ||'BIS_GLOBAL_START_DATE is setup.');
2096: wrapup_failure('INCR');
2097: l_stmt_num := 290;
2098: END IF;

Line 2104: bis_collection_utilities.put_line('Error Message: '|| errbuf);

2100: EXCEPTION
2101: WHEN GSD_NOT_AVAILABLE THEN
2102: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2103: ||l_stmt_num;
2104: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2105: bis_collection_utilities.put_line('Global start date'
2106: ||' is not available.'
2107: ||' Aborting.');
2108: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

Line 2105: bis_collection_utilities.put_line('Global start date'

2101: WHEN GSD_NOT_AVAILABLE THEN
2102: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2103: ||l_stmt_num;
2104: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2105: bis_collection_utilities.put_line('Global start date'
2106: ||' is not available.'
2107: ||' Aborting.');
2108: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
2109: retcode := SQLCODE;

Line 2108: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

2104: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2105: bis_collection_utilities.put_line('Global start date'
2106: ||' is not available.'
2107: ||' Aborting.');
2108: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
2109: retcode := SQLCODE;
2110: errbuf := SQLERRM;
2111: WHEN NO_INITIAL_DATA THEN
2112: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '

Line 2114: bis_collection_utilities.put_line('Error Message: '|| errbuf);

2110: errbuf := SQLERRM;
2111: WHEN NO_INITIAL_DATA THEN
2112: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2113: ||l_stmt_num;
2114: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2115: bis_collection_utilities.put_line(' Initial Load data is not available,'
2116: ||' Please run the Initial Load');
2117: retcode := -1;
2118: WHEN OTHERS THEN

Line 2115: bis_collection_utilities.put_line(' Initial Load data is not available,'

2111: WHEN NO_INITIAL_DATA THEN
2112: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2113: ||l_stmt_num;
2114: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2115: bis_collection_utilities.put_line(' Initial Load data is not available,'
2116: ||' Please run the Initial Load');
2117: retcode := -1;
2118: WHEN OTHERS THEN
2119: retcode := SQLCODE;

Line 2120: bis_collection_utilities.put_line('Incremental Load Failed.');

2116: ||' Please run the Initial Load');
2117: retcode := -1;
2118: WHEN OTHERS THEN
2119: retcode := SQLCODE;
2120: bis_collection_utilities.put_line('Incremental Load Failed.');
2121: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2122: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
2123: --
2124: bis_collection_utilities.put_line('Error Number: ' || retcode);

Line 2124: bis_collection_utilities.put_line('Error Number: ' || retcode);

2120: bis_collection_utilities.put_line('Incremental Load Failed.');
2121: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2122: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
2123: --
2124: bis_collection_utilities.put_line('Error Number: ' || retcode);
2125: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2126: --
2127: wrapup_failure('INCR');
2128: --

Line 2125: bis_collection_utilities.put_line('Error Message: '|| errbuf);

2121: errbuf := 'ERROR in '||g_package||l_procedure||' at line#: '
2122: ||l_stmt_num||' - '||substr(SQLERRM, 1,200);
2123: --
2124: bis_collection_utilities.put_line('Error Number: ' || retcode);
2125: bis_collection_utilities.put_line('Error Message: '|| errbuf);
2126: --
2127: wrapup_failure('INCR');
2128: --
2129: RAISE_APPLICATION_ERROR(-20000,errbuf);