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_FILE

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

365: END IF;
366: EXCEPTION
367: WHEN OTHERS
368: THEN
369: fnd_file.put_line( which => fnd_file.log
370: , buff => 'The Following SQL statement failed ');
371: fnd_file.put_line( which => fnd_file.log
372: , buff => l_sql_string);
373: fnd_file.put_line( which => fnd_file.log

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

367: WHEN OTHERS
368: THEN
369: fnd_file.put_line( which => fnd_file.log
370: , buff => 'The Following SQL statement failed ');
371: fnd_file.put_line( which => fnd_file.log
372: , buff => l_sql_string);
373: fnd_file.put_line( which => fnd_file.log
374: , buff => ' ');
375: IF (p_object_name = 'OKI_SALES_K_HDRS')

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

369: fnd_file.put_line( which => fnd_file.log
370: , buff => 'The Following SQL statement failed ');
371: fnd_file.put_line( which => fnd_file.log
372: , buff => l_sql_string);
373: fnd_file.put_line( which => fnd_file.log
374: , buff => ' ');
375: IF (p_object_name = 'OKI_SALES_K_HDRS')
376: THEN
377: FOR r_rec IN (SELECT dnz_chr_id, count(1) chr_count

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

384: SELECT contract_number ||' '||contract_number_modifier
385: INTO l_contract_number
386: FROM okc_k_headers_b
387: WHERE id = r_rec.dnz_chr_id;
388: fnd_file.put_line( which => fnd_file.log
389: , buff => 'Multiple Parties (Ex. CUSTOMER) defined for contract number '
390: || l_contract_number);
391: END LOOP;
392: fnd_file.put_line( which => fnd_file.log

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

388: fnd_file.put_line( which => fnd_file.log
389: , buff => 'Multiple Parties (Ex. CUSTOMER) defined for contract number '
390: || l_contract_number);
391: END LOOP;
392: fnd_file.put_line( which => fnd_file.log
393: , buff => ' ');
394: END IF;
395: RAISE;
396: END create_indicies;

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

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
444: , buff => l_sqlcode||' '||l_sqlerrm );
445: END update_oki_refresh;

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

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

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

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'
497: , name => 'OKI_UPD_RFR_TABLE_FAILURE');

Line 498: 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
501: , buff => l_sqlcode||' '||l_sqlerrm );
502: END update_refresh_job_run ;

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

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

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

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
598: fnd_message.set_name( application => 'OKI'

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

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:
605: WHEN OTHERS THEN
606: l_sqlcode := sqlcode ;

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

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:
619: -- Log the location within the procedure where the error occurred
620: fnd_message.set_name( application => 'OKI'

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

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:
627: fnd_file.put_line( which => fnd_file.log
628: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
630:
631:

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

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:
673: -- Log the location within the procedure where the error occurred
674: fnd_message.set_name( application => 'OKI'

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

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:
681: fnd_file.put_line( which => fnd_file.log
682: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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:
684: END truncate_table ;
685:

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

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:
906: WHEN l_excp_exit_immediate THEN
907: -- Do not log an error ; It has already been logged.

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

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:
926: -- Log the location within the procedure where the error occurred
927: fnd_message.set_name( application => 'OKI'

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

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:
934: fnd_file.put_line( which => fnd_file.log
935: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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:
937: END initial_job_check ;
938:

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

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:
1001: -- Log the location within the procedure where the error occurred
1002: fnd_message.set_name( application => 'OKI'

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

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:
1009: fnd_file.put_line( which => fnd_file.log
1010: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
1012:
1013: ---------------------------------------------------------------------

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

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:
1189: -- Log the location within the procedure where the error occurred
1190: fnd_message.set_name( application => 'OKI'

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

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:
1197: fnd_file.put_line( which => fnd_file.log
1198: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
1200:
1201: /****************11510 changes for currency conversion new Procedure***********/

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

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;
1385:
1386: IF(l_trx_func_rate_tab(i) = 0) THEN

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

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;
1396:
1397: END LOOP; -- FOR loop on tab(i)

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

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:
1481: fnd_file.put_line(which => fnd_file.log
1482: ,buff => 'Update of OKI_REFRESHS failed');

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

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
1484: CLOSE cur_contracts;
1485: l_sqlcode := sqlcode;

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

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
1496: ,buff => l_sqlcode||' '||l_sqlerrm);
1497: END initial_load_job_run_dtl;

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

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

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

1572: WHERE jrn1.job_run_id < l_sequence ) ;
1573:
1574: l_job_end_date := LEAST(nvl(p_job_start_date, sysdate ),l_sysdate);
1575:
1576: fnd_file.put_line( which => fnd_file.log
1577: , buff => 'Service Contracts Intelligence - incremental load Started on ' ||
1578: fnd_date.date_to_displayDT(sysdate));
1579: fnd_file.put_line( which => fnd_file.log
1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));

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

1575:
1576: fnd_file.put_line( which => fnd_file.log
1577: , buff => 'Service Contracts Intelligence - incremental load Started on ' ||
1578: fnd_date.date_to_displayDT(sysdate));
1579: fnd_file.put_line( which => fnd_file.log
1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1581: fnd_file.put_line( which => fnd_file.log
1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));
1583:

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

1577: , buff => 'Service Contracts Intelligence - incremental load Started on ' ||
1578: fnd_date.date_to_displayDT(sysdate));
1579: fnd_file.put_line( which => fnd_file.log
1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1581: fnd_file.put_line( which => fnd_file.log
1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));
1583:
1584: IF l_job_end_date < l_job_start_date THEN
1585: -- Job start date is greater than job end date

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

1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));
1583:
1584: IF l_job_end_date < l_job_start_date THEN
1585: -- Job start date is greater than job end date
1586: fnd_file.put_line( which => fnd_file.log
1587: , buff => 'Job start date is greater than job end date...Hence exiting');
1588: RAISE l_excp_exit_immediate;
1589: END IF;
1590:

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

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
1663: fnd_message.set_name( application => 'OKI'

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

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:
1670: WHEN OTHERS THEN
1671: l_sqlcode := sqlcode ;

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

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:
1684: -- Log the location within the procedure where the error occurred
1685: fnd_message.set_name( application => 'OKI'

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

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:
1692: fnd_file.put_line( which => fnd_file.log
1693: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
1695:
1696:

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

1736: l_job_start_date := fnd_conc_date.string_to_date('1900/01/01');
1737: l_table_name :='OKI_JOB_RUN_DTL' ;
1738: l_table_owner := 'OKI';
1739:
1740: fnd_file.put_line( which => fnd_file.log
1741: , buff => 'Service Contracts Intelligence - Initial load Started on: ' ||
1742: fnd_date.date_to_displayDT(sysdate));
1743: fnd_file.put_line( which => fnd_file.log
1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));

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

1739:
1740: fnd_file.put_line( which => fnd_file.log
1741: , buff => 'Service Contracts Intelligence - Initial load Started on: ' ||
1742: fnd_date.date_to_displayDT(sysdate));
1743: fnd_file.put_line( which => fnd_file.log
1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1745: fnd_file.put_line( which => fnd_file.log
1746: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_sysdate));
1747:

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

1741: , buff => 'Service Contracts Intelligence - Initial load Started on: ' ||
1742: fnd_date.date_to_displayDT(sysdate));
1743: fnd_file.put_line( which => fnd_file.log
1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1745: fnd_file.put_line( which => fnd_file.log
1746: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_sysdate));
1747:
1748: l_table_name := 'OKI_JOB_RUNS' ;
1749: l_loc := 'Calling truncate_table with ' || l_table_owner || '.' || l_table_name ;

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

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
1836: fnd_message.set_name( application => 'OKI'

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

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:
1843: WHEN OTHERS THEN
1844: l_sqlcode := sqlcode ;

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

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:
1857: -- Log the location within the procedure where the error occurred
1858: fnd_message.set_name( application => 'OKI'

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

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:
1865: fnd_file.put_line( which => fnd_file.log
1866: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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;
1868:
1869:

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

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 ) ;
1957:
1958: -- Log the location within the procedure where the error occurred
1959: fnd_message.set_name( application => 'OKI'

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

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;
1966: END;
1967:

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

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
2040: fnd_message.set_name( application => 'OKI'

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

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:
2047: WHEN OTHERS THEN
2048: l_sqlcode := sqlcode ;

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

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:
2061: -- Log the location within the procedure where the error occurred
2062: fnd_message.set_name( application => 'OKI'

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

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:
2069: fnd_file.put_line( which => fnd_file.log
2070: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
2072:
2073: ---------------------------------------------------------------------

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

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:
2168: WHEN l_excp_exit_immediate THEN
2169: -- Do not log an error ; It has already been logged.

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

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
2181: fnd_message.set_name( application => 'OKI'

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

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:
2188: WHEN OTHERS THEN
2189: l_sqlcode := sqlcode ;

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

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:
2202: -- Log the location within the procedure where the error occurred
2203: fnd_message.set_name( application => 'OKI'

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

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:
2210: fnd_file.put_line( which => fnd_file.log
2211: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
2213:
2214: ---------------------------------------------------------------------

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 2315: fnd_file.put_line(which => fnd_file.log

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:
2318: fnd_file.put_line(which => fnd_file.log
2319: ,buff => 'Update of OKI_REFRESHS failed');

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

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
2321: retcode := '2';
2322: fnd_file.put_line(fnd_file.log,sqlcode||' '||sqlerrm);

Line 2322: fnd_file.put_line(fnd_file.log,sqlcode||' '||sqlerrm);

2318: fnd_file.put_line(which => fnd_file.log
2319: ,buff => 'Update of OKI_REFRESHS failed');
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'

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

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:
2331: fnd_message.set_name(application => 'OKI'
2332: ,name => 'OKI_TABLE_LOAD_FAILURE');

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

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;
2338: END refresh_daily_rates;
2339:

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

2428: from oki_job_runs;
2429: EXCEPTION
2430: WHEN NO_DATA_FOUND THEN
2431: retcode := '2';
2432: fnd_file.put_line(which => fnd_file.log
2433: ,buff => 'For initial load please run Initial Job Start Set-up, Contracts Intelligence concurrent program first');
2434:
2435: RAISE l_excp_exit_immediate ;
2436: END;

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

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;
2788:
2789: EXCEPTION

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

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:
2798: fnd_file.put_line(which => fnd_file.log
2799: ,buff => 'Update of OKI_REFRESHS failed');

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

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
2801: l_sqlcode := sqlcode;
2802: l_sqlerrm := sqlerrm;

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

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
2812: , buff => l_sqlcode || ' ' || l_sqlerrm);
2813: -- try to get indexes back

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

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
2815: create_indicies(p_object_name => 'OKI_SALES_K_HDRS'

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

2867: , x_process_yn => l_process_yn
2868: , x_errbuf => x_errbuf
2869: , x_retcode => l_retcode ) ;
2870:
2871: fnd_file.put_line( which => fnd_file.log
2872: , buff => 'Job-run-id'||to_char(l_job_run_id)) ;
2873:
2874:
2875: l_loc := 'Determining status of process_refresh_check.' ;

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

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:
3249: EXCEPTION
3250: WHEN l_excp_no_processing then

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

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:
3268: fnd_file.put_line(which => fnd_file.log
3269: ,buff => 'Update of OKI_REFRESHS failed');

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

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
3271: l_sqlcode := sqlcode;
3272: l_sqlerrm := sqlerrm;

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

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:
3283: -- Log the location within the procedure where the error occurred
3284: fnd_message.set_name( application => 'OKI'

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

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:
3291: fnd_file.put_line( which => fnd_file.log
3292: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
3294:
3295: ---------------------------------------------------------------------

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

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:
3577: EXCEPTION
3578: WHEN l_excp_no_job_run_id THEN

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

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:
3588: fnd_message.set_name( application => 'OKI'
3589: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');

Line 3590: 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:
3593: WHEN l_no_update_refresh then
3594: fnd_message.set_name(application => 'OKI'

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

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:
3601: fnd_file.put_line(which => fnd_file.log
3602: ,buff => 'Update of OKI_REFRESHS failed');

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

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
3604: l_sqlcode := sqlcode;
3605: l_sqlerrm := sqlerrm;

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

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
3615: , buff => l_sqlcode||' '||l_sqlerrm);
3616: IF l_errpos < 5 THEN

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

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'
3618: ,p_parm_rec => l_ind_rec);

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

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:
3855: EXCEPTION
3856: WHEN l_excp_no_processing then

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

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:
3874: fnd_file.put_line(which => fnd_file.log
3875: ,buff => 'Update of OKI_REFRESHS failed');

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

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
3877: l_sqlcode := sqlcode;
3878: l_sqlerrm := sqlerrm;

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

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
3888: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
3889: END fast_sold_itm_lines ;

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

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

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

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:
4215: EXCEPTION
4216: WHEN l_no_update_refresh THEN

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

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
4224: , buff =>'Update of OKI_REFRESHS failed' );
4225:

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

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
4227: ROLLBACK;

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

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:
4237: fnd_message.set_name( application => 'OKI'
4238: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');

Line 4239: 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
4242: l_sqlcode := sqlcode;
4243: l_sqlerrm := sqlerrm;

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

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
4254: , buff => l_sqlcode||' '||l_sqlerrm);
4255: IF l_errpos < 5 THEN

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

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'
4257: , p_parm_rec => l_ind_rec);

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

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:
4590: EXCEPTION
4591: WHEN l_excp_no_processing then

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

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:
4609: fnd_file.put_line(which => fnd_file.log
4610: ,buff => 'Update of OKI_REFRESHS failed');

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

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:
4612: WHEN OTHERS THEN
4613: l_sqlcode := sqlcode;

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

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
4624: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
4625: END fast_cov_prd_lines ;

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

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

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

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:
4839: EXCEPTION
4840: WHEN l_excp_no_job_run_id THEN

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

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:
4851: fnd_message.set_name( application => 'OKI'
4852: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');

Line 4853: 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:
4856: when l_no_update_refresh then
4857: fnd_message.set_name(application => 'OKI'

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

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:
4864: fnd_file.put_line(which => fnd_file.log
4865: ,buff => 'Update of OKI_REFRESHS failed');

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

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
4867: l_sqlcode := sqlcode;
4868: l_sqlerrm := sqlerrm;

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

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
4878: , buff => l_sqlcode||' '||l_sqlerrm);
4879: IF l_errpos < 6 THEN

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

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'
4881: , p_parm_rec => l_ind_rec);

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

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:
5054: EXCEPTION
5055: WHEN l_excp_no_processing then

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

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:
5068: fnd_file.put_line(which => fnd_file.log
5069: ,buff => 'Update of OKI_REFRESHS failed');

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

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
5071: -- Do not log an error ; It has already been logged.
5072: -- Set return code to error

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

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
5087: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
5088: END fast_k_salesreps ;

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

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 *********/
5090: --------------------------------------------------------------

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

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:
5198: EXCEPTION
5199: WHEN l_excp_no_job_run_id THEN

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

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:
5209: fnd_message.set_name( application => 'OKI'
5210: , name => 'OKI_NO_JOB_RUN_ID_FAILURE');

Line 5211: 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:
5214: when l_no_update_refresh then
5215: fnd_message.set_name(application => 'OKI'

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

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:
5222: fnd_file.put_line(which => fnd_file.log
5223: ,buff => 'Update of OKI_REFRESHS failed');

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

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
5225: l_sqlcode := sqlcode;
5226: l_sqlerrm := sqlerrm;

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

5223: ,buff => 'Update of OKI_REFRESHS failed');
5224: WHEN OTHERS THEN
5225: l_sqlcode := sqlcode;
5226: l_sqlerrm := sqlerrm;
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'

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

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:
5238: -- Log the location within the procedure where the error occurred
5239: fnd_message.set_name( application => 'OKI'

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

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);
5247:
5248: fnd_file.put_line( which => fnd_file.log
5249: , buff => l_sqlcode || ' ' || l_sqlerrm);

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

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:
5251: END update_service_line;
5252:

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

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:
5338: EXCEPTION
5339: WHEN l_excp_no_processing then

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

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:
5351: fnd_file.put_line(which => fnd_file.log
5352: ,buff => 'Update of OKI_REFRESHS failed');

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

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
5354: -- Do not log an error ; It has already been logged.
5355: -- Set return code to error

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

5357:
5358: WHEN OTHERS THEN
5359: l_sqlcode := sqlcode;
5360: l_sqlerrm := sqlerrm;
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'

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

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:
5372: -- Log the location within the procedure where the error occurred
5373: fnd_message.set_name( application => 'OKI'

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

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);
5381:
5382: fnd_file.put_line( which => fnd_file.log
5383: , buff => l_sqlcode || ' ' || l_sqlerrm);

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

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;
5385:
5386: