APPS.OKI_DBI_SCM_MVIEWS_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 25: bis_collection_utilities.put_line('The degree of parallelism is ' ||

21: IF (l_parallel_degree = 1) THEN
22: l_parallel_degree := 0 ;
23: END IF ;
24:
25: bis_collection_utilities.put_line('The degree of parallelism is ' ||
26: l_parallel_degree ) ;
27:
28: line:='5' ;
29: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_01_j_mv'

Line 31: bis_collection_utilities.put_line('MV: oki_scm_01_j_mv refreshed.') ;

27:
28: line:='5' ;
29: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_01_j_mv'
30: , p_parallel_degree => l_parallel_degree ) ;
31: bis_collection_utilities.put_line('MV: oki_scm_01_j_mv refreshed.') ;
32:
33: line:='10' ;
34: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_ocr_mv'
35: , p_parallel_degree => l_parallel_degree ) ;

Line 36: bis_collection_utilities.put_line('MV: oki_scm_ocr_mv refreshed.') ;

32:
33: line:='10' ;
34: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_ocr_mv'
35: , p_parallel_degree => l_parallel_degree ) ;
36: bis_collection_utilities.put_line('MV: oki_scm_ocr_mv refreshed.') ;
37:
38: line:='15' ;
39: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_o_1_mv'
40: , p_parallel_degree => l_parallel_degree ) ;

Line 41: bis_collection_utilities.put_line('MV: oki_scm_o_1_mv refreshed.') ;

37:
38: line:='15' ;
39: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_o_1_mv'
40: , p_parallel_degree => l_parallel_degree ) ;
41: bis_collection_utilities.put_line('MV: oki_scm_o_1_mv refreshed.') ;
42:
43: line:='20' ;
44: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_o_2_mv'
45: , p_parallel_degree => l_parallel_degree ) ;

Line 46: bis_collection_utilities.put_line('MV: oki_scm_o_2_mv refreshed.') ;

42:
43: line:='20' ;
44: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_o_2_mv'
45: , p_parallel_degree => l_parallel_degree ) ;
46: bis_collection_utilities.put_line('MV: oki_scm_o_2_mv refreshed.') ;
47:
48: line:='25' ;
49: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_ot_mv'
50: , p_parallel_degree => l_parallel_degree ) ;

Line 51: bis_collection_utilities.put_line('MV: oki_scm_ot_mv refreshed.') ;

47:
48: line:='25' ;
49: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_ot_mv'
50: , p_parallel_degree => l_parallel_degree ) ;
51: bis_collection_utilities.put_line('MV: oki_scm_ot_mv refreshed.') ;
52:
53: line:='30' ;
54: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_blg_mv'
55: , p_parallel_degree => l_parallel_degree ) ;

Line 56: bis_collection_utilities.put_line('MV: oki_scm_blg_mv refreshed.') ;

52:
53: line:='30' ;
54: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_blg_mv'
55: , p_parallel_degree => l_parallel_degree ) ;
56: bis_collection_utilities.put_line('MV: oki_scm_blg_mv refreshed.') ;
57:
58: bis_collection_utilities.put_line('MV refresh completed successfully.') ;
59:
60: EXCEPTION

Line 58: bis_collection_utilities.put_line('MV refresh completed successfully.') ;

54: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_blg_mv'
55: , p_parallel_degree => l_parallel_degree ) ;
56: bis_collection_utilities.put_line('MV: oki_scm_blg_mv refreshed.') ;
57:
58: bis_collection_utilities.put_line('MV refresh completed successfully.') ;
59:
60: EXCEPTION
61: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
62: RAISE;

Line 66: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;

62: RAISE;
63: WHEN OTHERS THEN
64: errbuf := sqlerrm ;
65: retcode := sqlcode ;
66: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;
67: fnd_message.set_name( application => 'FND'
68: , name => 'CRM-DEBUG ERROR' ) ;
69: fnd_message.set_token( token => 'ROUTINE'
70: , value => 'OKI_DBI_SCM_MVIEWS_PVT.refresh_scm ' ) ;

Line 71: bis_collection_utilities.put_line(fnd_message.get) ;

67: fnd_message.set_name( application => 'FND'
68: , name => 'CRM-DEBUG ERROR' ) ;
69: fnd_message.set_token( token => 'ROUTINE'
70: , value => 'OKI_DBI_SCM_MVIEWS_PVT.refresh_scm ' ) ;
71: bis_collection_utilities.put_line(fnd_message.get) ;
72: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: END refresh_scm ;
74:
75: END oki_dbi_scm_mviews_pvt ;