DBA Data[Home] [Help]

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 1546: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');

1542: WHERE fnd.lookup_type = 'AHL_PRD_DF_CT_VAL_TYPES';
1543:
1544:
1545: BEGIN
1546: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1547: l_requester_note := FND_MESSAGE.get;
1548:
1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');

Line 1547: l_requester_note := FND_MESSAGE.get;

1543:
1544:
1545: BEGIN
1546: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1547: l_requester_note := FND_MESSAGE.get;
1548:
1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);

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

1546: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1547: l_requester_note := FND_MESSAGE.get;
1548:
1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);

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

1547: l_requester_note := FND_MESSAGE.get;
1548:
1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1548:
1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE

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

1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');

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

1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);

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

1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);

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

1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);
1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1560: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);

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

1554: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1560: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1562: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1555: l_requester_note := l_requester_note || FND_MESSAGE.get;
1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1560: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1562: l_requester_note := l_requester_note || FND_MESSAGE.get;
1563: END IF;

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

1556: ELSE
1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1560: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1562: l_requester_note := l_requester_note || FND_MESSAGE.get;
1563: END IF;
1564:

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

1557: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SR_CTXT');
1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1560: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1562: l_requester_note := l_requester_note || FND_MESSAGE.get;
1563: END IF;
1564:
1565: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');

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

1558: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER',p_df_header_info_rec.incident_number,false);
1559: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1560: FND_MESSAGE.SET_TOKEN('SUMMARY',p_df_header_info_rec.summary,false);
1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1562: l_requester_note := l_requester_note || FND_MESSAGE.get;
1563: END IF;
1564:
1565: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1566: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);

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

1561: FND_MESSAGE.SET_TOKEN('DUE_DATE',p_df_header_info_rec.due_date,false);
1562: l_requester_note := l_requester_note || FND_MESSAGE.get;
1563: END IF;
1564:
1565: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1566: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1567: l_requester_note := l_requester_note || FND_MESSAGE.get;
1568:
1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');

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

1562: l_requester_note := l_requester_note || FND_MESSAGE.get;
1563: END IF;
1564:
1565: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1566: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1567: l_requester_note := l_requester_note || FND_MESSAGE.get;
1568:
1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);

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

1563: END IF;
1564:
1565: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1566: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1567: l_requester_note := l_requester_note || FND_MESSAGE.get;
1568:
1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1571: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1565: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REASON');
1566: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1567: l_requester_note := l_requester_note || FND_MESSAGE.get;
1568:
1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1571: l_requester_note := l_requester_note || FND_MESSAGE.get;
1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');

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

1566: FND_MESSAGE.SET_TOKEN('REASON',getReasonCode(p_df_header_info_rec.defer_reason_code),false);
1567: l_requester_note := l_requester_note || FND_MESSAGE.get;
1568:
1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1571: l_requester_note := l_requester_note || FND_MESSAGE.get;
1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1567: l_requester_note := l_requester_note || FND_MESSAGE.get;
1568:
1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1571: l_requester_note := l_requester_note || FND_MESSAGE.get;
1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(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 1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');

1569: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REMARK');
1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1571: l_requester_note := l_requester_note || FND_MESSAGE.get;
1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');

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

1570: FND_MESSAGE.SET_TOKEN('REMARK',p_df_header_info_rec.remarks,false);
1571: l_requester_note := l_requester_note || FND_MESSAGE.get;
1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;
1579: ELSE
1580: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1581: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;
1579: ELSE
1580: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1581: l_requester_note := l_requester_note || FND_MESSAGE.get;
1582: END IF;

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

1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;
1579: ELSE
1580: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1581: l_requester_note := l_requester_note || FND_MESSAGE.get;
1582: END IF;
1583: ELSE
1584: 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

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

1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;
1579: ELSE
1580: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1581: l_requester_note := l_requester_note || FND_MESSAGE.get;
1582: END IF;
1583: ELSE
1584: 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
1585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');

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

1581: l_requester_note := l_requester_note || FND_MESSAGE.get;
1582: END IF;
1583: ELSE
1584: 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
1585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1586: l_requester_note := l_requester_note || FND_MESSAGE.get;
1587: END IF;
1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);

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

1582: END IF;
1583: ELSE
1584: 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
1585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1586: l_requester_note := l_requester_note || FND_MESSAGE.get;
1587: END IF;
1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1590: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1584: 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
1585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1586: l_requester_note := l_requester_note || FND_MESSAGE.get;
1587: END IF;
1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1590: l_requester_note := l_requester_note || FND_MESSAGE.get;
1591:
1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');

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

1585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1586: l_requester_note := l_requester_note || FND_MESSAGE.get;
1587: END IF;
1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1590: l_requester_note := l_requester_note || FND_MESSAGE.get;
1591:
1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);

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

1586: l_requester_note := l_requester_note || FND_MESSAGE.get;
1587: END IF;
1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1590: l_requester_note := l_requester_note || FND_MESSAGE.get;
1591:
1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1594: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');
1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1590: l_requester_note := l_requester_note || FND_MESSAGE.get;
1591:
1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1594: l_requester_note := l_requester_note || FND_MESSAGE.get;
1595:
1596: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');

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

1589: FND_MESSAGE.SET_TOKEN('SET_DUE_DATE',p_df_header_info_rec.set_due_date,false);
1590: l_requester_note := l_requester_note || FND_MESSAGE.get;
1591:
1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1594: l_requester_note := l_requester_note || FND_MESSAGE.get;
1595:
1596: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1597: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1590: l_requester_note := l_requester_note || FND_MESSAGE.get;
1591:
1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1594: l_requester_note := l_requester_note || FND_MESSAGE.get;
1595:
1596: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1597: l_requester_note := l_requester_note || FND_MESSAGE.get;
1598:

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

1592: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_EFFDT');
1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1594: l_requester_note := l_requester_note || FND_MESSAGE.get;
1595:
1596: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1597: l_requester_note := l_requester_note || FND_MESSAGE.get;
1598:
1599: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1600: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP

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

1593: FND_MESSAGE.SET_TOKEN('EFFECT_DATE',p_df_header_info_rec.deferral_effective_on,false);
1594: l_requester_note := l_requester_note || FND_MESSAGE.get;
1595:
1596: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_VALS');
1597: l_requester_note := l_requester_note || FND_MESSAGE.get;
1598:
1599: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1600: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP
1601: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN

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

1605: END IF;
1606: END LOOP;
1607:
1608: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1609: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1610: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN

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

1606: END LOOP;
1607:
1608: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1609: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1610: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);

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

1608: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1609: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1610: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;
1616: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);

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

1610: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;
1616: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1617: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1618: l_requester_note := l_requester_note || FND_MESSAGE.get;

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

1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;
1616: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1617: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1618: l_requester_note := l_requester_note || FND_MESSAGE.get;
1619: END LOOP;
1620: END IF;

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

1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;
1616: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1617: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1618: l_requester_note := l_requester_note || FND_MESSAGE.get;
1619: END LOOP;
1620: END IF;
1621: END IF;

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

1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;
1616: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1617: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);
1618: l_requester_note := l_requester_note || FND_MESSAGE.get;
1619: END LOOP;
1620: END IF;
1621: END IF;
1622: RETURN l_requester_note;