DBA Data[Home] [Help]

APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_US_BALANCE_VIEW_PKG

Line 32: pay_us_balance_view_pkg.debug_err('Invalid time dimension');

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;

Line 236: pay_us_balance_view_pkg.debug_err

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;

Line 2512: pay_us_balance_view_pkg.debug_err('The time dimension is invalid');

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 '||

Line 2514: pay_us_balance_view_pkg.debug_err('No Assignments to process');

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

Line 2516: pay_us_balance_view_pkg.debug_err('Either a GRE or a Reporting Unit '||

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

Line 2519: pay_us_balance_view_pkg.debug_err('The GRE parameter must be specified');

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');

Line 2521: pay_us_balance_view_pkg.debug_err('The Source Id parameter must be specified');

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');

Line 2523: pay_us_balance_view_pkg.debug_err('The Jurisdiction parameter can not be entered for Reporting Unit balances');

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');

Line 2525: pay_us_balance_view_pkg.debug_err('The Start Date parameter must be entered only when the dimension is PYDATE');

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');

Line 2527: pay_us_balance_view_pkg.debug_err('The Reporting Unit dimension can not be used for pay date range calculations');

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;

Line 2529: pay_us_balance_view_pkg.debug_err('The Start Date parameter MUST be entered when the dimension is PYDATE');

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: