[Home] [Help]
64:
65: --------------------------------------------------------------------------
66: -- Local Procedure Signature
67: --------------------------------------------------------------------------
68: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
69:
70: PROCEDURE InformSysAdminError(p_procedure_name IN VARCHAR2,
71: p_debug_info IN VARCHAR2,
72: p_error IN VARCHAR2);
862: l_debug_info := 'InsideRemoveRole'||p_person_party_id||' '||p_customer_id||p_cust_acct_site_id;
863: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
864: end if;
865: -------------------------------------------------------------------------
866: l_user_id := FND_PROFILE.VALUE('USER_ID');
867:
868: select user_name INTO l_user_name FROM fnd_user where user_id = l_user_id;
869:
870: if(p_cust_acct_site_id <> -1) then
2719: END IF;
2720: wf_event_t.initialize(l_event);
2721: l_event.setParameterList(l_parameter_list);
2722:
2723: FND_PROFILE.Get('OIR_APPROVAL_FOR_ACCOUNT_ACCESS', l_approval_profile);
2724: l_event_name := 'oracle.apps.ar.irec.addcustaccess';
2725: SELECT UMX_REG_REQUESTS_S.nextval INTO l_item_key FROM dual;
2726:
2727: IF (l_approval_profile='Y') THEN
2895: IF p_user_id IS NOT NULL THEN
2896: BEGIN
2897: select fpov.profile_option_value
2898: into l_reg_sec_profile
2899: from fnd_profile_option_values fpov, fnd_profile_options fpo
2900: where fpov.profile_option_id = fpo.profile_option_id
2901: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2902: and fpov.level_id = 10004 -- user level
2903: and fpov.level_value = p_user_id;
2915: --Get the security profile value set up for the
2916: --iReceivables Registration responsibility
2917: select fpov.profile_option_value
2918: into l_reg_sec_profile
2919: from fnd_profile_option_values fpov, fnd_profile_options fpo
2920: where fpov.profile_option_id = fpo.profile_option_id
2921: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2922: and fpov.level_id = 10003 -- responsibility level
2923: and fpov.level_value_application_id = 222
2926: WHEN NO_DATA_FOUND THEN
2927: --Get the security profile set up at the site level
2928: select fpov.profile_option_value
2929: into l_reg_sec_profile
2930: from fnd_profile_option_values fpov, fnd_profile_options fpo
2931: where fpov.profile_option_id = fpo.profile_option_id
2932: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2933: and fpov.level_id = 10001; -- Site level
2934:
3163: ----------------------------------------------------------------------------
3164: l_debug_info := 'Retrieve value of RegHoldDomain profile' ||
3165: p_past_reg_status;
3166: ----------------------------------------------------------------------------
3167: FND_PROFILE.Get('ARI_REG_HOLD_DOMAIN', l_profile_reg_hold_type);
3168:
3169: ----------------------------------------------------------------------------
3170: l_debug_info := 'Retrieve value of RegHoldNumOfDays profile' ||
3171: p_past_reg_status;
3169: ----------------------------------------------------------------------------
3170: l_debug_info := 'Retrieve value of RegHoldNumOfDays profile' ||
3171: p_past_reg_status;
3172: ----------------------------------------------------------------------------
3173: FND_PROFILE.GET('ARI_REG_HOLD_DURATION', l_profile_reg_hold_days);
3174:
3175: ----------------------------------------------------------------------------
3176: l_debug_info := 'OpenRegistrationCur checking for holds';
3177: ----------------------------------------------------------------------------