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.

[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on FND_PROFILE

Line 35: --G_TRANSACTION_TYPE CONSTANT VARCHAR2(30):= FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_WORKFLOW_PUB';
32: G_LOG_ENABLED varchar2(5);
33: G_MSG_LEVEL NUMBER;
34: g_org_id number;
35: --G_TRANSACTION_TYPE CONSTANT VARCHAR2(30):= FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
36: G_LAST_ENTERED_NOTE VARCHAR2(2000);
37:
38:
39: /*========================================================================

Line 885: --if (fnd_profile.value('ORG_ID') = to_char(l_org_id)) then

881: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_org_id is '||l_org_id);
882: if (mo_global.check_access(l_org_id) = 'Y') then
883: --end R12 specific
884: --begin 11i specific
885: --if (fnd_profile.value('ORG_ID') = to_char(l_org_id)) then
886: --end 11i specific
887: l_has_org_access := TRUE;
888: EXIT USER_RESPS_LOOP;
889: end if;

Line 2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2110: l_msg_index_out NUMBER;
2111: l_org_id NUMBER;
2112: l_approver_user_name VARCHAR2(320);
2113: approverRecord ame_util.approverRecord2;
2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;
2116:
2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');

Line 2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;

2111: l_org_id NUMBER;
2112: l_approver_user_name VARCHAR2(320);
2113: approverRecord ame_util.approverRecord2;
2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;
2116:
2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
2119:

Line 2216: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

2212:
2213: --added to get the profile name correctly
2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);
2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2216: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2217: l_IS_AME_INSTALLED := FND_PROFILE.value('AME_INSTALLED_FLAG');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_IS_AME_INSTALLED : ' || l_IS_AME_INSTALLED);
2219: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_transaction_type : ' || l_transaction_type);
2220:

Line 2217: l_IS_AME_INSTALLED := FND_PROFILE.value('AME_INSTALLED_FLAG');

2213: --added to get the profile name correctly
2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);
2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2216: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2217: l_IS_AME_INSTALLED := FND_PROFILE.value('AME_INSTALLED_FLAG');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_IS_AME_INSTALLED : ' || l_IS_AME_INSTALLED);
2219: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_transaction_type : ' || l_transaction_type);
2220:
2221: --Only when AME:Installed and LNS_AME_TRANSACTION_TYPE profile is setup, need to perform following action

Line 2352: l_loan_approval_from_ntf fnd_profile_option_values.profile_option_value%TYPE;

2348: actid in number,
2349: funcmode in varchar2,
2350: resultout out NOCOPY varchar2 ) IS
2351:
2352: l_loan_approval_from_ntf fnd_profile_option_values.profile_option_value%TYPE;
2353: BEGIN
2354: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF' || ' +');
2355:
2356: IF (funcmode <> wf_engine.eng_run) THEN

Line 2361: l_loan_approval_from_ntf := FND_PROFILE.value('LNS_APPROVE_LOAN_FROM_NTF');

2357: resultout := wf_engine.eng_null;
2358: return;
2359: END IF;
2360:
2361: l_loan_approval_from_ntf := FND_PROFILE.value('LNS_APPROVE_LOAN_FROM_NTF');
2362:
2363: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_approval_from_ntf : ' || l_loan_approval_from_ntf);
2364:
2365: IF NVL(l_loan_approval_from_ntf,'N') = 'N' THEN

Line 2640: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2636:
2637: l_next_approver ame_util.approverrecord;
2638: l_error_message fnd_new_messages.message_text%TYPE;
2639: l_approver_user_name VARCHAR2(320);
2640: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2641:
2642:
2643: BEGIN
2644: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' +');

Line 2652: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

2648: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || p_funcmode);
2649: IF (p_funcmode = 'RUN') THEN
2650:
2651:
2652: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2653: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2654: FindNextApprover(
2655: p_item_type => p_item_type,
2656: p_item_key => p_item_key,

Line 2749: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2745: l_approver_user_name VARCHAR2(320);
2746: approverRecord ame_util.approverRecord2;
2747: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2748: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_APPROVAL_STATUS_TO_AME';
2749: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2750: l_loan_approve_note VARCHAR2(2000);
2751:
2752: BEGIN
2753:

Line 2789: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

2785:
2786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2787: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.resp_id : ' || fnd_global.resp_id);
2788: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2789: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2791:
2792:
2793: approverRecord.name := l_approver_user_name;

Line 2857: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2853: l_approver_user_name VARCHAR2(320);
2854: approverRecord ame_util.approverRecord2;
2855: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2856: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REJECTED_STATUS_TO_AME';
2857: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2858:
2859: BEGIN
2860:
2861: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 2877: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

2873: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);
2874:
2875: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2876: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2877: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2878: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2879:
2880:
2881: approverRecord.name := l_approver_user_name;

Line 2941: l_loan_approval_using_ame fnd_profile_option_values.profile_option_value%TYPE;

2937: actid in number,
2938: funcmode in varchar2,
2939: resultout out NOCOPY varchar2 ) IS
2940:
2941: l_loan_approval_using_ame fnd_profile_option_values.profile_option_value%TYPE;
2942: l_api_name CONSTANT VARCHAR2(30) := 'APPROVE_LOAN_USING_AME';
2943: BEGIN
2944: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2945:

Line 2951: l_loan_approval_using_ame := FND_PROFILE.value('AME:Installed');

2947: resultout := wf_engine.eng_null;
2948: return;
2949: END IF;
2950:
2951: l_loan_approval_using_ame := FND_PROFILE.value('AME:Installed');
2952:
2953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AME:Installed : ' || l_loan_approval_using_ame);
2954:
2955: IF NVL(l_loan_approval_using_ame,'N') = 'N' THEN

Line 3165: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_nRespId, 206, l_AMEEnabled, l_bAMEProfileDefined);

3161:
3162: ----------------------------------------------------
3163: l_debug_info := 'Retrieve profile option AME Enabled';
3164: ----------------------------------------------------
3165: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_nRespId, 206, l_AMEEnabled, l_bAMEProfileDefined);
3166:
3167: if l_bAMEProfileDefined then
3168: -----------------------------------------------
3169: -- check the profile option value if it's defined

Line 3443: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');

3439: G_LOG_ENABLED := 'N';
3440: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3441:
3442: /* getting msg logging info */
3443: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3444: IF (G_LOG_ENABLED = 'N') then
3445: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3446: ELSE
3447: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

Line 3447: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

3443: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3444: IF (G_LOG_ENABLED = 'N') then
3445: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3446: ELSE
3447: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3448: END IF;
3449: END LNS_WORK_FLOW;