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