DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on FND_FILE

Line 1903: FND_file.new_line(fnd_file.log);

1899: hr_utility.trace('Yeah it came here ');
1900: IF g_pay_pa_link_tab.COUNT > 0
1901: THEN
1902:
1903: FND_file.new_line(fnd_file.log);
1904: FND_file.new_line(fnd_file.log);
1905: FND_FILE.put_line(fnd_file.log,
1906: l_space||'=====================================================================================================|');
1907: FND_file.put_line(fnd_file.log,

Line 1904: FND_file.new_line(fnd_file.log);

1900: IF g_pay_pa_link_tab.COUNT > 0
1901: THEN
1902:
1903: FND_file.new_line(fnd_file.log);
1904: FND_file.new_line(fnd_file.log);
1905: FND_FILE.put_line(fnd_file.log,
1906: l_space||'=====================================================================================================|');
1907: FND_file.put_line(fnd_file.log,
1908: ' The following details are recorded in the Interface table for Projects Import ');

Line 1905: FND_FILE.put_line(fnd_file.log,

1901: THEN
1902:
1903: FND_file.new_line(fnd_file.log);
1904: FND_file.new_line(fnd_file.log);
1905: FND_FILE.put_line(fnd_file.log,
1906: l_space||'=====================================================================================================|');
1907: FND_file.put_line(fnd_file.log,
1908: ' The following details are recorded in the Interface table for Projects Import ');
1909: FND_FILE.put_line(fnd_file.log,

Line 1907: FND_file.put_line(fnd_file.log,

1903: FND_file.new_line(fnd_file.log);
1904: FND_file.new_line(fnd_file.log);
1905: FND_FILE.put_line(fnd_file.log,
1906: l_space||'=====================================================================================================|');
1907: FND_file.put_line(fnd_file.log,
1908: ' The following details are recorded in the Interface table for Projects Import ');
1909: FND_FILE.put_line(fnd_file.log,
1910: l_space||'=====================================================================================================|');
1911: FND_file.new_line(fnd_file.log);

Line 1909: FND_FILE.put_line(fnd_file.log,

1905: FND_FILE.put_line(fnd_file.log,
1906: l_space||'=====================================================================================================|');
1907: FND_file.put_line(fnd_file.log,
1908: ' The following details are recorded in the Interface table for Projects Import ');
1909: FND_FILE.put_line(fnd_file.log,
1910: l_space||'=====================================================================================================|');
1911: FND_file.new_line(fnd_file.log);
1912: FND_file.new_line(fnd_file.log);
1913:

Line 1911: FND_file.new_line(fnd_file.log);

1907: FND_file.put_line(fnd_file.log,
1908: ' The following details are recorded in the Interface table for Projects Import ');
1909: FND_FILE.put_line(fnd_file.log,
1910: l_space||'=====================================================================================================|');
1911: FND_file.new_line(fnd_file.log);
1912: FND_file.new_line(fnd_file.log);
1913:
1914: FND_file.put_line(fnd_file.log,
1915: ' ======= NEW BATCH LINES FOR FRESH DETAILS ========= ');

Line 1912: FND_file.new_line(fnd_file.log);

1908: ' The following details are recorded in the Interface table for Projects Import ');
1909: FND_FILE.put_line(fnd_file.log,
1910: l_space||'=====================================================================================================|');
1911: FND_file.new_line(fnd_file.log);
1912: FND_file.new_line(fnd_file.log);
1913:
1914: FND_file.put_line(fnd_file.log,
1915: ' ======= NEW BATCH LINES FOR FRESH DETAILS ========= ');
1916:

Line 1914: FND_file.put_line(fnd_file.log,

1910: l_space||'=====================================================================================================|');
1911: FND_file.new_line(fnd_file.log);
1912: FND_file.new_line(fnd_file.log);
1913:
1914: FND_file.put_line(fnd_file.log,
1915: ' ======= NEW BATCH LINES FOR FRESH DETAILS ========= ');
1916:
1917: FORALL i IN INDICES OF g_pay_pa_link_tab
1918: INSERT INTO hxc_pay_pa_link_all

Line 1922: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||

1918: INSERT INTO hxc_pay_pa_link_all
1919: VALUES g_pay_pa_link_tab(i);
1920:
1921:
1922: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||
1923: l_line||
1924: RPAD('========',5)||
1925: l_line||
1926: RPAD('==========',10)||

Line 1937: fnd_file.put_line(fnd_file.log,l_space||RPAD('TBB_ID',10)||

1933: l_line||
1934: RPAD('==========',10)||'|');
1935:
1936:
1937: fnd_file.put_line(fnd_file.log,l_space||RPAD('TBB_ID',10)||
1938: l_space||
1939: RPAD('OVN',5)||
1940: l_space||
1941: RPAD('BATCH_ID',10)||

Line 1951: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||

1947: RPAD('PROJECT',10)||
1948: l_space||
1949: RPAD('TASK',10)||'|');
1950:
1951: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||
1952: l_line||
1953: RPAD('========',5)||
1954: l_line||
1955: RPAD('==========',10)||

Line 1968: fnd_file.put_line(fnd_file.log,l_space||RPAD(g_pay_pa_link_tab(i).time_building_block_id,10)||

1964:
1965:
1966: i := g_pay_pa_link_tab.FIRST;
1967: LOOP
1968: fnd_file.put_line(fnd_file.log,l_space||RPAD(g_pay_pa_link_tab(i).time_building_block_id,10)||
1969: l_space||
1970: RPAD(g_pay_pa_link_tab(i).object_version_number,5)||
1971: l_space||
1972: RPAD(g_pay_pa_link_tab(i).batch_id,10)||

Line 1984: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||

1980: RPAD(g_pay_pa_link_tab(i).task_id,10)||'|');
1981: i := g_pay_pa_link_tab.NEXT(i);
1982: EXIT WHEN NOT g_pay_pa_link_tab.EXISTS(i);
1983: END LOOP;
1984: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||
1985: l_line||
1986: RPAD('========',5)||
1987: l_line||
1988: RPAD('==========',10)||

Line 1999: FND_file.new_line(fnd_file.log);

1995: l_line||
1996: RPAD('==========',10)||'|');
1997:
1998:
1999: FND_file.new_line(fnd_file.log);
2000: FND_file.new_line(fnd_file.log);
2001:
2002: END IF;
2003:

Line 2000: FND_file.new_line(fnd_file.log);

1996: RPAD('==========',10)||'|');
1997:
1998:
1999: FND_file.new_line(fnd_file.log);
2000: FND_file.new_line(fnd_file.log);
2001:
2002: END IF;
2003:
2004: FND_file.new_line(fnd_file.log);

Line 2004: FND_file.new_line(fnd_file.log);

2000: FND_file.new_line(fnd_file.log);
2001:
2002: END IF;
2003:
2004: FND_file.new_line(fnd_file.log);
2005: FND_file.new_line(fnd_file.log);
2006:
2007: IF g_old_pay_pa_link_tab.COUNT > 0
2008: THEN

Line 2005: FND_file.new_line(fnd_file.log);

2001:
2002: END IF;
2003:
2004: FND_file.new_line(fnd_file.log);
2005: FND_file.new_line(fnd_file.log);
2006:
2007: IF g_old_pay_pa_link_tab.COUNT > 0
2008: THEN
2009:

Line 2011: FND_file.new_line(fnd_file.log);

2007: IF g_old_pay_pa_link_tab.COUNT > 0
2008: THEN
2009:
2010:
2011: FND_file.new_line(fnd_file.log);
2012: FND_file.new_line(fnd_file.log);
2013:
2014: FND_file.put_line(fnd_file.log,
2015: ' ======= RETRO BATCH LINES FOR PREVIOUSLY TRANSFERRED DETAILS ========= ');

Line 2012: FND_file.new_line(fnd_file.log);

2008: THEN
2009:
2010:
2011: FND_file.new_line(fnd_file.log);
2012: FND_file.new_line(fnd_file.log);
2013:
2014: FND_file.put_line(fnd_file.log,
2015: ' ======= RETRO BATCH LINES FOR PREVIOUSLY TRANSFERRED DETAILS ========= ');
2016:

Line 2014: FND_file.put_line(fnd_file.log,

2010:
2011: FND_file.new_line(fnd_file.log);
2012: FND_file.new_line(fnd_file.log);
2013:
2014: FND_file.put_line(fnd_file.log,
2015: ' ======= RETRO BATCH LINES FOR PREVIOUSLY TRANSFERRED DETAILS ========= ');
2016:
2017: FORALL i IN INDICES OF g_old_pay_pa_link_tab
2018: INSERT INTO hxc_pay_pa_link_all

Line 2022: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||

2018: INSERT INTO hxc_pay_pa_link_all
2019: values g_old_pay_pa_link_tab(i);
2020:
2021:
2022: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||
2023: l_line||
2024: RPAD('========',5)||
2025: l_line||
2026: RPAD('==========',10)||

Line 2037: fnd_file.put_line(fnd_file.log,l_space||RPAD('TBB_ID',10)||

2033: l_line||
2034: RPAD('==========',10)||'|');
2035:
2036:
2037: fnd_file.put_line(fnd_file.log,l_space||RPAD('TBB_ID',10)||
2038: l_space||
2039: RPAD('OVN',5)||
2040: l_space||
2041: RPAD('BATCH_ID',10)||

Line 2051: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||

2047: RPAD('PROJECT',10)||
2048: l_space||
2049: RPAD('TASK',10)||'|');
2050:
2051: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||
2052: l_line||
2053: RPAD('========',5)||
2054: l_line||
2055: RPAD('==========',10)||

Line 2069: fnd_file.put_line(fnd_file.log,l_space||RPAD(g_old_pay_pa_link_tab(i).time_building_block_id,10)||

2065:
2066:
2067: i := g_old_pay_pa_link_tab.FIRST;
2068: LOOP
2069: fnd_file.put_line(fnd_file.log,l_space||RPAD(g_old_pay_pa_link_tab(i).time_building_block_id,10)||
2070: l_space||
2071: RPAD(g_old_pay_pa_link_tab(i).object_version_number,5)||
2072: l_space||
2073: RPAD(g_old_pay_pa_link_tab(i).batch_id,10)||

Line 2086: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||

2082: i := g_old_pay_pa_link_tab.NEXT(i);
2083: EXIT WHEN NOT g_old_pay_pa_link_tab.EXISTS(i);
2084: END LOOP;
2085:
2086: fnd_file.put_line(fnd_file.log,l_space||RPAD('==========',10)||
2087: l_line||
2088: RPAD('========',5)||
2089: l_line||
2090: RPAD('==========',10)||

Line 2101: FND_file.new_line(fnd_file.log);

2097: l_line||
2098: RPAD('==========',10)||'|');
2099:
2100:
2101: FND_file.new_line(fnd_file.log);
2102: FND_file.new_line(fnd_file.log);
2103:
2104:
2105: END IF;

Line 2102: FND_file.new_line(fnd_file.log);

2098: RPAD('==========',10)||'|');
2099:
2100:
2101: FND_file.new_line(fnd_file.log);
2102: FND_file.new_line(fnd_file.log);
2103:
2104:
2105: END IF;
2106: