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

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

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

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

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

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

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

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

254: IF (AMS_DEBUG_HIGH_ON) THEN
255:
256:
257:
258: AMS_Utility_PVT.debug_message(l_full_name||': end');
259:
260: END IF;
261:
262: EXCEPTION

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

336: IF (AMS_DEBUG_HIGH_ON) THEN
337:
338:
339:
340: AMS_Utility_PVT.debug_message(l_full_name || ': start');
341:
342: END IF;
343:
344: IF NOT FND_API.compatible_api_call

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

364: -- validate
365: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
366: IF (AMS_DEBUG_HIGH_ON) THEN
367:
368: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
369: END IF;
370:
371: check_items
372: (

Line 396: AMS_Utility_PVT.debug_message(l_full_name||': check record');

392: -- record level
393: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
394: IF (AMS_DEBUG_HIGH_ON) THEN
395:
396: AMS_Utility_PVT.debug_message(l_full_name||': check record');
397: END IF;
398: check_record
399: (
400: p_msg_rec => p_msg_rec,

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

411:
412: -- update
413: IF (AMS_DEBUG_HIGH_ON) THEN
414:
415: AMS_Utility_PVT.debug_message(l_full_name||': update');
416: END IF;
417:
418: UPDATE AMS_MESSAGES_B SET
419: last_update_date = SYSDATE,

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

485: IF (AMS_DEBUG_HIGH_ON) THEN
486:
487:
488:
489: AMS_Utility_PVT.debug_message(l_full_name || ': end');
490:
491: END IF;
492:
493: EXCEPTION

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

560: IF (AMS_DEBUG_HIGH_ON) THEN
561:
562:
563:
564: AMS_Utility_PVT.debug_message(l_full_name || ': start');
565:
566: END IF;
567:
568: IF FND_API.to_boolean(p_init_msg_list) THEN

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

584:
585: -- delete
586: IF (AMS_DEBUG_HIGH_ON) THEN
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;

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

626: IF (AMS_DEBUG_HIGH_ON) THEN
627:
628:
629:
630: AMS_Utility_PVT.debug_message(l_full_name || ': end');
631:
632: END IF;
633:
634: EXCEPTION

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

711: BEGIN
712: -- initialize
713: IF (AMS_DEBUG_HIGH_ON) THEN
714:
715: AMS_Utility_PVT.debug_message(l_full_name || ': start');
716: END IF;
717:
718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;

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

734:
735: -- lock
736: IF (AMS_DEBUG_HIGH_ON) THEN
737:
738: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
739: END IF;
740:
741: OPEN c_msg_b;
742: FETCH c_msg_b INTO l_msg_id;

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

773: IF (AMS_DEBUG_HIGH_ON) THEN
774:
775:
776:
777: AMS_Utility_PVT.debug_message(l_full_name || ': end');
778:
779: END IF;
780:
781: EXCEPTION

Line 783: WHEN AMS_Utility_PVT.resource_locked THEN

779: END IF;
780:
781: EXCEPTION
782:
783: WHEN AMS_Utility_PVT.resource_locked THEN
784: x_return_status := FND_API.g_ret_sts_error;
785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
787: FND_MSG_PUB.add;

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

857:
858: ----------------------- initialize --------------------
859: IF (AMS_DEBUG_HIGH_ON) THEN
860:
861: AMS_Utility_PVT.debug_message(l_full_name||': start');
862: END IF;
863:
864: IF NOT FND_API.compatible_api_call
865: (

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

877: ---------------------- validate ------------------------
878: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
879: IF (AMS_DEBUG_HIGH_ON) THEN
880:
881: AMS_Utility_PVT.debug_message(l_full_name||': check items');
882: END IF;
883: check_items
884: (
885: p_validation_mode => JTF_PLSQL_API.g_create,

Line 901: AMS_Utility_PVT.debug_message(l_full_name||': check record');

897: -- record level
898: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
899: IF (AMS_DEBUG_HIGH_ON) THEN
900:
901: AMS_Utility_PVT.debug_message(l_full_name||': check record');
902: END IF;
903: check_record
904: (
905: p_msg_rec => p_msg_rec,

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

924: IF (AMS_DEBUG_HIGH_ON) THEN
925:
926:
927:
928: AMS_Utility_PVT.debug_message(l_full_name ||': end');
929:
930: END IF;
931:
932: EXCEPTION

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

984: BEGIN
985: -- initialize
986: IF (AMS_DEBUG_HIGH_ON) THEN
987:
988: AMS_Utility_PVT.debug_message(l_full_name || ': start');
989: END IF;
990:
991: x_return_status := FND_API.g_ret_sts_success;
992:

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

992:
993: -- check required items
994: IF (AMS_DEBUG_HIGH_ON) THEN
995:
996: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
997: END IF;
998: check_req_items
999: (
1000: p_validation_mode => p_validation_mode,

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

1008:
1009: -- check unique key items
1010: IF (AMS_DEBUG_HIGH_ON) THEN
1011:
1012: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');
1013: END IF;
1014: check_uk_items
1015: (
1016: p_validation_mode => p_validation_mode,

Line 1149: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1145: -- check PK, if message_id is passed in, must check if it is duplicate
1146: IF p_validation_mode = JTF_PLSQL_API.g_create
1147: AND p_msg_rec.message_id IS NOT NULL
1148: THEN
1149: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1150: (
1151: 'AMS_MESSAGES_VL',
1152: 'message_id = ' || p_msg_rec.message_id
1153: );

Line 1169: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1165:
1166: -- check message_name, language
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 = '''

Line 1178: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1174: || p_msg_rec.message_name
1175: || ''' AND language = ''' || USERENV('LANG') || ''''
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') || ''''