104: -- =========================================================================
105: -- Validate Environment
106: -- =========================================================================
107:
108: IF FND_GLOBAL.User_Id IS NULL
109: THEN
110: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
149: AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row(
150: px_list_cont_restrictions_id => l_list_cont_restrictions_id,
151: p_list_header_id => p_list_assoc_rec.list_header_id,
152: p_last_update_date => SYSDATE,
153: p_last_updated_by => FND_GLOBAL.USER_ID,
154: p_creation_date => SYSDATE,
155: p_created_by => FND_GLOBAL.USER_ID,
156: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
157: px_object_version_number => l_object_version_number,
151: p_list_header_id => p_list_assoc_rec.list_header_id,
152: p_last_update_date => SYSDATE,
153: p_last_updated_by => FND_GLOBAL.USER_ID,
154: p_creation_date => SYSDATE,
155: p_created_by => FND_GLOBAL.USER_ID,
156: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
157: px_object_version_number => l_object_version_number,
158: p_do_not_contact_flag => p_list_assoc_rec.do_not_contact_flag,
159: p_media_id => p_list_assoc_rec.media_id,
152: p_last_update_date => SYSDATE,
153: p_last_updated_by => FND_GLOBAL.USER_ID,
154: p_creation_date => SYSDATE,
155: p_created_by => FND_GLOBAL.USER_ID,
156: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
157: px_object_version_number => l_object_version_number,
158: p_do_not_contact_flag => p_list_assoc_rec.do_not_contact_flag,
159: p_media_id => p_list_assoc_rec.media_id,
160: p_list_used_by => p_list_assoc_rec.list_used_by,
362: AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row(
363: p_list_cont_restrictions_id => p_list_assoc_rec.list_cont_restrictions_id,
364: p_list_header_id => p_list_assoc_rec.list_header_id,
365: p_last_update_date => SYSDATE,
366: p_last_updated_by => FND_GLOBAL.USER_ID,
367: p_creation_date => SYSDATE,
368: p_created_by => FND_GLOBAL.USER_ID,
369: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
370: p_object_version_number => p_list_assoc_rec.object_version_number,
364: p_list_header_id => p_list_assoc_rec.list_header_id,
365: p_last_update_date => SYSDATE,
366: p_last_updated_by => FND_GLOBAL.USER_ID,
367: p_creation_date => SYSDATE,
368: p_created_by => FND_GLOBAL.USER_ID,
369: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
370: p_object_version_number => p_list_assoc_rec.object_version_number,
371: p_do_not_contact_flag => p_list_assoc_rec.do_not_contact_flag,
372: p_media_id => p_list_assoc_rec.media_id,
365: p_last_update_date => SYSDATE,
366: p_last_updated_by => FND_GLOBAL.USER_ID,
367: p_creation_date => SYSDATE,
368: p_created_by => FND_GLOBAL.USER_ID,
369: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
370: p_object_version_number => p_list_assoc_rec.object_version_number,
371: p_do_not_contact_flag => p_list_assoc_rec.do_not_contact_flag,
372: p_media_id => p_list_assoc_rec.media_id,
373: p_list_used_by => p_list_assoc_rec.list_used_by,