eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_DF_APPR_PVT dependencies on FND_MESSAGE

Line 94: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');

90:
91: OPEN unit_effectivity_id_csr(l_object_id);
92: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id;
93: IF(unit_effectivity_id_csr%NOTFOUND) THEN
94: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');
95: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
96: FND_MSG_PUB.ADD;
97: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
98: fnd_log.string

Line 95: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);

91: OPEN unit_effectivity_id_csr(l_object_id);
92: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id;
93: IF(unit_effectivity_id_csr%NOTFOUND) THEN
94: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');
95: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
96: FND_MSG_PUB.ADD;
97: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
98: fnd_log.string
99: (

Line 117: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');

113: x_return_status => l_return_status,
114: x_msg_count => l_msg_count,
115: x_msg_data => l_msg_data);
116: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
118: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
119: FND_MSG_PUB.ADD;
120: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
121: fnd_log.string

Line 118: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);

114: x_msg_count => l_msg_count,
115: x_msg_data => l_msg_data);
116: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
118: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
119: FND_MSG_PUB.ADD;
120: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
121: fnd_log.string
122: (

Line 131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');

127: END IF;
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSE
130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');
132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);
133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;
135: ELSE

Line 132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);

128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSE
130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');
132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);
133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;
135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');

Line 133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);

129: ELSE
130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');
132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);
133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;
135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');
137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);

Line 134: l_temp_subject := FND_MESSAGE.get;

130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');
132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);
133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;
135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');
137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);
138: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);

Line 136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');

132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);
133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;
135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');
137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);
138: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
139: l_temp_subject := FND_MESSAGE.get;
140: END IF;

Line 137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);

133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;
135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');
137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);
138: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
139: l_temp_subject := FND_MESSAGE.get;
140: END IF;
141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 138: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);

134: l_temp_subject := FND_MESSAGE.get;
135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');
137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);
138: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
139: l_temp_subject := FND_MESSAGE.get;
140: END IF;
141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
142: fnd_log.string

Line 139: l_temp_subject := FND_MESSAGE.get;

135: ELSE
136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_SUBJECT');
137: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',l_df_header_info_rec.incident_number,false);
138: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
139: l_temp_subject := FND_MESSAGE.get;
140: END IF;
141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
142: fnd_log.string
143: (

Line 189: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FW_SUBJECT');

185: 'REQUESTER NOTE : ' || l_requester_note
186: );
187: END IF;
188:
189: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FW_SUBJECT');
190: l_subject := FND_MESSAGE.get || l_temp_subject;
191:
192: wf_engine.setitemattrtext(
193: itemtype => itemtype

Line 190: l_subject := FND_MESSAGE.get || l_temp_subject;

186: );
187: END IF;
188:
189: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FW_SUBJECT');
190: l_subject := FND_MESSAGE.get || l_temp_subject;
191:
192: wf_engine.setitemattrtext(
193: itemtype => itemtype
194: ,itemkey => itemkey

Line 199: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_SUBJECT');

195: ,aname => 'FORWARD_SUBJECT'
196: ,avalue => l_subject
197: );
198:
199: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_SUBJECT');
200: l_subject := FND_MESSAGE.get || l_temp_subject;
201:
202: wf_engine.setitemattrtext(
203: itemtype => itemtype

Line 200: l_subject := FND_MESSAGE.get || l_temp_subject;

196: ,avalue => l_subject
197: );
198:
199: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_SUBJECT');
200: l_subject := FND_MESSAGE.get || l_temp_subject;
201:
202: wf_engine.setitemattrtext(
203: itemtype => itemtype
204: ,itemkey => itemkey

Line 209: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_SUBJECT');

205: ,aname => 'APPROVAL_SUBJECT'
206: ,avalue => l_subject
207: );
208:
209: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_SUBJECT');
210: l_subject := FND_MESSAGE.get || l_temp_subject;
211:
212: wf_engine.setitemattrtext(
213: itemtype => itemtype

Line 210: l_subject := FND_MESSAGE.get || l_temp_subject;

206: ,avalue => l_subject
207: );
208:
209: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_SUBJECT');
210: l_subject := FND_MESSAGE.get || l_temp_subject;
211:
212: wf_engine.setitemattrtext(
213: itemtype => itemtype
214: ,itemkey => itemkey

Line 219: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APVD_SUBJECT');

215: ,aname => 'REJECT_SUBJECT'
216: ,avalue => l_subject
217: );
218:
219: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APVD_SUBJECT');
220: l_subject := FND_MESSAGE.get || l_temp_subject;
221:
222: wf_engine.setitemattrtext(
223: itemtype => itemtype

Line 220: l_subject := FND_MESSAGE.get || l_temp_subject;

216: ,avalue => l_subject
217: );
218:
219: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APVD_SUBJECT');
220: l_subject := FND_MESSAGE.get || l_temp_subject;
221:
222: wf_engine.setitemattrtext(
223: itemtype => itemtype
224: ,itemkey => itemkey

Line 229: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FIN_SUBJECT');

225: ,aname => 'APPROVED_SUBJECT'
226: ,avalue => l_subject
227: );
228:
229: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FIN_SUBJECT');
230: l_subject := FND_MESSAGE.get || l_temp_subject;
231:
232: wf_engine.setitemattrtext(
233: itemtype => itemtype

Line 230: l_subject := FND_MESSAGE.get || l_temp_subject;

226: ,avalue => l_subject
227: );
228:
229: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FIN_SUBJECT');
230: l_subject := FND_MESSAGE.get || l_temp_subject;
231:
232: wf_engine.setitemattrtext(
233: itemtype => itemtype
234: ,itemkey => itemkey

Line 239: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REM_SUBJECT');

235: ,aname => 'FINAL_SUBJECT'
236: ,avalue => l_subject
237: );
238:
239: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REM_SUBJECT');
240: l_subject := FND_MESSAGE.get || l_temp_subject;
241:
242: wf_engine.setitemattrtext(
243: itemtype => itemtype

Line 240: l_subject := FND_MESSAGE.get || l_temp_subject;

236: ,avalue => l_subject
237: );
238:
239: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REM_SUBJECT');
240: l_subject := FND_MESSAGE.get || l_temp_subject;
241:
242: wf_engine.setitemattrtext(
243: itemtype => itemtype
244: ,itemkey => itemkey

Line 248: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_SUBJECT');

244: ,itemkey => itemkey
245: ,aname => 'REMIND_SUBJECT'
246: ,avalue => l_subject);
247:
248: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_SUBJECT');
249: l_subject := FND_MESSAGE.get || l_temp_subject;
250:
251: wf_engine.setitemattrtext(
252: itemtype => itemtype

Line 249: l_subject := FND_MESSAGE.get || l_temp_subject;

245: ,aname => 'REMIND_SUBJECT'
246: ,avalue => l_subject);
247:
248: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_SUBJECT');
249: l_subject := FND_MESSAGE.get || l_temp_subject;
250:
251: wf_engine.setitemattrtext(
252: itemtype => itemtype
253: ,itemkey => itemkey

Line 413: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FWD_BODY');

409: ,itemkey => l_item_key
410: ,aname => 'REQUESTER_NOTE'
411: );
412:
413: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FWD_BODY');
414: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
415: document := FND_MESSAGE.get;
416: document := document || l_requester_note;
417:

Line 414: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);

410: ,aname => 'REQUESTER_NOTE'
411: );
412:
413: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FWD_BODY');
414: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
415: document := FND_MESSAGE.get;
416: document := document || l_requester_note;
417:
418: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 415: document := FND_MESSAGE.get;

411: );
412:
413: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FWD_BODY');
414: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
415: document := FND_MESSAGE.get;
416: document := document || l_requester_note;
417:
418: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
419: fnd_log.string

Line 525: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APRVD_BODY');

521: ,itemkey => l_item_key
522: ,aname => 'REQUESTER_NOTE'
523: );
524:
525: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APRVD_BODY');
526: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
527: document := FND_MESSAGE.get;
528: document := document || l_requester_note;
529:

Line 526: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);

522: ,aname => 'REQUESTER_NOTE'
523: );
524:
525: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APRVD_BODY');
526: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
527: document := FND_MESSAGE.get;
528: document := document || l_requester_note;
529:
530: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 527: document := FND_MESSAGE.get;

523: );
524:
525: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APRVD_BODY');
526: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
527: document := FND_MESSAGE.get;
528: document := document || l_requester_note;
529:
530: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
531: fnd_log.string

Line 632: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FAPPR_BODY');

628: ,itemkey => l_item_key
629: ,aname => 'REQUESTER_NOTE'
630: );
631:
632: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FAPPR_BODY');
633: document := FND_MESSAGE.get;
634: document := document || l_requester_note;
635:
636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 633: document := FND_MESSAGE.get;

629: ,aname => 'REQUESTER_NOTE'
630: );
631:
632: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FAPPR_BODY');
633: document := FND_MESSAGE.get;
634: document := document || l_requester_note;
635:
636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
637: fnd_log.string

Line 745: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_BODY');

741: ,itemkey => l_item_key
742: ,aname => 'REQUESTER_NOTE'
743: );
744:
745: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_BODY');
746: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
747: document := FND_MESSAGE.get;
748: document := document || l_requester_note;
749:

Line 746: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);

742: ,aname => 'REQUESTER_NOTE'
743: );
744:
745: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_BODY');
746: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
747: document := FND_MESSAGE.get;
748: document := document || l_requester_note;
749:
750: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 747: document := FND_MESSAGE.get;

743: );
744:
745: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_BODY');
746: FND_MESSAGE.SET_TOKEN('APPROVER',l_approver ,false);
747: document := FND_MESSAGE.get;
748: document := document || l_requester_note;
749:
750: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
751: fnd_log.string

Line 860: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_BODY');

856: ,itemkey => l_item_key
857: ,aname => 'REQUESTER_NOTE'
858: );
859:
860: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_BODY');
861: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);
862: document := FND_MESSAGE.get;
863: document := document || l_requester_note;
864:

Line 861: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);

857: ,aname => 'REQUESTER_NOTE'
858: );
859:
860: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_BODY');
861: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);
862: document := FND_MESSAGE.get;
863: document := document || l_requester_note;
864:
865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 862: document := FND_MESSAGE.get;

858: );
859:
860: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_BODY');
861: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);
862: document := FND_MESSAGE.get;
863: document := document || l_requester_note;
864:
865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
866: fnd_log.string

Line 977: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPRM_BODY');

973: ,itemkey => l_item_key
974: ,aname => 'REQUESTER_NOTE'
975: );
976:
977: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPRM_BODY');
978: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);
979: document := FND_MESSAGE.get;
980: document := document || l_requester_note;
981:

Line 978: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);

974: ,aname => 'REQUESTER_NOTE'
975: );
976:
977: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPRM_BODY');
978: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);
979: document := FND_MESSAGE.get;
980: document := document || l_requester_note;
981:
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 979: document := FND_MESSAGE.get;

975: );
976:
977: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPRM_BODY');
978: FND_MESSAGE.SET_TOKEN('REQUESTER',l_requester ,false);
979: document := FND_MESSAGE.get;
980: document := document || l_requester_note;
981:
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
983: fnd_log.string

Line 1099: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_BODY');

1095: ,itemkey => l_item_key
1096: ,aname => 'REQUESTER_NOTE'
1097: );
1098:
1099: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_BODY');
1100: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_error_msg ,false);
1101: document := FND_MESSAGE.get;
1102: document := document || l_requester_note;
1103:

Line 1100: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_error_msg ,false);

1096: ,aname => 'REQUESTER_NOTE'
1097: );
1098:
1099: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_BODY');
1100: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_error_msg ,false);
1101: document := FND_MESSAGE.get;
1102: document := document || l_requester_note;
1103:
1104: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1101: document := FND_MESSAGE.get;

1097: );
1098:
1099: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_BODY');
1100: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_error_msg ,false);
1101: document := FND_MESSAGE.get;
1102: document := document || l_requester_note;
1103:
1104: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1105: fnd_log.string

Line 1256: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');

1252:
1253: OPEN unit_effectivity_id_csr(l_object_id);
1254: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id;
1255: IF(unit_effectivity_id_csr%NOTFOUND) THEN
1256: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');
1257: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1258: FND_MSG_PUB.ADD;
1259: CLOSE unit_effectivity_id_csr;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1257: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);

1253: OPEN unit_effectivity_id_csr(l_object_id);
1254: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id;
1255: IF(unit_effectivity_id_csr%NOTFOUND) THEN
1256: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');
1257: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1258: FND_MSG_PUB.ADD;
1259: CLOSE unit_effectivity_id_csr;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: ELSE

Line 1271: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');

1267: x_return_status => l_return_status,
1268: x_msg_count => l_msg_count,
1269: x_msg_data => l_msg_data);
1270: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1271: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
1272: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSE

Line 1272: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);

1268: x_msg_count => l_msg_count,
1269: x_msg_data => l_msg_data);
1270: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1271: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
1272: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSE
1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND

Line 1279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_MR_EXPIRED');

1275: ELSE
1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND
1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN
1278:
1279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_MR_EXPIRED');
1280: l_msg_data := FND_MESSAGE.get;
1281: UPDATE AHL_UNIT_DEFERRALS_TL
1282: SET approver_notes = approver_notes || l_msg_data,
1283: SOURCE_LANG = userenv('LANG')

Line 1280: l_msg_data := FND_MESSAGE.get;

1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND
1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN
1278:
1279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_MR_EXPIRED');
1280: l_msg_data := FND_MESSAGE.get;
1281: UPDATE AHL_UNIT_DEFERRALS_TL
1282: SET approver_notes = approver_notes || l_msg_data,
1283: SOURCE_LANG = userenv('LANG')
1284: WHERE unit_deferral_id = l_object_id

Line 1618: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');

1614: WHERE fnd.lookup_type = 'AHL_PRD_DF_CT_VAL_TYPES';
1615:
1616:
1617: BEGIN
1618: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1619: l_requester_note := FND_MESSAGE.get;
1620:
1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');

Line 1619: l_requester_note := FND_MESSAGE.get;

1615:
1616:
1617: BEGIN
1618: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1619: l_requester_note := FND_MESSAGE.get;
1620:
1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);

Line 1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');

1618: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1619: l_requester_note := FND_MESSAGE.get;
1620:
1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);

Line 1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);

1619: l_requester_note := FND_MESSAGE.get;
1620:
1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);

1620:
1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE

Line 1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);

1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');

Line 1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);

1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);

Line 1627: l_requester_note := l_requester_note || FND_MESSAGE.get;

1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);

Line 1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');

1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);

Line 1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);

1626: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1634: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);

1627: l_requester_note := l_requester_note || FND_MESSAGE.get;
1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1634: l_requester_note := l_requester_note || FND_MESSAGE.get;
1635: END IF;

Line 1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);

1628: ELSE
1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1634: l_requester_note := l_requester_note || FND_MESSAGE.get;
1635: END IF;
1636:

Line 1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);

1629: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1634: l_requester_note := l_requester_note || FND_MESSAGE.get;
1635: END IF;
1636:
1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');

Line 1634: l_requester_note := l_requester_note || FND_MESSAGE.get;

1630: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1631: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1632: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1634: l_requester_note := l_requester_note || FND_MESSAGE.get;
1635: END IF;
1636:
1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);

Line 1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');

1633: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1634: l_requester_note := l_requester_note || FND_MESSAGE.get;
1635: END IF;
1636:
1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1639: l_requester_note := l_requester_note || FND_MESSAGE.get;
1640:
1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');

Line 1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);

1634: l_requester_note := l_requester_note || FND_MESSAGE.get;
1635: END IF;
1636:
1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1639: l_requester_note := l_requester_note || FND_MESSAGE.get;
1640:
1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);

Line 1639: l_requester_note := l_requester_note || FND_MESSAGE.get;

1635: END IF;
1636:
1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1639: l_requester_note := l_requester_note || FND_MESSAGE.get;
1640:
1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1643: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');

1637: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1639: l_requester_note := l_requester_note || FND_MESSAGE.get;
1640:
1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1643: l_requester_note := l_requester_note || FND_MESSAGE.get;
1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');

Line 1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);

1638: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1639: l_requester_note := l_requester_note || FND_MESSAGE.get;
1640:
1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1643: l_requester_note := l_requester_note || FND_MESSAGE.get;
1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1643: l_requester_note := l_requester_note || FND_MESSAGE.get;

1639: l_requester_note := l_requester_note || FND_MESSAGE.get;
1640:
1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1643: l_requester_note := l_requester_note || FND_MESSAGE.get;
1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN

Line 1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');

1641: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1643: l_requester_note := l_requester_note || FND_MESSAGE.get;
1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1646: l_requester_note := l_requester_note || FND_MESSAGE.get;

1642: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1643: l_requester_note := l_requester_note || FND_MESSAGE.get;
1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN

Line 1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');

1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1649: l_requester_note := l_requester_note || FND_MESSAGE.get;

1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE

Line 1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');

1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE
1654: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');

Line 1652: l_requester_note := l_requester_note || FND_MESSAGE.get;

1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE
1654: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1656: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');

1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE
1654: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1656: l_requester_note := l_requester_note || FND_MESSAGE.get;
1657: END IF;
1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);

Line 1656: l_requester_note := l_requester_note || FND_MESSAGE.get;

1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE
1654: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1656: l_requester_note := l_requester_note || FND_MESSAGE.get;
1657: END IF;
1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1660: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');

1654: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1656: l_requester_note := l_requester_note || FND_MESSAGE.get;
1657: END IF;
1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1660: l_requester_note := l_requester_note || FND_MESSAGE.get;
1661:
1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');

Line 1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);

1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1656: l_requester_note := l_requester_note || FND_MESSAGE.get;
1657: END IF;
1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1660: l_requester_note := l_requester_note || FND_MESSAGE.get;
1661:
1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);

Line 1660: l_requester_note := l_requester_note || FND_MESSAGE.get;

1656: l_requester_note := l_requester_note || FND_MESSAGE.get;
1657: END IF;
1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1660: l_requester_note := l_requester_note || FND_MESSAGE.get;
1661:
1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1664: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');

1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1660: l_requester_note := l_requester_note || FND_MESSAGE.get;
1661:
1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1664: l_requester_note := l_requester_note || FND_MESSAGE.get;
1665:
1666: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');

Line 1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);

1659: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1660: l_requester_note := l_requester_note || FND_MESSAGE.get;
1661:
1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1664: l_requester_note := l_requester_note || FND_MESSAGE.get;
1665:
1666: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1667: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1664: l_requester_note := l_requester_note || FND_MESSAGE.get;

1660: l_requester_note := l_requester_note || FND_MESSAGE.get;
1661:
1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1664: l_requester_note := l_requester_note || FND_MESSAGE.get;
1665:
1666: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1667: l_requester_note := l_requester_note || FND_MESSAGE.get;
1668:

Line 1666: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');

1662: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1664: l_requester_note := l_requester_note || FND_MESSAGE.get;
1665:
1666: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1667: l_requester_note := l_requester_note || FND_MESSAGE.get;
1668:
1669: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1670: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP

Line 1667: l_requester_note := l_requester_note || FND_MESSAGE.get;

1663: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1664: l_requester_note := l_requester_note || FND_MESSAGE.get;
1665:
1666: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1667: l_requester_note := l_requester_note || FND_MESSAGE.get;
1668:
1669: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1670: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP
1671: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN

Line 1679: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');

1675: END IF;
1676: END LOOP;
1677:
1678: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1679: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1681: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN

Line 1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);

1676: END LOOP;
1677:
1678: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1679: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1681: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);

Line 1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);

1678: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1679: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1681: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;
1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);

Line 1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);

1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1681: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;
1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1687: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1688: l_requester_note := l_requester_note || FND_MESSAGE.get;

Line 1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);

1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;
1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1687: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1688: l_requester_note := l_requester_note || FND_MESSAGE.get;
1689: END LOOP;
1690: END IF;

Line 1687: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);

1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;
1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1687: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1688: l_requester_note := l_requester_note || FND_MESSAGE.get;
1689: END LOOP;
1690: END IF;
1691: END IF;

Line 1688: l_requester_note := l_requester_note || FND_MESSAGE.get;

1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;
1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1687: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1688: l_requester_note := l_requester_note || FND_MESSAGE.get;
1689: END LOOP;
1690: END IF;
1691: END IF;
1692: RETURN l_requester_note;