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_WF_APPR_PVT dependencies on FND_MESSAGE

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

88:
89: OPEN get_uc_header_det(l_object_id);
90: FETCH get_uc_header_det into l_uc_header_rec;
91: IF get_uc_header_det%NOTFOUND THEN
92: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
93: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: CLOSE get_uc_header_det;

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

89: OPEN get_uc_header_det(l_object_id);
90: FETCH get_uc_header_det into l_uc_header_rec;
91: IF get_uc_header_det%NOTFOUND THEN
92: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
93: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: CLOSE get_uc_header_det;
97:

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

101: ELSE
102: l_object := 'UC';
103: END IF;
104:
105: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
106: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
107: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
108: l_subject := fnd_message.get;
109:

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

102: l_object := 'UC';
103: END IF;
104:
105: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
106: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
107: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
108: l_subject := fnd_message.get;
109:
110: wf_engine.setitemattrtext

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

103: END IF;
104:
105: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
106: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
107: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
108: l_subject := fnd_message.get;
109:
110: wf_engine.setitemattrtext
111: (

Line 108: l_subject := fnd_message.get;

104:
105: fnd_message.set_name('AHL', 'AHL_UC_NTF_FORWARD_SUBJECT');
106: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
107: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
108: l_subject := fnd_message.get;
109:
110: wf_engine.setitemattrtext
111: (
112: itemtype => itemtype

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

114: ,aname => 'FORWARD_SUBJECT'
115: ,avalue => l_subject
116: );
117:
118: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
119: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
120: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
121: l_subject := fnd_message.get;
122:

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

115: ,avalue => l_subject
116: );
117:
118: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
119: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
120: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
121: l_subject := fnd_message.get;
122:
123: wf_engine.setitemattrtext

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

