APPS.ARPT_SQL_FUNC_UTIL dependencies on STANDARD

Line 2728: -- users can access in the customer standard form)

2724: WHEN TOO_MANY_ROWS THEN
2725: -- Bug 4128837 : this is the case for historical "bad" data,
2726: -- wherein one cust_acct_site_id can have multiple rows in hz_customer_profiles
2727: -- In this case, use the BILL_TO site (since this is the profile that
2728: -- users can access in the customer standard form)
2729:
2730: BEGIN
2731:
2732: select site_use_id

Line 2835: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()+');

2831: l_currency_code VARCHAR2(15);
2832: l_return_status VARCHAR2(1);
2833:
2834: BEGIN
2835: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()+');
2836: OZF_Claim_Install.get_amount_remaining (
2837: p_claim_id => p_claim_id,
2838: x_amount_remaining => l_amount_remaining,
2839: x_acctd_amount_remaining => l_acctd_amount_remaining,

Line 2850: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');

2846: ELSE
2847: RETURN l_amount_remaining;
2848: END IF;
2849:
2850: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: arp_standard.debug('Unexpected error '||sqlerrm||
2854: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');

Line 2853: arp_standard.debug('Unexpected error '||sqlerrm||

2849:
2850: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: arp_standard.debug('Unexpected error '||sqlerrm||
2854: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');
2855: RAISE;
2856: END get_claim_amount;
2857: