DBA Data[Home] [Help]

APPS.CN_INVOICE_CHANGES_PVT dependencies on CN_MESSAGE_PKG

Line 1916: cn_message_pkg.begin_batch(

1912: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1913: --
1914: BEGIN
1915: --
1916: cn_message_pkg.begin_batch(
1917: x_parent_proc_audit_id => NULL,
1918: x_process_audit_id => l_process_audit_id,
1919: x_request_id => fnd_global.conc_request_id,
1920: x_process_type => 'INVLOAD',

Line 1924: cn_message_pkg.write(

1920: x_process_type => 'INVLOAD',
1921: p_org_id => 204
1922: );
1923: --
1924: cn_message_pkg.write(
1925: p_message_text => 'Starting Invoice Capture Batch Program',
1926: p_message_type => 'MILESTONE');
1927: --
1928: l_adjust_comments := 'Negated during Invoice Split Batch Program Execution';

Line 1932: cn_message_pkg.write(

1928: l_adjust_comments := 'Negated during Invoice Split Batch Program Execution';
1929: x_errbuf := '';
1930: x_retcode := 0;
1931: --
1932: cn_message_pkg.write(
1933: p_message_text => 'Capturing New Invoices Cursor Start',
1934: p_message_type => 'MILESTONE');
1935: --
1936: IF (g_track_invoice = 'Y') THEN

Line 1942: cn_message_pkg.write(

1938: LOOP
1939: --
1940: l_counter := l_counter + 1;
1941: --
1942: cn_message_pkg.write(
1943: p_message_text => 'Record-'||l_counter||' '||
1944: 'api_id:'||c1_rec.comm_lines_api_id||'; '||
1945: 'rep:'||c1_rec.salesrep_id||'; '||
1946: 'invoice:'||c1_rec.invoice_number||'; '||

Line 1971: cn_message_pkg.write(

1967: WHERE comm_lines_api_id = c1_rec.comm_lines_api_id;
1968: --
1969: END LOOP;
1970: --
1971: cn_message_pkg.write(
1972: p_message_text => 'Total Number Of New Invoices Captured: '||l_counter,
1973: p_message_type => 'MILESTONE');
1974: --
1975: FOR l_cm_pmt_count IN 1..2

Line 1985: cn_message_pkg.write(

1981: END IF;
1982: l_counter := 0;
1983: l_negate_counter := 0;
1984: --
1985: cn_message_pkg.write(
1986: p_message_text => 'Capturing '||l_trx_type||' Cursor Start',
1987: p_message_type => 'MILESTONE');
1988: --
1989: FOR c2_rec IN c2(l_trx_type)

Line 1999: cn_message_pkg.write(

1995: LOOP
1996: --
1997: l_negate_counter := l_negate_counter + 1;
1998: --
1999: cn_message_pkg.write(
2000: p_message_text =>
2001: 'NEGATING '||l_trx_type||' : Record-'||l_negate_counter||' '||
2002: 'api_id:'||api_rec.comm_lines_api_id||'; '||
2003: 'rep:'||api_rec.salesrep_id||'; '||

Line 2187: cn_message_pkg.write(

2183: l_api_rec.sales_channel := l_adj_tbl(1).sales_channel;
2184: --
2185: cn_comm_lines_api_pkg.insert_row(l_api_rec);
2186: --
2187: cn_message_pkg.write(
2188: p_message_text =>
2189: 'Creating '||l_trx_type||' : Record-'||l_counter||' '||
2190: 'api_id:'||l_comm_lines_api_id,
2191: p_message_type => 'MILESTONE');

Line 2196: cn_message_pkg.write(

2192: END IF;
2193: END LOOP;
2194: END LOOP;
2195: --
2196: cn_message_pkg.write(
2197: p_message_text => 'Total Records Negated for '||
2198: l_trx_type ||':'||l_negate_counter,
2199: p_message_type => 'MILESTONE');
2200: --

Line 2201: cn_message_pkg.write(

2197: p_message_text => 'Total Records Negated for '||
2198: l_trx_type ||':'||l_negate_counter,
2199: p_message_type => 'MILESTONE');
2200: --
2201: cn_message_pkg.write(
2202: p_message_text => 'Total Number Of New '||l_trx_type||
2203: ' Created:'||l_counter,
2204: p_message_type => 'MILESTONE');
2205: --

Line 2209: cn_message_pkg.write(

2205: --
2206: END LOOP;
2207: END IF;
2208: --
2209: cn_message_pkg.write(
2210: p_message_text => 'Ending Invoice Capture Batch Program',
2211: p_message_type => 'MILESTONE');
2212: --
2213: cn_message_pkg.end_batch(

Line 2213: cn_message_pkg.end_batch(

2209: cn_message_pkg.write(
2210: p_message_text => 'Ending Invoice Capture Batch Program',
2211: p_message_type => 'MILESTONE');
2212: --
2213: cn_message_pkg.end_batch(
2214: x_process_audit_id => l_process_audit_id);
2215: --
2216: EXCEPTION
2217: WHEN OTHERS THEN

Line 2221: cn_message_pkg.write(

2217: WHEN OTHERS THEN
2218: --
2219: ROLLBACK;
2220: --
2221: cn_message_pkg.write(
2222: p_message_text => 'Error Occured In The Batch Process',
2223: p_message_type => 'ERROR');
2224: --
2225: cn_message_pkg.write(

Line 2225: cn_message_pkg.write(

2221: cn_message_pkg.write(
2222: p_message_text => 'Error Occured In The Batch Process',
2223: p_message_type => 'ERROR');
2224: --
2225: cn_message_pkg.write(
2226: p_message_text => SQLERRM,
2227: p_message_type => 'ERROR');
2228: --
2229: x_errbuf := 'ERROR';

Line 2232: cn_message_pkg.end_batch(

2228: --
2229: x_errbuf := 'ERROR';
2230: x_retcode := 1;
2231: --
2232: cn_message_pkg.end_batch(
2233: x_process_audit_id => l_process_audit_id);
2234: --
2235: END;
2236: --