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.GL_AUTO_ALLOC_WF_PKG dependencies on FND_PROFILE

Line 64: l_value fnd_profile_option_values.profile_option_value%TYPE;

60: l_resp_appl_id NUMBER;
61: l_business_group_id NUMBER;
62: l_gl_allow_preparer_approval Varchar2(30);
63: l_continue_next_step Varchar2(1);
64: l_value fnd_profile_option_values.profile_option_value%TYPE;
65: l_WorkFlow_Launch Boolean;
66: fnd_user_name Varchar2(100);
67: Cursor c_set_name IS
68: Select

Line 152: FND_PROFILE.GET('GL_AUTO_ALLOC_ROLLBACK_ALLOWED', l_value);

148:
149: l_rollback_allowed := 'N' ;
150: Else
151: l_WorkFlow_Launch := TRUE;
152: FND_PROFILE.GET('GL_AUTO_ALLOC_ROLLBACK_ALLOWED', l_value);
153: If l_value = 'Y' Then
154: l_rollback_allowed := 'Y';
155: Else
156: l_rollback_allowed := 'N';

Line 194: FND_PROFILE.GET('USER_ID', l_user_id);

190: itemkey => p_item_key,
191: aname => 'SET_REQ_ID',
192: avalue => p_request_Id );
193:
194: FND_PROFILE.GET('USER_ID', l_user_id);
195: if(l_org_id is null) then
196: FND_PROFILE.GET('ORG_ID', l_org_id);
197: end if;
198: FND_PROFILE.GET('RESP_ID', l_resp_id);

Line 196: FND_PROFILE.GET('ORG_ID', l_org_id);

192: avalue => p_request_Id );
193:
194: FND_PROFILE.GET('USER_ID', l_user_id);
195: if(l_org_id is null) then
196: FND_PROFILE.GET('ORG_ID', l_org_id);
197: end if;
198: FND_PROFILE.GET('RESP_ID', l_resp_id);
199: FND_PROFILE.GET('RESP_APPL_ID', l_resp_appl_id);
200: FND_PROFILE.GET('PER_BUSINESS_GROUP_ID', l_business_group_id);

Line 198: FND_PROFILE.GET('RESP_ID', l_resp_id);

194: FND_PROFILE.GET('USER_ID', l_user_id);
195: if(l_org_id is null) then
196: FND_PROFILE.GET('ORG_ID', l_org_id);
197: end if;
198: FND_PROFILE.GET('RESP_ID', l_resp_id);
199: FND_PROFILE.GET('RESP_APPL_ID', l_resp_appl_id);
200: FND_PROFILE.GET('PER_BUSINESS_GROUP_ID', l_business_group_id);
201: FND_PROFILE.GET('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
202:

Line 199: FND_PROFILE.GET('RESP_APPL_ID', l_resp_appl_id);

195: if(l_org_id is null) then
196: FND_PROFILE.GET('ORG_ID', l_org_id);
197: end if;
198: FND_PROFILE.GET('RESP_ID', l_resp_id);
199: FND_PROFILE.GET('RESP_APPL_ID', l_resp_appl_id);
200: FND_PROFILE.GET('PER_BUSINESS_GROUP_ID', l_business_group_id);
201: FND_PROFILE.GET('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
202:
203: -- Get AOL user name

Line 200: FND_PROFILE.GET('PER_BUSINESS_GROUP_ID', l_business_group_id);

196: FND_PROFILE.GET('ORG_ID', l_org_id);
197: end if;
198: FND_PROFILE.GET('RESP_ID', l_resp_id);
199: FND_PROFILE.GET('RESP_APPL_ID', l_resp_appl_id);
200: FND_PROFILE.GET('PER_BUSINESS_GROUP_ID', l_business_group_id);
201: FND_PROFILE.GET('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
202:
203: -- Get AOL user name
204: Open f_user_name;

Line 201: FND_PROFILE.GET('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);

197: end if;
198: FND_PROFILE.GET('RESP_ID', l_resp_id);
199: FND_PROFILE.GET('RESP_APPL_ID', l_resp_appl_id);
200: FND_PROFILE.GET('PER_BUSINESS_GROUP_ID', l_business_group_id);
201: FND_PROFILE.GET('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
202:
203: -- Get AOL user name
204: Open f_user_name;
205: fetch f_user_name into fnd_user_name;

Line 213: FND_PROFILE.GET('GL_JRNL_REVW_REQUIRED', l_value);

209: wf_engine.SetItemOwner( itemtype => p_item_type,
210: itemkey => p_item_key,
211: owner => fnd_user_name );
212:
213: FND_PROFILE.GET('GL_JRNL_REVW_REQUIRED', l_value);
214: wf_engine.SetItemAttrText( itemtype => p_item_type,
215: itemkey => p_item_key,
216: aname => 'GL_JRNL_REVW_REQUIRED',
217: avalue => l_value );

Line 220: FND_PROFILE.GET('GL_AUTO_ALLOC_CONTINUE_NEXT_STEP', l_value);

216: aname => 'GL_JRNL_REVW_REQUIRED',
217: avalue => l_value );
218:
219: -- Bug 2043415
220: FND_PROFILE.GET('GL_AUTO_ALLOC_CONTINUE_NEXT_STEP', l_value);
221:
222: If l_value = 'Y' Then
223: l_continue_next_step := 'Y';
224: Else

Line 785: l_batch_review_required fnd_profile_option_values.profile_option_value%TYPE;

781: p_actid IN NUMBER,
782: p_funcmode IN VARCHAR2,
783: p_result OUT NOCOPY VARCHAR2) Is
784:
785: l_batch_review_required fnd_profile_option_values.profile_option_value%TYPE;
786: l_step_number Number;
787: l_rollback_allowed Varchar2(1);
788: l_message_Name Varchar2(150);
789:

Line 1027: FND_PROFILE.put('ORG_ID', l_org_id);

1023: p_item_key,
1024: 'GL_ALLOW_PREPARER_APPROVAL');
1025:
1026:
1027: FND_PROFILE.put('ORG_ID', l_org_id);
1028: FND_PROFILE.put('USER_ID', l_user_id );
1029: FND_PROFILE.put('RESP_ID', l_resp_id);
1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);

Line 1028: FND_PROFILE.put('USER_ID', l_user_id );

1024: 'GL_ALLOW_PREPARER_APPROVAL');
1025:
1026:
1027: FND_PROFILE.put('ORG_ID', l_org_id);
1028: FND_PROFILE.put('USER_ID', l_user_id );
1029: FND_PROFILE.put('RESP_ID', l_resp_id);
1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);
1032: FND_PROFILE.put('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);

Line 1029: FND_PROFILE.put('RESP_ID', l_resp_id);

1025:
1026:
1027: FND_PROFILE.put('ORG_ID', l_org_id);
1028: FND_PROFILE.put('USER_ID', l_user_id );
1029: FND_PROFILE.put('RESP_ID', l_resp_id);
1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);
1032: FND_PROFILE.put('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
1033:

Line 1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);

1026:
1027: FND_PROFILE.put('ORG_ID', l_org_id);
1028: FND_PROFILE.put('USER_ID', l_user_id );
1029: FND_PROFILE.put('RESP_ID', l_resp_id);
1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);
1032: FND_PROFILE.put('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
1033:
1034: OPEN jrnl_approval_status_C;

Line 1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);

1027: FND_PROFILE.put('ORG_ID', l_org_id);
1028: FND_PROFILE.put('USER_ID', l_user_id );
1029: FND_PROFILE.put('RESP_ID', l_resp_id);
1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);
1032: FND_PROFILE.put('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
1033:
1034: OPEN jrnl_approval_status_C;
1035: LOOP

Line 1032: FND_PROFILE.put('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);

1028: FND_PROFILE.put('USER_ID', l_user_id );
1029: FND_PROFILE.put('RESP_ID', l_resp_id);
1030: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
1031: FND_PROFILE.put('PER_BUSINESS_GROUP_ID', l_business_group_id);
1032: FND_PROFILE.put('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
1033:
1034: OPEN jrnl_approval_status_C;
1035: LOOP
1036: fetch jrnl_approval_status_C into l_approval_code, l_gen_batch_name,l_gen_batch_id;

Line 3229: FND_PROFILE.put('ORG_ID', l_org_id);

3225: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3226: diagn_debug_msg('WAITING_TO_COMPLETE: ' || 'CLINT_INFO='||l_client_info);
3227: END IF;
3228:
3229: FND_PROFILE.put('ORG_ID', l_org_id);
3230: FND_PROFILE.put('USER_ID', l_user_id );
3231: FND_PROFILE.put('RESP_ID', l_resp_id);
3232: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3233:

Line 3230: FND_PROFILE.put('USER_ID', l_user_id );

3226: diagn_debug_msg('WAITING_TO_COMPLETE: ' || 'CLINT_INFO='||l_client_info);
3227: END IF;
3228:
3229: FND_PROFILE.put('ORG_ID', l_org_id);
3230: FND_PROFILE.put('USER_ID', l_user_id );
3231: FND_PROFILE.put('RESP_ID', l_resp_id);
3232: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3233:
3234: FND_PROFILE.get('STEP_DOWN_INTERVAL',l_profile_value);

Line 3231: FND_PROFILE.put('RESP_ID', l_resp_id);

3227: END IF;
3228:
3229: FND_PROFILE.put('ORG_ID', l_org_id);
3230: FND_PROFILE.put('USER_ID', l_user_id );
3231: FND_PROFILE.put('RESP_ID', l_resp_id);
3232: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3233:
3234: FND_PROFILE.get('STEP_DOWN_INTERVAL',l_profile_value);
3235:

Line 3232: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);

3228:
3229: FND_PROFILE.put('ORG_ID', l_org_id);
3230: FND_PROFILE.put('USER_ID', l_user_id );
3231: FND_PROFILE.put('RESP_ID', l_resp_id);
3232: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3233:
3234: FND_PROFILE.get('STEP_DOWN_INTERVAL',l_profile_value);
3235:
3236: IF (l_profile_value is NULL) THEN

Line 3234: FND_PROFILE.get('STEP_DOWN_INTERVAL',l_profile_value);

3230: FND_PROFILE.put('USER_ID', l_user_id );
3231: FND_PROFILE.put('RESP_ID', l_resp_id);
3232: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3233:
3234: FND_PROFILE.get('STEP_DOWN_INTERVAL',l_profile_value);
3235:
3236: IF (l_profile_value is NULL) THEN
3237: l_profile_value := 30;
3238: END IF;

Line 3963: FND_PROFILE.put('ORG_ID', l_org_id);

3959:
3960: --Bug fix 1971413
3961: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3962:
3963: FND_PROFILE.put('ORG_ID', l_org_id);
3964: FND_PROFILE.put('USER_ID', l_user_id );
3965: FND_PROFILE.put('RESP_ID', l_resp_id);
3966: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3967:

Line 3964: FND_PROFILE.put('USER_ID', l_user_id );

3960: --Bug fix 1971413
3961: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3962:
3963: FND_PROFILE.put('ORG_ID', l_org_id);
3964: FND_PROFILE.put('USER_ID', l_user_id );
3965: FND_PROFILE.put('RESP_ID', l_resp_id);
3966: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3967:
3968: select userenv('LANG') into l_userenv_lang from dual;

Line 3965: FND_PROFILE.put('RESP_ID', l_resp_id);

3961: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3962:
3963: FND_PROFILE.put('ORG_ID', l_org_id);
3964: FND_PROFILE.put('USER_ID', l_user_id );
3965: FND_PROFILE.put('RESP_ID', l_resp_id);
3966: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3967:
3968: select userenv('LANG') into l_userenv_lang from dual;
3969: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN

Line 3966: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);

3962:
3963: FND_PROFILE.put('ORG_ID', l_org_id);
3964: FND_PROFILE.put('USER_ID', l_user_id );
3965: FND_PROFILE.put('RESP_ID', l_resp_id);
3966: FND_PROFILE.put('RESP_APPL_ID', l_resp_appl_id);
3967:
3968: select userenv('LANG') into l_userenv_lang from dual;
3969: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3970: diagn_debug_msg('Submit_Request: ' || 'LANG='||l_userenv_lang);