DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_FACT_DATA dependencies on FND_FILE

Line 250: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

246: retcode := 0;
247:
248: EXCEPTION
249: when others then
250: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
251: errbuf := substr(SQLERRM,1,150);
252: retcode := -1 ;
253: raise;
254:

Line 475: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

471: retcode := 0;
472:
473: EXCEPTION
474: when others then
475: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
476: errbuf := substr(SQLERRM,1,150);
477: retcode := -1 ;
478: raise;
479:

Line 701: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

697: exception
698:
699: when others then
700:
701: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
702: errbuf := substr(SQLERRM,1,150);
703: retcode := -1 ;
704: raise;
705:

Line 812: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

808: exception
809:
810: when others then
811:
812: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
813: errbuf := substr(SQLERRM,1,150);
814: retcode := -1 ;
815: raise;
816:

Line 913: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

909: exception
910:
911: when others then
912:
913: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
914: errbuf := substr(SQLERRM,1,150);
915: retcode := -1 ;
916: raise;
917:

Line 1059: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1055: exception
1056:
1057: when others then
1058:
1059: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1060: errbuf := substr(SQLERRM,1,150);
1061: retcode := -1 ;
1062: raise;
1063:

Line 1245: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1241: retcode := 0;
1242:
1243: EXCEPTION
1244: when others then
1245: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1246: errbuf := substr(SQLERRM,1,150);
1247: retcode := -1 ;
1248: raise;
1249:

Line 1385: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1381: exception
1382:
1383: when others then
1384:
1385: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1386: errbuf := substr(SQLERRM,1,150);
1387: retcode := -1 ;
1388: raise;
1389:

Line 1747: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1743:
1744: exception
1745:
1746: WHEN others THEN
1747: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1748: errbuf := substr(SQLERRM,1,150);
1749: retcode := -1 ;
1750: raise;
1751:

Line 1790: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1786: EXECUTE IMMEDIATE p_str USING p_cal_code, p_min_date, p_max_date;
1787:
1788: exception
1789: WHEN others THEN
1790: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1791: raise;
1792:
1793: END populate_calendar_dates;
1794:

Line 1830: --fnd_file.put_line(fnd_file.log, l_min_date || ' ' || l_max_date );

1826: l_str := l_str || ' and created_by_refresh_num = ' || p_new_refresh_num;
1827: END IF;
1828: EXECUTE IMMEDIATE l_str INTO l_min_date, l_max_date;
1829:
1830: --fnd_file.put_line(fnd_file.log, l_min_date || ' ' || l_max_date );
1831:
1832: -- Get Database Link
1833: msd_common_utilities.get_db_link(p_instance, l_dblink, retcode);
1834:

Line 1857: fnd_file.put_line(fnd_file.log, 'Master ORG has not been defined for instance_id : '

1853:
1854: EXCEPTION
1855: WHEN no_data_found THEN
1856: IF (l_where = 1 ) THEN
1857: fnd_file.put_line(fnd_file.log, 'Master ORG has not been defined for instance_id : '
1858: || p_instance );
1859: errbuf := 'Master ORG has not been defined for instance_id : '|| p_instance;
1860: ELSIF (l_where = 2) THEN
1861: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||

Line 1861: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||

1857: fnd_file.put_line(fnd_file.log, 'Master ORG has not been defined for instance_id : '
1858: || p_instance );
1859: errbuf := 'Master ORG has not been defined for instance_id : '|| p_instance;
1860: ELSIF (l_where = 2) THEN
1861: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||
1862: 'for master org ' || l_org_id ||' for instance_id : ' || p_instance);
1863: errbuf := 'A calendar has not been defined for master org';
1864: END IF;
1865: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

Line 1865: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1861: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||
1862: 'for master org ' || l_org_id ||' for instance_id : ' || p_instance);
1863: errbuf := 'A calendar has not been defined for master org';
1864: END IF;
1865: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1866: errbuf := substr(SQLERRM,1,150);
1867: retcode := -1;
1868: raise;
1869: WHEN OTHERS THEN

Line 1870: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1866: errbuf := substr(SQLERRM,1,150);
1867: retcode := -1;
1868: raise;
1869: WHEN OTHERS THEN
1870: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1871: errbuf := substr(SQLERRM,1,150);
1872: retcode := -1;
1873: raise;
1874:

Line 1922: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1918: return l_is_required;
1919:
1920: EXCEPTION
1921: when others then
1922: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1923: errbuf := substr(SQLERRM,1,150);
1924: retcode := -1;
1925: return NULL;
1926: END;

Line 1989: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1985:
1986:
1987: EXCEPTION
1988: when others then
1989: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1990: errbuf := substr(SQLERRM,1,150);
1991: retcode := -1;
1992: raise;
1993: