DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on BIS_COLLECTION_UTILITIES

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

1569: l_debug_msg := 'Start of Incremental Load for Inventory ';
1570: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1571:
1572: l_stmt_num := 5;
1573: if (bis_collection_utilities.setup(p_object_name => 'OPI_DBI_INV_VALUE_F') = false) then
1574: raise_application_error(-20000,errbuf);
1575: end if;
1576:
1577: l_stmt_num :=10;

Line 1639: BIS_COLLECTION_UTILITIES.WRAPUP(

1635:
1636: l_debug_msg := 'End of Incremental Load for Inventory ';
1637: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1638:
1639: BIS_COLLECTION_UTILITIES.WRAPUP(
1640: p_status => TRUE,
1641: p_count => 0,
1642: p_message => 'Successfully refreshed inventory value base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1643: );

Line 1652: BIS_COLLECTION_UTILITIES.WRAPUP(

1648: retcode := -1;
1649: l_debug_msg := 'Failed with errror ' || SQLcode || ' - ' ||SQLERRM;
1650: OPI_DBI_BOUNDS_PKG.write(g_pkg_name,l_proc_name,l_stmt_num,l_debug_msg);
1651:
1652: BIS_COLLECTION_UTILITIES.WRAPUP(
1653: p_status => FALSE,
1654: p_message => 'Failed in Incremental Load of inventory value base table.'
1655: );
1656: RAISE;