DBA Data[Home] [Help]

APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on BIS_COLLECTION_UTILITIES

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

61: l_stage := 'Stage = START : ' ;
62:
63: retcode := '0' ;
64:
65: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities
66: IF(BIS_COLLECTION_UTILITIES.Setup(
67: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)
68: THEN
69: errbuf := FND_MESSAGE.Get;

Line 66: IF(BIS_COLLECTION_UTILITIES.Setup(

62:
63: retcode := '0' ;
64:
65: -- Call BIS_COLLECTION_UTILITIES to enable parallel session and other logging utilities
66: IF(BIS_COLLECTION_UTILITIES.Setup(
67: p_object_name => 'JTF_RS_DBI_RES_GRP_VL') = false)
68: THEN
69: errbuf := FND_MESSAGE.Get;
70: retcode := '-1';

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

109: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
110: AND table_owner= l_jtfu;
111: END;
112:
113: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner
114: ||': l_table_owner='||l_table_owner||': l_index_tblspace='||l_index_tblspace
115: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism);
116:
117: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS';

Line 557: BIS_COLLECTION_UTILITIES.wrapup(

553: FROM jtf_rs_dbi_denorm_res_groups;
554:
555: l_stage := 'Stage = WRAPUP : ' ;
556:
557: BIS_COLLECTION_UTILITIES.wrapup(
558: p_status => TRUE ,
559: p_count => l_insert_count,
560: p_period_to => l_bis_date);
561:

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

565: WHEN OTHERS THEN
566: fnd_file.put_line(fnd_file.log, l_stage||sqlcode||':'||sqlerrm);
567: retcode := '2'; -- Error
568: errbuf := l_stage||sqlerrm;
569: BIS_COLLECTION_UTILITIES.Debug('Error in Update Sales Group Hierarchy: '||l_stage||errbuf);
570:
571: BIS_COLLECTION_UTILITIES.wrapup(
572: p_status => FALSE ,
573: p_message => l_stage||sqlerrm,

Line 571: BIS_COLLECTION_UTILITIES.wrapup(

567: retcode := '2'; -- Error
568: errbuf := l_stage||sqlerrm;
569: BIS_COLLECTION_UTILITIES.Debug('Error in Update Sales Group Hierarchy: '||l_stage||errbuf);
570:
571: BIS_COLLECTION_UTILITIES.wrapup(
572: p_status => FALSE ,
573: p_message => l_stage||sqlerrm,
574: p_count => l_insert_count,
575: p_period_to => l_bis_date);