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

Line 239: FND_MESSAGE.set_name('AHL', 'AHL_OSP_OPER_FLAG_NULL');

235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
236: END IF;
237:
238: IF p_x_Inv_serv_item_rec.operation_flag IS NULL THEN
239: FND_MESSAGE.set_name('AHL', 'AHL_OSP_OPER_FLAG_NULL');
240: FND_MSG_PUB.ADD;
241: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
243: END IF;

Line 253: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORG_NAME_NULL');

249: IF (p_x_Inv_serv_item_rec.inv_org_id IS NULL OR
250: p_x_Inv_serv_item_rec.inv_org_id = FND_API.G_MISS_NUM) AND
251: (p_x_Inv_serv_item_rec.inv_org_name IS NULL OR
252: p_x_Inv_serv_item_rec.inv_org_name = FND_API.G_MISS_CHAR) THEN
253: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORG_NAME_NULL');
254: FND_MSG_PUB.ADD;
255: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
257: END IF;

Line 264: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_ITEM_NULL');

260: IF (p_x_Inv_serv_item_rec.inv_item_id IS NULL OR
261: p_x_Inv_serv_item_rec.inv_item_id = FND_API.G_MISS_NUM) AND
262: (p_x_Inv_serv_item_rec.inv_item_name IS NULL OR
263: p_x_Inv_serv_item_rec.inv_item_name = FND_API.G_MISS_CHAR) THEN
264: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_ITEM_NULL');
265: FND_MSG_PUB.ADD;
266: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
267: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
268: END IF;

Line 275: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SER_ITEM_NULL');

271: IF (p_x_Inv_serv_item_rec.service_item_id IS NULL OR
272: p_x_Inv_serv_item_rec.service_item_id = FND_API.G_MISS_NUM) AND
273: (p_x_Inv_serv_item_rec.service_item_name IS NULL OR
274: p_x_Inv_serv_item_rec.service_item_name = FND_API.G_MISS_CHAR) THEN
275: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SER_ITEM_NULL');
276: FND_MSG_PUB.ADD;
277: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
279: END IF;

Line 290: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');

286: p_x_Inv_serv_item_rec.inv_item_name,'Y');
287: FETCH get_Item_info_csr INTO p_x_Inv_serv_item_rec.inv_item_id,
288: p_x_Inv_serv_item_rec.inv_org_id;
289: IF get_Item_info_csr%NOTFOUND THEN
290: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');
291: FND_MSG_PUB.ADD;
292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
294: END IF;

Line 305: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');

301: p_x_Inv_serv_item_rec.inv_item_id,'Y');
302: FETCH get_Item_info_id_csr INTO p_x_Inv_serv_item_rec.inv_item_id,
303: p_x_Inv_serv_item_rec.inv_org_id;
304: IF get_Item_info_id_csr%NOTFOUND THEN
305: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_INV_ITEM');
306: FND_MSG_PUB.ADD;
307: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
309: END IF;

Line 318: FND_MESSAGE.set_name('AHL', 'AHL_VENDOR_START_DATE_PAST');

314:
315: END IF;
316:
317: IF TRUNC(p_x_Inv_serv_item_rec.active_start_date) < TRUNC(SYSDATE) THEN
318: FND_MESSAGE.set_name('AHL', 'AHL_VENDOR_START_DATE_PAST');
319: FND_MSG_PUB.ADD;
320: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
322: END IF;

Line 333: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_SERV_ITEM');

329: p_x_Inv_serv_item_rec.service_item_name,'N');
330: FETCH get_Item_info_csr INTO p_x_Inv_serv_item_rec.service_item_id,
331: p_x_Inv_serv_item_rec.inv_org_id;
332: IF get_Item_info_csr%NOTFOUND THEN
333: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_SERV_ITEM');
334: FND_MSG_PUB.ADD;
335: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
337: END IF;

Line 348: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_SERV_ITEM');

344: p_x_Inv_serv_item_rec.service_item_id,'N');
345: FETCH get_Item_info_id_csr INTO p_x_Inv_serv_item_rec.service_item_id,
346: p_x_Inv_serv_item_rec.inv_org_id;
347: IF get_Item_info_id_csr%NOTFOUND THEN
348: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INVALID_SERV_ITEM');
349: FND_MSG_PUB.ADD;
350: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
351: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
352: END IF;

Line 366: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RELATION_EXISTS');

362: p_x_Inv_serv_item_rec.inv_item_id,
363: p_x_Inv_serv_item_rec.service_item_id);
364: FETCH Item_Ser_rel_exists_csr INTO l_dummy;
365: IF Item_Ser_rel_exists_csr%FOUND THEN
366: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RELATION_EXISTS');
367: FND_MSG_PUB.ADD;
368: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
370: END IF;

Line 385: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_NULL');

381: IF p_x_Inv_serv_item_rec.operation_flag <> 'D' THEN
382:
383: IF (p_x_Inv_serv_item_rec.rank IS NULL OR
384: p_x_Inv_serv_item_rec.rank = FND_API.G_MISS_NUM) THEN
385: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_NULL');
386: FND_MSG_PUB.ADD;
387: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
389: END IF;

Line 393: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_INVALID_NUM');

389: END IF;
390: RAISE Fnd_Api.g_exc_error;
391: ELSIF ( p_x_Inv_serv_item_rec.rank < 1 OR
392: FLOOR(p_x_Inv_serv_item_rec.rank) <> p_x_Inv_serv_item_rec.rank) THEN
393: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_INVALID_NUM');
394: FND_MSG_PUB.ADD;
395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
397: END IF;

Line 404: FND_MESSAGE.set_name('AHL', 'AHL_OSP_START_DATE_NULL');

400:
401:
402: IF (p_x_Inv_serv_item_rec.active_start_date IS NULL OR
403: p_x_Inv_serv_item_rec.active_start_date = FND_API.G_MISS_DATE) THEN
404: FND_MESSAGE.set_name('AHL', 'AHL_OSP_START_DATE_NULL');
405: FND_MSG_PUB.ADD;
406: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
407: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
408: END IF;

Line 411: FND_MESSAGE.set_name('AHL', 'AHL_OSP_START_DATE_GT');

407: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
408: END IF;
409: ELSIF p_x_Inv_serv_item_rec.active_start_date > NVL(p_x_Inv_serv_item_rec.active_end_date,
410: p_x_Inv_serv_item_rec.active_start_date) THEN
411: FND_MESSAGE.set_name('AHL', 'AHL_OSP_START_DATE_GT');
412: FND_MSG_PUB.ADD;
413: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
415: END IF;

Line 432: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_DUP');

428: p_x_Inv_serv_item_rec.inv_ser_item_rel_id);
429: END IF;
430: FETCH Item_rank_exists_csr INTO l_dummy;
431: IF Item_rank_exists_csr%FOUND THEN
432: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_DUP');
433: FND_MSG_PUB.ADD;
434: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
436: END IF;

Line 449: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REL_ID_NULL');

445:
446: IF p_x_Inv_serv_item_rec.operation_flag IN ('D','U') THEN
447:
448: IF p_x_Inv_serv_item_rec.inv_ser_item_rel_id IS NULL THEN
449: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REL_ID_NULL');
450: FND_MSG_PUB.ADD;
451: RAISE Fnd_Api.g_exc_error;
452: END IF;
453:

Line 457: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REL_NOTFOUND');

453:
454: OPEN Item_Ser_rel_det_csr(p_x_Inv_serv_item_rec.inv_ser_item_rel_id);
455: FETCH Item_Ser_rel_det_csr INTO l_Item_Ser_rel_det;
456: IF Item_Ser_rel_det_csr%NOTFOUND THEN
457: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REL_NOTFOUND');
458: FND_MSG_PUB.ADD;
459: CLOSE Item_Ser_rel_det_csr;
460: RAISE Fnd_Api.g_exc_error;
461: END IF;

Line 465: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');

461: END IF;
462: CLOSE Item_Ser_rel_det_csr;
463:
464: IF NVL(l_Item_Ser_rel_det.object_version_number,-9) <> p_x_Inv_serv_item_rec.obj_ver_num THEN
465: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');
466: FND_MSG_PUB.ADD;
467: RAISE Fnd_Api.g_exc_error;
468: END IF;
469:

Line 509: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_RANK_EXISTS');

505: OPEN org_item_rank_exists_csr(p_x_Inv_serv_item_rec.inv_item_id, p_x_Inv_serv_item_rec.service_item_id, p_x_Inv_serv_item_rec.rank);
506: LOOP
507: FETCH org_item_rank_exists_csr INTO l_org_item_rank_exists_csr;
508: EXIT WHEN org_item_rank_exists_csr%NOTFOUND;
509: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_RANK_EXISTS');
510: FND_MESSAGE.set_token('INV_ORG_NAME', l_org_item_rank_exists_csr.inv_org_name);
511: FND_MESSAGE.set_token('INV_ITEM_NUMBER', l_org_item_rank_exists_csr.inv_item_number);
512: FND_MESSAGE.set_token('SVC_ITEM_NUMBER', l_org_item_rank_exists_csr.service_item_number);
513: FND_MESSAGE.set_token('RANK', l_org_item_rank_exists_csr.rank);

Line 510: FND_MESSAGE.set_token('INV_ORG_NAME', l_org_item_rank_exists_csr.inv_org_name);

506: LOOP
507: FETCH org_item_rank_exists_csr INTO l_org_item_rank_exists_csr;
508: EXIT WHEN org_item_rank_exists_csr%NOTFOUND;
509: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_RANK_EXISTS');
510: FND_MESSAGE.set_token('INV_ORG_NAME', l_org_item_rank_exists_csr.inv_org_name);
511: FND_MESSAGE.set_token('INV_ITEM_NUMBER', l_org_item_rank_exists_csr.inv_item_number);
512: FND_MESSAGE.set_token('SVC_ITEM_NUMBER', l_org_item_rank_exists_csr.service_item_number);
513: FND_MESSAGE.set_token('RANK', l_org_item_rank_exists_csr.rank);
514: FND_MSG_PUB.ADD;

Line 511: FND_MESSAGE.set_token('INV_ITEM_NUMBER', l_org_item_rank_exists_csr.inv_item_number);

507: FETCH org_item_rank_exists_csr INTO l_org_item_rank_exists_csr;
508: EXIT WHEN org_item_rank_exists_csr%NOTFOUND;
509: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_RANK_EXISTS');
510: FND_MESSAGE.set_token('INV_ORG_NAME', l_org_item_rank_exists_csr.inv_org_name);
511: FND_MESSAGE.set_token('INV_ITEM_NUMBER', l_org_item_rank_exists_csr.inv_item_number);
512: FND_MESSAGE.set_token('SVC_ITEM_NUMBER', l_org_item_rank_exists_csr.service_item_number);
513: FND_MESSAGE.set_token('RANK', l_org_item_rank_exists_csr.rank);
514: FND_MSG_PUB.ADD;
515: l_count := l_count + 1;

Line 512: FND_MESSAGE.set_token('SVC_ITEM_NUMBER', l_org_item_rank_exists_csr.service_item_number);

508: EXIT WHEN org_item_rank_exists_csr%NOTFOUND;
509: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_RANK_EXISTS');
510: FND_MESSAGE.set_token('INV_ORG_NAME', l_org_item_rank_exists_csr.inv_org_name);
511: FND_MESSAGE.set_token('INV_ITEM_NUMBER', l_org_item_rank_exists_csr.inv_item_number);
512: FND_MESSAGE.set_token('SVC_ITEM_NUMBER', l_org_item_rank_exists_csr.service_item_number);
513: FND_MESSAGE.set_token('RANK', l_org_item_rank_exists_csr.rank);
514: FND_MSG_PUB.ADD;
515: l_count := l_count + 1;
516: END LOOP;

Line 513: FND_MESSAGE.set_token('RANK', l_org_item_rank_exists_csr.rank);

509: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_RANK_EXISTS');
510: FND_MESSAGE.set_token('INV_ORG_NAME', l_org_item_rank_exists_csr.inv_org_name);
511: FND_MESSAGE.set_token('INV_ITEM_NUMBER', l_org_item_rank_exists_csr.inv_item_number);
512: FND_MESSAGE.set_token('SVC_ITEM_NUMBER', l_org_item_rank_exists_csr.service_item_number);
513: FND_MESSAGE.set_token('RANK', l_org_item_rank_exists_csr.rank);
514: FND_MSG_PUB.ADD;
515: l_count := l_count + 1;
516: END LOOP;
517: CLOSE org_item_rank_exists_csr;

Line 690: FND_MESSAGE.set_name('AHL', 'AHL_VENDOR_CER_END_DATE_PAST');

686: IF TRUNC(p_x_Inv_serv_item_rec.active_end_date) < TRUNC(SYSDATE) THEN
687: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
688: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY, 'End Date is in Past');
689: END IF;
690: FND_MESSAGE.set_name('AHL', 'AHL_VENDOR_CER_END_DATE_PAST');
691: FND_MSG_PUB.ADD;
692: RAISE Fnd_Api.g_exc_error;
693: END IF;
694: -- mpothuku End

Line 705: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');

701: WHERE inv_service_item_rel_id = p_x_Inv_serv_item_rec.inv_ser_item_rel_id
702: AND object_version_number = l_Item_Ser_rel_det.object_version_number;
703:
704: IF SQL%ROWCOUNT = 0 THEN
705: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');
706: FND_MSG_PUB.ADD;
707: RAISE Fnd_Api.g_exc_error;
708: END IF;
709:

Line 718: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');

714: WHERE inv_service_item_rel_id = p_x_Inv_serv_item_rec.inv_ser_item_rel_id
715: AND object_version_number = l_Item_Ser_rel_det.object_version_number;
716:
717: IF SQL%ROWCOUNT = 0 THEN
718: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');
719: FND_MSG_PUB.ADD;
720: RAISE Fnd_Api.g_exc_error;
721: END IF;
722: