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 AMS_UTILITY_PVT

Line 36: -- the AMS_Utility_PVT call with c_name_unique_cr,

32: -- 15-dec-1999 ptendulk Modified Create Media Channel API
33: -- 31-Dec-1999 ptendulk Modified (Check Object Version Number before
34: -- updating /deleting)
35: -- 07-Nov-2000 rrajesh Modified the uniqueness checking of media_name, by replacing
36: -- the AMS_Utility_PVT call with c_name_unique_cr,
37: -- c_name_unique_up cursors.
38: -- 06-Dec-2000 julou Commented out procedure check_media_flag_items
39: -- 07-Nov-2000 rrajesh Bug fix. 2005131. Moved dependancy checking of media from
40: -- campaign level to schedule level.

Line 206: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

202: IF (AMS_DEBUG_HIGH_ON) THEN
203:
204:
205:
206: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
207:
208: END IF;
209:
210: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 228: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

224:
225: ----------------------- validate -----------------------
226: IF (AMS_DEBUG_HIGH_ON) THEN
227:
228: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
229: END IF;
230:
231: -- Start of Comments by ptendulk
232: -- Following lines are commented on 10-Dec-1999 as

Line 307: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');

303:
304: -------------------------- insert --------------------------
305: IF (AMS_DEBUG_HIGH_ON) THEN
306:
307: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
308: END IF;
309:
310: --
311: -- Insert into mutli-language supported table.

Line 431: AMS_Utility_PVT.debug_message (l_full_name || ': End');

427: IF (AMS_DEBUG_HIGH_ON) THEN
428:
429:
430:
431: AMS_Utility_PVT.debug_message (l_full_name || ': End');
432:
433: END IF;
434:
435: EXCEPTION

Line 502: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

498: IF (AMS_DEBUG_HIGH_ON) THEN
499:
500:
501:
502: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
503:
504: END IF;
505:
506: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 524: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

520:
521: ----------------------- validate ----------------------
522: IF (AMS_DEBUG_HIGH_ON) THEN
523:
524: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
525: END IF;
526:
527: --
528: -- Check if record is seeded.

Line 577: AMS_Utility_PVT.debug_message (l_full_name || ': Update');

573:
574: -------------------------- update --------------------
575: IF (AMS_DEBUG_HIGH_ON) THEN
576:
577: AMS_Utility_PVT.debug_message (l_full_name || ': Update');
578: END IF;
579:
580: -- Modified by ptendulk on 30Dec1999
581: -- Check Obj Version Number before Updating

Line 655: AMS_Utility_PVT.debug_message (l_full_name || ': End');

651: IF (AMS_DEBUG_HIGH_ON) THEN
652:
653:
654:
655: AMS_Utility_PVT.debug_message (l_full_name || ': End');
656:
657: END IF;
658:
659: EXCEPTION

Line 748: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

744: IF (AMS_DEBUG_HIGH_ON) THEN
745:
746:
747:
748: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
749:
750: END IF;
751:
752: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 770: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');

766:
767: ------------------------ delete ------------------------
768: IF (AMS_DEBUG_HIGH_ON) THEN
769:
770: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');
771: END IF;
772:
773: --
774: -- Check if record is seeded.

Line 841: AMS_Utility_PVT.debug_message (l_full_name || ': End');

837: IF (AMS_DEBUG_HIGH_ON) THEN
838:
839:
840:
841: AMS_Utility_PVT.debug_message (l_full_name || ': End');
842:
843: END IF;
844:
845: EXCEPTION

Line 920: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

916: BEGIN
917: --------------------- initialize -----------------------
918: IF (AMS_DEBUG_HIGH_ON) THEN
919:
920: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
921: END IF;
922:
923: IF FND_API.to_boolean (p_init_msg_list) THEN
924: FND_MSG_PUB.initialize;

Line 941: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');

937:
938: ------------------------ lock -------------------------
939: IF (AMS_DEBUG_HIGH_ON) THEN
940:
941: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');
942: END IF;
943:
944: OPEN c_lock;
945: FETCH c_lock INTO l_dummy;

