28: ELSIF p_time_dimension = 'MONTH' THEN
29: l_date_mask := 'MONTH';
30: hr_utility.trace(l_routine_name||': 40');
31: ELSE
32: pay_us_balance_view_pkg.debug_err('Invalid time dimension');
33: END IF;
34:
35: hr_utility.trace('Ending routine: '||l_routine_name);
36: RETURN l_date_mask;
232: p_dimension,
233: p_business_group_id);
234: FETCH csr_get_def_bal_id INTO l_defined_balance_id;
235: IF csr_get_def_bal_id%NOTFOUND THEN
236: pay_us_balance_view_pkg.debug_err
237: ('No defined balance exists.');
238: l_defined_balance_id := NULL;
239: END IF;
240: CLOSE csr_get_def_bal_id;
2508: RETURN l_balance_value;
2509:
2510: EXCEPTION
2511: WHEN e_invalid_time_dimension THEN
2512: pay_us_balance_view_pkg.debug_err('The time dimension is invalid');
2513: WHEN e_no_assignments THEN
2514: pay_us_balance_view_pkg.debug_err('No Assignments to process');
2515: WHEN e_no_gre_or_source_id THEN
2516: pay_us_balance_view_pkg.debug_err('Either a GRE or a Reporting Unit '||
2510: EXCEPTION
2511: WHEN e_invalid_time_dimension THEN
2512: pay_us_balance_view_pkg.debug_err('The time dimension is invalid');
2513: WHEN e_no_assignments THEN
2514: pay_us_balance_view_pkg.debug_err('No Assignments to process');
2515: WHEN e_no_gre_or_source_id THEN
2516: pay_us_balance_view_pkg.debug_err('Either a GRE or a Reporting Unit '||
2517: '(Source Id) must be passed to this routine');
2518: WHEN e_no_gre_specified THEN
2512: pay_us_balance_view_pkg.debug_err('The time dimension is invalid');
2513: WHEN e_no_assignments THEN
2514: pay_us_balance_view_pkg.debug_err('No Assignments to process');
2515: WHEN e_no_gre_or_source_id THEN
2516: pay_us_balance_view_pkg.debug_err('Either a GRE or a Reporting Unit '||
2517: '(Source Id) must be passed to this routine');
2518: WHEN e_no_gre_specified THEN
2519: pay_us_balance_view_pkg.debug_err('The GRE parameter must be specified');
2520: WHEN e_no_source_id_specified THEN
2515: WHEN e_no_gre_or_source_id THEN
2516: pay_us_balance_view_pkg.debug_err('Either a GRE or a Reporting Unit '||
2517: '(Source Id) must be passed to this routine');
2518: WHEN e_no_gre_specified THEN
2519: pay_us_balance_view_pkg.debug_err('The GRE parameter must be specified');
2520: WHEN e_no_source_id_specified THEN
2521: pay_us_balance_view_pkg.debug_err('The Source Id parameter must be specified');
2522: WHEN e_jurisdiction_must_be_null THEN
2523: pay_us_balance_view_pkg.debug_err('The Jurisdiction parameter can not be entered for Reporting Unit balances');
2517: '(Source Id) must be passed to this routine');
2518: WHEN e_no_gre_specified THEN
2519: pay_us_balance_view_pkg.debug_err('The GRE parameter must be specified');
2520: WHEN e_no_source_id_specified THEN
2521: pay_us_balance_view_pkg.debug_err('The Source Id parameter must be specified');
2522: WHEN e_jurisdiction_must_be_null THEN
2523: pay_us_balance_view_pkg.debug_err('The Jurisdiction parameter can not be entered for Reporting Unit balances');
2524: WHEN e_invalid_dim_date_comb THEN
2525: pay_us_balance_view_pkg.debug_err('The Start Date parameter must be entered only when the dimension is PYDATE');
2519: pay_us_balance_view_pkg.debug_err('The GRE parameter must be specified');
2520: WHEN e_no_source_id_specified THEN
2521: pay_us_balance_view_pkg.debug_err('The Source Id parameter must be specified');
2522: WHEN e_jurisdiction_must_be_null THEN
2523: pay_us_balance_view_pkg.debug_err('The Jurisdiction parameter can not be entered for Reporting Unit balances');
2524: WHEN e_invalid_dim_date_comb THEN
2525: pay_us_balance_view_pkg.debug_err('The Start Date parameter must be entered only when the dimension is PYDATE');
2526: WHEN e_no_rpt_unit_for_pydate THEN
2527: pay_us_balance_view_pkg.debug_err('The Reporting Unit dimension can not be used for pay date range calculations');
2521: pay_us_balance_view_pkg.debug_err('The Source Id parameter must be specified');
2522: WHEN e_jurisdiction_must_be_null THEN
2523: pay_us_balance_view_pkg.debug_err('The Jurisdiction parameter can not be entered for Reporting Unit balances');
2524: WHEN e_invalid_dim_date_comb THEN
2525: pay_us_balance_view_pkg.debug_err('The Start Date parameter must be entered only when the dimension is PYDATE');
2526: WHEN e_no_rpt_unit_for_pydate THEN
2527: pay_us_balance_view_pkg.debug_err('The Reporting Unit dimension can not be used for pay date range calculations');
2528: WHEN e_no_start_date_for_pydate THEN
2529: pay_us_balance_view_pkg.debug_err('The Start Date parameter MUST be entered when the dimension is PYDATE');
2523: pay_us_balance_view_pkg.debug_err('The Jurisdiction parameter can not be entered for Reporting Unit balances');
2524: WHEN e_invalid_dim_date_comb THEN
2525: pay_us_balance_view_pkg.debug_err('The Start Date parameter must be entered only when the dimension is PYDATE');
2526: WHEN e_no_rpt_unit_for_pydate THEN
2527: pay_us_balance_view_pkg.debug_err('The Reporting Unit dimension can not be used for pay date range calculations');
2528: WHEN e_no_start_date_for_pydate THEN
2529: pay_us_balance_view_pkg.debug_err('The Start Date parameter MUST be entered when the dimension is PYDATE');
2530:
2531: END ca_group_level_balance;
2525: pay_us_balance_view_pkg.debug_err('The Start Date parameter must be entered only when the dimension is PYDATE');
2526: WHEN e_no_rpt_unit_for_pydate THEN
2527: pay_us_balance_view_pkg.debug_err('The Reporting Unit dimension can not be used for pay date range calculations');
2528: WHEN e_no_start_date_for_pydate THEN
2529: pay_us_balance_view_pkg.debug_err('The Start Date parameter MUST be entered when the dimension is PYDATE');
2530:
2531: END ca_group_level_balance;
2532:
2533: