eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_LOG

Line 861: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

857: END IF;
858: /* Added the below queries to fetch the user name and site_use_id for deleting
859: the record from ari_reg_verifications when access is removed for the selected location for Bug 13869981 */
860: ---------------------------------------------------------------------
861: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
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: -------------------------------------------------------------------------

Line 863: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);

859: the record from ari_reg_verifications when access is removed for the selected location for Bug 13869981 */
860: ---------------------------------------------------------------------
861: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
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:

Line 878: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

874: else -- This is being done to signify All Locations record
875: l_site_use_id := -1;
876: end if;
877: -------------------------------------------------------------------------
878: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
879: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'InsideRemoveRole'||l_user_name||l_site_use_id);
880: end if;
881: -------------------------------------------------------------------------
882: delete from ARI_REG_VERIFICATIONS

Line 879: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'InsideRemoveRole'||l_user_name||l_site_use_id);

875: l_site_use_id := -1;
876: end if;
877: -------------------------------------------------------------------------
878: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
879: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'InsideRemoveRole'||l_user_name||l_site_use_id);
880: end if;
881: -------------------------------------------------------------------------
882: delete from ARI_REG_VERIFICATIONS
883: WHERE UPPER(user_email_addr) = UPPER(l_user_name)

Line 2508: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2504: RegisterUser(p_event, l_person_party_id);
2505: -- Added the below lines for Bug 13869981
2506: l_registration_id := p_event.getValueForParameter('REGISTRATION_ID');
2507: -----------------------------------------------------------------------
2508: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2509: l_debug_info := 'RegId IN ADD CUST ACCESS----'||l_registration_id;
2510: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
2511: end if;
2512: -----------------------------------------------------------------------

Line 2510: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);

2506: l_registration_id := p_event.getValueForParameter('REGISTRATION_ID');
2507: -----------------------------------------------------------------------
2508: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2509: l_debug_info := 'RegId IN ADD CUST ACCESS----'||l_registration_id;
2510: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
2511: end if;
2512: -----------------------------------------------------------------------
2513: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => l_registration_id,
2514: x_Status_Lookup_Code => 'COMPLETE',

Line 2967: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2963: l_procedure_name VARCHAR2(50) := '.UpdateRegistrationTable';
2964: l_debug_info VARCHAR2(4000);
2965:
2966: BEGIN
2967: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2968: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRegistrationTable');
2969: END IF;
2970: -- This function is called on the event 'oracle.apps.fnd.umx.startaccountrequestwf'
2971: -- To ensure that the status has been updated to In Progress

Line 2968: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRegistrationTable');

2964: l_debug_info VARCHAR2(4000);
2965:
2966: BEGIN
2967: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2968: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRegistrationTable');
2969: END IF;
2970: -- This function is called on the event 'oracle.apps.fnd.umx.startaccountrequestwf'
2971: -- To ensure that the status has been updated to In Progress
2972: l_registration_id := p_event.getvalueforparameter('REGISTRATION_ID');

Line 2975: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2971: -- To ensure that the status has been updated to In Progress
2972: l_registration_id := p_event.getvalueforparameter('REGISTRATION_ID');
2973: l_item_key := p_event.getvalueforparameter('UMX_PARENT_ITEM_KEY');
2974: ------------------------------------------------------------------------
2975: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2976: l_debug_info := 'Values in URT---'||'l_registration_id --'||l_registration_id||' l_item_key -- '||l_item_key;
2977: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
2978: end if;
2979: -------------------------------------------------------------------------

Line 2977: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);

2973: l_item_key := p_event.getvalueforparameter('UMX_PARENT_ITEM_KEY');
2974: ------------------------------------------------------------------------
2975: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2976: l_debug_info := 'Values in URT---'||'l_registration_id --'||l_registration_id||' l_item_key -- '||l_item_key;
2977: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
2978: end if;
2979: -------------------------------------------------------------------------
2980: --Added if condition for Bug#16475167
2981: if(l_registration_id IS NOT NULL AND l_item_key IS NOT NULL) then

Line 3025: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3021: l_approval_result VARCHAR2(4000);
3022:
3023: BEGIN
3024: -----------------------------------------------------------------------
3025: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'In UpdateRejectedStatus Function');
3027: end if;
3028: -----------------------------------------------------------------------
3029:

Line 3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'In UpdateRejectedStatus Function');

3022:
3023: BEGIN
3024: -----------------------------------------------------------------------
3025: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'In UpdateRejectedStatus Function');
3027: end if;
3028: -----------------------------------------------------------------------
3029:
3030: -- This function is called on the event 'oracle.apps.ar.irec.accountrequest.notification.start'

Line 3042: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3038: itemkey => l_item_key,
3039: aname => 'APPROVAL_RESULT',
3040: ignore_notfound => false);
3041: -----------------------------------------------------------------------------
3042: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3043: l_debug_info := 'Values in UpdateRejectedStatus ---'||l_registration_id||l_item_key||l_approval_result;
3044: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
3045: end if;
3046: ------------------------------------------------------------------------------

Line 3044: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);

3040: ignore_notfound => false);
3041: -----------------------------------------------------------------------------
3042: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3043: l_debug_info := 'Values in UpdateRejectedStatus ---'||l_registration_id||l_item_key||l_approval_result;
3044: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
3045: end if;
3046: ------------------------------------------------------------------------------
3047: if (l_approval_result = 'REJECTED') then
3048: l_status := 'REJECTED';

Line 3867: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3863: l_debug_info VARCHAR2(4000);
3864: BEGIN
3865:
3866: --------------------------------------------------------------------
3867: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3868: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRequestAccess');
3869: end if;
3870: --------------------------------------------------------------------
3871:

Line 3868: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRequestAccess');

3864: BEGIN
3865:
3866: --------------------------------------------------------------------
3867: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3868: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRequestAccess');
3869: end if;
3870: --------------------------------------------------------------------
3871:
3872: --------------------------------------------------------------------

Line 3873: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3869: end if;
3870: --------------------------------------------------------------------
3871:
3872: --------------------------------------------------------------------
3873: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3874: l_debug_info := 'UpdateRequestAccess param values --- '||p_registration_id||p_registration_type||p_registration_status;
3875: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
3876: end if;
3877: ---------------------------------------------------------------------

Line 3875: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);

3871:
3872: --------------------------------------------------------------------
3873: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3874: l_debug_info := 'UpdateRequestAccess param values --- '||p_registration_id||p_registration_type||p_registration_status;
3875: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
3876: end if;
3877: ---------------------------------------------------------------------
3878: ARI_REG_VERIFY_PKG.Update_Row(x_Registration_id => p_registration_id,
3879: x_Registration_Type => p_registration_type,

Line 4021: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4017: l_debug_info VARCHAR2(4000);
4018: BEGIN
4019: mo_global.init('AR');
4020: ----------------------------------------------------------------------
4021: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4022: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateApprovalStatus'||p_itemkey);
4023: end if;
4024: ----------------------------------------------------------------------
4025: --

Line 4022: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateApprovalStatus'||p_itemkey);

4018: BEGIN
4019: mo_global.init('AR');
4020: ----------------------------------------------------------------------
4021: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4022: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateApprovalStatus'||p_itemkey);
4023: end if;
4024: ----------------------------------------------------------------------
4025: --
4026: -- RUN mode - normal process execution

Line 4119: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4115: l_error_msg VARCHAR2(2000);
4116: l_debug_info VARCHAR2(4000);
4117: BEGIN
4118: ---------------------------------------------------------------------
4119: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRejectStatus'||p_itemkey);
4121: end if;
4122: ----------------------------------------------------------------------
4123: --

Line 4120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRejectStatus'||p_itemkey);

4116: l_debug_info VARCHAR2(4000);
4117: BEGIN
4118: ---------------------------------------------------------------------
4119: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside UpdateRejectStatus'||p_itemkey);
4121: end if;
4122: ----------------------------------------------------------------------
4123: --
4124: -- RUN mode - normal process execution