DBA Data[Home] [Help]

APPS.CS_SR_INTERFACE_CP dependencies on FND_FILE

Line 218: /* --fnd_file.put_line(FND_FILE.OUTPUT,'exception :'||sqlerrm);

214: AND nvl(csd.interfaced_to_pa_flag,'N') in ('E','N');
215:
216:
217: BEGIN
218: /* --fnd_file.put_line(FND_FILE.OUTPUT,'exception :'||sqlerrm);
219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);
220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);

Line 219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);

215:
216:
217: BEGIN
218: /* --fnd_file.put_line(FND_FILE.OUTPUT,'exception :'||sqlerrm);
219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);
220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);

Line 220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);

216:
217: BEGIN
218: /* --fnd_file.put_line(FND_FILE.OUTPUT,'exception :'||sqlerrm);
219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);
220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);

Line 221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);

217: BEGIN
218: /* --fnd_file.put_line(FND_FILE.OUTPUT,'exception :'||sqlerrm);
219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);
220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);

Line 222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);

218: /* --fnd_file.put_line(FND_FILE.OUTPUT,'exception :'||sqlerrm);
219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);
220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);

Line 223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);

219: fnd_file.put_line(FND_FILE.log,'p_creation_from_date :'||p_creation_from_date);
220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);

Line 224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);

220: fnd_file.put_line(FND_FILE.log,'p_creation_to_date :'||p_creation_to_date);
221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);

Line 225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);

221: fnd_file.put_line(FND_FILE.log,'p_project_id :'||p_project_id);
222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);
229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);

Line 226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);

222: fnd_file.put_line(FND_FILE.log,'p_project_task_id :'||p_project_task_id);
223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);
229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);
230: fnd_file.put_line(FND_FILE.log,'p_inv_org_id :'||p_inv_org_id);*/

Line 227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);

223: fnd_file.put_line(FND_FILE.log,'p_transaction_type_id :'||p_transaction_type_id);
224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);
229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);
230: fnd_file.put_line(FND_FILE.log,'p_inv_org_id :'||p_inv_org_id);*/
231: FND_MSG_PUB.initialize;

Line 228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);

224: fnd_file.put_line(FND_FILE.log,'p_billing_type :'||p_billing_type);
225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);
229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);
230: fnd_file.put_line(FND_FILE.log,'p_inv_org_id :'||p_inv_org_id);*/
231: FND_MSG_PUB.initialize;
232:

Line 229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);

225: fnd_file.put_line(FND_FILE.log,'p_incident_id :'||p_incident_id);
226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);
229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);
230: fnd_file.put_line(FND_FILE.log,'p_inv_org_id :'||p_inv_org_id);*/
231: FND_MSG_PUB.initialize;
232:
233: /*l_err_cst_rec := l_cst_arry();

Line 230: fnd_file.put_line(FND_FILE.log,'p_inv_org_id :'||p_inv_org_id);*/

226: fnd_file.put_line(FND_FILE.log,'p_incident_status_id :'||p_incident_status_id);
227: fnd_file.put_line(FND_FILE.log,'p_source_code :'||p_source_code);
228: fnd_file.put_line(FND_FILE.log,'p_source_number :'||p_source_number);
229: fnd_file.put_line(FND_FILE.log,'p_org_id :'||p_org_id);
230: fnd_file.put_line(FND_FILE.log,'p_inv_org_id :'||p_inv_org_id);*/
231: FND_MSG_PUB.initialize;
232:
233: /*l_err_cst_rec := l_cst_arry();
234: l_succ_cst_rec := l_cst_arry();

Line 1512: --fnd_file.put_line(FND_FILE.log,'Aftre calling Validate_transaction :'||p_msg_data);

1508: , p_msg_count => p_msg_count
1509: , p_msg_data => p_msg_data
1510: , p_billable_flag => l_billable_flag);
1511:
1512: --fnd_file.put_line(FND_FILE.log,'Aftre calling Validate_transaction :'||p_msg_data);
1513:
1514:
1515: If p_msg_type = 'E' and p_msg_data is not null then
1516:

Line 1842: fnd_file.put_line(FND_FILE.log,'FND_MSG_PUB.Count_And_Get : '||p_msg_data);

1838: p_data => p_msg_data,--out
1839: p_encoded => FND_API.G_FALSE) ;--in
1840: FND_MSG_PUB.Delete_Msg;
1841:
1842: fnd_file.put_line(FND_FILE.log,'FND_MSG_PUB.Count_And_Get : '||p_msg_data);
1843:
1844:
1845:
1846: l_failure_count := l_failure_count+1;

Line 1919: fnd_file.put_line

1915:
1916:
1917:
1918:
1919: fnd_file.put_line
1920: (
1921: FND_FILE.OUTPUT
1922: , ''
1923: );

Line 1921: FND_FILE.OUTPUT

1917:
1918:
1919: fnd_file.put_line
1920: (
1921: FND_FILE.OUTPUT
1922: , ''
1923: );
1924:
1925: fnd_file.put_line

Line 1925: fnd_file.put_line

1921: FND_FILE.OUTPUT
1922: , ''
1923: );
1924:
1925: fnd_file.put_line
1926: (
1927: FND_FILE.OUTPUT
1928: , '

' || 'Results of the Cost Interface Program'
1929: || '

'

Line 1927: FND_FILE.OUTPUT

1923: );
1924:
1925: fnd_file.put_line
1926: (
1927: FND_FILE.OUTPUT
1928: , '

' || 'Results of the Cost Interface Program'
1929: || '

'
1930: );
1931:

Line 1933: fnd_file.put_line

1929: || '

'
1930: );
1931:
1932:
1933: fnd_file.put_line
1934: (
1935: FND_FILE.OUTPUT
1936: , ''

Line 1935: FND_FILE.OUTPUT

1931:
1932:
1933: fnd_file.put_line
1934: (
1935: FND_FILE.OUTPUT
1936: , '

'
1938: );
1939:

Line 1941: fnd_file.put_line

1937: || (l_count-1)|| ''
1938: );
1939:
1940:
1941: fnd_file.put_line
1942: (
1943: FND_FILE.OUTPUT
1944: , '

'

Line 1943: FND_FILE.OUTPUT

1939:
1940:
1941: fnd_file.put_line
1942: (
1943: FND_FILE.OUTPUT
1944: , '

'
1946: );
1947:

Line 1952: fnd_file.put_line

1948:
1949:
1950:
1951:
1952: fnd_file.put_line
1953: (
1954: FND_FILE.OUTPUT
1955: , '

'

Line 1954: FND_FILE.OUTPUT

1950:
1951:
1952: fnd_file.put_line
1953: (
1954: FND_FILE.OUTPUT
1955: , '

'
1957: );
1958:

Line 1965: fnd_file.put_line

1961:
1962: If l_err_cst_rec.count > 0 then
1963:
1964:
1965: fnd_file.put_line
1966: (
1967: FND_FILE.OUTPUT
1968: , '

' || 'Number of Cost Records considered for Projects Interface ' || ''
1937: || (l_count-1)|| '
' || 'Number of Cost Records considered for Projects Interface ' || ''
1937: || (l_count-1)|| '
' || 'Number of Cost Records successfully inserted into the Projects Interface Table' || ''
1945: || l_success_count|| '
' || 'Number of Cost Records successfully inserted into the Projects Interface Table' || ''
1945: || l_success_count|| '
' || 'Number of Cost Records failed to be inserted into the Projects Interface Table' || ''
1956: || l_failure_count|| '
' || 'Number of Cost Records failed to be inserted into the Projects Interface Table' || ''
1956: || l_failure_count|| '
'
1969: ||''

Line 1967: FND_FILE.OUTPUT

1963:
1964:
1965: fnd_file.put_line
1966: (
1967: FND_FILE.OUTPUT
1968: , '

'||'Details of the Cost records that failed Insertion'||'
'
1969: ||''
1970: );
1971:

Line 1973: fnd_file.put_line

1969: ||'

'
1970: );
1971:
1972:
1973: fnd_file.put_line
1974: (
1975: FND_FILE.OUTPUT,'

'
1976: );
1977:

Line 1975: FND_FILE.OUTPUT,'

'

1971:
1972:
1973: fnd_file.put_line
1974: (
1975: FND_FILE.OUTPUT,'

'
1976: );
1977:
1978:
1979: fnd_file.put_line

Line 1979: fnd_file.put_line

1975: FND_FILE.OUTPUT,'

'
1976: );
1977:
1978:
1979: fnd_file.put_line
1980: (
1981: FND_FILE.OUTPUT
1982: , '

'
1983: ||''

Line 1981: FND_FILE.OUTPUT

1977:
1978:
1979: fnd_file.put_line
1980: (
1981: FND_FILE.OUTPUT
1982: , '

'
1983: ||''
1984: ||''
1985: ||''

Line 1989: --fnd_file.put_line(FND_FILE.log,'getting l_err_cst_rec.count : '||l_err_cst_rec.count);

1985: ||'

'
1986: ||''
1987:
1988: );
1989: --fnd_file.put_line(FND_FILE.log,'getting l_err_cst_rec.count : '||l_err_cst_rec.count);
1990:
1991: For i in 1..l_err_cst_rec.count
1992: Loop
1993:

Line 1998: fnd_file.put_line

1994: /* select cost_id into l_err_cost_id
1995: from cs_cost_details
1996: where cost_id = l_err_cst_rec(i) ;*/
1997:
1998: fnd_file.put_line
1999: (
2000: FND_FILE.OUTPUT
2001: , '

'
2002: );

Line 2000: FND_FILE.OUTPUT

1996: where cost_id = l_err_cst_rec(i) ;*/
1997:
1998: fnd_file.put_line
1999: (
2000: FND_FILE.OUTPUT
2001: , '

'
2002: );
2003:
2004: l_text := '';
2008:
2009:
2010: fnd_file.put_line
2011: (
2012: FND_FILE.OUTPUT
2013: , ''||l_text||''
2014: );

Line 2012: FND_FILE.OUTPUT

2008:
2009:
2010: fnd_file.put_line
2011: (
2012: FND_FILE.OUTPUT
2013: , ''||l_text||''
2014: );
2015:
2016:

Line 2017: fnd_file.put_line (

2013: , ''||l_text||''
2014: );
2015:
2016:
2017: fnd_file.put_line (
2018: FND_FILE.OUTPUT
2019: , '

'
2020: );
2021:

Line 2018: FND_FILE.OUTPUT

2014: );
2015:
2016:
2017: fnd_file.put_line (
2018: FND_FILE.OUTPUT
2019: , ''
2020: );
2021:
2022: End loop;

Line 2033: fnd_file.put_line

2029:
2030: If l_succ_cst_rec.count > 0 then
2031:
2032:
2033: fnd_file.put_line
2034: (
2035: FND_FILE.OUTPUT
2036: , '

'||'Details of the Cost records that failed Insertion'||' '||'Details of the Cost records that failed Insertion'||'
'||'Cost Id'||'
'||'Cost Id'||''||'Service Request Number'||''||'Reject Reason'||' '||'Reject Reason'||'
' || l_err_cst_rec(i).cost_id

Line 2010: fnd_file.put_line

2006: || '

' || l_err_cst_rec(i).reject_reason
2007: || '
'
2037: ||''

Line 2035: FND_FILE.OUTPUT

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

'||'Details of the cost records that succeeded Insertion '||'
'
2037: ||''
2038: );
2039:

Line 2041: fnd_file.put_line

2037: ||'

