APPS.IGP_AD_USERID_PKG dependencies on WF_ENGINE

Line 100: l_party_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID');

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');
101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');

Line 101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');

97: END IF;
98:
99: l_item_key := itemkey;
100: l_party_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID');
101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');

Line 102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');

98:
99: l_item_key := itemkey;
100: l_party_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID');
101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');
106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');

Line 103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');

99: l_item_key := itemkey;
100: l_party_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID');
101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');
106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');
107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');

Line 104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');

100: l_party_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID');
101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');
106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');
107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');
108: l_req_email :=null;

Line 105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');

101: l_classification_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');
106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');
107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');
108: l_req_email :=null;
109:

Line 106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');

102: l_expiration_dt := Wf_Engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT');
103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');
106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');
107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');
108: l_req_email :=null;
109:
110: l_user_name := UPPER(l_user_name);

Line 107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');

103: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
104: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');
105: l_email_address :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS');
106: l_org :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ORGANIZATION');
107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');
108: l_req_email :=null;
109:
110: l_user_name := UPPER(l_user_name);
111: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME', l_user_name);

Line 111: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME', l_user_name);

107: l_req_id :=Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_REQ_ID');
108: l_req_email :=null;
109:
110: l_user_name := UPPER(l_user_name);
111: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME', l_user_name);
112:
113: -- Start : setting req date
114: OPEN c_get_req_dets(l_req_id);
115: FETCH c_get_req_dets INTO c_get_req_dets_rec;

Line 118: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQ_NAME', c_get_req_dets_rec.party_name);

114: OPEN c_get_req_dets(l_req_id);
115: FETCH c_get_req_dets INTO c_get_req_dets_rec;
116: CLOSE c_get_req_dets;
117: l_req_email:=''||c_get_req_dets_rec.email_address||'';
118: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQ_NAME', c_get_req_dets_rec.party_name);
119: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQ_EMAIL', l_req_email);
120: -- End : setting req date
121:
122: OPEN c_get_party_name(l_party_id);

Line 119: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQ_EMAIL', l_req_email);

115: FETCH c_get_req_dets INTO c_get_req_dets_rec;
116: CLOSE c_get_req_dets;
117: l_req_email:=''||c_get_req_dets_rec.email_address||'';
118: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQ_NAME', c_get_req_dets_rec.party_name);
119: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQ_EMAIL', l_req_email);
120: -- End : setting req date
121:
122: OPEN c_get_party_name(l_party_id);
123: FETCH c_get_party_name INTO l_party_det;

Line 130: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER', l_party_det.party_number);

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);
132:
133: IF (l_user_id IS NOT NULL) THEN
134:

Line 131: wf_engine.SetItemAttrText(itemtype,itemkey,'P_PERSON_NAME', l_party_det.party_name);

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);
132:
133: IF (l_user_id IS NOT NULL) THEN
134:
135: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 138: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'ACCOUNT'); -- Already a FND user. Only Portfolio a/c is reqd.

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

Line 144: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACTION', 'BOTH'); -- Both FND and Portfolio a/c have to be created.

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:
147:
148: IF (l_user_id IS NULL) THEN -- For a new FND user.

Line 190: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_requestor); -- This attr holds the USER name to which the ntification needs to be sent.

186: FETCH c_get_req_fnd_user_name INTO l_requestor;
187: CLOSE c_get_req_fnd_user_name;
188: -- End : Setting requestor fnd user name
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,

Line 232: wf_engine.SetItemAttrText(itemtype,itemkey,'P_USER_NAME', l_requestor);

228: OPEN c_get_fnd_user(l_user_id); -- Get FND user name from user_id for notifications.
229: FETCH c_get_fnd_user INTO l_requestor;
230: CLOSE c_get_fnd_user;
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);

Line 233: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_requestor);

229: FETCH c_get_fnd_user INTO l_requestor;
230: CLOSE c_get_fnd_user;
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;

Line 244: fnd_message.set_token('CONTACT_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));

240: -- Set the message of the approval message based on the parameters.
241: IF (l_org IS NOT NULL) THEN -- ext account request
242: IF (l_expiration_dt IS NOT NULL) THEN
243: fnd_message.set_name('IGS','IGP_AD_EXT_NTF_WTH_EX_DT'); -- ext account request with an exp date.
244: fnd_message.set_token('CONTACT_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));
245: fnd_message.set_token('ORG_NAME',l_org);
246: fnd_message.set_token('EXP_DT',l_expiration_dt);
247: l_message_text := fnd_message.get;
248: ELSE

Line 250: fnd_message.set_token('CONTACT_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));

246: fnd_message.set_token('EXP_DT',l_expiration_dt);
247: l_message_text := fnd_message.get;
248: ELSE
249: fnd_message.set_name('IGS','IGP_AD_EXT_NTF_WT_EX_DT'); -- ext account request without an exp date.
250: fnd_message.set_token('CONTACT_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));
251: fnd_message.set_token('ORG_NAME',l_org);
252: l_message_text := fnd_message.get;
253: END IF;
254: ELSIF (l_org IS NULL) THEN -- int account.

Line 257: fnd_message.set_token('PERSON_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));

253: END IF;
254: ELSIF (l_org IS NULL) THEN -- int account.
255: IF (l_expiration_dt IS NOT NULL) THEN
256: fnd_message.set_name('IGS','IGP_AD_INT_NTF_WTH_EX_DT'); -- int account request with an exp date.
257: fnd_message.set_token('PERSON_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));
258: fnd_message.set_token('EXP_DT',l_expiration_dt);
259: fnd_message.set_token('ACC_TYPE',l_classification_cd);
260: l_message_text := fnd_message.get;
261: ELSE

Line 263: fnd_message.set_token('PERSON_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));

259: fnd_message.set_token('ACC_TYPE',l_classification_cd);
260: l_message_text := fnd_message.get;
261: ELSE
262: fnd_message.set_name('IGS','IGP_AD_INT_NTF_WT_EX_DT'); -- int account request without an exp date.
263: fnd_message.set_token('PERSON_NAME',Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME'));
264: fnd_message.set_token('ACC_TYPE',l_classification_cd);
265: l_message_text := fnd_message.get;
266: END IF;
267: END IF;

Line 268: wf_engine.SetItemAttrText(itemtype,itemkey,'P_MESSAGE_TEXT', l_message_text); -- Set the parameter of the workflow to contain the approval message text.

264: fnd_message.set_token('ACC_TYPE',l_classification_cd);
265: l_message_text := fnd_message.get;
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;

Line 286: wf_engine.SetItemAttrText(itemtype,itemkey,'P_APPROVER', l_approver); -- Set the value for the approver, picked from profile.

282: OPEN c_get_approver_email(l_approver);
283: FETCH c_get_approver_email INTO l_approver_email;
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;

Line 287: wf_engine.SetItemAttrText(itemtype,itemkey,'P_APPROVER_EMAIL', l_approver_mail_url);

283: FETCH c_get_approver_email INTO l_approver_email;
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

Line 293: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE',fnd_message.get);

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);
294: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE',null);
295: ELSE
296: fnd_message.set_name('IGS','IGP_AD_INTERNAL_NOTE');
297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);

Line 294: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE',null);

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);
294: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE',null);
295: ELSE
296: fnd_message.set_name('IGS','IGP_AD_INTERNAL_NOTE');
297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);
298: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE', l_classification_cd);

Line 297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);

293: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE',fnd_message.get);
294: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE',null);
295: ELSE
296: fnd_message.set_name('IGS','IGP_AD_INTERNAL_NOTE');
297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);
298: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE', l_classification_cd);
299: END IF;
300: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;
301: select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;

Line 298: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE', l_classification_cd);

294: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE',null);
295: ELSE
296: fnd_message.set_name('IGS','IGP_AD_INTERNAL_NOTE');
297: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE', fnd_message.get);
298: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_SUB_TYPE', l_classification_cd);
299: END IF;
300: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;
301: select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;
302: l_url:=l_url_part1||l_url_part2||'/AppsLocalLogin.jsp';

Line 304: wf_engine.SetItemAttrText(itemtype,itemkey,'P_URL', l_url);

300: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;
301: select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;
302: l_url:=l_url_part1||l_url_part2||'/AppsLocalLogin.jsp';
303: l_url:=''||l_url||'';
304: wf_engine.SetItemAttrText(itemtype,itemkey,'P_URL', l_url);
305: resultout := 'COMPLETE:IGP_SUCCESS';
306: END IF;
307: END IF; -- for if funcmode='RUN'
308: EXCEPTION

Line 348: l_acc_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');

344:
345: BEGIN
346: IF (funcmode = 'RUN') THEN
347: l_exists :='N';
348: l_acc_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
349: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
350: IF (l_user_id IS NOT NULL) THEN
351: l_exists := 'N';
352: OPEN c_exists_acc(l_acc_type,l_user_id);

Line 349: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');

345: BEGIN
346: IF (funcmode = 'RUN') THEN
347: l_exists :='N';
348: l_acc_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD');
349: l_user_id := Wf_Engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID');
350: IF (l_user_id IS NOT NULL) THEN
351: l_exists := 'N';
352: OPEN c_exists_acc(l_acc_type,l_user_id);
353: FETCH c_exists_acc INTO l_exists;

Line 401: l_action := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ACTION');

397: l_action VARCHAR2(30);
398:
399: BEGIN
400: IF (funcmode = 'RUN') THEN
401: l_action := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ACTION');
402: IF (l_action = 'ACCOUNT' ) THEN
403: resultout := 'COMPLETE:ACCOUNT';
404: ELSIF (l_action='BOTH')THEN
405: resultout := 'COMPLETE:BOTH';

Line 443: l_user_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME');

439: IF (funcmode = 'RUN') THEN
440: l_exists :='N';
441: l_user_name :=NULL;
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.');

Line 514: wf_engine.SetItemAttrText(itemtype,itemkey,'P_MESSAGE_TEXT', l_message_text); -- Set the parameter of the workflow to contain the reason of not completing the create portfolio request.

510: END IF;
511: END;
512: end if;
513:
514: wf_engine.SetItemAttrText(itemtype,itemkey,'P_MESSAGE_TEXT', l_message_text); -- Set the parameter of the workflow to contain the reason of not completing the create portfolio request.
515:
516:
517: END IF;
518: EXCEPTION

Line 557: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' );

553: BEGIN
554: IF (funcmode = 'RUN') THEN
555: l_resp_exists :='N';
556: -- Extract the attributes from the workflow. These are required to create the FND user.
557: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' );
558: l_user_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME' );
559: l_email_address := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS' );
560: l_user_password := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PASSWORD' );
561: --Validate the password also.

Line 558: l_user_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME' );

554: IF (funcmode = 'RUN') THEN
555: l_resp_exists :='N';
556: -- Extract the attributes from the workflow. These are required to create the FND user.
557: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' );
558: l_user_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME' );
559: l_email_address := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS' );
560: l_user_password := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PASSWORD' );
561: --Validate the password also.
562: IF (l_user_password IS NULL) OR (length(l_user_password)<5) THEN

Line 559: l_email_address := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS' );

555: l_resp_exists :='N';
556: -- Extract the attributes from the workflow. These are required to create the FND user.
557: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' );
558: l_user_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME' );
559: l_email_address := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS' );
560: l_user_password := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PASSWORD' );
561: --Validate the password also.
562: IF (l_user_password IS NULL) OR (length(l_user_password)<5) THEN
563: l_user_password:=GENERATE_PASSWORD(l_party_id);

Line 560: l_user_password := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PASSWORD' );

556: -- Extract the attributes from the workflow. These are required to create the FND user.
557: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' );
558: l_user_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_USER_NAME' );
559: l_email_address := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EMAIL_ADDRESS' );
560: l_user_password := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PASSWORD' );
561: --Validate the password also.
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);

Line 564: Wf_Engine.SetItemAttrText(itemtype,itemkey,'P_PASSWORD',l_user_password);

560: l_user_password := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PASSWORD' );
561: --Validate the password also.
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;

Line 585: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_USER_ID', l_user_id); -- set the FND user ID. To be used later.

581: select USER_ID into l_user_id
582: from FND_USER
583: where USER_NAME = l_user_name;
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);

Line 586: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR', l_user_name);

582: from FND_USER
583: where USER_NAME = l_user_name;
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);

Line 680: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' ); -- HZ party ID.

676:
677: BEGIN
678: IF (funcmode = 'RUN') THEN
679: l_exists :='N';
680: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' ); -- HZ party ID.
681: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' ); -- FND user ID.
682: l_classification_cd := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD' ); -- Portfolio acc classification code...STAFF,FACULTY,STUDENT.
683: l_expiration_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT' ); -- Access expiration date.
684:

Line 681: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' ); -- FND user ID.

677: BEGIN
678: IF (funcmode = 'RUN') THEN
679: l_exists :='N';
680: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' ); -- HZ party ID.
681: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' ); -- FND user ID.
682: l_classification_cd := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD' ); -- Portfolio acc classification code...STAFF,FACULTY,STUDENT.
683: l_expiration_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT' ); -- Access expiration date.
684:
685: -- check if already a Portfolio user.

Line 682: l_classification_cd := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD' ); -- Portfolio acc classification code...STAFF,FACULTY,STUDENT.

678: IF (funcmode = 'RUN') THEN
679: l_exists :='N';
680: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' ); -- HZ party ID.
681: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' ); -- FND user ID.
682: l_classification_cd := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD' ); -- Portfolio acc classification code...STAFF,FACULTY,STUDENT.
683: l_expiration_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT' ); -- Access expiration date.
684:
685: -- check if already a Portfolio user.
686: l_exists:='N';

Line 683: l_expiration_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT' ); -- Access expiration date.

679: l_exists :='N';
680: l_party_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PARTY_ID' ); -- HZ party ID.
681: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' ); -- FND user ID.
682: l_classification_cd := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASSIFICATION_CD' ); -- Portfolio acc classification code...STAFF,FACULTY,STUDENT.
683: l_expiration_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRATION_DT' ); -- Access expiration date.
684:
685: -- check if already a Portfolio user.
686: l_exists:='N';
687: l_account_id:=null;

Line 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.

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.
698: ELSIF (l_account_id IS NULL) THEN --Call the TBH of the IGP_AC_ACCOUNTS table to insert into the table.
699: BEGIN
700: igp_ac_accounts_pkg.insert_row (
701: x_mode => 'R',

Line 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.

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

Line 797: l_account_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID');

793: );
794: END IF;
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;

Line 884: l_account_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID' );

880:
881:
882: BEGIN
883: IF (funcmode = 'RUN') THEN
884: l_account_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID' );
885: l_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' );
886: l_classcode := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASS_CODE' );
887: l_expiry_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRY_DATE' );
888: l_requestor_id := wf_engine.GetItemAttrText(itemtype,itemkey,'P_REQUESTOR' );

Line 885: l_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' );

881:
882: BEGIN
883: IF (funcmode = 'RUN') THEN
884: l_account_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID' );
885: l_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' );
886: l_classcode := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASS_CODE' );
887: l_expiry_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRY_DATE' );
888: l_requestor_id := wf_engine.GetItemAttrText(itemtype,itemkey,'P_REQUESTOR' );
889:

Line 886: l_classcode := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASS_CODE' );

882: BEGIN
883: IF (funcmode = 'RUN') THEN
884: l_account_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID' );
885: l_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' );
886: l_classcode := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASS_CODE' );
887: l_expiry_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRY_DATE' );
888: l_requestor_id := wf_engine.GetItemAttrText(itemtype,itemkey,'P_REQUESTOR' );
889:
890: OPEN c_get_requestor_det(l_requestor_id);

Line 887: l_expiry_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRY_DATE' );

883: IF (funcmode = 'RUN') THEN
884: l_account_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID' );
885: l_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' );
886: l_classcode := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASS_CODE' );
887: l_expiry_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRY_DATE' );
888: l_requestor_id := wf_engine.GetItemAttrText(itemtype,itemkey,'P_REQUESTOR' );
889:
890: OPEN c_get_requestor_det(l_requestor_id);
891: FETCH c_get_requestor_det INTO c_get_requestor_det_rec;

Line 888: l_requestor_id := wf_engine.GetItemAttrText(itemtype,itemkey,'P_REQUESTOR' );

884: l_account_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID' );
885: l_user_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_USER_ID' );
886: l_classcode := wf_engine.GetItemAttrText(itemtype,itemkey,'P_CLASS_CODE' );
887: l_expiry_dt := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_EXPIRY_DATE' );
888: l_requestor_id := wf_engine.GetItemAttrText(itemtype,itemkey,'P_REQUESTOR' );
889:
890: OPEN c_get_requestor_det(l_requestor_id);
891: FETCH c_get_requestor_det INTO c_get_requestor_det_rec;
892: CLOSE c_get_requestor_det;

Line 896: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR_NAME',c_get_requestor_det_rec.req_name);

892: CLOSE c_get_requestor_det;
893:
894: l_href_mailto :=''||c_get_requestor_det_rec.req_email;
895:
896: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR_NAME',c_get_requestor_det_rec.req_name);
897: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR_EMAIL',l_href_mailto);
898:
899: IF (l_classcode = 'EXTERNAL') THEN
900: fnd_message.set_name('IGS','IGP_AD_EXTERNAL_NOTE');

893:
894: l_href_mailto :=''||c_get_requestor_det_rec.req_email;
895:
896: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR_NAME',c_get_requestor_det_rec.req_name);
897: wf_engine.SetItemAttrText(itemtype,itemkey,'P_REQUESTOR_EMAIL',l_href_mailto);
898:
899: IF (l_classcode = 'EXTERNAL') THEN
900: fnd_message.set_name('IGS','IGP_AD_EXTERNAL_NOTE');
901: wf_engine.SetItemAttrText(itemtype,itemkey,'P_ACC_TYPE',fnd_message.get);