DBA Data[Home] [Help]

APPS.OKI_LOAD_YRA_PVT dependencies on FND_FILE

Line 144: fnd_file.put_line( which => fnd_file.log

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

Line 147: fnd_file.put_line( which => fnd_file.log

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: --------------------------------------------------------------------------------

Line 195: fnd_file.put_line( which => fnd_file.log

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

Line 198: fnd_file.put_line( which => fnd_file.log

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: --------------------------------------------------------------------------------

Line 370: fnd_file.put_line( which => fnd_file.log

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'

Line 380: fnd_file.put_line( which => fnd_file.log

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

Line 383: fnd_file.put_line( which => fnd_file.log

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:

Line 552: fnd_file.put_line( which => fnd_file.log

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'

Line 562: fnd_file.put_line( which => fnd_file.log

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

Line 565: fnd_file.put_line( which => fnd_file.log

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: --------------------------------------------------------------------------------

Line 722: fnd_file.put_line( which => fnd_file.log

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'

Line 732: fnd_file.put_line( which => fnd_file.log

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

Line 735: fnd_file.put_line( which => fnd_file.log

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

Line 834: fnd_file.put_line( which => fnd_file.log

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:

Line 879: fnd_file.put_line( which => fnd_file.log

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

Line 882: fnd_file.put_line( which => fnd_file.log

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: