DBA Data[Home] [Help]

APPS.AHL_MC_APPROVALS_PVT dependencies on FND_MESSAGE

Line 83: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

79: OPEN check_mc_exists(l_object_id, null);
80: FETCH check_mc_exists into l_mc_header_rec;
81: IF check_mc_exists%NOTFOUND
82: THEN
83: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
84: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
85: fnd_message.set_token('NAME', l_mc_header_rec.NAME, false);
86: fnd_msg_pub.add;
87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 84: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

80: FETCH check_mc_exists into l_mc_header_rec;
81: IF check_mc_exists%NOTFOUND
82: THEN
83: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
84: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
85: fnd_message.set_token('NAME', l_mc_header_rec.NAME, false);
86: fnd_msg_pub.add;
87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
88: THEN

Line 85: fnd_message.set_token('NAME', l_mc_header_rec.NAME, false);

81: IF check_mc_exists%NOTFOUND
82: THEN
83: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
84: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
85: fnd_message.set_token('NAME', l_mc_header_rec.NAME, false);
86: fnd_msg_pub.add;
87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
88: THEN
89: fnd_log.message

Line 100: fnd_message.set_name('AHL', 'AHL_MC_NTF_FORWARD_SUBJECT');

96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98: CLOSE check_mc_exists;
99:
100: fnd_message.set_name('AHL', 'AHL_MC_NTF_FORWARD_SUBJECT');
101: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
102: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
103: l_subject := fnd_message.get;
104:

Line 101: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

97: END IF;
98: CLOSE check_mc_exists;
99:
100: fnd_message.set_name('AHL', 'AHL_MC_NTF_FORWARD_SUBJECT');
101: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
102: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
103: l_subject := fnd_message.get;
104:
105: wf_engine.setitemattrtext

Line 102: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

98: CLOSE check_mc_exists;
99:
100: fnd_message.set_name('AHL', 'AHL_MC_NTF_FORWARD_SUBJECT');
101: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
102: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
103: l_subject := fnd_message.get;
104:
105: wf_engine.setitemattrtext
106: (

Line 103: l_subject := fnd_message.get;

99:
100: fnd_message.set_name('AHL', 'AHL_MC_NTF_FORWARD_SUBJECT');
101: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
102: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
103: l_subject := fnd_message.get;
104:
105: wf_engine.setitemattrtext
106: (
107: itemtype => itemtype

Line 123: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL_SUBJECT');

119: 'FORWARD_SUBJECT='||l_subject
120: );
121: END IF;
122:
123: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL_SUBJECT');
124: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
125: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
126: l_subject := fnd_message.get;
127:

Line 124: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

120: );
121: END IF;
122:
123: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL_SUBJECT');
124: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
125: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
126: l_subject := fnd_message.get;
127:
128: wf_engine.setitemattrtext

Line 125: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

121: END IF;
122:
123: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL_SUBJECT');
124: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
125: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
126: l_subject := fnd_message.get;
127:
128: wf_engine.setitemattrtext
129: (

Line 126: l_subject := fnd_message.get;

122:
123: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL_SUBJECT');
124: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
125: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
126: l_subject := fnd_message.get;
127:
128: wf_engine.setitemattrtext
129: (
130: itemtype => itemtype

Line 146: fnd_message.set_name('AHL', 'AHL_MC_NTF_REJECT_SUBJECT');

142: 'APPROVAL_SUBJECT='||l_subject
143: );
144: END IF;
145:
146: fnd_message.set_name('AHL', 'AHL_MC_NTF_REJECT_SUBJECT');
147: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
148: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
149: l_subject := fnd_message.get;
150:

Line 147: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

143: );
144: END IF;
145:
146: fnd_message.set_name('AHL', 'AHL_MC_NTF_REJECT_SUBJECT');
147: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
148: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext

Line 148: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

144: END IF;
145:
146: fnd_message.set_name('AHL', 'AHL_MC_NTF_REJECT_SUBJECT');
147: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
148: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext
152: (

Line 149: l_subject := fnd_message.get;

145:
146: fnd_message.set_name('AHL', 'AHL_MC_NTF_REJECT_SUBJECT');
147: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
148: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext
152: (
153: itemtype => itemtype

Line 169: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVED_SUBJECT');

165: 'REJECT_SUBJECT='||l_subject
166: );
167: END IF;
168:
169: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVED_SUBJECT');
170: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
171: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
172: l_subject := fnd_message.get;
173:

Line 170: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

166: );
167: END IF;
168:
169: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVED_SUBJECT');
170: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
171: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext

Line 171: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

167: END IF;
168:
169: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVED_SUBJECT');
170: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
171: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext
175: (

Line 172: l_subject := fnd_message.get;

168:
169: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVED_SUBJECT');
170: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
171: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext
175: (
176: itemtype => itemtype

Line 192: fnd_message.set_name('AHL', 'AHL_MC_NTF_FINAL_SUBJECT');

188: 'APPROVED_SUBJECT='||l_subject
189: );
190: END IF;
191:
192: fnd_message.set_name('AHL', 'AHL_MC_NTF_FINAL_SUBJECT');
193: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
194: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
195: l_subject := fnd_message.get;
196:

Line 193: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

189: );
190: END IF;
191:
192: fnd_message.set_name('AHL', 'AHL_MC_NTF_FINAL_SUBJECT');
193: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
194: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
195: l_subject := fnd_message.get;
196:
197: wf_engine.setitemattrtext

Line 194: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

190: END IF;
191:
192: fnd_message.set_name('AHL', 'AHL_MC_NTF_FINAL_SUBJECT');
193: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
194: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
195: l_subject := fnd_message.get;
196:
197: wf_engine.setitemattrtext
198: (

Line 195: l_subject := fnd_message.get;

191:
192: fnd_message.set_name('AHL', 'AHL_MC_NTF_FINAL_SUBJECT');
193: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
194: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
195: l_subject := fnd_message.get;
196:
197: wf_engine.setitemattrtext
198: (
199: itemtype => itemtype

Line 215: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND_SUBJECT');

211: 'FINAL_SUBJECT='||l_subject
212: );
213: END IF;
214:
215: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND_SUBJECT');
216: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
217: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
218: l_subject := fnd_message.get;
219:

Line 216: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

212: );
213: END IF;
214:
215: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND_SUBJECT');
216: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
217: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
218: l_subject := fnd_message.get;
219:
220: wf_engine.setitemattrtext

Line 217: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

213: END IF;
214:
215: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND_SUBJECT');
216: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
217: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
218: l_subject := fnd_message.get;
219:
220: wf_engine.setitemattrtext
221: (

Line 218: l_subject := fnd_message.get;

214:
215: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND_SUBJECT');
216: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
217: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
218: l_subject := fnd_message.get;
219:
220: wf_engine.setitemattrtext
221: (
222: itemtype => itemtype

Line 238: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_SUBJECT');

234: 'REMIND_SUBJECT='||l_subject
235: );
236: END IF;
237:
238: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_SUBJECT');
239: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
240: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
241: l_subject := fnd_message.get;
242:

Line 239: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);

235: );
236: END IF;
237:
238: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_SUBJECT');
239: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
240: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
241: l_subject := fnd_message.get;
242:
243: wf_engine.setitemattrtext

Line 240: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

236: END IF;
237:
238: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_SUBJECT');
239: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
240: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
241: l_subject := fnd_message.get;
242:
243: wf_engine.setitemattrtext
244: (

Line 241: l_subject := fnd_message.get;

237:
238: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_SUBJECT');
239: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
240: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
241: l_subject := fnd_message.get;
242:
243: wf_engine.setitemattrtext
244: (
245: itemtype => itemtype

Line 480: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

476: FETCH check_mc_exists into l_mc_header_rec;
477:
478: IF check_mc_exists%NOTFOUND
479: THEN
480: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
481: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
482: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
483: fnd_msg_pub.add;
484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 481: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

477:
478: IF check_mc_exists%NOTFOUND
479: THEN
480: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
481: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
482: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
483: fnd_msg_pub.add;
484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
485: THEN

Line 482: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

478: IF check_mc_exists%NOTFOUND
479: THEN
480: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
481: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
482: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
483: fnd_msg_pub.add;
484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.message

Line 495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');

491: );
492: END IF;
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');
496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
498: fnd_message.set_token('APPR_NAME',l_approver, false);
499: l_body := fnd_message.get;

Line 496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

492: END IF;
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');
496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
498: fnd_message.set_token('APPR_NAME',l_approver, false);
499: l_body := fnd_message.get;
500: END IF;

Line 497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');
496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
498: fnd_message.set_token('APPR_NAME',l_approver, false);
499: l_body := fnd_message.get;
500: END IF;
501: CLOSE check_mc_exists;

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

494: ELSE
495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');
496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
498: fnd_message.set_token('APPR_NAME',l_approver, false);
499: l_body := fnd_message.get;
500: END IF;
501: CLOSE check_mc_exists;
502:

Line 499: l_body := fnd_message.get;

495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');
496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
498: fnd_message.set_token('APPR_NAME',l_approver, false);
499: l_body := fnd_message.get;
500: END IF;
501: CLOSE check_mc_exists;
502:
503: document := document || l_body;

Line 642: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

638: FETCH check_mc_exists into l_mc_header_rec;
639:
640: IF check_mc_exists%NOTFOUND
641: THEN
642: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
643: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
644: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
645: fnd_msg_pub.add;
646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 643: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

639:
640: IF check_mc_exists%NOTFOUND
641: THEN
642: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
643: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
644: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
645: fnd_msg_pub.add;
646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
647: THEN

Line 644: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

640: IF check_mc_exists%NOTFOUND
641: THEN
642: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
643: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
644: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
645: fnd_msg_pub.add;
646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
647: THEN
648: fnd_log.message

Line 657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');

653: );
654: END IF;
655: RAISE FND_API.G_EXC_ERROR;
656: ELSE
657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');
658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
660: fnd_message.set_token('APPR_NAME',l_approver, false);
661: l_body := fnd_message.get;

Line 658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

654: END IF;
655: RAISE FND_API.G_EXC_ERROR;
656: ELSE
657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');
658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
660: fnd_message.set_token('APPR_NAME',l_approver, false);
661: l_body := fnd_message.get;
662: END IF;

Line 659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

655: RAISE FND_API.G_EXC_ERROR;
656: ELSE
657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');
658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
660: fnd_message.set_token('APPR_NAME',l_approver, false);
661: l_body := fnd_message.get;
662: END IF;
663: CLOSE check_mc_exists;

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

656: ELSE
657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');
658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
660: fnd_message.set_token('APPR_NAME',l_approver, false);
661: l_body := fnd_message.get;
662: END IF;
663: CLOSE check_mc_exists;
664:

Line 661: l_body := fnd_message.get;

657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');
658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
660: fnd_message.set_token('APPR_NAME',l_approver, false);
661: l_body := fnd_message.get;
662: END IF;
663: CLOSE check_mc_exists;
664:
665: document := document || l_body;

Line 795: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

791: FETCH check_mc_exists into l_mc_header_rec;
792:
793: IF check_mc_exists%NOTFOUND
794: THEN
795: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
796: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
797: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
798: fnd_msg_pub.add;
799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 796: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

792:
793: IF check_mc_exists%NOTFOUND
794: THEN
795: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
796: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
797: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
798: fnd_msg_pub.add;
799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
800: THEN

Line 797: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

793: IF check_mc_exists%NOTFOUND
794: THEN
795: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
796: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
797: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
798: fnd_msg_pub.add;
799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
800: THEN
801: fnd_log.message

Line 810: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FINAL');

806: );
807: END IF;
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FINAL');
811: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
812: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
813: l_body := fnd_message.get;
814: END IF;

Line 811: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

807: END IF;
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FINAL');
811: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
812: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
813: l_body := fnd_message.get;
814: END IF;
815: CLOSE check_mc_exists;

Line 812: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FINAL');
811: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
812: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
813: l_body := fnd_message.get;
814: END IF;
815: CLOSE check_mc_exists;
816:

Line 813: l_body := fnd_message.get;

809: ELSE
810: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FINAL');
811: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
812: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
813: l_body := fnd_message.get;
814: END IF;
815: CLOSE check_mc_exists;
816:
817: document := document || l_body;

Line 956: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

952: FETCH check_mc_exists into l_mc_header_rec;
953:
954: IF check_mc_exists%NOTFOUND
955: THEN
956: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
957: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
958: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
959: fnd_msg_pub.add;
960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 957: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

953:
954: IF check_mc_exists%NOTFOUND
955: THEN
956: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
957: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
958: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
959: fnd_msg_pub.add;
960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
961: THEN

Line 958: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

954: IF check_mc_exists%NOTFOUND
955: THEN
956: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
957: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
958: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
959: fnd_msg_pub.add;
960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.message

Line 971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');

967: );
968: END IF;
969: RAISE FND_API.G_EXC_ERROR;
970: ELSE
971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');
972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
974: fnd_message.set_token('APPR_NAME',l_approver, false);
975: l_body := fnd_message.get;

Line 972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

968: END IF;
969: RAISE FND_API.G_EXC_ERROR;
970: ELSE
971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');
972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
974: fnd_message.set_token('APPR_NAME',l_approver, false);
975: l_body := fnd_message.get;
976: END IF;

Line 973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

969: RAISE FND_API.G_EXC_ERROR;
970: ELSE
971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');
972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
974: fnd_message.set_token('APPR_NAME',l_approver, false);
975: l_body := fnd_message.get;
976: END IF;
977: CLOSE check_mc_exists;

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

970: ELSE
971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');
972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
974: fnd_message.set_token('APPR_NAME',l_approver, false);
975: l_body := fnd_message.get;
976: END IF;
977: CLOSE check_mc_exists;
978:

Line 975: l_body := fnd_message.get;

971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');
972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
974: fnd_message.set_token('APPR_NAME',l_approver, false);
975: l_body := fnd_message.get;
976: END IF;
977: CLOSE check_mc_exists;
978:
979: document := document || l_body;

Line 1125: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

1121: FETCH check_mc_exists into l_mc_header_rec;
1122:
1123: IF check_mc_exists%NOTFOUND
1124: THEN
1125: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1126: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1127: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1128: fnd_msg_pub.add;
1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1126: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

1122:
1123: IF check_mc_exists%NOTFOUND
1124: THEN
1125: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1126: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1127: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1128: fnd_msg_pub.add;
1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1130: THEN

Line 1127: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1123: IF check_mc_exists%NOTFOUND
1124: THEN
1125: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1126: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1127: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1128: fnd_msg_pub.add;
1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1130: THEN
1131: fnd_log.message

Line 1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');

1136: );
1137: END IF;
1138: RAISE FND_API.G_EXC_ERROR;
1139: ELSE
1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');
1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1144: fnd_message.set_token('NOTE',l_requester_note, false);

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

1137: END IF;
1138: RAISE FND_API.G_EXC_ERROR;
1139: ELSE
1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');
1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1144: fnd_message.set_token('NOTE',l_requester_note, false);
1145: l_body := fnd_message.get;

Line 1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

1138: RAISE FND_API.G_EXC_ERROR;
1139: ELSE
1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');
1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1144: fnd_message.set_token('NOTE',l_requester_note, false);
1145: l_body := fnd_message.get;
1146: END IF;

Line 1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1139: ELSE
1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');
1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1144: fnd_message.set_token('NOTE',l_requester_note, false);
1145: l_body := fnd_message.get;
1146: END IF;
1147: CLOSE check_mc_exists;

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

1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');
1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1144: fnd_message.set_token('NOTE',l_requester_note, false);
1145: l_body := fnd_message.get;
1146: END IF;
1147: CLOSE check_mc_exists;
1148:

Line 1145: l_body := fnd_message.get;

1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1143: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1144: fnd_message.set_token('NOTE',l_requester_note, false);
1145: l_body := fnd_message.get;
1146: END IF;
1147: CLOSE check_mc_exists;
1148:
1149: document := document || l_body;

Line 1295: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

1291: FETCH check_mc_exists into l_mc_header_rec;
1292:
1293: IF check_mc_exists%NOTFOUND
1294: THEN
1295: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1296: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1297: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1298: fnd_msg_pub.add;
1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1296: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

1292:
1293: IF check_mc_exists%NOTFOUND
1294: THEN
1295: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1296: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1297: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1298: fnd_msg_pub.add;
1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1300: THEN

Line 1297: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1293: IF check_mc_exists%NOTFOUND
1294: THEN
1295: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1296: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1297: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1298: fnd_msg_pub.add;
1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1300: THEN
1301: fnd_log.message

Line 1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');

1306: );
1307: END IF;
1308: RAISE FND_API.G_EXC_ERROR;
1309: ELSE
1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');
1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1314: fnd_message.set_token('NOTE',l_requester_note, false);

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

1307: END IF;
1308: RAISE FND_API.G_EXC_ERROR;
1309: ELSE
1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');
1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1314: fnd_message.set_token('NOTE',l_requester_note, false);
1315: l_body := fnd_message.get;

Line 1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

1308: RAISE FND_API.G_EXC_ERROR;
1309: ELSE
1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');
1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1314: fnd_message.set_token('NOTE',l_requester_note, false);
1315: l_body := fnd_message.get;
1316: END IF;

Line 1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1309: ELSE
1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');
1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1314: fnd_message.set_token('NOTE',l_requester_note, false);
1315: l_body := fnd_message.get;
1316: END IF;
1317: CLOSE check_mc_exists;

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

1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');
1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1314: fnd_message.set_token('NOTE',l_requester_note, false);
1315: l_body := fnd_message.get;
1316: END IF;
1317: CLOSE check_mc_exists;
1318:

Line 1315: l_body := fnd_message.get;

1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1313: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1314: fnd_message.set_token('NOTE',l_requester_note, false);
1315: l_body := fnd_message.get;
1316: END IF;
1317: CLOSE check_mc_exists;
1318:
1319: document := document || l_body;

Line 1455: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

1451: FETCH check_mc_exists into l_mc_header_rec;
1452:
1453: IF check_mc_exists%NOTFOUND
1454: THEN
1455: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1456: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1457: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1458: fnd_msg_pub.add;
1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1456: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

1452:
1453: IF check_mc_exists%NOTFOUND
1454: THEN
1455: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1456: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1457: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1458: fnd_msg_pub.add;
1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1460: THEN

Line 1457: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1453: IF check_mc_exists%NOTFOUND
1454: THEN
1455: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1456: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1457: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1458: fnd_msg_pub.add;
1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1460: THEN
1461: fnd_log.message

Line 1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');

1466: );
1467: END IF;
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSE
1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');
1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1473: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1474: l_body := fnd_message.get;

Line 1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

1467: END IF;
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSE
1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');
1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1473: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1474: l_body := fnd_message.get;
1475: END IF;

Line 1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSE
1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');
1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1473: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1474: l_body := fnd_message.get;
1475: END IF;
1476: CLOSE check_mc_exists;

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

1469: ELSE
1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');
1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1473: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1474: l_body := fnd_message.get;
1475: END IF;
1476: CLOSE check_mc_exists;
1477:

Line 1474: l_body := fnd_message.get;

1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');
1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1473: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1474: l_body := fnd_message.get;
1475: END IF;
1476: CLOSE check_mc_exists;
1477:
1478: document := document || l_body;

Line 1619: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

1615: FETCH check_mc_exists into l_mc_header_rec;
1616:
1617: IF check_mc_exists%NOTFOUND
1618: THEN
1619: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1620: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1621: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1622: fnd_msg_pub.add;
1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1620: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

1616:
1617: IF check_mc_exists%NOTFOUND
1618: THEN
1619: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1620: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1621: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1622: fnd_msg_pub.add;
1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1624: THEN

Line 1621: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1617: IF check_mc_exists%NOTFOUND
1618: THEN
1619: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1620: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1621: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1622: fnd_msg_pub.add;
1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1624: THEN
1625: fnd_log.message

Line 1811: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');

1807: FETCH check_mc_exists into l_mc_header_rec;
1808:
1809: IF check_mc_exists%NOTFOUND
1810: THEN
1811: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1812: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1813: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1814: fnd_msg_pub.add;
1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1812: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);

1808:
1809: IF check_mc_exists%NOTFOUND
1810: THEN
1811: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1812: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1813: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1814: fnd_msg_pub.add;
1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1816: THEN

Line 1813: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

1809: IF check_mc_exists%NOTFOUND
1810: THEN
1811: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1812: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1813: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1814: fnd_msg_pub.add;
1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1816: THEN
1817: fnd_log.message