DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on FND_GLOBAL

Line 161: --fnd_global.apps_initialize(1013429, 62494, 206);

157: cp.concurrent_program_name in ('LNS_BILLING','LNS_GL_TRANSFER'));
158:
159: BEGIN
160:
161: --fnd_global.apps_initialize(1013429, 62494, 206);
162:
163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
164:
165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);

Line 168: -- set user from fnd_global first

164:
165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);
166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:
168: -- set user from fnd_global first
169: l_user_id := fnd_global.user_id;
170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);
171:
172: if l_user_id is null or l_user_id = -1 then

Line 169: l_user_id := fnd_global.user_id;

165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);
166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:
168: -- set user from fnd_global first
169: l_user_id := fnd_global.user_id;
170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);
171:
172: if l_user_id is null or l_user_id = -1 then
173:

Line 170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);

166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:
168: -- set user from fnd_global first
169: l_user_id := fnd_global.user_id;
170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);
171:
172: if l_user_id is null or l_user_id = -1 then
173:
174: OPEN csr_notification(p_itemtype, p_itemkey);

Line 248: -- set resp from fnd_global first

244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot set session context because cannot find user_id');
245: return;
246: end if;
247:
248: -- set resp from fnd_global first
249: l_global_resp_id := fnd_global.resp_id;
250: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '4. Trying to get resp_id from fnd_global.resp_id = ' || l_global_resp_id);
251: OPEN csr_get_resp(l_user_id, l_global_resp_id);
252: FETCH csr_get_resp INTO

Line 249: l_global_resp_id := fnd_global.resp_id;

245: return;
246: end if;
247:
248: -- set resp from fnd_global first
249: l_global_resp_id := fnd_global.resp_id;
250: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '4. Trying to get resp_id from fnd_global.resp_id = ' || l_global_resp_id);
251: OPEN csr_get_resp(l_user_id, l_global_resp_id);
252: FETCH csr_get_resp INTO
253: l_user_name,

Line 250: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '4. Trying to get resp_id from fnd_global.resp_id = ' || l_global_resp_id);

246: end if;
247:
248: -- set resp from fnd_global first
249: l_global_resp_id := fnd_global.resp_id;
250: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '4. Trying to get resp_id from fnd_global.resp_id = ' || l_global_resp_id);
251: OPEN csr_get_resp(l_user_id, l_global_resp_id);
252: FETCH csr_get_resp INTO
253: l_user_name,
254: l_resp_id,

Line 293: fnd_global.apps_initialize(l_user_id, l_resp_id, 206);

289: end if;
290:
291: if l_user_id is not null and l_user_id > -1 and l_resp_id is not null and l_resp_id > -1 then
292: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting session context with user_id = ' || l_user_id || ' and resp_id = ' || l_resp_id);
293: fnd_global.apps_initialize(l_user_id, l_resp_id, 206);
294: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Session context is set successfully!');
295: end if;
296:
297: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');

Line 878: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);

874: FETCH c_get_user_resps
875: INTO l_resp_id;
876: EXIT USER_RESPS_LOOP WHEN c_get_user_resps%NOTFOUND;
877: --initialize the session context with the user and resp info
878: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);
879: --begin R12 specific
880: MO_GLOBAL.INIT('LNS');
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

Line 2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);

2210: aname => 'LNS_PRIMARY_ROLE');
2211: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);
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);

Line 2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);

2211: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);
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);

Line 2786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);

2782: aname => 'LNS_LAST_ENTERED_NOTE',
2783: avalue => l_loan_approve_note);
2784:
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);

Line 2787: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.resp_id : ' || fnd_global.resp_id);

2783: avalue => l_loan_approve_note);
2784:
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:

Line 2788: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);

2784:
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:

Line 2875: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);

2871: itemkey => p_item_key,
2872: aname => 'LNS_LOAN_ID');
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:

Line 2876: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);

2872: aname => 'LNS_LOAN_ID');
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: