103: -- =========================================================================
104: -- Validate Environment
105: -- =========================================================================
106:
107: IF FND_GLOBAL.User_Id IS NULL
108: THEN
109: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
144: AMS_IMP_SOURCE_LINES_PKG.Insert_Row(
145: px_import_source_line_id => l_import_source_line_id,
146: px_object_version_number => l_object_version_number,
147: p_last_update_date => SYSDATE,
148: p_last_updated_by => FND_GLOBAL.USER_ID,
149: p_creation_date => SYSDATE,
150: p_created_by => FND_GLOBAL.USER_ID,
151: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
152: p_import_list_header_id => p_is_line_rec.import_list_header_id,
146: px_object_version_number => l_object_version_number,
147: p_last_update_date => SYSDATE,
148: p_last_updated_by => FND_GLOBAL.USER_ID,
149: p_creation_date => SYSDATE,
150: p_created_by => FND_GLOBAL.USER_ID,
151: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
152: p_import_list_header_id => p_is_line_rec.import_list_header_id,
153: p_import_successful_flag => p_is_line_rec.import_successful_flag,
154: p_enabled_flag => p_is_line_rec.enabled_flag,
147: p_last_update_date => SYSDATE,
148: p_last_updated_by => FND_GLOBAL.USER_ID,
149: p_creation_date => SYSDATE,
150: p_created_by => FND_GLOBAL.USER_ID,
151: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
152: p_import_list_header_id => p_is_line_rec.import_list_header_id,
153: p_import_successful_flag => p_is_line_rec.import_successful_flag,
154: p_enabled_flag => p_is_line_rec.enabled_flag,
155: p_import_failure_reason => p_is_line_rec.import_failure_reason,
655: AMS_IMP_SOURCE_LINES_PKG.Update_Row(
656: p_import_source_line_id => p_is_line_rec.import_source_line_id,
657: p_object_version_number => p_is_line_rec.object_version_number,
658: p_last_update_date => SYSDATE,
659: p_last_updated_by => FND_GLOBAL.USER_ID,
660: p_creation_date => SYSDATE,
661: p_created_by => FND_GLOBAL.USER_ID,
662: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
663: p_import_list_header_id => p_is_line_rec.import_list_header_id,
657: p_object_version_number => p_is_line_rec.object_version_number,
658: p_last_update_date => SYSDATE,
659: p_last_updated_by => FND_GLOBAL.USER_ID,
660: p_creation_date => SYSDATE,
661: p_created_by => FND_GLOBAL.USER_ID,
662: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
663: p_import_list_header_id => p_is_line_rec.import_list_header_id,
664: p_import_successful_flag => p_is_line_rec.import_successful_flag,
665: p_enabled_flag => p_is_line_rec.enabled_flag,
658: p_last_update_date => SYSDATE,
659: p_last_updated_by => FND_GLOBAL.USER_ID,
660: p_creation_date => SYSDATE,
661: p_created_by => FND_GLOBAL.USER_ID,
662: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
663: p_import_list_header_id => p_is_line_rec.import_list_header_id,
664: p_import_successful_flag => p_is_line_rec.import_successful_flag,
665: p_enabled_flag => p_is_line_rec.enabled_flag,
666: p_import_failure_reason => p_is_line_rec.import_failure_reason,