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

Line 36: -- the AMS_Utility_PVT call with c_name_unique_cr,

32: -- 11/23/99 mpande Created.
33: -- 1. active_from_date,active_to_date and order_sequence are all for upgrade purposes only
34: -- so no validation is done for these columns
35: -- 08-Nov-2000 rrajesh Modified the uniqueness checking of channel_name, by replacing
36: -- the AMS_Utility_PVT call with c_name_unique_cr,
37: -- c_name_unique_up cursors.
38: -- 13-Dec-2000 rrajesh Changes for R4
39: -- 22-Dec-2000 rrajesh Removed the comments of internal channel flag.
40: -- 01/18/2001 rssharma Removed internal_resource attribute from the record and related code

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

78: IF (AMS_DEBUG_HIGH_ON) THEN
79:
80:
81:
82: AMS_Utility_PVT.debug_message(l_full_name||': start');
83:
84: END IF;
85:
86: IF FND_API.to_boolean(p_init_msg_list) THEN

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

100:
101: ----------------------- validate -----------------------
102: IF (AMS_DEBUG_HIGH_ON) THEN
103:
104: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
105: END IF;
106:
107: validate_channel(
108: p_api_version => l_api_version,

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

136:
137: -------------------------- insert --------------------------
138: IF (AMS_DEBUG_HIGH_ON) THEN
139:
140: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
141: END IF;
142:
143: -- Added by rrajesh on 12/07/00
144: --l_chan_rec.channel_type_code := 'INTERNAL'; --commented OUT NOCOPY by rrajesh on 12/22/00

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

284: IF (AMS_DEBUG_HIGH_ON) THEN
285:
286:
287:
288: AMS_Utility_PVT.debug_message(l_full_name ||': end');
289:
290: END IF;
291:
292: EXCEPTION

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

377: IF (AMS_DEBUG_HIGH_ON) THEN
378:
379:
380:
381: AMS_Utility_PVT.debug_message(l_full_name||': start');
382:
383: END IF;
384:
385: IF FND_API.to_boolean(p_init_msg_list) THEN

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

399:
400: -- holiu: the following checking is added for bug 1350477
401: IF (AMS_DEBUG_HIGH_ON) THEN
402:
403: AMS_Utility_PVT.debug_message(l_full_name ||': check before delete');
404: END IF;
405:
406: OPEN c_media_id;
407: FETCH c_media_id INTO l_media_id;

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

432: -- Bug fix:2089112. 10/31/01
433: ------------------------ delete ------------------------
434: IF (AMS_DEBUG_HIGH_ON) THEN
435:
436: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
437: END IF;
438:
439: DELETE FROM ams_channels_b
440: WHERE channel_id = p_chan_id

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

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

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

562:
563: -------------------- initialize ------------------------
564: IF (AMS_DEBUG_HIGH_ON) THEN
565:
566: AMS_Utility_PVT.debug_message(l_full_name||': start');
567: END IF;
568:
569: IF FND_API.to_boolean(p_init_msg_list) THEN
570: FND_MSG_PUB.initialize;

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

583:
584: ------------------------ lock -------------------------
585: IF (AMS_DEBUG_HIGH_ON) THEN
586:
587: AMS_Utility_PVT.debug_message(l_full_name||': lock');
588: END IF;
589:
590: OPEN c_chan_b;
591: FETCH c_chan_b INTO l_chan_id;

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

612: IF (AMS_DEBUG_HIGH_ON) THEN
613:
614:
615:
616: AMS_Utility_PVT.debug_message(l_full_name ||': end');
617:
618: END IF;
619:
620: EXCEPTION

Line 622: WHEN AMS_Utility_PVT.resource_locked THEN

618: END IF;
619:
620: EXCEPTION
621:
622: WHEN AMS_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
626: FND_MSG_PUB.add;

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

701: IF (AMS_DEBUG_HIGH_ON) THEN
702:
703:
704:
705: AMS_Utility_PVT.debug_message(l_full_name||': start');
706:
707: END IF;
708:
709: IF FND_API.to_boolean(p_init_msg_list) THEN

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

723:
724: ----------------------- validate ----------------------
725: IF (AMS_DEBUG_HIGH_ON) THEN
726:
727: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
728: END IF;
729:
730: -- replace g_miss_char/num/date with current column values
731: complete_chan_rec(p_chan_rec, l_chan_rec);

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

765: -- record level
766: -------------------------- update --------------------
767: IF (AMS_DEBUG_HIGH_ON) THEN
768:
769: AMS_Utility_PVT.debug_message(l_full_name ||': update');
770: END IF;
771:
772: -- Added by rrajesh on 12/07/00
773: --l_chan_rec.channel_type_code := 'INTERNAL'; -- commented out by rrajesh on 12/22/00

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

860: IF (AMS_DEBUG_HIGH_ON) THEN
861:
862:
863:
864: AMS_Utility_PVT.debug_message(l_full_name ||': end');
865:
866: END IF;
867:
868: EXCEPTION

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

935:
936: ----------------------- initialize --------------------
937: IF (AMS_DEBUG_HIGH_ON) THEN
938:
939: AMS_Utility_PVT.debug_message(l_full_name||': start');
940: END IF;
941:
942: IF FND_API.to_boolean(p_init_msg_list) THEN
943: FND_MSG_PUB.initialize;

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

956:
957: ---------------------- validate ------------------------
958: IF (AMS_DEBUG_HIGH_ON) THEN
959:
960: AMS_Utility_PVT.debug_message(l_full_name||': check items');
961: END IF;
962:
963: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
964: check_chan_items(

Line 981: AMS_Utility_PVT.debug_message(l_full_name||': check Records');

977: -- Following call is added by ptendulk on Jul 13th 2000 Ref: Bug#1353602
978: --=============================================================================
979: IF (AMS_DEBUG_HIGH_ON) THEN
980:
981: AMS_Utility_PVT.debug_message(l_full_name||': check Records');
982: END IF;
983: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
984: Check_Chan_Record(
985: p_chan_rec => p_chan_rec,

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

1004: IF (AMS_DEBUG_HIGH_ON) THEN
1005:
1006:
1007:
1008: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1009:
1010: END IF;
1011:
1012: EXCEPTION

Line 1160: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count - begin'); END IF;

1156: -- end rrajesh 11/08
1157:
1158: BEGIN
1159: x_return_status := FND_API.g_ret_sts_success;
1160: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count - begin'); END IF;
1161: -- For create_channel, when channel_id is passed in, we need to
1162: -- check if this channel_id is unique.
1163: IF p_validation_mode = JTF_PLSQL_API.g_create
1164: AND p_chan_rec.channel_id IS NOT NULL

Line 1166: IF AMS_Utility_PVT.check_uniqueness(

1162: -- check if this channel_id is unique.
1163: IF p_validation_mode = JTF_PLSQL_API.g_create
1164: AND p_chan_rec.channel_id IS NOT NULL
1165: THEN
1166: IF AMS_Utility_PVT.check_uniqueness(
1167: 'ams_channels_vl',
1168: 'channel_id = ' || p_chan_rec.channel_id
1169: ) = FND_API.g_false
1170: THEN

Line 1186: -- rrajesh start 11/08. Replaced the AMS_Utility_PVT call

1182: -- Check if channel_name is unique. Need to handle create and
1183: -- update differently.
1184: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1185:
1186: -- rrajesh start 11/08. Replaced the AMS_Utility_PVT call
1187: -- with the new cursor.
1188: --modified by rrajesh on 12/07/00
1189: --OPEN c_name_unique_cr(p_chan_rec.channel_name) ;
1190: OPEN c_name_unique_cr(p_chan_rec.channel_name, p_chan_rec.country_id) ;

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

1191: -- end 12/07/00
1192: FETCH c_name_unique_cr INTO l_count ;
1193: CLOSE c_name_unique_cr ;
1194:
1195: --l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1196: -- 'ams_channels_vl',
1197: -- 'channel_name = ''' || p_chan_rec.channel_name ||''''
1198: --);
1199: ELSE

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

1196: -- 'ams_channels_vl',
1197: -- 'channel_name = ''' || p_chan_rec.channel_name ||''''
1198: --);
1199: ELSE
1200: --l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1201: -- 'ams_channels_vl',
1202: -- 'channel_name = ''' || p_chan_rec.channel_name ||
1203: -- ''' AND channel_id <> ' || p_chan_rec.channel_id
1204: --);

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

1212: END IF;
1213:
1214: -- rrajesh start 11/08. Checking the uniqueness against the new cursor,
1215: -- c_name_unique_up
1216: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count '|| l_count ); END IF;
1217: IF l_count > 0 THEN
1218: --IF l_valid_flag = FND_API.g_false THEN
1219: -- rrajesh end 11/08
1220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1252: IF AMS_Utility_PVT.check_fk_exists(

1248: x_return_status := FND_API.g_ret_sts_success;
1249:
1250: ----------------------- managed_by_person_id ------------------------
1251: IF p_chan_rec.managed_by_person_id <> FND_API.g_miss_num THEN
1252: IF AMS_Utility_PVT.check_fk_exists(
1253: 'ams_jtf_rs_emp_v',
1254: 'resource_id',
1255: p_chan_rec.managed_by_person_id
1256: ) = FND_API.g_false

Line 1270: IF AMS_Utility_PVT.check_fk_exists(

1266: END IF;
1267:
1268: --------------------- preferred_vendor_id ------------------------
1269: IF p_chan_rec.preferred_vendor_id <> FND_API.g_miss_num THEN
1270: IF AMS_Utility_PVT.check_fk_exists(
1271: 'po_vendors',
1272: 'vendor_id',
1273: p_chan_rec.preferred_vendor_id
1274: ) = FND_API.g_false

Line 1287: IF AMS_Utility_PVT.check_fk_exists(

1283: END IF;
1284: END IF;
1285: --------------------- party_id ------------------------
1286: IF p_chan_rec.party_id <> FND_API.g_miss_num THEN
1287: IF AMS_Utility_PVT.check_fk_exists(
1288: 'HZ_PARTIES',
1289: 'party_id',
1290: p_chan_rec.party_id
1291: ) = FND_API.g_false

Line 1308: IF AMS_Utility_PVT.check_fk_exists(

1304: --------------------- country_id ------------------------
1305: IF p_chan_rec.country_id <> FND_API.g_miss_num THEN
1306:
1307: -- modified by soagrawa on 31-May-2001
1308: IF AMS_Utility_PVT.check_fk_exists(
1309: p_table_name => 'jtf_loc_hierarchies_vl', --'jtf_loc_areas_vl',
1310: p_pk_name => 'location_hierarchy_id', --'location_area_id',
1311: p_pk_value => p_chan_rec.country_id,
1312: p_pk_data_type => AMS_Utility_PVT.G_NUMBER,

Line 1312: p_pk_data_type => AMS_Utility_PVT.G_NUMBER,

1308: IF AMS_Utility_PVT.check_fk_exists(
1309: p_table_name => 'jtf_loc_hierarchies_vl', --'jtf_loc_areas_vl',
1310: p_pk_name => 'location_hierarchy_id', --'location_area_id',
1311: p_pk_value => p_chan_rec.country_id,
1312: p_pk_data_type => AMS_Utility_PVT.G_NUMBER,
1313: -- modified by soagrawa on 28-sep-2001, bug# 2021940
1314: p_additional_where_clause => ' location_type_code = ''COUNTRY'' ' --' location_type_name = ''Country'' '
1315: ) = FND_API.g_false
1316: THEN

Line 1350: IF AMS_Utility_PVT.check_lookup_exists(

1346: x_return_status := FND_API.g_ret_sts_success;
1347:
1348: ----------------------- channel_type_code ------------------------
1349: IF p_chan_rec.channel_type_code <> FND_API.g_miss_char THEN
1350: IF AMS_Utility_PVT.check_lookup_exists(
1351: p_lookup_type => 'AMS_CHANNEL_TYPE',
1352: p_lookup_code => p_chan_rec.channel_type_code
1353: ) = FND_API.g_false
1354: THEN

Line 1369: IF AMS_Utility_PVT.check_lookup_exists(

1365: ----------------------- rating ------------------------
1366: IF p_chan_rec.rating <> FND_API.g_miss_char
1367: AND p_chan_rec.rating IS NOT NULL
1368: THEN
1369: IF AMS_Utility_PVT.check_lookup_exists(
1370: p_lookup_type => 'AMS_CHANNEL_RATING',
1371: p_lookup_code => p_chan_rec.rating
1372: ) = FND_API.g_false
1373: THEN

Line 1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false

1406: ----------------------- outbound_flag ------------------------
1407: IF p_chan_rec.outbound_flag <> FND_API.g_miss_char
1408: AND p_chan_rec.outbound_flag IS NOT NULL
1409: THEN
1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false
1411: THEN
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1413: THEN
1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');

Line 1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false

1422: ----------------------- inbound_flag ------------------------
1423: IF p_chan_rec.inbound_flag <> FND_API.g_miss_char
1424: AND p_chan_rec.inbound_flag IS NOT NULL
1425: THEN
1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false
1427: THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');

Line 1973: AMS_Utility_PVT.debug_message('arg in get_country_name() :' || p_country_id);

1969:
1970: BEGIN
1971: IF (AMS_DEBUG_HIGH_ON) THEN
1972:
1973: AMS_Utility_PVT.debug_message('arg in get_country_name() :' || p_country_id);
1974: END IF;
1975:
1976: IF p_country_id IS NULL THEN
1977: RETURN NULL;