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_MEDIA_PVT dependencies on JTF_PLSQL_API

Line 64: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

60:
61: -- Check_Media_UK_Items
62: PROCEDURE Check_Media_UK_Items (
63: p_media_rec IN Media_Rec_Type,
64: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
65: x_return_status OUT NOCOPY VARCHAR2
66: );
67:
68: -- Check_Media_FK_Items

Line 97: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

93:
94: -- Check_MediaChannel_UK_Items
95: PROCEDURE Check_MediaChannel_UK_Items (
96: p_mediachl_rec IN MediaChannel_Rec_Type,
97: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
98: x_return_status OUT NOCOPY VARCHAR2
99: );
100:
101: -- Check_MediaChannel_FK_Items

Line 546: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

542:
543: -- replace g_miss_char/num/date with current column values
544: Complete_Media_Rec (p_media_rec, l_media_rec);
545:
546: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
547: Check_Media_Items (
548: p_media_rec => p_media_rec,
549: p_validation_mode => JTF_PLSQL_API.g_update,
550: x_return_status => l_return_status

Line 549: p_validation_mode => JTF_PLSQL_API.g_update,

545:
546: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
547: Check_Media_Items (
548: p_media_rec => p_media_rec,
549: p_validation_mode => JTF_PLSQL_API.g_update,
550: x_return_status => l_return_status
551: );
552:
553: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 560: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

556: RAISE FND_API.g_exc_error;
557: END IF;
558: END IF;
559:
560: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
561: Check_Media_Record (
562: p_media_rec => p_media_rec,
563: p_complete_rec => l_media_rec,
564: x_return_status => l_return_status

Line 1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1059:
1060: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
1061: END IF;
1062:
1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1064: Check_Media_Items (
1065: p_media_rec => p_media_rec,
1066: p_validation_mode => JTF_PLSQL_API.g_create,
1067: x_return_status => l_return_status

Line 1066: p_validation_mode => JTF_PLSQL_API.g_create,

1062:
1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1064: Check_Media_Items (
1065: p_media_rec => p_media_rec,
1066: p_validation_mode => JTF_PLSQL_API.g_create,
1067: x_return_status => l_return_status
1068: );
1069:
1070: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1081: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
1082:
1083: END IF;
1084:
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1086: Check_Media_Record (
1087: p_media_rec => p_media_rec,
1088: p_complete_rec => NULL,
1089: x_return_status => l_return_status

Line 1149: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1145: --
1146: ---------------------------------------------------------------------
1147: PROCEDURE Check_Media_Items (
1148: p_media_rec IN Media_Rec_Type,
1149: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1150: x_return_status OUT NOCOPY VARCHAR2
1151: )
1152: IS
1153: BEGIN

Line 1470: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1466:
1467: -- Check_Media_UK_Items
1468: PROCEDURE Check_Media_UK_Items (
1469: p_media_rec IN Media_Rec_Type,
1470: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1471: x_return_status OUT NOCOPY VARCHAR2
1472: )
1473: IS
1474: l_valid_flag VARCHAR2(1);

Line 1497: IF p_validation_mode = JTF_PLSQL_API.g_create

1493:
1494: -- MEDIA_ID
1495: -- For Create_Media, when ID is passed in, we need to
1496: -- check if this ID is unique.
1497: IF p_validation_mode = JTF_PLSQL_API.g_create
1498: AND p_media_rec.media_id IS NOT NULL
1499: THEN
1500: IF AMS_Utility_PVT.check_uniqueness(
1501: 'ams_media_b',

Line 1515: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1511: END IF;
1512: END IF;
1513:
1514: -- MEDIA_NAME
1515: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1516:
1517: -- rrajesh start 11/07. Replaced the AMS_Utility_PVT call
1518: -- with the new cursor.
1519: OPEN c_name_unique_cr(p_media_rec.media_name) ;

Line 1932: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1928:
1929: -- replace g_miss_char/num/date with current column values
1930: Complete_MediaChannel_Rec (p_mediachl_rec, l_mediachl_rec);
1931:
1932: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1933: Check_MediaChannel_Items (
1934: p_mediachl_rec => l_mediachl_rec, -- change from p_mediachl_rec vmodur
1935: p_validation_mode => JTF_PLSQL_API.g_update,
1936: x_return_status => l_return_status

Line 1935: p_validation_mode => JTF_PLSQL_API.g_update,

1931:
1932: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1933: Check_MediaChannel_Items (
1934: p_mediachl_rec => l_mediachl_rec, -- change from p_mediachl_rec vmodur
1935: p_validation_mode => JTF_PLSQL_API.g_update,
1936: x_return_status => l_return_status
1937: );
1938:
1939: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1946: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1942: RAISE FND_API.g_exc_error;
1943: END IF;
1944: END IF;
1945:
1946: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1947: Check_MediaChannel_Record (
1948: p_mediachl_rec => l_mediachl_rec, -- change from p_mediachl_rec vmodur
1949: p_complete_rec => l_mediachl_rec,
1950: x_return_status => l_return_status

Line 1962: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

1958: END IF;
1959:
1960: -- Following lines are commented by ptendulk on 16dec1999
1961: -- as we are not validating Interentity
1962: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1963: -- Check_MediaChannel_InterEntity (
1964: -- p_mediachl_rec => p_mediachl_rec,
1965: -- p_complete_rec => l_mediachl_rec,
1966: -- x_return_status => l_return_status

Line 2419: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2415:
2416: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
2417: END IF;
2418:
2419: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2420: Check_MediaChannel_Items (
2421: p_mediachl_rec => p_mediachl_rec,
2422: p_validation_mode => JTF_PLSQL_API.g_create,
2423: x_return_status => l_return_status

Line 2422: p_validation_mode => JTF_PLSQL_API.g_create,

2418:
2419: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2420: Check_MediaChannel_Items (
2421: p_mediachl_rec => p_mediachl_rec,
2422: p_validation_mode => JTF_PLSQL_API.g_create,
2423: x_return_status => l_return_status
2424: );
2425:
2426: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2441: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2437: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
2438:
2439: END IF;
2440:
2441: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2442: Check_MediaChannel_Record (
2443: p_mediachl_rec => p_mediachl_rec,
2444: p_complete_rec => NULL,
2445: x_return_status => l_return_status

Line 2505: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

2501: -- Check_MediaChannel_Items
2502: ---------------------------------------------------------------------
2503: PROCEDURE Check_MediaChannel_Items (
2504: p_mediachl_rec IN MediaChannel_Rec_Type,
2505: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2506: x_return_status OUT NOCOPY VARCHAR2
2507: )
2508: IS
2509: BEGIN

Line 2816: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

2812: --
2813: ---------------------------------------------------------------------
2814: PROCEDURE Check_MediaChannel_UK_Items (
2815: p_mediachl_rec IN MediaChannel_Rec_Type,
2816: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2817: x_return_status OUT NOCOPY VARCHAR2
2818: )
2819: IS
2820: -- soagrawa 15-jan-2002

Line 2850: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2846: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items start');
2847: END IF;
2848: -- The combination of media and channel should
2849: -- be unique.
2850: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2851: IF (AMS_DEBUG_HIGH_ON) THEN
2852:
2853: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items CREATE');
2854: END IF;