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

APPS.AHL_UC_ACL_WF_APPR_PVT dependencies on FND_MESSAGE

Line 82: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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;

Line 83: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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:

Line 89: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');

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:

Line 90: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

Line 91: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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: (

Line 92: l_subject := fnd_message.get;

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

Line 108: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');

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:

Line 109: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

Line 110: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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: (

Line 111: l_subject := fnd_message.get;

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

Line 127: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');

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:

Line 128: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

Line 129: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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: (

Line 130: l_subject := fnd_message.get;

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

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

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:

Line 147: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

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

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: (

Line 149: l_subject := fnd_message.get;

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

Line 164: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');

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:

Line 165: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

Line 166: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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: (

Line 167: l_subject := fnd_message.get;

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

Line 182: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND_SUBJECT');

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:

Line 183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

Line 184: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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: (

Line 185: l_subject := fnd_message.get;

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

Line 200: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');

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:

Line 201: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

Line 202: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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: (

Line 203: l_subject := fnd_message.get;

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

Line 410: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 411: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');

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;

Line 415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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;

Line 416: fnd_message.set_token('NAME',l_uc_header_rec.name, 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;
420: CLOSE get_uc_header_det;

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

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:

Line 418: l_body := fnd_message.get;

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;

Line 545: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 546: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');

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;

Line 550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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;

Line 551: fnd_message.set_token('NAME',l_uc_header_rec.name, 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;
555: CLOSE get_uc_header_det;

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

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:

Line 553: l_body := fnd_message.get;

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;

Line 676: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 677: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');

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;

Line 681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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;

Line 682: fnd_message.set_token('NAME',l_uc_header_rec.name, 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;
686:

Line 683: l_body := fnd_message.get;

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;

Line 807: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 808: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');

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;

Line 812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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;

Line 813: fnd_message.set_token('NAME',l_uc_header_rec.name, 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;
817: CLOSE get_uc_header_det;

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

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:

Line 815: l_body := fnd_message.get;

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;

Line 948: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 949: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');

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);

Line 953: fnd_message.set_token('REQUESTER',l_requester, 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;

Line 954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_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;
958: END IF;

Line 955: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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;

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

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:

Line 957: l_body := fnd_message.get;

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;

Line 1090: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 1091: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');

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);

Line 1095: fnd_message.set_token('REQUESTER',l_requester, 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;

Line 1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_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;
1100: END IF;

Line 1097: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

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;

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

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:

Line 1099: l_body := fnd_message.get;

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;

Line 1220: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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

Line 1221: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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);

Line 1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');

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;

Line 1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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;

Line 1226: fnd_message.set_token('NAME',l_uc_header_rec.name, 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;
1230: CLOSE get_uc_header_det;

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

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:

Line 1228: l_body := fnd_message.get;

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;

Line 1370: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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;

Line 1371: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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:

Line 1381: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

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;

Line 1383: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );

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;

Line 1587: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

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;

Line 1588: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);

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:

Line 1598: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

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