APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on FND_MESSAGE

Line 155: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

151: IF (get_mel_cdl_details%NOTFOUND OR l_mel_cdl_rec.object_version_number <> l_object_ovn)
152: THEN
153: CLOSE get_mel_cdl_details;
154:
155: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
156: fnd_message.set_token('HRD_ID', l_object_id, false);
157: fnd_msg_pub.add;
158:
159: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 156: fnd_message.set_token('HRD_ID', l_object_id, false);

152: THEN
153: CLOSE get_mel_cdl_details;
154:
155: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
156: fnd_message.set_token('HRD_ID', l_object_id, false);
157: fnd_msg_pub.add;
158:
159: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
160: THEN

Line 176: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FORWARD_SUBJ');

172: END IF;
173: CLOSE get_mel_cdl_details;
174:
175: /* FORWARD_SUBJECT */
176: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FORWARD_SUBJ');
177: fnd_message.set_token('HRD_ID',l_object_id, false);
178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 177: fnd_message.set_token('HRD_ID',l_object_id, false);

173: CLOSE get_mel_cdl_details;
174:
175: /* FORWARD_SUBJECT */
176: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FORWARD_SUBJ');
177: fnd_message.set_token('HRD_ID',l_object_id, false);
178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
181: l_subject := fnd_message.get;

Line 178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

174:
175: /* FORWARD_SUBJECT */
176: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FORWARD_SUBJ');
177: fnd_message.set_token('HRD_ID',l_object_id, false);
178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
181: l_subject := fnd_message.get;
182:

Line 179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

175: /* FORWARD_SUBJECT */
176: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FORWARD_SUBJ');
177: fnd_message.set_token('HRD_ID',l_object_id, false);
178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
181: l_subject := fnd_message.get;
182:
183: wf_engine.setitemattrtext

Line 180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

176: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FORWARD_SUBJ');
177: fnd_message.set_token('HRD_ID',l_object_id, false);
178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
181: l_subject := fnd_message.get;
182:
183: wf_engine.setitemattrtext
184: (

Line 181: l_subject := fnd_message.get;

177: fnd_message.set_token('HRD_ID',l_object_id, false);
178: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
181: l_subject := fnd_message.get;
182:
183: wf_engine.setitemattrtext
184: (
185: itemtype => itemtype,

Line 202: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL_SUBJ');

198: );
199: END IF;
200:
201: /* APPROVAL_SUBJECT */
202: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL_SUBJ');
203: fnd_message.set_token('HRD_ID',l_object_id, false);
204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 203: fnd_message.set_token('HRD_ID',l_object_id, false);

199: END IF;
200:
201: /* APPROVAL_SUBJECT */
202: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL_SUBJ');
203: fnd_message.set_token('HRD_ID',l_object_id, false);
204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
207: l_subject := fnd_message.get;

Line 204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

200:
201: /* APPROVAL_SUBJECT */
202: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL_SUBJ');
203: fnd_message.set_token('HRD_ID',l_object_id, false);
204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
207: l_subject := fnd_message.get;
208:

Line 205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

201: /* APPROVAL_SUBJECT */
202: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL_SUBJ');
203: fnd_message.set_token('HRD_ID',l_object_id, false);
204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
207: l_subject := fnd_message.get;
208:
209: wf_engine.setitemattrtext

Line 206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

202: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL_SUBJ');
203: fnd_message.set_token('HRD_ID',l_object_id, false);
204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
207: l_subject := fnd_message.get;
208:
209: wf_engine.setitemattrtext
210: (

Line 207: l_subject := fnd_message.get;

203: fnd_message.set_token('HRD_ID',l_object_id, false);
204: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
207: l_subject := fnd_message.get;
208:
209: wf_engine.setitemattrtext
210: (
211: itemtype => itemtype,

Line 228: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REJECT_SUBJ');

224: );
225: END IF;
226:
227: /* REJECT_SUBJECT */
228: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REJECT_SUBJ');
229: fnd_message.set_token('HRD_ID',l_object_id, false);
230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 229: fnd_message.set_token('HRD_ID',l_object_id, false);

225: END IF;
226:
227: /* REJECT_SUBJECT */
228: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REJECT_SUBJ');
229: fnd_message.set_token('HRD_ID',l_object_id, false);
230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
233: l_subject := fnd_message.get;

Line 230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

226:
227: /* REJECT_SUBJECT */
228: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REJECT_SUBJ');
229: fnd_message.set_token('HRD_ID',l_object_id, false);
230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
233: l_subject := fnd_message.get;
234:

Line 231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

227: /* REJECT_SUBJECT */
228: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REJECT_SUBJ');
229: fnd_message.set_token('HRD_ID',l_object_id, false);
230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
233: l_subject := fnd_message.get;
234:
235: wf_engine.setitemattrtext

Line 232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

228: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REJECT_SUBJ');
229: fnd_message.set_token('HRD_ID',l_object_id, false);
230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
233: l_subject := fnd_message.get;
234:
235: wf_engine.setitemattrtext
236: (

Line 233: l_subject := fnd_message.get;

229: fnd_message.set_token('HRD_ID',l_object_id, false);
230: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
233: l_subject := fnd_message.get;
234:
235: wf_engine.setitemattrtext
236: (
237: itemtype => itemtype,

Line 254: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVED_SUBJ');

250: );
251: END IF;
252:
253: /* APPROVED_SUBJECT */
254: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVED_SUBJ');
255: fnd_message.set_token('HRD_ID',l_object_id, false);
256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 255: fnd_message.set_token('HRD_ID',l_object_id, false);

251: END IF;
252:
253: /* APPROVED_SUBJECT */
254: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVED_SUBJ');
255: fnd_message.set_token('HRD_ID',l_object_id, false);
256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
259: l_subject := fnd_message.get;

Line 256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

252:
253: /* APPROVED_SUBJECT */
254: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVED_SUBJ');
255: fnd_message.set_token('HRD_ID',l_object_id, false);
256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
259: l_subject := fnd_message.get;
260:

Line 257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

253: /* APPROVED_SUBJECT */
254: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVED_SUBJ');
255: fnd_message.set_token('HRD_ID',l_object_id, false);
256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
259: l_subject := fnd_message.get;
260:
261: wf_engine.setitemattrtext

Line 258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

254: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVED_SUBJ');
255: fnd_message.set_token('HRD_ID',l_object_id, false);
256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
259: l_subject := fnd_message.get;
260:
261: wf_engine.setitemattrtext
262: (

Line 259: l_subject := fnd_message.get;

255: fnd_message.set_token('HRD_ID',l_object_id, false);
256: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
259: l_subject := fnd_message.get;
260:
261: wf_engine.setitemattrtext
262: (
263: itemtype => itemtype,

Line 280: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FINAL_SUBJ');

276: );
277: END IF;
278:
279: /* FINAL_SUBJECT */
280: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FINAL_SUBJ');
281: fnd_message.set_token('HRD_ID',l_object_id, false);
282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 281: fnd_message.set_token('HRD_ID',l_object_id, false);

277: END IF;
278:
279: /* FINAL_SUBJECT */
280: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FINAL_SUBJ');
281: fnd_message.set_token('HRD_ID',l_object_id, false);
282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
285: l_subject := fnd_message.get;

Line 282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

278:
279: /* FINAL_SUBJECT */
280: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FINAL_SUBJ');
281: fnd_message.set_token('HRD_ID',l_object_id, false);
282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
285: l_subject := fnd_message.get;
286:

Line 283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

279: /* FINAL_SUBJECT */
280: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FINAL_SUBJ');
281: fnd_message.set_token('HRD_ID',l_object_id, false);
282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
285: l_subject := fnd_message.get;
286:
287: wf_engine.setitemattrtext

Line 284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

280: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FINAL_SUBJ');
281: fnd_message.set_token('HRD_ID',l_object_id, false);
282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
285: l_subject := fnd_message.get;
286:
287: wf_engine.setitemattrtext
288: (

Line 285: l_subject := fnd_message.get;

281: fnd_message.set_token('HRD_ID',l_object_id, false);
282: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
285: l_subject := fnd_message.get;
286:
287: wf_engine.setitemattrtext
288: (
289: itemtype => itemtype,

Line 306: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND_SUBJ');

302: );
303: END IF;
304:
305: /* REMIND_SUBJECT */
306: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND_SUBJ');
307: fnd_message.set_token('HRD_ID',l_object_id, false);
308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 307: fnd_message.set_token('HRD_ID',l_object_id, false);

303: END IF;
304:
305: /* REMIND_SUBJECT */
306: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND_SUBJ');
307: fnd_message.set_token('HRD_ID',l_object_id, false);
308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
311: l_subject := fnd_message.get;

Line 308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

304:
305: /* REMIND_SUBJECT */
306: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND_SUBJ');
307: fnd_message.set_token('HRD_ID',l_object_id, false);
308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
311: l_subject := fnd_message.get;
312:

Line 309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

305: /* REMIND_SUBJECT */
306: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND_SUBJ');
307: fnd_message.set_token('HRD_ID',l_object_id, false);
308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
311: l_subject := fnd_message.get;
312:
313: wf_engine.setitemattrtext

Line 310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

306: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND_SUBJ');
307: fnd_message.set_token('HRD_ID',l_object_id, false);
308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
311: l_subject := fnd_message.get;
312:
313: wf_engine.setitemattrtext
314: (

Line 311: l_subject := fnd_message.get;

307: fnd_message.set_token('HRD_ID',l_object_id, false);
308: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
311: l_subject := fnd_message.get;
312:
313: wf_engine.setitemattrtext
314: (
315: itemtype => itemtype,

Line 332: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_SUBJ');

328: );
329: END IF;
330:
331: /* ERROR_SUBJECT */
332: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_SUBJ');
333: fnd_message.set_token('HRD_ID',l_object_id, false);
334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 333: fnd_message.set_token('HRD_ID',l_object_id, false);

329: END IF;
330:
331: /* ERROR_SUBJECT */
332: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_SUBJ');
333: fnd_message.set_token('HRD_ID',l_object_id, false);
334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
337: l_subject := fnd_message.get;

Line 334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

330:
331: /* ERROR_SUBJECT */
332: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_SUBJ');
333: fnd_message.set_token('HRD_ID',l_object_id, false);
334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
337: l_subject := fnd_message.get;
338:

Line 335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

331: /* ERROR_SUBJECT */
332: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_SUBJ');
333: fnd_message.set_token('HRD_ID',l_object_id, false);
334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
337: l_subject := fnd_message.get;
338:
339: wf_engine.setitemattrtext

Line 336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

332: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_SUBJ');
333: fnd_message.set_token('HRD_ID',l_object_id, false);
334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
337: l_subject := fnd_message.get;
338:
339: wf_engine.setitemattrtext
340: (

Line 337: l_subject := fnd_message.get;

333: fnd_message.set_token('HRD_ID',l_object_id, false);
334: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
337: l_subject := fnd_message.get;
338:
339: wf_engine.setitemattrtext
340: (
341: itemtype => itemtype,

Line 568: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

564: IF (get_mel_cdl_details%NOTFOUND)
565: THEN
566: CLOSE get_mel_cdl_details;
567:
568: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
569: fnd_message.set_token('HRD_ID', l_object_id, false);
570: fnd_msg_pub.add;
571:
572: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 569: fnd_message.set_token('HRD_ID', l_object_id, false);

565: THEN
566: CLOSE get_mel_cdl_details;
567:
568: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
569: fnd_message.set_token('HRD_ID', l_object_id, false);
570: fnd_msg_pub.add;
571:
572: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
573: THEN

Line 587: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FWD');

583:
584: ELSE
585: CLOSE get_mel_cdl_details;
586:
587: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FWD');
588: fnd_message.set_token('HRD_ID',l_object_id, false);
589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 588: fnd_message.set_token('HRD_ID',l_object_id, false);

584: ELSE
585: CLOSE get_mel_cdl_details;
586:
587: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FWD');
588: fnd_message.set_token('HRD_ID',l_object_id, false);
589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
592: fnd_message.set_token('APPR_NAME',l_approver, false);

Line 589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

585: CLOSE get_mel_cdl_details;
586:
587: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FWD');
588: fnd_message.set_token('HRD_ID',l_object_id, false);
589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
592: fnd_message.set_token('APPR_NAME',l_approver, false);
593: l_body := fnd_message.get;

Line 590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

586:
587: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FWD');
588: fnd_message.set_token('HRD_ID',l_object_id, false);
589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
592: fnd_message.set_token('APPR_NAME',l_approver, false);
593: l_body := fnd_message.get;
594:

Line 591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

587: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FWD');
588: fnd_message.set_token('HRD_ID',l_object_id, false);
589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
592: fnd_message.set_token('APPR_NAME',l_approver, false);
593: l_body := fnd_message.get;
594:
595: END IF;

Line 592: fnd_message.set_token('APPR_NAME',l_approver, false);

588: fnd_message.set_token('HRD_ID',l_object_id, false);
589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
592: fnd_message.set_token('APPR_NAME',l_approver, false);
593: l_body := fnd_message.get;
594:
595: END IF;
596:

Line 593: l_body := fnd_message.get;

589: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
590: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
591: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
592: fnd_message.set_token('APPR_NAME',l_approver, false);
593: l_body := fnd_message.get;
594:
595: END IF;
596:
597: document := document || l_body;

Line 741: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

737: IF (get_mel_cdl_details%NOTFOUND)
738: THEN
739: CLOSE get_mel_cdl_details;
740:
741: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
742: fnd_message.set_token('HRD_ID', l_object_id, false);
743: fnd_msg_pub.add;
744:
745: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 742: fnd_message.set_token('HRD_ID', l_object_id, false);

738: THEN
739: CLOSE get_mel_cdl_details;
740:
741: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
742: fnd_message.set_token('HRD_ID', l_object_id, false);
743: fnd_msg_pub.add;
744:
745: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
746: THEN

Line 760: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_APPRVD');

756:
757: ELSE
758: CLOSE get_mel_cdl_details;
759:
760: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_APPRVD');
761: fnd_message.set_token('HRD_ID',l_object_id, false);
762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 761: fnd_message.set_token('HRD_ID',l_object_id, false);

757: ELSE
758: CLOSE get_mel_cdl_details;
759:
760: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_APPRVD');
761: fnd_message.set_token('HRD_ID',l_object_id, false);
762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
765: fnd_message.set_token('APPR_NAME',l_approver, false);

Line 762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

758: CLOSE get_mel_cdl_details;
759:
760: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_APPRVD');
761: fnd_message.set_token('HRD_ID',l_object_id, false);
762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
765: fnd_message.set_token('APPR_NAME',l_approver, false);
766: l_body := fnd_message.get;

Line 763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

759:
760: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_APPRVD');
761: fnd_message.set_token('HRD_ID',l_object_id, false);
762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
765: fnd_message.set_token('APPR_NAME',l_approver, false);
766: l_body := fnd_message.get;
767:

Line 764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

760: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_APPRVD');
761: fnd_message.set_token('HRD_ID',l_object_id, false);
762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
765: fnd_message.set_token('APPR_NAME',l_approver, false);
766: l_body := fnd_message.get;
767:
768: END IF;

Line 765: fnd_message.set_token('APPR_NAME',l_approver, false);

761: fnd_message.set_token('HRD_ID',l_object_id, false);
762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
765: fnd_message.set_token('APPR_NAME',l_approver, false);
766: l_body := fnd_message.get;
767:
768: END IF;
769:

Line 766: l_body := fnd_message.get;

762: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
763: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
764: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
765: fnd_message.set_token('APPR_NAME',l_approver, false);
766: l_body := fnd_message.get;
767:
768: END IF;
769:
770: document := document || l_body;

Line 906: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

902: IF (get_mel_cdl_details%NOTFOUND)
903: THEN
904: CLOSE get_mel_cdl_details;
905:
906: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
907: fnd_message.set_token('HRD_ID', l_object_id, false);
908: fnd_msg_pub.add;
909:
910: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 907: fnd_message.set_token('HRD_ID', l_object_id, false);

903: THEN
904: CLOSE get_mel_cdl_details;
905:
906: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
907: fnd_message.set_token('HRD_ID', l_object_id, false);
908: fnd_msg_pub.add;
909:
910: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
911: THEN

Line 925: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FINAL');

921:
922: ELSE
923: CLOSE get_mel_cdl_details;
924:
925: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FINAL');
926: fnd_message.set_token('HRD_ID',l_object_id, false);
927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 926: fnd_message.set_token('HRD_ID',l_object_id, false);

922: ELSE
923: CLOSE get_mel_cdl_details;
924:
925: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FINAL');
926: fnd_message.set_token('HRD_ID',l_object_id, false);
927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
930: l_body := fnd_message.get;

Line 927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

923: CLOSE get_mel_cdl_details;
924:
925: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FINAL');
926: fnd_message.set_token('HRD_ID',l_object_id, false);
927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
930: l_body := fnd_message.get;
931:

Line 928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

924:
925: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FINAL');
926: fnd_message.set_token('HRD_ID',l_object_id, false);
927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
930: l_body := fnd_message.get;
931:
932: END IF;

Line 929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

925: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_FINAL');
926: fnd_message.set_token('HRD_ID',l_object_id, false);
927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
930: l_body := fnd_message.get;
931:
932: END IF;
933:

Line 930: l_body := fnd_message.get;

926: fnd_message.set_token('HRD_ID',l_object_id, false);
927: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
928: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
929: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
930: l_body := fnd_message.get;
931:
932: END IF;
933:
934: document := document || l_body;

Line 1078: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

1074: IF (get_mel_cdl_details%NOTFOUND)
1075: THEN
1076: CLOSE get_mel_cdl_details;
1077:
1078: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1079: fnd_message.set_token('HRD_ID', l_object_id, false);
1080: fnd_msg_pub.add;
1081:
1082: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1079: fnd_message.set_token('HRD_ID', l_object_id, false);

1075: THEN
1076: CLOSE get_mel_cdl_details;
1077:
1078: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1079: fnd_message.set_token('HRD_ID', l_object_id, false);
1080: fnd_msg_pub.add;
1081:
1082: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1083: THEN

Line 1097: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_RJCT');

1093:
1094: ELSE
1095: CLOSE get_mel_cdl_details;
1096:
1097: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_RJCT');
1098: fnd_message.set_token('HRD_ID',l_object_id, false);
1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 1098: fnd_message.set_token('HRD_ID',l_object_id, false);

1094: ELSE
1095: CLOSE get_mel_cdl_details;
1096:
1097: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_RJCT');
1098: fnd_message.set_token('HRD_ID',l_object_id, false);
1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1102: fnd_message.set_token('APPR_NAME',l_approver, false);

Line 1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

1095: CLOSE get_mel_cdl_details;
1096:
1097: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_RJCT');
1098: fnd_message.set_token('HRD_ID',l_object_id, false);
1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1102: fnd_message.set_token('APPR_NAME',l_approver, false);
1103: l_body := fnd_message.get;

Line 1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

1096:
1097: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_RJCT');
1098: fnd_message.set_token('HRD_ID',l_object_id, false);
1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1102: fnd_message.set_token('APPR_NAME',l_approver, false);
1103: l_body := fnd_message.get;
1104:

Line 1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

1097: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_FYI_RJCT');
1098: fnd_message.set_token('HRD_ID',l_object_id, false);
1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1102: fnd_message.set_token('APPR_NAME',l_approver, false);
1103: l_body := fnd_message.get;
1104:
1105: END IF;

Line 1102: fnd_message.set_token('APPR_NAME',l_approver, false);

1098: fnd_message.set_token('HRD_ID',l_object_id, false);
1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1102: fnd_message.set_token('APPR_NAME',l_approver, false);
1103: l_body := fnd_message.get;
1104:
1105: END IF;
1106:

Line 1103: l_body := fnd_message.get;

1099: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1100: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1101: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1102: fnd_message.set_token('APPR_NAME',l_approver, false);
1103: l_body := fnd_message.get;
1104:
1105: END IF;
1106:
1107: document := document || l_body;

Line 1259: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

1255: IF (get_mel_cdl_details%NOTFOUND)
1256: THEN
1257: CLOSE get_mel_cdl_details;
1258:
1259: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1260: fnd_message.set_token('HRD_ID', l_object_id, false);
1261: fnd_msg_pub.add;
1262:
1263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1260: fnd_message.set_token('HRD_ID', l_object_id, false);

1256: THEN
1257: CLOSE get_mel_cdl_details;
1258:
1259: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1260: fnd_message.set_token('HRD_ID', l_object_id, false);
1261: fnd_msg_pub.add;
1262:
1263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1264: THEN

Line 1278: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL');

1274:
1275: ELSE
1276: CLOSE get_mel_cdl_details;
1277:
1278: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL');
1279: fnd_message.set_token('HRD_ID',l_object_id, false);
1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 1279: fnd_message.set_token('HRD_ID',l_object_id, false);

1275: ELSE
1276: CLOSE get_mel_cdl_details;
1277:
1278: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL');
1279: fnd_message.set_token('HRD_ID',l_object_id, false);
1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);

Line 1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

1276: CLOSE get_mel_cdl_details;
1277:
1278: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL');
1279: fnd_message.set_token('HRD_ID',l_object_id, false);
1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);
1284: fnd_message.set_token('NOTE',l_requester_note, false);

Line 1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

1277:
1278: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL');
1279: fnd_message.set_token('HRD_ID',l_object_id, false);
1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);
1284: fnd_message.set_token('NOTE',l_requester_note, false);
1285: l_body := fnd_message.get;

Line 1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

1278: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_APPROVAL');
1279: fnd_message.set_token('HRD_ID',l_object_id, false);
1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);
1284: fnd_message.set_token('NOTE',l_requester_note, false);
1285: l_body := fnd_message.get;
1286:

Line 1283: fnd_message.set_token('REQUESTER',l_requester, false);

1279: fnd_message.set_token('HRD_ID',l_object_id, false);
1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);
1284: fnd_message.set_token('NOTE',l_requester_note, false);
1285: l_body := fnd_message.get;
1286:
1287: END IF;

Line 1284: fnd_message.set_token('NOTE',l_requester_note, false);

1280: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);
1284: fnd_message.set_token('NOTE',l_requester_note, false);
1285: l_body := fnd_message.get;
1286:
1287: END IF;
1288:

Line 1285: l_body := fnd_message.get;

1281: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1282: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1283: fnd_message.set_token('REQUESTER',l_requester, false);
1284: fnd_message.set_token('NOTE',l_requester_note, false);
1285: l_body := fnd_message.get;
1286:
1287: END IF;
1288:
1289: document := document || l_body;

Line 1441: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

1437: IF (get_mel_cdl_details%NOTFOUND)
1438: THEN
1439: CLOSE get_mel_cdl_details;
1440:
1441: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1442: fnd_message.set_token('HRD_ID', l_object_id, false);
1443: fnd_msg_pub.add;
1444:
1445: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1442: fnd_message.set_token('HRD_ID', l_object_id, false);

1438: THEN
1439: CLOSE get_mel_cdl_details;
1440:
1441: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1442: fnd_message.set_token('HRD_ID', l_object_id, false);
1443: fnd_msg_pub.add;
1444:
1445: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1446: THEN

Line 1460: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND');

1456:
1457: ELSE
1458: CLOSE get_mel_cdl_details;
1459:
1460: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND');
1461: fnd_message.set_token('HRD_ID',l_object_id, false);
1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 1461: fnd_message.set_token('HRD_ID',l_object_id, false);

1457: ELSE
1458: CLOSE get_mel_cdl_details;
1459:
1460: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND');
1461: fnd_message.set_token('HRD_ID',l_object_id, false);
1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);

Line 1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

1458: CLOSE get_mel_cdl_details;
1459:
1460: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND');
1461: fnd_message.set_token('HRD_ID',l_object_id, false);
1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);
1466: fnd_message.set_token('NOTE',l_requester_note, false);

Line 1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

1459:
1460: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND');
1461: fnd_message.set_token('HRD_ID',l_object_id, false);
1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);
1466: fnd_message.set_token('NOTE',l_requester_note, false);
1467: l_body := fnd_message.get;

Line 1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

1460: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_REMIND');
1461: fnd_message.set_token('HRD_ID',l_object_id, false);
1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);
1466: fnd_message.set_token('NOTE',l_requester_note, false);
1467: l_body := fnd_message.get;
1468:

Line 1465: fnd_message.set_token('REQUESTER',l_requester, false);

1461: fnd_message.set_token('HRD_ID',l_object_id, false);
1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);
1466: fnd_message.set_token('NOTE',l_requester_note, false);
1467: l_body := fnd_message.get;
1468:
1469: END IF;

Line 1466: fnd_message.set_token('NOTE',l_requester_note, false);

1462: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);
1466: fnd_message.set_token('NOTE',l_requester_note, false);
1467: l_body := fnd_message.get;
1468:
1469: END IF;
1470:

Line 1467: l_body := fnd_message.get;

1463: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1464: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1465: fnd_message.set_token('REQUESTER',l_requester, false);
1466: fnd_message.set_token('NOTE',l_requester_note, false);
1467: l_body := fnd_message.get;
1468:
1469: END IF;
1470:
1471: document := document || l_body;

Line 1614: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

1610: IF (get_mel_cdl_details%NOTFOUND)
1611: THEN
1612: CLOSE get_mel_cdl_details;
1613:
1614: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1615: fnd_message.set_token('HRD_ID', l_object_id, false);
1616: fnd_msg_pub.add;
1617:
1618: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1615: fnd_message.set_token('HRD_ID', l_object_id, false);

1611: THEN
1612: CLOSE get_mel_cdl_details;
1613:
1614: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1615: fnd_message.set_token('HRD_ID', l_object_id, false);
1616: fnd_msg_pub.add;
1617:
1618: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1619: THEN

Line 1633: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_ACT');

1629:
1630: ELSE
1631: CLOSE get_mel_cdl_details;
1632:
1633: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_ACT');
1634: fnd_message.set_token('HRD_ID',l_object_id, false);
1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

Line 1634: fnd_message.set_token('HRD_ID',l_object_id, false);

1630: ELSE
1631: CLOSE get_mel_cdl_details;
1632:
1633: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_ACT');
1634: fnd_message.set_token('HRD_ID',l_object_id, false);
1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);

Line 1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);

1631: CLOSE get_mel_cdl_details;
1632:
1633: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_ACT');
1634: fnd_message.set_token('HRD_ID',l_object_id, false);
1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1639: l_body := fnd_message.get;

Line 1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);

1632:
1633: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_ACT');
1634: fnd_message.set_token('HRD_ID',l_object_id, false);
1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1639: l_body := fnd_message.get;
1640:

Line 1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);

1633: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ERROR_ACT');
1634: fnd_message.set_token('HRD_ID',l_object_id, false);
1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1639: l_body := fnd_message.get;
1640:
1641: END IF;

Line 1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);

1634: fnd_message.set_token('HRD_ID',l_object_id, false);
1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1639: l_body := fnd_message.get;
1640:
1641: END IF;
1642:

Line 1639: l_body := fnd_message.get;

1635: fnd_message.set_token('PCN',l_mel_cdl_rec.name, false);
1636: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
1637: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
1638: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1639: l_body := fnd_message.get;
1640:
1641: END IF;
1642:
1643: document := document || l_body;

Line 1794: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

1790: IF (get_mel_cdl_details%NOTFOUND OR l_mel_cdl_rec.object_version_number <> l_object_ovn)
1791: THEN
1792: CLOSE get_mel_cdl_details;
1793:
1794: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1795: fnd_message.set_token('HRD_ID', l_object_id, false);
1796: fnd_msg_pub.add;
1797:
1798: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1795: fnd_message.set_token('HRD_ID', l_object_id, false);

1791: THEN
1792: CLOSE get_mel_cdl_details;
1793:
1794: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1795: fnd_message.set_token('HRD_ID', l_object_id, false);
1796: fnd_msg_pub.add;
1797:
1798: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1799: THEN

Line 2004: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

2000: IF (get_mel_cdl_details%NOTFOUND OR l_mel_cdl_rec.object_version_number <> l_object_ovn)
2001: THEN
2002: CLOSE get_mel_cdl_details;
2003:
2004: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
2005: fnd_message.set_token('HRD_ID', l_object_id, false);
2006: fnd_msg_pub.add;
2007:
2008: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 2005: fnd_message.set_token('HRD_ID', l_object_id, false);

2001: THEN
2002: CLOSE get_mel_cdl_details;
2003:
2004: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
2005: fnd_message.set_token('HRD_ID', l_object_id, false);
2006: fnd_msg_pub.add;
2007:
2008: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2009: THEN

Line 2259: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ID_INVALID');

2255: IF (get_nr_details_csr%NOTFOUND OR l_nr_rec.object_version_number <> l_object_ovn)
2256: THEN
2257: CLOSE get_nr_details_csr;
2258:
2259: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ID_INVALID');
2260: fnd_message.set_token('HDR_ID', l_object_id, false);
2261: fnd_msg_pub.add;
2262:
2263: IF (l_debug_exception >= l_debug_runtime)

Line 2260: fnd_message.set_token('HDR_ID', l_object_id, false);

2256: THEN
2257: CLOSE get_nr_details_csr;
2258:
2259: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ID_INVALID');
2260: fnd_message.set_token('HDR_ID', l_object_id, false);
2261: fnd_msg_pub.add;
2262:
2263: IF (l_debug_exception >= l_debug_runtime)
2264: THEN

Line 2279: fnd_message.set_name('AHL','AHL_UMP_NR_APPR_SUBJECT');

2275:
2276: END IF;
2277: CLOSE get_nr_details_csr;
2278:
2279: fnd_message.set_name('AHL','AHL_UMP_NR_APPR_SUBJECT');
2280: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2281: fnd_message.set_token('NR_NUM', l_nr_rec.incident_number);
2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);
2283: l_temp_subject := fnd_message.get;

Line 2280: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);

2276: END IF;
2277: CLOSE get_nr_details_csr;
2278:
2279: fnd_message.set_name('AHL','AHL_UMP_NR_APPR_SUBJECT');
2280: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2281: fnd_message.set_token('NR_NUM', l_nr_rec.incident_number);
2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);
2283: l_temp_subject := fnd_message.get;
2284:

Line 2281: fnd_message.set_token('NR_NUM', l_nr_rec.incident_number);

2277: CLOSE get_nr_details_csr;
2278:
2279: fnd_message.set_name('AHL','AHL_UMP_NR_APPR_SUBJECT');
2280: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2281: fnd_message.set_token('NR_NUM', l_nr_rec.incident_number);
2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);
2283: l_temp_subject := fnd_message.get;
2284:
2285: -- form requester note.

Line 2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);

2278:
2279: fnd_message.set_name('AHL','AHL_UMP_NR_APPR_SUBJECT');
2280: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2281: fnd_message.set_token('NR_NUM', l_nr_rec.incident_number);
2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);
2283: l_temp_subject := fnd_message.get;
2284:
2285: -- form requester note.
2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');

Line 2283: l_temp_subject := fnd_message.get;

2279: fnd_message.set_name('AHL','AHL_UMP_NR_APPR_SUBJECT');
2280: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2281: fnd_message.set_token('NR_NUM', l_nr_rec.incident_number);
2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);
2283: l_temp_subject := fnd_message.get;
2284:
2285: -- form requester note.
2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');
2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);

Line 2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');

2282: fnd_message.set_token('VISIT_NUM', l_nr_rec.visit_number);
2283: l_temp_subject := fnd_message.get;
2284:
2285: -- form requester note.
2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');
2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);
2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);

Line 2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);

2283: l_temp_subject := fnd_message.get;
2284:
2285: -- form requester note.
2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');
2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);
2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);

Line 2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);

2284:
2285: -- form requester note.
2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');
2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);
2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);

Line 2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);

2285: -- form requester note.
2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');
2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);
2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;

Line 2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);

2286: fnd_message.set_name('AHL','AHL_UMP_NR_REQ_NOTE');
2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);
2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;
2294:

Line 2291: fnd_message.set_token('ITEM',l_nr_rec.Item);

2287: fnd_message.set_token('INCIDENT_NUMBER', l_nr_rec.incident_number);
2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;
2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');

Line 2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);

2288: fnd_message.set_token('VISIT_NUMBER',l_nr_rec.visit_number);
2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;
2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);

Line 2293: l_requester_note := fnd_message.get;

2289: fnd_message.set_token('SUMMARY', l_nr_rec.summary);
2290: fnd_message.set_token('TYPE_NAME',l_nr_rec.name);
2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;
2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);

Line 2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');

2291: fnd_message.set_token('ITEM',l_nr_rec.Item);
2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;
2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);

Line 2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);

2292: fnd_message.set_token('SERIAL',l_nr_rec.serial_number);
2293: l_requester_note := fnd_message.get;
2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);

Line 2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);

2293: l_requester_note := fnd_message.get;
2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);
2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);

Line 2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);

2294:
2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);
2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);
2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,

Line 2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);

2295: fnd_message.set_name('AHL','AHL_UMP_MEL_CDL_REQ_NOTE');
2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);
2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);
2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,
2303: fnd_date.outputDT_mask));

Line 2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);

2296: fnd_message.set_token('MEL_CDL', l_nr_rec.mel_cdl_type_code);
2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);
2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);
2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,
2303: fnd_date.outputDT_mask));
2304:

Line 2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);

2297: fnd_message.set_token('ATA_CODE', l_nr_rec.ata_code);
2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);
2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);
2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,
2303: fnd_date.outputDT_mask));
2304:
2305: l_requester_note := l_requester_note || fnd_message.get;

Line 2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,

2298: fnd_message.set_token('PROD_CLASS', l_nr_rec.class_name);
2299: fnd_message.set_token('PROD_CLASS_NODE', l_nr_rec.node_name);
2300: fnd_message.set_token('REP_CAT', l_nr_rec.repair_category);
2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);
2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,
2303: fnd_date.outputDT_mask));
2304:
2305: l_requester_note := l_requester_note || fnd_message.get;
2306:

Line 2305: l_requester_note := l_requester_note || fnd_message.get;

2301: fnd_message.set_token('REP_TIME', l_nr_rec.repair_time);
2302: fnd_message.set_token('EXP_DATE', to_char(l_nr_rec.expected_resolution_date,
2303: fnd_date.outputDT_mask));
2304:
2305: l_requester_note := l_requester_note || fnd_message.get;
2306:
2307: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2308: fnd_log.string
2309: (

Line 2331: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FORWARD_SUBJ');

2327: ,avalue => l_requester_note
2328: );
2329:
2330: /* FORWARD_SUBJECT */
2331: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FORWARD_SUBJ');
2332: l_subject := fnd_message.get || l_temp_subject;
2333:
2334: wf_engine.setitemattrtext
2335: (

Line 2332: l_subject := fnd_message.get || l_temp_subject;

2328: );
2329:
2330: /* FORWARD_SUBJECT */
2331: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FORWARD_SUBJ');
2332: l_subject := fnd_message.get || l_temp_subject;
2333:
2334: wf_engine.setitemattrtext
2335: (
2336: itemtype => itemtype,

Line 2353: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL_SUBJ');

2349: );
2350: END IF;
2351:
2352: /* APPROVAL_SUBJECT */
2353: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL_SUBJ');
2354: l_subject := fnd_message.get || l_temp_subject;
2355:
2356: wf_engine.setitemattrtext
2357: (

Line 2354: l_subject := fnd_message.get || l_temp_subject;

2350: END IF;
2351:
2352: /* APPROVAL_SUBJECT */
2353: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL_SUBJ');
2354: l_subject := fnd_message.get || l_temp_subject;
2355:
2356: wf_engine.setitemattrtext
2357: (
2358: itemtype => itemtype,

Line 2375: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REJECT_SUBJ');

2371: );
2372: END IF;
2373:
2374: /* REJECT_SUBJECT */
2375: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REJECT_SUBJ');
2376: l_subject := fnd_message.get || l_temp_subject;
2377:
2378: wf_engine.setitemattrtext
2379: (

Line 2376: l_subject := fnd_message.get || l_temp_subject;

2372: END IF;
2373:
2374: /* REJECT_SUBJECT */
2375: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REJECT_SUBJ');
2376: l_subject := fnd_message.get || l_temp_subject;
2377:
2378: wf_engine.setitemattrtext
2379: (
2380: itemtype => itemtype,

Line 2397: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVED_SUBJ');

2393: );
2394: END IF;
2395:
2396: /* APPROVED_SUBJECT */
2397: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVED_SUBJ');
2398: l_subject := fnd_message.get || l_temp_subject;
2399:
2400: wf_engine.setitemattrtext
2401: (

Line 2398: l_subject := fnd_message.get || l_temp_subject;

2394: END IF;
2395:
2396: /* APPROVED_SUBJECT */
2397: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVED_SUBJ');
2398: l_subject := fnd_message.get || l_temp_subject;
2399:
2400: wf_engine.setitemattrtext
2401: (
2402: itemtype => itemtype,

Line 2419: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FINAL_SUBJ');

2415: );
2416: END IF;
2417:
2418: /* FINAL_SUBJECT */
2419: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FINAL_SUBJ');
2420: l_subject := fnd_message.get || l_temp_subject;
2421:
2422: wf_engine.setitemattrtext
2423: (

Line 2420: l_subject := fnd_message.get || l_temp_subject;

2416: END IF;
2417:
2418: /* FINAL_SUBJECT */
2419: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FINAL_SUBJ');
2420: l_subject := fnd_message.get || l_temp_subject;
2421:
2422: wf_engine.setitemattrtext
2423: (
2424: itemtype => itemtype,

Line 2441: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND_SUBJ');

2437: );
2438: END IF;
2439:
2440: /* REMIND_SUBJECT */
2441: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND_SUBJ');
2442: l_subject := fnd_message.get || l_temp_subject;
2443:
2444: wf_engine.setitemattrtext
2445: (

Line 2442: l_subject := fnd_message.get || l_temp_subject;

2438: END IF;
2439:
2440: /* REMIND_SUBJECT */
2441: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND_SUBJ');
2442: l_subject := fnd_message.get || l_temp_subject;
2443:
2444: wf_engine.setitemattrtext
2445: (
2446: itemtype => itemtype,

Line 2463: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_SUBJ');

2459: );
2460: END IF;
2461:
2462: /* ERROR_SUBJECT */
2463: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_SUBJ');
2464: l_subject := fnd_message.get || l_temp_subject;
2465:
2466: wf_engine.setitemattrtext
2467: (

Line 2464: l_subject := fnd_message.get || l_temp_subject;

2460: END IF;
2461:
2462: /* ERROR_SUBJECT */
2463: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_SUBJ');
2464: l_subject := fnd_message.get || l_temp_subject;
2465:
2466: wf_engine.setitemattrtext
2467: (
2468: itemtype => itemtype,

Line 2712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FWD');

2708: ,itemkey => l_item_key
2709: ,aname => 'REQUESTER_NOTE'
2710: );
2711:
2712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FWD');
2713: fnd_message.set_token('APPROVER',l_approver, false);
2714: l_body := fnd_message.get;
2715:
2716: document := l_body || l_requester_note;

Line 2713: fnd_message.set_token('APPROVER',l_approver, false);

2709: ,aname => 'REQUESTER_NOTE'
2710: );
2711:
2712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FWD');
2713: fnd_message.set_token('APPROVER',l_approver, false);
2714: l_body := fnd_message.get;
2715:
2716: document := l_body || l_requester_note;
2717:

Line 2714: l_body := fnd_message.get;

2710: );
2711:
2712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FWD');
2713: fnd_message.set_token('APPROVER',l_approver, false);
2714: l_body := fnd_message.get;
2715:
2716: document := l_body || l_requester_note;
2717:
2718: IF (l_debug_stmt >= l_debug_runtime)

Line 2879: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_APPRVD');

2875: ,itemkey => l_item_key
2876: ,aname => 'REQUESTER_NOTE'
2877: );
2878:
2879: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_APPRVD');
2880: fnd_message.set_token('APPROVER',l_approver, false);
2881: l_body := fnd_message.get;
2882:
2883: document := document || l_body || l_requester_note;

Line 2880: fnd_message.set_token('APPROVER',l_approver, false);

2876: ,aname => 'REQUESTER_NOTE'
2877: );
2878:
2879: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_APPRVD');
2880: fnd_message.set_token('APPROVER',l_approver, false);
2881: l_body := fnd_message.get;
2882:
2883: document := document || l_body || l_requester_note;
2884:

Line 2881: l_body := fnd_message.get;

2877: );
2878:
2879: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_APPRVD');
2880: fnd_message.set_token('APPROVER',l_approver, false);
2881: l_body := fnd_message.get;
2882:
2883: document := document || l_body || l_requester_note;
2884:
2885: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 3032: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FINAL');

3028: ,itemkey => l_item_key
3029: ,aname => 'REQUESTER_NOTE'
3030: );
3031:
3032: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FINAL');
3033: l_body := fnd_message.get;
3034:
3035: document := l_body || l_requester_note;
3036:

Line 3033: l_body := fnd_message.get;

3029: ,aname => 'REQUESTER_NOTE'
3030: );
3031:
3032: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_FINAL');
3033: l_body := fnd_message.get;
3034:
3035: document := l_body || l_requester_note;
3036:
3037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 3202: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_RJCT');

3198: itemkey => l_item_key,
3199: aname => 'APPROVER NOTE'
3200: );
3201:
3202: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_RJCT');
3203: fnd_message.set_token('APPROVER',l_approver, false);
3204: l_body := fnd_message.get;
3205:
3206: document := l_body || l_requester_note;

Line 3203: fnd_message.set_token('APPROVER',l_approver, false);

3199: aname => 'APPROVER NOTE'
3200: );
3201:
3202: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_RJCT');
3203: fnd_message.set_token('APPROVER',l_approver, false);
3204: l_body := fnd_message.get;
3205:
3206: document := l_body || l_requester_note;
3207:

Line 3204: l_body := fnd_message.get;

3200: );
3201:
3202: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FYI_RJCT');
3203: fnd_message.set_token('APPROVER',l_approver, false);
3204: l_body := fnd_message.get;
3205:
3206: document := l_body || l_requester_note;
3207:
3208: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 3367: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL');

3363: OPEN get_ue_mel_cdl_details(l_object_id);
3364: FETCH get_ue_mel_cdl_details INTO l_ue_mel_cdl_details_rec;
3365: CLOSE get_ue_mel_cdl_details;
3366:
3367: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL');
3368: fnd_message.set_token('REQUESTER',l_requester, false);
3369: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code);
3370:
3371: l_body := fnd_message.get;

Line 3368: fnd_message.set_token('REQUESTER',l_requester, false);

3364: FETCH get_ue_mel_cdl_details INTO l_ue_mel_cdl_details_rec;
3365: CLOSE get_ue_mel_cdl_details;
3366:
3367: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL');
3368: fnd_message.set_token('REQUESTER',l_requester, false);
3369: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code);
3370:
3371: l_body := fnd_message.get;
3372:

Line 3369: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code);

3365: CLOSE get_ue_mel_cdl_details;
3366:
3367: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL');
3368: fnd_message.set_token('REQUESTER',l_requester, false);
3369: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code);
3370:
3371: l_body := fnd_message.get;
3372:
3373: document := l_body || l_requester_note;

Line 3371: l_body := fnd_message.get;

3367: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL');
3368: fnd_message.set_token('REQUESTER',l_requester, false);
3369: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code);
3370:
3371: l_body := fnd_message.get;
3372:
3373: document := l_body || l_requester_note;
3374:
3375: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 3534: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

3530: FETCH get_ue_mel_cdl_details into l_ue_mel_cdl_details_rec;
3531: IF (get_ue_mel_cdl_details%NOTFOUND)
3532: THEN
3533: CLOSE get_ue_mel_cdl_details;
3534: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
3535: fnd_message.set_token('HDR_ID', l_object_id, false);
3536: fnd_msg_pub.add;
3537: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3538: THEN

Line 3535: fnd_message.set_token('HDR_ID', l_object_id, false);

