APPS.JTF_RS_DBI_CONC_PUB dependencies on BIS_COLLECTION_UTILITIES

Line 12: MODIFIED BY nsinghai 02/28/2003 -- Added BIS_COLLECTION_UTILITIES

8: Group Hierarchy in DBI product. This program is exclusively built for DBI
9: product and is NOT included in mainline code of ATG Resource Manager.
10:
11: CREATED BY nsinghai 01/16/2003
12: MODIFIED BY nsinghai 02/28/2003 -- Added BIS_COLLECTION_UTILITIES
13: -- call for setup, wrapup, debug
14: -- so that parallel session enabling
15: -- can be done by setup program
16: -- itself. Done after instructions

Line 79: BIS_COLLECTION_UTILITIES.Debug('Error in Update Sales Group Hierarchy:'||errbuf);

75: WHEN OTHERS THEN
76: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
77: retcode := '2'; -- Error
78: errbuf := sqlerrm;
79: BIS_COLLECTION_UTILITIES.Debug('Error in Update Sales Group Hierarchy:'||errbuf);
80: END populate_res_grp;
81:
82: /****************************************************************************
83: This is concurrent program to populate the data that can be accessed via view

Line 109: BIS_COLLECTION_UTILITIES.Debug('Error in Update Field Service District Hierarchy:'||errbuf);

105: WHEN OTHERS THEN
106: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
107: retcode := '2'; -- Error
108: errbuf := sqlerrm;
109: BIS_COLLECTION_UTILITIES.Debug('Error in Update Field Service District Hierarchy:'||errbuf);
110: END populate_fld_srv_district;
111:
112: /****************************************************************************
113: This is main procedure to populate the data in JTF_RS_DBI_MGR_GROUPS

Line 173: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities

169: l_partition := 'USAGE_'||p_usage||'_P1' ;
170:
171: p_retcode := '0' ;
172:
173: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities
174: IF(BIS_COLLECTION_UTILITIES.Setup(
175: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)
176: THEN
177: p_errbuf := FND_MESSAGE.Get;

Line 174: IF(BIS_COLLECTION_UTILITIES.Setup(

170:
171: p_retcode := '0' ;
172:
173: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities
174: IF(BIS_COLLECTION_UTILITIES.Setup(
175: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)
176: THEN
177: p_errbuf := FND_MESSAGE.Get;
178: p_retcode := '-1';

Line 228: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner

224: IF (l_index_owner IS NULL) THEN
225: l_index_owner := l_jtfu;
226: END IF;
227:
228: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner
229: ||': l_table_owner='||l_table_owner||': l_index_tblspace='||l_index_tblspace
230: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism
231: ||': Partition= '||l_partition);
232:

Line 664: BIS_COLLECTION_UTILITIES.wrapup(

660:
661: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
662: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
663:
664: BIS_COLLECTION_UTILITIES.wrapup(
665: p_status => TRUE ,
666: p_count => l_insert_count,
667: p_period_to => l_bis_date);
668:

Line 676: BIS_COLLECTION_UTILITIES.Debug('Error in Update Group Hierarchy for usage:'||

672: WHEN OTHERS THEN
673: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
674: p_retcode := '2'; -- Error
675: p_errbuf := sqlerrm;
676: BIS_COLLECTION_UTILITIES.Debug('Error in Update Group Hierarchy for usage:'||
677: p_usage||' : '||p_errbuf);
678:
679: BIS_COLLECTION_UTILITIES.wrapup(
680: p_status => FALSE ,

Line 679: BIS_COLLECTION_UTILITIES.wrapup(

675: p_errbuf := sqlerrm;
676: BIS_COLLECTION_UTILITIES.Debug('Error in Update Group Hierarchy for usage:'||
677: p_usage||' : '||p_errbuf);
678:
679: BIS_COLLECTION_UTILITIES.wrapup(
680: p_status => FALSE ,
681: p_message => sqlerrm,
682: p_count => l_insert_count,
683: p_period_to => l_bis_date);