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.AMS_SETUP_ATTR_PVT dependencies on AMS_UTILITY_PVT

Line 60: AMS_Utility_PVT.debug_message(l_full_name || ': start');

56: IF (AMS_DEBUG_HIGH_ON) THEN
57:
58:
59:
60: AMS_Utility_PVT.debug_message(l_full_name || ': start');
61:
62: END IF;
63:
64: /* IF NOT FND_API.compatible_api_call

Line 82: AMS_Utility_PVT.debug_message(l_full_name || ': validate');

78: -- validate
79: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
80: IF (AMS_DEBUG_HIGH_ON) THEN
81:
82: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
83: END IF;
84:
85: validate_setup_attr
86: (

Line 106: AMS_Utility_PVT.debug_message(l_full_name || ': insert');

102:
103: -- insert
104: IF (AMS_DEBUG_HIGH_ON) THEN
105:
106: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
107: END IF;
108:
109: IF l_setup_attr_rec.setup_attribute_id IS NULL THEN
110: LOOP

Line 190: AMS_Utility_PVT.debug_message(l_full_name||': end');

186: IF (AMS_DEBUG_HIGH_ON) THEN
187:
188:
189:
190: AMS_Utility_PVT.debug_message(l_full_name||': end');
191:
192: END IF;
193:
194: EXCEPTION

Line 270: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start of api'); END IF;

266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_success;
269:
270: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start of api'); END IF;
271:
272: /***
273: IF NOT FND_API.compatible_api_call
274: (

Line 286: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': complete '); END IF;

282: END IF;
283: **/
284:
285:
286: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': complete '); END IF;
287:
288: -- complete record
289: complete_setup_attr_rec
290: (

Line 297: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': validate'); END IF;

293: );
294:
295: -- validate
296: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
297: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': validate'); END IF;
298:
299: check_items
300: (
301: p_validation_mode => JTF_PLSQL_API.g_update,

Line 316: AMS_Utility_PVT.debug_message(l_full_name||': update');

312:
313: -- update
314: IF (AMS_DEBUG_HIGH_ON) THEN
315:
316: AMS_Utility_PVT.debug_message(l_full_name||': update');
317: END IF;
318:
319: UPDATE AMS_CUSTOM_SETUP_ATTR SET
320: custom_setup_id = l_setup_attr_rec.custom_setup_id,

Line 363: AMS_Utility_PVT.debug_message(l_full_name || ': end');

359: IF (AMS_DEBUG_HIGH_ON) THEN
360:
361:
362:
363: AMS_Utility_PVT.debug_message(l_full_name || ': end');
364:
365: END IF;
366:
367: EXCEPTION

Line 435: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name||': start start '); END IF;

431:
432: BEGIN
433:
434: ----------------------- initialize --------------------
435: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name||': start start '); END IF;
436:
437: IF FND_API.to_boolean(p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;

Line 457: AMS_Utility_PVT.debug_message(l_full_name||': check items');

453: ---------------------- validate ------------------------
454: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
455: IF (AMS_DEBUG_HIGH_ON) THEN
456:
457: AMS_Utility_PVT.debug_message(l_full_name||': check items');
458: END IF;
459: check_items
460: (
461: p_validation_mode => JTF_PLSQL_API.g_create,

Line 484: AMS_Utility_PVT.debug_message(l_full_name ||': end');

480: IF (AMS_DEBUG_HIGH_ON) THEN
481:
482:
483:
484: AMS_Utility_PVT.debug_message(l_full_name ||': end');
485:
486: END IF;
487:
488: EXCEPTION

Line 543: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start'); END IF;

539: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
540:
541: BEGIN
542: -- initialize
543: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start'); END IF;
544:
545: x_return_status := FND_API.g_ret_sts_success;
546:
547: -- check required items

Line 548: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check required items'); END IF;

544:
545: x_return_status := FND_API.g_ret_sts_success;
546:
547: -- check required items
548: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check required items'); END IF;
549: check_setup_attr_req_items
550: (
551: p_validation_mode => p_validation_mode,
552: p_setup_attr_rec => p_setup_attr_rec,

Line 561: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check uk items'); END IF;

557: RETURN;
558: END IF;
559:
560: -- check unique key items
561: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check uk items'); END IF;
562: /*
563: check_setup_attr_uk_items
564: (
565: p_setup_attr_rec => p_setup_attr_rec,

Line 574: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check fk items'); END IF;

570: RETURN;
571: END IF;
572: */
573: -- check foreign key items
574: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check fk items'); END IF;
575: check_setup_attr_fk_items
576: (
577: p_setup_attr_rec => p_setup_attr_rec,
578: x_return_status => x_return_status

Line 586: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check flag items'); END IF;

582: RETURN;
583: END IF;
584:
585: -- check flag items
586: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check flag items'); END IF;
587: check_setup_attr_flag_items
588: (
589: p_setup_attr_rec => p_setup_attr_rec,
590: x_return_status => x_return_status

Line 740: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(' UK Check '); END IF;

736: AND setup_attribute_id <> setup_id_in
737: );
738: BEGIN
739:
740: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(' UK Check '); END IF;
741:
742: x_return_status := FND_API.g_ret_sts_success;
743:
744: -- check PK, if custom_setup_id is passed in, must check if it is duplicate

Line 751: l_uk_flag := AMS_Utility_PVT.check_uniqueness

747:
748: IF p_validation_mode = JTF_PLSQL_API.g_create
749: AND p_setup_attr_rec.setup_attribute_id IS NOT NULL
750: THEN
751: l_uk_flag := AMS_Utility_PVT.check_uniqueness
752: (
753: 'AMS_CUSTOM_SETUP_ATTR',
754: 'setup_attribute_id = ' || p_setup_attr_rec.setup_attribute_id
755: );

Line 813: AMS_Utility_PVT.debug_message(' FK Check ');

809: IF (AMS_DEBUG_HIGH_ON) THEN
810:
811:
812:
813: AMS_Utility_PVT.debug_message(' FK Check ');
814:
815: END IF;
816: x_return_status := FND_API.g_ret_sts_success;
817:

Line 818: l_fk_flag := AMS_Utility_PVT.check_fk_exists

814:
815: END IF;
816: x_return_status := FND_API.g_ret_sts_success;
817:
818: l_fk_flag := AMS_Utility_PVT.check_fk_exists
819: (
820: 'AMS_CUSTOM_SETUPS_B',
821: 'custom_setup_id',
822: p_setup_attr_rec.custom_setup_id