3531: IF (get_ue_mel_cdl_details%NOTFOUND)
3532: THEN
3533: CLOSE get_ue_mel_cdl_details;
3534: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
3535: fnd_message.set_token('HDR_ID', l_object_id, false);
3536: fnd_msg_pub.add;
3537: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3538: THEN
3539: fnd_log.message

Line 3551: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND');

3547:
3548: END IF;
3549: CLOSE get_ue_mel_cdl_details;
3550:
3551: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND');
3552: fnd_message.set_token('REQUESTER',l_requester, false);
3553: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code, false);
3554: l_body := fnd_message.get;
3555:

Line 3552: fnd_message.set_token('REQUESTER',l_requester, false);

3548: END IF;
3549: CLOSE get_ue_mel_cdl_details;
3550:
3551: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND');
3552: fnd_message.set_token('REQUESTER',l_requester, false);
3553: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code, false);
3554: l_body := fnd_message.get;
3555:
3556: document := l_body || l_requester_note;

Line 3553: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code, false);

3549: CLOSE get_ue_mel_cdl_details;
3550:
3551: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND');
3552: fnd_message.set_token('REQUESTER',l_requester, false);
3553: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code, false);
3554: l_body := fnd_message.get;
3555:
3556: document := l_body || l_requester_note;
3557:

Line 3554: l_body := fnd_message.get;

3550:
3551: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND');
3552: fnd_message.set_token('REQUESTER',l_requester, false);
3553: fnd_message.set_token('MEL_CDL',l_ue_mel_cdl_details_rec.mel_cdl_type_code, false);
3554: l_body := fnd_message.get;
3555:
3556: document := l_body || l_requester_note;
3557:
3558: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 3712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_ACT');

3708: ,itemkey => l_item_key
3709: ,aname => 'REQUESTER_NOTE'
3710: );
3711:
3712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_ACT');
3713: fnd_message.set_token('ERR_MSG',l_error_msg, false);
3714: l_body := fnd_message.get;
3715:
3716: document := l_body || l_requester_note;

Line 3713: fnd_message.set_token('ERR_MSG',l_error_msg, false);

3709: ,aname => 'REQUESTER_NOTE'
3710: );
3711:
3712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_ACT');
3713: fnd_message.set_token('ERR_MSG',l_error_msg, false);
3714: l_body := fnd_message.get;
3715:
3716: document := l_body || l_requester_note;
3717:

Line 3714: l_body := fnd_message.get;

3710: );
3711:
3712: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_ACT');
3713: fnd_message.set_token('ERR_MSG',l_error_msg, false);
3714: l_body := fnd_message.get;
3715:
3716: document := l_body || l_requester_note;
3717:
3718: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 3931: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NTF_ID_INVALID');

3927: OPEN ue_deferral_csr(l_object_id);
3928: FETCH ue_deferral_csr INTO l_deferral_rec;
3929: IF (ue_deferral_csr%NOTFOUND) THEN
3930: CLOSE ue_deferral_csr;
3931: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NTF_ID_INVALID');
3932: FND_MESSAGE.Set_Token('HDR_ID',l_object_id);
3933: FND_MSG_PUB.ADD;
3934: RAISE FND_API.G_EXC_ERROR;
3935: END IF;

Line 3932: FND_MESSAGE.Set_Token('HDR_ID',l_object_id);

3928: FETCH ue_deferral_csr INTO l_deferral_rec;
3929: IF (ue_deferral_csr%NOTFOUND) THEN
3930: CLOSE ue_deferral_csr;
3931: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NTF_ID_INVALID');
3932: FND_MESSAGE.Set_Token('HDR_ID',l_object_id);
3933: FND_MSG_PUB.ADD;
3934: RAISE FND_API.G_EXC_ERROR;
3935: END IF;
3936: CLOSE ue_deferral_csr;

Line 3945: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_WF_UE_INVALID');

3941: OPEN unit_effect_csr(l_deferral_rec.unit_effectivity_id);
3942: FETCH unit_effect_csr INTO l_ue_rec;
3943: IF (unit_effect_csr%NOTFOUND) THEN
3944: CLOSE unit_effect_csr;
3945: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_WF_UE_INVALID');
3946: FND_MESSAGE.Set_Token('UE_ID',l_deferral_rec.unit_effectivity_id);
3947: FND_MSG_PUB.ADD;
3948: RAISE FND_API.G_EXC_ERROR;
3949: END IF;

Line 3946: FND_MESSAGE.Set_Token('UE_ID',l_deferral_rec.unit_effectivity_id);

3942: FETCH unit_effect_csr INTO l_ue_rec;
3943: IF (unit_effect_csr%NOTFOUND) THEN
3944: CLOSE unit_effect_csr;
3945: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_WF_UE_INVALID');
3946: FND_MESSAGE.Set_Token('UE_ID',l_deferral_rec.unit_effectivity_id);
3947: FND_MSG_PUB.ADD;
3948: RAISE FND_API.G_EXC_ERROR;
3949: END IF;
3950: CLOSE unit_effect_csr;

Line 3961: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');

3957: p_visit_id => null,
3958: p_item_instance_id => null) = FND_API.g_true THEN
3959: -- Unit is locked, therefore cannot proceed for approval.
3960: -- and cannot login to the workorder
3961: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');
3962: FND_MESSAGE.set_token('UE_ID', l_deferral_rec.unit_effectivity_id);
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_ERROR;
3965: END IF;

Line 3962: FND_MESSAGE.set_token('UE_ID', l_deferral_rec.unit_effectivity_id);

3958: p_item_instance_id => null) = FND_API.g_true THEN
3959: -- Unit is locked, therefore cannot proceed for approval.
3960: -- and cannot login to the workorder
3961: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');
3962: FND_MESSAGE.set_token('UE_ID', l_deferral_rec.unit_effectivity_id);
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_ERROR;
3965: END IF;
3966:

Line 4203: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');

4199: IF (get_ue_mel_cdl_details%NOTFOUND OR l_mel_cdl_rec.object_version_number <> l_object_ovn)
4200: THEN
4201: CLOSE get_ue_mel_cdl_details;
4202:
4203: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
4204: fnd_message.set_token('HDR_ID', l_object_id, false);
4205: fnd_msg_pub.add;
4206:
4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 4204: fnd_message.set_token('HDR_ID', l_object_id, false);

4200: THEN
4201: CLOSE get_ue_mel_cdl_details;
4202:
4203: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
4204: fnd_message.set_token('HDR_ID', l_object_id, false);
4205: fnd_msg_pub.add;
4206:
4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4208: THEN