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_TRX_SUMMARY_PKG dependencies on ARP_STANDARD

Line 1164: arp_standard.debug('arp_trx_summary_pkg.collect_customers()+');

1160: AND trx_date > add_months(sysdate, -24);
1161:
1162: l_rows NUMBER;
1163: BEGIN
1164: arp_standard.debug('arp_trx_summary_pkg.collect_customers()+');
1165: arp_standard.debug(' p_worker_number = ' || p_worker_number);
1166: arp_standard.debug(' p_list_size = ' || p_list_size);
1167:
1168: /* The processing of ar_trx_bal_summary requires all customers,

Line 1165: arp_standard.debug(' p_worker_number = ' || p_worker_number);

1161:
1162: l_rows NUMBER;
1163: BEGIN
1164: arp_standard.debug('arp_trx_summary_pkg.collect_customers()+');
1165: arp_standard.debug(' p_worker_number = ' || p_worker_number);
1166: arp_standard.debug(' p_list_size = ' || p_list_size);
1167:
1168: /* The processing of ar_trx_bal_summary requires all customers,
1169: but the one for ar_trx_summary only requires active customers.

Line 1166: arp_standard.debug(' p_list_size = ' || p_list_size);

1162: l_rows NUMBER;
1163: BEGIN
1164: arp_standard.debug('arp_trx_summary_pkg.collect_customers()+');
1165: arp_standard.debug(' p_worker_number = ' || p_worker_number);
1166: arp_standard.debug(' p_list_size = ' || p_list_size);
1167:
1168: /* The processing of ar_trx_bal_summary requires all customers,
1169: but the one for ar_trx_summary only requires active customers.
1170: So we can rebuild the list for each table separately and

Line 1198: arp_standard.debug(' p_cust_id(' || i || ') = ' || p_cust_id(i));

1194: VALUES(p_cust_id(i));
1195:
1196: /* FOR i IN p_cust_id.FIRST .. p_cust_id.LAST
1197: LOOP
1198: arp_standard.debug(' p_cust_id(' || i || ') = ' || p_cust_id(i));
1199: END LOOP; */
1200:
1201: END IF;
1202:

Line 1209: arp_standard.debug(' count of distinct customers = ' || l_rows);

1205: fnd_file.put_line(FND_FILE.LOG, ' worker ' || p_worker_number ||
1206: ' of ' || p_max_workers || ' number of customers: ' ||
1207: l_rows);
1208:
1209: arp_standard.debug(' count of distinct customers = ' || l_rows);
1210: arp_standard.debug('arp_trx_summary_pkg.collect_customers()-');
1211: END collect_customers;
1212:
1213:

Line 1210: arp_standard.debug('arp_trx_summary_pkg.collect_customers()-');

1206: ' of ' || p_max_workers || ' number of customers: ' ||
1207: l_rows);
1208:
1209: arp_standard.debug(' count of distinct customers = ' || l_rows);
1210: arp_standard.debug('arp_trx_summary_pkg.collect_customers()-');
1211: END collect_customers;
1212:
1213:
1214: /* 8784962 - Allow for call to this function that only clears

Line 1227: arp_standard.debug('Retrieved schema for AR : ' || l_schema);

1223: BEGIN
1224: IF FND_INSTALLATION.get_app_info('AR', l_status, l_industry, l_schema)
1225: THEN
1226: IF PG_DEBUG in ('Y', 'C') THEN
1227: arp_standard.debug('Retrieved schema for AR : ' || l_schema);
1228: END IF;
1229: ELSE
1230: IF PG_DEBUG in ('Y', 'C') THEN
1231: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');

Line 1231: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');

1227: arp_standard.debug('Retrieved schema for AR : ' || l_schema);
1228: END IF;
1229: ELSE
1230: IF PG_DEBUG in ('Y', 'C') THEN
1231: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');
1232: END IF;
1233: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.clear_summary_tables');
1234: RETURN;
1235: END IF;

Line 1233: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.clear_summary_tables');

1229: ELSE
1230: IF PG_DEBUG in ('Y', 'C') THEN
1231: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');
1232: END IF;
1233: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.clear_summary_tables');
1234: RETURN;
1235: END IF;
1236:
1237: arp_standard.debug('Table to clear = ' || p_table_to_clear);

Line 1237: arp_standard.debug('Table to clear = ' || p_table_to_clear);

1233: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.clear_summary_tables');
1234: RETURN;
1235: END IF;
1236:
1237: arp_standard.debug('Table to clear = ' || p_table_to_clear);
1238:
1239: /* If schema is set, clear the tables */
1240: IF l_schema IS NOT NULL
1241: THEN