'
2038: );
2039:
2040:
2041: fnd_file.put_line
2042: (
2043: FND_FILE.OUTPUT,'

'
2044: );
2045:

Line 2043: FND_FILE.OUTPUT,'

'

2039:
2040:
2041: fnd_file.put_line
2042: (
2043: FND_FILE.OUTPUT,'

'
2044: );
2045:
2046:
2047: /* fnd_file.put_line

Line 2047: /* fnd_file.put_line

2043: FND_FILE.OUTPUT,'

'
2044: );
2045:
2046:
2047: /* fnd_file.put_line
2048: (
2049: FND_FILE.OUTPUT
2050: , '

'
2051: ||''

Line 2049: FND_FILE.OUTPUT

2045:
2046:
2047: /* fnd_file.put_line
2048: (
2049: FND_FILE.OUTPUT
2050: , '

'
2051: ||''
2052: ||''
2053:

Line 2058: fnd_file.put_line

2054: );*/
2055:
2056:
2057:
2058: fnd_file.put_line
2059: (
2060: FND_FILE.OUTPUT
2061: , '

'
2062: ||''

Line 2060: FND_FILE.OUTPUT

2056:
2057:
2058: fnd_file.put_line
2059: (
2060: FND_FILE.OUTPUT
2061: , '

'
2062: ||''
2063: ||''
2064: ||''

Line 2079: fnd_file.put_line

2075: where cost_id = l_succ_cst_rec(i) ;*/
2076:
2077:
2078:
2079: fnd_file.put_line
2080: (
2081: FND_FILE.OUTPUT
2082: , '

'
2083: );

Line 2081: FND_FILE.OUTPUT

2077:
2078:
2079: fnd_file.put_line
2080: (
2081: FND_FILE.OUTPUT
2082: , '

'
2083: );
2084:
2085: /* l_text := '';
2091:
2092: fnd_file.put_line
2093: (
2094: FND_FILE.OUTPUT
2095: , ''||l_text||''
2096: );

Line 2094: FND_FILE.OUTPUT

2090: || '';
2091:
2092: fnd_file.put_line
2093: (
2094: FND_FILE.OUTPUT
2095: , ''||l_text||''
2096: );
2097:
2098:

Line 2099: fnd_file.put_line (

2095: , ''||l_text||''
2096: );
2097:
2098:
2099: fnd_file.put_line (
2100: FND_FILE.OUTPUT
2101: , '

'
2102: );
2103:

Line 2100: FND_FILE.OUTPUT

2096: );
2097:
2098:
2099: fnd_file.put_line (
2100: FND_FILE.OUTPUT
2101: , ''
2102: );
2103:
2104:

Line 2110: fnd_file.put_line

2106: End loop;
2107:
2108: End if;
2109:
2110: fnd_file.put_line
2111: (
2112: FND_FILE.OUTPUT
2113: , '

'||'Details of the cost records that succeeded Insertion '||' '||'Details of the cost records that succeeded Insertion '||'
'||'Cost Id'||'
'||'Cost Id'||'
'||'Cost Id'||'
'||'Cost Id'||''||'Service Request Number'||'
' || l_succ_cst_rec(i)

Line 2092: fnd_file.put_line

2088: l_text := '

 ' || l_succ_cst_rec(i).cost_id
2089: || '		' || l_succ_cst_rec(i).incident_number
2090: || '
' );
2114:

Line 2112: FND_FILE.OUTPUT

2108: End if;
2109:
2110: fnd_file.put_line
2111: (
2112: FND_FILE.OUTPUT
2113: , '' );
2114:
2115:
2116:

Line 2128: fnd_file.put_line(fnd_file.log,p_msg_data);

2124: 'WARNING'
2125: , SUBSTR(p_msg_data, 1, 240)
2126: );
2127:
2128: fnd_file.put_line(fnd_file.log,p_msg_data);
2129:
2130: WHEN l_interface_error then
2131:
2132: