266: if is_create then
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));
288: end if;
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:
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);
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;
305:
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:
328: exit;
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:
336:
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;
348: end if;
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
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);
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;
385: end if;
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:
399:
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;
432: end if;
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:
447:
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
458:
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:
481: begin
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;