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 81: BIS_COLLECTION_UTILITIES.Debug('Error in Update Sales Group Hierarchy:'||errbuf);

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

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

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

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

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

Line 177: IF(BIS_COLLECTION_UTILITIES.Setup(

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

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

231: IF (l_table_owner IS NULL) THEN
232: l_table_owner := l_jtfu;
233: END IF;
234:
235: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner
236: ||': l_table_owner='||l_table_owner||': l_index_tblspace='||l_index_tblspace
237: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism
238: ||': Partition= '||l_partition);
239:

Line 671: BIS_COLLECTION_UTILITIES.wrapup(

667:
668: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
669: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
670:
671: BIS_COLLECTION_UTILITIES.wrapup(
672: p_status => TRUE ,
673: p_count => l_insert_count,
674: p_period_to => l_bis_date);
675:

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

679: WHEN OTHERS THEN
680: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
681: p_retcode := '2'; -- Error
682: p_errbuf := sqlerrm;
683: BIS_COLLECTION_UTILITIES.Debug('Error in Update Group Hierarchy for usage:'||
684: p_usage||' : '||p_errbuf);
685:
686: BIS_COLLECTION_UTILITIES.wrapup(
687: p_status => FALSE ,

Line 686: BIS_COLLECTION_UTILITIES.wrapup(

682: p_errbuf := sqlerrm;
683: BIS_COLLECTION_UTILITIES.Debug('Error in Update Group Hierarchy for usage:'||
684: p_usage||' : '||p_errbuf);
685:
686: BIS_COLLECTION_UTILITIES.wrapup(
687: p_status => FALSE ,
688: p_message => sqlerrm,
689: p_count => l_insert_count,
690: p_period_to => l_bis_date);