140:
141: fnd_message.set_token( token => 'TABLE_NAME'
142: , value => 'OKI_YOY_RENEWAL_AMT' );
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 );
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_yoy_rnwl ;
150:
151: --------------------------------------------------------------------------------
191:
192: fnd_message.set_token( token => 'OBJECT_NAME'
193: , value => 'OKI_LOAD_YRA_PVT.UPD_YOY_RNWL' );
194:
195: fnd_file.put_line( which => fnd_file.log
196: , buff => fnd_message.get );
197:
198: fnd_file.put_line( which => fnd_file.log
199: , buff => l_sqlcode||' '||l_sqlerrm );
194:
195: fnd_file.put_line( which => fnd_file.log
196: , buff => fnd_message.get );
197:
198: fnd_file.put_line( which => fnd_file.log
199: , buff => l_sqlcode||' '||l_sqlerrm );
200: END upd_yoy_rnwl ;
201:
202: --------------------------------------------------------------------------------
366:
367: fnd_message.set_token( token => 'OBJECT_NAME'
368: , value => 'OKI_LOAD_YRA_PVT.CALC_YRA_DTL1');
369:
370: fnd_file.put_line( which => fnd_file.log
371: , buff => fnd_message.get);
372:
373: -- Log the location within the procedure where the error occurred
374: fnd_message.set_name( application => 'OKI'
376:
377: fnd_message.set_token( token => 'LOCATION'
378: , value => l_loc);
379:
380: fnd_file.put_line( which => fnd_file.log
381: , buff => fnd_message.get);
382:
383: fnd_file.put_line( which => fnd_file.log
384: , buff => l_sqlcode||' '||l_sqlerrm );
379:
380: fnd_file.put_line( which => fnd_file.log
381: , buff => fnd_message.get);
382:
383: fnd_file.put_line( which => fnd_file.log
384: , buff => l_sqlcode||' '||l_sqlerrm );
385: END calc_yra_dtl1 ;
386:
387:
548:
549: fnd_message.set_token( token => 'OBJECT_NAME'
550: , value => 'OKI_LOAD_YRA_PVT.CALC_YRA_DTL2');
551:
552: fnd_file.put_line( which => fnd_file.log
553: , buff => fnd_message.get);
554:
555: -- Log the location within the procedure where the error occurred
556: fnd_message.set_name( application => 'OKI'
558:
559: fnd_message.set_token( token => 'LOCATION'
560: , value => l_loc);
561:
562: fnd_file.put_line( which => fnd_file.log
563: , buff => fnd_message.get);
564:
565: fnd_file.put_line( which => fnd_file.log
566: , buff => l_sqlcode||' '||l_sqlerrm );
561:
562: fnd_file.put_line( which => fnd_file.log
563: , buff => fnd_message.get);
564:
565: fnd_file.put_line( which => fnd_file.log
566: , buff => l_sqlcode||' '||l_sqlerrm );
567: END calc_yra_dtl2 ;
568:
569: --------------------------------------------------------------------------------
718:
719: fnd_message.set_token( token => 'OBJECT_NAME'
720: , value => 'OKI_LOAD_YRA_PVT.CALC_YRA_SUM');
721:
722: fnd_file.put_line( which => fnd_file.log
723: , buff => fnd_message.get);
724:
725: -- Log the location within the procedure where the error occurred
726: fnd_message.set_name( application => 'OKI'
728:
729: fnd_message.set_token( token => 'LOCATION'
730: , value => l_loc);
731:
732: fnd_file.put_line( which => fnd_file.log
733: , buff => fnd_message.get);
734:
735: fnd_file.put_line( which => fnd_file.log
736: , buff => l_sqlcode||' '||l_sqlerrm );
731:
732: fnd_file.put_line( which => fnd_file.log
733: , buff => fnd_message.get);
734:
735: fnd_file.put_line( which => fnd_file.log
736: , buff => l_sqlcode||' '||l_sqlerrm );
737: END calc_yra_sum ;
738: --------------------------------------------------------------------------------
739: -- Procedure to create all the yoy renewal records. If an
830:
831: fnd_message.set_token( token => 'TABLE_NAME'
832: , value => l_table_name );
833:
834: fnd_file.put_line( which => fnd_file.log
835: , buff => fnd_message.get);
836:
837: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
838:
875:
876: fnd_message.set_token( token => 'OBJECT_NAME'
877: , value => 'OKI_LOAD_YRA_PVT.CRT_YOY_RNWL');
878:
879: fnd_file.put_line( which => fnd_file.log
880: , buff => fnd_message.get);
881:
882: fnd_file.put_line( which => fnd_file.log
883: , buff => l_sqlcode||' '||l_sqlerrm );
878:
879: fnd_file.put_line( which => fnd_file.log
880: , buff => fnd_message.get);
881:
882: fnd_file.put_line( which => fnd_file.log
883: , buff => l_sqlcode||' '||l_sqlerrm );
884:
885: END crt_yoy_rnwl ;
886: