APPS.PAY_LOAD_PARAMETERS dependencies on HR_UTILITY

Line 66: hr_utility.trace('After getting qualifier_name : '||l_qualifier);

62: l_qualifier := p_qualifier;
63: found := TRUE;
64: end loop;
65: --
66: hr_utility.trace('After getting qualifier_name : '||l_qualifier);
67:
68: if(found = TRUE) then
69:
70: UPDATE PAY_PARAMETER_QUALIFIERS SET

Line 79: hr_utility.trace('Inserting new qualifier : '||p_qualifier);

75: WHERE qualifier = l_qualifier ;
76:
77: else
78:
79: hr_utility.trace('Inserting new qualifier : '||p_qualifier);
80:
81: INSERT INTO PAY_PARAMETER_QUALIFIERS (
82: qualifier
83: , description

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

97: end if;
98: --
99: exception
100: when others then
101: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
102: --
103: end load_parameter_qualifiers;
104:
105: --------

Line 152: hr_utility.trace('After getrec, l_parameter_id : '||l_parameter_id);

148: for getrec in pp_exits(p_parameter_name) loop
149: l_parameter_id := getrec.parameter_id;
150: found := TRUE;
151: end loop;
152: hr_utility.trace('After getrec, l_parameter_id : '||l_parameter_id);
153: --
154: if (p_bg_name is not null) then
155: select business_group_id
156: into l_business_group_id

Line 177: hr_utility.trace('Before inserting, l_param_def_id : '||l_parameter_def_id);

173: open get_param_def_id(p_parameter_name);
174: fetch get_param_def_id into l_parameter_def_id;
175: close get_param_def_id;
176:
177: hr_utility.trace('Before inserting, l_param_def_id : '||l_parameter_def_id);
178:
179: INSERT INTO PAY_PARAMETERS (
180: parameter_id
181: , parameter_def_id

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

204: end if;
205: --
206: exception
207: when others then
208: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
209: --
210: end load_parameterS;
211:
212: --------

Line 244: hr_utility.trace('After getrec, l_parameter_def_id: '||l_parameter_def_id);

240: l_parameter_def_id := getrec.parameter_def_id;
241: found := TRUE;
242: end loop;
243:
244: hr_utility.trace('After getrec, l_parameter_def_id: '||l_parameter_def_id);
245: --
246: if(found = TRUE) then
247:
248: UPDATE PAY_PARAMETER_DEFINITIONS SET

Line 267: hr_utility.trace('Inserting into pay_parameter_definitions... :'|| p_parameter_name);

263: ,LAST_UPDATE_LOGIN = fnd_global.login_id
264: WHERE parameter_def_id = l_parameter_def_id ;
265:
266: else
267: hr_utility.trace('Inserting into pay_parameter_definitions... :'|| p_parameter_name);
268:
269: INSERT INTO PAY_PARAMETER_DEFINITIONS (
270: parameter_def_id
271: ,parameter_name

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

321: end if;
322: --
323: exception
324: when others then
325: hr_utility.trace('An exception was raised : '||dbms_utility.format_error_stack );
326: --
327: end load_parameter_definitions;
328:
329: --------