DBA Data[Home] [Help]

APPS.OKI_DBI_MV_UTIL_PVT dependencies on FND_MESSAGE

Line 77: fnd_message.set_name( application => 'FND'

73: WHEN MV_LOG_EXISTS THEN
74: NULL ;
75: WHEN OTHERS THEN
76: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
77: fnd_message.set_name( application => 'FND'
78: , name => 'CRM-DEBUG ERROR' ) ;
79: fnd_message.set_token( token => 'ROUTINE'
80: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv_log ' ) ;
81: bis_collection_utilities.put_line(fnd_message.get) ;

Line 79: fnd_message.set_token( token => 'ROUTINE'

75: WHEN OTHERS THEN
76: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
77: fnd_message.set_name( application => 'FND'
78: , name => 'CRM-DEBUG ERROR' ) ;
79: fnd_message.set_token( token => 'ROUTINE'
80: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv_log ' ) ;
81: bis_collection_utilities.put_line(fnd_message.get) ;
82: bis_collection_utilities.put_line( ' p_base_table : ' || p_base_table ) ;
83: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

77: fnd_message.set_name( application => 'FND'
78: , name => 'CRM-DEBUG ERROR' ) ;
79: fnd_message.set_token( token => 'ROUTINE'
80: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv_log ' ) ;
81: bis_collection_utilities.put_line(fnd_message.get) ;
82: bis_collection_utilities.put_line( ' p_base_table : ' || p_base_table ) ;
83: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
84: END create_mv_log ;
85:

Line 178: fnd_message.set_name( application => 'FND'

174: WHEN mv_exists THEN
175: NULL ;
176: WHEN OTHERS THEN
177: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
178: fnd_message.set_name( application => 'FND'
179: , name => 'CRM-DEBUG ERROR' ) ;
180: fnd_message.set_token( token => 'ROUTINE'
181: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv ' ) ;
182: bis_collection_utilities.put_line(fnd_message.get) ;

Line 180: fnd_message.set_token( token => 'ROUTINE'

176: WHEN OTHERS THEN
177: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
178: fnd_message.set_name( application => 'FND'
179: , name => 'CRM-DEBUG ERROR' ) ;
180: fnd_message.set_token( token => 'ROUTINE'
181: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv ' ) ;
182: bis_collection_utilities.put_line(fnd_message.get) ;
183: bis_collection_utilities.put_line( ' p_mv_name : ' || p_mv_name ) ;
184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

178: fnd_message.set_name( application => 'FND'
179: , name => 'CRM-DEBUG ERROR' ) ;
180: fnd_message.set_token( token => 'ROUTINE'
181: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv ' ) ;
182: bis_collection_utilities.put_line(fnd_message.get) ;
183: bis_collection_utilities.put_line( ' p_mv_name : ' || p_mv_name ) ;
184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
185: END create_mv ;
186:

Line 238: fnd_message.set_name( application => 'FND'

234: WHEN mv_index_exists THEN
235: NULL ;
236: WHEN OTHERS THEN
237: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
238: fnd_message.set_name( application => 'FND'
239: , name => 'CRM-DEBUG ERROR' ) ;
240: fnd_message.set_token( token => 'ROUTINE'
241: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv_Index ' ) ;
242: bis_collection_utilities.put_line(fnd_message.get) ;

Line 240: fnd_message.set_token( token => 'ROUTINE'

236: WHEN OTHERS THEN
237: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
238: fnd_message.set_name( application => 'FND'
239: , name => 'CRM-DEBUG ERROR' ) ;
240: fnd_message.set_token( token => 'ROUTINE'
241: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv_Index ' ) ;
242: bis_collection_utilities.put_line(fnd_message.get) ;
243: bis_collection_utilities.put_line( ' p_mv_name : ' || p_mv_name ) ;
244: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

238: fnd_message.set_name( application => 'FND'
239: , name => 'CRM-DEBUG ERROR' ) ;
240: fnd_message.set_token( token => 'ROUTINE'
241: , value => 'OKI_DBI_MV_UTIL_PVT.create_mv_Index ' ) ;
242: bis_collection_utilities.put_line(fnd_message.get) ;
243: bis_collection_utilities.put_line( ' p_mv_name : ' || p_mv_name ) ;
244: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
245: END create_mv_index;
246:

Line 272: fnd_message.set_name( application => 'FND'

268: , parallelism => p_parallel_degree ) ;
269: EXCEPTION
270: WHEN OTHERS THEN
271: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
272: fnd_message.set_name( application => 'FND'
273: , name => 'CRM-DEBUG ERROR' ) ;
274: fnd_message.set_token( token => 'ROUTINE'
275: , value => 'OKI_DBI_MV_UTIL_PVT.refresh ' ) ;
276: bis_collection_utilities.put_line(fnd_message.get) ;

Line 274: fnd_message.set_token( token => 'ROUTINE'

270: WHEN OTHERS THEN
271: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
272: fnd_message.set_name( application => 'FND'
273: , name => 'CRM-DEBUG ERROR' ) ;
274: fnd_message.set_token( token => 'ROUTINE'
275: , value => 'OKI_DBI_MV_UTIL_PVT.refresh ' ) ;
276: bis_collection_utilities.put_line(fnd_message.get) ;
277: bis_collection_utilities.put_line( ' p_mv_name : ' || p_mv_name ) ;
278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

272: fnd_message.set_name( application => 'FND'
273: , name => 'CRM-DEBUG ERROR' ) ;
274: fnd_message.set_token( token => 'ROUTINE'
275: , value => 'OKI_DBI_MV_UTIL_PVT.refresh ' ) ;
276: bis_collection_utilities.put_line(fnd_message.get) ;
277: bis_collection_utilities.put_line( ' p_mv_name : ' || p_mv_name ) ;
278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: END refresh ;
280:

Line 308: fnd_message.set_name( application => 'FND'

304: -- ignore the error if an attempt is made to insert an existing record
305: NULL ;
306: WHEN OTHERS THEN
307: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
308: fnd_message.set_name( application => 'FND'
309: , name => 'CRM-DEBUG ERROR' ) ;
310: fnd_message.set_token( token => 'ROUTINE'
311: , value => 'OKI_DBI_MV_UTIL_PVT.crt_mx ' ) ;
312: bis_collection_utilities.put_line(fnd_message.get) ;

Line 310: fnd_message.set_token( token => 'ROUTINE'

306: WHEN OTHERS THEN
307: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
308: fnd_message.set_name( application => 'FND'
309: , name => 'CRM-DEBUG ERROR' ) ;
310: fnd_message.set_token( token => 'ROUTINE'
311: , value => 'OKI_DBI_MV_UTIL_PVT.crt_mx ' ) ;
312: bis_collection_utilities.put_line(fnd_message.get) ;
313: bis_collection_utilities.put_line( ' p_id : ' || p_id ) ;
314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

308: fnd_message.set_name( application => 'FND'
309: , name => 'CRM-DEBUG ERROR' ) ;
310: fnd_message.set_token( token => 'ROUTINE'
311: , value => 'OKI_DBI_MV_UTIL_PVT.crt_mx ' ) ;
312: bis_collection_utilities.put_line(fnd_message.get) ;
313: bis_collection_utilities.put_line( ' p_id : ' || p_id ) ;
314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
315: END crt_mx ;
316: