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.IEU_UWQ_MEDIA_TYPES_PVT dependencies on FND_MSG_PUB

Line 254: fnd_msg_pub.delete_msg();

250:
251:
252: BEGIN
253:
254: fnd_msg_pub.delete_msg();
255: x_return_status := fnd_api.g_ret_sts_success;
256: FND_MSG_PUB.initialize;
257:
258: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 256: FND_MSG_PUB.initialize;

252: BEGIN
253:
254: fnd_msg_pub.delete_msg();
255: x_return_status := fnd_api.g_ret_sts_success;
256: FND_MSG_PUB.initialize;
257:
258: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
259:
260: valid_name := true;

Line 271: FND_MSG_PUB.Add;

267:
268: if rec_obj.media_type_name IS NULL then
269:
270: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_NAME_NULL');
271: FND_MSG_PUB.Add;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: else
274: temp_media_name := LTRIM(RTRIM(rec_obj.media_type_name));
275:

Line 293: FND_MSG_PUB.Add;

289: END LOOP;
290:
291: if NOT(valid_name) then
292: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_NAME_ILLEGAL');
293: FND_MSG_PUB.Add;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: else
296:
297: select count(*) into media_name_count from IEU_UWQ_MEDIA_TYPES_TL where lower(MEDIA_TYPE_NAME) like lower(temp_media_name);

Line 300: FND_MSG_PUB.Add;

296:
297: select count(*) into media_name_count from IEU_UWQ_MEDIA_TYPES_TL where lower(MEDIA_TYPE_NAME) like lower(temp_media_name);
298: if media_name_count <> 0 then
299: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_NAME_EXISTS');
300: FND_MSG_PUB.Add;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: end if;
303: end if;
304:

Line 310: FND_MSG_PUB.Add;

306: end if;
307:
308: if rec_obj.media_type_uuid IS NULL then
309: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_UUID_NULL');
310: FND_MSG_PUB.Add;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: else
313:
314: temp_uuid := LTRIM(RTRIM(rec_obj.media_type_uuid));

Line 333: FND_MSG_PUB.Add;

329: end if;
330: END LOOP;
331: if NOT(valid_uuid) then
332: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_UUID_ILLEGAL');
333: FND_MSG_PUB.Add;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: else
336:
337: select count(*) into media_uuid_count from IEU_UWQ_MEDIA_TYPES_B where lower(MEDIA_TYPE_UUID) like lower(temp_uuid);

Line 341: FND_MSG_PUB.Add;

337: select count(*) into media_uuid_count from IEU_UWQ_MEDIA_TYPES_B where lower(MEDIA_TYPE_UUID) like lower(temp_uuid);
338:
339: if media_uuid_count <> 0 then
340: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_UUID_EXISTS');
341: FND_MSG_PUB.Add;
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: end if;
344: end if;
345: end if;

Line 353: FND_MSG_PUB.Add;

349:
350:
351: if rec_obj.application_name IS NULL then
352: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_APPNAME_NULL');
353: FND_MSG_PUB.Add;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: else
356: select count(*) into application_name_count from FND_APPLICATION_TL T, FND_APPLICATION B
357: where B.APPLICATION_ID = T.APPLICATION_ID and T.LANGUAGE = l_language and lower(T.APPLICATION_NAME) like lower(rec_obj.application_name);

Line 361: FND_MSG_PUB.Add;

357: where B.APPLICATION_ID = T.APPLICATION_ID and T.LANGUAGE = l_language and lower(T.APPLICATION_NAME) like lower(rec_obj.application_name);
358:
359: if application_name_count = 0 then
360: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_APPNAME_INVALID');
361: FND_MSG_PUB.Add;
362: raise FND_API.G_EXC_ERROR;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: end if;
365: end if;

Line 390: FND_MSG_PUB.Add;

386: END LOOP;
387:
388: if NOT(valid_cli_class) then
389: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_CLI_ILLEGAL');
390: FND_MSG_PUB.Add;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: end if;
393:
394: if (rec_obj.cli_plugin_id IS NULL) then

Line 404: FND_MSG_PUB.Add;

400: if cli_class_name_count <> 0 then
401:
402:
403: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_CLI_NAME');
404: FND_MSG_PUB.Add;
405: x_return_status := FND_API.G_RET_STS_ERROR;
406:
407: end if;
408: end if;

Line 437: FND_MSG_PUB.Add;

433: END LOOP;
434:
435: if NOT(valid_svr_class) then
436: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_SVR_ILLEGAL');
437: FND_MSG_PUB.Add;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: end if;
440:
441: if (rec_obj.svr_mps_plugin_id IS NULL) then

Line 452: FND_MSG_PUB.Add;

448:
449:
450: if class_name_count <> 0 then
451: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_SVR_NAME');
452: FND_MSG_PUB.Add;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: end if;
455: else
456: select count(*) into class_name_count from IEU_CLI_PROV_PLUGINS

Line 463: FND_MSG_PUB.Add;

459:
460:
461: if class_name_count <> 0 then
462: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDIA_SVR_NAME');
463: FND_MSG_PUB.Add;
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: end if;
466:
467: end if;

Line 486: FND_MSG_PUB.Add;

482: select count(*) into l_temp_class_count from all_objects where owner = 'APPS' and object_type in('PACKAGE', 'PACKAGE BODY') and status='VALID'and object_name = l_temp_pkg_name;
483:
484: if not(l_temp_class_count is null) and (l_temp_class_count <= 0) then
485: FND_MESSAGE.set_name('IEU', 'IEU_PROV_MEDCLASSFN_INVALID');
486: FND_MSG_PUB.Add;
487: x_return_status := FND_API.G_RET_STS_ERROR;
488:
489: end if;
490:

Line 504: FND_MSG_PUB.Count_And_Get(

500: end if;*/
501:
502:
503: -- Standard call to get message count and if count is 1, get message info.
504: FND_MSG_PUB.Count_And_Get(
505: p_count => x_msg_count,
506: p_data => x_msg_data
507: );
508:

Line 509: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

505: p_count => x_msg_count,
506: p_data => x_msg_data
507: );
508:
509: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
510: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
511: x_msg_data := x_msg_data || ',' || l_msg_data;
512: END LOOP;
513:

Line 510: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

506: p_data => x_msg_data
507: );
508:
509: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
510: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
511: x_msg_data := x_msg_data || ',' || l_msg_data;
512: END LOOP;
513:
514:

Line 522: FND_MSG_PUB.Count_And_Get(

518: WHEN FND_API.G_EXC_ERROR THEN
519:
520:
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: FND_MSG_PUB.Count_And_Get(
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526:

Line 528: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

524: p_data => x_msg_data
525: );
526:
527:
528: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
529: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
530: x_msg_data := x_msg_data || ',' || l_msg_data;
531: END LOOP;
532:

Line 529: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

525: );
526:
527:
528: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
529: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
530: x_msg_data := x_msg_data || ',' || l_msg_data;
531: END LOOP;
532:
533:

Line 539: FND_MSG_PUB.Count_And_Get

535:
536:
537:
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: (
541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );

Line 545: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:
545: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
546: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
547: x_msg_data := x_msg_data || ',' || l_msg_data;
548: END LOOP;
549:

Line 546: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

542: p_data => x_msg_data
543: );
544:
545: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
546: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
547: x_msg_data := x_msg_data || ',' || l_msg_data;
548: END LOOP;
549:
550: WHEN OTHERS THEN

Line 556: FND_MSG_PUB.Count_And_Get (

552:
553: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555:
556: FND_MSG_PUB.Count_And_Get (
557: p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560:

Line 561: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

557: p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560:
561: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
562: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
563: x_msg_data := x_msg_data || ',' || l_msg_data;
564: END LOOP;
565:

Line 562: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

558: p_data => x_msg_data
559: );
560:
561: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
562: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
563: x_msg_data := x_msg_data || ',' || l_msg_data;
564: END LOOP;
565:
566: