DBA Data[Home] [Help]

APPS.PAY_CORE_UTILS dependencies on PAY_CORE_UTILS

Line 1: package body pay_core_utils as

1: package body pay_core_utils as
2: /* $Header: pycorutl.pkb 120.26.12010000.1 2008/07/27 22:23:36 appldev ship $ */
3: --
4: -- Setup Globals
5: --

Line 6: g_pkg varchar2(30) := 'pay_core_utils';

2: /* $Header: pycorutl.pkb 120.26.12010000.1 2008/07/27 22:23:36 appldev ship $ */
3: --
4: -- Setup Globals
5: --
6: g_pkg varchar2(30) := 'pay_core_utils';
7: g_traces BOOLEAN := hr_utility.debug_enabled;
8:
9: type varchar_1_tbl is table of varchar2(1) index by binary_integer;
10: type varchar_50_tbl is table of varchar2(50) index by binary_integer;

Line 208: hr_utility.trace('pay_core_utils.get_business_group_id '||business_group_id);

204: dbms_sql.close_cursor(sql_cur);
205: end if;
206: --
207: if (g_traces) then
208: hr_utility.trace('pay_core_utils.get_business_group_id '||business_group_id);
209: end if;
210: return business_group_id;
211: --
212: exception

Line 266: hr_utility.trace('pay_core_utils.get_dyt_business_group '||business_group_id);

262:
263: end if;
264: --
265: if (g_traces) then
266: hr_utility.trace('pay_core_utils.get_dyt_business_group '||business_group_id);
267: end if;
268: return g_business_group_id;
269: --
270: exception

Line 305: hr_utility.trace('pay_core_utils.get_legislation_code '||g_legislation_code);

301: end if;
302: end if;
303: --
304: if (g_traces) then
305: hr_utility.trace('pay_core_utils.get_legislation_code '||g_legislation_code);
306: end if;
307: return g_legislation_code;
308: --
309: end get_legislation_code;

Line 321: hr_utility.set_location('pay_core_utils.reset_cached_values', 10);

317: */
318: procedure reset_cached_values
319: is
320: begin
321: hr_utility.set_location('pay_core_utils.reset_cached_values', 10);
322: --
323: g_business_group_id := null;
324: g_legislation_code := null;
325: --

Line 326: hr_utility.set_location('pay_core_utils.reset_cached_values', 20);

322: --
323: g_business_group_id := null;
324: g_legislation_code := null;
325: --
326: hr_utility.set_location('pay_core_utils.reset_cached_values', 20);
327: --
328: end reset_cached_values;
329: --
330: -------------------------- get_time_definition ----------------------------

Line 469: g_end_date(p_element_type_id) := pay_core_utils.get_time_period_start

465: if (l_proration_group_id <> -1) then
466: g_end_date(p_element_type_id) := pay_interpreter_pkg.prorate_start_date
467: (p_assignment_action_id, l_proration_group_id);
468: elsif (l_time_definition_type <> 'N') then
469: g_end_date(p_element_type_id) := pay_core_utils.get_time_period_start
470: (p_payroll_action_id);
471: else
472: g_end_date(p_element_type_id) := p_date_earned;
473: end if;

Line 503: pay_proc_logging.PY_ENTRY('pay_core_utils.get_prorated_dates');

499: l_time_def_id number;
500: tmp_num number;
501: begin
502: --
503: pay_proc_logging.PY_ENTRY('pay_core_utils.get_prorated_dates');
504: --
505: pay_proc_logging.PY_LOG_TXT(pay_proc_logging.PY_ELEMETY,
506: 'EE_ID = '||p_ee_id||' AA_ID = '||p_asg_act_id);
507: --

Line 543: pay_proc_logging.PY_EXIT('pay_core_utils.get_prorated_dates');

539: 'Prorate Date '||p_date_array(cnt)||' Type '||p_type_array(cnt));
540: --
541: end loop;
542: --
543: pay_proc_logging.PY_EXIT('pay_core_utils.get_prorated_dates');
544: --
545: end get_prorated_dates;
546: --
547: ------------------------------ set_prorate_dates -------------------------------

Line 703: hr_utility.set_location('pay_core_utils.push_message', 10);

699: p_level in varchar2
700: )
701: is
702: begin
703: hr_utility.set_location('pay_core_utils.push_message', 10);
704: --
705: g_message_stack.sz := g_message_stack.sz + 1;
706: g_message_stack.message_name(g_message_stack.sz) := p_msg_name;
707: g_message_stack.message_txt(g_message_stack.sz) := p_msg_txt;

Line 718: hr_utility.set_location('pay_core_utils.push_message', 20);

714: else
715: g_message_stack.message_level(g_message_stack.sz) := 'F';
716: end if;
717: --
718: hr_utility.set_location('pay_core_utils.push_message', 20);
719: --
720: end push_message;
721: --
722: --------------------------- push_token -------------------------------

Line 734: hr_utility.set_location('pay_core_utils.push_token', 10);

730: p_tok_value in varchar2
731: )
732: is
733: begin
734: hr_utility.set_location('pay_core_utils.push_token', 10);
735: --
736: g_message_tokens.sz := g_message_tokens.sz + 1;
737: g_message_tokens.token_name(g_message_tokens.sz) := p_tok_name;
738: g_message_tokens.token_value(g_message_tokens.sz) := p_tok_value;

Line 746: hr_utility.set_location('pay_core_utils.push_token', 20);

742: g_message_stack.token_str(g_message_stack.sz) := g_message_tokens.sz;
743: end if;
744: g_message_stack.token_end(g_message_stack.sz) := g_message_tokens.sz;
745: --
746: hr_utility.set_location('pay_core_utils.push_token', 20);
747: --
748: end push_token;
749: --
750: --------------------------- pop_message -------------------------------

Line 771: hr_utility.set_location('pay_core_utils.pop_message', 10);

767: p_sev_level out nocopy varchar2
768: )
769: is
770: begin
771: hr_utility.set_location('pay_core_utils.pop_message', 10);
772: --
773: if (g_message_stack.sz = 0) then
774: p_msg_text := null;
775: p_sev_level := null;

Line 804: hr_utility.set_locatIon('pay_core_utils.pop_message', 20);

800: p_sev_level := g_message_stack.message_level(g_message_stack.sz);
801: g_message_tokens.sz := g_message_stack.token_str(g_message_stack.sz) - 1;
802: g_message_stack.sz := g_message_stack.sz - 1;
803: --
804: hr_utility.set_locatIon('pay_core_utils.pop_message', 20);
805: --
806: end pop_message;
807:
808: procedure mesg_stack_error_hdlr(p_pactid in number)

Line 1026: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);

1022: p_pap_group_id in number
1023: )
1024: is
1025: begin
1026: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);
1027: --
1028: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;
1029: --
1030: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);

Line 1028: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;

1024: is
1025: begin
1026: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);
1027: --
1028: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;
1029: --
1030: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);
1031: --
1032: end set_pap_group_id;

Line 1030: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);

1026: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);
1027: --
1028: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;
1029: --
1030: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);
1031: --
1032: end set_pap_group_id;
1033: --
1034: --------------------------- get_pap_group_id -------------------------------

Line 1043: return pay_core_utils.pay_action_parameter_group_id;

1039: */
1040: function get_pap_group_id return number
1041: is
1042: begin
1043: return pay_core_utils.pay_action_parameter_group_id;
1044: --
1045: end get_pap_group_id;
1046: --
1047: --------------------------- get_action_parameter ------------------------

Line 1462: pay_core_utils.assert_condition('pay_core_utils.get_leg_context_iv_name:1',

1458: --
1459: if (l_approved = FALSE
1460: and p_context_name <> 'JURISDICTION_CODE') then
1461: --
1462: pay_core_utils.assert_condition('pay_core_utils.get_leg_context_iv_name:1',
1463: 1 = 2);
1464: --
1465: end if;
1466: --

Line 1986: pay_core_utils.assert_condition(

1982: and l_failure_point = 'P')
1983: or l_failure_point = 'A')
1984: and p_raise_error) then
1985: --
1986: pay_core_utils.assert_condition(
1987: 'pay_core_utils.get_upgrade_status:1',
1988: 1 = 2);
1989: --
1990: else

Line 1987: 'pay_core_utils.get_upgrade_status:1',

1983: or l_failure_point = 'A')
1984: and p_raise_error) then
1985: --
1986: pay_core_utils.assert_condition(
1987: 'pay_core_utils.get_upgrade_status:1',
1988: 1 = 2);
1989: --
1990: else
1991: l_status := 'N';

Line 1999: pay_core_utils.assert_condition(

1995: when no_data_found then
1996: if (( l_failure_point = 'A')
1997: and p_raise_error) then
1998: --
1999: pay_core_utils.assert_condition(
2000: 'pay_core_utils.get_upgrade_status:1',
2001: 1 = 2);
2002: --
2003: else

Line 2000: 'pay_core_utils.get_upgrade_status:1',

1996: if (( l_failure_point = 'A')
1997: and p_raise_error) then
1998: --
1999: pay_core_utils.assert_condition(
2000: 'pay_core_utils.get_upgrade_status:1',
2001: 1 = 2);
2002: --
2003: else
2004: l_status := 'N';

Line 2025: pay_core_utils.assert_condition(

2021: and l_failure_point = 'P' )
2022: or l_failure_point = 'A')
2023: and p_raise_error) then
2024: --
2025: pay_core_utils.assert_condition(
2026: 'pay_core_utils.get_upgrade_status:1',
2027: 1 = 2);
2028: --
2029: else

Line 2026: 'pay_core_utils.get_upgrade_status:1',

2022: or l_failure_point = 'A')
2023: and p_raise_error) then
2024: --
2025: pay_core_utils.assert_condition(
2026: 'pay_core_utils.get_upgrade_status:1',
2027: 1 = 2);
2028: --
2029: else
2030: l_status := 'N';

Line 2038: pay_core_utils.assert_condition(

2034: when no_data_found then
2035: if ((l_failure_point = 'A')
2036: and p_raise_error) then
2037: --
2038: pay_core_utils.assert_condition(
2039: 'pay_core_utils.get_upgrade_status:1',
2040: 1 = 2);
2041: --
2042: else

Line 2039: 'pay_core_utils.get_upgrade_status:1',

2035: if ((l_failure_point = 'A')
2036: and p_raise_error) then
2037: --
2038: pay_core_utils.assert_condition(
2039: 'pay_core_utils.get_upgrade_status:1',
2040: 1 = 2);
2041: --
2042: else
2043: l_status := 'N';

Line 2065: pay_core_utils.assert_condition(

2061: and l_failure_point = 'P' )
2062: or l_failure_point = 'A')
2063: and p_raise_error) then
2064: --
2065: pay_core_utils.assert_condition(
2066: 'pay_core_utils.get_upgrade_status:1',
2067: 1 = 2);
2068: --
2069: else

Line 2066: 'pay_core_utils.get_upgrade_status:1',

2062: or l_failure_point = 'A')
2063: and p_raise_error) then
2064: --
2065: pay_core_utils.assert_condition(
2066: 'pay_core_utils.get_upgrade_status:1',
2067: 1 = 2);
2068: --
2069: else
2070: l_status := 'N';

Line 2078: pay_core_utils.assert_condition(

2074: when no_data_found then
2075: if (( l_failure_point = 'A')
2076: and p_raise_error) then
2077: --
2078: pay_core_utils.assert_condition(
2079: 'pay_core_utils.get_upgrade_status:1',
2080: 1 = 2);
2081: --
2082: else

Line 2079: 'pay_core_utils.get_upgrade_status:1',

2075: if (( l_failure_point = 'A')
2076: and p_raise_error) then
2077: --
2078: pay_core_utils.assert_condition(
2079: 'pay_core_utils.get_upgrade_status:1',
2080: 1 = 2);
2081: --
2082: else
2083: l_status := 'N';

Line 2090: pay_core_utils.assert_condition('pay_core_utils.get_upgrade_status:2',

2086: --
2087: else
2088: --
2089: /* Force an assertion */
2090: pay_core_utils.assert_condition('pay_core_utils.get_upgrade_status:2',
2091: 1 = 2);
2092: end if;
2093: end if;
2094: --

Line 2344: end pay_core_utils;

2340: g_message_stack.sz := 0;
2341: g_message_tokens.sz := 0;
2342: g_process_path := null;
2343: g_asg_action_id := null;
2344: end pay_core_utils;