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

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

56: IF (AMS_DEBUG_HIGH_ON) THEN
57:
58:
59:
60: AMS_Utility_PVT.debug_message(l_full_name || ': start');
61:
62: END IF;
63:
64: IF NOT FND_API.compatible_api_call

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

76:
77: -- validate
78: IF (AMS_DEBUG_HIGH_ON) THEN
79:
80: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
81: END IF;
82:
83: validate_cust_setup
84: (

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

114:
115: -- insert
116: IF (AMS_DEBUG_HIGH_ON) THEN
117:
118: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
119: END IF;
120:
121: INSERT INTO AMS_CUSTOM_SETUPS_B
122: (

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

543: IF (AMS_DEBUG_HIGH_ON) THEN
544:
545:
546:
547: AMS_Utility_PVT.debug_message(l_full_name||': end');
548:
549: END IF;
550:
551: EXCEPTION

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

624: IF (AMS_DEBUG_HIGH_ON) THEN
625:
626:
627:
628: AMS_Utility_PVT.debug_message(l_full_name || ': start');
629:
630: END IF;
631:
632: IF NOT FND_API.compatible_api_call

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

662: -- validate
663: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
664: IF (AMS_DEBUG_HIGH_ON) THEN
665:
666: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
667: END IF;
668: IF (AMS_DEBUG_HIGH_ON) THEN
669:
670: AMS_Utility_PVT.debug_message(l_full_name || ': check items');

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

666: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
667: END IF;
668: IF (AMS_DEBUG_HIGH_ON) THEN
669:
670: AMS_Utility_PVT.debug_message(l_full_name || ': check items');
671: END IF;
672: check_items
673: (
674: p_validation_mode => JTF_PLSQL_API.g_update,

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

686:
687: -- update
688: IF (AMS_DEBUG_HIGH_ON) THEN
689:
690: AMS_Utility_PVT.debug_message(l_full_name||': update');
691: END IF;
692:
693: UPDATE AMS_CUSTOM_SETUPS_B SET
694: last_update_date = SYSDATE,

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

746: IF (AMS_DEBUG_HIGH_ON) THEN
747:
748:
749:
750: AMS_Utility_PVT.debug_message(l_full_name || ': end');
751:
752: END IF;
753:
754: EXCEPTION

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

837: IF (AMS_DEBUG_HIGH_ON) THEN
838:
839:
840:
841: AMS_Utility_PVT.debug_message(l_full_name || ': start');
842:
843: END IF;
844:
845: IF NOT FND_API.compatible_api_call

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

866:
867: -- delete
868: IF (AMS_DEBUG_HIGH_ON) THEN
869:
870: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
871: END IF;
872:
873: OPEN c_is_used_count(p_cust_setup_id);
874: FETCH c_is_used_count INTO l_is_used_count;

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

942: IF (AMS_DEBUG_HIGH_ON) THEN
943:
944:
945:
946: AMS_Utility_PVT.debug_message(l_full_name || ': end');
947:
948: END IF;
949:
950: EXCEPTION

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

1027: BEGIN
1028: -- initialize
1029: IF (AMS_DEBUG_HIGH_ON) THEN
1030:
1031: AMS_Utility_PVT.debug_message(l_full_name || ': start');
1032: END IF;
1033:
1034: IF FND_API.to_boolean(p_init_msg_list) THEN
1035: FND_MSG_PUB.initialize;

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

1050:
1051: -- lock
1052: IF (AMS_DEBUG_HIGH_ON) THEN
1053:
1054: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
1055: END IF;
1056:
1057: OPEN c_cust_setup_b;
1058: FETCH c_cust_setup_b INTO l_cust_setup_id;

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

1089: IF (AMS_DEBUG_HIGH_ON) THEN
1090:
1091:
1092:
1093: AMS_Utility_PVT.debug_message(l_full_name || ': end');
1094:
1095: END IF;
1096:
1097: EXCEPTION

Line 1099: WHEN AMS_Utility_PVT.resource_locked THEN

1095: END IF;
1096:
1097: EXCEPTION
1098:
1099: WHEN AMS_Utility_PVT.resource_locked THEN
1100: x_return_status := FND_API.g_ret_sts_error;
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1103: FND_MSG_PUB.add;

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

1173:
1174: ----------------------- initialize --------------------
1175: IF (AMS_DEBUG_HIGH_ON) THEN
1176:
1177: AMS_Utility_PVT.debug_message(l_full_name||': start');
1178: END IF;
1179:
1180: -- IF FND_API.to_boolean(p_init_msg_list) THEN
1181: -- FND_MSG_PUB.initialize;

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

1197: ---------------------- validate ------------------------
1198: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1199: IF (AMS_DEBUG_HIGH_ON) THEN
1200:
1201: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1202: END IF;
1203: check_items
1204: (
1205: p_validation_mode => JTF_PLSQL_API.g_create,

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

1225: IF (AMS_DEBUG_HIGH_ON) THEN
1226:
1227:
1228:
1229: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1230:
1231: END IF;
1232:
1233: EXCEPTION

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

1286: BEGIN
1287: -- initialize
1288: IF (AMS_DEBUG_HIGH_ON) THEN
1289:
1290: AMS_Utility_PVT.debug_message(l_full_name || ': start');
1291: END IF;
1292:
1293: x_return_status := FND_API.g_ret_sts_success;
1294:

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

1294:
1295: -- check required items
1296: IF (AMS_DEBUG_HIGH_ON) THEN
1297:
1298: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
1299: END IF;
1300: check_cust_setup_req_items
1301: (
1302: p_validation_mode => p_validation_mode,

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

1310:
1311: -- check unique key items
1312: IF (AMS_DEBUG_HIGH_ON) THEN
1313:
1314: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');
1315: END IF;
1316: check_cust_setup_uk_items
1317: (
1318: p_validation_mode => p_validation_mode,

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

1326:
1327: -- check foreign key items
1328: IF (AMS_DEBUG_HIGH_ON) THEN
1329:
1330: AMS_Utility_PVT.debug_message(l_full_name || ': check fk items');
1331: END IF;
1332: check_cust_setup_fk_items
1333: (
1334: p_cust_setup_rec => p_cust_setup_rec,

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

1341:
1342: -- check flags
1343: IF (AMS_DEBUG_HIGH_ON) THEN
1344:
1345: AMS_Utility_PVT.debug_message(l_full_name || ': check flag items');
1346: END IF;
1347: check_cust_setup_flag_items
1348: (
1349: p_cust_setup_rec => p_cust_setup_rec,

Line 1504: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1500: -- check PK, if custom_setup_id is passed in, must check if it is duplicATE
1501: IF p_validation_mode = JTF_PLSQL_API.g_create
1502: AND p_cust_setup_rec.custom_setup_id IS NOT NULL
1503: THEN
1504: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1505: (
1506: 'AMS_CUSTOM_SETUPS_VL',
1507: 'custom_setup_id = ' || p_cust_setup_rec.custom_setup_id
1508: );

Line 1524: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1520:
1521: -- check custom_setup_id
1522: /*************** commented by abhola
1523: IF p_cust_setup_rec.custom_setup_id IS NOT NULL THEN -- UPDATE RECORD
1524: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1525: (
1526: 'AMS_CUSTOM_SETUPS_TL',
1527: 'custom_setup_id <> ' || p_cust_setup_rec.custom_setup_id
1528: || ' AND setup_name = ''' || p_cust_setup_rec.setup_name

Line 1532: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1528: || ' AND setup_name = ''' || p_cust_setup_rec.setup_name
1529: || ''' AND language = ''' || USERENV('LANG') ||''''
1530: );
1531: ELSE -- NEW RECORD
1532: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1533: (
1534: 'AMS_CUSTOM_SETUPS_TL',
1535: 'setup_name = ''' || p_cust_setup_rec.setup_name
1536: || ''' AND language = ''' || USERENV('LANG') ||''''

Line 1610: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1606: IF p_cust_setup_rec.media_id IS NOT NULL THEN
1607: -- DELV condition added by rrajesh on 07/21/01
1608: -- And moved ams_media_b check in else condition
1609: IF p_cust_setup_rec.object_type = 'DELV' THEN
1610: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1611: (
1612: 'AMS_CATEGORIES_B',
1613: 'category_id',
1614: p_cust_setup_rec.media_id

Line 1617: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1613: 'category_id',
1614: p_cust_setup_rec.media_id
1615: );
1616: ELSE
1617: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1618: (
1619: 'AMS_MEDIA_B',
1620: 'media_id',
1621: p_cust_setup_rec.media_id