eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.36 2011/12/15 07:24:22 panumala ship $ */
3: --
4: -- Setup Globals
5: --

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

2: /* $Header: pycorutl.pkb 120.36 2011/12/15 07:24:22 panumala 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 186: hr_utility.trace('pay_core_utils.get_business_group p_statement:'||p_statement);

182: begin
183: g_traces := hr_utility.debug_enabled;
184:
185: if (g_traces) then
186: hr_utility.trace('pay_core_utils.get_business_group p_statement:'||p_statement);
187: end if;
188:
189: if (g_cache_business_group) then
190:

Line 207: hr_utility.trace('pay_core_utils.get_business_group post dbms_sql.parse exception');

203: p_statement,
204: dbms_sql.v7);
205: exception
206: when others then
207: hr_utility.trace('pay_core_utils.get_business_group post dbms_sql.parse exception');
208: dbms_sql.close_cursor(sql_cur);
209: return NULL;
210: end;
211: --

Line 224: hr_utility.trace('pay_core_utils.get_business_group id: '||business_group_id);

220: end if;
221: end if;
222: --
223: if (g_traces) then
224: hr_utility.trace('pay_core_utils.get_business_group id: '||business_group_id);
225: end if;
226: return business_group_id;
227: --
228: exception

Line 252: hr_utility.trace('pay_core_utils.get_business_group_withbind p_statement:'||p_statement||

248: begin
249: g_traces := hr_utility.debug_enabled;
250:
251: if (g_traces) then
252: hr_utility.trace('pay_core_utils.get_business_group_withbind p_statement:'||p_statement||
253: ' p_bindvar:'||to_char(p_bindvar));
254: end if;
255:
256: if (g_cache_business_group) then

Line 265: hr_utility.trace('pay_core_utils.get_business_group_withbind id: '||business_group_id);

261:
262: end if;
263: --
264: if (g_traces) then
265: hr_utility.trace('pay_core_utils.get_business_group_withbind id: '||business_group_id);
266: end if;
267:
268: return business_group_id;
269: --

Line 325: hr_utility.trace('pay_core_utils.get_dyt_business_group id:'||to_char(business_group_id)||

321:
322: end if;
323: --
324: if (g_traces) then
325: hr_utility.trace('pay_core_utils.get_dyt_business_group id:'||to_char(business_group_id)||
326: ' g_bg_id:'||to_char(g_business_group_id));
327: end if;
328: return g_business_group_id;
329: --

Line 364: hr_utility.trace('pay_core_utils.get_dyt_business_group id:'||to_char(business_group_id)||

360:
361: end if;
362: --
363: if (g_traces) then
364: hr_utility.trace('pay_core_utils.get_dyt_business_group id:'||to_char(business_group_id)||
365: ' g_bg_id:'||to_char(g_business_group_id));
366: end if;
367: return g_business_group_id;
368: --

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

393: end if;
394: end if;
395: --
396: if (g_traces) then
397: hr_utility.trace('pay_core_utils.get_legislation_code '||g_legislation_code);
398: end if;
399: return g_legislation_code;
400: --
401: end get_legislation_code;

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

409: */
410: procedure reset_cached_values
411: is
412: begin
413: hr_utility.set_location('pay_core_utils.reset_cached_values', 10);
414: --
415: g_business_group_id := null;
416: g_legislation_code := null;
417: --

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

414: --
415: g_business_group_id := null;
416: g_legislation_code := null;
417: --
418: hr_utility.set_location('pay_core_utils.reset_cached_values', 20);
419: --
420: end reset_cached_values;
421: --
422: -------------------------- get_time_definition ----------------------------

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

557: if (l_proration_group_id <> -1) then
558: g_end_date(p_element_type_id) := pay_interpreter_pkg.prorate_start_date
559: (p_assignment_action_id, l_proration_group_id);
560: elsif (l_time_definition_type <> 'N') then
561: g_end_date(p_element_type_id) := pay_core_utils.get_time_period_start
562: (p_payroll_action_id);
563: else
564: g_end_date(p_element_type_id) := p_date_earned;
565: end if;

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

591: l_time_def_id number;
592: tmp_num number;
593: begin
594: --
595: pay_proc_logging.PY_ENTRY('pay_core_utils.get_prorated_dates');
596: --
597: pay_proc_logging.PY_LOG_TXT(pay_proc_logging.PY_ELEMETY,
598: 'EE_ID = '||p_ee_id||' AA_ID = '||p_asg_act_id);
599: --

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

631: 'Prorate Date '||p_date_array(cnt)||' Type '||p_type_array(cnt));
632: --
633: end loop;
634: --
635: pay_proc_logging.PY_EXIT('pay_core_utils.get_prorated_dates');
636: --
637: end get_prorated_dates;
638: --
639: ------------------------------ set_prorate_dates -------------------------------

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

791: p_level in varchar2
792: )
793: is
794: begin
795: hr_utility.set_location('pay_core_utils.push_message', 10);
796: --
797: g_message_stack.sz := g_message_stack.sz + 1;
798: g_message_stack.message_name(g_message_stack.sz) := p_msg_name;
799: g_message_stack.message_txt(g_message_stack.sz) := p_msg_txt;

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

806: else
807: g_message_stack.message_level(g_message_stack.sz) := 'F';
808: end if;
809: --
810: hr_utility.set_location('pay_core_utils.push_message', 20);
811: --
812: end push_message;
813: --
814: --------------------------- push_token -------------------------------

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

822: p_tok_value in varchar2
823: )
824: is
825: begin
826: hr_utility.set_location('pay_core_utils.push_token', 10);
827: --
828: g_message_tokens.sz := g_message_tokens.sz + 1;
829: g_message_tokens.token_name(g_message_tokens.sz) := p_tok_name;
830: g_message_tokens.token_value(g_message_tokens.sz) := p_tok_value;

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

834: g_message_stack.token_str(g_message_stack.sz) := g_message_tokens.sz;
835: end if;
836: g_message_stack.token_end(g_message_stack.sz) := g_message_tokens.sz;
837: --
838: hr_utility.set_location('pay_core_utils.push_token', 20);
839: --
840: end push_token;
841: --
842: --------------------------- pop_message -------------------------------

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

859: p_sev_level out nocopy varchar2
860: )
861: is
862: begin
863: hr_utility.set_location('pay_core_utils.pop_message', 10);
864: --
865: if (g_message_stack.sz = 0) then
866: p_msg_text := null;
867: p_sev_level := null;

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

892: p_sev_level := g_message_stack.message_level(g_message_stack.sz);
893: g_message_tokens.sz := g_message_stack.token_str(g_message_stack.sz) - 1;
894: g_message_stack.sz := g_message_stack.sz - 1;
895: --
896: hr_utility.set_locatIon('pay_core_utils.pop_message', 20);
897: --
898: end pop_message;
899:
900: procedure mesg_stack_error_hdlr(p_pactid in number)

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

1114: p_pap_group_id in number
1115: )
1116: is
1117: begin
1118: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);
1119: --
1120: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;
1121: --
1122: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);

Line 1120: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;

1116: is
1117: begin
1118: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);
1119: --
1120: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;
1121: --
1122: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);
1123: --
1124: end set_pap_group_id;

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

1118: hr_utility.set_location('pay_core_utils.set_pap_group_id', 10);
1119: --
1120: pay_core_utils.pay_action_parameter_group_id := p_pap_group_id;
1121: --
1122: hr_utility.set_location('pay_core_utils.set_pap_group_id', 20);
1123: --
1124: end set_pap_group_id;
1125: --
1126: --------------------------- get_pap_group_id -------------------------------

Line 1135: return pay_core_utils.pay_action_parameter_group_id;

1131: */
1132: function get_pap_group_id return number
1133: is
1134: begin
1135: return pay_core_utils.pay_action_parameter_group_id;
1136: --
1137: end get_pap_group_id;
1138: --
1139: --------------------------- get_action_parameter ------------------------

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

1571: --
1572: if (l_approved = FALSE
1573: and p_context_name <> 'JURISDICTION_CODE') then
1574: --
1575: pay_core_utils.assert_condition('pay_core_utils.get_leg_context_iv_name:1',
1576: 1 = 2);
1577: --
1578: end if;
1579: --

Line 2107: pay_core_utils.assert_condition(

2103: and l_failure_point = 'P')
2104: or l_failure_point = 'A')
2105: and p_raise_error) then
2106: --
2107: pay_core_utils.assert_condition(
2108: 'pay_core_utils.get_upgrade_status:1',
2109: 1 = 2);
2110: --
2111: else

Line 2108: 'pay_core_utils.get_upgrade_status:1',

2104: or l_failure_point = 'A')
2105: and p_raise_error) then
2106: --
2107: pay_core_utils.assert_condition(
2108: 'pay_core_utils.get_upgrade_status:1',
2109: 1 = 2);
2110: --
2111: else
2112: l_status := 'N';

Line 2120: pay_core_utils.assert_condition(

2116: when no_data_found then
2117: if (( l_failure_point = 'A')
2118: and p_raise_error) then
2119: --
2120: pay_core_utils.assert_condition(
2121: 'pay_core_utils.get_upgrade_status:1',
2122: 1 = 2);
2123: --
2124: else

Line 2121: 'pay_core_utils.get_upgrade_status:1',

2117: if (( l_failure_point = 'A')
2118: and p_raise_error) then
2119: --
2120: pay_core_utils.assert_condition(
2121: 'pay_core_utils.get_upgrade_status:1',
2122: 1 = 2);
2123: --
2124: else
2125: l_status := 'N';

Line 2146: pay_core_utils.assert_condition(

2142: and l_failure_point = 'P' )
2143: or l_failure_point = 'A')
2144: and p_raise_error) then
2145: --
2146: pay_core_utils.assert_condition(
2147: 'pay_core_utils.get_upgrade_status:1',
2148: 1 = 2);
2149: --
2150: else

Line 2147: 'pay_core_utils.get_upgrade_status:1',

2143: or l_failure_point = 'A')
2144: and p_raise_error) then
2145: --
2146: pay_core_utils.assert_condition(
2147: 'pay_core_utils.get_upgrade_status:1',
2148: 1 = 2);
2149: --
2150: else
2151: l_status := 'N';

Line 2159: pay_core_utils.assert_condition(

2155: when no_data_found then
2156: if ((l_failure_point = 'A')
2157: and p_raise_error) then
2158: --
2159: pay_core_utils.assert_condition(
2160: 'pay_core_utils.get_upgrade_status:1',
2161: 1 = 2);
2162: --
2163: else

Line 2160: 'pay_core_utils.get_upgrade_status:1',

2156: if ((l_failure_point = 'A')
2157: and p_raise_error) then
2158: --
2159: pay_core_utils.assert_condition(
2160: 'pay_core_utils.get_upgrade_status:1',
2161: 1 = 2);
2162: --
2163: else
2164: l_status := 'N';

Line 2186: pay_core_utils.assert_condition(

2182: and l_failure_point = 'P' )
2183: or l_failure_point = 'A')
2184: and p_raise_error) then
2185: --
2186: pay_core_utils.assert_condition(
2187: 'pay_core_utils.get_upgrade_status:1',
2188: 1 = 2);
2189: --
2190: else

Line 2187: 'pay_core_utils.get_upgrade_status:1',

2183: or l_failure_point = 'A')
2184: and p_raise_error) then
2185: --
2186: pay_core_utils.assert_condition(
2187: 'pay_core_utils.get_upgrade_status:1',
2188: 1 = 2);
2189: --
2190: else
2191: l_status := 'N';

Line 2199: pay_core_utils.assert_condition(

2195: when no_data_found then
2196: if (( l_failure_point = 'A')
2197: and p_raise_error) then
2198: --
2199: pay_core_utils.assert_condition(
2200: 'pay_core_utils.get_upgrade_status:1',
2201: 1 = 2);
2202: --
2203: else

Line 2200: 'pay_core_utils.get_upgrade_status:1',

2196: if (( l_failure_point = 'A')
2197: and p_raise_error) then
2198: --
2199: pay_core_utils.assert_condition(
2200: 'pay_core_utils.get_upgrade_status:1',
2201: 1 = 2);
2202: --
2203: else
2204: l_status := 'N';

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

2207: --
2208: else
2209: --
2210: /* Force an assertion */
2211: pay_core_utils.assert_condition('pay_core_utils.get_upgrade_status:2',
2212: 1 = 2);
2213: end if;
2214: end if;
2215: --

Line 2477: hr_utility.trace('Entered pay_core_utils '|| lv_proc);

2473: --
2474: BEGIN
2475: --
2476: if (g_traces) then
2477: hr_utility.trace('Entered pay_core_utils '|| lv_proc);
2478: end if;
2479: --
2480: OPEN search_input_value_id(p_element_type_id);
2481: FETCH search_input_value_id INTO v_input_value_id;

Line 2500: hr_utility.trace('Leaving pay_core_utils '|| lv_proc);

2496: IF SQL%ROWCOUNT > 0 THEN
2497: p_status := 'Success';
2498: END IF ;
2499: --
2500: hr_utility.trace('Leaving pay_core_utils '|| lv_proc);
2501: --
2502: EXCEPTION
2503: WHEN OTHERS THEN
2504: p_status := 'Error';

Line 2516: end pay_core_utils;

2512: g_message_stack.sz := 0;
2513: g_message_tokens.sz := 0;
2514: g_process_path := null;
2515: g_asg_action_id := null;
2516: end pay_core_utils;