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_AGING_BUCKETS_PKG dependencies on AR_AGING_BUCKETS_PKG

Line 1: PACKAGE BODY AR_AGING_BUCKETS_PKG AS

1: PACKAGE BODY AR_AGING_BUCKETS_PKG AS
2: /* $Header: ARAGBKTB.pls 120.9.12020000.2 2012/07/26 03:59:48 jatian ship $ */
3:
4:
5: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 211: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()+');

207: ';
208:
209: BEGIN
210: IF PG_DEBUG in ('Y', 'C') THEN
211: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()+');
212: END IF;
213:
214: FOR buc_rec IN buc_info_cur LOOP
215: IF buc_rec.report_heading2 IS NULL THEN

Line 237: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()-');

233:
234: END LOOP;
235:
236: IF PG_DEBUG in ('Y', 'C') THEN
237: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()-');
238: END IF;
239:
240: RETURN l_report_heading;
241:

Line 246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_report_heading()');

242: EXCEPTION
243: WHEN OTHERS THEN
244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_standard.debug( ' Exception '||SQLERRM);
246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_report_heading()');
247: END IF;
248: RAISE;
249: END get_report_heading;
250:

Line 278: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_parent_request_id()+');

274: l_request_id NUMBER;
275:
276: BEGIN
277: IF PG_DEBUG in ('Y', 'C') THEN
278: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_parent_request_id()+');
279: arp_standard.debug( 'p_request_id :'||p_request_id);
280: END IF;
281:
282: SELECT parent_request_id

Line 297: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_parent_request_id()');

293: EXCEPTION
294: WHEN OTHERS THEN
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_standard.debug( ' Exception '||SQLERRM);
297: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_parent_request_id()');
298: END IF;
299: RAISE;
300: END get_parent_request_id;
301:

Line 330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');

326: p_info_type VARCHAR2) RETURN VARCHAR2 IS
327:
328: BEGIN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');
331: arp_standard.debug( 'p_site_use_id :'||p_site_use_id);
332: arp_standard.debug( 'p_info_type :'||p_info_type);
333: arp_standard.debug( 'pg_temp_site_use_id :'||pg_temp_site_use_id);
334: END IF;

Line 410: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()-');

406:
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug( 'pg_temp_contact_name '||pg_temp_contact_name);
409: arp_standard.debug( 'pg_temp_contact_phone '||pg_temp_contact_phone);
410: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()-');
411: END IF;
412:
413: IF p_info_type = 'NAME' THEN
414: RETURN pg_temp_contact_name;

Line 423: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_contact_information()');

419: EXCEPTION
420: WHEN OTHERS THEN
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_standard.debug( 'Exception message '||SQLERRM);
423: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_contact_information()');
424: END IF;
425: RETURN NULL;
426: END get_contact_information;
427:

Line 917: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()+');

913: l_xml_header VARCHAR2(32000);
914:
915: BEGIN
916: IF PG_DEBUG in ('Y', 'C') THEN
917: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()+');
918: END IF;
919:
920: IF to_number(pg_reporting_level) = 1000 AND
921: mo_utils.check_ledger_in_sp(TO_NUMBER(pg_reporting_entity_id)) = 'N' THEN

Line 955: '||pg_risk_meaning||''||AR_AGING_BUCKETS_PKG.get_report_heading();

951: '||pg_in_invoice_type_low||'
952: '||pg_in_invoice_type_high||'
953: '||pg_cons_profile_value||'
954: '||pg_functional_currency||'
955: '||pg_risk_meaning||''||AR_AGING_BUCKETS_PKG.get_report_heading();
956:
957: IF PG_DEBUG in ('Y', 'C') THEN
958: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()-');
959: END IF;

Line 958: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()-');

954: '||pg_functional_currency||'
955: '||pg_risk_meaning||''||AR_AGING_BUCKETS_PKG.get_report_heading();
956:
957: IF PG_DEBUG in ('Y', 'C') THEN
958: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()-');
959: END IF;
960:
961: RETURN l_xml_header;
962:

Line 966: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_report_header_xml()');

962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: arp_standard.debug( 'Exception message '||SQLERRM);
966: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_report_header_xml()');
967: RETURN NULL;
968: END get_report_header_xml;
969:
970:

Line 998: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');

994: l_sys_query VARCHAR2(20000);
995:
996: BEGIN
997: IF PG_DEBUG in ('Y', 'C') THEN
998: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');
999: END IF;
1000:
1001: l_sys_query := '
1002: SELECT param.org_id,

Line 1033: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');

1029: USING pg_in_currency;
1030:
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_standard.debug( ' Rows returned '||SQL%ROWCOUNT);
1033: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');
1034: END IF;
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1040: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.populate_setup_information()');

1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_standard.debug( ' Exception '||SQLERRM);
1040: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.populate_setup_information()');
1041: END IF;
1042: RAISE;
1043: END populate_setup_information;
1044:

Line 1074: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()+');

1070: PROCEDURE initialize_package_globals IS
1071: BEGIN
1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()+');
1075: END IF;
1076:
1077: XLA_MO_REPORTING_API.Initialize(pg_reporting_level, pg_reporting_entity_id, 'AUTO');
1078:

Line 1102: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1098:
1099:
1100: /* Replace the variables to bind with the function calls so that we don't have to bind those */
1101: pg_org_where_ps := replace(pg_org_where_ps,
1102: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1103: pg_org_where_gld := replace(pg_org_where_gld,
1104: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1105: pg_org_where_ct := replace(pg_org_where_ct,
1106: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1104: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1100: /* Replace the variables to bind with the function calls so that we don't have to bind those */
1101: pg_org_where_ps := replace(pg_org_where_ps,
1102: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1103: pg_org_where_gld := replace(pg_org_where_gld,
1104: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1105: pg_org_where_ct := replace(pg_org_where_ct,
1106: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1107: pg_org_where_sales := replace(pg_org_where_sales,
1108: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1106: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1102: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1103: pg_org_where_gld := replace(pg_org_where_gld,
1104: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1105: pg_org_where_ct := replace(pg_org_where_ct,
1106: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1107: pg_org_where_sales := replace(pg_org_where_sales,
1108: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1109: pg_org_where_ct2 := replace(pg_org_where_ct2,
1110: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1108: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1104: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1105: pg_org_where_ct := replace(pg_org_where_ct,
1106: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1107: pg_org_where_sales := replace(pg_org_where_sales,
1108: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1109: pg_org_where_ct2 := replace(pg_org_where_ct2,
1110: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1111: pg_org_where_adj := replace(pg_org_where_adj,
1112: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1110: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1106: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1107: pg_org_where_sales := replace(pg_org_where_sales,
1108: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1109: pg_org_where_ct2 := replace(pg_org_where_ct2,
1110: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1111: pg_org_where_adj := replace(pg_org_where_adj,
1112: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1113: pg_org_where_app := replace(pg_org_where_app,
1114: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1112: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1108: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1109: pg_org_where_ct2 := replace(pg_org_where_ct2,
1110: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1111: pg_org_where_adj := replace(pg_org_where_adj,
1112: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1113: pg_org_where_app := replace(pg_org_where_app,
1114: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1115: pg_org_where_crh := replace(pg_org_where_crh,
1116: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1114: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1110: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1111: pg_org_where_adj := replace(pg_org_where_adj,
1112: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1113: pg_org_where_app := replace(pg_org_where_app,
1114: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1115: pg_org_where_crh := replace(pg_org_where_crh,
1116: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1117: pg_org_where_ra := replace(pg_org_where_ra,
1118: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1116: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1112: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1113: pg_org_where_app := replace(pg_org_where_app,
1114: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1115: pg_org_where_crh := replace(pg_org_where_crh,
1116: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1117: pg_org_where_ra := replace(pg_org_where_ra,
1118: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1119: pg_org_where_cr := replace(pg_org_where_cr,
1120: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1118: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1114: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1115: pg_org_where_crh := replace(pg_org_where_crh,
1116: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1117: pg_org_where_ra := replace(pg_org_where_ra,
1118: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1119: pg_org_where_cr := replace(pg_org_where_cr,
1120: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1121: pg_org_where_sys_param := replace(pg_org_where_sys_param,
1122: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

Line 1120: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1116: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1117: pg_org_where_ra := replace(pg_org_where_ra,
1118: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1119: pg_org_where_cr := replace(pg_org_where_cr,
1120: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1121: pg_org_where_sys_param := replace(pg_org_where_sys_param,
1122: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1123:
1124: IF PG_DEBUG in ('Y', 'C') THEN

Line 1122: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');

1118: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1119: pg_org_where_cr := replace(pg_org_where_cr,
1120: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1121: pg_org_where_sys_param := replace(pg_org_where_sys_param,
1122: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1123:
1124: IF PG_DEBUG in ('Y', 'C') THEN
1125: arp_standard.debug( ' Populating balancing segment strings.. ');
1126: END IF;

Line 1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');

1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_standard.debug( ' pg_short_unid_phrase :'||pg_short_unid_phrase);
1238: arp_standard.debug( ' pg_payment_meaning :'||pg_payment_meaning);
1239: arp_standard.debug( ' pg_risk_meaning :'||pg_risk_meaning);
1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');
1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN

Line 1246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.initialize_package_globals()');

1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: arp_standard.debug( ' Exception '||SQLERRM);
1246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.initialize_package_globals()');
1247: RAISE;
1248: END initialize_package_globals;
1249:
1250:

Line 1274: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()+');

1270: *==========================================================================*/
1271: PROCEDURE cleanup_staging_tables IS
1272: BEGIN
1273: IF PG_DEBUG in ('Y', 'C') THEN
1274: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()+');
1275: arp_standard.debug( 'pg_retain_staging_flag :'||pg_retain_staging_flag );
1276: END IF;
1277:
1278: DELETE

Line 1291: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()-');

1287: FROM ar_aging_mfar_extract
1288: WHERE parent_request_id = pg_request_id;
1289:
1290: IF PG_DEBUG in ('Y', 'C') THEN
1291: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()-');
1292: END IF;
1293: END cleanup_staging_tables;
1294:
1295:

Line 1339: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()+');

1335: l_stmt_cursor INTEGER;
1336: l_rows_processed NUMBER;
1337: BEGIN
1338: IF PG_DEBUG in ('Y', 'C') THEN
1339: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()+');
1340: END IF;
1341:
1342: IF PG_DEBUG in ('Y', 'C') THEN
1343: arp_standard.debug( 'Deleting existing data for parent_request_id:'||pg_request_id);

Line 1528: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');

1524: END IF;
1525:
1526: IF PG_DEBUG in ('Y', 'C') THEN
1527: arp_standard.debug( 'rows inserted into staging table:'||l_rows_processed);
1528: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN

Line 1534: arp_standard.debug( 'In AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');

1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: arp_standard.debug( 'Exception : '||SQLERRM );
1534: arp_standard.debug( 'In AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');
1535: RAISE;
1536: END alloc_aging_payment_schedules;
1537:
1538:

Line 1580: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()+');

1576: /*Only verified the flow related to aging by account report,need verify and replace the
1577: lexical parameters and test the complete flow when we decide to migrate all these
1578: reports(reports like ARXAGR ,ARXAGL and ARXAGS)*/
1579: IF PG_DEBUG in ('Y', 'C') THEN
1580: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()+');
1581: arp_standard.debug( 'p_qry_category '||p_qry_category);
1582: END IF;
1583:
1584: --report specific subquery

Line 1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');

1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );
1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1784: END IF;
1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN

Line 1789: arp_standard.debug( 'Exception :AR_AGING_BUCKETS_PKG.get_report_specific_info()-');

1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: arp_standard.debug( 'Exception '||SQLERRM);
1789: arp_standard.debug( 'Exception :AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1790: RAISE;
1791: END get_report_specific_info;
1792:
1793:

Line 1848: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()+');

1844:
1845:
1846: BEGIN
1847: IF PG_DEBUG in ('Y', 'C') THEN
1848: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()+');
1849: arp_standard.debug( 'p_cursor :'||p_cursor);
1850: END IF;
1851:
1852: FOR buc_rec IN buc_info_cur LOOP

Line 1872: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()-');

1868: END LOOP;
1869:
1870:
1871: IF PG_DEBUG in ('Y', 'C') THEN
1872: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()-');
1873: END IF;
1874:
1875: EXCEPTION
1876: WHEN OTHERS THEN

Line 1878: arp_standard.debug( 'EXception AR_AGING_BUCKETS_PKG.bind_bucket_parameters()');

1874:
1875: EXCEPTION
1876: WHEN OTHERS THEN
1877: arp_standard.debug( 'Exception '||SQLERRM);
1878: arp_standard.debug( 'EXception AR_AGING_BUCKETS_PKG.bind_bucket_parameters()');
1879: RAISE;
1880: END bind_bucket_parameters;
1881:
1882:

Line 1913: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()+');

1909: l_insert_stmt VARCHAR2(32000);
1910:
1911: BEGIN
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()+');
1914: arp_standard.debug( 'p_qry_category :'||p_qry_category);
1915: END IF;
1916:
1917: l_insert_stmt := '

Line 1978: AR_AGING_BUCKETS_PKG.get_contact_information( contact_site_id,

1974: amount_credited,
1975: gl_date,
1976: data_converted_flag,
1977: exchange_rate,
1978: AR_AGING_BUCKETS_PKG.get_contact_information( contact_site_id,
1979: ''NAME'') contact_name,
1980: AR_AGING_BUCKETS_PKG.get_contact_information( contact_site_id,
1981: ''PHONE'') contact_phone,
1982: bucket_0,

Line 1980: AR_AGING_BUCKETS_PKG.get_contact_information( contact_site_id,

1976: data_converted_flag,
1977: exchange_rate,
1978: AR_AGING_BUCKETS_PKG.get_contact_information( contact_site_id,
1979: ''NAME'') contact_name,
1980: AR_AGING_BUCKETS_PKG.get_contact_information( contact_site_id,
1981: ''PHONE'') contact_phone,
1982: bucket_0,
1983: bucket_1,
1984: bucket_2,

Line 2034: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');

2030: arp_standard.debug( 'Rows Processed '||l_rows_processed);
2031: END IF;
2032:
2033: IF PG_DEBUG in ('Y', 'C') THEN
2034: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');
2035: END IF;
2036:
2037: EXCEPTION
2038: WHEN OTHERS THEN

Line 2040: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');

2036:
2037: EXCEPTION
2038: WHEN OTHERS THEN
2039: arp_standard.debug( 'Exception '||SQLERRM);
2040: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');
2041: RAISE;
2042: END extract_aging_information;
2043:
2044:

Line 2083: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()+');

2079: l_accting_source VARCHAR2(30);
2080:
2081: BEGIN
2082: IF PG_DEBUG in ('Y', 'C') THEN
2083: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()+');
2084: END IF;
2085:
2086: get_report_specific_info( p_qry_category => AR_AGING_CTGRY_INVOICE,
2087: p_rep_specific_cols => l_rep_specific_cols,

Line 2701: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()-');

2697: and dist2.amount_dr is not null
2698: and th2.customer_trx_id = ps.customer_trx_id)';
2699:
2700: IF PG_DEBUG in ('Y', 'C') THEN
2701: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()-');
2702: END IF;
2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN

Line 2707: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.build_select_stmt()');

2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: IF PG_DEBUG in ('Y', 'C') THEN
2707: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.build_select_stmt()');
2708: arp_standard.debug( 'Exception message '||SQLERRM);
2709: END IF;
2710: RAISE;
2711: END build_select_stmt;

Line 2853: l_aging_mfar_tab AR_AGING_BUCKETS_PKG.AGING_MFAR_TAB;

2849: ae.currency_code
2850: order by payment_schedule_id
2851: );
2852:
2853: l_aging_mfar_tab AR_AGING_BUCKETS_PKG.AGING_MFAR_TAB;
2854: l_run_alloc_tot NUMBER;
2855: l_alloc_amt NUMBER;
2856: l_run_rec_tot NUMBER;
2857: l_pror_identifier NUMBER(15);

Line 2861: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()+');

2857: l_pror_identifier NUMBER(15);
2858:
2859: BEGIN
2860: IF PG_DEBUG in ('Y', 'C') THEN
2861: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()+');
2862: arp_standard.debug( 'p_category '||p_category);
2863: END IF;
2864:
2865: OPEN aging_ps_cur;

Line 2915: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()-');

2911: EXIT WHEN aging_ps_cur%NOTFOUND;
2912: END LOOP;
2913:
2914: IF PG_DEBUG in ('Y', 'C') THEN
2915: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()-');
2916: END IF;
2917:
2918: EXCEPTION
2919: WHEN OTHERS THEN

Line 2922: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()');

2918: EXCEPTION
2919: WHEN OTHERS THEN
2920: IF PG_DEBUG in ('Y', 'C') THEN
2921: arp_standard.debug( 'Exception message '||SQLERRM);
2922: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()');
2923: END IF;
2924: RAISE;
2925: END prorate_aging_balances_mfar;
2926:

Line 2972: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()+');

2968: l_alter_str VARCHAR2(100);
2969:
2970: BEGIN
2971: IF PG_DEBUG in ('Y', 'C') THEN
2972: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()+');
2973: print_clob(p_extract_query);
2974: END IF;
2975:
2976: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

Line 3095: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()-');

3091:
3092: ar_cumulative_balance_report.process_clob(tempResult);
3093:
3094: IF PG_DEBUG in ('Y', 'C') THEN
3095: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()-');
3096: END IF;
3097:
3098: EXCEPTION
3099: WHEN OTHERS THEN

Line 3108: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.generate_xml()');

3104: END IF;
3105:
3106: IF PG_DEBUG in ('Y', 'C') THEN
3107: arp_standard.debug( 'Exception message '||SQLERRM);
3108: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.generate_xml()');
3109: END IF;
3110: RAISE;
3111: END generate_xml;
3112:

Line 3166: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()+');

3162: p_retain_staging_flag IN VARCHAR2 DEFAULT NULL) IS
3163: BEGIN
3164:
3165: IF PG_DEBUG in ('Y', 'C') THEN
3166: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()+');
3167: arp_standard.debug( 'invoking procedure aging_seven_buckets..');
3168: END IF;
3169:
3170: aging_seven_buckets( p_rep_type => p_rep_type,

Line 3198: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()-');

3194: p_retain_staging_flag => p_retain_staging_flag,
3195: p_master_req_flag => 'N');
3196:
3197: IF PG_DEBUG in ('Y', 'C') THEN
3198: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()-');
3199: END IF;
3200: END aging_rep_extract;
3201:
3202:

Line 3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');

3308: END submit_subrequest;
3309:
3310: BEGIN
3311: IF PG_DEBUG in ('Y', 'C') THEN
3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');
3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);

Line 3471: END AR_AGING_BUCKETS_PKG;

3467:
3468: END aging_seven_buckets;
3469:
3470:
3471: END AR_AGING_BUCKETS_PKG;