APPS.AR_MO_CACHE_UTILS dependencies on AR_MO_CACHE_UTILS

Line 1: PACKAGE BODY ar_mo_cache_utils AS

1: PACKAGE BODY ar_mo_cache_utils AS
2: /*$Header: ARMOCSHB.pls 120.17 2006/03/16 00:55:42 jypandey noship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: -- Bug 3251839 - tm_installed and tm_default_setup functions provide a

Line 12: arp_util.debug('ar_mo_cache_utils.tm_installed()');

8: FUNCTION tm_installed
9: RETURN VARCHAR2 IS
10: BEGIN
11: IF PG_DEBUG in ('Y', 'C') THEN
12: arp_util.debug('ar_mo_cache_utils.tm_installed()');
13: END IF;
14:
15: IF ozf_claim_install.check_installed THEN
16: RETURN 'Y';

Line 23: arp_util.debug('EXCEPTION: problem calling ozf_claim_install.check_installed - ar_mo_cache_utils.tm_installed');

19: END IF;
20: EXCEPTION
21: WHEN OTHERS THEN
22: IF PG_DEBUG in ('Y', 'C') THEN
23: arp_util.debug('EXCEPTION: problem calling ozf_claim_install.check_installed - ar_mo_cache_utils.tm_installed');
24: END IF;
25: APP_EXCEPTION.raise_exception;
26: END;
27:

Line 32: arp_util.debug('ar_mo_cache_utils.tm_default_setup()');

28: FUNCTION tm_default_setup
29: RETURN VARCHAR2 IS
30: BEGIN
31: IF PG_DEBUG in ('Y', 'C') THEN
32: arp_util.debug('ar_mo_cache_utils.tm_default_setup()');
33: END IF;
34:
35: IF ozf_claim_install.check_default_setup THEN
36: RETURN 'Y';

Line 43: arp_util.debug('EXCEPTION: problem calling ozf_claim_install.check_default_setup - ar_mo_cache_utils.tm_default_setup');

39: END IF;
40: EXCEPTION
41: WHEN OTHERS THEN
42: IF PG_DEBUG in ('Y', 'C') THEN
43: arp_util.debug('EXCEPTION: problem calling ozf_claim_install.check_default_setup - ar_mo_cache_utils.tm_default_setup');
44: END IF;
45: APP_EXCEPTION.raise_exception;
46: END;
47:

Line 63: arp_util.debug('ar_mo_cache_utils.retrieve_globals()+');

59: WHERE sp.org_id = nvl(c_org_id , sp.org_id);
60:
61: BEGIN
62: IF PG_DEBUG in ('Y', 'C') THEN
63: arp_util.debug('ar_mo_cache_utils.retrieve_globals()+');
64: END IF;
65:
66: /* ---------------------------------------------------------------
67: This statement fetches operating unit attributes from the

Line 740: arp_util.debug('ar_mo_cache_utils.retrieve_globals()-');

736: and zxpo.org_id (+) = sp.org_id;
737: end if;
738:
739: IF PG_DEBUG in ('Y', 'C') THEN
740: arp_util.debug('ar_mo_cache_utils.retrieve_globals()-');
741: END IF;
742:
743: EXCEPTION
744: when no_data_found then

Line 766: arp_util.debug('EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS - ar_mo_cache_utils.retrieve_globals' );

762: where sob.set_of_books_id = REC.set_of_books_id
763: and org_id = REC.org_id;
764: exception when no_data_found then
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_util.debug('EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS - ar_mo_cache_utils.retrieve_globals' );
767: END IF;
768: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_GL_SET_OF_BOOKS');
769: APP_EXCEPTION.raise_exception;
770: RAISE;

Line 784: arp_util.debug('EXCEPTION: NO_DATA_FOUND IN CURRENCIES - ar_mo_cache_utils.retrieve_globals' );

780: and sob.currency_code = c.currency_code;
781:
782: exception when no_data_found then
783: IF PG_DEBUG in ('Y', 'C') THEN
784: arp_util.debug('EXCEPTION: NO_DATA_FOUND IN CURRENCIES - ar_mo_cache_utils.retrieve_globals' );
785: END IF;
786: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
787: APP_EXCEPTION.raise_exception;
788: RAISE; --end of WHEN NO DATA FOUND

Line 801: - ar_mo_cache_utils.retrieve_globals' );

797:
798: IF l_exp_flag ='N' THEN
799: IF PG_DEBUG in ('Y', 'C') THEN
800: arp_util.debug('retrieve_globals: ' || 'EXCEPTION: NO_DATA_FOUND IN SYSTEM PARAMETERS
801: - ar_mo_cache_utils.retrieve_globals' );
802: END IF;
803: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
804: APP_EXCEPTION.raise_exception;
805: RAISE;

Line 850: END ar_mo_cache_utils;

846: WHEN others THEN Raise;
847:
848: END set_org_context_in_api;
849:
850: END ar_mo_cache_utils;