APPS.ARI_UTILITIES dependencies on ARI_UTILITIES

Line 1: PACKAGE BODY ARI_UTILITIES AS

1: PACKAGE BODY ARI_UTILITIES AS
2: /* $Header: ARIUTILB.pls 120.37.12020000.3 2012/12/25 18:31:05 shvimal ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARI_UTILITIES';

3:
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARI_UTILITIES';
8: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
9:
10: G_PRV_ADDRESS_ID HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE := 0;
11: G_BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES.SITE_USE_ID%TYPE := 0;

Line 1927: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME,' calling ari_utilities.strip_white_spaces p_routing_number ::'||p_routing_number);

1923: /*---------------------------------+
1924: | Remove all non-digit characters |
1925: +---------------------------------*/
1926: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1927: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME,' calling ari_utilities.strip_white_spaces p_routing_number ::'||p_routing_number);
1928: end if;
1929:
1930: ari_utilities.strip_white_spaces (p_routing_number,
1931: l_routing_num_stripped);

Line 1930: ari_utilities.strip_white_spaces (p_routing_number,

1926: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1927: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME,' calling ari_utilities.strip_white_spaces p_routing_number ::'||p_routing_number);
1928: end if;
1929:
1930: ari_utilities.strip_white_spaces (p_routing_number,
1931: l_routing_num_stripped);
1932:
1933: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1934: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME,' Stripped Routing number l_routing_num_stripped ::'||l_routing_num_stripped);

Line 2002: arp_standard.debug('ari_utilities.strip_white_spaces()+');

1998: len_strip_num number := 0;
1999: l_strip_num_char character_tab_typ;
2000: BEGIN
2001: IF PG_DEBUG in ('Y', 'C') THEN
2002: arp_standard.debug('ari_utilities.strip_white_spaces()+');
2003: END IF;
2004:
2005: SELECT lengthb(p_num_to_strip)
2006: INTO len_strip_num

Line 2024: arp_standard.debug('ari_utilities.strip_white_spaces()-');

2020: END IF;
2021: END LOOP;
2022:
2023: IF PG_DEBUG in ('Y', 'C') THEN
2024: arp_standard.debug('ari_utilities.strip_white_spaces()-');
2025: END IF;
2026: EXCEPTION
2027: when OTHERS then
2028: raise;

Line 2051: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;

2047:
2048: select count(*) into l_site_access_count from ar_sites_assigned_v acct_sites_count
2049: where acct_sites_count.party_id=p_party_id
2050: and acct_sites_count.cust_account_id=p_customer_id
2051: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;
2052:
2053: select count(*) into l_flag from(
2054: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
2055: and CUSTOMER_SITE_USE_ID in

Line 2057: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where

2053: select count(*) into l_flag from(
2054: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
2055: and CUSTOMER_SITE_USE_ID in
2056: (
2057: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where
2058: party_id=p_party_id
2059: and cust_account_id=p_customer_id
2060: )
2061: );

Line 2748: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,

2744:
2745: EXCEPTION
2746: WHEN OTHERS THEN
2747: rslt := 'COMPLETE:' || 'N';
2748: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,
2749: l_itemkey,to_char(actid),funcmode);
2750: IF (PG_DEBUG = 'Y') THEN
2751: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2752: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 3112: END ari_utilities;

3108: pending_cmreq_amt := 0;
3109: return pending_cmreq_amt;
3110: END get_pending_cmreq_amount;
3111:
3112: END ari_utilities;
3113:
3114: