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_INIT dependencies on BIV_DBI_COLLECTION_UTIL

Line 108: if biv_dbi_collection_util.correct_bad_audit(l_error_message) <> 0 then

104: /* this is a temporary workaround to bad audit data cause by:
105: - bug 3050727 - fixed
106: */
107:
108: if biv_dbi_collection_util.correct_bad_audit(l_error_message) <> 0 then
109: raise l_exception;
110: end if;
111:
112: biv_dbi_collection_util.get_last_log( l_log_rowid

Line 112: biv_dbi_collection_util.get_last_log( l_log_rowid

108: if biv_dbi_collection_util.correct_bad_audit(l_error_message) <> 0 then
109: raise l_exception;
110: end if;
111:
112: biv_dbi_collection_util.get_last_log( l_log_rowid
113: , l_process_type
114: , l_collect_from_date
115: , l_collect_to_date
116: , l_success_flag

Line 177: if biv_dbi_collection_util.get_schema_name

173: -- load
174: -- l_collect_to_date := to_date('31-12-2002 23:59:59','dd-mm-yyyy hh24:mi:ss');
175: -- @@@@@@@@ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
176:
177: if biv_dbi_collection_util.get_schema_name
178: (l_biv_schema, l_error_message) <> 0 then
179: raise l_exception;
180: end if;
181:

Line 193: if biv_dbi_collection_util.truncate_table

189: bis_collection_utilities.log('Starting Escalations Staging table population ');
190:
191: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ESCALATIONS_STG');
192:
193: if biv_dbi_collection_util.truncate_table
194: (l_biv_schema, 'BIV_DBI_ESCALATIONS_STG', l_error_message) <> 0 then
195: raise l_exception;
196: end if;
197:

Line 349: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;

345:
346: l_timer number;
347: l_rowcount number;
348:
349: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
350: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
351: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
352:
353: begin

Line 350: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;

346: l_timer number;
347: l_rowcount number;
348:
349: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
350: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
351: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
352:
353: begin
354:

Line 351: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;

347: l_rowcount number;
348:
349: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
350: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
351: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
352:
353: begin
354:
355: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_ACTIVITY' ) then

Line 359: biv_dbi_collection_util.get_last_log( l_log_rowid

355: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_ACTIVITY' ) then
356: raise g_bis_setup_exception;
357: end if;
358:
359: biv_dbi_collection_util.get_last_log( l_log_rowid
360: , l_process_type
361: , l_collect_from_date
362: , l_collect_to_date
363: , l_success_flag

Line 385: if biv_dbi_collection_util.get_schema_name

381: if l_activity_flag = 'N' then
382:
383: l_timer := dbms_utility.get_time;
384:
385: if biv_dbi_collection_util.get_schema_name
386: (l_biv_schema, l_error_message) <> 0 then
387: raise l_exception;
388: end if;
389:

Line 396: if biv_dbi_collection_util.truncate_table

392: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
393:
394: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ACTIVITY_SUM_F');
395:
396: if biv_dbi_collection_util.truncate_table
397: (l_biv_schema, 'BIV_DBI_ACTIVITY_SUM_F', l_error_message) <> 0 then
398: raise l_exception;
399: end if;
400:

Line 527: biv_dbi_collection_util.set_log_error

523: when g_bis_setup_exception then
524: rollback;
525: errbuf := 'Error in BIS_COLLECTION_UTILITIES.Setup';
526: retcode := '2';
527: biv_dbi_collection_util.set_log_error
528: ( p_rowid => l_log_rowid
529: , p_activity_error => errbuf
530: );
531: commit;

Line 538: biv_dbi_collection_util.set_log_error

534: rollback;
535: if l_error_message is null then
536: l_error_message := substr(sqlerrm,1,4000);
537: end if;
538: biv_dbi_collection_util.set_log_error
539: ( p_rowid => l_log_rowid
540: , p_activity_error => l_error_message
541: );
542: commit;

Line 578: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;

574:
575: l_timer number;
576: l_rowcount number;
577:
578: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
579: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
580: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
581:
582: begin

Line 579: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;

575: l_timer number;
576: l_rowcount number;
577:
578: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
579: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
580: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
581:
582: begin
583:

Line 580: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;

576: l_rowcount number;
577:
578: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
579: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
580: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
581:
582: begin
583:
584: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_CLOSED' ) then

Line 588: biv_dbi_collection_util.get_last_log( l_log_rowid

584: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_CLOSED' ) then
585: raise g_bis_setup_exception;
586: end if;
587:
588: biv_dbi_collection_util.get_last_log( l_log_rowid
589: , l_process_type
590: , l_collect_from_date
591: , l_collect_to_date
592: , l_success_flag

Line 614: if biv_dbi_collection_util.get_schema_name

610: if l_closed_flag = 'N' then
611:
612: l_timer := dbms_utility.get_time;
613:
614: if biv_dbi_collection_util.get_schema_name
615: (l_biv_schema, l_error_message) <> 0 then
616: raise l_exception;
617: end if;
618:

Line 625: if biv_dbi_collection_util.truncate_table

621: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
622:
623: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_CLOSED_SUM_F');
624:
625: if biv_dbi_collection_util.truncate_table
626: (l_biv_schema, 'BIV_DBI_CLOSED_SUM_F', l_error_message) <> 0 then
627: raise l_exception;
628: end if;
629:

Line 794: biv_dbi_collection_util.set_log_error

790: when g_bis_setup_exception then
791: rollback;
792: errbuf := 'Error in BIS_COLLECTION_UTILITIES.Setup';
793: retcode := '2';
794: biv_dbi_collection_util.set_log_error
795: ( p_rowid => l_log_rowid
796: , p_closed_error => errbuf
797: );
798: commit;

Line 805: biv_dbi_collection_util.set_log_error

801: rollback;
802: if l_error_message is null then
803: l_error_message := substr(sqlerrm,1,4000);
804: end if;
805: biv_dbi_collection_util.set_log_error
806: ( p_rowid => l_log_rowid
807: , p_closed_error => l_error_message
808: );
809: commit;

Line 845: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;

841:
842: l_timer number;
843: l_rowcount number;
844:
845: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
846: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
847: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
848:
849: l_max_date date := to_date('4712/12/31','yyyy/mm/dd');

Line 846: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;

842: l_timer number;
843: l_rowcount number;
844:
845: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
846: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
847: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
848:
849: l_max_date date := to_date('4712/12/31','yyyy/mm/dd');
850:

Line 847: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;

843: l_rowcount number;
844:
845: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
846: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
847: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
848:
849: l_max_date date := to_date('4712/12/31','yyyy/mm/dd');
850:
851: begin

Line 857: biv_dbi_collection_util.get_last_log( l_log_rowid

853: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_BACKLOG' ) then
854: raise g_bis_setup_exception;
855: end if;
856:
857: biv_dbi_collection_util.get_last_log( l_log_rowid
858: , l_process_type
859: , l_collect_from_date
860: , l_collect_to_date
861: , l_success_flag

Line 883: if biv_dbi_collection_util.get_schema_name

879: if l_backlog_flag = 'N' then
880:
881: l_timer := dbms_utility.get_time;
882:
883: if biv_dbi_collection_util.get_schema_name
884: (l_biv_schema, l_error_message) <> 0 then
885: raise l_exception;
886: end if;
887:

Line 894: if biv_dbi_collection_util.truncate_table

890: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
891:
892: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_BACKLOG_SUM_F');
893:
894: if biv_dbi_collection_util.truncate_table
895: (l_biv_schema, 'BIV_DBI_BACKLOG_SUM_F', l_error_message) <> 0 then
896: raise l_exception;
897: end if;
898:

Line 1309: biv_dbi_collection_util.set_log_error

1305: when g_bis_setup_exception then
1306: rollback;
1307: errbuf := 'Error in BIS_COLLECTION_UTILITIES.Setup';
1308: retcode := '2';
1309: biv_dbi_collection_util.set_log_error
1310: ( p_rowid => l_log_rowid
1311: , p_backlog_error => errbuf
1312: );
1313: commit;

Line 1320: biv_dbi_collection_util.set_log_error

1316: rollback;
1317: if l_error_message is null then
1318: l_error_message := substr(sqlerrm,1,4000);
1319: end if;
1320: biv_dbi_collection_util.set_log_error
1321: ( p_rowid => l_log_rowid
1322: , p_backlog_error => l_error_message
1323: );
1324: commit;

Line 1360: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;

1356:
1357: l_timer number;
1358: l_rowcount number;
1359:
1360: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
1361: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
1362: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
1363:
1364: begin

Line 1361: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;

1357: l_timer number;
1358: l_rowcount number;
1359:
1360: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
1361: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
1362: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
1363:
1364: begin
1365:

Line 1362: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;

1358: l_rowcount number;
1359:
1360: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
1361: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
1362: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
1363:
1364: begin
1365:
1366: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_RESOLUTION' ) then

Line 1370: biv_dbi_collection_util.get_last_log( l_log_rowid

1366: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECT_INIT_RESOLUTION' ) then
1367: raise g_bis_setup_exception;
1368: end if;
1369:
1370: biv_dbi_collection_util.get_last_log( l_log_rowid
1371: , l_process_type
1372: , l_collect_from_date
1373: , l_collect_to_date
1374: , l_success_flag

Line 1396: if biv_dbi_collection_util.get_schema_name

1392: if l_resolution_flag = 'N' then
1393:
1394: l_timer := dbms_utility.get_time;
1395:
1396: if biv_dbi_collection_util.get_schema_name
1397: (l_biv_schema, l_error_message) <> 0 then
1398: raise l_exception;
1399: end if;
1400:

Line 1407: if biv_dbi_collection_util.truncate_table

1403: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:
1407: if biv_dbi_collection_util.truncate_table
1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;
1410: end if;
1411:

Line 1638: biv_dbi_collection_util.set_log_error

1634: when g_bis_setup_exception then
1635: rollback;
1636: errbuf := 'Error in BIS_COLLECTION_UTILITIES.Setup';
1637: retcode := '2';
1638: biv_dbi_collection_util.set_log_error
1639: ( p_rowid => l_log_rowid
1640: , p_resolution_error => errbuf
1641: );
1642: commit;

Line 1649: biv_dbi_collection_util.set_log_error

1645: rollback;
1646: if l_error_message is null then
1647: l_error_message := substr(sqlerrm,1,4000);
1648: end if;
1649: biv_dbi_collection_util.set_log_error
1650: ( p_rowid => l_log_rowid
1651: , p_resolution_error => l_error_message
1652: );
1653: commit;