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 593: nvl(cp1.standard_terms, cp2.standard_terms) site_term,

589: P_bill_site_low NUMBER, P_bill_site_high NUMBER) IS
590: SELECT acct.cust_account_id customer_id,
591: nvl(cp1.cons_bill_level, cp2.cons_bill_level) site_bill_level,
592: cp2.cons_bill_level acct_bill_level,
593: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
594: cp2.standard_terms acct_term
595: FROM hz_cust_accounts acct,
596: hz_cust_acct_sites acct_site,
597: hz_cust_site_uses site_uses,

Line 594: cp2.standard_terms acct_term

590: SELECT acct.cust_account_id customer_id,
591: nvl(cp1.cons_bill_level, cp2.cons_bill_level) site_bill_level,
592: cp2.cons_bill_level acct_bill_level,
593: nvl(cp1.standard_terms, cp2.standard_terms) site_term,
594: cp2.standard_terms acct_term
595: FROM hz_cust_accounts acct,
596: hz_cust_acct_sites acct_site,
597: hz_cust_site_uses site_uses,
598: hz_customer_profiles cp1,

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

934: 'AND site_uses.site_use_code = ''BILL_TO'' ' ||
935: 'AND CP.cust_account_id = acct_site.cust_account_id ' ||
936: 'AND CP.site_use_id IS NULL ' ||
937: 'AND SP.site_use_id(+) = site_uses.site_use_id ' ||
938: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||
939: 'AND :term_id = ' ||
940: ' decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
941: ' ''A'', CP.standard_terms, ' ||
942: ' ''S'', SP.standard_terms) ' ||

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

937: 'AND SP.site_use_id(+) = site_uses.site_use_id ' ||
938: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||
939: 'AND :term_id = ' ||
940: ' decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
941: ' ''A'', CP.standard_terms, ' ||
942: ' ''S'', SP.standard_terms) ' ||
943: 'AND decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
944: ' ''A'', CP.cons_inv_flag, ' ||
945: ' ''S'', SP.cons_inv_flag) = ''Y'' ' ||

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

938: 'AND ar_bfb_utils_pvt.is_payment_term_bfb(nvl(SP.standard_terms, CP.standard_terms)) = ''Y'' ' ||
939: 'AND :term_id = ' ||
940: ' decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
941: ' ''A'', CP.standard_terms, ' ||
942: ' ''S'', SP.standard_terms) ' ||
943: 'AND decode(ar_bfb_utils_pvt.get_bill_level(acct_site.cust_account_id), ' ||
944: ' ''A'', CP.cons_inv_flag, ' ||
945: ' ''S'', SP.cons_inv_flag) = ''Y'' ' ||
946: 'AND NOT EXISTS ' ||

Line 1342: arp_standard.profile.request_id,

1338: VALUES (l_consinv_id,
1339: l_cons_billno,
1340: L_sites.customer_id,
1341: L_sites.site_id,
1342: arp_standard.profile.request_id,
1343: arp_global.last_update_date,
1344: arp_global.last_updated_by,
1345: arp_global.creation_date,
1346: arp_global.created_by,

Line 1358: arp_standard.sysparm.org_id,

1354: l_due_date,
1355: P_currency,
1356: nvl(l_beginning_balance,0),
1357: 0,
1358: arp_standard.sysparm.org_id,
1359: l_billing_date,
1360: L_sites.bill_level,
1361: l_last_bill_date,
1362: P_billing_cycle_id,

Line 1555: arp_standard.sysparm.org_id,

1551: L_inv_trx.amount_due,
1552: L_inv_trx.tax,
1553: l_new_schedule_id, -- bug 6488683
1554: l_consinv_lineno,
1555: arp_standard.sysparm.org_id,
1556: l_comments,
1557: L_inv_trx.trx_desc,
1558: L_inv_trx.trx_id,
1559: L_inv_trx.ship_id);

Line 2584: arp_standard.sysparm.org_id,

2580: L_sites.site_id,
2581: P_currency,
2582: NULL,
2583: l_bucket_name,
2584: arp_standard.sysparm.org_id,
2585: NULL,
2586: 'CONS_BILL',
2587: l_outstanding_balance,
2588: l_bucket_titletop_0,

Line 2921: arp_standard.init_standard(p_org_id);

2917:
2918: IF P_org_id is not null THEN
2919: write_debug_and_log('ORG ID : '||p_org_id);
2920: mo_global.set_policy_context('S',p_org_id);
2921: arp_standard.init_standard(p_org_id);
2922: Report(l_report);
2923:
2924: ELSE
2925:

Line 2930: arp_standard.init_standard(p_org_id);

2926: FOR k in org_rec LOOP
2927: write_debug_and_log('ORG ID : '||k.org_id);
2928:
2929: mo_global.set_policy_context('S',k.org_id);
2930: arp_standard.init_standard(p_org_id);
2931: Report(l_report);
2932:
2933: END LOOP;
2934:

Line 3008: arp_standard.init_standard(p_org_id);

3004: IF P_org_id is not null THEN
3005:
3006: write_debug_and_log('ORG ID : '||p_org_id);
3007: mo_global.set_policy_context('S',p_org_id);
3008: arp_standard.init_standard(p_org_id);
3009:
3010: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
3011: l_report.print_option := 'DRAFT';
3012: else

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

3017: -- default to functional currency
3018: SELECT sob.currency_code
3019: INTO l_use_currency
3020: FROM gl_sets_of_books sob
3021: WHERE sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
3022: ELSE
3023: l_use_currency := P_currency;
3024: END IF;
3025:

Line 3058: arp_standard.init_standard(p_org_id);

3054:
3055: FOR k in org_rec LOOP
3056:
3057: mo_global.set_policy_context('S',k.org_id);
3058: arp_standard.init_standard(p_org_id);
3059:
3060: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
3061: l_report.print_option := 'DRAFT';
3062: else

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

3067: -- default to functional currency
3068: SELECT sob.currency_code
3069: INTO l_use_currency
3070: FROM gl_sets_of_books sob
3071: WHERE sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
3072: ELSE
3073: l_use_currency := P_currency;
3074: END IF;
3075:

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

3128: to_char(null), -- Bill Date Low
3129: to_char(null), -- Bill Date High
3130: to_char(null), -- Bill Number Low
3131: to_char(null), -- Bill Number High
3132: arp_standard.profile.request_id, -- Conc Request ID
3133: to_char(null));
3134:
3135: write_debug_and_log('... request ID is ' || to_char(l_request_id));
3136: