eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_LOAD_YRA_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_YOY_RENEWAL_AMT' );

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_YOY_RENEWAL_AMT' );
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_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 );
149: END ins_yoy_rnwl ;

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

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

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

188:
189: fnd_message.set_name( application => 'OKI'
190: , name => 'OKI_UNEXPECTED_FAILURE' );
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 );

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

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 );
200: END upd_yoy_rnwl ;

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

360:
361: -- Set return code TO error
362: x_retcode := '2' ;
363:
364: fnd_message.set_name( application => 'OKI'
365: , name => 'OKI_UNEXPECTED_FAILURE');
366:
367: fnd_message.set_token( token => 'OBJECT_NAME'
368: , value => 'OKI_LOAD_YRA_PVT.CALC_YRA_DTL1');

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

363:
364: fnd_message.set_name( application => 'OKI'
365: , name => 'OKI_UNEXPECTED_FAILURE');
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);

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

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'
375: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

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'
375: , name => 'OKI_LOC_IN_PROG_FAILURE');
376:
377: fnd_message.set_token( token => 'LOCATION'
378: , value => l_loc);

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

373: -- Log the location within the procedure where the error occurred
374: fnd_message.set_name( application => 'OKI'
375: , name => 'OKI_LOC_IN_PROG_FAILURE');
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);

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

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 );
385: END calc_yra_dtl1 ;

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

542:
543: -- Set return code TO error
544: x_retcode := '2' ;
545:
546: fnd_message.set_name( application => 'OKI'
547: , name => 'OKI_UNEXPECTED_FAILURE');
548:
549: fnd_message.set_token( token => 'OBJECT_NAME'
550: , value => 'OKI_LOAD_YRA_PVT.CALC_YRA_DTL2');

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

545:
546: fnd_message.set_name( application => 'OKI'
547: , name => 'OKI_UNEXPECTED_FAILURE');
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);

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

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'
557: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

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'
557: , name => 'OKI_LOC_IN_PROG_FAILURE');
558:
559: fnd_message.set_token( token => 'LOCATION'
560: , value => l_loc);

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

555: -- Log the location within the procedure where the error occurred
556: fnd_message.set_name( application => 'OKI'
557: , name => 'OKI_LOC_IN_PROG_FAILURE');
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);

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

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 );
567: END calc_yra_dtl2 ;

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

712:
713: -- Set return code TO error
714: x_retcode := '2' ;
715:
716: fnd_message.set_name( application => 'OKI'
717: , name => 'OKI_UNEXPECTED_FAILURE');
718:
719: fnd_message.set_token( token => 'OBJECT_NAME'
720: , value => 'OKI_LOAD_YRA_PVT.CALC_YRA_SUM');

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

715:
716: fnd_message.set_name( application => 'OKI'
717: , name => 'OKI_UNEXPECTED_FAILURE');
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);

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

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'
727: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

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'
727: , name => 'OKI_LOC_IN_PROG_FAILURE');
728:
729: fnd_message.set_token( token => 'LOCATION'
730: , value => l_loc);

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

725: -- Log the location within the procedure where the error occurred
726: fnd_message.set_name( application => 'OKI'
727: , name => 'OKI_LOC_IN_PROG_FAILURE');
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);

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

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 );
737: END calc_yra_sum ;

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

824:
825:
826: -- Table loaded successfully. Log message IN concurrent manager
827: -- log indicating successful load.
828: fnd_message.set_name( application => 'OKI'
829: , name => 'OKI_TABLE_LOAD_SUCCESS');
830:
831: fnd_message.set_token( token => 'TABLE_NAME'
832: , value => l_table_name );

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

827: -- log indicating successful load.
828: fnd_message.set_name( application => 'OKI'
829: , name => 'OKI_TABLE_LOAD_SUCCESS');
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);

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

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:
839: IF l_retcode in ('1', '2') THEN

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

869: -- ROLLBACK all transactions
870: ROLLBACK TO oki_load_yra_pvt_crt_yoy_rnwl ;
871:
872:
873: fnd_message.set_name( application => 'OKI'
874: , name => 'OKI_UNEXPECTED_FAILURE');
875:
876: fnd_message.set_token( token => 'OBJECT_NAME'
877: , value => 'OKI_LOAD_YRA_PVT.CRT_YOY_RNWL');

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

872:
873: fnd_message.set_name( application => 'OKI'
874: , name => 'OKI_UNEXPECTED_FAILURE');
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);

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

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