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 HR_UTILITY

Line 7: g_traces BOOLEAN := hr_utility.debug_enabled;

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;
11: type varchar_240_tbl is table of varchar2(240) index by binary_integer;

Line 183: g_traces := hr_utility.debug_enabled;

179: l_assignment_id number;
180: business_group_id number;
181:
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;

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 249: g_traces := hr_utility.debug_enabled;

245: -- bug 13075414 overload to pass bind variable so reduce hard parsing
246: business_group_id number;
247:
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));

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 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 875: hr_utility.set_message(g_message_stack.applid(g_message_stack.sz),

871: if (g_message_stack.message_name(g_message_stack.sz) is NULL)
872: then
873: p_msg_text := g_message_stack.message_txt(g_message_stack.sz);
874: else
875: hr_utility.set_message(g_message_stack.applid(g_message_stack.sz),
876: g_message_stack.message_name(g_message_stack.sz));
877: --
878: if (g_message_stack.token_str(g_message_stack.sz) is not null) then
879: --

Line 883: hr_utility.set_message_token(g_message_tokens.token_name(tok_cnt),

879: --
880: for tok_cnt in g_message_stack.token_str(g_message_stack.sz) ..
881: g_message_stack.token_end(g_message_stack.sz) loop
882: --
883: hr_utility.set_message_token(g_message_tokens.token_name(tok_cnt),
884: g_message_tokens.token_value(tok_cnt));
885: --
886: end loop;
887: --

Line 890: p_msg_text := hr_utility.get_message;

886: end loop;
887: --
888: end if;
889: --
890: p_msg_text := hr_utility.get_message;
891: end if;
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;

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 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 1768: hr_utility.set_message(801, 'HR_6882_HRPROC_ASSERT') ;

1764: begin
1765: --
1766: if not p_condition
1767: then
1768: hr_utility.set_message(801, 'HR_6882_HRPROC_ASSERT') ;
1769: hr_utility.set_message_token('LOCATION', p_location);
1770: hr_utility.raise_error ;
1771: end if;
1772: --

Line 1769: hr_utility.set_message_token('LOCATION', p_location);

1765: --
1766: if not p_condition
1767: then
1768: hr_utility.set_message(801, 'HR_6882_HRPROC_ASSERT') ;
1769: hr_utility.set_message_token('LOCATION', p_location);
1770: hr_utility.raise_error ;
1771: end if;
1772: --
1773: end assert_condition;

Line 1770: hr_utility.raise_error ;

1766: if not p_condition
1767: then
1768: hr_utility.set_message(801, 'HR_6882_HRPROC_ASSERT') ;
1769: hr_utility.set_message_token('LOCATION', p_location);
1770: hr_utility.raise_error ;
1771: end if;
1772: --
1773: end assert_condition;
1774: --

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 2487: hr_utility.trace('No Pay Value for the element: '|| p_element_type_id);

2483: if search_input_value_id%notfound THEN
2484: close search_input_value_id;
2485: p_status := 'NO_PAY_VALUE_FOUND';
2486: if (g_traces) then
2487: hr_utility.trace('No Pay Value for the element: '|| p_element_type_id);
2488: end if;
2489: end if;
2490: CLOSE search_input_value_id;
2491: --

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