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_LIST_WORD_FIELDS_PVT dependencies on AMS_UTILITY_PVT

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

59:
60:
61:
62:
63: AMS_Utility_PVT.debug_message(l_full_name || ': start');
64:
65:
66: END IF;
67:

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

80:
81: -- validate
82: IF (AMS_DEBUG_HIGH_ON) THEN
83:
84: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
85: END IF;
86: validate_list_word_field
87: (
88: p_api_version => l_api_version,

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_wrd_fld_rec.list_word_field_id IS NULL THEN
110: LOOP

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

172: IF (AMS_DEBUG_HIGH_ON) THEN
173:
174:
175:
176: AMS_Utility_PVT.debug_message(l_full_name||': end');
177:
178: END IF;
179:
180: EXCEPTION

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

254: IF (AMS_DEBUG_HIGH_ON) THEN
255:
256:
257:
258: AMS_Utility_PVT.debug_message(l_full_name || ': start');
259:
260: END IF;
261:
262: IF NOT FND_API.compatible_api_call

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

275: -- validate
276: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
277: IF (AMS_DEBUG_HIGH_ON) THEN
278:
279: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
280: END IF;
281:
282: check_items
283: (

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

304:
305: -- update
306: IF (AMS_DEBUG_HIGH_ON) THEN
307:
308: AMS_Utility_PVT.debug_message(l_full_name||': update');
309: END IF;
310:
311: UPDATE AMS_LIST_WORD_FIELDS SET
312: last_update_date = SYSDATE,

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

346: IF (AMS_DEBUG_HIGH_ON) THEN
347:
348:
349:
350: AMS_Utility_PVT.debug_message(l_full_name || ': end');
351:
352: END IF;
353:
354: EXCEPTION

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

421: IF (AMS_DEBUG_HIGH_ON) THEN
422:
423:
424:
425: AMS_Utility_PVT.debug_message(l_full_name || ': start');
426:
427: END IF;
428:
429: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 449: AMS_Utility_PVT.debug_message(l_full_name || ': delete');

445:
446: -- delete
447: IF (AMS_DEBUG_HIGH_ON) THEN
448:
449: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
450: END IF;
451:
452: DELETE FROM AMS_LIST_WORD_FIELDS
453: WHERE list_word_field_id = p_wrd_fld_id

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

476: IF (AMS_DEBUG_HIGH_ON) THEN
477:
478:
479:
480: AMS_Utility_PVT.debug_message(l_full_name || ': end');
481:
482: END IF;
483:
484: EXCEPTION

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

554: BEGIN
555: -- initialize
556: IF (AMS_DEBUG_HIGH_ON) THEN
557:
558: AMS_Utility_PVT.debug_message(l_full_name || ': start');
559: END IF;
560:
561: IF FND_API.to_boolean(p_init_msg_list) THEN
562: FND_MSG_PUB.initialize;

Line 581: AMS_Utility_PVT.debug_message(l_full_name || ': lock');

577:
578: -- lock
579: IF (AMS_DEBUG_HIGH_ON) THEN
580:
581: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
582: END IF;
583:
584: OPEN c_list_word_field;
585: FETCH c_list_word_field INTO l_wrd_fld_id;

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

604: IF (AMS_DEBUG_HIGH_ON) THEN
605:
606:
607:
608: AMS_Utility_PVT.debug_message(l_full_name || ': end');
609:
610: END IF;
611:
612: EXCEPTION

Line 614: WHEN AMS_Utility_PVT.resource_locked THEN

610: END IF;
611:
612: EXCEPTION
613:
614: WHEN AMS_Utility_PVT.resource_locked THEN
615: x_return_status := FND_API.g_ret_sts_error;
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
617: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
618: FND_MSG_PUB.add;

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

688:
689: ----------------------- initialize --------------------
690: IF (AMS_DEBUG_HIGH_ON) THEN
691:
692: AMS_Utility_PVT.debug_message(l_full_name||': start');
693: END IF;
694:
695: IF NOT FND_API.compatible_api_call
696: (

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

708: ---------------------- validate ------------------------
709: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
710: IF (AMS_DEBUG_HIGH_ON) THEN
711:
712: AMS_Utility_PVT.debug_message(l_full_name||': check items');
713: END IF;
714: check_items
715: (
716: p_validation_mode => JTF_PLSQL_API.g_create,

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

738: IF (AMS_DEBUG_HIGH_ON) THEN
739:
740:
741:
742: AMS_Utility_PVT.debug_message(l_full_name ||': end');
743:
744: END IF;
745:
746: EXCEPTION

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

798: BEGIN
799: -- initialize
800: IF (AMS_DEBUG_HIGH_ON) THEN
801:
802: AMS_Utility_PVT.debug_message(l_full_name || ': start');
803: END IF;
804:
805: x_return_status := FND_API.g_ret_sts_success;
806:

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

806:
807: -- check required items
808: IF (AMS_DEBUG_HIGH_ON) THEN
809:
810: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
811: END IF;
812: check_req_items
813: (
814: p_validation_mode => p_validation_mode,

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

822:
823: -- check foreign key items
824: IF (AMS_DEBUG_HIGH_ON) THEN
825:
826: AMS_Utility_PVT.debug_message(l_full_name || ': check fk items');
827: END IF;
828: check_fk_items
829: (
830: p_wrd_fld_rec => p_wrd_fld_rec,

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

837:
838: -- check unique key items
839: IF (AMS_DEBUG_HIGH_ON) THEN
840:
841: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');
842: END IF;
843: check_uk_items
844: (
845: p_validation_mode => p_validation_mode,

Line 1002: l_fk_flag := AMS_Utility_PVT.check_fk_exists

998:
999: x_return_status := FND_API.g_ret_sts_success;
1000:
1001: -- check field_table_name, field_column_name
1002: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1003: (
1004: 'AMS_LIST_FIELDS_B',
1005: 'field_table_name',
1006: p_wrd_fld_rec.field_table_name,

Line 1023: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1019: END IF;
1020:
1021: -- check list_word_replaces_id
1022: IF p_wrd_fld_rec.list_word_replaces_id IS NOT NULL THEN
1023: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1024: (
1025: 'AMS_LIST_WORD_REPLACES',
1026: 'list_word_replaces_id',
1027: p_wrd_fld_rec.list_word_replaces_id

Line 1068: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1064: -- check PK, if list_word_field_id is passed in, must check if it is duplicate
1065: IF p_validation_mode = JTF_PLSQL_API.g_create
1066: AND p_wrd_fld_rec.list_word_field_id IS NOT NULL
1067: THEN
1068: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1069: (
1070: 'AMS_LIST_WORD_FIELDS',
1071: 'list_word_field_id = ' || p_wrd_fld_rec.list_word_field_id
1072: );

Line 1087: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1083: END IF;
1084:
1085: -- check list_word_replaces_id, field_table_name, field_column_name
1086: IF p_wrd_fld_rec.list_word_field_id IS NOT NULL THEN
1087: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1088: (
1089: 'AMS_LIST_WORD_FIELDS',
1090: 'list_word_field_id <> ' || p_wrd_fld_rec.list_word_field_id
1091: || ' AND list_word_replaces_id = ' || p_wrd_fld_rec.list_word_replaces_id

Line 1096: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1092: || ' AND field_table_name = ''' || p_wrd_fld_rec.field_table_name
1093: || ''' AND field_column_name = ''' || p_wrd_fld_rec.field_column_name || ''''
1094: );
1095: ELSE
1096: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1097: (
1098: 'AMS_LIST_WORD_FIELDS',
1099: 'list_word_replaces_id = ' || p_wrd_fld_rec.list_word_replaces_id
1100: || ' AND field_table_name = ''' || p_wrd_fld_rec.field_table_name