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.BIV_DBI_COLLECTION_AGE dependencies on BIS_COLLECTION_UTILITIES

Line 37: if not bis_collection_utilities.setup( 'BIV_BAC_AGE_SUM_F' ) then

33: l_error_tbl bis_utilities_pub.error_tbl_type;
34:
35: begin
36:
37: if not bis_collection_utilities.setup( 'BIV_BAC_AGE_SUM_F' ) then
38: raise g_bis_setup_exception;
39: end if;
40:
41: biv_dbi_collection_util.get_last_log( l_log_rowid

Line 74: bis_collection_utilities.log('Starting Backlog Aging Load, aging As At ' ||

70: end if;
71: raise l_exception;
72: end if;
73:
74: bis_collection_utilities.log('Starting Backlog Aging Load, aging As At ' ||
75: fnd_date.date_to_displaydt(l_collect_to_date));
76:
77: if biv_dbi_collection_util.get_schema_name
78: ( l_biv_schema

Line 83: bis_collection_utilities.log('truncating dates table',1);

79: , l_error_message ) <> 0 then
80: raise l_exception;
81: end if;
82:
83: bis_collection_utilities.log('truncating dates table',1);
84:
85: if biv_dbi_collection_util.truncate_table
86: ( l_biv_schema
87: , 'BIV_DBI_BACKLOG_AGE_DATES'

Line 92: bis_collection_utilities.log('loading dates table',1);

88: , l_error_message ) <> 0 then
89: raise l_exception;
90: end if;
91:
92: bis_collection_utilities.log('loading dates table',1);
93:
94: insert
95: into biv_dbi_backlog_age_dates
96: ( report_date

Line 291: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);

287: );
288:
289: l_rowcount := sql%rowcount;
290:
291: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);
292:
293: bis_collection_utilities.log('gathering stats on dates table',1);
294:
295: if biv_dbi_collection_util.gather_statistics

Line 293: bis_collection_utilities.log('gathering stats on dates table',1);

289: l_rowcount := sql%rowcount;
290:
291: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);
292:
293: bis_collection_utilities.log('gathering stats on dates table',1);
294:
295: if biv_dbi_collection_util.gather_statistics
296: ( l_biv_schema
297: , 'BIV_DBI_BACKLOG_AGE_DATES'

Line 302: bis_collection_utilities.log('truncating Backlog Aging table',1);

298: , l_error_message ) <> 0 then
299: raise l_exception;
300: end if;
301:
302: bis_collection_utilities.log('truncating Backlog Aging table',1);
303:
304: if biv_dbi_collection_util.truncate_table
305: ( l_biv_schema
306: , 'BIV_BAC_AGE_SUM_F'

Line 311: bis_collection_utilities.log('inserting Backlog Aging rows',1);

307: , l_error_message ) <> 0 then
308: raise l_exception;
309: end if;
310:
311: bis_collection_utilities.log('inserting Backlog Aging rows',1);
312:
313: insert /*+ APPEND parallel(f) */
314: into biv_bac_age_sum_f f
315: ( report_date

Line 628: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);

624: ;
625:
626: l_rowcount := sql%rowcount;
627:
628: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);
629: commit;
630:
631: --
632: bis_collection_utilities.log('gathering stats on Backlog Aging table',2);

Line 632: bis_collection_utilities.log('gathering stats on Backlog Aging table',2);

628: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);
629: commit;
630:
631: --
632: bis_collection_utilities.log('gathering stats on Backlog Aging table',2);
633: if biv_dbi_collection_util.gather_statistics
634: ( l_biv_schema
635: , 'BIV_BAC_AGE_SUM_F'
636: , l_error_message ) <> 0 then

Line 641: bis_collection_utilities.log('inserting group set rows into Backlog Aging table',2);

637: raise l_exception;
638: end if;
639: --
640:
641: bis_collection_utilities.log('inserting group set rows into Backlog Aging table',2);
642:
643: insert /*+ APPEND parallel(f) */
644: into biv_bac_age_sum_f f
645: ( report_date

Line 781: bis_collection_utilities.log(l_rowcount || ' rows inserted for grouping sets',2);

777: );
778: --
779: l_rowcount := sql%rowcount;
780: --
781: bis_collection_utilities.log(l_rowcount || ' rows inserted for grouping sets',2);
782: commit;
783: --
784:
785: bis_collection_utilities.log('Backlog Age Load Complete');

Line 785: bis_collection_utilities.log('Backlog Age Load Complete');

781: bis_collection_utilities.log(l_rowcount || ' rows inserted for grouping sets',2);
782: commit;
783: --
784:
785: bis_collection_utilities.log('Backlog Age Load Complete');
786:
787: commit;
788:
789: bis_collection_utilities.wrapup( p_status => true

Line 789: bis_collection_utilities.wrapup( p_status => true

785: bis_collection_utilities.log('Backlog Age Load Complete');
786:
787: commit;
788:
789: bis_collection_utilities.wrapup( p_status => true
790: , p_period_from => l_collect_to_date
791: , p_period_to => l_collect_to_date
792: , p_count => l_rowcount
793: );

Line 798: errbuf := 'Error in BIS_COLLECTION_UTILITIES.Setup';

794:
795: exception
796: when g_bis_setup_exception then
797: rollback;
798: errbuf := 'Error in BIS_COLLECTION_UTILITIES.Setup';
799: retcode := '2';
800:
801: when others then
802: rollback;

Line 806: bis_collection_utilities.wrapup( p_status => false

802: rollback;
803: if l_error_message is null then
804: l_error_message := substr(sqlerrm,1,4000);
805: end if;
806: bis_collection_utilities.wrapup( p_status => false
807: , p_message => l_error_message
808: , p_period_from => l_collect_to_date
809: , p_period_to => l_collect_to_date
810: );