APPS.AMS_LIST_MAINT_PVT dependencies on AMS_UTILITY_PVT

Line 115: AMS_Utility_PVT.Create_Log (

111: -----------------------------------------
112: retcode :=0;
113:
114:
115: AMS_Utility_PVT.Create_Log (
116: x_return_status => l_return_status,
117: p_arc_log_used_by => 'LIST',
118: p_log_used_by_id => p_list_header_id,
119: p_msg_data => G_PKG_NAME || '.' || 'SCHEDULE_LIST: ' || TO_CHAR (p_validation_level));

Line 189: AMS_UTILITY_PVT.Convert_Timezone(

185: -- p_user_tz_id can be null... take value in profile option for User Timezone
186:
187: IF (p_time IS NOT NULL)
188: THEN
189: AMS_UTILITY_PVT.Convert_Timezone(
190: p_init_msg_list => FND_API.G_TRUE,
191: x_return_status => l_return_status,
192: x_msg_count => l_msg_count,
193: x_msg_data => l_msg_data,

Line 265: IF AMS_Utility_PVT.check_fk_exists(

261: /*
262: l_return_status := FND_API.G_TRUE;
263:
264: IF(p_arc_list_used_by = 'CSCH')THEN
265: IF AMS_Utility_PVT.check_fk_exists(
266: 'ams_campaign_schedules',
267: 'campaign_schedule_id',
268: p_list_used_by_id) = FND_API.g_false
269: THEN

Line 275: IF AMS_Utility_PVT.check_fk_exists(

271: RETURN l_return_status;
272:
273: END IF;
274: ELSIF(p_arc_list_used_by = 'CAMP')THEN
275: IF AMS_Utility_PVT.check_fk_exists(
276: 'ams_campaigns_all_b',
277: 'campaign_id',
278: p_list_used_by_id) = FND_API.g_false
279: THEN

Line 284: IF AMS_Utility_PVT.check_fk_exists(

280: l_return_status := FND_API.G_FALSE;
281: RETURN l_return_status;
282: END IF;
283: ELSIF(p_arc_list_used_by = 'EVEO')THEN
284: IF AMS_Utility_PVT.check_fk_exists(
285: 'ams_event_offers_all_b',
286: 'event_offer_id',
287: p_list_used_by_id) = FND_API.g_false
288: THEN

Line 293: IF AMS_Utility_PVT.check_fk_exists(

289: l_return_status := FND_API.G_FALSE;
290: RETURN l_return_status;
291: END IF;
292: ELSIF(p_arc_list_used_by = 'EVEH')THEN
293: IF AMS_Utility_PVT.check_fk_exists(
294: 'ams_event_headers_all_b',
295: 'event_header_id',
296: p_list_used_by_id) = FND_API.g_false
297: THEN

Line 894: IF AMS_Utility_PVT.check_lookup_exists(

890: --------------------------------------------------------------------------------
891: --Check that(if specified) the list type is valid. --
892: --------------------------------------------------------------------------------
893: IF(p_list_type IS NOT NULL)THEN
894: IF AMS_Utility_PVT.check_lookup_exists(
895: p_lookup_type => 'AMS_LIST_TYPE',
896: p_lookup_code => p_list_type) = FND_API.g_false THEN
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

1240: IF (AMS_DEBUG_HIGH_ON) THEN
1241:
1242:
1243:
1244: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1245:
1246: END IF;
1247:
1248: IF FND_API.to_boolean (p_init_msg_list) THEN