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.ARP_BF_BILL dependencies on STANDARD

Line 32: arp_standard.debug(p_message);

28: fnd_file.put_line(FND_FILE.LOG,p_message);
29:
30: END IF;
31:
32: arp_standard.debug(p_message);
33:
34: EXCEPTION
35: WHEN others THEN
36: NULL;

Line 612: nvl(cp1.standard_terms, cp2.standard_terms) site_term,

608: P_bill_site_low NUMBER, P_bill_site_high NUMBER) IS
609: SELECT acct.cust_account_id customer_id,
610: nvl(cp1.cons_bill_level, cp2.cons_bill_level) site_bill_level,
611: cp2.cons_bill_level acct_bill_level,
612: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
613: cp2.standard_terms acct_term
614: FROM hz_cust_accounts acct,
615: hz_cust_acct_sites acct_site,
616: hz_cust_site_uses site_uses,

Line 613: cp2.standard_terms acct_term

609: SELECT acct.cust_account_id customer_id,
610: nvl(cp1.cons_bill_level, cp2.cons_bill_level) site_bill_level,
611: cp2.cons_bill_level acct_bill_level,
612: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
613: cp2.standard_terms acct_term
614: FROM hz_cust_accounts acct,
615: hz_cust_acct_sites acct_site,
616: hz_cust_site_uses site_uses,
617: hz_customer_profiles cp1,

Line 956: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||

952: 'AND site_uses.site_use_code = ''BILL_TO'' ' ||
953: 'AND CP.cust_account_id = acct_site.cust_account_id ' ||
954: 'AND CP.site_use_id IS NULL ' ||
955: 'AND SP.site_use_id(+) = site_uses.site_use_id ' ||
956: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||
957: 'AND :term_id = ' ||
958: ' decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
959: ' ''A'', CP.standard_terms, ' ||
960: ' ''S'', SP.standard_terms) ' ||

Line 959: ' ''A'', CP.standard_terms, ' ||

955: 'AND SP.site_use_id(+) = site_uses.site_use_id ' ||
956: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||
957: 'AND :term_id = ' ||
958: ' decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
959: ' ''A'', CP.standard_terms, ' ||
960: ' ''S'', SP.standard_terms) ' ||
961: 'AND decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
962: ' ''A'', CP.cons_inv_flag, ' ||
963: ' ''S'', SP.cons_inv_flag) = ''Y'' ' ||

Line 960: ' ''S'', SP.standard_terms) ' ||

956: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||
957: 'AND :term_id = ' ||
958: ' decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
959: ' ''A'', CP.standard_terms, ' ||
960: ' ''S'', SP.standard_terms) ' ||
961: 'AND decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
962: ' ''A'', CP.cons_inv_flag, ' ||
963: ' ''S'', SP.cons_inv_flag) = ''Y'' ' ||
964: 'AND NOT EXISTS ' ||

Line 1350: arp_standard.profile.request_id,

1346: VALUES (l_consinv_id,
1347: l_cons_billno,
1348: L_sites.customer_id,
1349: L_sites.site_id,
1350: arp_standard.profile.request_id,
1351: arp_global.last_update_date,
1352: arp_global.last_updated_by,
1353: arp_global.creation_date,
1354: arp_global.created_by,

Line 1366: arp_standard.sysparm.org_id,

1362: l_due_date,
1363: P_currency,
1364: nvl(l_beginning_balance,0),
1365: 0,
1366: arp_standard.sysparm.org_id,
1367: l_billing_date,
1368: L_sites.bill_level,
1369: l_last_bill_date,
1370: P_billing_cycle_id,

Line 1517: arp_standard.sysparm.org_id,

1513: L_inv_trx.amount_due,
1514: L_inv_trx.tax,
1515: l_new_schedule_id, -- bug 6488683
1516: l_consinv_lineno,
1517: arp_standard.sysparm.org_id,
1518: l_comments,
1519: L_inv_trx.trx_desc,
1520: L_inv_trx.trx_id,
1521: L_inv_trx.ship_id);

Line 2333: arp_standard.sysparm.org_id,

2329: L_sites.site_id,
2330: P_currency,
2331: NULL,
2332: l_bucket_name,
2333: arp_standard.sysparm.org_id,
2334: NULL,
2335: 'CONS_BILL',
2336: l_outstanding_balance,
2337: l_bucket_titletop_0,

Line 2666: arp_standard.init_standard(p_org_id);

2662:
2663: IF P_org_id is not null THEN
2664: write_debug_and_log('ORG ID : '||p_org_id);
2665: mo_global.set_policy_context('S',p_org_id);
2666: arp_standard.init_standard(p_org_id);
2667: Report(l_report);
2668:
2669: ELSE
2670:

Line 2675: arp_standard.init_standard(p_org_id);

2671: FOR k in org_rec LOOP
2672: write_debug_and_log('ORG ID : '||k.org_id);
2673:
2674: mo_global.set_policy_context('S',k.org_id);
2675: arp_standard.init_standard(p_org_id);
2676: Report(l_report);
2677:
2678: END LOOP;
2679:

Line 2751: arp_standard.init_standard(p_org_id);

2747: IF P_org_id is not null THEN
2748:
2749: write_debug_and_log('ORG ID : '||p_org_id);
2750: mo_global.set_policy_context('S',p_org_id);
2751: arp_standard.init_standard(p_org_id);
2752:
2753: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
2754: l_report.print_option := 'DRAFT';
2755: else

Line 2764: WHERE sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;

2760: -- default to functional currency
2761: SELECT sob.currency_code
2762: INTO l_use_currency
2763: FROM gl_sets_of_books sob
2764: WHERE sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
2765: ELSE
2766: l_use_currency := P_currency;
2767: END IF;
2768:

Line 2800: arp_standard.init_standard(p_org_id);

2796:
2797: FOR k in org_rec LOOP
2798:
2799: mo_global.set_policy_context('S',k.org_id);
2800: arp_standard.init_standard(p_org_id);
2801:
2802: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
2803: l_report.print_option := 'DRAFT';
2804: else

Line 2813: WHERE sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;

2809: -- default to functional currency
2810: SELECT sob.currency_code
2811: INTO l_use_currency
2812: FROM gl_sets_of_books sob
2813: WHERE sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
2814: ELSE
2815: l_use_currency := P_currency;
2816: END IF;
2817:

Line 2874: arp_standard.profile.request_id, -- Conc Request ID

2870: to_char(null), -- Bill Date Low
2871: to_char(null), -- Bill Date High
2872: to_char(null), -- Bill Number Low
2873: to_char(null), -- Bill Number High
2874: arp_standard.profile.request_id, -- Conc Request ID
2875: to_char(null));
2876:
2877: write_debug_and_log('... request ID is ' || to_char(l_request_id));
2878: