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_LOAD_PROCESS_FLOWS dependencies on HR_UTILITY

Line 94: hr_utility.trace('After getting bg_name : '||l_business_group_id);

90: from per_business_groups
91: where name = p_bg_name;
92: end if;
93: --
94: hr_utility.trace('After getting bg_name : '||l_business_group_id);
95:
96: if(found = TRUE) then
97:
98: UPDATE PAY_PARAMETER_SETS SET

Line 113: hr_utility.trace('After get_set_name_id : '||l_set_name_id);

109: FETCH c_get_set_name_id into l_set_name_id;
110: CLOSE c_get_set_name_id;
111:
112:
113: hr_utility.trace('After get_set_name_id : '||l_set_name_id);
114:
115: INSERT INTO PAY_PARAMETER_SETS (
116: set_id
117: , set_name_id

Line 144: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );

140: end if;
141: --
142: exception
143: when others then
144: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
145: --
146: end load_parameter_sets;
147:
148: --------

Line 224: hr_utility.trace('After getrec, l_set_variable_id : '||l_set_variable_id);

220: for getrec in psvexists(p_set_name,p_param_name) loop
221: l_set_variable_id := getrec.set_variable_id;
222: found := TRUE;
223: end loop;
224: hr_utility.trace('After getrec, l_set_variable_id : '||l_set_variable_id);
225: --
226: if (p_bg_name is not null) then
227: select business_group_id
228: into l_business_group_id

Line 258: hr_utility.trace('Before inserting, l_set_id : '||l_set_id);

254: OPEN c_get_set_id(p_set_name);
255: FETCH c_get_set_id into l_set_id;
256: CLOSE c_get_set_id;
257:
258: hr_utility.trace('Before inserting, l_set_id : '||l_set_id);
259:
260: INSERT INTO PAY_PARA_SET_VARIABLES (
261: set_variable_id
262: , set_id

Line 301: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );

297: end if;
298: --
299: exception
300: when others then
301: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
302: --
303: end load_para_set_variables;
304:
305: --------

Line 397: hr_utility.trace('After getrec, l_shared_variable_id: '||l_shared_variable_id);

393: l_shared_variable_id := getrec.shared_variable_id;
394: found := TRUE;
395: end loop;
396:
397: hr_utility.trace('After getrec, l_shared_variable_id: '||l_shared_variable_id);
398:
399: --
400: if (p_bg_name is not null) then
401: select business_group_id

Line 417: hr_utility.trace('After get_src_id :'|| l_source_set_var_id);

413: open get_src_dstn_set_var_id(p_flow_name,p_flow_param);
414: fetch get_src_dstn_set_var_id into l_source_set_var_id;
415: close get_src_dstn_set_var_id;
416:
417: hr_utility.trace('After get_src_id :'|| l_source_set_var_id);
418:
419: open get_src_dstn_set_var_id(p_set_name,p_set_param);
420: fetch get_src_dstn_set_var_id into l_destin_set_var_id;
421: close get_src_dstn_set_var_id;

Line 423: hr_utility.trace('After get_dest_id :'|| l_destin_set_var_id);

419: open get_src_dstn_set_var_id(p_set_name,p_set_param);
420: fetch get_src_dstn_set_var_id into l_destin_set_var_id;
421: close get_src_dstn_set_var_id;
422:
423: hr_utility.trace('After get_dest_id :'|| l_destin_set_var_id);
424:
425: INSERT INTO PAY_PARA_SET_OVERRIDE_VARS (
426: shared_variable_id
427: , source_set_var_id

Line 452: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );

448: end if;
449: --
450: exception
451: when others then
452: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
453: --
454: end load_para_set_override_vars;
455:
456: --------

Line 567: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );

563: end if;
564: --
565: exception
566: when others then
567: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
568: --
569: end load_process_flows;
570:
571:

Line 677: hr_utility.trace('Before inserting, l_set_id: '|| l_set_id);

673: OPEN c_get_flow_id(p_flow_name);
674: FETCH c_get_flow_id into l_process_flow_id;
675: CLOSE c_get_flow_id;
676:
677: hr_utility.trace('Before inserting, l_set_id: '|| l_set_id);
678: hr_utility.trace('Before inserting, l_process_flow_id: '|| l_process_flow_id);
679:
680: INSERT INTO PAY_PROCESS_FLOW_SETS (
681: process_flow_set_id

Line 678: hr_utility.trace('Before inserting, l_process_flow_id: '|| l_process_flow_id);

674: FETCH c_get_flow_id into l_process_flow_id;
675: CLOSE c_get_flow_id;
676:
677: hr_utility.trace('Before inserting, l_set_id: '|| l_set_id);
678: hr_utility.trace('Before inserting, l_process_flow_id: '|| l_process_flow_id);
679:
680: INSERT INTO PAY_PROCESS_FLOW_SETS (
681: process_flow_set_id
682: , process_flow_id

Line 709: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );

705: end if;
706: --
707: exception
708: when others then
709: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
710: --
711: end load_process_flow_sets;
712:
713: end PAY_LOAD_PROCESS_FLOWS;