116: );
117:
118: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
119: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
120: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
121: l_subject := fnd_message.get;
122:
123: wf_engine.setitemattrtext
124: (

Line 121: l_subject := fnd_message.get;

117:
118: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL_SUBJECT');
119: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
120: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
121: l_subject := fnd_message.get;
122:
123: wf_engine.setitemattrtext
124: (
125: itemtype => itemtype

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

130: IF G_DEBUG='Y' THEN
131: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
132: END IF;
133:
134: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
135: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
136: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
137: l_subject := fnd_message.get;
138:

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

131: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
132: END IF;
133:
134: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
135: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
136: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
137: l_subject := fnd_message.get;
138:
139: wf_engine.setitemattrtext

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

132: END IF;
133:
134: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
135: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
136: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
137: l_subject := fnd_message.get;
138:
139: wf_engine.setitemattrtext
140: (

Line 137: l_subject := fnd_message.get;

133:
134: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
135: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
136: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
137: l_subject := fnd_message.get;
138:
139: wf_engine.setitemattrtext
140: (
141: itemtype => itemtype

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

146: IF G_DEBUG='Y' THEN
147: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
148: END IF;
149:
150: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
151: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
152: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
153: l_subject := fnd_message.get;
154:

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

147: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
148: END IF;
149:
150: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
151: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
152: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
153: l_subject := fnd_message.get;
154:
155: wf_engine.setitemattrtext

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

148: END IF;
149:
150: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
151: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
152: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
153: l_subject := fnd_message.get;
154:
155: wf_engine.setitemattrtext
156: (

Line 153: l_subject := fnd_message.get;

149:
150: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
151: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
152: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
153: l_subject := fnd_message.get;
154:
155: wf_engine.setitemattrtext
156: (
157: itemtype => itemtype

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

162: IF G_DEBUG='Y' THEN
163: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
164: END IF;
165:
166: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
167: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
168: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
169: l_subject := fnd_message.get;
170:

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

163: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
164: END IF;
165:
166: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
167: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
168: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
169: l_subject := fnd_message.get;
170:
171: wf_engine.setitemattrtext

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

164: END IF;
165:
166: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
167: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
168: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
169: l_subject := fnd_message.get;
170:
171: wf_engine.setitemattrtext
172: (

Line 169: l_subject := fnd_message.get;

165:
166: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
167: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
168: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
169: l_subject := fnd_message.get;
170:
171: wf_engine.setitemattrtext
172: (
173: itemtype => itemtype

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

178: IF G_DEBUG='Y' THEN
179: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
180: END IF;
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: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
180: END IF;
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: END IF;
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 198: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');

194: IF G_DEBUG='Y' THEN
195: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
196: END IF;
197:
198: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
199: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
200: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
201: l_subject := fnd_message.get;
202:

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

195: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
196: END IF;
197:
198: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
199: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
200: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
201: l_subject := fnd_message.get;
202:
203: wf_engine.setitemattrtext

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

196: END IF;
197:
198: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
199: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
200: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
201: l_subject := fnd_message.get;
202:
203: wf_engine.setitemattrtext
204: (

Line 201: l_subject := fnd_message.get;

197:
198: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
199: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
200: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
201: l_subject := fnd_message.get;
202:
203: wf_engine.setitemattrtext
204: (
205: itemtype => itemtype

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

400: FETCH get_uc_header_det into l_uc_header_rec;
401:
402: IF get_uc_header_det%NOTFOUND
403: THEN
404: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
405: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');

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

401:
402: IF get_uc_header_det%NOTFOUND
403: THEN
404: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
405: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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

404: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
405: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
411: fnd_message.set_token('APPR_NAME',l_approver, false);
412: l_body := fnd_message.get;

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

405: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
411: fnd_message.set_token('APPR_NAME',l_approver, false);
412: l_body := fnd_message.get;
413: END IF;

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

406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
411: fnd_message.set_token('APPR_NAME',l_approver, false);
412: l_body := fnd_message.get;
413: END IF;
414: CLOSE get_uc_header_det;

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

407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
411: fnd_message.set_token('APPR_NAME',l_approver, false);
412: l_body := fnd_message.get;
413: END IF;
414: CLOSE get_uc_header_det;
415:

Line 412: l_body := fnd_message.get;

408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
411: fnd_message.set_token('APPR_NAME',l_approver, false);
412: l_body := fnd_message.get;
413: END IF;
414: CLOSE get_uc_header_det;
415:
416: document := document || l_body;

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

536: FETCH get_uc_header_det into l_uc_header_rec;
537:
538: IF get_uc_header_det%NOTFOUND
539: THEN
540: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
541: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');

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

537:
538: IF get_uc_header_det%NOTFOUND
539: THEN
540: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
541: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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

540: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
541: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
546: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
547: fnd_message.set_token('APPR_NAME',l_approver, false);
548: l_body := fnd_message.get;

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

541: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
546: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
547: fnd_message.set_token('APPR_NAME',l_approver, false);
548: l_body := fnd_message.get;
549: END IF;

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

542: RAISE FND_API.G_EXC_ERROR;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
546: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
547: fnd_message.set_token('APPR_NAME',l_approver, false);
548: l_body := fnd_message.get;
549: END IF;
550: CLOSE get_uc_header_det;

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

543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
546: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
547: fnd_message.set_token('APPR_NAME',l_approver, false);
548: l_body := fnd_message.get;
549: END IF;
550: CLOSE get_uc_header_det;
551:

Line 548: l_body := fnd_message.get;

544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
546: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
547: fnd_message.set_token('APPR_NAME',l_approver, false);
548: l_body := fnd_message.get;
549: END IF;
550: CLOSE get_uc_header_det;
551:
552: document := document || l_body;

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

669: FETCH get_uc_header_det into l_uc_header_rec;
670:
671: IF get_uc_header_det%NOTFOUND
672: THEN
673: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
674: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');

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

670:
671: IF get_uc_header_det%NOTFOUND
672: THEN
673: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
674: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
678: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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

673: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
674: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
678: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
679: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
680: l_body := fnd_message.get;
681: END IF;

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

674: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
678: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
679: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
680: l_body := fnd_message.get;
681: END IF;
682: CLOSE get_uc_header_det;

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

675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
678: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
679: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
680: l_body := fnd_message.get;
681: END IF;
682: CLOSE get_uc_header_det;
683:

Line 680: l_body := fnd_message.get;

676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
678: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
679: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
680: l_body := fnd_message.get;
681: END IF;
682: CLOSE get_uc_header_det;
683:
684: document := document || l_body;

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

802: OPEN get_uc_header_det(l_object_id);
803: FETCH get_uc_header_det into l_uc_header_rec;
804:
805: IF get_uc_header_det%NOTFOUND THEN
806: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
807: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');

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

803: FETCH get_uc_header_det into l_uc_header_rec;
804:
805: IF get_uc_header_det%NOTFOUND THEN
806: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
807: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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

806: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
807: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
812: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
813: fnd_message.set_token('APPR_NAME',l_approver, false);
814: l_body := fnd_message.get;

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

807: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
812: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
813: fnd_message.set_token('APPR_NAME',l_approver, false);
814: l_body := fnd_message.get;
815: END IF;

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

808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
812: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
813: fnd_message.set_token('APPR_NAME',l_approver, false);
814: l_body := fnd_message.get;
815: END IF;
816: CLOSE get_uc_header_det;

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

809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
812: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
813: fnd_message.set_token('APPR_NAME',l_approver, false);
814: l_body := fnd_message.get;
815: END IF;
816: CLOSE get_uc_header_det;
817:

Line 814: l_body := fnd_message.get;

810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
812: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
813: fnd_message.set_token('APPR_NAME',l_approver, false);
814: l_body := fnd_message.get;
815: END IF;
816: CLOSE get_uc_header_det;
817:
818: document := document || l_body;

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

943: FETCH get_uc_header_det into l_uc_header_rec;
944:
945: IF get_uc_header_det%NOTFOUND
946: THEN
947: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
948: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
949: RAISE FND_API.G_EXC_ERROR;
950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');

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

944:
945: IF get_uc_header_det%NOTFOUND
946: THEN
947: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
948: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
949: RAISE FND_API.G_EXC_ERROR;
950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);

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

947: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
948: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
949: RAISE FND_API.G_EXC_ERROR;
950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
954: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
955: fnd_message.set_token('NOTE',l_requester_note, false);

Line 952: fnd_message.set_token('REQUESTER',l_requester, false);

948: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
949: RAISE FND_API.G_EXC_ERROR;
950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
954: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
955: fnd_message.set_token('NOTE',l_requester_note, false);
956: l_body := fnd_message.get;

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

949: RAISE FND_API.G_EXC_ERROR;
950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
954: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
955: fnd_message.set_token('NOTE',l_requester_note, false);
956: l_body := fnd_message.get;
957: END IF;

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

950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
954: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
955: fnd_message.set_token('NOTE',l_requester_note, false);
956: l_body := fnd_message.get;
957: END IF;
958: CLOSE get_uc_header_det;

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

951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
954: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
955: fnd_message.set_token('NOTE',l_requester_note, false);
956: l_body := fnd_message.get;
957: END IF;
958: CLOSE get_uc_header_det;
959:

Line 956: l_body := fnd_message.get;

952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
954: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
955: fnd_message.set_token('NOTE',l_requester_note, false);
956: l_body := fnd_message.get;
957: END IF;
958: CLOSE get_uc_header_det;
959:
960: document := document || l_body;

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

1085: FETCH get_uc_header_det into l_uc_header_rec;
1086:
1087: IF get_uc_header_det%NOTFOUND
1088: THEN
1089: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1090: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');

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

1086:
1087: IF get_uc_header_det%NOTFOUND
1088: THEN
1089: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1090: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);

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

1089: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1090: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1096: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1097: fnd_message.set_token('NOTE',l_requester_note, false);

Line 1094: fnd_message.set_token('REQUESTER',l_requester, false);

1090: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1096: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1097: fnd_message.set_token('NOTE',l_requester_note, false);
1098: l_body := fnd_message.get;

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

1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1096: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1097: fnd_message.set_token('NOTE',l_requester_note, false);
1098: l_body := fnd_message.get;
1099: END IF;

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

1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1096: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1097: fnd_message.set_token('NOTE',l_requester_note, false);
1098: l_body := fnd_message.get;
1099: END IF;
1100: CLOSE get_uc_header_det;

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

1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1096: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1097: fnd_message.set_token('NOTE',l_requester_note, false);
1098: l_body := fnd_message.get;
1099: END IF;
1100: CLOSE get_uc_header_det;
1101:

Line 1098: l_body := fnd_message.get;

1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1096: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1097: fnd_message.set_token('NOTE',l_requester_note, false);
1098: l_body := fnd_message.get;
1099: END IF;
1100: CLOSE get_uc_header_det;
1101:
1102: document := document || l_body;

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

1217: FETCH get_uc_header_det into l_uc_header_rec;
1218:
1219: IF get_uc_header_det%NOTFOUND
1220: THEN
1221: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1222: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');

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

1218:
1219: IF get_uc_header_det%NOTFOUND
1220: THEN
1221: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1222: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

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

1221: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1222: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1227: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1228: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1229: l_body := fnd_message.get;

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

1222: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1227: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1228: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1229: l_body := fnd_message.get;
1230: END IF;

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

1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1227: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1228: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1229: l_body := fnd_message.get;
1230: END IF;
1231: CLOSE get_uc_header_det;

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

1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1227: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1228: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1229: l_body := fnd_message.get;
1230: END IF;
1231: CLOSE get_uc_header_det;
1232:

Line 1229: l_body := fnd_message.get;

1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1227: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
1228: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1229: l_body := fnd_message.get;
1230: END IF;
1231: CLOSE get_uc_header_det;
1232:
1233: document := document || l_body;

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

1378: FETCH get_uc_header_det into l_uc_header_rec;
1379:
1380: IF get_uc_header_det%NOTFOUND
1381: THEN
1382: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1383: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: CLOSE get_uc_header_det;

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

1379:
1380: IF get_uc_header_det%NOTFOUND
1381: THEN
1382: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1383: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: CLOSE get_uc_header_det;
1387:

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

1390: FETCH check_uc_ovn into l_check_uc_ovn;
1391:
1392: IF check_uc_ovn%NOTFOUND THEN
1393:
1394: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1395:
1396: IF G_DEBUG='Y' THEN
1397: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1398: END IF;

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

1393:
1394: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1395:
1396: IF G_DEBUG='Y' THEN
1397: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1398: END IF;
1399:
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;

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

1597: FETCH get_uc_header_det into l_uc_header_rec;
1598:
1599: IF get_uc_header_det%NOTFOUND
1600: THEN
1601: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1602: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605: CLOSE get_uc_header_det;

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

1598:
1599: IF get_uc_header_det%NOTFOUND
1600: THEN
1601: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1602: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605: CLOSE get_uc_header_det;
1606:

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

1609: FETCH check_uc_ovn into l_check_uc_ovn;
1610:
1611: IF check_uc_ovn%NOTFOUND
1612: THEN
1613: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1614: RAISE FND_API.G_EXC_ERROR;
1615: END IF;
1616:
1617: