78:
79: OPEN get_uc_header_det(l_object_id);
80: FETCH get_uc_header_det into l_uc_header_rec;
81: IF get_uc_header_det%NOTFOUND THEN
82: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
83: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: CLOSE get_uc_header_det;
79: OPEN get_uc_header_det(l_object_id);
80: FETCH get_uc_header_det into l_uc_header_rec;
81: IF get_uc_header_det%NOTFOUND THEN
82: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
83: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: CLOSE get_uc_header_det;
87:
85: END IF;
86: CLOSE get_uc_header_det;
87:
88: --
89: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
90: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
91: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
92: l_subject := fnd_message.get;
93:
86: CLOSE get_uc_header_det;
87:
88: --
89: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
90: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
91: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
92: l_subject := fnd_message.get;
93:
94: wf_engine.setitemattrtext
87:
88: --
89: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
90: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
91: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
92: l_subject := fnd_message.get;
93:
94: wf_engine.setitemattrtext
95: (
88: --
89: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
90: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
91: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
92: l_subject := fnd_message.get;
93:
94: wf_engine.setitemattrtext
95: (
96: itemtype => itemtype
104: END IF;
105: --
106:
107: --
108: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
109: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
110: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
111: l_subject := fnd_message.get;
112:
105: --
106:
107: --
108: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
109: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
110: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext
106:
107: --
108: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
109: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
110: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext
114: (
107: --
108: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
109: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
110: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext
114: (
115: itemtype => itemtype
123: END IF;
124: --
125:
126: --
127: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
128: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
129: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
130: l_subject := fnd_message.get;
131:
124: --
125:
126: --
127: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
128: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
129: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
130: l_subject := fnd_message.get;
131:
132: wf_engine.setitemattrtext
125:
126: --
127: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
128: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
129: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
130: l_subject := fnd_message.get;
131:
132: wf_engine.setitemattrtext
133: (
126: --
127: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
128: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
129: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
130: l_subject := fnd_message.get;
131:
132: wf_engine.setitemattrtext
133: (
134: itemtype => itemtype
142: END IF;
143: --
144:
145: --
146: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
147: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
148: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
149: l_subject := fnd_message.get;
150:
143: --
144:
145: --
146: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
147: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
148: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext
144:
145: --
146: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
147: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
148: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext
152: (
145: --
146: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
147: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
148: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext
152: (
153: itemtype => itemtype
160: END IF;
161: --
162:
163: --
164: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
165: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
166: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
167: l_subject := fnd_message.get;
168:
161: --
162:
163: --
164: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
165: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
166: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
167: l_subject := fnd_message.get;
168:
169: wf_engine.setitemattrtext
162:
163: --
164: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
165: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
166: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
167: l_subject := fnd_message.get;
168:
169: wf_engine.setitemattrtext
170: (
163: --
164: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
165: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
166: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
167: l_subject := fnd_message.get;
168:
169: wf_engine.setitemattrtext
170: (
171: itemtype => itemtype
178: END IF;
179: --
180:
181: --
182: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND_SUBJECT');
183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
184: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
185: l_subject := fnd_message.get;
186:
179: --
180:
181: --
182: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND_SUBJECT');
183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
184: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
185: l_subject := fnd_message.get;
186:
187: wf_engine.setitemattrtext
180:
181: --
182: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND_SUBJECT');
183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
184: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
185: l_subject := fnd_message.get;
186:
187: wf_engine.setitemattrtext
188: (
181: --
182: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND_SUBJECT');
183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
184: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
185: l_subject := fnd_message.get;
186:
187: wf_engine.setitemattrtext
188: (
189: itemtype => itemtype
196: END IF;
197: --
198:
199: --
200: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
201: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
202: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
203: l_subject := fnd_message.get;
204:
197: --
198:
199: --
200: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
201: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
202: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
203: l_subject := fnd_message.get;
204:
205: wf_engine.setitemattrtext
198:
199: --
200: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
201: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
202: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
203: l_subject := fnd_message.get;
204:
205: wf_engine.setitemattrtext
206: (
199: --
200: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
201: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
202: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
203: l_subject := fnd_message.get;
204:
205: wf_engine.setitemattrtext
206: (
207: itemtype => itemtype
406: OPEN get_uc_header_det(l_object_id);
407: FETCH get_uc_header_det into l_uc_header_rec;
408:
409: IF get_uc_header_det%NOTFOUND THEN
410: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
411: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
407: FETCH get_uc_header_det into l_uc_header_rec;
408:
409: IF get_uc_header_det%NOTFOUND THEN
410: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
411: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
411: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
416: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
417: fnd_message.set_token('APPR_NAME',l_approver, false);
418: l_body := fnd_message.get;
411: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
416: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
417: fnd_message.set_token('APPR_NAME',l_approver, false);
418: l_body := fnd_message.get;
419: END IF;
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
416: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
417: fnd_message.set_token('APPR_NAME',l_approver, false);
418: l_body := fnd_message.get;
419: END IF;
420: CLOSE get_uc_header_det;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
416: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
417: fnd_message.set_token('APPR_NAME',l_approver, false);
418: l_body := fnd_message.get;
419: END IF;
420: CLOSE get_uc_header_det;
421:
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
416: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
417: fnd_message.set_token('APPR_NAME',l_approver, false);
418: l_body := fnd_message.get;
419: END IF;
420: CLOSE get_uc_header_det;
421:
422: document := document || l_body;
541: FETCH get_uc_header_det into l_uc_header_rec;
542:
543: IF get_uc_header_det%NOTFOUND
544: THEN
545: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
546: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
542:
543: IF get_uc_header_det%NOTFOUND
544: THEN
545: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
546: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
545: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
546: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
551: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
552: fnd_message.set_token('APPR_NAME',l_approver, false);
553: l_body := fnd_message.get;
546: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
551: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
552: fnd_message.set_token('APPR_NAME',l_approver, false);
553: l_body := fnd_message.get;
554: END IF;
547: RAISE FND_API.G_EXC_ERROR;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
551: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
552: fnd_message.set_token('APPR_NAME',l_approver, false);
553: l_body := fnd_message.get;
554: END IF;
555: CLOSE get_uc_header_det;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
551: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
552: fnd_message.set_token('APPR_NAME',l_approver, false);
553: l_body := fnd_message.get;
554: END IF;
555: CLOSE get_uc_header_det;
556:
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
551: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
552: fnd_message.set_token('APPR_NAME',l_approver, false);
553: l_body := fnd_message.get;
554: END IF;
555: CLOSE get_uc_header_det;
556:
557: document := document || l_body;
672: OPEN get_uc_header_det(l_object_id);
673: FETCH get_uc_header_det into l_uc_header_rec;
674:
675: IF get_uc_header_det%NOTFOUND THEN
676: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
677: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
673: FETCH get_uc_header_det into l_uc_header_rec;
674:
675: IF get_uc_header_det%NOTFOUND THEN
676: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
677: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
676: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
677: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
682: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
683: l_body := fnd_message.get;
684: END IF;
677: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
682: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
683: l_body := fnd_message.get;
684: END IF;
685: CLOSE get_uc_header_det;
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
682: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
683: l_body := fnd_message.get;
684: END IF;
685: CLOSE get_uc_header_det;
686:
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
682: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
683: l_body := fnd_message.get;
684: END IF;
685: CLOSE get_uc_header_det;
686:
687: document := document || l_body;
803: OPEN get_uc_header_det(l_object_id);
804: FETCH get_uc_header_det into l_uc_header_rec;
805:
806: IF get_uc_header_det%NOTFOUND THEN
807: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
808: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
809: RAISE FND_API.G_EXC_ERROR;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
804: FETCH get_uc_header_det into l_uc_header_rec;
805:
806: IF get_uc_header_det%NOTFOUND THEN
807: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
808: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
809: RAISE FND_API.G_EXC_ERROR;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
807: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
808: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
809: RAISE FND_API.G_EXC_ERROR;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
813: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
814: fnd_message.set_token('APPR_NAME',l_approver, false);
815: l_body := fnd_message.get;
808: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
809: RAISE FND_API.G_EXC_ERROR;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
813: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
814: fnd_message.set_token('APPR_NAME',l_approver, false);
815: l_body := fnd_message.get;
816: END IF;
809: RAISE FND_API.G_EXC_ERROR;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
813: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
814: fnd_message.set_token('APPR_NAME',l_approver, false);
815: l_body := fnd_message.get;
816: END IF;
817: CLOSE get_uc_header_det;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
813: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
814: fnd_message.set_token('APPR_NAME',l_approver, false);
815: l_body := fnd_message.get;
816: END IF;
817: CLOSE get_uc_header_det;
818:
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
813: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
814: fnd_message.set_token('APPR_NAME',l_approver, false);
815: l_body := fnd_message.get;
816: END IF;
817: CLOSE get_uc_header_det;
818:
819: document := document || l_body;
944: OPEN get_uc_header_det(l_object_id);
945: FETCH get_uc_header_det into l_uc_header_rec;
946:
947: IF get_uc_header_det%NOTFOUND THEN
948: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
949: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
950: RAISE FND_API.G_EXC_ERROR;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
945: FETCH get_uc_header_det into l_uc_header_rec;
946:
947: IF get_uc_header_det%NOTFOUND THEN
948: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
949: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
950: RAISE FND_API.G_EXC_ERROR;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
948: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
949: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
950: RAISE FND_API.G_EXC_ERROR;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
956: fnd_message.set_token('NOTE',l_requester_note, false);
949: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
950: RAISE FND_API.G_EXC_ERROR;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
956: fnd_message.set_token('NOTE',l_requester_note, false);
957: l_body := fnd_message.get;
950: RAISE FND_API.G_EXC_ERROR;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
956: fnd_message.set_token('NOTE',l_requester_note, false);
957: l_body := fnd_message.get;
958: END IF;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
956: fnd_message.set_token('NOTE',l_requester_note, false);
957: l_body := fnd_message.get;
958: END IF;
959: CLOSE get_uc_header_det;
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
956: fnd_message.set_token('NOTE',l_requester_note, false);
957: l_body := fnd_message.get;
958: END IF;
959: CLOSE get_uc_header_det;
960:
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
956: fnd_message.set_token('NOTE',l_requester_note, false);
957: l_body := fnd_message.get;
958: END IF;
959: CLOSE get_uc_header_det;
960:
961: document := document || l_body;
1086: OPEN get_uc_header_det(l_object_id);
1087: FETCH get_uc_header_det into l_uc_header_rec;
1088:
1089: IF get_uc_header_det%NOTFOUND THEN
1090: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1091: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1087: FETCH get_uc_header_det into l_uc_header_rec;
1088:
1089: IF get_uc_header_det%NOTFOUND THEN
1090: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1091: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1090: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1091: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1098: fnd_message.set_token('NOTE',l_requester_note, false);
1091: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1098: fnd_message.set_token('NOTE',l_requester_note, false);
1099: l_body := fnd_message.get;
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1098: fnd_message.set_token('NOTE',l_requester_note, false);
1099: l_body := fnd_message.get;
1100: END IF;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1098: fnd_message.set_token('NOTE',l_requester_note, false);
1099: l_body := fnd_message.get;
1100: END IF;
1101: CLOSE get_uc_header_det;
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1098: fnd_message.set_token('NOTE',l_requester_note, false);
1099: l_body := fnd_message.get;
1100: END IF;
1101: CLOSE get_uc_header_det;
1102:
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1098: fnd_message.set_token('NOTE',l_requester_note, false);
1099: l_body := fnd_message.get;
1100: END IF;
1101: CLOSE get_uc_header_det;
1102:
1103: document := document || l_body;
1216: OPEN get_uc_header_det(l_object_id);
1217: FETCH get_uc_header_det into l_uc_header_rec;
1218:
1219: IF get_uc_header_det%NOTFOUND THEN
1220: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1221: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1222: RAISE FND_API.G_EXC_ERROR;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1217: FETCH get_uc_header_det into l_uc_header_rec;
1218:
1219: IF get_uc_header_det%NOTFOUND THEN
1220: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1221: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1222: RAISE FND_API.G_EXC_ERROR;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1220: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1221: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1222: RAISE FND_API.G_EXC_ERROR;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1226: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1227: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1228: l_body := fnd_message.get;
1221: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1222: RAISE FND_API.G_EXC_ERROR;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1226: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1227: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1228: l_body := fnd_message.get;
1229: END IF;
1222: RAISE FND_API.G_EXC_ERROR;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1226: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1227: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1228: l_body := fnd_message.get;
1229: END IF;
1230: CLOSE get_uc_header_det;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1226: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1227: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1228: l_body := fnd_message.get;
1229: END IF;
1230: CLOSE get_uc_header_det;
1231:
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1226: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1227: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1228: l_body := fnd_message.get;
1229: END IF;
1230: CLOSE get_uc_header_det;
1231:
1232: document := document || l_body;
1366: OPEN get_uc_header_det(l_object_id);
1367: FETCH get_uc_header_det into l_uc_header_rec;
1368:
1369: IF get_uc_header_det%NOTFOUND THEN
1370: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1371: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374: CLOSE get_uc_header_det;
1367: FETCH get_uc_header_det into l_uc_header_rec;
1368:
1369: IF get_uc_header_det%NOTFOUND THEN
1370: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1371: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374: CLOSE get_uc_header_det;
1375:
1377: OPEN check_uc_ovn(l_object_id, l_object_version_number);
1378: FETCH check_uc_ovn into l_check_uc_ovn;
1379:
1380: IF check_uc_ovn%NOTFOUND THEN
1381: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1382: IF G_DEBUG='Y' THEN
1383: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1384: END IF;
1385: RAISE FND_API.G_EXC_ERROR;
1379:
1380: IF check_uc_ovn%NOTFOUND THEN
1381: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1382: IF G_DEBUG='Y' THEN
1383: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1384: END IF;
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387: CLOSE check_uc_ovn;
1583: OPEN get_uc_header_det(l_object_id);
1584: FETCH get_uc_header_det into l_uc_header_rec;
1585:
1586: IF get_uc_header_det%NOTFOUND THEN
1587: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1588: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591: CLOSE get_uc_header_det;
1584: FETCH get_uc_header_det into l_uc_header_rec;
1585:
1586: IF get_uc_header_det%NOTFOUND THEN
1587: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1588: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591: CLOSE get_uc_header_det;
1592:
1594: OPEN check_uc_ovn(l_object_id, l_object_version_number);
1595: FETCH check_uc_ovn into l_check_uc_ovn;
1596:
1597: IF check_uc_ovn%NOTFOUND THEN
1598: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601:
1602: UPDATE ahl_unit_config_headers