110: else
111: p_expiry_information := 0;
112: end if;
113: ELSE
114: fnd_message.set_name('PAY', 'This dimension is invalid');
115: fnd_message.raise_error;
116: END IF;
117: --
118: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
111: p_expiry_information := 0;
112: end if;
113: ELSE
114: fnd_message.set_name('PAY', 'This dimension is invalid');
115: fnd_message.raise_error;
116: END IF;
117: --
118: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
119: hr_utility.set_location('Leaving : ' || l_proc, 40);
185: p_dimension_name,
186: l_owner_date_earned);
187: END IF;
188: ELSE
189: fnd_message.set_name('PAY', 'This dimension is invalid');
190: fnd_message.raise_error;
191: END IF;
192: --
193: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
186: l_owner_date_earned);
187: END IF;
188: ELSE
189: fnd_message.set_name('PAY', 'This dimension is invalid');
190: fnd_message.raise_error;
191: END IF;
192: --
193: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
194: hr_utility.set_location('Leaving : ' || l_proc, 20);
534: --
535: elsif l_dimension_name in (
536: hr_jprts.g_element_itd,
537: hr_jprts.g_element_ptd) then
538: fnd_message.set_name('PAY', 'This dimension is invalid');
539: fnd_message.raise_error;
540: --
541: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp then
542: l_from_date := hr_jprts.dimension_reset_date_userdef(
535: elsif l_dimension_name in (
536: hr_jprts.g_element_itd,
537: hr_jprts.g_element_ptd) then
538: fnd_message.set_name('PAY', 'This dimension is invalid');
539: fnd_message.raise_error;
540: --
541: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp then
542: l_from_date := hr_jprts.dimension_reset_date_userdef(
543: l_dimension_name,
594: l_action_sequence);
595: end if;
596: -- Specified dimension is not supported
597: else
598: fnd_message.set_name('PAY', 'This dimension is invalid');
599: fnd_message.raise_error;
600: end if;
601: --
602: RETURN l_balance;
595: end if;
596: -- Specified dimension is not supported
597: else
598: fnd_message.set_name('PAY', 'This dimension is invalid');
599: fnd_message.raise_error;
600: end if;
601: --
602: RETURN l_balance;
603: END balance;
2935: l_balance_type_id);
2936: /* -- This function can not call the calculation of Element dimension.
2937: -- Because it needs source_id.
2938: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
2939: -- fnd_message.set_name('PAY','This dimension is invalid');
2940: -- fnd_message.raise_error;
2941: --l_balance := NULL;
2942: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
2943: -- fnd_message.set_name('PAY','This dimension is invalid');
2936: /* -- This function can not call the calculation of Element dimension.
2937: -- Because it needs source_id.
2938: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
2939: -- fnd_message.set_name('PAY','This dimension is invalid');
2940: -- fnd_message.raise_error;
2941: --l_balance := NULL;
2942: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
2943: -- fnd_message.set_name('PAY','This dimension is invalid');
2944: -- fnd_message.raise_error;
2939: -- fnd_message.set_name('PAY','This dimension is invalid');
2940: -- fnd_message.raise_error;
2941: --l_balance := NULL;
2942: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
2943: -- fnd_message.set_name('PAY','This dimension is invalid');
2944: -- fnd_message.raise_error;
2945: -- l_balance := NULL; */
2946: --ELSE the balance must be for a USER-REG level dimension
2947: ELSE
2940: -- fnd_message.raise_error;
2941: --l_balance := NULL;
2942: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
2943: -- fnd_message.set_name('PAY','This dimension is invalid');
2944: -- fnd_message.raise_error;
2945: -- l_balance := NULL; */
2946: --ELSE the balance must be for a USER-REG level dimension
2947: ELSE
2948: l_balance := balance(p_assignment_action_id, p_defined_balance_id);
3059: p_effective_date);
3060: /* -- This function can not call the calculation of Element dimension.
3061: -- Because it needs source_id.
3062: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
3063: -- fnd_message.set_name('PAY','This dimension is invalid');
3064: -- fnd_message.raise_error;
3065: -- l_balance := NULL;
3066: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
3067: -- fnd_message.set_name('PAY','This dimension is invalid');
3060: /* -- This function can not call the calculation of Element dimension.
3061: -- Because it needs source_id.
3062: -- ELSIF l_dimension_name = hr_jprts.g_element_itd then
3063: -- fnd_message.set_name('PAY','This dimension is invalid');
3064: -- fnd_message.raise_error;
3065: -- l_balance := NULL;
3066: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
3067: -- fnd_message.set_name('PAY','This dimension is invalid');
3068: -- fnd_message.raise_error;
3063: -- fnd_message.set_name('PAY','This dimension is invalid');
3064: -- fnd_message.raise_error;
3065: -- l_balance := NULL;
3066: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
3067: -- fnd_message.set_name('PAY','This dimension is invalid');
3068: -- fnd_message.raise_error;
3069: -- l_balance := NULL; */
3070: ----
3071: -- This comment is no more effective because new function has been added
3064: -- fnd_message.raise_error;
3065: -- l_balance := NULL;
3066: -- ELSIF l_dimension_name = hr_jprts.g_element_ptd then
3067: -- fnd_message.set_name('PAY','This dimension is invalid');
3068: -- fnd_message.raise_error;
3069: -- l_balance := NULL; */
3070: ----
3071: -- This comment is no more effective because new function has been added
3072: -- for hr_jprts.g_asg_jul2jun_jp and hr_jprts.g_asg_fytd2_jp