230: -- =========================================================================
231: -- Validate Environment
232: -- =========================================================================
233:
234: IF FND_GLOBAL.User_Id IS NULL
235: THEN
236: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
284: -- Invoke table handler(OZF_THRESHOLD_RULES_PKG.Insert_Row)
285: OZF_THRESHOLD_RULES_PKG.Insert_Row(
286: px_threshold_rule_id => l_threshold_rule_id,
287: p_last_update_date => SYSDATE,
288: p_last_updated_by => NVL(fnd_global.user_id, -1),
289: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
290: p_creation_date => SYSDATE,
291: p_created_by => NVL(fnd_global.user_id, -1),
292: p_created_from => NULL,
285: OZF_THRESHOLD_RULES_PKG.Insert_Row(
286: px_threshold_rule_id => l_threshold_rule_id,
287: p_last_update_date => SYSDATE,
288: p_last_updated_by => NVL(fnd_global.user_id, -1),
289: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
290: p_creation_date => SYSDATE,
291: p_created_by => NVL(fnd_global.user_id, -1),
292: p_created_from => NULL,
293: p_request_id => fnd_global.conc_request_id,
287: p_last_update_date => SYSDATE,
288: p_last_updated_by => NVL(fnd_global.user_id, -1),
289: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
290: p_creation_date => SYSDATE,
291: p_created_by => NVL(fnd_global.user_id, -1),
292: p_created_from => NULL,
293: p_request_id => fnd_global.conc_request_id,
294: p_program_application_id => fnd_global.prog_appl_id,
295: p_program_id => fnd_global.conc_program_id,
289: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
290: p_creation_date => SYSDATE,
291: p_created_by => NVL(fnd_global.user_id, -1),
292: p_created_from => NULL,
293: p_request_id => fnd_global.conc_request_id,
294: p_program_application_id => fnd_global.prog_appl_id,
295: p_program_id => fnd_global.conc_program_id,
296: p_program_update_date => SYSDATE,
297: p_period_type => p_threshold_rule_rec.period_type,
290: p_creation_date => SYSDATE,
291: p_created_by => NVL(fnd_global.user_id, -1),
292: p_created_from => NULL,
293: p_request_id => fnd_global.conc_request_id,
294: p_program_application_id => fnd_global.prog_appl_id,
295: p_program_id => fnd_global.conc_program_id,
296: p_program_update_date => SYSDATE,
297: p_period_type => p_threshold_rule_rec.period_type,
298: p_enabled_flag => p_threshold_rule_rec.enabled_flag,
291: p_created_by => NVL(fnd_global.user_id, -1),
292: p_created_from => NULL,
293: p_request_id => fnd_global.conc_request_id,
294: p_program_application_id => fnd_global.prog_appl_id,
295: p_program_id => fnd_global.conc_program_id,
296: p_program_update_date => SYSDATE,
297: p_period_type => p_threshold_rule_rec.period_type,
298: p_enabled_flag => p_threshold_rule_rec.enabled_flag,
299: p_threshold_calendar =>l_threshold_calendar,
563: -- Invoke table handler(OZF_THRESHOLD_RULES_PKG.Update_Row)
564: OZF_THRESHOLD_RULES_PKG.Update_Row(
565: p_threshold_rule_id => l_threshold_rule_rec.threshold_rule_id,
566: p_last_update_date => SYSDATE,
567: p_last_updated_by => NVL(fnd_global.user_id, -1),
568: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
569: p_created_from => l_threshold_rule_rec.created_from,
570: p_request_id => fnd_global.conc_request_id,
571: p_program_application_id => fnd_global.prog_appl_id,
564: OZF_THRESHOLD_RULES_PKG.Update_Row(
565: p_threshold_rule_id => l_threshold_rule_rec.threshold_rule_id,
566: p_last_update_date => SYSDATE,
567: p_last_updated_by => NVL(fnd_global.user_id, -1),
568: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
569: p_created_from => l_threshold_rule_rec.created_from,
570: p_request_id => fnd_global.conc_request_id,
571: p_program_application_id => fnd_global.prog_appl_id,
572: p_program_id => fnd_global.conc_program_id,
566: p_last_update_date => SYSDATE,
567: p_last_updated_by => NVL(fnd_global.user_id, -1),
568: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
569: p_created_from => l_threshold_rule_rec.created_from,
570: p_request_id => fnd_global.conc_request_id,
571: p_program_application_id => fnd_global.prog_appl_id,
572: p_program_id => fnd_global.conc_program_id,
573: p_program_update_date => SYSDATE,
574: p_period_type => l_threshold_rule_rec.period_type,
567: p_last_updated_by => NVL(fnd_global.user_id, -1),
568: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
569: p_created_from => l_threshold_rule_rec.created_from,
570: p_request_id => fnd_global.conc_request_id,
571: p_program_application_id => fnd_global.prog_appl_id,
572: p_program_id => fnd_global.conc_program_id,
573: p_program_update_date => SYSDATE,
574: p_period_type => l_threshold_rule_rec.period_type,
575: p_enabled_flag => l_threshold_rule_rec.enabled_flag,
568: p_last_update_login => NVL(fnd_global.conc_login_id, -1),
569: p_created_from => l_threshold_rule_rec.created_from,
570: p_request_id => fnd_global.conc_request_id,
571: p_program_application_id => fnd_global.prog_appl_id,
572: p_program_id => fnd_global.conc_program_id,
573: p_program_update_date => SYSDATE,
574: p_period_type => l_threshold_rule_rec.period_type,
575: p_enabled_flag => l_threshold_rule_rec.enabled_flag,
576: p_start_period_name => l_threshold_rule_rec.start_period_name,