65: WHERE assignment_id=c_assignment_id
66: AND business_group_id=c_bg_id
67: AND c_effective_date BETWEEN effective_start_date AND effective_end_date );
68: BEGIN
69: g_debug := hr_utility.debug_enabled;
70:
71: IF g_debug THEN
72: hr_utility.set_location('Start of PER_SG_ASG_LEG_HOOK.UPDATE_SG_ASG',1);
73: END IF;
68: BEGIN
69: g_debug := hr_utility.debug_enabled;
70:
71: IF g_debug THEN
72: hr_utility.set_location('Start of PER_SG_ASG_LEG_HOOK.UPDATE_SG_ASG',1);
73: END IF;
74:
75: OPEN c_tax_unit_id(p_assignment_id, p_effective_date);
76: FETCH c_tax_unit_id into l_tax_unit_id, l_bg_id;
97: IF (l_future_actions_exist <> 'YES' AND p_datetrack_update_mode = 'UPDATE') THEN
98: NULL;
99: ELSE
100: IF p_datetrack_update_mode = 'CORRECTION' THEN
101: hr_utility.set_message(801, 'HR_SG_LEGAL_EMP_CHANGE2');
102: ELSE
103: hr_utility.set_message(801, 'HR_SG_LEGAL_EMP_CHANGE1');
104: END IF;
105: hr_utility.raise_error;
99: ELSE
100: IF p_datetrack_update_mode = 'CORRECTION' THEN
101: hr_utility.set_message(801, 'HR_SG_LEGAL_EMP_CHANGE2');
102: ELSE
103: hr_utility.set_message(801, 'HR_SG_LEGAL_EMP_CHANGE1');
104: END IF;
105: hr_utility.raise_error;
106:
107: IF g_debug THEN
101: hr_utility.set_message(801, 'HR_SG_LEGAL_EMP_CHANGE2');
102: ELSE
103: hr_utility.set_message(801, 'HR_SG_LEGAL_EMP_CHANGE1');
104: END IF;
105: hr_utility.raise_error;
106:
107: IF g_debug THEN
108: hr_utility.set_location('End of PER_SG_ASG_LEG_HOOK.UPDATE_SG_ASG', 2);
109: END IF;
104: END IF;
105: hr_utility.raise_error;
106:
107: IF g_debug THEN
108: hr_utility.set_location('End of PER_SG_ASG_LEG_HOOK.UPDATE_SG_ASG', 2);
109: END IF;
110: END IF;
111: END IF;
112: END IF;
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: IF g_debug THEN
118: hr_utility.set_location('Error in PER_SG_ASG_LEG_HOOK.UPDATE_SG_ASG', 100);
119: END IF;
120: RAISE;
121:
122: