eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_CUMULATIVE_BALANCE_REPORT

Line 1: PACKAGE BODY ar_cumulative_balance_report AS

1: PACKAGE BODY ar_cumulative_balance_report AS
2: /* $Header: ARXCUABB.pls 120.14.12020000.2 2012/07/24 07:05:01 kkikkise ship $ */
3:
4:
5: -- comments

Line 182: debug('ar_cumulative_balance_report.process_clob(+)');

178: l_offset_temp number;
179:
180: BEGIN
181:
182: debug('ar_cumulative_balance_report.process_clob(+)');
183:
184: -- get length of internal lob and open the dest. file.
185: l_clob_size := dbms_lob.getlength(p_xml_clob);
186:

Line 239: debug('ar_cumulative_balance_report.process_clob(-)');

235: END LOOP;
236:
237: fnd_file.new_line(fnd_file.output,1);
238:
239: debug('ar_cumulative_balance_report.process_clob(-)');
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: debug('EXCEPTION: OTHERS process_clob');

Line 269: debug('ar_cumulative_balance_report.get_gl_account_segment(+)');

265: WHERE sob.set_of_books_id = sys.set_of_books_id);
266:
267: BEGIN
268:
269: debug('ar_cumulative_balance_report.get_gl_account_segment(+)');
270:
271: OPEN segment;
272: FETCH segment INTO l_gl_account_segment;
273: CLOSE segment;

Line 275: debug('ar_cumulative_balance_report.get_gl_account_segment(-)');

271: OPEN segment;
272: FETCH segment INTO l_gl_account_segment;
273: CLOSE segment;
274:
275: debug('ar_cumulative_balance_report.get_gl_account_segment(-)');
276: RETURN l_gl_account_segment;
277:
278: END get_gl_account_segment;
279:

Line 287: debug('ar_cumulative_balance_report.perform_updates(+)');

283: l_update_stmt VARCHAR2(32767);
284:
285: BEGIN
286:
287: debug('ar_cumulative_balance_report.perform_updates(+)');
288:
289: -- update null trx number, type, date, currency for invoices and CMS.
290:
291: l_update_stmt :=

Line 379: debug('ar_cumulative_balance_report.perform_updates(-)');

375: debug('update statement 1(b): ' || SQL%ROWCOUNT);
376:
377: COMMIT;
378:
379: debug('ar_cumulative_balance_report.perform_updates(-)');
380:
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN
383: debug('EXCEPTION: NO_DATA_FOUND perform_updates');

Line 439: debug('ar_cumulative_balance_report.insert_dist_data(+)');

435: AND sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
436:
437: BEGIN
438:
439: debug('ar_cumulative_balance_report.insert_dist_data(+)');
440: debug('start date: ' || to_char(p_start_date));
441: debug('end date: ' || to_char(p_end_date));
442: debug('status: ' || p_period_status);
443:

Line 998: debug('ar_cumulative_balance_report.insert_dist_data(-)');

994: END LOOP;
995:
996: CLOSE l_ref_cursor;
997:
998: debug('ar_cumulative_balance_report.insert_dist_data(-)');
999:
1000: EXCEPTION
1001: WHEN NO_DATA_FOUND THEN
1002: debug('EXCEPTION: NO_DATA_FOUND insert_dist_data');

Line 1031: debug('ar_cumulative_balance_report.flex_sql(+)');

1027: l_ret_param varchar2(2000);
1028:
1029: BEGIN
1030:
1031: debug('ar_cumulative_balance_report.flex_sql(+)');
1032:
1033: -- This is a wrapper function for the fa_rx_flex_pkg. When patch 4128137 is
1034: -- released, we need to replace this call with the corresponding
1035: -- FND API calls

Line 1048: debug('ar_cumulative_balance_report.flex_sql(-)');

1044: p_function => p_function,
1045: p_operand1 => p_operand1,
1046: p_operand2 => p_operand2);
1047:
1048: debug('ar_cumulative_balance_report.flex_sql(-)');
1049:
1050: RETURN l_ret_param;
1051:
1052: END flex_sql;

Line 1066: debug('ar_cumulative_balance_report.get_seg_codition(+)');

1062: l_seg_where VARCHAR2(4000);
1063:
1064: BEGIN
1065:
1066: debug('ar_cumulative_balance_report.get_seg_codition(+)');
1067:
1068: IF p_seg_low IS NULL AND p_seg_high IS NULL THEN
1069:
1070: l_seg_where := NULL;

Line 1113: debug('ar_cumulative_balance_report.get_seg_codition(-)');

1109: p_operand2 => p_seg_high);
1110:
1111: END IF;
1112:
1113: debug('ar_cumulative_balance_report.get_seg_codition(-)');
1114:
1115: RETURN l_seg_where;
1116:
1117: END get_seg_condition;

Line 1140: debug('ar_cumulative_balance_report.populate_ccids(+)');

1136: l_max_end_date DATE;
1137: l_segment_str VARCHAR2(2000);
1138: BEGIN
1139:
1140: debug('ar_cumulative_balance_report.populate_ccids(+)');
1141: debug('p_coa_id : ' || p_coa_id);
1142: debug('p_co_seg_low : ' || p_co_seg_low );
1143: debug('p_co_seg_high : ' || p_co_seg_high);
1144: debug('p_gl_account_low : ' || p_gl_account_low);

Line 1201: debug('ar_cumulative_balance_report.populate_ccids(-)');

1197: debug('number of rows inserted: ' || SQL%ROWCOUNT);
1198:
1199: fnd_stats.gather_table_stats('AR', 'AR_CCID_BY_GL_ACCOUNTS');
1200:
1201: debug('ar_cumulative_balance_report.populate_ccids(-)');
1202:
1203: EXCEPTION
1204: WHEN NO_DATA_FOUND THEN
1205: debug('EXCEPTION: NO_DATA_FOUND populate_ccids');

Line 1229: debug('ar_cumulative_balance_report.refresh_verdict(+)');

1225: l_sql_stmt VARCHAR2(4000);
1226:
1227: BEGIN
1228:
1229: debug('ar_cumulative_balance_report.refresh_verdict(+)');
1230:
1231: l_sql_stmt := 'SELECT count(*), max(trx_date), max(activity_gl_date)
1232: FROM ar_base_gl_acct_balances bal WHERE 1=1 ' ;
1233:

Line 1250: debug('ar_cumulative_balance_report.refresh_verdict(-)');

1246: IF ( (l_num_rows = 0) OR
1247: (p_gl_as_of_date < l_max_trx_date) OR
1248: (p_gl_as_of_date < l_max_activity_date)) THEN
1249:
1250: debug('ar_cumulative_balance_report.refresh_verdict(-)');
1251: RETURN 'Y';
1252:
1253: END IF;
1254:

Line 1255: debug('ar_cumulative_balance_report.refresh_verdict(-)');

1251: RETURN 'Y';
1252:
1253: END IF;
1254:
1255: debug('ar_cumulative_balance_report.refresh_verdict(-)');
1256: RETURN 'N';
1257:
1258: END refresh_verdict;
1259:

Line 1294: debug('ar_cumulative_balance_report.populate_data(+)');

1290: WHERE closing_status = 'C';
1291:
1292: BEGIN
1293:
1294: debug('ar_cumulative_balance_report.populate_data(+)');
1295: debug('p_reporting_level : ' || p_reporting_level);
1296: debug('p_reporting_entity_id : ' || p_reporting_entity_id);
1297: debug('p_reporting_format : ' || p_reporting_format);
1298: debug('p_sob_id : ' || p_sob_id);

Line 1465: debug('ar_cumulative_balance_report.populate_data(-)');

1461: debug('Number of rows deleted: ' || SQL%ROWCOUNT);
1462:
1463: COMMIT;
1464:
1465: debug('ar_cumulative_balance_report.populate_data(-)');
1466:
1467: EXCEPTION
1468: WHEN NO_DATA_FOUND THEN
1469: debug('EXCEPTION: NO_DATA_FOUND populate_data');

Line 1499: debug('ar_cumulative_balance_report.init(+)');

1495: from ar_system_parameters;
1496:
1497: BEGIN
1498:
1499: debug('ar_cumulative_balance_report.init(+)');
1500:
1501: IF p_set_of_books_id <> -1999 THEN
1502: OPEN sob_type;
1503: FETCH sob_type INTO l_mrc_sob_type_code;

Line 1583: debug('ar_cumulative_balance_report.init(-)');

1579: g_ar_transaction_history_all := 'ar_transaction_history_all br';
1580:
1581: END IF;
1582:
1583: debug('ar_cumulative_balance_report.init(-)');
1584:
1585: END init;
1586:
1587:

Line 1664: debug('ar_cumulative_balance_report.generate_xml()+');

1660: AND lookup_type ='ALL';
1661:
1662: BEGIN
1663:
1664: debug('ar_cumulative_balance_report.generate_xml()+');
1665: debug('p_reporting_level : ' || p_reporting_level);
1666: debug('p_reporting_entity_id : ' || p_reporting_entity_id);
1667: debug('p_reporting_format : ' || p_reporting_format);
1668: debug('p_sob_id : ' || p_sob_id);

Line 2050: debug('ar_cumulative_balance_report.generate_xml()-');

2046: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2047: process_clob(tempResult);
2048: p_result := tempResult;
2049:
2050: debug('ar_cumulative_balance_report.generate_xml()-');
2051:
2052: EXCEPTION
2053: WHEN NO_DATA_FOUND THEN
2054: debug('EXCEPTION: NO_DATA_FOUND generate_xml');

Line 2075: debug('EXCEPTION: ar_cumulative_balance_report.initialize');

2071: NULL;
2072:
2073: EXCEPTION
2074: WHEN NO_DATA_FOUND THEN
2075: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2076: RAISE;
2077:
2078: WHEN OTHERS THEN
2079: debug('EXCEPTION: ar_cumulative_balance_report.initialize');

Line 2079: debug('EXCEPTION: ar_cumulative_balance_report.initialize');

2075: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2076: RAISE;
2077:
2078: WHEN OTHERS THEN
2079: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2080: RAISE;
2081:
2082: END ar_cumulative_balance_report;

Line 2082: END ar_cumulative_balance_report;

2078: WHEN OTHERS THEN
2079: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2080: RAISE;
2081:
2082: END ar_cumulative_balance_report;