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.IGP_AD_USERID_PKG dependencies on FND_LOG

Line 95: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

91: IF (funcmode = 'RUN') THEN
92: l_requestor := NULL;
93: l_approver := NULL;
94:
95: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
96: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','itemkey:'||itemkey);
97: END IF;
98:
99: l_item_key := itemkey;

Line 96: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','itemkey:'||itemkey);

92: l_requestor := NULL;
93: l_approver := NULL;
94:
95: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
96: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','itemkey:'||itemkey);
97: END IF;
98:
99: l_item_key := itemkey;
100: l_party_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID');

Line 126: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

122: OPEN c_get_party_name(l_party_id);
123: FETCH c_get_party_name INTO l_party_det;
124: CLOSE c_get_party_name;
125:
126: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
127: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_party_det.name :'||l_party_det.party_name);
128: END IF;
129:
130: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER', l_party_det.party_number);

Line 127: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_party_det.name :'||l_party_det.party_name);

123: FETCH c_get_party_name INTO l_party_det;
124: CLOSE c_get_party_name;
125:
126: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
127: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_party_det.name :'||l_party_det.party_name);
128: END IF;
129:
130: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER', l_party_det.party_number);
131: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NAME', l_party_det.party_name);

Line 135: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

131: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NAME', l_party_det.party_name);
132:
133: IF (l_user_id IS NOT NULL) THEN
134:
135: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
136: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','UserId passed is Not Null' ||l_user_id);
137: END IF;
138: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'ACCOUNT'); -- Already a FND user. Only Portfolio a/c is reqd.
139: ELSE

Line 136: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','UserId passed is Not Null' ||l_user_id);

132:
133: IF (l_user_id IS NOT NULL) THEN
134:
135: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
136: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','UserId passed is Not Null' ||l_user_id);
137: END IF;
138: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'ACCOUNT'); -- Already a FND user. Only Portfolio a/c is reqd.
139: ELSE
140:

Line 141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

137: END IF;
138: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'ACCOUNT'); -- Already a FND user. Only Portfolio a/c is reqd.
139: ELSE
140:
141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
142: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','UserId passed is Null');
143: END IF;
144: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'BOTH'); -- Both FND and Portfolio a/c have to be created.
145: END IF;

Line 142: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','UserId passed is Null');

138: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'ACCOUNT'); -- Already a FND user. Only Portfolio a/c is reqd.
139: ELSE
140:
141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
142: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','UserId passed is Null');
143: END IF;
144: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'BOTH'); -- Both FND and Portfolio a/c have to be created.
145: END IF;
146:

Line 178: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

174: fnd_global.user_id
175: );
176: EXCEPTION
177: WHEN OTHERS THEN
178: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
179: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_user_id.record_data','Exception while recording data in interface table.'||SQLERRM);
180: END IF;
181: resultout := 'COMPLETE:IGP_FAIL';
182: RAISE;

Line 179: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_user_id.record_data','Exception while recording data in interface table.'||SQLERRM);

175: );
176: EXCEPTION
177: WHEN OTHERS THEN
178: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
179: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_user_id.record_data','Exception while recording data in interface table.'||SQLERRM);
180: END IF;
181: resultout := 'COMPLETE:IGP_FAIL';
182: RAISE;
183: END;

Line 221: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

217: fnd_global.user_id
218: );
219: EXCEPTION
220: WHEN OTHERS THEN
221: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_user_id.record_data','For User: ' || l_user_id || ' Exception while recording data in interface table.'||SQLERRM);
223: END IF;
224: resultout := 'COMPLETE:IGP_FAIL';
225: RAISE;

Line 222: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_user_id.record_data','For User: ' || l_user_id || ' Exception while recording data in interface table.'||SQLERRM);

218: );
219: EXCEPTION
220: WHEN OTHERS THEN
221: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_user_id.record_data','For User: ' || l_user_id || ' Exception while recording data in interface table.'||SQLERRM);
223: END IF;
224: resultout := 'COMPLETE:IGP_FAIL';
225: RAISE;
226: END;

Line 235: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

231:
232: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME', l_requestor);
233: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_requestor);
234:
235: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
236: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','Fetching user name for existing user l_requestor'||l_requestor);
237: END IF;
238:
239: END IF;

Line 236: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','Fetching user name for existing user l_requestor'||l_requestor);

232: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME', l_requestor);
233: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_requestor);
234:
235: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
236: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','Fetching user name for existing user l_requestor'||l_requestor);
237: END IF;
238:
239: END IF;
240: -- Set the message of the approval message based on the parameters.

Line 270: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

266: END IF;
267: END IF;
268: wf_engine.SetItemAttrText(itemtype,itemkey,'P_MESSAGE_TEXT', l_message_text); -- Set the parameter of the workflow to contain the approval message text.
269:
270: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
271: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_message_text :'||l_message_text);
272: END IF;
273:
274: l_approver:=fnd_profile.value('IGP_ADMIN_WF_APPROVER');

Line 271: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_message_text :'||l_message_text);

267: END IF;
268: wf_engine.SetItemAttrText(itemtype,itemkey,'P_MESSAGE_TEXT', l_message_text); -- Set the parameter of the workflow to contain the approval message text.
269:
270: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
271: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','l_message_text :'||l_message_text);
272: END IF;
273:
274: l_approver:=fnd_profile.value('IGP_ADMIN_WF_APPROVER');
275:

Line 277: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

273:
274: l_approver:=fnd_profile.value('IGP_ADMIN_WF_APPROVER');
275:
276: IF (l_approver IS NULL) THEN
277: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
278: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver not defined');
279: END IF;
280: resultout := 'COMPLETE:IGP_FAIL'; -- Approver not defined.
281: ELSE

Line 278: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver not defined');

274: l_approver:=fnd_profile.value('IGP_ADMIN_WF_APPROVER');
275:
276: IF (l_approver IS NULL) THEN
277: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
278: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver not defined');
279: END IF;
280: resultout := 'COMPLETE:IGP_FAIL'; -- Approver not defined.
281: ELSE
282: OPEN c_get_approver_email(l_approver);

Line 288: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

284: CLOSE c_get_approver_email;
285: l_approver_mail_url:=''||l_approver_email||'';
286: wf_engine.SetItemAttrText(itemtype,itemkey,'P_APPROVER', l_approver); -- Set the value for the approver, picked from profile.
287: wf_engine.SetItemAttrText(itemtype,itemkey,'P_APPROVER_EMAIL', l_approver_mail_url);
288: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver '||l_approver);
290: END IF;
291: IF (l_classification_cd = 'EXTERNAL') THEN
292: fnd_message.set_name('IGS','IGP_AD_EXTERNAL_NOTE');

Line 289: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver '||l_approver);

285: l_approver_mail_url:=''||l_approver_email||'';
286: wf_engine.SetItemAttrText(itemtype,itemkey,'P_APPROVER', l_approver); -- Set the value for the approver, picked from profile.
287: wf_engine.SetItemAttrText(itemtype,itemkey,'P_APPROVER_EMAIL', l_approver_mail_url);
288: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
289: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_user_id.record_data','approver '||l_approver);
290: END IF;
291: IF (l_classification_cd = 'EXTERNAL') THEN
292: fnd_message.set_name('IGS','IGP_AD_EXTERNAL_NOTE');
293: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE',fnd_message.get);

Line 311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

307: END IF; -- for if funcmode='RUN'
308: EXCEPTION
309: WHEN others THEN
310: resultout := 'COMPLETE:IGP_FAIL';
311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
312: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.record_data','Unhandled Exception in Record Data ' ||sqlerrm);
313: END IF;
314: END RECORD_DATA;
315:

Line 312: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.record_data','Unhandled Exception in Record Data ' ||sqlerrm);

308: EXCEPTION
309: WHEN others THEN
310: resultout := 'COMPLETE:IGP_FAIL';
311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
312: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.record_data','Unhandled Exception in Record Data ' ||sqlerrm);
313: END IF;
314: END RECORD_DATA;
315:
316: PROCEDURE CHECK_EXISTING_ACCOUNT(itemtype IN VARCHAR2,

Line 355: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

351: l_exists := 'N';
352: OPEN c_exists_acc(l_acc_type,l_user_id);
353: FETCH c_exists_acc INTO l_exists;
354: CLOSE c_exists_acc;
355: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
356: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.check_existing_account','l_exists :'||l_exists);
357: END IF;
358: IF (l_exists = 'Y') THEN
359: resultout := 'COMPLETE:Y';

Line 356: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.check_existing_account','l_exists :'||l_exists);

352: OPEN c_exists_acc(l_acc_type,l_user_id);
353: FETCH c_exists_acc INTO l_exists;
354: CLOSE c_exists_acc;
355: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
356: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.check_existing_account','l_exists :'||l_exists);
357: END IF;
358: IF (l_exists = 'Y') THEN
359: resultout := 'COMPLETE:Y';
360: BEGIN

Line 364: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

360: BEGIN
361: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
362: EXCEPTION
363: WHEN others THEN
364: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
365: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','While deleting record from Interface table :'||sqlerrm);
366: END IF;
367: END;
368: ELSE

Line 365: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','While deleting record from Interface table :'||sqlerrm);

361: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
362: EXCEPTION
363: WHEN others THEN
364: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
365: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','While deleting record from Interface table :'||sqlerrm);
366: END IF;
367: END;
368: ELSE
369: resultout := 'COMPLETE:N';

Line 377: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

373: END IF;
374: END IF; --funcmode
375: EXCEPTION
376: WHEN others THEN
377: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
378: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','Unhandled exception :'||sqlerrm);
379: END IF;
380: END CHECK_EXISTING_ACCOUNT;
381:

Line 378: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','Unhandled exception :'||sqlerrm);

374: END IF; --funcmode
375: EXCEPTION
376: WHEN others THEN
377: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
378: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','Unhandled exception :'||sqlerrm);
379: END IF;
380: END CHECK_EXISTING_ACCOUNT;
381:
382: PROCEDURE CHECK_ACTION(itemtype IN VARCHAR2,

Line 407: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

403: resultout := 'COMPLETE:ACCOUNT';
404: ELSIF (l_action='BOTH')THEN
405: resultout := 'COMPLETE:BOTH';
406: END IF;
407: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
408: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.check_action','l_action :'||l_action);
409: END IF;
410: END IF;
411: EXCEPTION

Line 408: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.check_action','l_action :'||l_action);

404: ELSIF (l_action='BOTH')THEN
405: resultout := 'COMPLETE:BOTH';
406: END IF;
407: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
408: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.check_action','l_action :'||l_action);
409: END IF;
410: END IF;
411: EXCEPTION
412: WHEN others THEN

Line 413: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

409: END IF;
410: END IF;
411: EXCEPTION
412: WHEN others THEN
413: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
414: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','Unhandled exception :'||sqlerrm);
415: END IF;
416: END CHECK_ACTION;
417:

Line 414: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','Unhandled exception :'||sqlerrm);

410: END IF;
411: EXCEPTION
412: WHEN others THEN
413: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
414: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.check_action','Unhandled exception :'||sqlerrm);
415: END IF;
416: END CHECK_ACTION;
417:
418: PROCEDURE VALIDATE_USER_NAME(itemtype IN VARCHAR2,

Line 446: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

442: l_message_text := NULL;
443: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
444: l_exists:='N';
445: if FND_SSO_MANAGER.isUserCreateUpdateAllowed() then
446: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name', ' User create and update allowed.');
448: END IF;
449:
450: -- test user already exist, output of testusername

Line 447: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name', ' User create and update allowed.');

443: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
444: l_exists:='N';
445: if FND_SSO_MANAGER.isUserCreateUpdateAllowed() then
446: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name', ' User create and update allowed.');
448: END IF;
449:
450: -- test user already exist, output of testusername
451: --@ USER_OK_CREATE constant pls_integer := 0;

Line 458: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

454: --@ USER_SYNCHED constant pls_integer := 3;
455: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
456: l_num := fnd_user_pkg.testusername(x_user_name=>l_user_name);
457: if l_num = 0 then
458: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_exists :'||l_exists);
460: END IF;
461: resultout := 'COMPLETE:Y'; -- No FND user with this name exists.
462: elsif l_num = 1 then

Line 459: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_exists :'||l_exists);

455: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
456: l_num := fnd_user_pkg.testusername(x_user_name=>l_user_name);
457: if l_num = 0 then
458: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_exists :'||l_exists);
460: END IF;
461: resultout := 'COMPLETE:Y'; -- No FND user with this name exists.
462: elsif l_num = 1 then
463: fnd_message.set_name('IGS','IGP_AD_INVALID_USR_NAME'); -- Invalid user name

Line 468: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

464: fnd_message.set_token('USERNAME',l_user_name);
465: l_message_text := fnd_message.get;
466:
467: resultout := 'COMPLETE:N'; -- user name does not comply user name policy
468: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name || ' does not comply user name policy.');
470: END IF;
471: elsif l_num = 2 then
472: fnd_message.set_name('IGS','IGP_AD_USR_ALREADY_REGISTERED'); -- User already registered in fnd

Line 469: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name || ' does not comply user name policy.');

465: l_message_text := fnd_message.get;
466:
467: resultout := 'COMPLETE:N'; -- user name does not comply user name policy
468: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name || ' does not comply user name policy.');
470: END IF;
471: elsif l_num = 2 then
472: fnd_message.set_name('IGS','IGP_AD_USR_ALREADY_REGISTERED'); -- User already registered in fnd
473: fnd_message.set_token('USERNAME',l_user_name);

Line 477: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

473: fnd_message.set_token('USERNAME',l_user_name);
474: l_message_text := fnd_message.get;
475:
476: resultout := 'COMPLETE:N'; -- user name already exist in fnd_user.
477: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
478: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name || ' user name already exist in fnd_user.');
479: END IF;
480: else -- if l_num = 3 or 4
481: fnd_message.set_name('IGS','IGP_AD_USR_ALREADY_REG_IN_OID'); -- User already registered in OID

Line 478: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name || ' user name already exist in fnd_user.');

474: l_message_text := fnd_message.get;
475:
476: resultout := 'COMPLETE:N'; -- user name already exist in fnd_user.
477: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
478: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name || ' user name already exist in fnd_user.');
479: END IF;
480: else -- if l_num = 3 or 4
481: fnd_message.set_name('IGS','IGP_AD_USR_ALREADY_REG_IN_OID'); -- User already registered in OID
482: fnd_message.set_token('USERNAME',l_user_name);

Line 485: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

481: fnd_message.set_name('IGS','IGP_AD_USR_ALREADY_REG_IN_OID'); -- User already registered in OID
482: fnd_message.set_token('USERNAME',l_user_name);
483: l_message_text := fnd_message.get;
484: resultout := 'COMPLETE:N'; -- user name is already in use with Oracle Internet Directory.
485: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
486: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name||' is already in use with Oracle Internet Directory.');
487:
488: END IF;
489: end if; -- FOR l_num = 0

Line 486: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name||' is already in use with Oracle Internet Directory.');

482: fnd_message.set_token('USERNAME',l_user_name);
483: l_message_text := fnd_message.get;
484: resultout := 'COMPLETE:N'; -- user name is already in use with Oracle Internet Directory.
485: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
486: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name','l_user_name :'||l_user_name||' is already in use with Oracle Internet Directory.');
487:
488: END IF;
489: end if; -- FOR l_num = 0
490: else

Line 497: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

493: fnd_message.set_name('IGS','IGP_AD_USR_CRT_UPD_NOT_ALOWED'); -- Creation or updating of a user is not allowed.
494: l_message_text := fnd_message.get;
495: resultout := 'COMPLETE:N'; -- Creation or updating of a user is not allowed.
496:
497: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
498: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name',' Creation or updating of a user is not allowed.');
499: END IF;
500: end if; -- FOR FND_SSO_MANAGER.isUserCreateUpdateAllowed()
501:

Line 498: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name',' Creation or updating of a user is not allowed.');

494: l_message_text := fnd_message.get;
495: resultout := 'COMPLETE:N'; -- Creation or updating of a user is not allowed.
496:
497: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
498: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name',' Creation or updating of a user is not allowed.');
499: END IF;
500: end if; -- FOR FND_SSO_MANAGER.isUserCreateUpdateAllowed()
501:
502: -- clean up the record from igp_ac_account_ints

Line 508: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

504: BEGIN
505: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
506: EXCEPTION
507: WHEN others THEN
508: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
509: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.validate_user_name','While deleting record from Interface table :'||sqlerrm);
510: END IF;
511: END;
512: end if;

Line 509: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.validate_user_name','While deleting record from Interface table :'||sqlerrm);

505: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
506: EXCEPTION
507: WHEN others THEN
508: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
509: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.validate_user_name','While deleting record from Interface table :'||sqlerrm);
510: END IF;
511: END;
512: end if;
513:

Line 520: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

516:
517: END IF;
518: EXCEPTION
519: WHEN others THEN
520: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
521: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.validate_user_name','Unhandled exception :'||sqlerrm);
522: END IF;
523: END VALIDATE_USER_NAME;
524:

Line 521: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.validate_user_name','Unhandled exception :'||sqlerrm);

517: END IF;
518: EXCEPTION
519: WHEN others THEN
520: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
521: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.validate_user_name','Unhandled exception :'||sqlerrm);
522: END IF;
523: END VALIDATE_USER_NAME;
524:
525: PROCEDURE CREATE_FND_USER(itemtype IN VARCHAR2,

Line 566: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

562: IF (l_user_password IS NULL) OR (length(l_user_password)<5) THEN
563: l_user_password:=GENERATE_PASSWORD(l_party_id);
564: Wf_Engine.SetItemAttrText(itemtype,itemkey,'P_PASSWORD',l_user_password);
565: END IF;
566: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','Creating user with values :'||l_party_id||' '||l_user_name||' '||l_email_address);
568: END IF;
569: -- Now, call FND package to create the FND user.
570: begin

Line 567: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','Creating user with values :'||l_party_id||' '||l_user_name||' '||l_email_address);

563: l_user_password:=GENERATE_PASSWORD(l_party_id);
564: Wf_Engine.SetItemAttrText(itemtype,itemkey,'P_PASSWORD',l_user_password);
565: END IF;
566: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','Creating user with values :'||l_party_id||' '||l_user_name||' '||l_email_address);
568: END IF;
569: -- Now, call FND package to create the FND user.
570: begin
571: fnd_user_pkg.CreateUser (

Line 588: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

584:
585: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_USER_ID', l_user_id); -- set the FND user ID. To be used later.
586: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_user_name);
587: resultout := 'COMPLETE:IGP_SUCCESS';
588: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_id :'||l_user_id);
590: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_name :'||l_user_name);
591: END IF;
592: exception

Line 589: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_id :'||l_user_id);

585: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_USER_ID', l_user_id); -- set the FND user ID. To be used later.
586: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_user_name);
587: resultout := 'COMPLETE:IGP_SUCCESS';
588: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_id :'||l_user_id);
590: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_name :'||l_user_name);
591: END IF;
592: exception
593: when others then

Line 590: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_name :'||l_user_name);

586: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_user_name);
587: resultout := 'COMPLETE:IGP_SUCCESS';
588: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_id :'||l_user_id);
590: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','l_user_name :'||l_user_name);
591: END IF;
592: exception
593: when others then
594: delete from igp_ac_account_ints where item_key= itemkey;

Line 595: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

591: END IF;
592: exception
593: when others then
594: delete from igp_ac_account_ints where item_key= itemkey;
595: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
596: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','error while creating FND user.');
597: END IF;
598: resultout := 'COMPLETE:IGP_FAIL';
599: end;

Line 596: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','error while creating FND user.');

592: exception
593: when others then
594: delete from igp_ac_account_ints where item_key= itemkey;
595: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
596: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','error while creating FND user.');
597: END IF;
598: resultout := 'COMPLETE:IGP_FAIL';
599: end;
600:

Line 604: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

600:
601: END IF; -- for funcmode='RUN'
602: EXCEPTION
603: WHEN others THEN
604: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
605: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','Unhandled Exception :'||sqlerrm);
606: END IF;
607: resultout := 'COMPLETE:IGP_FAIL';
608: END CREATE_FND_USER;

Line 605: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','Unhandled Exception :'||sqlerrm);

601: END IF; -- for funcmode='RUN'
602: EXCEPTION
603: WHEN others THEN
604: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
605: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_fnd_user','Unhandled Exception :'||sqlerrm);
606: END IF;
607: resultout := 'COMPLETE:IGP_FAIL';
608: END CREATE_FND_USER;
609:

Line 692: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

688: OPEN c_is_port_user(l_party_id);
689: FETCH c_is_port_user INTO l_account_id;
690: CLOSE c_is_port_user;
691:
692: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Existing account ID is l_account_id :'||l_account_id);
694: END IF;
695:
696: IF (l_account_id IS NOT NULL) THEN

Line 693: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Existing account ID is l_account_id :'||l_account_id);

689: FETCH c_is_port_user INTO l_account_id;
690: CLOSE c_is_port_user;
691:
692: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
693: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Existing account ID is l_account_id :'||l_account_id);
694: END IF;
695:
696: IF (l_account_id IS NOT NULL) THEN
697: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Portfolio a/c exists: Set the value of the account ID in the WF.

Line 710: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

706: x_object_version_number => 1 -- OVN is always 1 for a newly created record.
707: );
708: EXCEPTION
709: WHEN others THEN
710: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception.');
712: END IF;
713: END;
714: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Collect the account_id for the new a/c created and set the value in WF.

Line 711: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception.');

707: );
708: EXCEPTION
709: WHEN others THEN
710: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception.');
712: END IF;
713: END;
714: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Collect the account_id for the new a/c created and set the value in WF.
715: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 715: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

711: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception.');
712: END IF;
713: END;
714: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Collect the account_id for the new a/c created and set the value in WF.
715: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
716: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Newly created account ID : l_account_id :'||l_account_id);
717: END IF;
718: END IF;
719:

Line 716: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Newly created account ID : l_account_id :'||l_account_id);

712: END IF;
713: END;
714: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Collect the account_id for the new a/c created and set the value in WF.
715: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
716: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Newly created account ID : l_account_id :'||l_account_id);
717: END IF;
718: END IF;
719:
720: FOR c_get_resp_rec IN c_get_resp(l_classification_cd)

Line 728: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

724: OPEN c_chk_resp(l_fnd_user_id,c_get_resp_rec.responsibility_id);
725: FETCH c_chk_resp INTO c_chk_resp_rec;
726: CLOSE c_chk_resp;
727:
728: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
729: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp Id :'||c_chk_resp_rec.responsibility_id);
730: END IF;
731:
732: IF (c_chk_resp_rec.responsibility_id IS NOT NULL) THEN --check if we need to update the end date of the FND resp.

Line 729: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp Id :'||c_chk_resp_rec.responsibility_id);

725: FETCH c_chk_resp INTO c_chk_resp_rec;
726: CLOSE c_chk_resp;
727:
728: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
729: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp Id :'||c_chk_resp_rec.responsibility_id);
730: END IF;
731:
732: IF (c_chk_resp_rec.responsibility_id IS NOT NULL) THEN --check if we need to update the end date of the FND resp.
733: l_fnd_resp_end_dt:=c_chk_resp_rec.end_date;

Line 735: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

731:
732: IF (c_chk_resp_rec.responsibility_id IS NOT NULL) THEN --check if we need to update the end date of the FND resp.
733: l_fnd_resp_end_dt:=c_chk_resp_rec.end_date;
734: IF (l_fnd_resp_end_dt IS NOT NULL) THEN
735: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
736: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp end date :'||l_fnd_resp_end_dt);
737: END IF;
738: IF (l_expiration_dt IS NULL) THEN -- Update the FNd resp to be not end dated,.
739: OPEN c_get_resp_desc(c_get_resp_rec.responsibility_id); -- get the desc of the resp. reqd for API call.

Line 736: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp end date :'||l_fnd_resp_end_dt);

732: IF (c_chk_resp_rec.responsibility_id IS NOT NULL) THEN --check if we need to update the end date of the FND resp.
733: l_fnd_resp_end_dt:=c_chk_resp_rec.end_date;
734: IF (l_fnd_resp_end_dt IS NOT NULL) THEN
735: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
736: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp end date :'||l_fnd_resp_end_dt);
737: END IF;
738: IF (l_expiration_dt IS NULL) THEN -- Update the FNd resp to be not end dated,.
739: OPEN c_get_resp_desc(c_get_resp_rec.responsibility_id); -- get the desc of the resp. reqd for API call.
740: FETCH c_get_resp_desc INTO l_desc;

Line 770: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

766: description =>l_desc -- Description.
767: );
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
771: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception while creating user..');
772: END IF;
773: END;
774: END IF;

Line 771: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception while creating user..');

767: );
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
771: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception while creating user..');
772: END IF;
773: END;
774: END IF;
775: END IF;

Line 782: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

