73:
74: BEGIN
75:
76: lv_procedure_name := 'PAY_US_ELEM_ENT_CHK_LEG_HOOK.CHK_ELEM_ENTRY';
77: hr_utility.trace('Entering '|| lv_procedure_name);
78: hr_utility.set_location (lv_procedure_name,10);
79: hr_utility.trace('Input parameters....');
80: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
81: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
74: BEGIN
75:
76: lv_procedure_name := 'PAY_US_ELEM_ENT_CHK_LEG_HOOK.CHK_ELEM_ENTRY';
77: hr_utility.trace('Entering '|| lv_procedure_name);
78: hr_utility.set_location (lv_procedure_name,10);
79: hr_utility.trace('Input parameters....');
80: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
81: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
82: hr_utility.trace('p_element_entry_link_id = '|| p_element_link_id);
75:
76: lv_procedure_name := 'PAY_US_ELEM_ENT_CHK_LEG_HOOK.CHK_ELEM_ENTRY';
77: hr_utility.trace('Entering '|| lv_procedure_name);
78: hr_utility.set_location (lv_procedure_name,10);
79: hr_utility.trace('Input parameters....');
80: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
81: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
82: hr_utility.trace('p_element_entry_link_id = '|| p_element_link_id);
83:
76: lv_procedure_name := 'PAY_US_ELEM_ENT_CHK_LEG_HOOK.CHK_ELEM_ENTRY';
77: hr_utility.trace('Entering '|| lv_procedure_name);
78: hr_utility.set_location (lv_procedure_name,10);
79: hr_utility.trace('Input parameters....');
80: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
81: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
82: hr_utility.trace('p_element_entry_link_id = '|| p_element_link_id);
83:
84: ln_architecture_flag := -1; /* No architecture selected currently */
77: hr_utility.trace('Entering '|| lv_procedure_name);
78: hr_utility.set_location (lv_procedure_name,10);
79: hr_utility.trace('Input parameters....');
80: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
81: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
82: hr_utility.trace('p_element_entry_link_id = '|| p_element_link_id);
83:
84: ln_architecture_flag := -1; /* No architecture selected currently */
85: lb_status := TRUE;
78: hr_utility.set_location (lv_procedure_name,10);
79: hr_utility.trace('Input parameters....');
80: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
81: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
82: hr_utility.trace('p_element_entry_link_id = '|| p_element_link_id);
83:
84: ln_architecture_flag := -1; /* No architecture selected currently */
85: lb_status := TRUE;
86: lv_element_name := null;
149: end loop;
150: close c_get_elem_entries;
151:
152: if lb_status then
153: hr_utility.set_location (lv_procedure_name,20);
154: hr_utility.trace('Leaving '||lv_procedure_name);
155: return;
156: else
157: hr_utility.set_location (lv_procedure_name,30);
150: close c_get_elem_entries;
151:
152: if lb_status then
153: hr_utility.set_location (lv_procedure_name,20);
154: hr_utility.trace('Leaving '||lv_procedure_name);
155: return;
156: else
157: hr_utility.set_location (lv_procedure_name,30);
158: hr_utility.set_message(801,'PAY_US_WAGE_ARCH_DIFF');
153: hr_utility.set_location (lv_procedure_name,20);
154: hr_utility.trace('Leaving '||lv_procedure_name);
155: return;
156: else
157: hr_utility.set_location (lv_procedure_name,30);
158: hr_utility.set_message(801,'PAY_US_WAGE_ARCH_DIFF');
159: hr_utility.raise_error;
160: end if;
161:
154: hr_utility.trace('Leaving '||lv_procedure_name);
155: return;
156: else
157: hr_utility.set_location (lv_procedure_name,30);
158: hr_utility.set_message(801,'PAY_US_WAGE_ARCH_DIFF');
159: hr_utility.raise_error;
160: end if;
161:
162: END CHK_ELEM_ENTRY;
155: return;
156: else
157: hr_utility.set_location (lv_procedure_name,30);
158: hr_utility.set_message(801,'PAY_US_WAGE_ARCH_DIFF');
159: hr_utility.raise_error;
160: end if;
161:
162: END CHK_ELEM_ENTRY;
163: