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 IGP_AD_USERID_PKG

Line 1: PACKAGE BODY IGP_AD_USERID_PKG AS

1: PACKAGE BODY IGP_AD_USERID_PKG AS
2: /* $Header: IGSPADAB.pls 120.7 2006/05/04 22:49:44 bmerugu noship $ */
3: /*
4: || Created By : nsidana
5: || Created On : 1/28/2004

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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;

Line 957: END igp_ad_userid_pkg;

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;