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.22.12010000.6 2009/01/15 11:56:24 nkanchan 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 1653: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;

1649:
1650: select count(*) into l_site_access_count from ar_sites_assigned_v acct_sites_count
1651: where acct_sites_count.party_id=p_party_id
1652: and acct_sites_count.cust_account_id=p_customer_id
1653: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;
1654:
1655: select count(*) into l_flag from(
1656: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
1657: and CUSTOMER_SITE_USE_ID in

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

1655: select count(*) into l_flag from(
1656: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
1657: and CUSTOMER_SITE_USE_ID in
1658: (
1659: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where
1660: party_id=p_party_id
1661: and cust_account_id=p_customer_id
1662: )
1663: );

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

2128:
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: rslt := 'COMPLETE:' || 'N';
2132: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,
2133: l_itemkey,to_char(actid),funcmode);
2134: IF (PG_DEBUG = 'Y') THEN
2135: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2136: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 2320: END ari_utilities;

2316: ROLLBACK TO CANCEL_DISPUTE;
2317: p_return_status := FND_API.G_RET_STS_ERROR;
2318: END cancel_dispute;
2319:
2320: END ari_utilities;
2321:
2322: