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

Line 1914: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1910:
1911: -- Debug Message
1912: IF (AMS_DEBUG_HIGH_ON) THEN
1913:
1914: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1915: END IF;
1916:
1917:
1918: -- Initialize API return status to SUCCESS

Line 1945: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

1941: -- Validate Environment
1942: -- =========================================================================
1943:
1944: IF FND_GLOBAL.User_Id IS NULL THEN
1945: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1953: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Entries');

1949: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1950: -- Debug message
1951: IF (AMS_DEBUG_HIGH_ON) THEN
1952:
1953: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Entries');
1954: END IF;
1955:
1956: -- Invoke validation procedures
1957: Validate_list_entries(

Line 1972: AMS_UTILITY_PVT.debug_message('Private API: After Validate' );

1968: IF (AMS_DEBUG_HIGH_ON) THEN
1969:
1970:
1971:
1972: AMS_UTILITY_PVT.debug_message('Private API: After Validate' );
1973:
1974: END IF;
1975: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1976: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1978: AMS_UTILITY_PVT.debug_message('Private API: After Validate failed' );

1974: END IF;
1975: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1976: IF (AMS_DEBUG_HIGH_ON) THEN
1977:
1978: AMS_UTILITY_PVT.debug_message('Private API: After Validate failed' );
1979: END IF;
1980: RAISE FND_API.G_EXC_ERROR;
1981: END IF;
1982:

Line 1987: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

1983:
1984: -- Debug Message
1985: IF (AMS_DEBUG_HIGH_ON) THEN
1986:
1987: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1988: END IF;
1989:
1990: -- batoleti coding starts for bug# 6688996
1991: l_created_by := 0;

Line 2399: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

2395: END IF;
2396: -- Debug Message
2397: IF (AMS_DEBUG_HIGH_ON) THEN
2398:
2399: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2400: END IF;
2401:
2402: -- Standard call to get message count and if count is 1, get message info.
2403: FND_MSG_PUB.Count_And_Get

Line 2409: WHEN AMS_Utility_PVT.resource_locked THEN

2405: p_data => x_msg_data
2406: );
2407: EXCEPTION
2408:
2409: WHEN AMS_Utility_PVT.resource_locked THEN
2410: x_return_status := FND_API.g_ret_sts_error;
2411: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2412:
2413: WHEN FND_API.G_EXC_ERROR THEN

Line 2411: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2407: EXCEPTION
2408:
2409: WHEN AMS_Utility_PVT.resource_locked THEN
2410: x_return_status := FND_API.g_ret_sts_error;
2411: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2412:
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO CREATE_List_Entries_PVT;
2415: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2505: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2501:
2502: -- Debug Message
2503: IF (AMS_DEBUG_HIGH_ON) THEN
2504:
2505: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2506: END IF;
2507:
2508:
2509: -- Initialize API return status to SUCCESS

Line 2515: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

2511:
2512: -- Debug Message
2513: IF (AMS_DEBUG_HIGH_ON) THEN
2514:
2515: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
2516: END IF;
2517:
2518: OPEN c_get_List_Entries( l_tar_list_entries_rec.list_entry_id);
2519:

Line 2523: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

2519:
2520: FETCH c_get_List_Entries INTO l_ref_list_entries_rec ;
2521:
2522: If ( c_get_List_Entries%NOTFOUND) THEN
2523: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
2524: p_token_name => 'INFO',
2525: p_token_value => 'List_Entries' || P_list_entries_rec.list_entry_id) ;
2526: RAISE FND_API.G_EXC_ERROR;
2527: END IF;

Line 2531: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

2527: END IF;
2528: -- Debug Message
2529: IF (AMS_DEBUG_HIGH_ON) THEN
2530:
2531: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
2532: END IF;
2533: CLOSE c_get_List_Entries;
2534:
2535:

Line 2538: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

2534:
2535:
2536: If (l_tar_list_entries_rec.object_version_number is NULL or
2537: l_tar_list_entries_rec.object_version_number = FND_API.G_MISS_NUM ) Then
2538: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
2539: p_token_name => 'COLUMN',
2540: p_token_value => 'object_version_number') ;
2541: raise FND_API.G_EXC_ERROR;
2542: End if;

Line 2545: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

2541: raise FND_API.G_EXC_ERROR;
2542: End if;
2543: -- Check Whether record has been changed by someone else
2544: If (l_tar_list_entries_rec.object_version_number <> l_ref_list_entries_rec.object_version_number) Then
2545: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
2546: p_token_name => 'INFO',
2547: p_token_value => 'List_Entries') ;
2548: raise FND_API.G_EXC_ERROR;
2549: End if;

Line 2559: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Entries');

2555: THEN
2556: -- Debug message
2557: IF (AMS_DEBUG_HIGH_ON) THEN
2558:
2559: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Entries');
2560: END IF;
2561:
2562: -- Invoke validation procedures
2563: Validate_list_entries(

Line 2989: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

2985:
2986: -- Debug Message
2987: IF (AMS_DEBUG_HIGH_ON) THEN
2988:
2989: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2990: END IF;
2991:
2992: -- Standard call to get message count and if count is 1, get message info.
2993: FND_MSG_PUB.Count_And_Get

Line 2999: WHEN AMS_Utility_PVT.resource_locked THEN

2995: p_data => x_msg_data
2996: );
2997: EXCEPTION
2998:
2999: WHEN AMS_Utility_PVT.resource_locked THEN
3000: x_return_status := FND_API.g_ret_sts_error;
3001: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3002:
3003: WHEN FND_API.G_EXC_ERROR THEN

Line 3001: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2997: EXCEPTION
2998:
2999: WHEN AMS_Utility_PVT.resource_locked THEN
3000: x_return_status := FND_API.g_ret_sts_error;
3001: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3002:
3003: WHEN FND_API.G_EXC_ERROR THEN
3004: ROLLBACK TO UPDATE_List_Entries_PVT;
3005: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3078: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3074:
3075: -- Debug Message
3076: IF (AMS_DEBUG_HIGH_ON) THEN
3077:
3078: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3079: END IF;
3080:
3081:
3082: -- Initialize API return status to SUCCESS

Line 3091: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

3087: --
3088: -- Debug Message
3089: IF (AMS_DEBUG_HIGH_ON) THEN
3090:
3091: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
3092: END IF;
3093:
3094: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Delete_Row)
3095: AMS_LIST_ENTRIES_PKG.Delete_Row(

Line 3111: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3107:
3108: -- Debug Message
3109: IF (AMS_DEBUG_HIGH_ON) THEN
3110:
3111: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3112: END IF;
3113:
3114: -- Standard call to get message count and if count is 1, get message info.
3115: FND_MSG_PUB.Count_And_Get

Line 3121: WHEN AMS_Utility_PVT.resource_locked THEN

3117: p_data => x_msg_data
3118: );
3119: EXCEPTION
3120:
3121: WHEN AMS_Utility_PVT.resource_locked THEN
3122: x_return_status := FND_API.g_ret_sts_error;
3123: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3124:
3125: WHEN FND_API.G_EXC_ERROR THEN

Line 3123: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

3119: EXCEPTION
3120:
3121: WHEN AMS_Utility_PVT.resource_locked THEN
3122: x_return_status := FND_API.g_ret_sts_error;
3123: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3124:
3125: WHEN FND_API.G_EXC_ERROR THEN
3126: ROLLBACK TO DELETE_List_Entries_PVT;
3127: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3193: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3189:
3190: -- Debug Message
3191: IF (AMS_DEBUG_HIGH_ON) THEN
3192:
3193: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3194: END IF;
3195:
3196: -- Initialize message list if p_init_msg_list is set to TRUE.
3197: IF FND_API.to_Boolean( p_init_msg_list )

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

3218: IF (AMS_DEBUG_HIGH_ON) THEN
3219:
3220:
3221:
3222: AMS_Utility_PVT.debug_message(l_full_name||': start');
3223:
3224: END IF;
3225: OPEN c_List_Entries;
3226:

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

3243: p_count => x_msg_count,
3244: p_data => x_msg_data);
3245: IF (AMS_DEBUG_HIGH_ON) THEN
3246:
3247: AMS_Utility_PVT.debug_message(l_full_name ||': end');
3248: END IF;
3249: EXCEPTION
3250:
3251: WHEN AMS_Utility_PVT.resource_locked THEN

Line 3251: WHEN AMS_Utility_PVT.resource_locked THEN

3247: AMS_Utility_PVT.debug_message(l_full_name ||': end');
3248: END IF;
3249: EXCEPTION
3250:
3251: WHEN AMS_Utility_PVT.resource_locked THEN
3252: x_return_status := FND_API.g_ret_sts_error;
3253: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3254:
3255: WHEN FND_API.G_EXC_ERROR THEN

Line 3253: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

3249: EXCEPTION
3250:
3251: WHEN AMS_Utility_PVT.resource_locked THEN
3252: x_return_status := FND_API.g_ret_sts_error;
3253: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3254:
3255: WHEN FND_API.G_EXC_ERROR THEN
3256: ROLLBACK TO LOCK_List_Entries_PVT;
3257: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3301: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

3297:
3298: BEGIN
3299: x_return_status := FND_API.g_ret_sts_success;
3300: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3301: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
3302: 'AMS_LIST_ENTRIES',
3303: 'LIST_ENTRY_ID = ''' || p_list_entries_rec.LIST_ENTRY_ID ||''''
3304: );
3305: ELSE

Line 3306: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

3302: 'AMS_LIST_ENTRIES',
3303: 'LIST_ENTRY_ID = ''' || p_list_entries_rec.LIST_ENTRY_ID ||''''
3304: );
3305: ELSE
3306: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
3307: 'AMS_LIST_ENTRIES',
3308: 'LIST_ENTRY_ID = ''' || p_list_entries_rec.LIST_ENTRY_ID ||
3309: ''' AND LIST_ENTRY_ID <> ' || p_list_entries_rec.LIST_ENTRY_ID
3310: );

Line 3314: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_ENTRY_ID_DUPLICATE');

3310: );
3311: END IF;
3312:
3313: IF l_valid_flag = FND_API.g_false THEN
3314: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_ENTRY_ID_DUPLICATE');
3315: x_return_status := FND_API.g_ret_sts_error;
3316: RETURN;
3317: END IF;
3318:

Line 3334: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_header_id');

3330: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3331:
3332:
3333: IF p_list_entries_rec.list_header_id = FND_API.g_miss_num OR p_list_entries_rec.list_header_id IS NULL THEN
3334: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_header_id');
3335: x_return_status := FND_API.g_ret_sts_error;
3336: END IF;
3337:
3338:

Line 3340: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_id');

3336: END IF;
3337:
3338:
3339: IF p_list_entries_rec.list_select_action_id = FND_API.g_miss_num OR p_list_entries_rec.list_select_action_id IS NULL THEN
3340: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_id');
3341: x_return_status := FND_API.g_ret_sts_error;
3342: END IF;
3343:
3344:

Line 3346: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_select_action_from');

3342: END IF;
3343:
3344:
3345: IF p_list_entries_rec.arc_list_select_action_from = FND_API.g_miss_char OR p_list_entries_rec.arc_list_select_action_from IS NULL THEN
3346: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_select_action_from');
3347: x_return_status := FND_API.g_ret_sts_error;
3348: END IF;
3349:
3350:

Line 3352: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_from_name');

3348: END IF;
3349:
3350:
3351: IF p_list_entries_rec.list_select_action_from_name = FND_API.g_miss_char OR p_list_entries_rec.list_select_action_from_name IS NULL THEN
3352: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_from_name');
3353: x_return_status := FND_API.g_ret_sts_error;
3354: END IF;
3355:
3356:

Line 3358: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code');

3354: END IF;
3355:
3356:
3357: IF p_list_entries_rec.source_code = FND_API.g_miss_char OR p_list_entries_rec.source_code IS NULL THEN
3358: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code');
3359: x_return_status := FND_API.g_ret_sts_error;
3360: END IF;
3361:
3362:

Line 3364: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_used_by_source');

3360: END IF;
3361:
3362:
3363: IF p_list_entries_rec.arc_list_used_by_source = FND_API.g_miss_char OR p_list_entries_rec.arc_list_used_by_source IS NULL THEN
3364: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_used_by_source');
3365: x_return_status := FND_API.g_ret_sts_error;
3366: END IF;
3367:
3368:

Line 3370: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code_for_id');

3366: END IF;
3367:
3368:
3369: IF p_list_entries_rec.source_code_for_id = FND_API.g_miss_num OR p_list_entries_rec.source_code_for_id IS NULL THEN
3370: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code_for_id');
3371: x_return_status := FND_API.g_ret_sts_error;
3372: END IF;
3373:
3374: -- no validation for creation, pin_code uses list_entry_id

Line 3377: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'pin_code');

3373:
3374: -- no validation for creation, pin_code uses list_entry_id
3375: /*
3376: IF p_list_entries_rec.pin_code = FND_API.g_miss_char OR p_list_entries_rec.pin_code IS NULL THEN
3377: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'pin_code');
3378: x_return_status := FND_API.g_ret_sts_error;
3379: END IF;
3380: */
3381:

Line 3383: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_id');

3379: END IF;
3380: */
3381:
3382: IF p_list_entries_rec.list_entry_source_system_id = FND_API.g_miss_num OR p_list_entries_rec.list_entry_source_system_id IS NULL THEN
3383: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_id');
3384: x_return_status := FND_API.g_ret_sts_error;
3385: END IF;
3386:
3387:

Line 3389: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_type');

3385: END IF;
3386:
3387:
3388: IF p_list_entries_rec.list_entry_source_system_type = FND_API.g_miss_char OR p_list_entries_rec.list_entry_source_system_type IS NULL THEN
3389: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_type');
3390: x_return_status := FND_API.g_ret_sts_error;
3391: END IF;
3392:
3393:

Line 3395: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'view_application_id');

3391: END IF;
3392:
3393:
3394: IF p_list_entries_rec.view_application_id = FND_API.g_miss_num OR p_list_entries_rec.view_application_id IS NULL THEN
3395: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'view_application_id');
3396: x_return_status := FND_API.g_ret_sts_error;
3397: END IF;
3398:
3399:

Line 3401: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'manually_entered_flag');

3397: END IF;
3398:
3399:
3400: IF p_list_entries_rec.manually_entered_flag = FND_API.g_miss_char OR p_list_entries_rec.manually_entered_flag IS NULL THEN
3401: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'manually_entered_flag');
3402: x_return_status := FND_API.g_ret_sts_error;
3403: END IF;
3404:
3405:

Line 3407: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_duplicate_flag');

3403: END IF;
3404:
3405:
3406: IF p_list_entries_rec.marked_as_duplicate_flag = FND_API.g_miss_char OR p_list_entries_rec.marked_as_duplicate_flag IS NULL THEN
3407: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_duplicate_flag');
3408: x_return_status := FND_API.g_ret_sts_error;
3409: END IF;
3410:
3411:

Line 3413: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_random_flag');

3409: END IF;
3410:
3411:
3412: IF p_list_entries_rec.marked_as_random_flag = FND_API.g_miss_char OR p_list_entries_rec.marked_as_random_flag IS NULL THEN
3413: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_random_flag');
3414: x_return_status := FND_API.g_ret_sts_error;
3415: END IF;
3416:
3417:

Line 3419: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'part_of_control_group_flag');

3415: END IF;
3416:
3417:
3418: IF p_list_entries_rec.part_of_control_group_flag = FND_API.g_miss_char OR p_list_entries_rec.part_of_control_group_flag IS NULL THEN
3419: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'part_of_control_group_flag');
3420: x_return_status := FND_API.g_ret_sts_error;
3421: END IF;
3422:
3423:

Line 3425: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'exclude_in_triggered_list_flag');

3421: END IF;
3422:
3423:
3424: IF p_list_entries_rec.exclude_in_triggered_list_flag = FND_API.g_miss_char OR p_list_entries_rec.exclude_in_triggered_list_flag IS NULL THEN
3425: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'exclude_in_triggered_list_flag');
3426: x_return_status := FND_API.g_ret_sts_error;
3427: END IF;
3428:
3429:

Line 3431: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'enabled_flag');

3427: END IF;
3428:
3429:
3430: IF p_list_entries_rec.enabled_flag = FND_API.g_miss_char OR p_list_entries_rec.enabled_flag IS NULL THEN
3431: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'enabled_flag');
3432: x_return_status := FND_API.g_ret_sts_error;
3433: END IF;
3434: ELSE
3435:

Line 3438: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_id');

3434: ELSE
3435:
3436:
3437: IF p_list_entries_rec.list_entry_id IS NULL THEN
3438: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_id');
3439: x_return_status := FND_API.g_ret_sts_error;
3440: END IF;
3441:
3442:

Line 3444: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_header_id');

3440: END IF;
3441:
3442:
3443: IF p_list_entries_rec.list_header_id IS NULL THEN
3444: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_header_id');
3445: x_return_status := FND_API.g_ret_sts_error;
3446: END IF;
3447:
3448:

Line 3450: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'last_update_date');

3446: END IF;
3447:
3448:
3449: IF p_list_entries_rec.last_update_date IS NULL THEN
3450: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'last_update_date');
3451: x_return_status := FND_API.g_ret_sts_error;
3452: END IF;
3453:
3454:

Line 3456: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'last_updated_by');

3452: END IF;
3453:
3454:
3455: IF p_list_entries_rec.last_updated_by IS NULL THEN
3456: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'last_updated_by');
3457: x_return_status := FND_API.g_ret_sts_error;
3458: END IF;
3459:
3460:

Line 3462: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'creation_date');

3458: END IF;
3459:
3460:
3461: IF p_list_entries_rec.creation_date IS NULL THEN
3462: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'creation_date');
3463: x_return_status := FND_API.g_ret_sts_error;
3464: END IF;
3465:
3466:

Line 3468: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'created_by');

3464: END IF;
3465:
3466:
3467: IF p_list_entries_rec.created_by IS NULL THEN
3468: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'created_by');
3469: x_return_status := FND_API.g_ret_sts_error;
3470: END IF;
3471:
3472:

Line 3474: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_id');

3470: END IF;
3471:
3472:
3473: IF p_list_entries_rec.list_select_action_id IS NULL THEN
3474: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_id');
3475: x_return_status := FND_API.g_ret_sts_error;
3476: END IF;
3477:
3478:

Line 3480: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_select_action_from');

3476: END IF;
3477:
3478:
3479: IF p_list_entries_rec.arc_list_select_action_from IS NULL THEN
3480: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_select_action_from');
3481: x_return_status := FND_API.g_ret_sts_error;
3482: END IF;
3483:
3484:

Line 3486: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_from_name');

3482: END IF;
3483:
3484:
3485: IF p_list_entries_rec.list_select_action_from_name IS NULL THEN
3486: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_select_action_from_name');
3487: x_return_status := FND_API.g_ret_sts_error;
3488: END IF;
3489:
3490:

Line 3492: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code');

3488: END IF;
3489:
3490:
3491: IF p_list_entries_rec.source_code IS NULL THEN
3492: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code');
3493: x_return_status := FND_API.g_ret_sts_error;
3494: END IF;
3495:
3496:

Line 3498: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_used_by_source');

3494: END IF;
3495:
3496:
3497: IF p_list_entries_rec.arc_list_used_by_source IS NULL THEN
3498: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'arc_list_used_by_source');
3499: x_return_status := FND_API.g_ret_sts_error;
3500: END IF;
3501:
3502:

Line 3504: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code_for_id');

3500: END IF;
3501:
3502:
3503: IF p_list_entries_rec.source_code_for_id IS NULL THEN
3504: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'source_code_for_id');
3505: x_return_status := FND_API.g_ret_sts_error;
3506: END IF;
3507:
3508: IF p_list_entries_rec.pin_code IS NULL THEN

Line 3509: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'pin_code');

3505: x_return_status := FND_API.g_ret_sts_error;
3506: END IF;
3507:
3508: IF p_list_entries_rec.pin_code IS NULL THEN
3509: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'pin_code');
3510: x_return_status := FND_API.g_ret_sts_error;
3511: END IF;
3512:
3513:

Line 3515: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_id');

3511: END IF;
3512:
3513:
3514: IF p_list_entries_rec.list_entry_source_system_id IS NULL THEN
3515: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_id');
3516: x_return_status := FND_API.g_ret_sts_error;
3517: END IF;
3518:
3519:

Line 3521: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_type');

3517: END IF;
3518:
3519:
3520: IF p_list_entries_rec.list_entry_source_system_type IS NULL THEN
3521: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'list_entry_source_system_type');
3522: x_return_status := FND_API.g_ret_sts_error;
3523: END IF;
3524:
3525:

Line 3527: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'view_application_id');

3523: END IF;
3524:
3525:
3526: IF p_list_entries_rec.view_application_id IS NULL THEN
3527: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'view_application_id');
3528: x_return_status := FND_API.g_ret_sts_error;
3529: END IF;
3530:
3531:

Line 3533: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'manually_entered_flag');

3529: END IF;
3530:
3531:
3532: IF p_list_entries_rec.manually_entered_flag IS NULL THEN
3533: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'manually_entered_flag');
3534: x_return_status := FND_API.g_ret_sts_error;
3535: END IF;
3536:
3537:

Line 3539: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_duplicate_flag');

3535: END IF;
3536:
3537:
3538: IF p_list_entries_rec.marked_as_duplicate_flag IS NULL THEN
3539: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_duplicate_flag');
3540: x_return_status := FND_API.g_ret_sts_error;
3541: END IF;
3542:
3543:

Line 3545: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_random_flag');

3541: END IF;
3542:
3543:
3544: IF p_list_entries_rec.marked_as_random_flag IS NULL THEN
3545: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'marked_as_random_flag');
3546: x_return_status := FND_API.g_ret_sts_error;
3547: END IF;
3548:
3549:

Line 3551: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'part_of_control_group_flag');

3547: END IF;
3548:
3549:
3550: IF p_list_entries_rec.part_of_control_group_flag IS NULL THEN
3551: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'part_of_control_group_flag');
3552: x_return_status := FND_API.g_ret_sts_error;
3553: END IF;
3554:
3555:

Line 3557: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'exclude_in_triggered_list_flag');

3553: END IF;
3554:
3555:
3556: IF p_list_entries_rec.exclude_in_triggered_list_flag IS NULL THEN
3557: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'exclude_in_triggered_list_flag');
3558: x_return_status := FND_API.g_ret_sts_error;
3559: END IF;
3560:
3561:

Line 3563: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'enabled_flag');

3559: END IF;
3560:
3561:
3562: IF p_list_entries_rec.enabled_flag IS NULL THEN
3563: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'enabled_flag');
3564: x_return_status := FND_API.g_ret_sts_error;
3565: END IF;
3566: END IF;
3567:

Line 3632: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','newly_updated_flag');

3628: )
3629: THEN
3630: null;
3631: else
3632: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','newly_updated_flag');
3633: x_return_status := FND_API.g_ret_sts_error;
3634: END IF;
3635:
3636: IF ( p_list_entries_rec.manually_entered_flag = 'Y' OR

Line 3644: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','manually_entered_flag');

3640: )
3641: THEN
3642: null;
3643: else
3644: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','manually_entered_flag');
3645: x_return_status := FND_API.g_ret_sts_error;
3646: END IF;
3647:
3648: IF ( p_list_entries_rec.marked_as_duplicate_flag = 'Y' OR

Line 3656: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','marked_as_duplicate_flag');

3652: )
3653: THEN
3654: null;
3655: else
3656: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','marked_as_duplicate_flag');
3657: x_return_status := FND_API.g_ret_sts_error;
3658: END IF;
3659:
3660: IF ( p_list_entries_rec.marked_as_random_flag = 'Y' OR

Line 3668: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','marked_as_random_flag');

3664: )
3665: THEN
3666: null;
3667: else
3668: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','marked_as_random_flag');
3669: x_return_status := FND_API.g_ret_sts_error;
3670: END IF;
3671:
3672: IF ( p_list_entries_rec.part_of_control_group_flag = 'Y' OR

Line 3680: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','part_of_control_group_flag');

3676: )
3677: THEN
3678: null;
3679: else
3680: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','part_of_control_group_flag');
3681: x_return_status := FND_API.g_ret_sts_error;
3682: END IF;
3683:
3684: IF ( p_list_entries_rec.exclude_in_triggered_list_flag = 'Y' OR

Line 3692: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','exclude_in_triggered_list_flag');

3688: )
3689: THEN
3690: null;
3691: else
3692: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','exclude_in_triggered_list_flag');
3693: x_return_status := FND_API.g_ret_sts_error;
3694: END IF;
3695:
3696: IF ( p_list_entries_rec.enabled_flag = 'Y' OR

Line 3704: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','enabled_flag');

3700: )
3701: THEN
3702: null;
3703: else
3704: AMS_Utility_PVT.Error_Message('AMS_API_INVALID_FLAG','INVALID_FLAG','enabled_flag');
3705: x_return_status := FND_API.g_ret_sts_error;
3706: END IF;
3707:
3708: IF ( p_list_entries_rec.outcome_id is not null AND

Line 3713: AMS_Utility_PVT.Error_Message(p_message_name=>'AMS_BAD_OUTCOME_ID');

3709: p_list_entries_rec.outcome_id <> FND_API.g_miss_num) THEN
3710: open check_outcome(p_list_entries_rec.outcome_id);
3711: fetch check_outcome into l_dummy;
3712: if check_outcome%notfound then
3713: AMS_Utility_PVT.Error_Message(p_message_name=>'AMS_BAD_OUTCOME_ID');
3714: x_return_status := FND_API.g_ret_sts_error;
3715: return;
3716: end if;
3717: close check_outcome;

Line 3724: AMS_Utility_PVT.Error_Message(p_message_name=>'AMS_BAD_RESULT_ID');

3720: p_list_entries_rec.result_id <> FND_API.g_miss_num) THEN
3721: open check_result(p_list_entries_rec.outcome_id,p_list_entries_rec.result_id);
3722: fetch check_result into l_dummy;
3723: if check_result%notfound then
3724: AMS_Utility_PVT.Error_Message(p_message_name=>'AMS_BAD_RESULT_ID');
3725: x_return_status := FND_API.g_ret_sts_error;
3726: return;
3727: end if;
3728: close check_result;

Line 3735: AMS_Utility_PVT.Error_Message(p_message_name=>'AMS_BAD_REASON_ID');

3731: p_list_entries_rec.reason_id <> fnd_api.g_miss_num) THEN
3732: open check_reason(p_list_entries_rec.reason_id,p_list_entries_rec.result_id);
3733: fetch check_reason into l_dummy;
3734: if check_reason%notfound then
3735: AMS_Utility_PVT.Error_Message(p_message_name=>'AMS_BAD_REASON_ID');
3736: x_return_status := FND_API.g_ret_sts_error;
3737: return;
3738: end if;
3739: close check_reason;

Line 3793: AMS_UTILITY_PVT.debug_message('Private API: ' || 'before check_list_entries_Business');

3789: IF (AMS_DEBUG_HIGH_ON) THEN
3790:
3791:
3792:
3793: AMS_UTILITY_PVT.debug_message('Private API: ' || 'before check_list_entries_Business');
3794:
3795: END IF;
3796: check_list_entries_Business(
3797: p_list_entries_rec => p_list_entries_rec,

Line 3805: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after check_list_entries_Business');

3801: RETURN;
3802: END IF;
3803: IF (AMS_DEBUG_HIGH_ON) THEN
3804:
3805: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after check_list_entries_Business');
3806: END IF;
3807:
3808: END Check_list_entries_Items;
3809:

Line 3863: AMS_UTILITY_PVT.debug_message('complete rec');

3859:
3860: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3861: IF (AMS_DEBUG_HIGH_ON) THEN
3862:
3863: AMS_UTILITY_PVT.debug_message('complete rec');
3864: END IF;
3865: Validate_list_entries_Rec(
3866: p_api_version_number => 1.0,
3867: p_init_msg_list => FND_API.G_FALSE,

Line 3884: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3880:
3881: -- Debug Message
3882: IF (AMS_DEBUG_HIGH_ON) THEN
3883:
3884: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3885: END IF;
3886:
3887:
3888: -- Initialize API return status to SUCCESS

Line 3895: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3891:
3892: -- Debug Message
3893: IF (AMS_DEBUG_HIGH_ON) THEN
3894:
3895: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3896: END IF;
3897:
3898: -- Standard call to get message count and if count is 1, get message info.
3899: FND_MSG_PUB.Count_And_Get

Line 3905: WHEN AMS_Utility_PVT.resource_locked THEN

3901: p_data => x_msg_data
3902: );
3903: EXCEPTION
3904:
3905: WHEN AMS_Utility_PVT.resource_locked THEN
3906: x_return_status := FND_API.g_ret_sts_error;
3907: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3908:
3909: WHEN FND_API.G_EXC_ERROR THEN

Line 3907: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

3903: EXCEPTION
3904:
3905: WHEN AMS_Utility_PVT.resource_locked THEN
3906: x_return_status := FND_API.g_ret_sts_error;
3907: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
3908:
3909: WHEN FND_API.G_EXC_ERROR THEN
3910: ROLLBACK TO VALIDATE_List_Entries_;
3911: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3972: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

3968:
3969: -- Debug Message
3970: IF (AMS_DEBUG_HIGH_ON) THEN
3971:
3972: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
3973: END IF;
3974: -- Standard call to get message count and if count is 1, get message info.
3975: FND_MSG_PUB.Count_And_Get
3976: (p_count => x_msg_count,