Line 967: AMS_Utility_PVT.debug_message (l_full_name || ': End');

963: IF (AMS_DEBUG_HIGH_ON) THEN
964:
965:
966:
967: AMS_Utility_PVT.debug_message (l_full_name || ': End');
968:
969: END IF;
970:
971: EXCEPTION

Line 972: WHEN AMS_Utility_PVT.resource_locked THEN

968:
969: END IF;
970:
971: EXCEPTION
972: WHEN AMS_Utility_PVT.resource_locked THEN
973: x_return_status := FND_API.g_ret_sts_error;
974: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
975: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
976: FND_MSG_PUB.add;

Line 1039: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1035: BEGIN
1036: --------------------- initialize -----------------------
1037: IF (AMS_DEBUG_HIGH_ON) THEN
1038:
1039: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1040: END IF;
1041:
1042: IF FND_API.to_boolean (p_init_msg_list) THEN
1043: FND_MSG_PUB.initialize;

Line 1060: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');

1056:
1057: ---------------------- validate ------------------------
1058: IF (AMS_DEBUG_HIGH_ON) 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 (

Line 1081: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');

1077: IF (AMS_DEBUG_HIGH_ON) THEN
1078:
1079:
1080:
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

Line 1110: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1106: IF (AMS_DEBUG_HIGH_ON) THEN
1107:
1108:
1109:
1110: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1111:
1112: END IF;
1113:
1114: EXCEPTION

Line 1492: --IF (AMS_DEBUG_HIGH_ON) THENAMS_Utility_PVT.debug_message('Check the uniqueness');END IF;

1488: -- end 11/07
1489:
1490: BEGIN
1491: x_return_status := FND_API.g_ret_sts_success;
1492: --IF (AMS_DEBUG_HIGH_ON) THENAMS_Utility_PVT.debug_message('Check the uniqueness');END IF;
1493:
1494: -- MEDIA_ID
1495: -- For Create_Media, when ID is passed in, we need to
1496: -- check if this ID is unique.

Line 1500: IF AMS_Utility_PVT.check_uniqueness(

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',
1502: 'media_id = ' || p_media_rec.media_id
1503: ) = FND_API.g_false
1504: THEN

Line 1517: -- rrajesh start 11/07. Replaced the AMS_Utility_PVT call

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) ;
1520: FETCH c_name_unique_cr INTO l_count ;
1521: CLOSE c_name_unique_cr ;

Line 1523: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (

1519: OPEN c_name_unique_cr(p_media_rec.media_name) ;
1520: FETCH c_name_unique_cr INTO l_count ;
1521: CLOSE c_name_unique_cr ;
1522:
1523: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1524: -- 'ams_media_vl',
1525: -- 'media_name = ''' || p_media_rec.media_name || ''''
1526: -- );
1527: ELSE

Line 1528: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (

1524: -- 'ams_media_vl',
1525: -- 'media_name = ''' || p_media_rec.media_name || ''''
1526: -- );
1527: ELSE
1528: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1529: -- 'ams_media_vl',
1530: -- 'media_name = ''' || p_media_rec.media_name ||
1531: -- ''' AND media_id <> ' || p_media_rec.media_id
1532: -- );

Line 1539: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Cpount '|| l_count ); END IF;

1535: CLOSE c_name_unique_up ;
1536: -- rrajesh end 11/07
1537:
1538: END IF;
1539: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Cpount '|| l_count ); END IF;
1540: -- rrajesh start 11/07. Checking the uniqueness against the new cursor,
1541: -- c_name_unique_up
1542: IF l_count > 0 THEN
1543: -- rrajesh end 11/07

Line 1581: IF AMS_Utility_PVT.check_lookup_exists (

1577:
1578: --
1579: -- MEDIA_TYPE_CODE
1580: IF p_media_rec.media_type_code <> FND_API.g_miss_char THEN
1581: IF AMS_Utility_PVT.check_lookup_exists (
1582: p_lookup_type => L_MEDIA_TYPE_CODE,
1583: p_lookup_code => p_media_rec.media_type_code
1584: ) = FND_API.g_false
1585: THEN

Line 1612: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.inbound_flag) = FND_API.g_false THEN

1608: x_return_status := FND_API.g_ret_sts_success;
1609:
1610: -- INBOUND_FLAG
1611: IF p_media_rec.inbound_flag <> FND_API.g_miss_char AND p_media_rec.inbound_flag IS NOT NULL THEN
1612: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.inbound_flag) = FND_API.g_false THEN
1613: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1614: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_INBOUND_FLAG');
1615: FND_MSG_PUB.add;
1616: END IF;

Line 1625: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.enabled_flag) = FND_API.g_false THEN

1621: END IF;
1622:
1623: -- ENABLED_FLAG
1624: IF p_media_rec.enabled_flag <> FND_API.g_miss_char AND p_media_rec.enabled_flag IS NOT NULL THEN
1625: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.enabled_flag) = FND_API.g_false THEN
1626: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1627: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_ENABLED_FLAG');
1628: FND_MSG_PUB.add;
1629: END IF;

Line 1691: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1687: IF (AMS_DEBUG_HIGH_ON) THEN
1688:
1689:
1690:
1691: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1692:
1693: END IF;
1694:
1695: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 1713: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

1709:
1710: ----------------------- validate -----------------------
1711: IF (AMS_DEBUG_HIGH_ON) THEN
1712:
1713: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
1714: END IF;
1715:
1716: Validate_MediaChannel (
1717: p_api_version => l_api_version,

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

1757:
1758: -------------------------- insert --------------------------
1759: IF (AMS_DEBUG_HIGH_ON) THEN
1760:
1761: AMS_Utility_PVT.debug_message (l_full_name || ': insert');
1762: END IF;
1763: IF (AMS_DEBUG_HIGH_ON) THEN
1764:
1765: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_channel_id);

Line 1765: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_channel_id);

1761: AMS_Utility_PVT.debug_message (l_full_name || ': insert');
1762: END IF;
1763: IF (AMS_DEBUG_HIGH_ON) THEN
1764:
1765: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_channel_id);
1766: END IF;
1767: IF (AMS_DEBUG_HIGH_ON) THEN
1768:
1769: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_id);

Line 1769: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_id);

1765: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_channel_id);
1766: END IF;
1767: IF (AMS_DEBUG_HIGH_ON) THEN
1768:
1769: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_id);
1770: END IF;
1771: IF (AMS_DEBUG_HIGH_ON) THEN
1772:
1773: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.channel_id);

Line 1773: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.channel_id);

1769: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.media_id);
1770: END IF;
1771: IF (AMS_DEBUG_HIGH_ON) THEN
1772:
1773: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.channel_id);
1774: END IF;
1775: IF (AMS_DEBUG_HIGH_ON) THEN
1776:
1777: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_from_date);

Line 1777: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_from_date);

1773: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.channel_id);
1774: END IF;
1775: IF (AMS_DEBUG_HIGH_ON) THEN
1776:
1777: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_from_date);
1778: END IF;
1779: IF (AMS_DEBUG_HIGH_ON) THEN
1780:
1781: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_to_date);

Line 1781: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_to_date);

1777: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_from_date);
1778: END IF;
1779: IF (AMS_DEBUG_HIGH_ON) THEN
1780:
1781: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_to_date);
1782: END IF;
1783:
1784: INSERT INTO ams_media_channels (
1785: media_channel_id,

Line 1834: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1830: IF (AMS_DEBUG_HIGH_ON) THEN
1831:
1832:
1833:
1834: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1835:
1836: END IF;
1837:
1838: EXCEPTION

Line 1904: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1900: IF (AMS_DEBUG_HIGH_ON) THEN
1901:
1902:
1903:
1904: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1905:
1906: END IF;
1907:
1908: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 1926: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

1922:
1923: ----------------------- validate ----------------------
1924: IF (AMS_DEBUG_HIGH_ON) THEN
1925:
1926: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
1927: END IF;
1928:
1929: -- replace g_miss_char/num/date with current column values
1930: Complete_MediaChannel_Rec (p_mediachl_rec, l_mediachl_rec);

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

1975:
1976: -------------------------- update --------------------
1977: IF (AMS_DEBUG_HIGH_ON) THEN
1978:
1979: AMS_Utility_PVT.debug_message(l_full_name ||': update');
1980: END IF;
1981:
1982: -- Modified by ptendulk on 30Dec1999
1983: -- Check Obj Version Number before Updating

Line 2020: AMS_Utility_PVT.debug_message (l_full_name || ': End');

2016: IF (AMS_DEBUG_HIGH_ON) THEN
2017:
2018:
2019:
2020: AMS_Utility_PVT.debug_message (l_full_name || ': End');
2021:
2022: END IF;
2023:
2024: EXCEPTION

Line 2114: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

2110: IF (AMS_DEBUG_HIGH_ON) THEN
2111:
2112:
2113:
2114: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
2115:
2116: END IF;
2117:
2118: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 2136: AMS_Utility_PVT.debug_message (l_full_name || ': check before delete');

2132:
2133: -- holiu: add the following checking for bug 1350477
2134: IF (AMS_DEBUG_HIGH_ON) THEN
2135:
2136: AMS_Utility_PVT.debug_message (l_full_name || ': check before delete');
2137: END IF;
2138:
2139: OPEN c_in_use;
2140: FETCH c_in_use INTO l_in_use;

Line 2170: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');

2166:
2167: ------------------------ delete ------------------------
2168: IF (AMS_DEBUG_HIGH_ON) THEN
2169:
2170: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');
2171: END IF;
2172:
2173: DELETE FROM ams_media_channels
2174: WHERE media_channel_id = p_mediachl_id;

Line 2199: AMS_Utility_PVT.debug_message (l_full_name || ': End');

2195: IF (AMS_DEBUG_HIGH_ON) THEN
2196:
2197:
2198:
2199: AMS_Utility_PVT.debug_message (l_full_name || ': End');
2200:
2201: END IF;
2202:
2203: EXCEPTION

Line 2277: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

2273: BEGIN
2274: --------------------- initialize -----------------------
2275: IF (AMS_DEBUG_HIGH_ON) THEN
2276:
2277: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
2278: END IF;
2279:
2280: IF FND_API.to_boolean (p_init_msg_list) THEN
2281: FND_MSG_PUB.initialize;

Line 2298: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');

2294:
2295: ------------------------ lock -------------------------
2296: IF (AMS_DEBUG_HIGH_ON) THEN
2297:
2298: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');
2299: END IF;
2300:
2301: OPEN c_lock;
2302: FETCH c_lock INTO l_dummy;

Line 2324: AMS_Utility_PVT.debug_message (l_full_name || ': End');

2320: IF (AMS_DEBUG_HIGH_ON) THEN
2321:
2322:
2323:
2324: AMS_Utility_PVT.debug_message (l_full_name || ': End');
2325:
2326: END IF;
2327:
2328: EXCEPTION

Line 2329: WHEN AMS_Utility_PVT.resource_locked THEN

2325:
2326: END IF;
2327:
2328: EXCEPTION
2329: WHEN AMS_Utility_PVT.resource_locked THEN
2330: x_return_status := FND_API.g_ret_sts_error;
2331: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2332: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
2333: FND_MSG_PUB.add;

Line 2395: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

2391: BEGIN
2392: --------------------- initialize -----------------------
2393: IF (AMS_DEBUG_HIGH_ON) THEN
2394:
2395: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
2396: END IF;
2397:
2398: IF FND_API.to_boolean (p_init_msg_list) THEN
2399: FND_MSG_PUB.initialize;

Line 2416: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');

2412:
2413: ---------------------- validate ------------------------
2414: IF (AMS_DEBUG_HIGH_ON) 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 (

Line 2437: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');

2433: IF (AMS_DEBUG_HIGH_ON) THEN
2434:
2435:
2436:
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

Line 2466: AMS_Utility_PVT.debug_message (l_full_name || ': End');

2462: IF (AMS_DEBUG_HIGH_ON) THEN
2463:
2464:
2465:
2466: AMS_Utility_PVT.debug_message (l_full_name || ': End');
2467:
2468: END IF;
2469:
2470: EXCEPTION

Line 2846: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items start');

2842: BEGIN
2843: x_return_status := FND_API.g_ret_sts_success;
2844: IF (AMS_DEBUG_HIGH_ON) THEN
2845:
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

Line 2853: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items CREATE');

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;
2855: IF (AMS_DEBUG_HIGH_ON) THEN
2856:
2857: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);

Line 2857: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);

2853: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items CREATE');
2854: END IF;
2855: IF (AMS_DEBUG_HIGH_ON) THEN
2856:
2857: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);
2858: END IF;
2859: IF (AMS_DEBUG_HIGH_ON) THEN
2860:
2861: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);

Line 2861: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);

2857: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);
2858: END IF;
2859: IF (AMS_DEBUG_HIGH_ON) THEN
2860:
2861: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);
2862: END IF;
2863: /*
2864: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2865: 'ams_media_channels',

Line 2864: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

2860:
2861: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);
2862: END IF;
2863: /*
2864: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2865: 'ams_media_channels',
2866: 'media_id = ' || p_mediachl_rec.media_id
2867: || ' AND channel_id = ' || p_mediachl_rec.channel_id
2868: -- following two where clauses added by soagrawa on 15-jan-2002

Line 2883: AMS_Utility_PVT.debug_message('l_count is >'||l_count);

2879: IF (AMS_DEBUG_HIGH_ON) THEN
2880:
2881:
2882:
2883: AMS_Utility_PVT.debug_message('l_count is >'||l_count);
2884:
2885: END IF;
2886: IF l_count = 0
2887: THEN

Line 2896: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items UPDATE');

2892:
2893: ELSE
2894: IF (AMS_DEBUG_HIGH_ON) THEN
2895:
2896: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items UPDATE');
2897: END IF;
2898: IF (AMS_DEBUG_HIGH_ON) THEN
2899:
2900: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);

Line 2900: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);

2896: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items UPDATE');
2897: END IF;
2898: IF (AMS_DEBUG_HIGH_ON) THEN
2899:
2900: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);
2901: END IF;
2902: IF (AMS_DEBUG_HIGH_ON) THEN
2903:
2904: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);

Line 2904: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);

2900: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_id);
2901: END IF;
2902: IF (AMS_DEBUG_HIGH_ON) THEN
2903:
2904: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);
2905: END IF;
2906: IF (AMS_DEBUG_HIGH_ON) THEN
2907:
2908: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_channel_id);

Line 2908: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_channel_id);

2904: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);
2905: END IF;
2906: IF (AMS_DEBUG_HIGH_ON) THEN
2907:
2908: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.media_channel_id);
2909: END IF;
2910: --
2911: -- For UPDATE operations, make sure the
2912: -- uniqueness check excludes the current

Line 2915: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

2911: -- For UPDATE operations, make sure the
2912: -- uniqueness check excludes the current
2913: -- record.
2914: /*
2915: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2916: 'ams_media_channels',
2917: 'media_id = ' || p_mediachl_rec.media_id
2918: || ' AND channel_id = ' || p_mediachl_rec.channel_id
2919: || ' AND media_channel_id <> ' || p_mediachl_rec.media_channel_id

Line 2967: IF AMS_Utility_PVT.check_fk_exists (

2963:
2964: --
2965: -- MEDIA_ID
2966: IF p_mediachl_rec.media_id <> FND_API.g_miss_num THEN
2967: IF AMS_Utility_PVT.check_fk_exists (
2968: 'ams_media_b',
2969: 'media_id',
2970: p_mediachl_rec.media_id
2971: ) = FND_API.g_false

Line 2986: IF AMS_Utility_PVT.check_fk_exists (

2982:
2983: --
2984: -- CHANNEL_ID
2985: IF p_mediachl_rec.channel_id <> FND_API.g_miss_num THEN
2986: IF AMS_Utility_PVT.check_fk_exists (
2987: 'ams_channels_b',
2988: 'channel_id',
2989: p_mediachl_rec.channel_id
2990: ) = FND_API.g_false