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

Line 90: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing dates in Time Dimension.');

86:
87: IF l_missing_day_flag THEN
88: retcode := 1;
89: errbuf := 'Please check log file for details. ';
90: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing dates in Time Dimension.');
91:
92: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date
93: ||' to ' || l_max_miss_date );
94: END IF;

Line 92: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date

88: retcode := 1;
89: errbuf := 'Please check log file for details. ';
90: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing dates in Time Dimension.');
91:
92: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date
93: ||' to ' || l_max_miss_date );
94: END IF;
95: ELSE
96: retcode := 1;

Line 98: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

94: END IF;
95: ELSE
96: retcode := 1;
97: errbuf := 'Please check log file for details. ';
98: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
99:
100: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
101:
102: END IF;

Line 100: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');

96: retcode := 1;
97: errbuf := 'Please check log file for details. ';
98: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
99:
100: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
101:
102: END IF;
103:
104: EXCEPTION

Line 111: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

107: l_err_num := SQLCODE;
108: l_err_msg := 'ERROR in OPI_DBI_OPM_COGS_PKG.CHECK_SETUP_GLOBALS '
109: || substr(SQLERRM, 1,200);
110:
111: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
112: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
113:
114: END check_setup_globals;
115:

Line 112: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

108: l_err_msg := 'ERROR in OPI_DBI_OPM_COGS_PKG.CHECK_SETUP_GLOBALS '
109: || substr(SQLERRM, 1,200);
110:
111: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
112: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
113:
114: END check_setup_globals;
115:
116: -- return 0 -- normal

Line 131: bis_collection_utilities.put_line('Load incremental OPM Test Subr cogs into stg '

127: l_stmt NUMBER := 0;
128:
129:
130: BEGIN
131: bis_collection_utilities.put_line('Load incremental OPM Test Subr cogs into stg '
132: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
133:
134: -- Regular sales order
135: insert into opi_dbi_cogs_fstg

Line 237: bis_collection_utilities.put_line('Load incremental OPM Final Subr cogs into stg '

233: ,TURNS_COGS_FLAG
234: ,SOURCE ;
235:
236: commit;
237: bis_collection_utilities.put_line('Load incremental OPM Final Subr cogs into stg '
238: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
239:
240: insert into opi_dbi_cogs_fstg
241: (

Line 362: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);

358: x_msg := NULL;
359: EXCEPTION WHEN OTHERS THEN
360: ROLLBACK;
361:
362: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
363: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
364: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
365: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
366: x_status := 0; -- error

Line 363: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

359: EXCEPTION WHEN OTHERS THEN
360: ROLLBACK;
361:
362: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
363: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
364: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
365: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
366: x_status := 0; -- error
367: x_msg := Sqlerrm;

Line 364: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);

360: ROLLBACK;
361:
362: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
363: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
364: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
365: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
366: x_status := 0; -- error
367: x_msg := Sqlerrm;
368:

Line 365: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

361:
362: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
363: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
364: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
365: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
366: x_status := 0; -- error
367: x_msg := Sqlerrm;
368:
369: END refresh_opm_subl_org_cogs;

Line 382: bis_collection_utilities.put_line('Load OPM Test Subr cogs into stg '

378:
379: l_stmt NUMBER := 0;
380:
381: BEGIN
382: bis_collection_utilities.put_line('Load OPM Test Subr cogs into stg '
383: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
384:
385:
386: -- Regular sales order

Line 492: bis_collection_utilities.put_line('Load OPM Final Subr cogs into stg '

488: ,TURNS_COGS_FLAG
489: ,SOURCE
490: )
491: ;
492: bis_collection_utilities.put_line('Load OPM Final Subr cogs into stg '
493: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
494:
495: commit;
496: insert /*+ append parallel(opi_dbi_cogs_fstg) */ into opi_dbi_cogs_fstg

Line 605: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);

601: x_msg := NULL;
602: EXCEPTION WHEN OTHERS THEN
603: ROLLBACK;
604:
605: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
606: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
607: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
608: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
609: x_status := 0; -- error

Line 606: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

602: EXCEPTION WHEN OTHERS THEN
603: ROLLBACK;
604:
605: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
606: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
607: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
608: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
609: x_status := 0; -- error
610: x_msg := Sqlerrm;

Line 607: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);

603: ROLLBACK;
604:
605: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
606: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
607: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
608: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
609: x_status := 0; -- error
610: x_msg := Sqlerrm;
611:

Line 608: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

604:
605: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
606: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
607: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
608: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
609: x_status := 0; -- error
610: x_msg := Sqlerrm;
611:
612: END initial_opm_subl_org_cogs;

Line 644: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

640: BEGIN
641:
642: retcode := 0;
643:
644: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
645:
646:
647: -- 1. get subledger cogs
648:

Line 676: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ' ||l_last_trx_id );

672: where led.doc_type in ( 'OMSO', 'PORC')
673: and led.acct_ttl_type = 5200
674: AND led.gl_trans_date >= global_start_date;
675:
676: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ' ||l_last_trx_id );
677: BIS_COLLECTION_UTILITIES.PUT_LINE ('Incremental Refresh chosen, but Initial Load may be faster' );
678: END;
679:
680:

Line 677: BIS_COLLECTION_UTILITIES.PUT_LINE ('Incremental Refresh chosen, but Initial Load may be faster' );

673: and led.acct_ttl_type = 5200
674: AND led.gl_trans_date >= global_start_date;
675:
676: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ' ||l_last_trx_id );
677: BIS_COLLECTION_UTILITIES.PUT_LINE ('Incremental Refresh chosen, but Initial Load may be faster' );
678: END;
679:
680:
681:

Line 682: BIS_COLLECTION_UTILITIES.PUT_LINE

678: END;
679:
680:
681:
682: BIS_COLLECTION_UTILITIES.PUT_LINE
683: ('Collecting OPM Subledger COGS for transaction ID range: ' || to_char(l_last_trx_id + 1) ||' - ' || l_new_trx_id);
684:
685:
686:

Line 687: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));

683: ('Collecting OPM Subledger COGS for transaction ID range: ' || to_char(l_last_trx_id + 1) ||' - ' || l_new_trx_id);
684:
685:
686:
687: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));
688:
689: l_batch_from_id := l_last_trx_id;
690: l_batch_to_id := l_new_trx_id;
691:

