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_REFRESH_PVT dependencies on FND_MESSAGE

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

435:
436: -- Set return code to warning
437: x_retcode := '2';
438:
439: fnd_message.set_name( application => 'OKI'
440: , name => 'OKI_UPD_RFR_TABLE_FAILURE');
441: fnd_file.put_line( which => fnd_file.log
442: , buff => fnd_message.get);
443: fnd_file.put_line( which => fnd_file.log

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

438:
439: fnd_message.set_name( application => 'OKI'
440: , name => 'OKI_UPD_RFR_TABLE_FAILURE');
441: fnd_file.put_line( which => fnd_file.log
442: , buff => fnd_message.get);
443: fnd_file.put_line( which => fnd_file.log
444: , buff => l_sqlcode||' '||l_sqlerrm );
445: END update_oki_refresh;
446:

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

485: -- Set return code to warning
486: x_retcode := '1';
487:
488: -- Log the location within the package where the error occurred
489: fnd_message.set_name( application => 'OKI'
490: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
491: fnd_message.set_token( token => 'LOCATION'
492: , value => 'oki_refresh_pvt.update_refresh_job_run ' ) ;
493: fnd_file.put_line( which => fnd_file.log

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

487:
488: -- Log the location within the package where the error occurred
489: fnd_message.set_name( application => 'OKI'
490: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
491: fnd_message.set_token( token => 'LOCATION'
492: , value => 'oki_refresh_pvt.update_refresh_job_run ' ) ;
493: fnd_file.put_line( which => fnd_file.log
494: , buff => fnd_message.get ) ;
495:

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

490: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
491: fnd_message.set_token( token => 'LOCATION'
492: , value => 'oki_refresh_pvt.update_refresh_job_run ' ) ;
493: fnd_file.put_line( which => fnd_file.log
494: , buff => fnd_message.get ) ;
495:
496: fnd_message.set_name( application => 'OKI'
497: , name => 'OKI_UPD_RFR_TABLE_FAILURE');
498: fnd_file.put_line( which => fnd_file.log

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

492: , value => 'oki_refresh_pvt.update_refresh_job_run ' ) ;
493: fnd_file.put_line( which => fnd_file.log
494: , buff => fnd_message.get ) ;
495:
496: fnd_message.set_name( application => 'OKI'
497: , name => 'OKI_UPD_RFR_TABLE_FAILURE');
498: fnd_file.put_line( which => fnd_file.log
499: , buff => fnd_message.get);
500: fnd_file.put_line( which => fnd_file.log

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

495:
496: fnd_message.set_name( application => 'OKI'
497: , name => 'OKI_UPD_RFR_TABLE_FAILURE');
498: fnd_file.put_line( which => fnd_file.log
499: , buff => fnd_message.get);
500: fnd_file.put_line( which => fnd_file.log
501: , buff => l_sqlcode||' '||l_sqlerrm );
502: END update_refresh_job_run ;
503:

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

586: -- Set return code to error
587: x_retcode := 2 ;
588:
589: -- Log the location within the package where the error occurred
590: fnd_message.set_name( application => 'OKI'
591: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
592: fnd_message.set_token( token => 'LOCATION'
593: , value => 'oki_refresh_pvt.ins_job_runs' ) ;
594: fnd_file.put_line( which => fnd_file.log

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

588:
589: -- Log the location within the package where the error occurred
590: fnd_message.set_name( application => 'OKI'
591: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
592: fnd_message.set_token( token => 'LOCATION'
593: , value => 'oki_refresh_pvt.ins_job_runs' ) ;
594: fnd_file.put_line( which => fnd_file.log
595: , buff => fnd_message.get ) ;
596:

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

591: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
592: fnd_message.set_token( token => 'LOCATION'
593: , value => 'oki_refresh_pvt.ins_job_runs' ) ;
594: fnd_file.put_line( which => fnd_file.log
595: , buff => fnd_message.get ) ;
596:
597: -- Log the location within the procedure where the error occurred
598: fnd_message.set_name( application => 'OKI'
599: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

594: fnd_file.put_line( which => fnd_file.log
595: , buff => fnd_message.get ) ;
596:
597: -- Log the location within the procedure where the error occurred
598: fnd_message.set_name( application => 'OKI'
599: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
600: fnd_message.set_token( token => 'LOCATION'
601: , value => l_loc ) ;
602: fnd_file.put_line( which => fnd_file.log

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

596:
597: -- Log the location within the procedure where the error occurred
598: fnd_message.set_name( application => 'OKI'
599: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
600: fnd_message.set_token( token => 'LOCATION'
601: , value => l_loc ) ;
602: fnd_file.put_line( which => fnd_file.log
603: , buff => fnd_message.get ) ;
604:

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

599: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
600: fnd_message.set_token( token => 'LOCATION'
601: , value => l_loc ) ;
602: fnd_file.put_line( which => fnd_file.log
603: , buff => fnd_message.get ) ;
604:
605: WHEN OTHERS THEN
606: l_sqlcode := sqlcode ;
607: l_sqlerrm := sqlerrm ;

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

606: l_sqlcode := sqlcode ;
607: l_sqlerrm := sqlerrm ;
608: ROLLBACK ;
609: x_retcode := '2' ;
610: fnd_message.set_name( application => 'OKI'
611: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
612:
613: fnd_message.set_token( token => 'OBJECT_NAME'
614: , value => 'oki_refresh_pvt.job_start' ) ;

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

609: x_retcode := '2' ;
610: fnd_message.set_name( application => 'OKI'
611: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
612:
613: fnd_message.set_token( token => 'OBJECT_NAME'
614: , value => 'oki_refresh_pvt.job_start' ) ;
615:
616: fnd_file.put_line( which => fnd_file.log
617: , buff => fnd_message.get ) ;

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

613: fnd_message.set_token( token => 'OBJECT_NAME'
614: , value => 'oki_refresh_pvt.job_start' ) ;
615:
616: fnd_file.put_line( which => fnd_file.log
617: , buff => fnd_message.get ) ;
618:
619: -- Log the location within the procedure where the error occurred
620: fnd_message.set_name( application => 'OKI'
621: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

616: fnd_file.put_line( which => fnd_file.log
617: , buff => fnd_message.get ) ;
618:
619: -- Log the location within the procedure where the error occurred
620: fnd_message.set_name( application => 'OKI'
621: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
622: fnd_message.set_token( token => 'LOCATION'
623: , value => l_loc ) ;
624: fnd_file.put_line( which => fnd_file.log

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

618:
619: -- Log the location within the procedure where the error occurred
620: fnd_message.set_name( application => 'OKI'
621: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
622: fnd_message.set_token( token => 'LOCATION'
623: , value => l_loc ) ;
624: fnd_file.put_line( which => fnd_file.log
625: , buff => fnd_message.get ) ;
626:

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

621: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
622: fnd_message.set_token( token => 'LOCATION'
623: , value => l_loc ) ;
624: fnd_file.put_line( which => fnd_file.log
625: , buff => fnd_message.get ) ;
626:
627: fnd_file.put_line( which => fnd_file.log
628: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
629: END ins_job_runs ;

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

660: l_sqlcode := sqlcode ;
661: l_sqlerrm := sqlerrm ;
662: ROLLBACK ;
663: x_retcode := '2' ;
664: fnd_message.set_name( application => 'OKI'
665: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
666:
667: fnd_message.set_token( token => 'OBJECT_NAME'
668: , value => 'oki_refresh_pvt.truncate_table' ) ;

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

663: x_retcode := '2' ;
664: fnd_message.set_name( application => 'OKI'
665: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
666:
667: fnd_message.set_token( token => 'OBJECT_NAME'
668: , value => 'oki_refresh_pvt.truncate_table' ) ;
669:
670: fnd_file.put_line( which => fnd_file.log
671: , buff => fnd_message.get ) ;

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

667: fnd_message.set_token( token => 'OBJECT_NAME'
668: , value => 'oki_refresh_pvt.truncate_table' ) ;
669:
670: fnd_file.put_line( which => fnd_file.log
671: , buff => fnd_message.get ) ;
672:
673: -- Log the location within the procedure where the error occurred
674: fnd_message.set_name( application => 'OKI'
675: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

670: fnd_file.put_line( which => fnd_file.log
671: , buff => fnd_message.get ) ;
672:
673: -- Log the location within the procedure where the error occurred
674: fnd_message.set_name( application => 'OKI'
675: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
676: fnd_message.set_token( token => 'LOCATION'
677: , value => l_loc ) ;
678: fnd_file.put_line( which => fnd_file.log

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

672:
673: -- Log the location within the procedure where the error occurred
674: fnd_message.set_name( application => 'OKI'
675: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
676: fnd_message.set_token( token => 'LOCATION'
677: , value => l_loc ) ;
678: fnd_file.put_line( which => fnd_file.log
679: , buff => fnd_message.get ) ;
680:

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

675: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
676: fnd_message.set_token( token => 'LOCATION'
677: , value => l_loc ) ;
678: fnd_file.put_line( which => fnd_file.log
679: , buff => fnd_message.get ) ;
680:
681: fnd_file.put_line( which => fnd_file.log
682: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
683:

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

895: WHEN l_excp_no_processing then
896: -- Just exit the program and continue with the table load
897:
898: -- Log the location within the procedure where the error occurred
899: fnd_message.set_name( application => 'OKI'
900: , name => 'OKI_OBJ_ALREADY_RFR_MSG') ;
901: fnd_message.set_token( token => 'OBJECT_NAME'
902: , value => 'OKI_JOB_RUNS') ;
903: fnd_file.put_line( which => fnd_file.log

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

897:
898: -- Log the location within the procedure where the error occurred
899: fnd_message.set_name( application => 'OKI'
900: , name => 'OKI_OBJ_ALREADY_RFR_MSG') ;
901: fnd_message.set_token( token => 'OBJECT_NAME'
902: , value => 'OKI_JOB_RUNS') ;
903: fnd_file.put_line( which => fnd_file.log
904: , buff => fnd_message.get) ;
905:

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

900: , name => 'OKI_OBJ_ALREADY_RFR_MSG') ;
901: fnd_message.set_token( token => 'OBJECT_NAME'
902: , value => 'OKI_JOB_RUNS') ;
903: fnd_file.put_line( which => fnd_file.log
904: , buff => fnd_message.get) ;
905:
906: WHEN l_excp_exit_immediate THEN
907: -- Do not log an error ; It has already been logged.
908: -- Set return code to error

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

913: l_sqlcode := sqlcode;
914: l_sqlerrm := sqlerrm;
915: ROLLBACK;
916: x_retcode := '2';
917: fnd_message.set_name( application => 'OKI'
918: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
919:
920: fnd_message.set_token( token => 'OBJECT_NAME'
921: , value => 'oki_refresh_pvt.initial_job_check' ) ;

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

916: x_retcode := '2';
917: fnd_message.set_name( application => 'OKI'
918: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
919:
920: fnd_message.set_token( token => 'OBJECT_NAME'
921: , value => 'oki_refresh_pvt.initial_job_check' ) ;
922:
923: fnd_file.put_line( which => fnd_file.log
924: , buff => fnd_message.get ) ;

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

920: fnd_message.set_token( token => 'OBJECT_NAME'
921: , value => 'oki_refresh_pvt.initial_job_check' ) ;
922:
923: fnd_file.put_line( which => fnd_file.log
924: , buff => fnd_message.get ) ;
925:
926: -- Log the location within the procedure where the error occurred
927: fnd_message.set_name( application => 'OKI'
928: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

923: fnd_file.put_line( which => fnd_file.log
924: , buff => fnd_message.get ) ;
925:
926: -- Log the location within the procedure where the error occurred
927: fnd_message.set_name( application => 'OKI'
928: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
929: fnd_message.set_token( token => 'LOCATION'
930: , value => l_loc ) ;
931: fnd_file.put_line( which => fnd_file.log

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

925:
926: -- Log the location within the procedure where the error occurred
927: fnd_message.set_name( application => 'OKI'
928: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
929: fnd_message.set_token( token => 'LOCATION'
930: , value => l_loc ) ;
931: fnd_file.put_line( which => fnd_file.log
932: , buff => fnd_message.get ) ;
933:

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

928: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
929: fnd_message.set_token( token => 'LOCATION'
930: , value => l_loc ) ;
931: fnd_file.put_line( which => fnd_file.log
932: , buff => fnd_message.get ) ;
933:
934: fnd_file.put_line( which => fnd_file.log
935: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
936:

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

988: l_sqlcode := sqlcode ;
989: l_sqlerrm := sqlerrm ;
990: ROLLBACK ;
991: x_retcode := '2' ;
992: fnd_message.set_name( application => 'OKI'
993: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
994:
995: fnd_message.set_token( token => 'OBJECT_NAME'
996: , value => 'oki_refresh_pvt.get_load_date_range' ) ;

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

991: x_retcode := '2' ;
992: fnd_message.set_name( application => 'OKI'
993: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
994:
995: fnd_message.set_token( token => 'OBJECT_NAME'
996: , value => 'oki_refresh_pvt.get_load_date_range' ) ;
997:
998: fnd_file.put_line( which => fnd_file.log
999: , buff => fnd_message.get ) ;

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

995: fnd_message.set_token( token => 'OBJECT_NAME'
996: , value => 'oki_refresh_pvt.get_load_date_range' ) ;
997:
998: fnd_file.put_line( which => fnd_file.log
999: , buff => fnd_message.get ) ;
1000:
1001: -- Log the location within the procedure where the error occurred
1002: fnd_message.set_name( application => 'OKI'
1003: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

998: fnd_file.put_line( which => fnd_file.log
999: , buff => fnd_message.get ) ;
1000:
1001: -- Log the location within the procedure where the error occurred
1002: fnd_message.set_name( application => 'OKI'
1003: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1004: fnd_message.set_token( token => 'LOCATION'
1005: , value => l_loc ) ;
1006: fnd_file.put_line( which => fnd_file.log

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

1000:
1001: -- Log the location within the procedure where the error occurred
1002: fnd_message.set_name( application => 'OKI'
1003: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1004: fnd_message.set_token( token => 'LOCATION'
1005: , value => l_loc ) ;
1006: fnd_file.put_line( which => fnd_file.log
1007: , buff => fnd_message.get ) ;
1008:

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

1003: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1004: fnd_message.set_token( token => 'LOCATION'
1005: , value => l_loc ) ;
1006: fnd_file.put_line( which => fnd_file.log
1007: , buff => fnd_message.get ) ;
1008:
1009: fnd_file.put_line( which => fnd_file.log
1010: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
1011: END get_load_date_range ;

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

1176: l_sqlcode := sqlcode ;
1177: l_sqlerrm := sqlerrm ;
1178: ROLLBACK ;
1179: x_retcode := '2' ;
1180: fnd_message.set_name( application => 'OKI'
1181: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
1182:
1183: fnd_message.set_token( token => 'OBJECT_NAME'
1184: , value => 'oki_refresh_pvt.ins_job_run_dtl' ) ;

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

1179: x_retcode := '2' ;
1180: fnd_message.set_name( application => 'OKI'
1181: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
1182:
1183: fnd_message.set_token( token => 'OBJECT_NAME'
1184: , value => 'oki_refresh_pvt.ins_job_run_dtl' ) ;
1185:
1186: fnd_file.put_line( which => fnd_file.log
1187: , buff => fnd_message.get ) ;

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

1183: fnd_message.set_token( token => 'OBJECT_NAME'
1184: , value => 'oki_refresh_pvt.ins_job_run_dtl' ) ;
1185:
1186: fnd_file.put_line( which => fnd_file.log
1187: , buff => fnd_message.get ) ;
1188:
1189: -- Log the location within the procedure where the error occurred
1190: fnd_message.set_name( application => 'OKI'
1191: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

1186: fnd_file.put_line( which => fnd_file.log
1187: , buff => fnd_message.get ) ;
1188:
1189: -- Log the location within the procedure where the error occurred
1190: fnd_message.set_name( application => 'OKI'
1191: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1192: fnd_message.set_token( token => 'LOCATION'
1193: , value => l_loc ) ;
1194: fnd_file.put_line( which => fnd_file.log

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

1188:
1189: -- Log the location within the procedure where the error occurred
1190: fnd_message.set_name( application => 'OKI'
1191: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1192: fnd_message.set_token( token => 'LOCATION'
1193: , value => l_loc ) ;
1194: fnd_file.put_line( which => fnd_file.log
1195: , buff => fnd_message.get ) ;
1196:

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

1191: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1192: fnd_message.set_token( token => 'LOCATION'
1193: , value => l_loc ) ;
1194: fnd_file.put_line( which => fnd_file.log
1195: , buff => fnd_message.get ) ;
1196:
1197: fnd_file.put_line( which => fnd_file.log
1198: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
1199: END ins_job_run_dtl ;

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

1372: END IF;
1373:
1374:
1375: IF(l_trx_base_rate_tab(i) = 0) THEN
1376: fnd_message.set_name(application => 'OKI'
1377: ,name => 'OKI_CONV_RATE_FAILURE');
1378: fnd_message.set_token(token => 'FROM_CURRENCY'
1379: ,value => trans_currency_tab(i));
1380: fnd_message.set_token(token => 'TO_CURRENCY'

Line 1378: fnd_message.set_token(token => 'FROM_CURRENCY'

1374:
1375: IF(l_trx_base_rate_tab(i) = 0) THEN
1376: fnd_message.set_name(application => 'OKI'
1377: ,name => 'OKI_CONV_RATE_FAILURE');
1378: fnd_message.set_token(token => 'FROM_CURRENCY'
1379: ,value => trans_currency_tab(i));
1380: fnd_message.set_token(token => 'TO_CURRENCY'
1381: ,value => base_currency_tab(i));
1382: fnd_file.put_line(which => fnd_file.log

Line 1380: fnd_message.set_token(token => 'TO_CURRENCY'

1376: fnd_message.set_name(application => 'OKI'
1377: ,name => 'OKI_CONV_RATE_FAILURE');
1378: fnd_message.set_token(token => 'FROM_CURRENCY'
1379: ,value => trans_currency_tab(i));
1380: fnd_message.set_token(token => 'TO_CURRENCY'
1381: ,value => base_currency_tab(i));
1382: fnd_file.put_line(which => fnd_file.log
1383: ,buff => fnd_message.get);
1384: END IF;

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

1379: ,value => trans_currency_tab(i));
1380: fnd_message.set_token(token => 'TO_CURRENCY'
1381: ,value => base_currency_tab(i));
1382: fnd_file.put_line(which => fnd_file.log
1383: ,buff => fnd_message.get);
1384: END IF;
1385:
1386: IF(l_trx_func_rate_tab(i) = 0) THEN
1387: fnd_message.set_name(application => 'OKI'

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

1383: ,buff => fnd_message.get);
1384: END IF;
1385:
1386: IF(l_trx_func_rate_tab(i) = 0) THEN
1387: fnd_message.set_name(application => 'OKI'
1388: ,name => 'OKI_CONV_RATE_FAILURE');
1389: fnd_message.set_token(token => 'FROM_CURRENCY'
1390: ,value => trans_currency_tab(i));
1391: fnd_message.set_token(token => 'TO_CURRENCY'

Line 1389: fnd_message.set_token(token => 'FROM_CURRENCY'

1385:
1386: IF(l_trx_func_rate_tab(i) = 0) THEN
1387: fnd_message.set_name(application => 'OKI'
1388: ,name => 'OKI_CONV_RATE_FAILURE');
1389: fnd_message.set_token(token => 'FROM_CURRENCY'
1390: ,value => trans_currency_tab(i));
1391: fnd_message.set_token(token => 'TO_CURRENCY'
1392: ,value => func_currency_tab(i));
1393: fnd_file.put_line(which => fnd_file.log

Line 1391: fnd_message.set_token(token => 'TO_CURRENCY'

1387: fnd_message.set_name(application => 'OKI'
1388: ,name => 'OKI_CONV_RATE_FAILURE');
1389: fnd_message.set_token(token => 'FROM_CURRENCY'
1390: ,value => trans_currency_tab(i));
1391: fnd_message.set_token(token => 'TO_CURRENCY'
1392: ,value => func_currency_tab(i));
1393: fnd_file.put_line(which => fnd_file.log
1394: ,buff => fnd_message.get);
1395: END IF;

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

1390: ,value => trans_currency_tab(i));
1391: fnd_message.set_token(token => 'TO_CURRENCY'
1392: ,value => func_currency_tab(i));
1393: fnd_file.put_line(which => fnd_file.log
1394: ,buff => fnd_message.get);
1395: END IF;
1396:
1397: END LOOP; -- FOR loop on tab(i)
1398:

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

1470: ,tabname => 'OKI_K_CONV_RATE',percent=> 10);
1471:
1472: EXCEPTION
1473: when l_no_update_refresh then
1474: fnd_message.set_name(application => 'OKI'
1475: ,name => 'OKI_TABLE_LOAD_FAILURE');
1476: fnd_message.set_token(token => 'TABLE_NAME'
1477: ,value => 'initial_load_job_run_dtl');
1478: fnd_file.put_line(which => fnd_file.log

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

1472: EXCEPTION
1473: when l_no_update_refresh then
1474: fnd_message.set_name(application => 'OKI'
1475: ,name => 'OKI_TABLE_LOAD_FAILURE');
1476: fnd_message.set_token(token => 'TABLE_NAME'
1477: ,value => 'initial_load_job_run_dtl');
1478: fnd_file.put_line(which => fnd_file.log
1479: ,buff => fnd_message.get);
1480:

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

1475: ,name => 'OKI_TABLE_LOAD_FAILURE');
1476: fnd_message.set_token(token => 'TABLE_NAME'
1477: ,value => 'initial_load_job_run_dtl');
1478: fnd_file.put_line(which => fnd_file.log
1479: ,buff => fnd_message.get);
1480:
1481: fnd_file.put_line(which => fnd_file.log
1482: ,buff => 'Update of OKI_REFRESHS failed');
1483: WHEN OTHERS THEN

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

1485: l_sqlcode := sqlcode;
1486: l_sqlerrm := sqlerrm;
1487: ROLLBACK;
1488: x_retcode := '2';
1489: fnd_message.set_name(application => 'OKI'
1490: ,name => 'OKI_TABLE_LOAD_FAILURE');
1491: fnd_message.set_token(token => 'TABLE_NAME'
1492: ,value => 'initial_load_job_run_dtl');
1493: fnd_file.put_line(which => fnd_file.log

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

1487: ROLLBACK;
1488: x_retcode := '2';
1489: fnd_message.set_name(application => 'OKI'
1490: ,name => 'OKI_TABLE_LOAD_FAILURE');
1491: fnd_message.set_token(token => 'TABLE_NAME'
1492: ,value => 'initial_load_job_run_dtl');
1493: fnd_file.put_line(which => fnd_file.log
1494: ,buff => fnd_message.get);
1495: fnd_file.put_line(which => fnd_file.log

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

1490: ,name => 'OKI_TABLE_LOAD_FAILURE');
1491: fnd_message.set_token(token => 'TABLE_NAME'
1492: ,value => 'initial_load_job_run_dtl');
1493: fnd_file.put_line(which => fnd_file.log
1494: ,buff => fnd_message.get);
1495: fnd_file.put_line(which => fnd_file.log
1496: ,buff => l_sqlcode||' '||l_sqlerrm);
1497: END initial_load_job_run_dtl;
1498:

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

1651: -- Set return code to error
1652: x_retcode := 2 ;
1653:
1654: -- Log the location within the package where the error occurred
1655: fnd_message.set_name( application => 'OKI'
1656: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1657: fnd_message.set_token( token => 'LOCATION'
1658: , value => 'oki_refresh_pvt.job_start' ) ;
1659: fnd_file.put_line( which => fnd_file.log

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

1653:
1654: -- Log the location within the package where the error occurred
1655: fnd_message.set_name( application => 'OKI'
1656: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1657: fnd_message.set_token( token => 'LOCATION'
1658: , value => 'oki_refresh_pvt.job_start' ) ;
1659: fnd_file.put_line( which => fnd_file.log
1660: , buff => fnd_message.get ) ;
1661:

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

1656: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1657: fnd_message.set_token( token => 'LOCATION'
1658: , value => 'oki_refresh_pvt.job_start' ) ;
1659: fnd_file.put_line( which => fnd_file.log
1660: , buff => fnd_message.get ) ;
1661:
1662: -- Log the location within the procedure where the error occurred
1663: fnd_message.set_name( application => 'OKI'
1664: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

1659: fnd_file.put_line( which => fnd_file.log
1660: , buff => fnd_message.get ) ;
1661:
1662: -- Log the location within the procedure where the error occurred
1663: fnd_message.set_name( application => 'OKI'
1664: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1665: fnd_message.set_token( token => 'LOCATION'
1666: , value => l_loc ) ;
1667: fnd_file.put_line( which => fnd_file.log

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

1661:
1662: -- Log the location within the procedure where the error occurred
1663: fnd_message.set_name( application => 'OKI'
1664: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1665: fnd_message.set_token( token => 'LOCATION'
1666: , value => l_loc ) ;
1667: fnd_file.put_line( which => fnd_file.log
1668: , buff => fnd_message.get ) ;
1669:

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

1664: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1665: fnd_message.set_token( token => 'LOCATION'
1666: , value => l_loc ) ;
1667: fnd_file.put_line( which => fnd_file.log
1668: , buff => fnd_message.get ) ;
1669:
1670: WHEN OTHERS THEN
1671: l_sqlcode := sqlcode ;
1672: l_sqlerrm := sqlerrm ;

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

1671: l_sqlcode := sqlcode ;
1672: l_sqlerrm := sqlerrm ;
1673: ROLLBACK ;
1674: x_retcode := '2' ;
1675: fnd_message.set_name( application => 'OKI'
1676: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
1677:
1678: fnd_message.set_token( token => 'OBJECT_NAME'
1679: , value => 'oki_refresh_pvt.job_start' ) ;

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

1674: x_retcode := '2' ;
1675: fnd_message.set_name( application => 'OKI'
1676: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
1677:
1678: fnd_message.set_token( token => 'OBJECT_NAME'
1679: , value => 'oki_refresh_pvt.job_start' ) ;
1680:
1681: fnd_file.put_line( which => fnd_file.log
1682: , buff => fnd_message.get ) ;

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

1678: fnd_message.set_token( token => 'OBJECT_NAME'
1679: , value => 'oki_refresh_pvt.job_start' ) ;
1680:
1681: fnd_file.put_line( which => fnd_file.log
1682: , buff => fnd_message.get ) ;
1683:
1684: -- Log the location within the procedure where the error occurred
1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

1681: fnd_file.put_line( which => fnd_file.log
1682: , buff => fnd_message.get ) ;
1683:
1684: -- Log the location within the procedure where the error occurred
1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1687: fnd_message.set_token( token => 'LOCATION'
1688: , value => l_loc ) ;
1689: fnd_file.put_line( which => fnd_file.log

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

1683:
1684: -- Log the location within the procedure where the error occurred
1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1687: fnd_message.set_token( token => 'LOCATION'
1688: , value => l_loc ) ;
1689: fnd_file.put_line( which => fnd_file.log
1690: , buff => fnd_message.get ) ;
1691:

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

1686: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1687: fnd_message.set_token( token => 'LOCATION'
1688: , value => l_loc ) ;
1689: fnd_file.put_line( which => fnd_file.log
1690: , buff => fnd_message.get ) ;
1691:
1692: fnd_file.put_line( which => fnd_file.log
1693: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
1694: END job_start ;

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

1824: -- Set return code to error
1825: x_retcode := 2 ;
1826:
1827: -- Log the location within the package where the error occurred
1828: fnd_message.set_name( application => 'OKI'
1829: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1830: fnd_message.set_token( token => 'LOCATION'
1831: , value => 'oki_refresh_pvt.job_start' ) ;
1832: fnd_file.put_line( which => fnd_file.log

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

1826:
1827: -- Log the location within the package where the error occurred
1828: fnd_message.set_name( application => 'OKI'
1829: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1830: fnd_message.set_token( token => 'LOCATION'
1831: , value => 'oki_refresh_pvt.job_start' ) ;
1832: fnd_file.put_line( which => fnd_file.log
1833: , buff => fnd_message.get ) ;
1834:

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

1829: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1830: fnd_message.set_token( token => 'LOCATION'
1831: , value => 'oki_refresh_pvt.job_start' ) ;
1832: fnd_file.put_line( which => fnd_file.log
1833: , buff => fnd_message.get ) ;
1834:
1835: -- Log the location within the procedure where the error occurred
1836: fnd_message.set_name( application => 'OKI'
1837: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

1832: fnd_file.put_line( which => fnd_file.log
1833: , buff => fnd_message.get ) ;
1834:
1835: -- Log the location within the procedure where the error occurred
1836: fnd_message.set_name( application => 'OKI'
1837: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1838: fnd_message.set_token( token => 'LOCATION'
1839: , value => l_loc ) ;
1840: fnd_file.put_line( which => fnd_file.log

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

1834:
1835: -- Log the location within the procedure where the error occurred
1836: fnd_message.set_name( application => 'OKI'
1837: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1838: fnd_message.set_token( token => 'LOCATION'
1839: , value => l_loc ) ;
1840: fnd_file.put_line( which => fnd_file.log
1841: , buff => fnd_message.get ) ;
1842:

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

1837: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1838: fnd_message.set_token( token => 'LOCATION'
1839: , value => l_loc ) ;
1840: fnd_file.put_line( which => fnd_file.log
1841: , buff => fnd_message.get ) ;
1842:
1843: WHEN OTHERS THEN
1844: l_sqlcode := sqlcode ;
1845: l_sqlerrm := sqlerrm ;

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

1844: l_sqlcode := sqlcode ;
1845: l_sqlerrm := sqlerrm ;
1846: ROLLBACK ;
1847: x_retcode := '2' ;
1848: fnd_message.set_name( application => 'OKI'
1849: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
1850:
1851: fnd_message.set_token( token => 'OBJECT_NAME'
1852: , value => 'oki_refresh_pvt.job_start' ) ;

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

1847: x_retcode := '2' ;
1848: fnd_message.set_name( application => 'OKI'
1849: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
1850:
1851: fnd_message.set_token( token => 'OBJECT_NAME'
1852: , value => 'oki_refresh_pvt.job_start' ) ;
1853:
1854: fnd_file.put_line( which => fnd_file.log
1855: , buff => fnd_message.get ) ;

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

1851: fnd_message.set_token( token => 'OBJECT_NAME'
1852: , value => 'oki_refresh_pvt.job_start' ) ;
1853:
1854: fnd_file.put_line( which => fnd_file.log
1855: , buff => fnd_message.get ) ;
1856:
1857: -- Log the location within the procedure where the error occurred
1858: fnd_message.set_name( application => 'OKI'
1859: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

1854: fnd_file.put_line( which => fnd_file.log
1855: , buff => fnd_message.get ) ;
1856:
1857: -- Log the location within the procedure where the error occurred
1858: fnd_message.set_name( application => 'OKI'
1859: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1860: fnd_message.set_token( token => 'LOCATION'
1861: , value => l_loc ) ;
1862: fnd_file.put_line( which => fnd_file.log

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

1856:
1857: -- Log the location within the procedure where the error occurred
1858: fnd_message.set_name( application => 'OKI'
1859: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1860: fnd_message.set_token( token => 'LOCATION'
1861: , value => l_loc ) ;
1862: fnd_file.put_line( which => fnd_file.log
1863: , buff => fnd_message.get ) ;
1864:

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

1859: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1860: fnd_message.set_token( token => 'LOCATION'
1861: , value => l_loc ) ;
1862: fnd_file.put_line( which => fnd_file.log
1863: , buff => fnd_message.get ) ;
1864:
1865: fnd_file.put_line( which => fnd_file.log
1866: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
1867: END initial_load_job_start;

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

1939: CLOSE cur_currency_rate;
1940: END IF;
1941: l_sqlcode := sqlcode;
1942: l_sqlerrm := sqlerrm;
1943: fnd_message.set_name( application => 'OKI'
1944: , name => 'OKI_CONV_RATE_FAILURE' ) ;
1945:
1946: fnd_message.set_token( token => 'OBJECT_NAME'
1947: , value => 'oki_refresh_pvt.get_conversion_rate' ) ;

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

1942: l_sqlerrm := sqlerrm;
1943: fnd_message.set_name( application => 'OKI'
1944: , name => 'OKI_CONV_RATE_FAILURE' ) ;
1945:
1946: fnd_message.set_token( token => 'OBJECT_NAME'
1947: , value => 'oki_refresh_pvt.get_conversion_rate' ) ;
1948:
1949: fnd_message.set_token( token => 'FROM_CURRENCY'
1950: , value => 'p_from_currency' ) ;

Line 1949: fnd_message.set_token( token => 'FROM_CURRENCY'

1945:
1946: fnd_message.set_token( token => 'OBJECT_NAME'
1947: , value => 'oki_refresh_pvt.get_conversion_rate' ) ;
1948:
1949: fnd_message.set_token( token => 'FROM_CURRENCY'
1950: , value => 'p_from_currency' ) ;
1951:
1952: fnd_message.set_token( token => 'TO_CURRENCY'
1953: , value => 'p_to_currency' ) ;

Line 1952: fnd_message.set_token( token => 'TO_CURRENCY'

1948:
1949: fnd_message.set_token( token => 'FROM_CURRENCY'
1950: , value => 'p_from_currency' ) ;
1951:
1952: fnd_message.set_token( token => 'TO_CURRENCY'
1953: , value => 'p_to_currency' ) ;
1954:
1955: fnd_file.put_line( which => fnd_file.log
1956: , buff => fnd_message.get ) ;

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

1952: fnd_message.set_token( token => 'TO_CURRENCY'
1953: , value => 'p_to_currency' ) ;
1954:
1955: fnd_file.put_line( which => fnd_file.log
1956: , buff => fnd_message.get ) ;
1957:
1958: -- Log the location within the procedure where the error occurred
1959: fnd_message.set_name( application => 'OKI'
1960: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

1955: fnd_file.put_line( which => fnd_file.log
1956: , buff => fnd_message.get ) ;
1957:
1958: -- Log the location within the procedure where the error occurred
1959: fnd_message.set_name( application => 'OKI'
1960: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1961: fnd_message.set_token( token => 'LOCATION'
1962: , value => l_loc ) ;
1963: fnd_file.put_line( which => fnd_file.log

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

1957:
1958: -- Log the location within the procedure where the error occurred
1959: fnd_message.set_name( application => 'OKI'
1960: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1961: fnd_message.set_token( token => 'LOCATION'
1962: , value => l_loc ) ;
1963: fnd_file.put_line( which => fnd_file.log
1964: , buff => fnd_message.get ) ;
1965: RETURN -1;

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

1960: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
1961: fnd_message.set_token( token => 'LOCATION'
1962: , value => l_loc ) ;
1963: fnd_file.put_line( which => fnd_file.log
1964: , buff => fnd_message.get ) ;
1965: RETURN -1;
1966: END;
1967:
1968:

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

2028: -- Set return code to error
2029: x_retcode := 2 ;
2030:
2031: -- Log the location within the package where the error occurred
2032: fnd_message.set_name( application => 'OKI'
2033: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2034: fnd_message.set_token( token => 'LOCATION'
2035: , value => 'oki_refresh_pvt.job_end' ) ;
2036: fnd_file.put_line( which => fnd_file.log

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

2030:
2031: -- Log the location within the package where the error occurred
2032: fnd_message.set_name( application => 'OKI'
2033: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2034: fnd_message.set_token( token => 'LOCATION'
2035: , value => 'oki_refresh_pvt.job_end' ) ;
2036: fnd_file.put_line( which => fnd_file.log
2037: , buff => fnd_message.get ) ;
2038:

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

2033: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2034: fnd_message.set_token( token => 'LOCATION'
2035: , value => 'oki_refresh_pvt.job_end' ) ;
2036: fnd_file.put_line( which => fnd_file.log
2037: , buff => fnd_message.get ) ;
2038:
2039: -- Log the location within the procedure where the error occurred
2040: fnd_message.set_name( application => 'OKI'
2041: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

2036: fnd_file.put_line( which => fnd_file.log
2037: , buff => fnd_message.get ) ;
2038:
2039: -- Log the location within the procedure where the error occurred
2040: fnd_message.set_name( application => 'OKI'
2041: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2042: fnd_message.set_token( token => 'LOCATION'
2043: , value => l_loc ) ;
2044: fnd_file.put_line( which => fnd_file.log

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

2038:
2039: -- Log the location within the procedure where the error occurred
2040: fnd_message.set_name( application => 'OKI'
2041: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2042: fnd_message.set_token( token => 'LOCATION'
2043: , value => l_loc ) ;
2044: fnd_file.put_line( which => fnd_file.log
2045: , buff => fnd_message.get ) ;
2046:

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

2041: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2042: fnd_message.set_token( token => 'LOCATION'
2043: , value => l_loc ) ;
2044: fnd_file.put_line( which => fnd_file.log
2045: , buff => fnd_message.get ) ;
2046:
2047: WHEN OTHERS THEN
2048: l_sqlcode := sqlcode ;
2049: l_sqlerrm := sqlerrm ;

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

2048: l_sqlcode := sqlcode ;
2049: l_sqlerrm := sqlerrm ;
2050: ROLLBACK ;
2051: x_retcode := '2' ;
2052: fnd_message.set_name( application => 'OKI'
2053: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2054:
2055: fnd_message.set_token( token => 'OBJECT_NAME'
2056: , value => 'oki_refresh_pvt.job_end' ) ;

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

2051: x_retcode := '2' ;
2052: fnd_message.set_name( application => 'OKI'
2053: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2054:
2055: fnd_message.set_token( token => 'OBJECT_NAME'
2056: , value => 'oki_refresh_pvt.job_end' ) ;
2057:
2058: fnd_file.put_line( which => fnd_file.log
2059: , buff => fnd_message.get ) ;

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

2055: fnd_message.set_token( token => 'OBJECT_NAME'
2056: , value => 'oki_refresh_pvt.job_end' ) ;
2057:
2058: fnd_file.put_line( which => fnd_file.log
2059: , buff => fnd_message.get ) ;
2060:
2061: -- Log the location within the procedure where the error occurred
2062: fnd_message.set_name( application => 'OKI'
2063: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

2058: fnd_file.put_line( which => fnd_file.log
2059: , buff => fnd_message.get ) ;
2060:
2061: -- Log the location within the procedure where the error occurred
2062: fnd_message.set_name( application => 'OKI'
2063: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2064: fnd_message.set_token( token => 'LOCATION'
2065: , value => l_loc ) ;
2066: fnd_file.put_line( which => fnd_file.log

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

2060:
2061: -- Log the location within the procedure where the error occurred
2062: fnd_message.set_name( application => 'OKI'
2063: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2064: fnd_message.set_token( token => 'LOCATION'
2065: , value => l_loc ) ;
2066: fnd_file.put_line( which => fnd_file.log
2067: , buff => fnd_message.get ) ;
2068:

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

2063: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2064: fnd_message.set_token( token => 'LOCATION'
2065: , value => l_loc ) ;
2066: fnd_file.put_line( which => fnd_file.log
2067: , buff => fnd_message.get ) ;
2068:
2069: fnd_file.put_line( which => fnd_file.log
2070: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
2071: END job_end ;

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

2157: EXCEPTION
2158: WHEN l_excp_no_processing then
2159: x_process_yn := 'N' ;
2160: -- Log the location within the procedure where the error occurred
2161: fnd_message.set_name( application => 'OKI'
2162: , name => 'OKI_OBJ_ALREADY_RFR_MSG') ;
2163: fnd_message.set_token( token => 'OBJECT_NAME'
2164: , value => p_object_name ) ;
2165: fnd_file.put_line( which => fnd_file.log

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

2159: x_process_yn := 'N' ;
2160: -- Log the location within the procedure where the error occurred
2161: fnd_message.set_name( application => 'OKI'
2162: , name => 'OKI_OBJ_ALREADY_RFR_MSG') ;
2163: fnd_message.set_token( token => 'OBJECT_NAME'
2164: , value => p_object_name ) ;
2165: fnd_file.put_line( which => fnd_file.log
2166: , buff => fnd_message.get) ;
2167:

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

2162: , name => 'OKI_OBJ_ALREADY_RFR_MSG') ;
2163: fnd_message.set_token( token => 'OBJECT_NAME'
2164: , value => p_object_name ) ;
2165: fnd_file.put_line( which => fnd_file.log
2166: , buff => fnd_message.get) ;
2167:
2168: WHEN l_excp_exit_immediate THEN
2169: -- Do not log an error ; It has already been logged.
2170: -- Set return code to error

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

2169: -- Do not log an error ; It has already been logged.
2170: -- Set return code to error
2171: x_retcode := 2 ;
2172: -- Log the location within the package where the error occurred
2173: fnd_message.set_name( application => 'OKI'
2174: , name => 'OKI_LOC_IN_PROG_FAILURE') ;
2175: fnd_message.set_token( token => 'LOCATION'
2176: , value => 'oki_refresh_pvt.process_refresh_check' ) ;
2177: fnd_file.put_line( which => fnd_file.log

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

2171: x_retcode := 2 ;
2172: -- Log the location within the package where the error occurred
2173: fnd_message.set_name( application => 'OKI'
2174: , name => 'OKI_LOC_IN_PROG_FAILURE') ;
2175: fnd_message.set_token( token => 'LOCATION'
2176: , value => 'oki_refresh_pvt.process_refresh_check' ) ;
2177: fnd_file.put_line( which => fnd_file.log
2178: , buff => fnd_message.get) ;
2179:

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

2174: , name => 'OKI_LOC_IN_PROG_FAILURE') ;
2175: fnd_message.set_token( token => 'LOCATION'
2176: , value => 'oki_refresh_pvt.process_refresh_check' ) ;
2177: fnd_file.put_line( which => fnd_file.log
2178: , buff => fnd_message.get) ;
2179:
2180: -- Log the location within the procedure where the error occurred
2181: fnd_message.set_name( application => 'OKI'
2182: , name => 'OKI_LOC_IN_PROG_FAILURE') ;

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

2177: fnd_file.put_line( which => fnd_file.log
2178: , buff => fnd_message.get) ;
2179:
2180: -- Log the location within the procedure where the error occurred
2181: fnd_message.set_name( application => 'OKI'
2182: , name => 'OKI_LOC_IN_PROG_FAILURE') ;
2183: fnd_message.set_token( token => 'LOCATION'
2184: , value => l_loc) ;
2185: fnd_file.put_line( which => fnd_file.log

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

2179:
2180: -- Log the location within the procedure where the error occurred
2181: fnd_message.set_name( application => 'OKI'
2182: , name => 'OKI_LOC_IN_PROG_FAILURE') ;
2183: fnd_message.set_token( token => 'LOCATION'
2184: , value => l_loc) ;
2185: fnd_file.put_line( which => fnd_file.log
2186: , buff => fnd_message.get) ;
2187:

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

2182: , name => 'OKI_LOC_IN_PROG_FAILURE') ;
2183: fnd_message.set_token( token => 'LOCATION'
2184: , value => l_loc) ;
2185: fnd_file.put_line( which => fnd_file.log
2186: , buff => fnd_message.get) ;
2187:
2188: WHEN OTHERS THEN
2189: l_sqlcode := sqlcode ;
2190: l_sqlerrm := sqlerrm ;

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

2189: l_sqlcode := sqlcode ;
2190: l_sqlerrm := sqlerrm ;
2191: ROLLBACK ;
2192: x_retcode := '2' ;
2193: fnd_message.set_name( application => 'OKI'
2194: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2195:
2196: fnd_message.set_token( token => 'OBJECT_NAME'
2197: , value => 'oki_refresh_pvt.process_refresh_check' ) ;

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

2192: x_retcode := '2' ;
2193: fnd_message.set_name( application => 'OKI'
2194: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2195:
2196: fnd_message.set_token( token => 'OBJECT_NAME'
2197: , value => 'oki_refresh_pvt.process_refresh_check' ) ;
2198:
2199: fnd_file.put_line( which => fnd_file.log
2200: , buff => fnd_message.get ) ;

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

2196: fnd_message.set_token( token => 'OBJECT_NAME'
2197: , value => 'oki_refresh_pvt.process_refresh_check' ) ;
2198:
2199: fnd_file.put_line( which => fnd_file.log
2200: , buff => fnd_message.get ) ;
2201:
2202: -- Log the location within the procedure where the error occurred
2203: fnd_message.set_name( application => 'OKI'
2204: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;

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

2199: fnd_file.put_line( which => fnd_file.log
2200: , buff => fnd_message.get ) ;
2201:
2202: -- Log the location within the procedure where the error occurred
2203: fnd_message.set_name( application => 'OKI'
2204: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2205: fnd_message.set_token( token => 'LOCATION'
2206: , value => l_loc ) ;
2207: fnd_file.put_line( which => fnd_file.log

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

2201:
2202: -- Log the location within the procedure where the error occurred
2203: fnd_message.set_name( application => 'OKI'
2204: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2205: fnd_message.set_token( token => 'LOCATION'
2206: , value => l_loc ) ;
2207: fnd_file.put_line( which => fnd_file.log
2208: , buff => fnd_message.get ) ;
2209:

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

2204: , name => 'OKI_LOC_IN_PROG_FAILURE' ) ;
2205: fnd_message.set_token( token => 'LOCATION'
2206: , value => l_loc ) ;
2207: fnd_file.put_line( which => fnd_file.log
2208: , buff => fnd_message.get ) ;
2209:
2210: fnd_file.put_line( which => fnd_file.log
2211: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
2212: END process_refresh_check ;

Line 2306: fnd_message.set_name('OKI','OKI_TABLE_LOAD_SUCCESS');

2302: -- analyze table
2303: fnd_stats.gather_table_stats(ownname=>'OKI' ,tabname=>'OKI_DAILY_RATES',percent=> 10);
2304:
2305: --DBMS_OUTPUT.PUT_LINE('End of the program...');
2306: fnd_message.set_name('OKI','OKI_TABLE_LOAD_SUCCESS');
2307: fnd_message.set_token('TABLE_NAME','OKI_DAILY_RATES');
2308: fnd_file.put_line(fnd_file.log,fnd_message.get);
2309: EXCEPTION
2310: when l_no_update_refresh then

Line 2307: fnd_message.set_token('TABLE_NAME','OKI_DAILY_RATES');

2303: fnd_stats.gather_table_stats(ownname=>'OKI' ,tabname=>'OKI_DAILY_RATES',percent=> 10);
2304:
2305: --DBMS_OUTPUT.PUT_LINE('End of the program...');
2306: fnd_message.set_name('OKI','OKI_TABLE_LOAD_SUCCESS');
2307: fnd_message.set_token('TABLE_NAME','OKI_DAILY_RATES');
2308: fnd_file.put_line(fnd_file.log,fnd_message.get);
2309: EXCEPTION
2310: when l_no_update_refresh then
2311: fnd_message.set_name(application => 'OKI'

Line 2308: fnd_file.put_line(fnd_file.log,fnd_message.get);

2304:
2305: --DBMS_OUTPUT.PUT_LINE('End of the program...');
2306: fnd_message.set_name('OKI','OKI_TABLE_LOAD_SUCCESS');
2307: fnd_message.set_token('TABLE_NAME','OKI_DAILY_RATES');
2308: fnd_file.put_line(fnd_file.log,fnd_message.get);
2309: EXCEPTION
2310: when l_no_update_refresh then
2311: fnd_message.set_name(application => 'OKI'
2312: ,name => 'OKI_TABLE_LOAD_FAILURE');

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

2307: fnd_message.set_token('TABLE_NAME','OKI_DAILY_RATES');
2308: fnd_file.put_line(fnd_file.log,fnd_message.get);
2309: EXCEPTION
2310: when l_no_update_refresh then
2311: fnd_message.set_name(application => 'OKI'
2312: ,name => 'OKI_TABLE_LOAD_FAILURE');
2313: fnd_message.set_token(token => 'TABLE_NAME'
2314: ,value => 'OKI_DAILY_RATES');
2315: fnd_file.put_line(which => fnd_file.log

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

2309: EXCEPTION
2310: when l_no_update_refresh then
2311: fnd_message.set_name(application => 'OKI'
2312: ,name => 'OKI_TABLE_LOAD_FAILURE');
2313: fnd_message.set_token(token => 'TABLE_NAME'
2314: ,value => 'OKI_DAILY_RATES');
2315: fnd_file.put_line(which => fnd_file.log
2316: ,buff => fnd_message.get);
2317:

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

2312: ,name => 'OKI_TABLE_LOAD_FAILURE');
2313: fnd_message.set_token(token => 'TABLE_NAME'
2314: ,value => 'OKI_DAILY_RATES');
2315: fnd_file.put_line(which => fnd_file.log
2316: ,buff => fnd_message.get);
2317:
2318: fnd_file.put_line(which => fnd_file.log
2319: ,buff => 'Update of OKI_REFRESHS failed');
2320: WHEN OTHERS THEN

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

2320: WHEN OTHERS THEN
2321: retcode := '2';
2322: fnd_file.put_line(fnd_file.log,sqlcode||' '||sqlerrm);
2323:
2324: fnd_message.set_name(application => 'OKI'
2325: ,name => 'OKI_UNEXPECTED_FAILURE');
2326: fnd_message.set_token(token => 'OBJECT_NAME'
2327: ,value => 'OKI_DAILY_RATES');
2328: fnd_file.put_line(which => fnd_file.log

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

2322: fnd_file.put_line(fnd_file.log,sqlcode||' '||sqlerrm);
2323:
2324: fnd_message.set_name(application => 'OKI'
2325: ,name => 'OKI_UNEXPECTED_FAILURE');
2326: fnd_message.set_token(token => 'OBJECT_NAME'
2327: ,value => 'OKI_DAILY_RATES');
2328: fnd_file.put_line(which => fnd_file.log
2329: ,buff => fnd_message.get);
2330:

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

2325: ,name => 'OKI_UNEXPECTED_FAILURE');
2326: fnd_message.set_token(token => 'OBJECT_NAME'
2327: ,value => 'OKI_DAILY_RATES');
2328: fnd_file.put_line(which => fnd_file.log
2329: ,buff => fnd_message.get);
2330:
2331: fnd_message.set_name(application => 'OKI'
2332: ,name => 'OKI_TABLE_LOAD_FAILURE');
2333: fnd_message.set_token(token => 'TABLE_NAME'

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

2327: ,value => 'OKI_DAILY_RATES');
2328: fnd_file.put_line(which => fnd_file.log
2329: ,buff => fnd_message.get);
2330:
2331: fnd_message.set_name(application => 'OKI'
2332: ,name => 'OKI_TABLE_LOAD_FAILURE');
2333: fnd_message.set_token(token => 'TABLE_NAME'
2334: ,value => 'OKI_DAILY_RATES');
2335: fnd_file.put_line(which => fnd_file.log

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

2329: ,buff => fnd_message.get);
2330:
2331: fnd_message.set_name(application => 'OKI'
2332: ,name => 'OKI_TABLE_LOAD_FAILURE');
2333: fnd_message.set_token(token => 'TABLE_NAME'
2334: ,value => 'OKI_DAILY_RATES');
2335: fnd_file.put_line(which => fnd_file.log
2336: ,buff => fnd_message.get);
2337: ROLLBACK;

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

2332: ,name => 'OKI_TABLE_LOAD_FAILURE');
2333: fnd_message.set_token(token => 'TABLE_NAME'
2334: ,value => 'OKI_DAILY_RATES');
2335: fnd_file.put_line(which => fnd_file.log
2336: ,buff => fnd_message.get);
2337: ROLLBACK;
2338: END refresh_daily_rates;
2339:
2340: ---------------------------------------------------------------------

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

2777:
2778:
2779: l_errpos := 10;
2780:
2781: fnd_message.set_name(application => 'OKI'
2782: ,name => 'OKI_TABLE_LOAD_SUCCESS');
2783: fnd_message.set_token(token => 'TABLE_NAME'
2784: ,value => 'OKI_SALES_K_HDRS');
2785: fnd_file.put_line(which => fnd_file.log

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

2779: l_errpos := 10;
2780:
2781: fnd_message.set_name(application => 'OKI'
2782: ,name => 'OKI_TABLE_LOAD_SUCCESS');
2783: fnd_message.set_token(token => 'TABLE_NAME'
2784: ,value => 'OKI_SALES_K_HDRS');
2785: fnd_file.put_line(which => fnd_file.log
2786: ,buff => fnd_message.get);
2787: l_errpos := 11;

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

2782: ,name => 'OKI_TABLE_LOAD_SUCCESS');
2783: fnd_message.set_token(token => 'TABLE_NAME'
2784: ,value => 'OKI_SALES_K_HDRS');
2785: fnd_file.put_line(which => fnd_file.log
2786: ,buff => fnd_message.get);
2787: l_errpos := 11;
2788:
2789: EXCEPTION
2790: when l_no_update_refresh then

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

2787: l_errpos := 11;
2788:
2789: EXCEPTION
2790: when l_no_update_refresh then
2791: fnd_message.set_name(application => 'OKI'
2792: ,name => 'OKI_TABLE_LOAD_FAILURE');
2793: fnd_message.set_token(token => 'TABLE_NAME'
2794: ,value => 'OKI_SALES_K_HDRS');
2795: fnd_file.put_line(which => fnd_file.log

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

2789: EXCEPTION
2790: when l_no_update_refresh then
2791: fnd_message.set_name(application => 'OKI'
2792: ,name => 'OKI_TABLE_LOAD_FAILURE');
2793: fnd_message.set_token(token => 'TABLE_NAME'
2794: ,value => 'OKI_SALES_K_HDRS');
2795: fnd_file.put_line(which => fnd_file.log
2796: ,buff => fnd_message.get);
2797:

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

2792: ,name => 'OKI_TABLE_LOAD_FAILURE');
2793: fnd_message.set_token(token => 'TABLE_NAME'
2794: ,value => 'OKI_SALES_K_HDRS');
2795: fnd_file.put_line(which => fnd_file.log
2796: ,buff => fnd_message.get);
2797:
2798: fnd_file.put_line(which => fnd_file.log
2799: ,buff => 'Update of OKI_REFRESHS failed');
2800: WHEN OTHERS THEN

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

2801: l_sqlcode := sqlcode;
2802: l_sqlerrm := sqlerrm;
2803: ROLLBACK;
2804: retcode := '2';
2805: fnd_message.set_name( application => 'OKI'
2806: , name => 'OKI_TABLE_LOAD_FAILURE');
2807: fnd_message.set_token( token => 'TABLE_NAME'
2808: , value => 'OKI_SALES_K_HDRS');
2809: fnd_file.put_line( which => fnd_file.log

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

2803: ROLLBACK;
2804: retcode := '2';
2805: fnd_message.set_name( application => 'OKI'
2806: , name => 'OKI_TABLE_LOAD_FAILURE');
2807: fnd_message.set_token( token => 'TABLE_NAME'
2808: , value => 'OKI_SALES_K_HDRS');
2809: fnd_file.put_line( which => fnd_file.log
2810: , buff => fnd_message.get);
2811: fnd_file.put_line( which => fnd_file.log

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

2806: , name => 'OKI_TABLE_LOAD_FAILURE');
2807: fnd_message.set_token( token => 'TABLE_NAME'
2808: , value => 'OKI_SALES_K_HDRS');
2809: fnd_file.put_line( which => fnd_file.log
2810: , buff => fnd_message.get);
2811: fnd_file.put_line( which => fnd_file.log
2812: , buff => l_sqlcode || ' ' || l_sqlerrm);
2813: -- try to get indexes back
2814: IF l_errpos < 6 THEN

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

3238: fnd_stats.gather_table_stats( ownname => 'OKI'
3239: , tabname => l_table_name
3240: , percent => 10 ) ;
3241:
3242: fnd_message.set_name( application => 'OKI'
3243: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
3244: fnd_message.set_token( token => 'TABLE_NAME'
3245: , value => l_table_name ) ;
3246: fnd_file.put_line( which => fnd_file.log

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

3240: , percent => 10 ) ;
3241:
3242: fnd_message.set_name( application => 'OKI'
3243: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
3244: fnd_message.set_token( token => 'TABLE_NAME'
3245: , value => l_table_name ) ;
3246: fnd_file.put_line( which => fnd_file.log
3247: , buff => fnd_message.get ) ;
3248:

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

3243: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
3244: fnd_message.set_token( token => 'TABLE_NAME'
3245: , value => l_table_name ) ;
3246: fnd_file.put_line( which => fnd_file.log
3247: , buff => fnd_message.get ) ;
3248:
3249: EXCEPTION
3250: WHEN l_excp_no_processing then
3251: -- Do not log an error ; It has already been logged.

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

3257: -- Set return code to error
3258: x_retcode := '2' ;
3259:
3260: WHEN l_no_update_refresh then
3261: fnd_message.set_name(application => 'OKI'
3262: ,name => 'OKI_TABLE_LOAD_FAILURE');
3263: fnd_message.set_token(token => 'TABLE_NAME'
3264: ,value => 'OKI_SALES_K_HDRS');
3265: fnd_file.put_line(which => fnd_file.log

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

3259:
3260: WHEN l_no_update_refresh then
3261: fnd_message.set_name(application => 'OKI'
3262: ,name => 'OKI_TABLE_LOAD_FAILURE');
3263: fnd_message.set_token(token => 'TABLE_NAME'
3264: ,value => 'OKI_SALES_K_HDRS');
3265: fnd_file.put_line(which => fnd_file.log
3266: ,buff => fnd_message.get);
3267:

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

3262: ,name => 'OKI_TABLE_LOAD_FAILURE');
3263: fnd_message.set_token(token => 'TABLE_NAME'
3264: ,value => 'OKI_SALES_K_HDRS');
3265: fnd_file.put_line(which => fnd_file.log
3266: ,buff => fnd_message.get);
3267:
3268: fnd_file.put_line(which => fnd_file.log
3269: ,buff => 'Update of OKI_REFRESHS failed');
3270: WHEN OTHERS THEN

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

3272: l_sqlerrm := sqlerrm;
3273: ROLLBACK;
3274: x_retcode := '2';
3275:
3276: fnd_message.set_name( application => 'OKI'
3277: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3278: fnd_message.set_token( token => 'TABLE_NAME'
3279: , value => 'OKI_SALES_K_HDRS' ) ;
3280: fnd_file.put_line( which => fnd_file.log

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

3274: x_retcode := '2';
3275:
3276: fnd_message.set_name( application => 'OKI'
3277: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3278: fnd_message.set_token( token => 'TABLE_NAME'
3279: , value => 'OKI_SALES_K_HDRS' ) ;
3280: fnd_file.put_line( which => fnd_file.log
3281: , buff => fnd_message.get ) ;
3282:

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

3277: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3278: fnd_message.set_token( token => 'TABLE_NAME'
3279: , value => 'OKI_SALES_K_HDRS' ) ;
3280: fnd_file.put_line( which => fnd_file.log
3281: , buff => fnd_message.get ) ;
3282:
3283: -- Log the location within the procedure where the error occurred
3284: fnd_message.set_name( application => 'OKI'
3285: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

3280: fnd_file.put_line( which => fnd_file.log
3281: , buff => fnd_message.get ) ;
3282:
3283: -- Log the location within the procedure where the error occurred
3284: fnd_message.set_name( application => 'OKI'
3285: , name => 'OKI_LOC_IN_PROG_FAILURE');
3286: fnd_message.set_token( token => 'LOCATION'
3287: , value => l_loc ) ;
3288: fnd_file.put_line( which => fnd_file.log

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

3282:
3283: -- Log the location within the procedure where the error occurred
3284: fnd_message.set_name( application => 'OKI'
3285: , name => 'OKI_LOC_IN_PROG_FAILURE');
3286: fnd_message.set_token( token => 'LOCATION'
3287: , value => l_loc ) ;
3288: fnd_file.put_line( which => fnd_file.log
3289: , buff => fnd_message.get ) ;
3290:

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

3285: , name => 'OKI_LOC_IN_PROG_FAILURE');
3286: fnd_message.set_token( token => 'LOCATION'
3287: , value => l_loc ) ;
3288: fnd_file.put_line( which => fnd_file.log
3289: , buff => fnd_message.get ) ;
3290:
3291: fnd_file.put_line( which => fnd_file.log
3292: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
3293: END fast_sales_k_hdrs ;

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

3566: fnd_stats.gather_table_stats(ownname => 'OKI'
3567: ,tabname => 'OKI_SOLD_ITM_LINES',percent=> 10);
3568: l_errpos := 9;
3569:
3570: fnd_message.set_name(application => 'OKI'
3571: ,name => 'OKI_TABLE_LOAD_SUCCESS');
3572: fnd_message.set_token(token => 'TABLE_NAME'
3573: ,value => 'OKI_SOLD_ITM_LINES');
3574: fnd_file.put_line(which => fnd_file.log

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

3568: l_errpos := 9;
3569:
3570: fnd_message.set_name(application => 'OKI'
3571: ,name => 'OKI_TABLE_LOAD_SUCCESS');
3572: fnd_message.set_token(token => 'TABLE_NAME'
3573: ,value => 'OKI_SOLD_ITM_LINES');
3574: fnd_file.put_line(which => fnd_file.log
3575: ,buff => fnd_message.get);
3576:

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

3571: ,name => 'OKI_TABLE_LOAD_SUCCESS');
3572: fnd_message.set_token(token => 'TABLE_NAME'
3573: ,value => 'OKI_SOLD_ITM_LINES');
3574: fnd_file.put_line(which => fnd_file.log
3575: ,buff => fnd_message.get);
3576:
3577: EXCEPTION
3578: WHEN l_excp_no_job_run_id THEN
3579: ROLLBACK;

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

3577: EXCEPTION
3578: WHEN l_excp_no_job_run_id THEN
3579: ROLLBACK;
3580: retcode := '2';
3581: fnd_message.set_name( application => 'OKI'
3582: , name => 'OKI_TABLE_LOAD_FAILURE');
3583: fnd_message.set_token( token => 'TABLE_NAME'
3584: , value => 'OKI_SOLD_ITM_LINES');
3585: fnd_file.put_line( which => fnd_file.log

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

3579: ROLLBACK;
3580: retcode := '2';
3581: fnd_message.set_name( application => 'OKI'
3582: , name => 'OKI_TABLE_LOAD_FAILURE');
3583: fnd_message.set_token( token => 'TABLE_NAME'
3584: , value => 'OKI_SOLD_ITM_LINES');
3585: fnd_file.put_line( which => fnd_file.log
3586: , buff => fnd_message.get);
3587:

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

3582: , name => 'OKI_TABLE_LOAD_FAILURE');
3583: fnd_message.set_token( token => 'TABLE_NAME'
3584: , value => 'OKI_SOLD_ITM_LINES');
3585: fnd_file.put_line( which => fnd_file.log
3586: , buff => fnd_message.get);
3587:
3588: fnd_message.set_name( application => 'OKI'
3589: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
3590: fnd_file.put_line( which => fnd_file.log

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

3584: , value => 'OKI_SOLD_ITM_LINES');
3585: fnd_file.put_line( which => fnd_file.log
3586: , buff => fnd_message.get);
3587:
3588: fnd_message.set_name( application => 'OKI'
3589: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
3590: fnd_file.put_line( which => fnd_file.log
3591: , buff => fnd_message.get);
3592:

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

3587:
3588: fnd_message.set_name( application => 'OKI'
3589: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
3590: fnd_file.put_line( which => fnd_file.log
3591: , buff => fnd_message.get);
3592:
3593: WHEN l_no_update_refresh then
3594: fnd_message.set_name(application => 'OKI'
3595: ,name => 'OKI_TABLE_LOAD_FAILURE');

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

3590: fnd_file.put_line( which => fnd_file.log
3591: , buff => fnd_message.get);
3592:
3593: WHEN l_no_update_refresh then
3594: fnd_message.set_name(application => 'OKI'
3595: ,name => 'OKI_TABLE_LOAD_FAILURE');
3596: fnd_message.set_token(token => 'TABLE_NAME'
3597: ,value => 'OKI_SOLD_ITM_LINES');
3598: fnd_file.put_line(which => fnd_file.log

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

3592:
3593: WHEN l_no_update_refresh then
3594: fnd_message.set_name(application => 'OKI'
3595: ,name => 'OKI_TABLE_LOAD_FAILURE');
3596: fnd_message.set_token(token => 'TABLE_NAME'
3597: ,value => 'OKI_SOLD_ITM_LINES');
3598: fnd_file.put_line(which => fnd_file.log
3599: ,buff => fnd_message.get);
3600:

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

3595: ,name => 'OKI_TABLE_LOAD_FAILURE');
3596: fnd_message.set_token(token => 'TABLE_NAME'
3597: ,value => 'OKI_SOLD_ITM_LINES');
3598: fnd_file.put_line(which => fnd_file.log
3599: ,buff => fnd_message.get);
3600:
3601: fnd_file.put_line(which => fnd_file.log
3602: ,buff => 'Update of OKI_REFRESHS failed');
3603: WHEN OTHERS THEN

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

3604: l_sqlcode := sqlcode;
3605: l_sqlerrm := sqlerrm;
3606: ROLLBACK;
3607: retcode := '2';
3608: fnd_message.set_name( application => 'OKI'
3609: , name => 'OKI_TABLE_LOAD_FAILURE');
3610: fnd_message.set_token( token => 'TABLE_NAME'
3611: , value => 'OKI_SOLD_ITM_LINES');
3612: fnd_file.put_line( which => fnd_file.log

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

3606: ROLLBACK;
3607: retcode := '2';
3608: fnd_message.set_name( application => 'OKI'
3609: , name => 'OKI_TABLE_LOAD_FAILURE');
3610: fnd_message.set_token( token => 'TABLE_NAME'
3611: , value => 'OKI_SOLD_ITM_LINES');
3612: fnd_file.put_line( which => fnd_file.log
3613: , buff => fnd_message.get);
3614: fnd_file.put_line( which => fnd_file.log

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

3609: , name => 'OKI_TABLE_LOAD_FAILURE');
3610: fnd_message.set_token( token => 'TABLE_NAME'
3611: , value => 'OKI_SOLD_ITM_LINES');
3612: fnd_file.put_line( which => fnd_file.log
3613: , buff => fnd_message.get);
3614: fnd_file.put_line( which => fnd_file.log
3615: , buff => l_sqlcode||' '||l_sqlerrm);
3616: IF l_errpos < 5 THEN
3617: create_indicies(p_object_name => 'OKI_SOLD_ITM_LINES'

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

3844: fnd_stats.gather_table_stats( ownname => 'OKI'
3845: , tabname => l_table_name
3846: , percent => 10 ) ;
3847:
3848: fnd_message.set_name( application => 'OKI'
3849: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
3850: fnd_message.set_token( token => 'TABLE_NAME'
3851: , value => l_table_name ) ;
3852: fnd_file.put_line( which => fnd_file.log

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

3846: , percent => 10 ) ;
3847:
3848: fnd_message.set_name( application => 'OKI'
3849: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
3850: fnd_message.set_token( token => 'TABLE_NAME'
3851: , value => l_table_name ) ;
3852: fnd_file.put_line( which => fnd_file.log
3853: , buff => fnd_message.get ) ;
3854:

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

3849: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
3850: fnd_message.set_token( token => 'TABLE_NAME'
3851: , value => l_table_name ) ;
3852: fnd_file.put_line( which => fnd_file.log
3853: , buff => fnd_message.get ) ;
3854:
3855: EXCEPTION
3856: WHEN l_excp_no_processing then
3857: -- Do not log an error ; It has already been logged.

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

3863: -- Set return code to error
3864: x_retcode := '2' ;
3865:
3866: when l_no_update_refresh then
3867: fnd_message.set_name(application => 'OKI'
3868: ,name => 'OKI_TABLE_LOAD_FAILURE');
3869: fnd_message.set_token(token => 'TABLE_NAME'
3870: ,value => 'OKI_SOLD_ITM_LINES');
3871: fnd_file.put_line(which => fnd_file.log

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

3865:
3866: when l_no_update_refresh then
3867: fnd_message.set_name(application => 'OKI'
3868: ,name => 'OKI_TABLE_LOAD_FAILURE');
3869: fnd_message.set_token(token => 'TABLE_NAME'
3870: ,value => 'OKI_SOLD_ITM_LINES');
3871: fnd_file.put_line(which => fnd_file.log
3872: ,buff => fnd_message.get);
3873:

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

3868: ,name => 'OKI_TABLE_LOAD_FAILURE');
3869: fnd_message.set_token(token => 'TABLE_NAME'
3870: ,value => 'OKI_SOLD_ITM_LINES');
3871: fnd_file.put_line(which => fnd_file.log
3872: ,buff => fnd_message.get);
3873:
3874: fnd_file.put_line(which => fnd_file.log
3875: ,buff => 'Update of OKI_REFRESHS failed');
3876: WHEN OTHERS THEN

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

3877: l_sqlcode := sqlcode;
3878: l_sqlerrm := sqlerrm;
3879: ROLLBACK;
3880: x_retcode := '2';
3881: fnd_message.set_name( application => 'OKI'
3882: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3883: fnd_message.set_token( token => 'TABLE_NAME'
3884: , value => l_table_name ) ;
3885: fnd_file.put_line( which => fnd_file.log

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

3879: ROLLBACK;
3880: x_retcode := '2';
3881: fnd_message.set_name( application => 'OKI'
3882: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3883: fnd_message.set_token( token => 'TABLE_NAME'
3884: , value => l_table_name ) ;
3885: fnd_file.put_line( which => fnd_file.log
3886: , buff => fnd_message.get ) ;
3887: fnd_file.put_line( which => fnd_file.log

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

3882: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3883: fnd_message.set_token( token => 'TABLE_NAME'
3884: , value => l_table_name ) ;
3885: fnd_file.put_line( which => fnd_file.log
3886: , buff => fnd_message.get ) ;
3887: fnd_file.put_line( which => fnd_file.log
3888: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
3889: END fast_sold_itm_lines ;
3890:

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

4204: fnd_stats.gather_table_stats(ownname => 'OKI'
4205: ,tabname => 'OKI_COV_PRD_LINES',percent=> 10);
4206: l_errpos := 9;
4207:
4208: fnd_message.set_name(application => 'OKI'
4209: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4210: fnd_message.set_token(token => 'TABLE_NAME'
4211: ,value => 'OKI_COV_PRD_LINES');
4212: fnd_file.put_line(which => fnd_file.log

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

4206: l_errpos := 9;
4207:
4208: fnd_message.set_name(application => 'OKI'
4209: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4210: fnd_message.set_token(token => 'TABLE_NAME'
4211: ,value => 'OKI_COV_PRD_LINES');
4212: fnd_file.put_line(which => fnd_file.log
4213: ,buff => fnd_message.get);
4214:

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

4209: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4210: fnd_message.set_token(token => 'TABLE_NAME'
4211: ,value => 'OKI_COV_PRD_LINES');
4212: fnd_file.put_line(which => fnd_file.log
4213: ,buff => fnd_message.get);
4214:
4215: EXCEPTION
4216: WHEN l_no_update_refresh THEN
4217: fnd_message.set_name( application => 'OKI'

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

4213: ,buff => fnd_message.get);
4214:
4215: EXCEPTION
4216: WHEN l_no_update_refresh THEN
4217: fnd_message.set_name( application => 'OKI'
4218: , name => 'OKI_TABLE_LOAD_FAILURE');
4219: fnd_message.set_token( token => 'TABLE_NAME'
4220: , value => 'OKI_COV_PRD_LINES');
4221: fnd_file.put_line( which => fnd_file.log

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

4215: EXCEPTION
4216: WHEN l_no_update_refresh THEN
4217: fnd_message.set_name( application => 'OKI'
4218: , name => 'OKI_TABLE_LOAD_FAILURE');
4219: fnd_message.set_token( token => 'TABLE_NAME'
4220: , value => 'OKI_COV_PRD_LINES');
4221: fnd_file.put_line( which => fnd_file.log
4222: , buff => fnd_message.get);
4223: fnd_file.put_line( which => fnd_file.log

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

4218: , name => 'OKI_TABLE_LOAD_FAILURE');
4219: fnd_message.set_token( token => 'TABLE_NAME'
4220: , value => 'OKI_COV_PRD_LINES');
4221: fnd_file.put_line( which => fnd_file.log
4222: , buff => fnd_message.get);
4223: fnd_file.put_line( which => fnd_file.log
4224: , buff =>'Update of OKI_REFRESHS failed' );
4225:
4226: WHEN l_excp_no_job_run_id THEN

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

4226: WHEN l_excp_no_job_run_id THEN
4227: ROLLBACK;
4228: retcode := '2';
4229:
4230: fnd_message.set_name( application => 'OKI'
4231: , name => 'OKI_TABLE_LOAD_FAILURE');
4232: fnd_message.set_token( token => 'TABLE_NAME'
4233: , value => 'OKI_COV_PRD_LINES');
4234: fnd_file.put_line( which => fnd_file.log

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

4228: retcode := '2';
4229:
4230: fnd_message.set_name( application => 'OKI'
4231: , name => 'OKI_TABLE_LOAD_FAILURE');
4232: fnd_message.set_token( token => 'TABLE_NAME'
4233: , value => 'OKI_COV_PRD_LINES');
4234: fnd_file.put_line( which => fnd_file.log
4235: , buff => fnd_message.get);
4236:

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

4231: , name => 'OKI_TABLE_LOAD_FAILURE');
4232: fnd_message.set_token( token => 'TABLE_NAME'
4233: , value => 'OKI_COV_PRD_LINES');
4234: fnd_file.put_line( which => fnd_file.log
4235: , buff => fnd_message.get);
4236:
4237: fnd_message.set_name( application => 'OKI'
4238: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
4239: fnd_file.put_line( which => fnd_file.log

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

4233: , value => 'OKI_COV_PRD_LINES');
4234: fnd_file.put_line( which => fnd_file.log
4235: , buff => fnd_message.get);
4236:
4237: fnd_message.set_name( application => 'OKI'
4238: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
4239: fnd_file.put_line( which => fnd_file.log
4240: , buff => fnd_message.get);
4241: WHEN OTHERS THEN

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

4236:
4237: fnd_message.set_name( application => 'OKI'
4238: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
4239: fnd_file.put_line( which => fnd_file.log
4240: , buff => fnd_message.get);
4241: WHEN OTHERS THEN
4242: l_sqlcode := sqlcode;
4243: l_sqlerrm := sqlerrm;
4244: ROLLBACK;

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

4243: l_sqlerrm := sqlerrm;
4244: ROLLBACK;
4245: retcode := '2';
4246:
4247: fnd_message.set_name( application => 'OKI'
4248: , name => 'OKI_TABLE_LOAD_FAILURE');
4249: fnd_message.set_token( token => 'TABLE_NAME'
4250: , value => 'OKI_COV_PRD_LINES');
4251: fnd_file.put_line( which => fnd_file.log

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

4245: retcode := '2';
4246:
4247: fnd_message.set_name( application => 'OKI'
4248: , name => 'OKI_TABLE_LOAD_FAILURE');
4249: fnd_message.set_token( token => 'TABLE_NAME'
4250: , value => 'OKI_COV_PRD_LINES');
4251: fnd_file.put_line( which => fnd_file.log
4252: , buff => fnd_message.get);
4253: fnd_file.put_line( which => fnd_file.log

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

4248: , name => 'OKI_TABLE_LOAD_FAILURE');
4249: fnd_message.set_token( token => 'TABLE_NAME'
4250: , value => 'OKI_COV_PRD_LINES');
4251: fnd_file.put_line( which => fnd_file.log
4252: , buff => fnd_message.get);
4253: fnd_file.put_line( which => fnd_file.log
4254: , buff => l_sqlcode||' '||l_sqlerrm);
4255: IF l_errpos < 5 THEN
4256: create_indicies( p_object_name => 'OKI_COV_PRD_LINES'

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

4579: fnd_stats.gather_table_stats( ownname => 'OKI'
4580: , tabname => l_table_name
4581: , percent => 10 ) ;
4582:
4583: fnd_message.set_name( application => 'OKI'
4584: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
4585: fnd_message.set_token( token => 'TABLE_NAME'
4586: , value => l_table_name ) ;
4587: fnd_file.put_line( which => fnd_file.log

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

4581: , percent => 10 ) ;
4582:
4583: fnd_message.set_name( application => 'OKI'
4584: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
4585: fnd_message.set_token( token => 'TABLE_NAME'
4586: , value => l_table_name ) ;
4587: fnd_file.put_line( which => fnd_file.log
4588: , buff => fnd_message.get ) ;
4589:

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

4584: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
4585: fnd_message.set_token( token => 'TABLE_NAME'
4586: , value => l_table_name ) ;
4587: fnd_file.put_line( which => fnd_file.log
4588: , buff => fnd_message.get ) ;
4589:
4590: EXCEPTION
4591: WHEN l_excp_no_processing then
4592: -- Do not log an error ; It has already been logged.

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

4598: -- Set return code to error
4599: x_retcode := '2' ;
4600:
4601: when l_no_update_refresh then
4602: fnd_message.set_name(application => 'OKI'
4603: ,name => 'OKI_TABLE_LOAD_FAILURE');
4604: fnd_message.set_token(token => 'TABLE_NAME'
4605: ,value => 'OKI_COV_PRD_LINES');
4606: fnd_file.put_line(which => fnd_file.log

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

4600:
4601: when l_no_update_refresh then
4602: fnd_message.set_name(application => 'OKI'
4603: ,name => 'OKI_TABLE_LOAD_FAILURE');
4604: fnd_message.set_token(token => 'TABLE_NAME'
4605: ,value => 'OKI_COV_PRD_LINES');
4606: fnd_file.put_line(which => fnd_file.log
4607: ,buff => fnd_message.get);
4608:

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

4603: ,name => 'OKI_TABLE_LOAD_FAILURE');
4604: fnd_message.set_token(token => 'TABLE_NAME'
4605: ,value => 'OKI_COV_PRD_LINES');
4606: fnd_file.put_line(which => fnd_file.log
4607: ,buff => fnd_message.get);
4608:
4609: fnd_file.put_line(which => fnd_file.log
4610: ,buff => 'Update of OKI_REFRESHS failed');
4611:

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

4613: l_sqlcode := sqlcode;
4614: l_sqlerrm := sqlerrm;
4615: ROLLBACK;
4616: x_retcode := '2';
4617: fnd_message.set_name( application => 'OKI'
4618: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
4619: fnd_message.set_token( token => 'TABLE_NAME'
4620: , value => l_table_name ) ;
4621: fnd_file.put_line( which => fnd_file.log

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

4615: ROLLBACK;
4616: x_retcode := '2';
4617: fnd_message.set_name( application => 'OKI'
4618: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
4619: fnd_message.set_token( token => 'TABLE_NAME'
4620: , value => l_table_name ) ;
4621: fnd_file.put_line( which => fnd_file.log
4622: , buff => fnd_message.get ) ;
4623: fnd_file.put_line( which => fnd_file.log

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

4618: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
4619: fnd_message.set_token( token => 'TABLE_NAME'
4620: , value => l_table_name ) ;
4621: fnd_file.put_line( which => fnd_file.log
4622: , buff => fnd_message.get ) ;
4623: fnd_file.put_line( which => fnd_file.log
4624: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
4625: END fast_cov_prd_lines ;
4626: ---------------------------------------------------------------------

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

4828: -- analyze table
4829: fnd_stats.gather_table_stats(ownname => 'OKI'
4830: ,tabname => 'OKI_K_SALESREPS',percent=> 10);
4831:
4832: fnd_message.set_name(application => 'OKI'
4833: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4834: fnd_message.set_token(token => 'TABLE_NAME'
4835: ,value => 'OKI_K_SALESREPS');
4836: fnd_file.put_line(which => fnd_file.log

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

4830: ,tabname => 'OKI_K_SALESREPS',percent=> 10);
4831:
4832: fnd_message.set_name(application => 'OKI'
4833: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4834: fnd_message.set_token(token => 'TABLE_NAME'
4835: ,value => 'OKI_K_SALESREPS');
4836: fnd_file.put_line(which => fnd_file.log
4837: ,buff => fnd_message.get);
4838:

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

4833: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4834: fnd_message.set_token(token => 'TABLE_NAME'
4835: ,value => 'OKI_K_SALESREPS');
4836: fnd_file.put_line(which => fnd_file.log
4837: ,buff => fnd_message.get);
4838:
4839: EXCEPTION
4840: WHEN l_excp_no_job_run_id THEN
4841: ROLLBACK;

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

4840: WHEN l_excp_no_job_run_id THEN
4841: ROLLBACK;
4842: retcode := '2';
4843:
4844: fnd_message.set_name( application => 'OKI'
4845: , name => 'OKI_TABLE_LOAD_FAILURE');
4846: fnd_message.set_token( token => 'TABLE_NAME'
4847: , value => 'OKI_K_SALESREPS');
4848: fnd_file.put_line( which => fnd_file.log

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

4842: retcode := '2';
4843:
4844: fnd_message.set_name( application => 'OKI'
4845: , name => 'OKI_TABLE_LOAD_FAILURE');
4846: fnd_message.set_token( token => 'TABLE_NAME'
4847: , value => 'OKI_K_SALESREPS');
4848: fnd_file.put_line( which => fnd_file.log
4849: , buff => fnd_message.get);
4850:

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

4845: , name => 'OKI_TABLE_LOAD_FAILURE');
4846: fnd_message.set_token( token => 'TABLE_NAME'
4847: , value => 'OKI_K_SALESREPS');
4848: fnd_file.put_line( which => fnd_file.log
4849: , buff => fnd_message.get);
4850:
4851: fnd_message.set_name( application => 'OKI'
4852: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
4853: fnd_file.put_line( which => fnd_file.log

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

4847: , value => 'OKI_K_SALESREPS');
4848: fnd_file.put_line( which => fnd_file.log
4849: , buff => fnd_message.get);
4850:
4851: fnd_message.set_name( application => 'OKI'
4852: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
4853: fnd_file.put_line( which => fnd_file.log
4854: , buff => fnd_message.get);
4855:

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

4850:
4851: fnd_message.set_name( application => 'OKI'
4852: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
4853: fnd_file.put_line( which => fnd_file.log
4854: , buff => fnd_message.get);
4855:
4856: when l_no_update_refresh then
4857: fnd_message.set_name(application => 'OKI'
4858: ,name => 'OKI_TABLE_LOAD_FAILURE');

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

4853: fnd_file.put_line( which => fnd_file.log
4854: , buff => fnd_message.get);
4855:
4856: when l_no_update_refresh then
4857: fnd_message.set_name(application => 'OKI'
4858: ,name => 'OKI_TABLE_LOAD_FAILURE');
4859: fnd_message.set_token(token => 'TABLE_NAME'
4860: ,value => 'OKI_K_SALESREPS');
4861: fnd_file.put_line(which => fnd_file.log

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

4855:
4856: when l_no_update_refresh then
4857: fnd_message.set_name(application => 'OKI'
4858: ,name => 'OKI_TABLE_LOAD_FAILURE');
4859: fnd_message.set_token(token => 'TABLE_NAME'
4860: ,value => 'OKI_K_SALESREPS');
4861: fnd_file.put_line(which => fnd_file.log
4862: ,buff => fnd_message.get);
4863:

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

4858: ,name => 'OKI_TABLE_LOAD_FAILURE');
4859: fnd_message.set_token(token => 'TABLE_NAME'
4860: ,value => 'OKI_K_SALESREPS');
4861: fnd_file.put_line(which => fnd_file.log
4862: ,buff => fnd_message.get);
4863:
4864: fnd_file.put_line(which => fnd_file.log
4865: ,buff => 'Update of OKI_REFRESHS failed');
4866: WHEN OTHERS THEN

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

4867: l_sqlcode := sqlcode;
4868: l_sqlerrm := sqlerrm;
4869: ROLLBACK;
4870: retcode := '2';
4871: fnd_message.set_name( application => 'OKI'
4872: , name => 'OKI_TABLE_LOAD_FAILURE');
4873: fnd_message.set_token( token => 'TABLE_NAME'
4874: , value => 'OKI_K_SALESREPS');
4875: fnd_file.put_line( which => fnd_file.log

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

4869: ROLLBACK;
4870: retcode := '2';
4871: fnd_message.set_name( application => 'OKI'
4872: , name => 'OKI_TABLE_LOAD_FAILURE');
4873: fnd_message.set_token( token => 'TABLE_NAME'
4874: , value => 'OKI_K_SALESREPS');
4875: fnd_file.put_line( which => fnd_file.log
4876: , buff => fnd_message.get);
4877: fnd_file.put_line( which => fnd_file.log

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

4872: , name => 'OKI_TABLE_LOAD_FAILURE');
4873: fnd_message.set_token( token => 'TABLE_NAME'
4874: , value => 'OKI_K_SALESREPS');
4875: fnd_file.put_line( which => fnd_file.log
4876: , buff => fnd_message.get);
4877: fnd_file.put_line( which => fnd_file.log
4878: , buff => l_sqlcode||' '||l_sqlerrm);
4879: IF l_errpos < 6 THEN
4880: create_indicies( p_object_name => 'OKI_K_SALESREPS'

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

5043: fnd_stats.gather_table_stats( ownname => 'OKI'
5044: , tabname => l_table_name
5045: , percent => 10 ) ;
5046:
5047: fnd_message.set_name( application => 'OKI'
5048: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
5049: fnd_message.set_token( token => 'TABLE_NAME'
5050: , value => l_table_name ) ;
5051: fnd_file.put_line( which => fnd_file.log

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

5045: , percent => 10 ) ;
5046:
5047: fnd_message.set_name( application => 'OKI'
5048: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
5049: fnd_message.set_token( token => 'TABLE_NAME'
5050: , value => l_table_name ) ;
5051: fnd_file.put_line( which => fnd_file.log
5052: , buff => fnd_message.get ) ;
5053:

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

5048: , name => 'OKI_TABLE_LOAD_SUCCESS' ) ;
5049: fnd_message.set_token( token => 'TABLE_NAME'
5050: , value => l_table_name ) ;
5051: fnd_file.put_line( which => fnd_file.log
5052: , buff => fnd_message.get ) ;
5053:
5054: EXCEPTION
5055: WHEN l_excp_no_processing then
5056: -- Do not log an error ; It has already been logged.

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

5057: -- Just exit the program and continue with the other table load
5058: null ;
5059:
5060: when l_no_update_refresh then
5061: fnd_message.set_name(application => 'OKI'
5062: ,name => 'OKI_TABLE_LOAD_FAILURE');
5063: fnd_message.set_token(token => 'TABLE_NAME'
5064: ,value => l_table_name);
5065: fnd_file.put_line(which => fnd_file.log

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

5059:
5060: when l_no_update_refresh then
5061: fnd_message.set_name(application => 'OKI'
5062: ,name => 'OKI_TABLE_LOAD_FAILURE');
5063: fnd_message.set_token(token => 'TABLE_NAME'
5064: ,value => l_table_name);
5065: fnd_file.put_line(which => fnd_file.log
5066: ,buff => fnd_message.get);
5067:

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

5062: ,name => 'OKI_TABLE_LOAD_FAILURE');
5063: fnd_message.set_token(token => 'TABLE_NAME'
5064: ,value => l_table_name);
5065: fnd_file.put_line(which => fnd_file.log
5066: ,buff => fnd_message.get);
5067:
5068: fnd_file.put_line(which => fnd_file.log
5069: ,buff => 'Update of OKI_REFRESHS failed');
5070: WHEN l_excp_exit_immediate THEN

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

5076: l_sqlcode := sqlcode;
5077: l_sqlerrm := sqlerrm;
5078: ROLLBACK;
5079: x_retcode := '2';
5080: fnd_message.set_name( application => 'OKI'
5081: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
5082: fnd_message.set_token( token => 'TABLE_NAME'
5083: , value => l_table_name ) ;
5084: fnd_file.put_line( which => fnd_file.log

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

5078: ROLLBACK;
5079: x_retcode := '2';
5080: fnd_message.set_name( application => 'OKI'
5081: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
5082: fnd_message.set_token( token => 'TABLE_NAME'
5083: , value => l_table_name ) ;
5084: fnd_file.put_line( which => fnd_file.log
5085: , buff => fnd_message.get ) ;
5086: fnd_file.put_line( which => fnd_file.log

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

5081: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
5082: fnd_message.set_token( token => 'TABLE_NAME'
5083: , value => l_table_name ) ;
5084: fnd_file.put_line( which => fnd_file.log
5085: , buff => fnd_message.get ) ;
5086: fnd_file.put_line( which => fnd_file.log
5087: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
5088: END fast_k_salesreps ;
5089: /*********11510 changes stub out the procedure *********/

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

5187: if x_retcode = 2 then
5188: raise l_no_update_refresh;
5189: end if;
5190:
5191: fnd_message.set_name(application => 'OKI'
5192: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5193: fnd_message.set_token(token => 'TABLE_NAME'
5194: ,value => 'OKI_SOLD_ITM_LINES');
5195: fnd_file.put_line(which => fnd_file.log

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

5189: end if;
5190:
5191: fnd_message.set_name(application => 'OKI'
5192: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5193: fnd_message.set_token(token => 'TABLE_NAME'
5194: ,value => 'OKI_SOLD_ITM_LINES');
5195: fnd_file.put_line(which => fnd_file.log
5196: ,buff => fnd_message.get);
5197:

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

5192: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5193: fnd_message.set_token(token => 'TABLE_NAME'
5194: ,value => 'OKI_SOLD_ITM_LINES');
5195: fnd_file.put_line(which => fnd_file.log
5196: ,buff => fnd_message.get);
5197:
5198: EXCEPTION
5199: WHEN l_excp_no_job_run_id THEN
5200: ROLLBACK;

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

5198: EXCEPTION
5199: WHEN l_excp_no_job_run_id THEN
5200: ROLLBACK;
5201: x_retcode := '2';
5202: fnd_message.set_name( application => 'OKI'
5203: , name => 'OKI_TABLE_LOAD_FAILURE');
5204: fnd_message.set_token( token => 'TABLE_NAME'
5205: , value => 'OKI_SOLD_ITM_LINES');
5206: fnd_file.put_line( which => fnd_file.log

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

5200: ROLLBACK;
5201: x_retcode := '2';
5202: fnd_message.set_name( application => 'OKI'
5203: , name => 'OKI_TABLE_LOAD_FAILURE');
5204: fnd_message.set_token( token => 'TABLE_NAME'
5205: , value => 'OKI_SOLD_ITM_LINES');
5206: fnd_file.put_line( which => fnd_file.log
5207: , buff => fnd_message.get);
5208:

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

5203: , name => 'OKI_TABLE_LOAD_FAILURE');
5204: fnd_message.set_token( token => 'TABLE_NAME'
5205: , value => 'OKI_SOLD_ITM_LINES');
5206: fnd_file.put_line( which => fnd_file.log
5207: , buff => fnd_message.get);
5208:
5209: fnd_message.set_name( application => 'OKI'
5210: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
5211: fnd_file.put_line( which => fnd_file.log

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

5205: , value => 'OKI_SOLD_ITM_LINES');
5206: fnd_file.put_line( which => fnd_file.log
5207: , buff => fnd_message.get);
5208:
5209: fnd_message.set_name( application => 'OKI'
5210: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
5211: fnd_file.put_line( which => fnd_file.log
5212: , buff => fnd_message.get);
5213:

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

5208:
5209: fnd_message.set_name( application => 'OKI'
5210: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');
5211: fnd_file.put_line( which => fnd_file.log
5212: , buff => fnd_message.get);
5213:
5214: when l_no_update_refresh then
5215: fnd_message.set_name(application => 'OKI'
5216: ,name => 'OKI_TABLE_LOAD_FAILURE');

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

5211: fnd_file.put_line( which => fnd_file.log
5212: , buff => fnd_message.get);
5213:
5214: when l_no_update_refresh then
5215: fnd_message.set_name(application => 'OKI'
5216: ,name => 'OKI_TABLE_LOAD_FAILURE');
5217: fnd_message.set_token(token => 'TABLE_NAME'
5218: ,value => 'OKI_SOLD_ITM_LINES');
5219: fnd_file.put_line(which => fnd_file.log

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

5213:
5214: when l_no_update_refresh then
5215: fnd_message.set_name(application => 'OKI'
5216: ,name => 'OKI_TABLE_LOAD_FAILURE');
5217: fnd_message.set_token(token => 'TABLE_NAME'
5218: ,value => 'OKI_SOLD_ITM_LINES');
5219: fnd_file.put_line(which => fnd_file.log
5220: ,buff => fnd_message.get);
5221:

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

5216: ,name => 'OKI_TABLE_LOAD_FAILURE');
5217: fnd_message.set_token(token => 'TABLE_NAME'
5218: ,value => 'OKI_SOLD_ITM_LINES');
5219: fnd_file.put_line(which => fnd_file.log
5220: ,buff => fnd_message.get);
5221:
5222: fnd_file.put_line(which => fnd_file.log
5223: ,buff => 'Update of OKI_REFRESHS failed');
5224: WHEN OTHERS THEN

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

5227: fnd_file.put_line(which => fnd_file.log
5228: ,buff => l_message);
5229: ROLLBACK;
5230: x_retcode := '2';
5231: fnd_message.set_name( application => 'OKI'
5232: , name => 'OKI_TABLE_LOAD_FAILURE');
5233: fnd_message.set_token( token => 'TABLE_NAME'
5234: , value => 'OKI_SOLD_ITM_LINES');
5235: fnd_file.put_line( which => fnd_file.log

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

5229: ROLLBACK;
5230: x_retcode := '2';
5231: fnd_message.set_name( application => 'OKI'
5232: , name => 'OKI_TABLE_LOAD_FAILURE');
5233: fnd_message.set_token( token => 'TABLE_NAME'
5234: , value => 'OKI_SOLD_ITM_LINES');
5235: fnd_file.put_line( which => fnd_file.log
5236: , buff => fnd_message.get);
5237:

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

5232: , name => 'OKI_TABLE_LOAD_FAILURE');
5233: fnd_message.set_token( token => 'TABLE_NAME'
5234: , value => 'OKI_SOLD_ITM_LINES');
5235: fnd_file.put_line( which => fnd_file.log
5236: , buff => fnd_message.get);
5237:
5238: -- Log the location within the procedure where the error occurred
5239: fnd_message.set_name( application => 'OKI'
5240: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

5235: fnd_file.put_line( which => fnd_file.log
5236: , buff => fnd_message.get);
5237:
5238: -- Log the location within the procedure where the error occurred
5239: fnd_message.set_name( application => 'OKI'
5240: , name => 'OKI_LOC_IN_PROG_FAILURE');
5241:
5242: fnd_message.set_token( token => 'LOCATION'
5243: , value => l_loc);

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

5238: -- Log the location within the procedure where the error occurred
5239: fnd_message.set_name( application => 'OKI'
5240: , name => 'OKI_LOC_IN_PROG_FAILURE');
5241:
5242: fnd_message.set_token( token => 'LOCATION'
5243: , value => l_loc);
5244:
5245: fnd_file.put_line( which => fnd_file.log
5246: , buff => fnd_message.get);

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

5242: fnd_message.set_token( token => 'LOCATION'
5243: , value => l_loc);
5244:
5245: fnd_file.put_line( which => fnd_file.log
5246: , buff => fnd_message.get);
5247:
5248: fnd_file.put_line( which => fnd_file.log
5249: , buff => l_sqlcode || ' ' || l_sqlerrm);
5250:

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

5327: raise l_no_update_refresh;
5328: end if;
5329: l_loc := ' Succesfully Updated price negotiated for Service Contracts ';
5330:
5331: fnd_message.set_name(application => 'OKI'
5332: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5333: fnd_message.set_token(token => 'TABLE_NAME'
5334: ,value => 'OKI_SOLD_ITM_LINES');
5335: fnd_file.put_line(which => fnd_file.log

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

5329: l_loc := ' Succesfully Updated price negotiated for Service Contracts ';
5330:
5331: fnd_message.set_name(application => 'OKI'
5332: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5333: fnd_message.set_token(token => 'TABLE_NAME'
5334: ,value => 'OKI_SOLD_ITM_LINES');
5335: fnd_file.put_line(which => fnd_file.log
5336: ,buff => fnd_message.get);
5337:

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

5332: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5333: fnd_message.set_token(token => 'TABLE_NAME'
5334: ,value => 'OKI_SOLD_ITM_LINES');
5335: fnd_file.put_line(which => fnd_file.log
5336: ,buff => fnd_message.get);
5337:
5338: EXCEPTION
5339: WHEN l_excp_no_processing then
5340: -- Do not log an error ; It has already been logged.

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

5340: -- Do not log an error ; It has already been logged.
5341: -- Just exit the program and continue with the other table load
5342: null ;
5343: when l_no_update_refresh then
5344: fnd_message.set_name(application => 'OKI'
5345: ,name => 'OKI_TABLE_LOAD_FAILURE');
5346: fnd_message.set_token(token => 'TABLE_NAME'
5347: ,value => 'OKI_SOLD_ITM_LINES');
5348: fnd_file.put_line(which => fnd_file.log

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

5342: null ;
5343: when l_no_update_refresh then
5344: fnd_message.set_name(application => 'OKI'
5345: ,name => 'OKI_TABLE_LOAD_FAILURE');
5346: fnd_message.set_token(token => 'TABLE_NAME'
5347: ,value => 'OKI_SOLD_ITM_LINES');
5348: fnd_file.put_line(which => fnd_file.log
5349: ,buff => fnd_message.get);
5350:

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

5345: ,name => 'OKI_TABLE_LOAD_FAILURE');
5346: fnd_message.set_token(token => 'TABLE_NAME'
5347: ,value => 'OKI_SOLD_ITM_LINES');
5348: fnd_file.put_line(which => fnd_file.log
5349: ,buff => fnd_message.get);
5350:
5351: fnd_file.put_line(which => fnd_file.log
5352: ,buff => 'Update of OKI_REFRESHS failed');
5353: WHEN l_excp_exit_immediate THEN

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

5361: fnd_file.put_line(which => fnd_file.log
5362: ,buff => l_message);
5363: ROLLBACK;
5364: x_retcode := '2';
5365: fnd_message.set_name( application => 'OKI'
5366: , name => 'OKI_TABLE_LOAD_FAILURE');
5367: fnd_message.set_token( token => 'TABLE_NAME'
5368: , value => 'OKI_SOLD_ITM_LINES');
5369: fnd_file.put_line( which => fnd_file.log

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

5363: ROLLBACK;
5364: x_retcode := '2';
5365: fnd_message.set_name( application => 'OKI'
5366: , name => 'OKI_TABLE_LOAD_FAILURE');
5367: fnd_message.set_token( token => 'TABLE_NAME'
5368: , value => 'OKI_SOLD_ITM_LINES');
5369: fnd_file.put_line( which => fnd_file.log
5370: , buff => fnd_message.get);
5371:

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

5366: , name => 'OKI_TABLE_LOAD_FAILURE');
5367: fnd_message.set_token( token => 'TABLE_NAME'
5368: , value => 'OKI_SOLD_ITM_LINES');
5369: fnd_file.put_line( which => fnd_file.log
5370: , buff => fnd_message.get);
5371:
5372: -- Log the location within the procedure where the error occurred
5373: fnd_message.set_name( application => 'OKI'
5374: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

5369: fnd_file.put_line( which => fnd_file.log
5370: , buff => fnd_message.get);
5371:
5372: -- Log the location within the procedure where the error occurred
5373: fnd_message.set_name( application => 'OKI'
5374: , name => 'OKI_LOC_IN_PROG_FAILURE');
5375:
5376: fnd_message.set_token( token => 'LOCATION'
5377: , value => l_loc);

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

5372: -- Log the location within the procedure where the error occurred
5373: fnd_message.set_name( application => 'OKI'
5374: , name => 'OKI_LOC_IN_PROG_FAILURE');
5375:
5376: fnd_message.set_token( token => 'LOCATION'
5377: , value => l_loc);
5378:
5379: fnd_file.put_line( which => fnd_file.log
5380: , buff => fnd_message.get);

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

5376: fnd_message.set_token( token => 'LOCATION'
5377: , value => l_loc);
5378:
5379: fnd_file.put_line( which => fnd_file.log
5380: , buff => fnd_message.get);
5381:
5382: fnd_file.put_line( which => fnd_file.log
5383: , buff => l_sqlcode || ' ' || l_sqlerrm);
5384: END fast_update_service_line;