[Home] [Help]
1: Package Body OKI_REFRESH_PVT AS
2: /* $Header: OKIRRFHB.pls 115.74 2004/08/13 16:35:16 asparama ship $ */
3:
4: ----
5: --
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:
496: fnd_message.set_name( application => 'OKI'
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:
597: -- Log the location within the procedure where the error occurred
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 ) ;
618:
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 ) ;
672:
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 ) ;
925:
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 ) ;
1000:
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 ) ;
1188:
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:
1662: -- Log the location within the procedure where the error occurred
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 ) ;
1683:
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:
1835: -- Log the location within the procedure where the error occurred
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 ) ;
1856:
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' ) ;
1951:
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:
2039: -- Log the location within the procedure where the error occurred
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 ) ;
2060:
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:
2180: -- Log the location within the procedure where the error occurred
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 ) ;
2201:
2407: EXECUTE IMMEDIATE l_sql_string;
2408: l_errpos := 3;
2409:
2410: /*
2411: oki_refresh_pvt.ins_job_runs (
2412: p_job_start_date => l_sysdate
2413: , p_job_end_date => l_sysdate
2414: , p_job_curr_start_date => l_init_job_run_date
2415: , p_job_curr_end_date => l_sysdate
5395: g_request_id := fnd_global.CONC_REQUEST_ID;
5396: g_program_application_id := fnd_global.PROG_APPL_ID;
5397: g_program_id := fnd_global.CONC_PROGRAM_ID;
5398: g_program_update_date := SYSDATE;
5399: END OKI_REFRESH_PVT ;