Line 692: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);

688:
689: l_batch_from_id := l_last_trx_id;
690: l_batch_to_id := l_new_trx_id;
691:
692: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);
693:
694: refresh_opm_subl_org_cogs(
695: l_batch_from_id + 1,
696: l_batch_to_id,

Line 729: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

725: null);
726:
727: COMMIT; -- commit per org
728:
729: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
730:
731: RETURN x_row_count;
732: EXCEPTION WHEN OTHERS THEN
733: ROLLBACK;

Line 735: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );

731: RETURN x_row_count;
732: EXCEPTION WHEN OTHERS THEN
733: ROLLBACK;
734:
735: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );
736: errbuf := Sqlerrm;
737: retcode := 1;
738: RETURN x_row_count;
739: END refresh_opm_cogs;

Line 771: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

767: BEGIN
768:
769: retcode := 0;
770:
771: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
772:
773:
774: -- 1. get subledger cogs
775:

Line 785: BIS_COLLECTION_UTILITIES.PUT_LINE('Initial Refresh' );

781: where tst.doc_type in ( 'OMSO', 'PORC' )
782: and tst.acct_ttl_type = 5200
783: AND tst.gl_trans_date >= global_start_date;
784:
785: BIS_COLLECTION_UTILITIES.PUT_LINE('Initial Refresh' );
786:
787:
788: BIS_COLLECTION_UTILITIES.PUT_LINE
789: ('Collecting OPM Subledger COGS for transaction ID range: ' || l_last_trx_id ||' - ' || l_new_trx_id);

Line 788: BIS_COLLECTION_UTILITIES.PUT_LINE

784:
785: BIS_COLLECTION_UTILITIES.PUT_LINE('Initial Refresh' );
786:
787:
788: BIS_COLLECTION_UTILITIES.PUT_LINE
789: ('Collecting OPM Subledger COGS for transaction ID range: ' || l_last_trx_id ||' - ' || l_new_trx_id);
790:
791:
792: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));

Line 792: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));

788: BIS_COLLECTION_UTILITIES.PUT_LINE
789: ('Collecting OPM Subledger COGS for transaction ID range: ' || l_last_trx_id ||' - ' || l_new_trx_id);
790:
791:
792: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));
793:
794: l_batch_from_id := l_last_trx_id;
795: l_batch_to_id := l_new_trx_id;
796:

Line 797: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);

793:
794: l_batch_from_id := l_last_trx_id;
795: l_batch_to_id := l_new_trx_id;
796:
797: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);
798:
799: initial_opm_subl_org_cogs(
800: l_batch_from_id,
801: l_batch_to_id,

Line 834: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

830: null,
831: null);
832: COMMIT;
833:
834: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
835:
836: RETURN x_row_count;
837: EXCEPTION WHEN OTHERS THEN
838: ROLLBACK;

Line 840: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );

836: RETURN x_row_count;
837: EXCEPTION WHEN OTHERS THEN
838: ROLLBACK;
839:
840: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );
841: errbuf := Sqlerrm;
842: retcode := 1;
843: RETURN 0; --x_row_count;
844: END complete_refresh_opm_cogs;