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 627: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

623: exception
624:
625: when others then
626:
627: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
628: errbuf := substr(SQLERRM,1,150);
629: retcode := -1 ;
630: raise;
631:

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

734: exception
735:
736: when others then
737:
738: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
739: errbuf := substr(SQLERRM,1,150);
740: retcode := -1 ;
741: raise;
742:

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

835: exception
836:
837: when others then
838:
839: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
840: errbuf := substr(SQLERRM,1,150);
841: retcode := -1 ;
842: raise;
843:

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

981: exception
982:
983: when others then
984:
985: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
986: errbuf := substr(SQLERRM,1,150);
987: retcode := -1 ;
988: raise;
989:

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

1167: retcode := 0;
1168:
1169: EXCEPTION
1170: when others then
1171: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1172: errbuf := substr(SQLERRM,1,150);
1173: retcode := -1 ;
1174: raise;
1175:

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

1307: exception
1308:
1309: when others then
1310:
1311: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1312: errbuf := substr(SQLERRM,1,150);
1313: retcode := -1 ;
1314: raise;
1315:

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

1669:
1670: exception
1671:
1672: WHEN others THEN
1673: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1674: errbuf := substr(SQLERRM,1,150);
1675: retcode := -1 ;
1676: raise;
1677:

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

1712: EXECUTE IMMEDIATE p_str USING p_cal_code, p_min_date, p_max_date;
1713:
1714: exception
1715: WHEN others THEN
1716: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1717: raise;
1718:
1719: END populate_calendar_dates;
1720:

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

1752: l_str := l_str || ' and created_by_refresh_num = ' || p_new_refresh_num;
1753: END IF;
1754: EXECUTE IMMEDIATE l_str INTO l_min_date, l_max_date;
1755:
1756: --fnd_file.put_line(fnd_file.log, l_min_date || ' ' || l_max_date );
1757:
1758: -- Get Database Link
1759: msd_common_utilities.get_db_link(p_instance, l_dblink, retcode);
1760:

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

1779:
1780: EXCEPTION
1781: WHEN no_data_found THEN
1782: IF (l_where = 1 ) THEN
1783: fnd_file.put_line(fnd_file.log, 'Master ORG has not been defined for instance_id : '
1784: || p_instance );
1785: errbuf := 'Master ORG has not been defined for instance_id : '|| p_instance;
1786: ELSIF (l_where = 2) THEN
1787: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||

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

1783: fnd_file.put_line(fnd_file.log, 'Master ORG has not been defined for instance_id : '
1784: || p_instance );
1785: errbuf := 'Master ORG has not been defined for instance_id : '|| p_instance;
1786: ELSIF (l_where = 2) THEN
1787: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||
1788: 'for master org ' || l_org_id ||' for instance_id : ' || p_instance);
1789: errbuf := 'A calendar has not been defined for master org';
1790: END IF;
1791: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

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

1787: fnd_file.put_line(fnd_file.log, 'A calendar has not been defined ' ||
1788: 'for master org ' || l_org_id ||' for instance_id : ' || p_instance);
1789: errbuf := 'A calendar has not been defined for master org';
1790: END IF;
1791: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1792: errbuf := substr(SQLERRM,1,150);
1793: retcode := -1;
1794: raise;
1795: WHEN OTHERS THEN

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

1792: errbuf := substr(SQLERRM,1,150);
1793: retcode := -1;
1794: raise;
1795: WHEN OTHERS THEN
1796: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1797: errbuf := substr(SQLERRM,1,150);
1798: retcode := -1;
1799: raise;
1800:

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

1844: return l_is_required;
1845:
1846: EXCEPTION
1847: when others then
1848: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1849: errbuf := substr(SQLERRM,1,150);
1850: retcode := -1;
1851: return NULL;
1852: END;

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

1875:
1876:
1877: EXCEPTION
1878: when others then
1879: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1880: errbuf := substr(SQLERRM,1,150);
1881: retcode := -1;
1882: raise;
1883: