APPS.IGP_AD_USERID_PKG dependencies on IGP_AC_ACCOUNT_INTS

Line 150: INSERT INTO igp_ac_account_ints (item_key,

146:
147:
148: IF (l_user_id IS NULL) THEN -- For a new FND user.
149: BEGIN
150: INSERT INTO igp_ac_account_ints (item_key,
151: int_account_id,
152: party_id,
153: acc_classification_code,
154: access_expiration_date,

Line 164: igp_ac_account_ints_s.NEXTVAL,

160: last_update_date,
161: last_update_login)
162: VALUES(
163: l_item_key,
164: igp_ac_account_ints_s.NEXTVAL,
165: l_party_id,
166: l_classification_cd,
167: l_expiration_dt,
168: null,

Line 193: INSERT INTO igp_ac_account_ints (item_key,

189:
190: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_requestor); -- This attr holds the USER name to which the ntification needs to be sent.
191: ELSIF (l_user_id IS NOT NULL) THEN -- For an existing FND user.
192: BEGIN
193: INSERT INTO igp_ac_account_ints (item_key,
194: int_account_id,
195: party_id,
196: acc_classification_code,
197: access_expiration_date,

Line 207: igp_ac_account_ints_s.NEXTVAL,

203: last_update_date,
204: last_update_login)
205: VALUES(
206: l_item_key,
207: igp_ac_account_ints_s.NEXTVAL,
208: l_party_id,
209: l_classification_cd,
210: l_expiration_dt,
211: l_user_id,

Line 361: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;

357: END IF;
358: IF (l_exists = 'Y') THEN
359: resultout := 'COMPLETE:Y';
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);

Line 502: -- clean up the record from igp_ac_account_ints

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
503: if l_num <> 0 then
504: BEGIN
505: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
506: EXCEPTION

Line 505: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;

501:
502: -- clean up the record from igp_ac_account_ints
503: if l_num <> 0 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);

Line 594: delete from igp_ac_account_ints where item_key= itemkey;

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

Line 814: DELETE FROM igp_ac_account_ints

810: x_access_expiration_date => l_expiration_dt, -- Access expiration date.
811: x_object_version_number => 1
812: );
813: -- Delete from interface table.
814: DELETE FROM igp_ac_account_ints
815: WHERE party_id=l_party_id
816: AND acc_classification_code=l_classification_cd;
817: EXCEPTION
818: WHEN OTHERS THEN

Line 943: DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;

939: AS
940: BEGIN
941: IF (funcmode = 'RUN') 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);