DBA Data[Home] [Help]

APPS.CS_SR_COST_CP dependencies on FND_FILE

Line 905: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');

901: , SUBSTR(x_msg_data, 1, 240)
902: );
903:
904: --Added for bug 7168775
905: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
906:
907:
908: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
909: THEN

Line 968: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');

964: , SUBSTR(x_msg_data, 1, 240)
965: );
966:
967: --Added for bug 7168775
968: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
969:
970: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
971: THEN
972: FND_LOG.String

Line 1030: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');

1026: , SUBSTR(x_msg_data, 1, 240)
1027: );
1028:
1029: --Added for bug 7168775
1030: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
1031:
1032:
1033: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1034: THEN

Line 1098: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');

1094: , SUBSTR(x_msg_data, 1, 240)
1095: );
1096:
1097: --Added for bug 7168775
1098: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
1099:
1100:
1101: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1102: THEN

Line 1829: FND_FILE.PUT_LINE(FND_FILE.LOG,'exception : '||sqlerrm);

1825:
1826: END LOOP;
1827: exception
1828: WHEN OTHERS THEN
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,'exception : '||sqlerrm);
1830: end;
1831: --END LOOP;
1832:
1833: CLOSE c_staging;

Line 1929: fnd_file.put_line

1925: , 'Getting number of SRs submitted for Cost Creation'
1926: );
1927: END IF;
1928:
1929: fnd_file.put_line
1930: (
1931: FND_FILE.OUTPUT
1932: , ''
1933: );

Line 1931: FND_FILE.OUTPUT

1927: END IF;
1928:
1929: fnd_file.put_line
1930: (
1931: FND_FILE.OUTPUT
1932: , ''
1933: );
1934:
1935:

Line 1943: fnd_file.put_line

1939: 'CS'
1940: , 'CS_SR_COST_RESULT'
1941: );
1942:
1943: fnd_file.put_line
1944: (
1945: FND_FILE.OUTPUT
1946: , '

' || l_report_caption
1947: || '

'

Line 1945: FND_FILE.OUTPUT

1941: );
1942:
1943: fnd_file.put_line
1944: (
1945: FND_FILE.OUTPUT
1946: , '

' || l_report_caption
1947: || '

'
1948: );
1949:

Line 1969: fnd_file.put_line

1965: cs_cost_staging s
1966: WHERE
1967: s.worker_id = NVL(p_worker_id, s.worker_id);
1968:
1969: fnd_file.put_line
1970: (
1971: FND_FILE.OUTPUT
1972: , '

'

Line 1971: FND_FILE.OUTPUT

1967: s.worker_id = NVL(p_worker_id, s.worker_id);
1968:
1969: fnd_file.put_line
1970: (
1971: FND_FILE.OUTPUT
1972: , '

'
1974: );
1975:

Line 1998: fnd_file.put_line

1994: WHERE
1995: status = 'S'
1996: AND s.worker_id = NVL(p_worker_id, s.worker_id);
1997:
1998: fnd_file.put_line
1999: (
2000: FND_FILE.OUTPUT
2001: , '

'

Line 2000: FND_FILE.OUTPUT

1996: AND s.worker_id = NVL(p_worker_id, s.worker_id);
1997:
1998: fnd_file.put_line
1999: (
2000: FND_FILE.OUTPUT
2001: , '

'
2003: );
2004:

Line 2032: fnd_file.put_line

2028: -- if there were some rows that were not
2029: -- processed, display that too in the report.
2030:
2031: THEN
2032: fnd_file.put_line
2033: (
2034: FND_FILE.OUTPUT
2035: , '

'
2038: );

Line 2081: fnd_file.put_line

2077: -- if there were some rows that failed during
2078: -- processing, display that in the report.
2079:
2080: THEN
2081: fnd_file.put_line
2082: (
2083: FND_FILE.OUTPUT
2084: , '

' || l_report_caption || ''
1973: || l_row_count || '
' || l_report_caption || ''
1973: || l_row_count || '
' || l_report_caption || ''
2002: || l_row_count || '
' || l_report_caption || ''
2002: || l_row_count || '
' || l_report_caption
2036: || '
'

Line 2034: FND_FILE.OUTPUT

2030:
2031: THEN
2032: fnd_file.put_line
2033: (
2034: FND_FILE.OUTPUT
2035: , '

' || l_report_caption
2036: || '
'
2037: || l_row_count || '
' || l_report_caption
2085: || '
' || l_row_count

Line 2083: FND_FILE.OUTPUT

2079:
2080: THEN
2081: fnd_file.put_line
2082: (
2083: FND_FILE.OUTPUT
2084: , '

' || l_report_caption
2085: || '
' || l_row_count
2086: || '
'
2087: );

Line 2122: fnd_file.put_line

2118:
2119: -- Starting to print the report on all the SRs that failed
2120: -- cost creation due to business reasons along with the vital details
2121:
2122: fnd_file.put_line
2123: (
2124: FND_FILE.OUTPUT
2125: , '

'
2126: );

Line 2124: FND_FILE.OUTPUT

2120: -- cost creation due to business reasons along with the vital details
2121:
2122: fnd_file.put_line
2123: (
2124: FND_FILE.OUTPUT
2125: , '

'
2126: );
2127: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2128: THEN

Line 2142: fnd_file.put_line

2138: (
2139: 'CS'
2140: , 'CS_SR_FAILED_ESTIMATE_REPORT'
2141: );
2142: fnd_file.put_line
2143: (
2144: FND_FILE.OUTPUT
2145: , l_report_caption
2146: );

Line 2144: FND_FILE.OUTPUT

2140: , 'CS_SR_FAILED_ESTIMATE_REPORT'
2141: );
2142: fnd_file.put_line
2143: (
2144: FND_FILE.OUTPUT
2145: , l_report_caption
2146: );
2147: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2148: THEN

Line 2157: fnd_file.put_line

2153: , l_report_caption
2154: );
2155: END IF;
2156:
2157: fnd_file.put_line
2158: (
2159: FND_FILE.OUTPUT
2160: , ''
2161: );

Line 2159: FND_FILE.OUTPUT

2155: END IF;
2156:
2157: fnd_file.put_line
2158: (
2159: FND_FILE.OUTPUT
2160: , ''
2161: );
2162: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2163: THEN

Line 2175: fnd_file.put_line

2171:
2172: ---
2173:
2174:
2175: fnd_file.put_line
2176: (
2177: FND_FILE.OUTPUT
2178: , ''
2179: );

Line 2177: FND_FILE.OUTPUT

2173:
2174:
2175: fnd_file.put_line
2176: (
2177: FND_FILE.OUTPUT
2178: , '

'
2179: );
2180: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2181: THEN

Line 2195: fnd_file.put_line

2191: (
2192: 'CS'
2193: , 'CS_SR_COST_FAILED_RPT_HEAD'
2194: );
2195: fnd_file.put_line
2196: (
2197: FND_FILE.OUTPUT
2198: , l_report_caption
2199: );

Line 2197: FND_FILE.OUTPUT

2193: , 'CS_SR_COST_FAILED_RPT_HEAD'
2194: );
2195: fnd_file.put_line
2196: (
2197: FND_FILE.OUTPUT
2198: , l_report_caption
2199: );
2200: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2201: THEN

Line 2210: fnd_file.put_line

2206: , l_report_caption
2207: );
2208: END IF;
2209:
2210: fnd_file.put_line
2211: (
2212: FND_FILE.OUTPUT
2213: , '

'
2214: );

Line 2212: FND_FILE.OUTPUT

2208: END IF;
2209:
2210: fnd_file.put_line
2211: (
2212: FND_FILE.OUTPUT
2213: , ''
2214: );
2215: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2216: THEN

Line 2268: fnd_file.put_line

2264: -- the message dictionary.
2265:
2266: FOR j IN l_incident_number_arr.FIRST..l_incident_number_arr.LAST
2267: LOOP
2268: fnd_file.put_line
2269: (
2270: FND_FILE.OUTPUT
2271: , '

'
2272: );

Line 2270: FND_FILE.OUTPUT

2266: FOR j IN l_incident_number_arr.FIRST..l_incident_number_arr.LAST
2267: LOOP
2268: fnd_file.put_line
2269: (
2270: FND_FILE.OUTPUT
2271: , '

'
2272: );
2273:
2274: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 2400: fnd_file.put_line

2396: END IF;
2397:
2398: l_text := l_text || NVL(l_error_message_text, '-') || '';
2399:
2400: fnd_file.put_line
2401: (
2402: FND_FILE.OUTPUT
2403: , l_text
2404: );

Line 2402: FND_FILE.OUTPUT

2398: l_text := l_text || NVL(l_error_message_text, '-') || '';
2399:
2400: fnd_file.put_line
2401: (
2402: FND_FILE.OUTPUT
2403: , l_text
2404: );
2405:
2406: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 2416: fnd_file.put_line

2412: , l_text
2413: );
2414: END IF;
2415:
2416: fnd_file.put_line
2417: (
2418: FND_FILE.OUTPUT
2419: , '

'
2420: );

Line 2418: FND_FILE.OUTPUT

2414: END IF;
2415:
2416: fnd_file.put_line
2417: (
2418: FND_FILE.OUTPUT
2419: , ''
2420: );
2421:
2422: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 2452: fnd_file.put_line

2448: );
2449: END IF;
2450: END IF;
2451:
2452: fnd_file.put_line
2453: (
2454: FND_FILE.OUTPUT
2455: , '

'
2456: );

Line 2454: FND_FILE.OUTPUT

2450: END IF;
2451:
2452: fnd_file.put_line
2453: (
2454: FND_FILE.OUTPUT
2455: , ''
2456: );
2457: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2458: THEN