APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 2861: bis_collection_utilities.put_line(l_debug_msg );

2857: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2858:
2859: l_stmt_num := 10;
2860: l_debug_msg := 'Starting Initial Load for Inventory Management page';
2861: bis_collection_utilities.put_line(l_debug_msg );
2862:
2863: -- action: why do we need this. confirm with performance team as why this is required
2864: execute immediate 'alter session set hash_area_size=104857600' ;
2865: execute immediate 'alter session set sort_area_size=104857600' ;

Line 2887: if (bis_collection_utilities.setup ( p_object_name => 'OPI_DBI_INV_VALUE_F') = false) then

2883: OPI_DBI_INV_VALUE_INIT_PKG.seed_inv_type_codes; -- No changes for R12
2884: commit;
2885:
2886: l_stmt_num := 35;
2887: if (bis_collection_utilities.setup ( p_object_name => 'OPI_DBI_INV_VALUE_F') = false) then
2888: raise_application_error(-20000,errbuf);
2889: end if;
2890:
2891: l_stmt_num :=40;

Line 3027: BIS_COLLECTION_UTILITIES.wrapup( -- updates the log

3023: -- This will update log table for successful completion of
3024: -- Inventory Initial Load
3025: OPI_DBI_BOUNDS_PKG.set_load_successful('INVENTORY', 'INIT');
3026:
3027: BIS_COLLECTION_UTILITIES.wrapup( -- updates the log
3028: p_status => TRUE,
3029: p_count => 0, -- for 5.0 only. will put meaningful number in 6.0
3030: p_message => 'Successfully loaded inventory value base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
3031: );

Line 3045: BIS_COLLECTION_UTILITIES.WRAPUP(

3041: retcode := -1;
3042: l_debug_msg := 'Failed with errror ' || SQLcode || ' - ' ||SQLERRM;
3043: OPI_DBI_BOUNDS_PKG.write(g_pkg_name,l_proc_name,l_stmt_num,l_debug_msg);
3044:
3045: BIS_COLLECTION_UTILITIES.WRAPUP(
3046: p_status => FALSE,
3047: p_message => 'Failed in Initial Load of inventory value base table.'
3048: );
3049: RAISE;