778: OPEN c_get_resp_desc(c_get_resp_rec.responsibility_id); -- get the desc of the resp. reqd for API call.
779: FETCH c_get_resp_desc INTO l_desc;
780: CLOSE c_get_resp_desc;
781:
782: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
783: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp desc for new resp :'||l_desc);
784: END IF;
785: fnd_user_resp_groups_api.insert_assignment(
786: user_id => l_fnd_user_id, -- FND user ID.

Line 783: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp desc for new resp :'||l_desc);

779: FETCH c_get_resp_desc INTO l_desc;
780: CLOSE c_get_resp_desc;
781:
782: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
783: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Resp desc for new resp :'||l_desc);
784: END IF;
785: fnd_user_resp_groups_api.insert_assignment(
786: user_id => l_fnd_user_id, -- FND user ID.
787: responsibility_id =>c_get_resp_rec.responsibility_id, -- RESP ID.

Line 799: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

795: END LOOP;
796: -- Insert a record in IGP_AC_ACC_CLASSES table.
797: l_account_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID');
798:
799: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
800: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Account ID :'||l_account_id);
801: END IF;
802:
803: lv_rowid:=NULL;

Line 800: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Account ID :'||l_account_id);

796: -- Insert a record in IGP_AC_ACC_CLASSES table.
797: l_account_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID');
798:
799: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
800: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Account ID :'||l_account_id);
801: END IF;
802:
803: lv_rowid:=NULL;
804: BEGIN

Line 819: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

815: WHERE party_id=l_party_id
816: AND acc_classification_code=l_classification_cd;
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
820: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception while creating user..');
821: END IF;
822: END;
823: resultout:='COMPLETE';

Line 820: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception while creating user..');

816: AND acc_classification_code=l_classification_cd;
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
820: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Unhandled exception while creating user..');
821: END IF;
822: END;
823: resultout:='COMPLETE';
824: END IF;

Line 827: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

823: resultout:='COMPLETE';
824: END IF;
825: EXCEPTION
826: WHEN OTHERS THEN
827: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
828: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Exception :'||sqlerrm);
829: END IF;
830: END CREATE_PORT_ACCOUNT;
831:

Line 828: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Exception :'||sqlerrm);

824: END IF;
825: EXCEPTION
826: WHEN OTHERS THEN
827: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
828: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.create_port_account','Exception :'||sqlerrm);
829: END IF;
830: END CREATE_PORT_ACCOUNT;
831:
832: FUNCTION GENERATE_PASSWORD (p_party_id NUMBER) RETURN VARCHAR2

Line 912: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

908: OPEN c_get_per_details(l_user_id);
909: FETCH c_get_per_details INTO c_get_per_details_rec;
910: CLOSE c_get_per_details;
911:
912: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
913: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Name :'||c_get_per_details_rec.party_name);
914: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Number :'||c_get_per_details_rec.party_number);
915: END IF;
916:

Line 913: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Name :'||c_get_per_details_rec.party_name);

909: FETCH c_get_per_details INTO c_get_per_details_rec;
910: CLOSE c_get_per_details;
911:
912: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
913: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Name :'||c_get_per_details_rec.party_name);
914: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Number :'||c_get_per_details_rec.party_number);
915: END IF;
916:
917: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NAME', c_get_per_details_rec.party_name);

Line 914: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Number :'||c_get_per_details_rec.party_number);

910: CLOSE c_get_per_details;
911:
912: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
913: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Name :'||c_get_per_details_rec.party_name);
914: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','person details Number :'||c_get_per_details_rec.party_number);
915: END IF;
916:
917: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NAME', c_get_per_details_rec.party_name);
918: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER', c_get_per_details_rec.party_number);

Line 924: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

920: OPEN c_get_fnd_user(l_user_id);
921: FETCH c_get_fnd_user INTO l_user_name;
922: CLOSE c_get_fnd_user;
923:
924: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
925: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','User Name :'||l_user_name);
926: END IF;
927:
928: wf_engine.SetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS', l_user_name);

Line 925: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','User Name :'||l_user_name);

921: FETCH c_get_fnd_user INTO l_user_name;
922: CLOSE c_get_fnd_user;
923:
924: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
925: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.set_data','User Name :'||l_user_name);
926: END IF;
927:
928: wf_engine.SetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS', l_user_name);
929: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME',l_user_name);

Line 946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

942: BEGIN
943: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
944: EXCEPTION
945: WHEN others THEN
946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
947: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.cleanup','While deleting record from Interface table :'||sqlerrm);
948: END IF;
949: END;
950: END IF;

Line 947: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.cleanup','While deleting record from Interface table :'||sqlerrm);

943: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
944: EXCEPTION
945: WHEN others THEN
946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
947: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.cleanup','While deleting record from Interface table :'||sqlerrm);
948: END IF;
949: END;
950: END IF;
951: EXCEPTION

Line 953: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

949: END;
950: END IF;
951: EXCEPTION
952: WHEN OTHERS THEN
953: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
954: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.cleanup','Unhandled exception while deleting record from Interface table :'||sqlerrm);
955: END IF;
956: END CLEANUP;
957: END igp_ad_userid_pkg;

Line 954: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.cleanup','Unhandled exception while deleting record from Interface table :'||sqlerrm);

950: END IF;
951: EXCEPTION
952: WHEN OTHERS THEN
953: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
954: fnd_log.string(fnd_log.level_exception,'igs.plsql.igp_ad_userid_pkg.cleanup','Unhandled exception while deleting record from Interface table :'||sqlerrm);
955: END IF;
956: END CLEANUP;
957: END igp_ad_userid_pkg;