DBA Data[Home] [Help]

APPS.OKI_LOAD_FBO_PVT dependencies on FND_MESSAGE

Line 138: fnd_message.set_name( application => 'OKI'

134:
135: -- Set return code TO error
136: x_retcode := '2';
137:
138: fnd_message.set_name( application => 'OKI'
139: , name => 'OKI_TABLE_LOAD_FAILURE');
140:
141: fnd_message.set_token( token => 'TABLE_NAME'
142: , value => 'OKI_FORECAST_BY_ORGS');

Line 141: fnd_message.set_token( token => 'TABLE_NAME'

137:
138: fnd_message.set_name( application => 'OKI'
139: , name => 'OKI_TABLE_LOAD_FAILURE');
140:
141: fnd_message.set_token( token => 'TABLE_NAME'
142: , value => 'OKI_FORECAST_BY_ORGS');
143:
144: fnd_file.put_line( which => fnd_file.log
145: , buff => fnd_message.get);

Line 145: , buff => fnd_message.get);

141: fnd_message.set_token( token => 'TABLE_NAME'
142: , value => 'OKI_FORECAST_BY_ORGS');
143:
144: fnd_file.put_line( which => fnd_file.log
145: , buff => fnd_message.get);
146:
147: fnd_file.put_line( which => fnd_file.log
148: , buff => l_sqlcode||' '||l_sqlerrm );
149: END ins_fcst_by_org ;

Line 191: fnd_message.set_name( application => 'OKI'

187:
188: -- Set return code to error
189: x_retcode := '2';
190:
191: fnd_message.set_name( application => 'OKI'
192: , name => 'OKI_UNEXPECTED_FAILURE');
193:
194: fnd_message.set_token( token => 'OBJECT_NAME'
195: , value => 'OKI_UPD_FCST_BY_ORG');

Line 194: fnd_message.set_token( token => 'OBJECT_NAME'

190:
191: fnd_message.set_name( application => 'OKI'
192: , name => 'OKI_UNEXPECTED_FAILURE');
193:
194: fnd_message.set_token( token => 'OBJECT_NAME'
195: , value => 'OKI_UPD_FCST_BY_ORG');
196:
197: fnd_file.put_line( which => fnd_file.log
198: , buff => fnd_message.get);

Line 198: , buff => fnd_message.get);

194: fnd_message.set_token( token => 'OBJECT_NAME'
195: , value => 'OKI_UPD_FCST_BY_ORG');
196:
197: fnd_file.put_line( which => fnd_file.log
198: , buff => fnd_message.get);
199:
200: fnd_file.put_line( which => fnd_file.log
201: , buff => l_sqlcode||' '||l_sqlerrm );
202: END upd_fcst_by_org ;

Line 405: fnd_message.set_name( application => 'OKI'

401:
402: -- Set return code TO error
403: x_retcode := '2' ;
404:
405: fnd_message.set_name( application => 'OKI'
406: , name => 'OKI_UNEXPECTED_FAILURE');
407:
408: fnd_message.set_token( token => 'OBJECT_NAME'
409: , value => 'OKI_LOAD_FBO_PVT.CALC_FBO_DTL1');

Line 408: fnd_message.set_token( token => 'OBJECT_NAME'

404:
405: fnd_message.set_name( application => 'OKI'
406: , name => 'OKI_UNEXPECTED_FAILURE');
407:
408: fnd_message.set_token( token => 'OBJECT_NAME'
409: , value => 'OKI_LOAD_FBO_PVT.CALC_FBO_DTL1');
410:
411: fnd_file.put_line( which => fnd_file.log
412: , buff => fnd_message.get);

Line 412: , buff => fnd_message.get);

408: fnd_message.set_token( token => 'OBJECT_NAME'
409: , value => 'OKI_LOAD_FBO_PVT.CALC_FBO_DTL1');
410:
411: fnd_file.put_line( which => fnd_file.log
412: , buff => fnd_message.get);
413:
414: -- Log the location within the procedure where the error occurred
415: fnd_message.set_name( application => 'OKI'
416: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 415: fnd_message.set_name( application => 'OKI'

411: fnd_file.put_line( which => fnd_file.log
412: , buff => fnd_message.get);
413:
414: -- Log the location within the procedure where the error occurred
415: fnd_message.set_name( application => 'OKI'
416: , name => 'OKI_LOC_IN_PROG_FAILURE');
417:
418: fnd_message.set_token( token => 'LOCATION'
419: , value => l_loc);

Line 418: fnd_message.set_token( token => 'LOCATION'

414: -- Log the location within the procedure where the error occurred
415: fnd_message.set_name( application => 'OKI'
416: , name => 'OKI_LOC_IN_PROG_FAILURE');
417:
418: fnd_message.set_token( token => 'LOCATION'
419: , value => l_loc);
420:
421: fnd_file.put_line( which => fnd_file.log
422: , buff => fnd_message.get);

Line 422: , buff => fnd_message.get);

418: fnd_message.set_token( token => 'LOCATION'
419: , value => l_loc);
420:
421: fnd_file.put_line( which => fnd_file.log
422: , buff => fnd_message.get);
423:
424: fnd_file.put_line( which => fnd_file.log
425: , buff => l_sqlcode||' '||l_sqlerrm );
426: END calc_fbo_dtl1 ;

Line 625: fnd_message.set_name( application => 'OKI'

621:
622: -- Set return code TO error
623: x_retcode := '2' ;
624:
625: fnd_message.set_name( application => 'OKI'
626: , name => 'OKI_UNEXPECTED_FAILURE');
627:
628: fnd_message.set_token( token => 'OBJECT_NAME'
629: , value => 'OKI_LOAD_FBO_PVT.CALC_FBO_SUM');

Line 628: fnd_message.set_token( token => 'OBJECT_NAME'

624:
625: fnd_message.set_name( application => 'OKI'
626: , name => 'OKI_UNEXPECTED_FAILURE');
627:
628: fnd_message.set_token( token => 'OBJECT_NAME'
629: , value => 'OKI_LOAD_FBO_PVT.CALC_FBO_SUM');
630:
631: fnd_file.put_line( which => fnd_file.log
632: , buff => fnd_message.get);

Line 632: , buff => fnd_message.get);

628: fnd_message.set_token( token => 'OBJECT_NAME'
629: , value => 'OKI_LOAD_FBO_PVT.CALC_FBO_SUM');
630:
631: fnd_file.put_line( which => fnd_file.log
632: , buff => fnd_message.get);
633:
634: -- Log the location within the procedure where the error occurred
635: fnd_message.set_name( application => 'OKI'
636: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 635: fnd_message.set_name( application => 'OKI'

631: fnd_file.put_line( which => fnd_file.log
632: , buff => fnd_message.get);
633:
634: -- Log the location within the procedure where the error occurred
635: fnd_message.set_name( application => 'OKI'
636: , name => 'OKI_LOC_IN_PROG_FAILURE');
637:
638: fnd_message.set_token( token => 'LOCATION'
639: , value => l_loc);

Line 638: fnd_message.set_token( token => 'LOCATION'

634: -- Log the location within the procedure where the error occurred
635: fnd_message.set_name( application => 'OKI'
636: , name => 'OKI_LOC_IN_PROG_FAILURE');
637:
638: fnd_message.set_token( token => 'LOCATION'
639: , value => l_loc);
640:
641: fnd_file.put_line( which => fnd_file.log
642: , buff => fnd_message.get);

Line 642: , buff => fnd_message.get);

638: fnd_message.set_token( token => 'LOCATION'
639: , value => l_loc);
640:
641: fnd_file.put_line( which => fnd_file.log
642: , buff => fnd_message.get);
643:
644: fnd_file.put_line( which => fnd_file.log
645: , buff => l_sqlcode||' '||l_sqlerrm );
646: END calc_fbo_sum ;

Line 726: fnd_message.set_name( application => 'OKI'

722:
723:
724: -- Table loaded successfully. Log message IN concurrent manager
725: -- log indicating successful load.
726: fnd_message.set_name( application => 'OKI'
727: , name => 'OKI_TABLE_LOAD_SUCCESS');
728:
729: fnd_message.set_token( token => 'TABLE_NAME'
730: , value => l_table_name );

Line 729: fnd_message.set_token( token => 'TABLE_NAME'

725: -- log indicating successful load.
726: fnd_message.set_name( application => 'OKI'
727: , name => 'OKI_TABLE_LOAD_SUCCESS');
728:
729: fnd_message.set_token( token => 'TABLE_NAME'
730: , value => l_table_name );
731:
732: fnd_file.put_line( which => fnd_file.log
733: , buff => fnd_message.get);

Line 733: , buff => fnd_message.get);

729: fnd_message.set_token( token => 'TABLE_NAME'
730: , value => l_table_name );
731:
732: fnd_file.put_line( which => fnd_file.log
733: , buff => fnd_message.get);
734:
735: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
736:
737: IF l_retcode in ('1', '2') THEN

Line 771: fnd_message.set_name( application => 'OKI'

767: -- ROLLBACK all transactions
768: ROLLBACK TO oki_load_fbo_pvt_crt_fcst_org ;
769:
770:
771: fnd_message.set_name( application => 'OKI'
772: , name => 'OKI_UNEXPECTED_FAILURE');
773:
774: fnd_message.set_token( token => 'OBJECT_NAME'
775: , value => 'OKI_LOAD_FBO_PVT.CRT_FCST_ORG');

Line 774: fnd_message.set_token( token => 'OBJECT_NAME'

770:
771: fnd_message.set_name( application => 'OKI'
772: , name => 'OKI_UNEXPECTED_FAILURE');
773:
774: fnd_message.set_token( token => 'OBJECT_NAME'
775: , value => 'OKI_LOAD_FBO_PVT.CRT_FCST_ORG');
776:
777: fnd_file.put_line( which => fnd_file.log
778: , buff => fnd_message.get);

Line 778: , buff => fnd_message.get);

774: fnd_message.set_token( token => 'OBJECT_NAME'
775: , value => 'OKI_LOAD_FBO_PVT.CRT_FCST_ORG');
776:
777: fnd_file.put_line( which => fnd_file.log
778: , buff => fnd_message.get);
779:
780: fnd_file.put_line( which => fnd_file.log
781: , buff => l_sqlcode||' '||l_sqlerrm );
782: