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_API

Line 83: x_return_status := fnd_api.g_ret_sts_success;

79: v_classfn_query_proc IEU_UWQ_MEDIA_TYPES_B.CLASSIFICATION_QUERY_PROC%type;
80:
81:
82: BEGIN
83: x_return_status := fnd_api.g_ret_sts_success;
84:
85: v_cursorID := DBMS_SQL.OPEN_CURSOR;
86:
87:

Line 177: WHEN fnd_api.g_exc_error THEN

173:
174: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
175:
176: EXCEPTION
177: WHEN fnd_api.g_exc_error THEN
178:
179: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
180: x_return_status := fnd_api.g_ret_sts_error;
181:

Line 180: x_return_status := fnd_api.g_ret_sts_error;

176: EXCEPTION
177: WHEN fnd_api.g_exc_error THEN
178:
179: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
180: x_return_status := fnd_api.g_ret_sts_error;
181:
182: WHEN fnd_api.g_exc_unexpected_error THEN
183:
184: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

Line 182: WHEN fnd_api.g_exc_unexpected_error THEN

178:
179: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
180: x_return_status := fnd_api.g_ret_sts_error;
181:
182: WHEN fnd_api.g_exc_unexpected_error THEN
183:
184: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
185: x_return_status := fnd_api.g_ret_sts_unexp_error;
186:

Line 185: x_return_status := fnd_api.g_ret_sts_unexp_error;

181:
182: WHEN fnd_api.g_exc_unexpected_error THEN
183:
184: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
185: x_return_status := fnd_api.g_ret_sts_unexp_error;
186:
187: WHEN OTHERS THEN
188:
189: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

Line 190: x_return_status := fnd_api.g_ret_sts_unexp_error;

186:
187: WHEN OTHERS THEN
188:
189: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191:
192: END GET_MEDIA_TYPE_LIST;
193:
194: --===================================================================

Line 255: x_return_status := fnd_api.g_ret_sts_success;

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;
259:

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

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:
276: FOR i in 1..LENGTH(temp_media_name) LOOP

Line 283: x_return_status := fnd_api.g_ret_sts_success;

279: if ((temp_char >= '0' and temp_char <= '9') or (temp_char >= 'a' and temp_char <= 'z') or
280: (temp_char >= 'A' and temp_char <= 'Z') or (temp_char = '-') or (temp_char = '_') or
281: (temp_char = '.') or (temp_char = ' ')) then
282:
283: x_return_status := fnd_api.g_ret_sts_success;
284:
285: else
286: valid_name := false;
287: exit;

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

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);
298: if media_name_count <> 0 then

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

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:
305:

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

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));
315:

Line 323: --x_return_status := fnd_api.g_ret_sts_success;

319: if ((temp_char >= '0' and temp_char <= '9') or (temp_char >= 'a' and temp_char <= 'z') or
320: (temp_char >= 'A' and temp_char <= 'Z') or (temp_char = '-') or (temp_char = '_') or
321: (temp_char = '.')) then
322:
323: --x_return_status := fnd_api.g_ret_sts_success;
324: null;
325:
326: else
327: valid_uuid := false;

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

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);
338:

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

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;
346:

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

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);
358:

Line 362: raise FND_API.G_EXC_ERROR;

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;
366:

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

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;
366:
367:

Line 379: -- x_return_status := fnd_api.g_ret_sts_success;

375: if ((temp_char >= '0' and temp_char <= '9') or (temp_char >= 'a' and temp_char <= 'z') or
376: (temp_char >= 'A' and temp_char <= 'Z') or (temp_char = '-') or (temp_char = '_') or
377: (temp_char = '.')) then
378:
379: -- x_return_status := fnd_api.g_ret_sts_success;
380: null;
381:
382: else
383: valid_cli_class := false;

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

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
395: select count(*) into cli_class_name_count from IEU_UWQ_CLI_MED_PLUGINS

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

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;
409:

Line 426: --x_return_status := fnd_api.g_ret_sts_success;

422: if ((temp_char >= '0' and temp_char <= '9') or (temp_char >= 'a' and temp_char <= 'z') or
423: (temp_char >= 'A' and temp_char <= 'Z') or (temp_char = '-') or (temp_char = '_') or
424: (temp_char = '.')) then
425:
426: --x_return_status := fnd_api.g_ret_sts_success;
427: null;
428:
429: else
430: valid_svr_class := false;

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

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
442:

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

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
457: where lower(PLUGIN_CLASS_NAME) like lower(temp_svr_class);

Line 464: x_return_status := FND_API.G_RET_STS_ERROR;

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;
468: end if;

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

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:
491: EXCEPTION

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 518: WHEN FND_API.G_EXC_ERROR THEN

514:
515:
516: EXCEPTION
517:
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(

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

517:
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: );

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 534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

530: x_msg_data := x_msg_data || ',' || l_msg_data;
531: END LOOP;
532:
533:
534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
535:
536:
537:
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

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 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: WHEN OTHERS THEN
551:
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

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:

Line 606: x_return_status := fnd_api.g_ret_sts_success;

602: l_plugin_med_map_id NUMBER(15);
603:
604: BEGIN
605:
606: x_return_status := fnd_api.g_ret_sts_success;
607:
608: IEU_UWQ_MEDIA_TYPES_PVT.VALIDATE ( x_return_status,
609: x_msg_count,
610: x_msg_data,

Line 874: WHEN fnd_api.g_exc_error THEN

870:
871: COMMIT;
872:
873: EXCEPTION
874: WHEN fnd_api.g_exc_error THEN
875:
876:
877: ROLLBACK;
878: x_return_status := fnd_api.g_ret_sts_error;

Line 878: x_return_status := fnd_api.g_ret_sts_error;

874: WHEN fnd_api.g_exc_error THEN
875:
876:
877: ROLLBACK;
878: x_return_status := fnd_api.g_ret_sts_error;
879:
880: WHEN fnd_api.g_exc_unexpected_error THEN
881:
882:

Line 880: WHEN fnd_api.g_exc_unexpected_error THEN

876:
877: ROLLBACK;
878: x_return_status := fnd_api.g_ret_sts_error;
879:
880: WHEN fnd_api.g_exc_unexpected_error THEN
881:
882:
883: ROLLBACK;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 884: x_return_status := fnd_api.g_ret_sts_unexp_error;

880: WHEN fnd_api.g_exc_unexpected_error THEN
881:
882:
883: ROLLBACK;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;
885:
886: WHEN OTHERS THEN
887:
888:

Line 890: x_return_status := fnd_api.g_ret_sts_unexp_error;

886: WHEN OTHERS THEN
887:
888:
889: ROLLBACK;
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891:
892: END CREATE_MEDIA_TYPE;
893:
894:

Line 937: x_return_status := fnd_api.g_ret_sts_success;

933:
934:
935:
936: BEGIN
937: x_return_status := fnd_api.g_ret_sts_success;
938: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
939:
940:
941:

Line 1299: WHEN fnd_api.g_exc_error THEN

1295: commit;
1296:
1297:
1298: EXCEPTION
1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302:
1303: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1301: x_return_status := fnd_api.g_ret_sts_error;

1297:
1298: EXCEPTION
1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302:
1303: WHEN fnd_api.g_exc_unexpected_error THEN
1304: ROLLBACK;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1303: WHEN fnd_api.g_exc_unexpected_error THEN

1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302:
1303: WHEN fnd_api.g_exc_unexpected_error THEN
1304: ROLLBACK;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:
1307: WHEN NO_DATA_FOUND THEN

Line 1305: x_return_status := fnd_api.g_ret_sts_unexp_error;

1301: x_return_status := fnd_api.g_ret_sts_error;
1302:
1303: WHEN fnd_api.g_exc_unexpected_error THEN
1304: ROLLBACK;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:
1307: WHEN NO_DATA_FOUND THEN
1308: null;
1309:

Line 1312: x_return_status := fnd_api.g_ret_sts_unexp_error;

1308: null;
1309:
1310: WHEN OTHERS THEN
1311: ROLLBACK;
1312: x_return_status := fnd_api.g_ret_sts_unexp_error;
1313:
1314:
1315:
1316: END UPDATE_MEDIA_TYPE;