APPS.AMS_MESSAGES_PVT dependencies on AMS_MESSAGES_TL

Line 206: INSERT INTO AMS_MESSAGES_TL

202: l_msg_rec.attribute14,
203: l_msg_rec.attribute15
204: );
205:
206: INSERT INTO AMS_MESSAGES_TL
207: (
208: message_id,
209: language,
210: last_update_date,

Line 235: FROM AMS_MESSAGES_TL t

231: WHERE l.installed_flag in ('I', 'B')
232: AND NOT EXISTS
233: (
234: SELECT NULL
235: FROM AMS_MESSAGES_TL t
236: WHERE t.message_id = l_msg_rec.message_id
237: AND t.language = l.language_code
238: );
239:

Line 455: UPDATE AMS_MESSAGES_TL SET

451: END IF;
452: RAISE FND_API.g_exc_error;
453: END IF;
454:
455: UPDATE AMS_MESSAGES_TL SET
456: last_update_date = SYSDATE,
457: last_updated_by = FND_GLOBAL.user_id,
458: last_update_login = FND_GLOBAL.conc_login_id,
459: source_lang = USERENV('LANG'),

Line 591: DELETE FROM AMS_MESSAGES_TL

587:
588: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
589: END IF;
590:
591: DELETE FROM AMS_MESSAGES_TL
592: WHERE message_id = p_msg_id;
593:
594: IF (SQL%NOTFOUND) THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 706: FROM AMS_MESSAGES_TL

702: FOR UPDATE OF message_id NOWAIT;
703:
704: CURSOR c_msg_tl IS
705: SELECT message_id
706: FROM AMS_MESSAGES_TL
707: WHERE message_id = p_msg_id
708: AND USERENV('LANG') IN (language, source_lang)
709: FOR UPDATE OF message_id NOWAIT;
710:

Line 1127: FROM AMS_MESSAGES_TL

1123: l_uk_flag VARCHAR2(1);
1124:
1125: cursor check_name_with_id(l_msg_id IN NUMBER, l_msg_name IN VARCHAR2) IS
1126: SELECT ''
1127: FROM AMS_MESSAGES_TL
1128: WHERE message_id <> l_msg_id
1129: AND message_name = l_msg_name
1130: AND language = USERENV('LANG');
1131:

Line 1135: FROM AMS_MESSAGES_TL

1131:
1132:
1133: cursor check_name_without_id(l_msg_name IN VARCHAR2) IS
1134: SELECT ''
1135: FROM AMS_MESSAGES_TL
1136: WHERE message_name = l_msg_name
1137: AND language = USERENV('LANG');
1138: l_dummy VARCHAR2(1);
1139: l_flag VARCHAR2(1);

Line 1171: 'AMS_MESSAGES_TL',

1167: /********
1168: IF p_msg_rec.message_id IS NOT NULL THEN
1169: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1170: (
1171: 'AMS_MESSAGES_TL',
1172: 'message_id<> ' || p_msg_rec.message_id
1173: || ' AND message_name = '''
1174: || p_msg_rec.message_name
1175: || ''' AND language = ''' || USERENV('LANG') || ''''

Line 1180: 'AMS_MESSAGES_TL',

1176: );
1177: ELSE
1178: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1179: (
1180: 'AMS_MESSAGES_TL',
1181: 'message_name = ''' || p_msg_rec.message_name
1182: ||''' AND language = ''' || USERENV('LANG') || ''''
1183: );
1184: END IF;