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');
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);
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 ;
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');
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);
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 ;
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');
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);
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');
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);
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);
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 ;
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');
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);
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');
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);
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);
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 ;
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 );
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);
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
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');
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);
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: