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

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

105: --------------------- initialize -----------------------
106: SAVEPOINT Create_User_Status;
107: IF (AMS_DEBUG_HIGH_ON) THEN
108:
109: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
110: END IF;
111: IF FND_API.to_boolean (p_init_msg_list) THEN
112: FND_MSG_PUB.initialize;
113: END IF;

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

122: x_return_status := FND_API.g_ret_sts_success;
123: ----------------------- validate -----------------------
124: IF (AMS_DEBUG_HIGH_ON) THEN
125:
126: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
127: END IF;
128:
129:
130:

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

167: END IF;
168: -------------------------- insert --------------------------
169: IF (AMS_DEBUG_HIGH_ON) THEN
170:
171: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
172: END IF;
173: --
174: -- Insert into mutli-language supported table.
175: --

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

254: p_data => x_msg_data
255: );
256: IF (AMS_DEBUG_HIGH_ON) THEN
257:
258: AMS_Utility_PVT.debug_message (l_full_name || ': End');
259: END IF;
260: EXCEPTION
261: WHEN FND_API.g_exc_error THEN
262: ROLLBACK TO Create_User_Status;

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

313: --------------------- initialize -----------------------
314: SAVEPOINT Update_User_Status;
315: IF (AMS_DEBUG_HIGH_ON) THEN
316:
317: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
318: END IF;
319: IF FND_API.to_boolean (p_init_msg_list) THEN
320: FND_MSG_PUB.initialize;
321: END IF;

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

330: x_return_status := FND_API.g_ret_sts_success;
331: ----------------------- validate ----------------------
332: IF (AMS_DEBUG_HIGH_ON) THEN
333:
334: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
335: END IF;
336: -- replace g_miss_char/num/date with current column values
337: Complete_User_Status_Rec (p_user_status_rec, l_user_status_rec);
338:

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

390: seed_needs_update(l_user_status_rec) = FND_API.g_true THEN
391: -------------------------- update --------------------
392: IF (AMS_DEBUG_HIGH_ON) THEN
393:
394: AMS_Utility_PVT.debug_message (l_full_name || ': Update');
395: END IF;
396:
397: -- Check to see if the user status can be disabled
398: IF NVL(l_user_status_rec.enabled_flag,'Y') = 'N' THEN

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

457: p_data => x_msg_data
458: );
459: IF (AMS_DEBUG_HIGH_ON) THEN
460:
461: AMS_Utility_PVT.debug_message (l_full_name || ': End');
462: END IF;
463: EXCEPTION
464: WHEN FND_API.g_exc_error THEN
465: ROLLBACK TO Update_User_Status;

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

536: --------------------- initialize -----------------------
537: SAVEPOINT Delete_User_Status;
538: IF (AMS_DEBUG_HIGH_ON) THEN
539:
540: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
541: END IF;
542: IF FND_API.to_boolean (p_init_msg_list) THEN
543: FND_MSG_PUB.initialize;
544: END IF;

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

553: x_return_status := FND_API.g_ret_sts_success;
554: ------------------------ delete ------------------------
555: IF (AMS_DEBUG_HIGH_ON) THEN
556:
557: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');
558: END IF;
559: -- Delete TL data
560:
561: IF l_user_status_rec.seeded_flag='N'

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

595: p_data => x_msg_data
596: );
597: IF (AMS_DEBUG_HIGH_ON) THEN
598:
599: AMS_Utility_PVT.debug_message (l_full_name || ': End');
600: END IF;
601: EXCEPTION
602: WHEN FND_API.g_exc_error THEN
603: ROLLBACK TO Delete_User_Status;

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

665: BEGIN
666: --------------------- initialize -----------------------
667: IF (AMS_DEBUG_HIGH_ON) THEN
668:
669: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
670: END IF;
671: IF FND_API.to_boolean (p_init_msg_list) THEN
672: FND_MSG_PUB.initialize;
673: END IF;

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

682: x_return_status := FND_API.g_ret_sts_success;
683: ------------------------ lock -------------------------
684: IF (AMS_DEBUG_HIGH_ON) THEN
685:
686: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');
687: END IF;
688: OPEN c_lock;
689: FETCH c_lock INTO l_dummy;
690: IF (c_lock%NOTFOUND) THEN

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

703: p_data => x_msg_data
704: );
705: IF (AMS_DEBUG_HIGH_ON) THEN
706:
707: AMS_Utility_PVT.debug_message (l_full_name || ': End');
708: END IF;
709: EXCEPTION
710: WHEN AMS_Utility_PVT.resource_locked THEN
711: x_return_status := FND_API.g_ret_sts_error;

Line 710: WHEN AMS_Utility_PVT.resource_locked THEN

706:
707: AMS_Utility_PVT.debug_message (l_full_name || ': End');
708: END IF;
709: EXCEPTION
710: WHEN AMS_Utility_PVT.resource_locked THEN
711: x_return_status := FND_API.g_ret_sts_error;
712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
714: FND_MSG_PUB.add;

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

767: BEGIN
768: --------------------- initialize -----------------------
769: IF (AMS_DEBUG_HIGH_ON) THEN
770:
771: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
772: END IF;
773: IF FND_API.to_boolean (p_init_msg_list) THEN
774: FND_MSG_PUB.initialize;
775: END IF;

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

784: x_return_status := FND_API.g_ret_sts_success;
785: ---------------------- validate ------------------------
786: IF (AMS_DEBUG_HIGH_ON) THEN
787:
788: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
789: END IF;
790: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
791: Check_User_Status_Items (
792: p_user_status_rec => p_user_status_rec,

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

800: END IF;
801: END IF;
802: IF (AMS_DEBUG_HIGH_ON) THEN
803:
804: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
805: END IF;
806: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
807: Check_User_Status_Record (
808: p_user_status_rec => p_user_status_rec,

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

822: p_data => x_msg_data
823: );
824: IF (AMS_DEBUG_HIGH_ON) THEN
825:
826: AMS_Utility_PVT.debug_message (l_full_name || ': End');
827: END IF;
828: EXCEPTION
829: WHEN FND_API.g_exc_error THEN
830: x_return_status := FND_API.g_ret_sts_error;

Line 964: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.DEBUG_MESSAGE('sTART DATE:'|| to_char(l_start_date_active,'DD_MON_YYYY'));END IF;

960: IF (l_end_date_active IS NULL OR l_end_date_active = FND_API.g_miss_date) THEN
961: l_end_date_active := p_complete_rec.end_date_active;
962: END IF;
963: */
964: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.DEBUG_MESSAGE('sTART DATE:'|| to_char(l_start_date_active,'DD_MON_YYYY'));END IF;
965: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.DEBUG_MESSAGE('end DATE:'|| to_char(l_end_date_active,'DD-MON-YYYY'));END IF;
966:
967: IF l_start_date_active IS NOT NULL AND l_end_date_active IS NOT NULL THEN
968: IF l_start_date_active > l_end_date_active THEN

Line 965: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.DEBUG_MESSAGE('end DATE:'|| to_char(l_end_date_active,'DD-MON-YYYY'));END IF;

961: l_end_date_active := p_complete_rec.end_date_active;
962: END IF;
963: */
964: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.DEBUG_MESSAGE('sTART DATE:'|| to_char(l_start_date_active,'DD_MON_YYYY'));END IF;
965: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.DEBUG_MESSAGE('end DATE:'|| to_char(l_end_date_active,'DD-MON-YYYY'));END IF;
966:
967: IF l_start_date_active IS NOT NULL AND l_end_date_active IS NOT NULL THEN
968: IF l_start_date_active > l_end_date_active THEN
969: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1102: AMS_UTILITY_PVT.DEBUG_MESSAGE('sTART DATE:'|| to_char(l_user_status_rec.start_date_active,'DD_MON_YYYY'));

1098:
1099: BEGIN
1100: IF (AMS_DEBUG_HIGH_ON) THEN
1101:
1102: AMS_UTILITY_PVT.DEBUG_MESSAGE('sTART DATE:'|| to_char(l_user_status_rec.start_date_active,'DD_MON_YYYY'));
1103: END IF;
1104: IF (AMS_DEBUG_HIGH_ON) THEN
1105:
1106: AMS_UTILITY_PVT.DEBUG_MESSAGE('end DATE:'|| to_char(l_user_status_rec.end_Date_active,'DD-MON-YYYY'));

Line 1106: AMS_UTILITY_PVT.DEBUG_MESSAGE('end DATE:'|| to_char(l_user_status_rec.end_Date_active,'DD-MON-YYYY'));

1102: AMS_UTILITY_PVT.DEBUG_MESSAGE('sTART DATE:'|| to_char(l_user_status_rec.start_date_active,'DD_MON_YYYY'));
1103: END IF;
1104: IF (AMS_DEBUG_HIGH_ON) THEN
1105:
1106: AMS_UTILITY_PVT.DEBUG_MESSAGE('end DATE:'|| to_char(l_user_status_rec.end_Date_active,'DD-MON-YYYY'));
1107: END IF;
1108:
1109: if l_user_status_rec.start_date_active is NOT NULL then
1110: if l_user_status_rec.end_Date_active is NOT NULL then

Line 1263: IF AMS_Utility_PVT.check_uniqueness(

1259: -- check if this ID is unique.
1260: IF p_validation_mode = JTF_PLSQL_API.g_create
1261: AND p_user_status_rec.user_status_id IS NOT NULL
1262: THEN
1263: IF AMS_Utility_PVT.check_uniqueness(
1264: 'ams_user_statuses_vl',
1265: 'user_status_id = ' || p_user_status_rec.user_status_id
1266: ) = FND_API.g_false
1267: THEN

Line 1279: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

1275: END IF;
1276: -- check if NAME is UNIQUE
1277: -- modified sugupta 02/22/2000 UNIQUENESS OF NAME LIMITED TO THAT ACTIVITY TYPE
1278: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1279: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1280: 'ams_user_statuses_vl',
1281: 'name = ''' || p_user_status_rec.name ||
1282: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type || ''''
1283: );

Line 1285: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

1281: 'name = ''' || p_user_status_rec.name ||
1282: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type || ''''
1283: );
1284: ELSE
1285: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1286: 'ams_user_statuses_vl',
1287: 'name = ''' || p_user_status_rec.name ||
1288: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type ||
1289: ''' AND user_status_id <> ' || p_user_status_rec.user_status_id

Line 1328: IF AMS_Utility_PVT.check_lookup_exists (

1324: -- SYSTEM_STATUS_TYPE
1325: l_system_status_type := p_user_status_rec.system_status_type;
1326: IF p_user_status_rec.system_status_code <> FND_API.g_miss_char THEN
1327: /* changed by BGEORGE 6/17/2002
1328: IF AMS_Utility_PVT.check_lookup_exists (
1329: p_lookup_type => l_system_status_type,
1330: p_lookup_code => p_user_status_rec.system_status_code
1331: ) = FND_API.g_false
1332: */

Line 1333: IF AMS_Utility_PVT.check_lookup_exists(

1329: p_lookup_type => l_system_status_type,
1330: p_lookup_code => p_user_status_rec.system_status_code
1331: ) = FND_API.g_false
1332: */
1333: IF AMS_Utility_PVT.check_lookup_exists(
1334: p_lookup_type => l_system_status_type,
1335: p_lookup_code => p_user_status_rec.system_status_code,
1336: p_view_application_id => fnd_global.resp_appl_id
1337: ) = FND_API.g_false

Line 1358: IF AMS_Utility_PVT.is_Y_or_N (p_user_status_rec.default_flag) = FND_API.g_false THEN

1354: BEGIN
1355: x_return_status := FND_API.g_ret_sts_success;
1356: -- DEFAULT_FLAG
1357: IF p_user_status_rec.default_flag <> FND_API.g_miss_char AND p_user_status_rec.default_flag IS NOT NULL THEN
1358: IF AMS_Utility_PVT.is_Y_or_N (p_user_status_rec.default_flag) = FND_API.g_false THEN
1359: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1360: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_DEFAULT_FLAG');
1361: FND_MSG_PUB.add;
1362: END IF;

Line 1369: IF AMS_Utility_PVT.is_Y_or_N (p_user_status_rec.enabled_flag) = FND_API.g_false THEN

1365: END IF;
1366: END IF;
1367: -- ENABLED_FLAG
1368: IF p_user_status_rec.enabled_flag <> FND_API.g_miss_char AND p_user_status_rec.enabled_flag IS NOT NULL THEN
1369: IF AMS_Utility_PVT.is_Y_or_N (p_user_status_rec.enabled_flag) = FND_API.g_false THEN
1370: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1371: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_ENABLED_FLAG');
1372: FND_MSG_PUB.add;
1373: END IF;