Line 1244: arp_standard.debug('truncating table data');

1240: IF l_schema IS NOT NULL
1241: THEN
1242: IF PG_DEBUG in ('Y','C')
1243: THEN
1244: arp_standard.debug('truncating table data');
1245: END IF;
1246: IF p_table_to_clear IN ('A','B')
1247: THEN
1248: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.AR_TRX_BAL_SUMMARY';

Line 1263: arp_standard.debug('ar_trx_summary_pkg.clear_summary_by_customer()+');

1259: PROCEDURE clear_summary_by_customer(p_cust_id IN l_cust_id_type) IS
1260: BEGIN
1261: IF PG_DEBUG in ('Y','C')
1262: THEN
1263: arp_standard.debug('ar_trx_summary_pkg.clear_summary_by_customer()+');
1264: END IF;
1265:
1266: FORALL i IN 1..p_cust_id.COUNT
1267: DELETE FROM AR_TRX_BAL_SUMMARY

Line 1276: arp_standard.debug('ar_trx_summary_pkg.clear_summary_by_customer()-');

1272: WHERE cust_account_id = p_cust_id(i);
1273:
1274: IF PG_DEBUG in ('Y','C')
1275: THEN
1276: arp_standard.debug('ar_trx_summary_pkg.clear_summary_by_customer()-');
1277: END IF;
1278: END clear_summary_by_customer;
1279:
1280: PROCEDURE submit_child_workers(p_max_workers IN NUMBER,

Line 1290: arp_standard.debug('ar_trx_summary_pkg.submit_child_workers()+');

1286:
1287: BEGIN
1288: IF PG_DEBUG in ('Y','C')
1289: THEN
1290: arp_standard.debug('ar_trx_summary_pkg.submit_child_workers()+');
1291: END IF;
1292:
1293: FOR i IN 1..(p_max_workers - 1) LOOP
1294: l_reqid := FND_REQUEST.SUBMIT_REQUEST (

Line 1309: arp_standard.debug('ar_trx_summary_pkg.submit_child_workers()-');

1305: COMMIT;
1306:
1307: IF PG_DEBUG in ('Y','C')
1308: THEN
1309: arp_standard.debug('ar_trx_summary_pkg.submit_child_workers()-');
1310: END IF;
1311:
1312: END submit_child_workers;
1313:

Line 1322: arp_standard.debug('ar_trx_summary_pkg.submit_held_events()+');

1318:
1319: BEGIN
1320: IF PG_DEBUG in ('Y','C')
1321: THEN
1322: arp_standard.debug('ar_trx_summary_pkg.submit_held_events()+');
1323: END IF;
1324:
1325: l_reqid := FND_REQUEST.SUBMIT_REQUEST (
1326: application=>l_appl_short,

Line 1332: arp_standard.debug(' request_id = ' || l_reqid);

1328: sub_request=>FALSE);
1329:
1330: IF PG_DEBUG in ('Y','C')
1331: THEN
1332: arp_standard.debug(' request_id = ' || l_reqid);
1333: arp_standard.debug('ar_trx_summary_pkg.submit_held_events()-');
1334: END IF;
1335:
1336: END submit_held_events;

Line 1333: arp_standard.debug('ar_trx_summary_pkg.submit_held_events()-');

1329:
1330: IF PG_DEBUG in ('Y','C')
1331: THEN
1332: arp_standard.debug(' request_id = ' || l_reqid);
1333: arp_standard.debug('ar_trx_summary_pkg.submit_held_events()-');
1334: END IF;
1335:
1336: END submit_held_events;
1337:

Line 1343: arp_standard.debug('ar_trx_summary_pkg.block_events()+');

1339: p_request_id IN NUMBER) IS
1340: BEGIN
1341: IF PG_DEBUG in ('Y','C')
1342: THEN
1343: arp_standard.debug('ar_trx_summary_pkg.block_events()+');
1344: arp_standard.debug(' p_action = ' || p_action);
1345: arp_standard.debug(' p_request_id = ' || p_request_id);
1346: END IF;
1347:

Line 1344: arp_standard.debug(' p_action = ' || p_action);

1340: BEGIN
1341: IF PG_DEBUG in ('Y','C')
1342: THEN
1343: arp_standard.debug('ar_trx_summary_pkg.block_events()+');
1344: arp_standard.debug(' p_action = ' || p_action);
1345: arp_standard.debug(' p_request_id = ' || p_request_id);
1346: END IF;
1347:
1348: IF p_action = 'BLOCK'

Line 1345: arp_standard.debug(' p_request_id = ' || p_request_id);

1341: IF PG_DEBUG in ('Y','C')
1342: THEN
1343: arp_standard.debug('ar_trx_summary_pkg.block_events()+');
1344: arp_standard.debug(' p_action = ' || p_action);
1345: arp_standard.debug(' p_request_id = ' || p_request_id);
1346: END IF;
1347:
1348: IF p_action = 'BLOCK'
1349: THEN

Line 1361: arp_standard.debug('EXCEPTION: Invalid p_action value');

1357: AND REQUEST_ID = p_request_id;
1358: ELSE
1359: IF PG_DEBUG in ('Y','C')
1360: THEN
1361: arp_standard.debug('EXCEPTION: Invalid p_action value');
1362: END IF;
1363: END IF;
1364:
1365: COMMIT;

Line 1369: arp_standard.debug('ar_trx_summary_pkg.block_events()-');

1365: COMMIT;
1366:
1367: IF PG_DEBUG in ('Y','C')
1368: THEN
1369: arp_standard.debug('ar_trx_summary_pkg.block_events()-');
1370: END IF;
1371: END;
1372:
1373: PROCEDURE load_trx_bal_summary(p_cust_id IN l_cust_id_type)

Line 1378: arp_standard.debug('ar_trx_summary_pkg.load_trx_bal_summary()+');

1374: IS
1375: BEGIN
1376: IF PG_DEBUG in ('Y','C')
1377: THEN
1378: arp_standard.debug('ar_trx_summary_pkg.load_trx_bal_summary()+');
1379: END IF;
1380:
1381: FORALL i IN 1..p_cust_id.COUNT
1382: INSERT INTO AR_TRX_BAL_SUMMARY

Line 1611: arp_standard.debug('ar_trx_summary_pkg.load_trx_bal_summary()-');

1607: GROUP BY D.CUSTOMER_ID,D.CUSTOMER_SITE_USE_ID,D.CURRENCY_CODE,D.ORG_ID);
1608:
1609: IF PG_DEBUG in ('Y','C')
1610: THEN
1611: arp_standard.debug('ar_trx_summary_pkg.load_trx_bal_summary()-');
1612: END IF;
1613:
1614: END load_trx_bal_summary;
1615:

Line 1621: arp_standard.debug('ar_trx_summary_pkg.load_trx_summary()+');

1617: IS
1618: BEGIN
1619: IF PG_DEBUG in ('Y','C')
1620: THEN
1621: arp_standard.debug('ar_trx_summary_pkg.load_trx_summary()+');
1622: END IF;
1623:
1624: /* Dev Note: I think I can further simplify this code .. particularly
1625: the logic for:

Line 2024: arp_standard.debug('ar_trx_summary_pkg.load_trx_summary()-');

2020: D.as_of_date);
2021:
2022: IF PG_DEBUG in ('Y','C')
2023: THEN
2024: arp_standard.debug('ar_trx_summary_pkg.load_trx_summary()-');
2025: END IF;
2026: END load_trx_summary;
2027:
2028: PROCEDURE load_largest_inv_info

Line 2047: arp_standard.debug('ar_trx_summary_pkg.load_largest_inv_info()+');

2043:
2044: BEGIN
2045: IF PG_DEBUG in ('Y','C')
2046: THEN
2047: arp_standard.debug('ar_trx_summary_pkg.load_largest_inv_info()+');
2048: END IF;
2049:
2050: text_select :=
2051: 'SELECT customer_id, customer_site_use_id,

Line 2079: arp_standard.debug(text_select);

2075: WHERE rank_amount = 1';
2076:
2077: IF PG_DEBUG in ('Y','C')
2078: THEN
2079: arp_standard.debug(text_select);
2080: END IF;
2081:
2082: text_update := 'Update /*+ INDEX(ats AR_TRX_SUMMARY_U1) */ ar_trx_summary ats
2083: set LARGEST_INV_AMOUNT = :amount,

Line 2157: arp_standard.debug('ar_trx_summary_pkg.load_largest_inv_info()-');

2153: DBMS_SQL.CLOSE_CURSOR(v_cursor2);
2154:
2155: IF PG_DEBUG in ('Y','C')
2156: THEN
2157: arp_standard.debug('ar_trx_summary_pkg.load_largest_inv_info()-');
2158: END IF;
2159: END load_largest_inv_info;
2160:
2161: PROCEDURE load_high_watermark IS

Line 2178: arp_standard.debug('ar_trx_summary_pkg.load_high_watermark()+');

2174:
2175: BEGIN
2176: IF PG_DEBUG in ('Y','C')
2177: THEN
2178: arp_standard.debug('ar_trx_summary_pkg.load_high_watermark()+');
2179: END IF;
2180:
2181: /* 7518998 - Changed first subquery to UNION ALL, forced
2182: ra rows to be CASH, and completely removed CM app subquery */

Line 2257: arp_standard.debug(text_select);

2253: where as_of_date > add_months(sysdate , -24)';
2254:
2255: IF PG_DEBUG in ('Y','C')
2256: THEN
2257: arp_standard.debug(text_select);
2258: END IF;
2259:
2260: text_update :=
2261: 'Update /*+ INDEX(ats AR_TRX_SUMMARY_U1) */ ar_trx_summary ats

Line 2333: arp_standard.debug('ar_trx_summary_pkg.load_high_watermark()-');

2329: DBMS_SQL.CLOSE_CURSOR(v_cursor2);
2330:
2331: IF PG_DEBUG in ('Y','C')
2332: THEN
2333: arp_standard.debug('ar_trx_summary_pkg.load_high_watermark()-');
2334: END IF;
2335:
2336: END load_high_watermark;
2337:

Line 2354: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()+');

2350: l_return BOOLEAN;
2351: BEGIN
2352: IF PG_DEBUG in ('Y','C')
2353: THEN
2354: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()+');
2355: arp_standard.debug(' p_skip_secondary_processes = ' || p_skip_secondary_processes);
2356: END IF;
2357:
2358: /* Check profile, if set to N, then terminate program */

Line 2355: arp_standard.debug(' p_skip_secondary_processes = ' || p_skip_secondary_processes);

2351: BEGIN
2352: IF PG_DEBUG in ('Y','C')
2353: THEN
2354: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()+');
2355: arp_standard.debug(' p_skip_secondary_processes = ' || p_skip_secondary_processes);
2356: END IF;
2357:
2358: /* Check profile, if set to N, then terminate program */
2359: l_po_value := fnd_profile.value('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH');

Line 2367: arp_standard.debug(' AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH = N');

2363: fnd_file.put_line(fnd_file.log,
2364: 'The profile AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH = N');
2365: IF PG_DEBUG in ('Y','C')
2366: THEN
2367: arp_standard.debug(' AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH = N');
2368: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()-');
2369: END IF;
2370:
2371: retcode := SUCCESS;

Line 2368: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()-');

2364: 'The profile AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH = N');
2365: IF PG_DEBUG in ('Y','C')
2366: THEN
2367: arp_standard.debug(' AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH = N');
2368: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()-');
2369: END IF;
2370:
2371: retcode := SUCCESS;
2372: RETURN;

Line 2395: arp_standard.debug(' l_max_workers = ' || l_max_workers);

2391: END IF;
2392:
2393: IF PG_DEBUG in ('Y','C')
2394: THEN
2395: arp_standard.debug(' l_max_workers = ' || l_max_workers);
2396: arp_standard.debug(' l_worker_number = ' || l_worker_number);
2397: END IF;
2398:
2399: /* so now we should have l_max_workers as some integer

Line 2396: arp_standard.debug(' l_worker_number = ' || l_worker_number);

2392:
2393: IF PG_DEBUG in ('Y','C')
2394: THEN
2395: arp_standard.debug(' l_max_workers = ' || l_max_workers);
2396: arp_standard.debug(' l_worker_number = ' || l_worker_number);
2397: END IF;
2398:
2399: /* so now we should have l_max_workers as some integer
2400: and l_worker_number is zero for master and 1 through l_max_workers -1

Line 2492: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()-');

2488: COMMIT;
2489:
2490: IF PG_DEBUG in ('Y','C')
2491: THEN
2492: arp_standard.debug('ar_trx_summary_pkg.refresh_summary_data()-');
2493: END IF;
2494:
2495: retcode := SUCCESS;
2496: RETURN;

Line 2518: arp_standard.debug('ar_trx_summary_pkg.process_held_events()+');

2514: fnd_file.put_line(fnd_file.log,'arp_trx_summary_pkg.process_held_events()+');
2515:
2516: IF PG_DEBUG in ('Y','C')
2517: THEN
2518: arp_standard.debug('ar_trx_summary_pkg.process_held_events()+');
2519: END IF;
2520:
2521: /* Process the business events that have been raised running the run of this
2522: concurrent program so far */

Line 2604: arp_standard.debug('Retrieved schema for AR : ' || l_schema);

2600: /* Clean out the AR_SUM_REF_EVENT_HIST table */
2601: IF FND_INSTALLATION.get_app_info('AR', l_status, l_industry, l_schema)
2602: THEN
2603: IF PG_DEBUG in ('Y', 'C') THEN
2604: arp_standard.debug('Retrieved schema for AR : ' || l_schema);
2605: END IF;
2606: ELSE
2607: IF PG_DEBUG in ('Y', 'C') THEN
2608: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');

Line 2608: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');

2604: arp_standard.debug('Retrieved schema for AR : ' || l_schema);
2605: END IF;
2606: ELSE
2607: IF PG_DEBUG in ('Y', 'C') THEN
2608: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');
2609: END IF;
2610: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.process_held_events');
2611: RETURN;
2612: END IF;

Line 2610: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.process_held_events');

2606: ELSE
2607: IF PG_DEBUG in ('Y', 'C') THEN
2608: arp_standard.debug('Problem retrieving AR schema name from fnd_installation');
2609: END IF;
2610: arp_standard.debug('EXCEPTION: arp_trx_summary_pkg.process_held_events');
2611: RETURN;
2612: END IF;
2613:
2614: /* If schema is set, clear event table */

Line 2633: arp_standard.debug('ar_trx_summary_pkg.process_held_events()-');

2629: fnd_file.put_line(fnd_file.log,'arp_trx_summary_pkg.process_held_events()-');
2630:
2631: IF PG_DEBUG in ('Y','C')
2632: THEN
2633: arp_standard.debug('ar_trx_summary_pkg.process_held_events()-');
2634: END IF;
2635: END process_held_events;
2636:
2637: END AR_TRX_SUMMARY_PKG;