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_REPAIR_CATEGORIES_PVT dependencies on FND_MSG_PUB

Line 114: FND_MSG_PUB.initialize;

110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_boolean(p_init_msg_list)
113: THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Initialize API return status to success
118: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 131: FND_MSG_PUB.ADD;

127: THEN
128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML');
129: FND_MESSAGE.SET_TOKEN('FIELD', p_x_repair_category_tbl(i).dml_operation);
130: FND_MESSAGE.SET_TOKEN('RECORD', p_x_repair_category_tbl(i).incident_urgency_name||' - '||p_x_repair_category_tbl(i).repair_time);
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF (p_x_repair_category_tbl(i).DML_OPERATION = 'D')

Line 159: FND_MSG_PUB.ADD;

155: repcat.repair_category_id = p_x_repair_category_tbl(i).repair_category_id;
156:
157: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_ATASEQ_DEL');
158: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
159: FND_MSG_PUB.ADD;
160: END IF;
161: CLOSE check_repcat_assoc;
162:
163: -- Check error message stack

Line 164: x_msg_count := FND_MSG_PUB.count_msg;

160: END IF;
161: CLOSE check_repcat_assoc;
162:
163: -- Check error message stack
164: x_msg_count := FND_MSG_PUB.count_msg;
165: IF x_msg_count > 0
166: THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;

Line 193: FND_MSG_PUB.ADD;

189: IF (get_srurg_id_from_name%NOTFOUND)
190: THEN
191: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_INV');
192: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
193: FND_MSG_PUB.ADD;
194: END IF;
195: CLOSE get_srurg_id_from_name;
196: ELSIF (p_x_repair_category_tbl(i).incident_urgency_id IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_id <> FND_API.G_MISS_NUM)
197: THEN

Line 204: FND_MSG_PUB.ADD;

200: IF (check_srurg_exists%NOTFOUND)
201: THEN
202: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_INV');
203: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_id);
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: CLOSE check_srurg_exists;
208: ELSE

Line 210: FND_MSG_PUB.ADD;

206: END IF;
207: CLOSE check_srurg_exists;
208: ELSE
209: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_MAND');
210: FND_MSG_PUB.ADD;
211: END IF;
212:
213: -- Trim the urgency name passed in
214: p_x_repair_category_tbl(i).incident_urgency_name := LTRIM(RTRIM(p_x_repair_category_tbl(i).incident_urgency_name));

Line 223: FND_MSG_PUB.ADD;

219: IF (check_srurg_chg_for_upd%NOTFOUND)
220: THEN
221: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_SRURG_UPD_NOCHG');
222: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
223: FND_MSG_PUB.ADD;
224: END IF;
225: CLOSE check_srurg_chg_for_upd;
226:
227: -- Validate repair time is valid

Line 232: FND_MSG_PUB.ADD;

228: IF (p_x_repair_category_tbl(i).repair_time <= 0 )
229: THEN
230: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_TIME_INV');
231: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
232: FND_MSG_PUB.ADD;
233: END IF;
234:
235: -- Validate repair time already does not exist for another record
236: OPEN check_reptime_exists(p_x_repair_category_tbl(i).repair_time, p_x_repair_category_tbl(i).repair_category_id);

Line 242: FND_MSG_PUB.ADD;

238: IF (check_reptime_exists%FOUND)
239: THEN
240: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_SRURG_TIME_EXISTS');
241: FND_MESSAGE.SET_TOKEN('TIME', p_x_repair_category_tbl(i).repair_time);
242: FND_MSG_PUB.ADD;
243: END IF;
244: CLOSE check_reptime_exists;
245:
246: -- Check error message stack

Line 247: x_msg_count := FND_MSG_PUB.count_msg;

243: END IF;
244: CLOSE check_reptime_exists;
245:
246: -- Check error message stack
247: x_msg_count := FND_MSG_PUB.count_msg;
248: IF x_msg_count > 0
249: THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;

Line 308: FND_MSG_PUB.ADD;

304: IF (get_srurg_id_from_name%NOTFOUND)
305: THEN
306: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_INV');
307: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
308: FND_MSG_PUB.ADD;
309: END IF;
310: CLOSE get_srurg_id_from_name;
311: ELSIF (p_x_repair_category_tbl(i).incident_urgency_id IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_id <> FND_API.G_MISS_NUM)
312: THEN

Line 319: FND_MSG_PUB.ADD;

315: IF (check_srurg_exists%NOTFOUND)
316: THEN
317: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_INV');
318: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_id);
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322: CLOSE check_srurg_exists;
323: ELSE

Line 325: FND_MSG_PUB.ADD;

321: END IF;
322: CLOSE check_srurg_exists;
323: ELSE
324: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_MAND');
325: FND_MSG_PUB.ADD;
326: END IF;
327:
328: -- Trim the urgency name passed in
329: p_x_repair_category_tbl(i).incident_urgency_name := LTRIM(RTRIM(p_x_repair_category_tbl(i).incident_urgency_name));

Line 338: FND_MSG_PUB.ADD;

334: IF (check_repcat_exists%FOUND)
335: THEN
336: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_SRURG_EXISTS');
337: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
338: FND_MSG_PUB.ADD;
339: END IF;
340: CLOSE check_repcat_exists;
341:
342: -- Validate repair time is valid

Line 347: FND_MSG_PUB.ADD;

343: IF (p_x_repair_category_tbl(i).repair_time <= 0 )
344: THEN
345: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_TIME_INV');
346: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
347: FND_MSG_PUB.ADD;
348: END IF;
349:
350: -- Validate repair time already does not exist for another record
351: OPEN check_reptime_exists(p_x_repair_category_tbl(i).repair_time, null);

Line 357: FND_MSG_PUB.ADD;

353: IF (check_reptime_exists%FOUND)
354: THEN
355: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_SRURG_TIME_EXISTS');
356: FND_MESSAGE.SET_TOKEN('TIME', p_x_repair_category_tbl(i).repair_time);
357: FND_MSG_PUB.ADD;
358: END IF;
359: CLOSE check_reptime_exists;
360:
361: -- Check error message stack

Line 362: x_msg_count := FND_MSG_PUB.count_msg;

358: END IF;
359: CLOSE check_reptime_exists;
360:
361: -- Check error message stack
362: x_msg_count := FND_MSG_PUB.count_msg;
363: IF x_msg_count > 0
364: THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;

Line 446: x_msg_count := FND_MSG_PUB.count_msg;

442: END LOOP;
443: END IF;
444:
445: -- Check error message stack at completing proc
446: x_msg_count := FND_MSG_PUB.count_msg;
447: IF x_msg_count > 0
448: THEN
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;

Line 459: FND_MSG_PUB.count_and_get

455: COMMIT WORK;
456: END IF;
457:
458: -- Standard call to get message count and if count is 1, get message info
459: FND_MSG_PUB.count_and_get
460: (
461: p_count => x_msg_count,
462: p_data => x_msg_data,
463: p_encoded => FND_API.G_FALSE

Line 470: FND_MSG_PUB.count_and_get

466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: Rollback to process_repair_categories_sp;
470: FND_MSG_PUB.count_and_get
471: (
472: p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE

Line 480: FND_MSG_PUB.count_and_get

476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: Rollback to process_repair_categories_sp;
480: FND_MSG_PUB.count_and_get
481: (
482: p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => FND_API.G_FALSE

Line 490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

486:
487: WHEN OTHERS THEN
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: Rollback to process_repair_categories_sp;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.add_exc_msg
493: (
494: p_pkg_name => G_PKG_NAME,

Line 492: FND_MSG_PUB.add_exc_msg

488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: Rollback to process_repair_categories_sp;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.add_exc_msg
493: (
494: p_pkg_name => G_PKG_NAME,
495: p_procedure_name => l_api_name,
496: p_error_text => SUBSTR(SQLERRM,1,240)

Line 499: FND_MSG_PUB.count_and_get

495: p_procedure_name => l_api_name,
496: p_error_text => SUBSTR(SQLERRM,1,240)
497: );
498: END IF;
499: FND_MSG_PUB.count_and_get
500: (
501: p_count => x_msg_count,
502: p_data => x_msg_data,
503: p_encoded => FND_API.G_FALSE

Line 535: FND_MSG_PUB.ADD;

531: IF (check_rep_cat_exists%NOTFOUND)
532: THEN
533: CLOSE check_rep_cat_exists;
534: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_NOTFOUND');
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_ERROR;
537: ELSIF (p_object_ver_num <> l_dummy_number)
538: THEN
539: CLOSE check_rep_cat_exists;

Line 541: FND_MSG_PUB.ADD;

537: ELSIF (p_object_ver_num <> l_dummy_number)
538: THEN
539: CLOSE check_rep_cat_exists;
540: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544: CLOSE check_rep_cat_exists;
545: