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.11.12000000.2 2007/10/19 14:01:51 spdixit ship $ */
3:
4:
5: -- comments

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

174: l_chunk VARCHAR2(32767);
175:
176: BEGIN
177:
178: debug('ar_cumulative_balance_report.process_clob(+)');
179:
180: -- get length of internal lob and open the dest. file.
181: l_clob_size := dbms_lob.getlength(p_xml_clob);
182:

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

209: END LOOP;
210:
211: fnd_file.new_line(fnd_file.output,1);
212:
213: debug('ar_cumulative_balance_report.process_clob(-)');
214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: debug('EXCEPTION: OTHERS process_clob');

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

239: WHERE sob.set_of_books_id = sys.set_of_books_id);
240:
241: BEGIN
242:
243: debug('ar_cumulative_balance_report.get_gl_account_segment(+)');
244:
245: OPEN segment;
246: FETCH segment INTO l_gl_account_segment;
247: CLOSE segment;

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

245: OPEN segment;
246: FETCH segment INTO l_gl_account_segment;
247: CLOSE segment;
248:
249: debug('ar_cumulative_balance_report.get_gl_account_segment(-)');
250: RETURN l_gl_account_segment;
251:
252: END get_gl_account_segment;
253:

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

257: l_update_stmt VARCHAR2(32767);
258:
259: BEGIN
260:
261: debug('ar_cumulative_balance_report.perform_updates(+)');
262:
263: -- update null trx number, type, date, currency for invoices and CMS.
264:
265: l_update_stmt :=

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

349: debug('update statement 1(b): ' || SQL%ROWCOUNT);
350:
351: COMMIT;
352:
353: debug('ar_cumulative_balance_report.perform_updates(-)');
354:
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: debug('EXCEPTION: NO_DATA_FOUND perform_updates');

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

409: AND sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
410:
411: BEGIN
412:
413: debug('ar_cumulative_balance_report.insert_dist_data(+)');
414: debug('start date: ' || to_char(p_start_date));
415: debug('end date: ' || to_char(p_end_date));
416: debug('status: ' || p_period_status);
417:

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

968: END LOOP;
969:
970: CLOSE l_ref_cursor;
971:
972: debug('ar_cumulative_balance_report.insert_dist_data(-)');
973:
974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: debug('EXCEPTION: NO_DATA_FOUND insert_dist_data');

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

1001: l_ret_param varchar2(2000);
1002:
1003: BEGIN
1004:
1005: debug('ar_cumulative_balance_report.flex_sql(+)');
1006:
1007: -- This is a wrapper function for the fa_rx_flex_pkg. When patch 4128137 is
1008: -- released, we need to replace this call with the corresponding
1009: -- FND API calls

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

1018: p_function => p_function,
1019: p_operand1 => p_operand1,
1020: p_operand2 => p_operand2);
1021:
1022: debug('ar_cumulative_balance_report.flex_sql(-)');
1023:
1024: RETURN l_ret_param;
1025:
1026: END flex_sql;

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

1036: l_seg_where VARCHAR2(4000);
1037:
1038: BEGIN
1039:
1040: debug('ar_cumulative_balance_report.get_seg_codition(+)');
1041:
1042: IF p_seg_low IS NULL AND p_seg_high IS NULL THEN
1043:
1044: l_seg_where := NULL;

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

1083: p_operand2 => p_seg_high);
1084:
1085: END IF;
1086:
1087: debug('ar_cumulative_balance_report.get_seg_codition(-)');
1088:
1089: RETURN l_seg_where;
1090:
1091: END get_seg_condition;

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

1110: l_max_end_date DATE;
1111:
1112: BEGIN
1113:
1114: debug('ar_cumulative_balance_report.populate_ccids(+)');
1115: debug('p_coa_id : ' || p_coa_id);
1116: debug('p_co_seg_low : ' || p_co_seg_low );
1117: debug('p_co_seg_high : ' || p_co_seg_high);
1118: debug('p_gl_account_low : ' || p_gl_account_low);

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

1168: EXECUTE IMMEDIATE l_sql_stmt ;
1169:
1170: debug('number of rows inserted: ' || SQL%ROWCOUNT);
1171:
1172: debug('ar_cumulative_balance_report.populate_ccids(-)');
1173:
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: debug('EXCEPTION: NO_DATA_FOUND populate_ccids');

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

1196: l_sql_stmt VARCHAR2(4000);
1197:
1198: BEGIN
1199:
1200: debug('ar_cumulative_balance_report.refresh_verdict(+)');
1201:
1202: l_sql_stmt := 'SELECT count(*), max(trx_date), max(activity_gl_date)
1203: FROM ar_base_gl_acct_balances bal WHERE 1=1 ' ;
1204:

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

1217: IF ( (l_num_rows = 0) OR
1218: (p_gl_as_of_date < l_max_trx_date) OR
1219: (p_gl_as_of_date < l_max_activity_date)) THEN
1220:
1221: debug('ar_cumulative_balance_report.refresh_verdict(-)');
1222: RETURN 'Y';
1223:
1224: END IF;
1225:

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

1222: RETURN 'Y';
1223:
1224: END IF;
1225:
1226: debug('ar_cumulative_balance_report.refresh_verdict(-)');
1227: RETURN 'N';
1228:
1229: END refresh_verdict;
1230:

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

1261: WHERE closing_status = 'C';
1262:
1263: BEGIN
1264:
1265: debug('ar_cumulative_balance_report.populate_data(+)');
1266: debug('p_reporting_level : ' || p_reporting_level);
1267: debug('p_reporting_entity_id : ' || p_reporting_entity_id);
1268: debug('p_reporting_format : ' || p_reporting_format);
1269: debug('p_sob_id : ' || p_sob_id);

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

1432: debug('Number of rows deleted: ' || SQL%ROWCOUNT);
1433:
1434: COMMIT;
1435:
1436: debug('ar_cumulative_balance_report.populate_data(-)');
1437:
1438: EXCEPTION
1439: WHEN NO_DATA_FOUND THEN
1440: debug('EXCEPTION: NO_DATA_FOUND populate_data');

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

1466: from ar_system_parameters;
1467:
1468: BEGIN
1469:
1470: debug('ar_cumulative_balance_report.init(+)');
1471:
1472: IF p_set_of_books_id <> -1999 THEN
1473: OPEN sob_type;
1474: FETCH sob_type INTO l_mrc_sob_type_code;

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

1550: g_ar_transaction_history_all := 'ar_transaction_history_all br';
1551:
1552: END IF;
1553:
1554: debug('ar_cumulative_balance_report.init(-)');
1555:
1556: END init;
1557:
1558:

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

1631: AND lookup_type ='ALL';
1632:
1633: BEGIN
1634:
1635: debug('ar_cumulative_balance_report.generate_xml()+');
1636: debug('p_reporting_level : ' || p_reporting_level);
1637: debug('p_reporting_entity_id : ' || p_reporting_entity_id);
1638: debug('p_reporting_format : ' || p_reporting_format);
1639: debug('p_sob_id : ' || p_sob_id);

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

2017: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2018: process_clob(tempResult);
2019: p_result := tempResult;
2020:
2021: debug('ar_cumulative_balance_report.generate_xml()-');
2022:
2023: EXCEPTION
2024: WHEN NO_DATA_FOUND THEN
2025: debug('EXCEPTION: NO_DATA_FOUND generate_xml');

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

2042: NULL;
2043:
2044: EXCEPTION
2045: WHEN NO_DATA_FOUND THEN
2046: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2047: RAISE;
2048:
2049: WHEN OTHERS THEN
2050: debug('EXCEPTION: ar_cumulative_balance_report.initialize');

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

2046: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2047: RAISE;
2048:
2049: WHEN OTHERS THEN
2050: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2051: RAISE;
2052:
2053: END ar_cumulative_balance_report;

Line 2053: END ar_cumulative_balance_report;

2049: WHEN OTHERS THEN
2050: debug('EXCEPTION: ar_cumulative_balance_report.initialize');
2051: RAISE;
2052:
2053: END ar_cumulative_balance_report;