101: -- =========================================================================
102: -- Validate Environment
103: -- =========================================================================
104:
105: IF FND_GLOBAL.User_Id IS NULL
106: THEN
107: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
140: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row)
141: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row(
142: px_list_source_type_assoc_id => l_list_source_type_assoc_id,
143: p_last_update_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,
145: p_creation_date => SYSDATE,
146: p_created_by => FND_GLOBAL.USER_ID,
147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
148: px_object_version_number => l_object_version_number,
142: px_list_source_type_assoc_id => l_list_source_type_assoc_id,
143: p_last_update_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,
145: p_creation_date => SYSDATE,
146: p_created_by => FND_GLOBAL.USER_ID,
147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
148: px_object_version_number => l_object_version_number,
149: p_master_source_type_id => p_st_assoc_rec.master_source_type_id,
150: p_sub_source_type_id => p_st_assoc_rec.sub_source_type_id,
143: p_last_update_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,
145: p_creation_date => SYSDATE,
146: p_created_by => FND_GLOBAL.USER_ID,
147: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
148: px_object_version_number => l_object_version_number,
149: p_master_source_type_id => p_st_assoc_rec.master_source_type_id,
150: p_sub_source_type_id => p_st_assoc_rec.sub_source_type_id,
151: p_sub_source_type_pk_column => p_st_assoc_rec.sub_source_type_pk_column,
356: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(
357: p_list_source_type_assoc_id =>
358: p_st_assoc_rec.list_source_type_assoc_id,
359: p_last_update_date => SYSDATE,
360: p_last_updated_by => FND_GLOBAL.USER_ID,
361: p_creation_date => SYSDATE,
362: p_created_by => FND_GLOBAL.USER_ID,
363: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
364: p_object_version_number => p_st_assoc_rec.object_version_number,
358: p_st_assoc_rec.list_source_type_assoc_id,
359: p_last_update_date => SYSDATE,
360: p_last_updated_by => FND_GLOBAL.USER_ID,
361: p_creation_date => SYSDATE,
362: p_created_by => FND_GLOBAL.USER_ID,
363: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
364: p_object_version_number => p_st_assoc_rec.object_version_number,
365: p_master_source_type_id => p_st_assoc_rec.master_source_type_id,
366: p_sub_source_type_id => p_st_assoc_rec.sub_source_type_id,
359: p_last_update_date => SYSDATE,
360: p_last_updated_by => FND_GLOBAL.USER_ID,
361: p_creation_date => SYSDATE,
362: p_created_by => FND_GLOBAL.USER_ID,
363: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
364: p_object_version_number => p_st_assoc_rec.object_version_number,
365: p_master_source_type_id => p_st_assoc_rec.master_source_type_id,
366: p_sub_source_type_id => p_st_assoc_rec.sub_source_type_id,
367: p_sub_source_type_pk_column =>