APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on HR_UTILITY

Line 85: hr_utility.trace('A4 CKF call p_cost_allocation_keyflex is : '|| l_ccid);

81: p_segment28 =>l_segment28,
82: p_segment29 =>l_segment29,
83: p_segment30 =>l_segment30);
84:
85: hr_utility.trace('A4 CKF call p_cost_allocation_keyflex is : '|| l_ccid);
86:
87: return(l_ccid);
88:
89: end get_costing_info;

Line 106: hr_utility.trace('p_batch_name' || p_batch_name);

102: l_new_header_id number;
103:
104: Begin
105:
106: hr_utility.trace('p_batch_name' || p_batch_name);
107: hr_utility.trace('p_business_group_id' || p_business_group_id);
108: hr_utility.trace('p_batch_reference' || p_batch_reference);
109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);

Line 107: hr_utility.trace('p_business_group_id' || p_business_group_id);

103:
104: Begin
105:
106: hr_utility.trace('p_batch_name' || p_batch_name);
107: hr_utility.trace('p_business_group_id' || p_business_group_id);
108: hr_utility.trace('p_batch_reference' || p_batch_reference);
109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);
111: hr_utility.trace('p_batch_id' || p_batch_id);

Line 108: hr_utility.trace('p_batch_reference' || p_batch_reference);

104: Begin
105:
106: hr_utility.trace('p_batch_name' || p_batch_name);
107: hr_utility.trace('p_business_group_id' || p_business_group_id);
108: hr_utility.trace('p_batch_reference' || p_batch_reference);
109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);
111: hr_utility.trace('p_batch_id' || p_batch_id);
112:

Line 109: hr_utility.trace('p_batch_source' || p_batch_source);

105:
106: hr_utility.trace('p_batch_name' || p_batch_name);
107: hr_utility.trace('p_business_group_id' || p_business_group_id);
108: hr_utility.trace('p_batch_reference' || p_batch_reference);
109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);
111: hr_utility.trace('p_batch_id' || p_batch_id);
112:
113: -- hr_utility.trace_on(null,'webadi');

Line 110: hr_utility.trace('p_batch_status' || p_batch_status);

106: hr_utility.trace('p_batch_name' || p_batch_name);
107: hr_utility.trace('p_business_group_id' || p_business_group_id);
108: hr_utility.trace('p_batch_reference' || p_batch_reference);
109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);
111: hr_utility.trace('p_batch_id' || p_batch_id);
112:
113: -- hr_utility.trace_on(null,'webadi');
114: select name into l_bg_name

Line 111: hr_utility.trace('p_batch_id' || p_batch_id);

107: hr_utility.trace('p_business_group_id' || p_business_group_id);
108: hr_utility.trace('p_batch_reference' || p_batch_reference);
109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);
111: hr_utility.trace('p_batch_id' || p_batch_id);
112:
113: -- hr_utility.trace_on(null,'webadi');
114: select name into l_bg_name
115: from per_business_groups

Line 113: -- hr_utility.trace_on(null,'webadi');

109: hr_utility.trace('p_batch_source' || p_batch_source);
110: hr_utility.trace('p_batch_status' || p_batch_status);
111: hr_utility.trace('p_batch_id' || p_batch_id);
112:
113: -- hr_utility.trace_on(null,'webadi');
114: select name into l_bg_name
115: from per_business_groups
116: where business_group_id = p_business_group_id;
117:

Line 119: hr_utility.trace('l_batch_name, before selecting' || l_batch_name);

115: from per_business_groups
116: where business_group_id = p_business_group_id;
117:
118:
119: hr_utility.trace('l_batch_name, before selecting' || l_batch_name);
120: select batch_name into l_batch_name
121: from pay_balance_batch_headers
122: where upper(batch_name) = upper(p_batch_name)
123: and business_group_id = p_business_group_id;

Line 125: hr_utility.trace('l_batch_name, after selecting' || l_batch_name);

121: from pay_balance_batch_headers
122: where upper(batch_name) = upper(p_batch_name)
123: and business_group_id = p_business_group_id;
124:
125: hr_utility.trace('l_batch_name, after selecting' || l_batch_name);
126:
127: if l_batch_name is not null then
128:
129: hr_utility.trace('l_batch_name, exception:' || l_batch_name);

Line 129: hr_utility.trace('l_batch_name, exception:' || l_batch_name);

125: hr_utility.trace('l_batch_name, after selecting' || l_batch_name);
126:
127: if l_batch_name is not null then
128:
129: hr_utility.trace('l_batch_name, exception:' || l_batch_name);
130:
131: raise value_found;
132:
133: end if;

Line 139: hr_utility.trace('exception: value_found');

135: EXCEPTION
136:
137: when value_found then
138:
139: hr_utility.trace('exception: value_found');
140:
141: hr_utility.trace('Please enter a unique name for Batch Name parameter');
142: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
143: -- Bug: 5079557

Line 141: hr_utility.trace('Please enter a unique name for Batch Name parameter');

137: when value_found then
138:
139: hr_utility.trace('exception: value_found');
140:
141: hr_utility.trace('Please enter a unique name for Batch Name parameter');
142: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
143: -- Bug: 5079557
144: hr_utility.raise_error;
145:

Line 142: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');

138:
139: hr_utility.trace('exception: value_found');
140:
141: hr_utility.trace('Please enter a unique name for Batch Name parameter');
142: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
143: -- Bug: 5079557
144: hr_utility.raise_error;
145:
146: -- return;

Line 144: hr_utility.raise_error;

140:
141: hr_utility.trace('Please enter a unique name for Batch Name parameter');
142: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
143: -- Bug: 5079557
144: hr_utility.raise_error;
145:
146: -- return;
147:
148: when no_data_found then

Line 150: hr_utility.trace('exception: no data found');

146: -- return;
147:
148: when no_data_found then
149:
150: hr_utility.trace('exception: no data found');
151:
152: --select max(batch_id) into p_batch_id
153: select pay_batch_headers_s.nextval into p_batch_id
154: from dual;

Line 199: --hr_utility.trace_on(null,'ram');

195:
196:
197: Begin
198:
199: --hr_utility.trace_on(null,'ram');
200: -- Bug: 5171907
201: hr_utility.trace('p_batch_id: ' || p_batch_id);
202: hr_utility.trace('p_batch_name: ' || p_batch_name);
203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);

Line 201: hr_utility.trace('p_batch_id: ' || p_batch_id);

197: Begin
198:
199: --hr_utility.trace_on(null,'ram');
200: -- Bug: 5171907
201: hr_utility.trace('p_batch_id: ' || p_batch_id);
202: hr_utility.trace('p_batch_name: ' || p_batch_name);
203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
204: hr_utility.trace('p_batch_source: ' || p_batch_source);
205: hr_utility.trace('p_batch_status: ' || p_batch_status);

Line 202: hr_utility.trace('p_batch_name: ' || p_batch_name);

198:
199: --hr_utility.trace_on(null,'ram');
200: -- Bug: 5171907
201: hr_utility.trace('p_batch_id: ' || p_batch_id);
202: hr_utility.trace('p_batch_name: ' || p_batch_name);
203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
204: hr_utility.trace('p_batch_source: ' || p_batch_source);
205: hr_utility.trace('p_batch_status: ' || p_batch_status);
206:

Line 203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);

199: --hr_utility.trace_on(null,'ram');
200: -- Bug: 5171907
201: hr_utility.trace('p_batch_id: ' || p_batch_id);
202: hr_utility.trace('p_batch_name: ' || p_batch_name);
203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
204: hr_utility.trace('p_batch_source: ' || p_batch_source);
205: hr_utility.trace('p_batch_status: ' || p_batch_status);
206:
207: -- Bug: 5226336

Line 204: hr_utility.trace('p_batch_source: ' || p_batch_source);

200: -- Bug: 5171907
201: hr_utility.trace('p_batch_id: ' || p_batch_id);
202: hr_utility.trace('p_batch_name: ' || p_batch_name);
203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
204: hr_utility.trace('p_batch_source: ' || p_batch_source);
205: hr_utility.trace('p_batch_status: ' || p_batch_status);
206:
207: -- Bug: 5226336
208:

Line 205: hr_utility.trace('p_batch_status: ' || p_batch_status);

201: hr_utility.trace('p_batch_id: ' || p_batch_id);
202: hr_utility.trace('p_batch_name: ' || p_batch_name);
203: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
204: hr_utility.trace('p_batch_source: ' || p_batch_source);
205: hr_utility.trace('p_batch_status: ' || p_batch_status);
206:
207: -- Bug: 5226336
208:
209: SELECT batch_status, business_group_name

Line 214: hr_utility.trace('l_batch_status: ' || l_batch_status);

210: INTO l_batch_status, l_bg_name
211: FROM pay_balance_batch_headers
212: WHERE batch_id = p_batch_id;
213:
214: hr_utility.trace('l_batch_status: ' || l_batch_status);
215: hr_utility.trace('l_bg_name: ' || l_bg_name);
216:
217: SELECT batch_name
218: INTO l_batch_name

Line 215: hr_utility.trace('l_bg_name: ' || l_bg_name);

211: FROM pay_balance_batch_headers
212: WHERE batch_id = p_batch_id;
213:
214: hr_utility.trace('l_batch_status: ' || l_batch_status);
215: hr_utility.trace('l_bg_name: ' || l_bg_name);
216:
217: SELECT batch_name
218: INTO l_batch_name
219: FROM pay_balance_batch_headers

Line 224: hr_utility.trace('l_batch_name, exception:' || l_batch_name);

220: WHERE upper(batch_name) = upper(p_batch_name)
221: AND business_group_name = l_bg_name;
222:
223: IF l_batch_name is not null THEN
224: hr_utility.trace('l_batch_name, exception:' || l_batch_name);
225: raise value_found;
226: END IF;
227:
228: EXCEPTION

Line 232: hr_utility.trace('exception: value_found');

228: EXCEPTION
229:
230: WHEN value_found THEN
231:
232: hr_utility.trace('exception: value_found');
233: hr_utility.trace('Please enter a unique name for Batch Name parameter');
234: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
235: hr_utility.raise_error;
236:

Line 233: hr_utility.trace('Please enter a unique name for Batch Name parameter');

229:
230: WHEN value_found THEN
231:
232: hr_utility.trace('exception: value_found');
233: hr_utility.trace('Please enter a unique name for Batch Name parameter');
234: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
235: hr_utility.raise_error;
236:
237: WHEN others THEN

Line 234: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');

230: WHEN value_found THEN
231:
232: hr_utility.trace('exception: value_found');
233: hr_utility.trace('Please enter a unique name for Batch Name parameter');
234: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
235: hr_utility.raise_error;
236:
237: WHEN others THEN
238: BEGIN

Line 235: hr_utility.raise_error;

231:
232: hr_utility.trace('exception: value_found');
233: hr_utility.trace('Please enter a unique name for Batch Name parameter');
234: hr_utility.set_message('PAY','Please enter a unique name for Batch Name parameter');
235: hr_utility.raise_error;
236:
237: WHEN others THEN
238: BEGIN
239: hr_utility.trace('exception: no data found');

Line 239: hr_utility.trace('exception: no data found');

235: hr_utility.raise_error;
236:
237: WHEN others THEN
238: BEGIN
239: hr_utility.trace('exception: no data found');
240:
241: IF l_batch_status in ('L','T','C') THEN
242: RAISE value_found;
243: ELSE

Line 245: hr_utility.trace('updating batch headers...');

241: IF l_batch_status in ('L','T','C') THEN
242: RAISE value_found;
243: ELSE
244: BEGIN
245: hr_utility.trace('updating batch headers...');
246: hr_utility.trace('p_batch_name: ' || p_batch_name);
247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
248: hr_utility.trace('p_batch_source: ' || p_batch_source);
249: hr_utility.trace('p_batch_id: ' || p_batch_id);

Line 246: hr_utility.trace('p_batch_name: ' || p_batch_name);

242: RAISE value_found;
243: ELSE
244: BEGIN
245: hr_utility.trace('updating batch headers...');
246: hr_utility.trace('p_batch_name: ' || p_batch_name);
247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
248: hr_utility.trace('p_batch_source: ' || p_batch_source);
249: hr_utility.trace('p_batch_id: ' || p_batch_id);
250:

Line 247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);

243: ELSE
244: BEGIN
245: hr_utility.trace('updating batch headers...');
246: hr_utility.trace('p_batch_name: ' || p_batch_name);
247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
248: hr_utility.trace('p_batch_source: ' || p_batch_source);
249: hr_utility.trace('p_batch_id: ' || p_batch_id);
250:
251: UPDATE pay_balance_batch_headers

Line 248: hr_utility.trace('p_batch_source: ' || p_batch_source);

244: BEGIN
245: hr_utility.trace('updating batch headers...');
246: hr_utility.trace('p_batch_name: ' || p_batch_name);
247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
248: hr_utility.trace('p_batch_source: ' || p_batch_source);
249: hr_utility.trace('p_batch_id: ' || p_batch_id);
250:
251: UPDATE pay_balance_batch_headers
252: SET batch_name = p_batch_name,

Line 249: hr_utility.trace('p_batch_id: ' || p_batch_id);

245: hr_utility.trace('updating batch headers...');
246: hr_utility.trace('p_batch_name: ' || p_batch_name);
247: hr_utility.trace('p_batch_reference: ' || p_batch_reference);
248: hr_utility.trace('p_batch_source: ' || p_batch_source);
249: hr_utility.trace('p_batch_id: ' || p_batch_id);
250:
251: UPDATE pay_balance_batch_headers
252: SET batch_name = p_batch_name,
253: batch_reference = p_batch_reference,

Line 257: hr_utility.trace('updating batch headers is done');

253: batch_reference = p_batch_reference,
254: batch_source = p_batch_source
255: WHERE batch_id = p_batch_id;
256:
257: hr_utility.trace('updating batch headers is done');
258:
259: EXCEPTION
260:
261: WHEN OTHERS THEN

Line 262: hr_utility.trace('Exception: unable to update pay_balance_batch_headers table.');

258:
259: EXCEPTION
260:
261: WHEN OTHERS THEN
262: hr_utility.trace('Exception: unable to update pay_balance_batch_headers table.');
263: hr_utility.raise_error;
264: END;
265: END IF;
266:

Line 263: hr_utility.raise_error;

259: EXCEPTION
260:
261: WHEN OTHERS THEN
262: hr_utility.trace('Exception: unable to update pay_balance_batch_headers table.');
263: hr_utility.raise_error;
264: END;
265: END IF;
266:
267: EXCEPTION

Line 270: hr_utility.trace('exception: value_found');

266:
267: EXCEPTION
268:
269: WHEN value_found THEN
270: hr_utility.trace('exception: value_found');
271: hr_utility.raise_error;
272: END;
273: end update_batch_header;
274:

Line 271: hr_utility.raise_error;

267: EXCEPTION
268:
269: WHEN value_found THEN
270: hr_utility.trace('exception: value_found');
271: hr_utility.raise_error;
272: END;
273: end update_batch_header;
274:
275:

Line 360: --hr_utility.trace_on(null,'webadi');

356:
357: Begin
358:
359:
360: --hr_utility.trace_on(null,'webadi');
361: hr_utility.trace('p_batch_id is : '|| p_batch_id );
362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );

Line 361: hr_utility.trace('p_batch_id is : '|| p_batch_id );

357: Begin
358:
359:
360: --hr_utility.trace_on(null,'webadi');
361: hr_utility.trace('p_batch_id is : '|| p_batch_id );
362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );

Line 362: hr_utility.trace('p_batch_name is : '|| p_batch_name );

358:
359:
360: --hr_utility.trace_on(null,'webadi');
361: hr_utility.trace('p_batch_id is : '|| p_batch_id );
362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);

Line 363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );

359:
360: --hr_utility.trace_on(null,'webadi');
361: hr_utility.trace('p_batch_id is : '|| p_batch_id );
362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );

Line 364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );

360: --hr_utility.trace_on(null,'webadi');
361: hr_utility.trace('p_batch_id is : '|| p_batch_id );
362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );

Line 365: hr_utility.trace('p_effective_date is : '|| p_effective_date );

361: hr_utility.trace('p_batch_id is : '|| p_batch_id );
362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);

Line 366: hr_utility.trace('p_employee_id is : '|| p_employee_id);

362: hr_utility.trace('p_batch_name is : '|| p_batch_name );
363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );

Line 367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );

363: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );

Line 368: hr_utility.trace('p_element_name is : '|| p_element_name );

364: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );

Line 369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);

365: hr_utility.trace('p_effective_date is : '|| p_effective_date );
366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);

Line 370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );

366: hr_utility.trace('p_employee_id is : '|| p_employee_id);
367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );

Line 371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );

367: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );

Line 372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );

368: hr_utility.trace('p_element_name is : '|| p_element_name );
369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );

Line 373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);

369: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );

Line 374: hr_utility.trace('p_gre_id is : '|| p_gre_id );

370: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );

Line 375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );

371: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );

Line 376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );

372: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );

Line 377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );

373: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );

Line 378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );

374: hr_utility.trace('p_gre_id is : '|| p_gre_id );
375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );

Line 379: hr_utility.trace('segment1 is : '|| segment1 );

375: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );

Line 380: hr_utility.trace('segment2 is : '|| segment2 );

376: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );

Line 381: hr_utility.trace('segment3 is : '|| segment3 );

377: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );

Line 382: hr_utility.trace('segment4 is : '|| segment4 );

378: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );

Line 383: hr_utility.trace('segment5 is : '|| segment5 );

379: hr_utility.trace('segment1 is : '|| segment1 );
380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );

Line 384: hr_utility.trace('segment6 is : '|| segment6 );

380: hr_utility.trace('segment2 is : '|| segment2 );
381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );

Line 385: hr_utility.trace('segment7 is : '|| segment7 );

381: hr_utility.trace('segment3 is : '|| segment3 );
382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );

Line 386: hr_utility.trace('segment8 is : '|| segment8 );

382: hr_utility.trace('segment4 is : '|| segment4 );
383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );

Line 387: hr_utility.trace('segment9 is : '|| segment9 );

383: hr_utility.trace('segment5 is : '|| segment5 );
384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );

Line 388: hr_utility.trace('segment10 is : '||segment10 );

384: hr_utility.trace('segment6 is : '|| segment6 );
385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );

Line 389: hr_utility.trace('segment11 is : '||segment11 );

385: hr_utility.trace('segment7 is : '|| segment7 );
386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );

Line 390: hr_utility.trace('segment12 is : '||segment12 );

386: hr_utility.trace('segment8 is : '|| segment8 );
387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);

Line 391: hr_utility.trace('segment13 is : '||segment13 );

387: hr_utility.trace('segment9 is : '|| segment9 );
388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );

Line 392: hr_utility.trace('segment14 is : '||segment14 );

388: hr_utility.trace('segment10 is : '||segment10 );
389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );

Line 393: hr_utility.trace('segment15 is : '||segment15 );

389: hr_utility.trace('segment11 is : '||segment11 );
390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );

Line 394: hr_utility.trace('segment16 is : '|| segment16);

390: hr_utility.trace('segment12 is : '||segment12 );
391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );

Line 395: hr_utility.trace('segment17 is : '|| segment17 );

391: hr_utility.trace('segment13 is : '||segment13 );
392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );

Line 396: hr_utility.trace('segment18 is : '|| segment18 );

392: hr_utility.trace('segment14 is : '||segment14 );
393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );

Line 397: hr_utility.trace('segment19 is : '|| segment19 );

393: hr_utility.trace('segment15 is : '||segment15 );
394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );

Line 398: hr_utility.trace('segment20 is : '|| segment20 );

394: hr_utility.trace('segment16 is : '|| segment16);
395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );

Line 399: hr_utility.trace('segment21 is : '|| segment21 );

395: hr_utility.trace('segment17 is : '|| segment17 );
396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );

Line 400: hr_utility.trace('segment22 is : '|| segment22 );

396: hr_utility.trace('segment18 is : '|| segment18 );
397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );

Line 401: hr_utility.trace('segment23 is : '|| segment23 );

397: hr_utility.trace('segment19 is : '|| segment19 );
398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );

Line 402: hr_utility.trace('segment24 is : '|| segment24 );

398: hr_utility.trace('segment20 is : '|| segment20 );
399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );

Line 403: hr_utility.trace('segment25 is : '||segment25 );

399: hr_utility.trace('segment21 is : '|| segment21 );
400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );

Line 404: hr_utility.trace('segment26 is : '||segment26 );

400: hr_utility.trace('segment22 is : '|| segment22 );
401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );

Line 405: hr_utility.trace('segment27 cons is : '||segment27 );

401: hr_utility.trace('segment23 is : '|| segment23 );
402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );

Line 406: hr_utility.trace('segment28 is : '||segment28 );

402: hr_utility.trace('segment24 is : '|| segment24 );
403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );

Line 407: hr_utility.trace('segment29 is : '||segment29 );

403: hr_utility.trace('segment25 is : '||segment25 );
404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );

Line 408: hr_utility.trace('segment30 is : '||segment30 );

404: hr_utility.trace('segment26 is : '||segment26 );
405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );

Line 409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );

405: hr_utility.trace('segment27 cons is : '||segment27 );
406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );

Line 410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );

406: hr_utility.trace('segment28 is : '||segment28 );
407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );

Line 411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );

407: hr_utility.trace('segment29 is : '||segment29 );
408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );

Line 412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );

408: hr_utility.trace('segment30 is : '||segment30 );
409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );

Line 413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );

409: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );

Line 414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );

410: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );

Line 415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );

411: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );

Line 416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );

412: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );

Line 417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );

413: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );

Line 418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );

414: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );

Line 419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );

415: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );

Line 420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );

416: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );

Line 421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );

417: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );

Line 422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );

418: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );

Line 423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );

419: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );

Line 424: hr_utility.trace('p_col1 is : '|| p_col1 );

420: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );

Line 425: hr_utility.trace('p_col2 is : '|| p_col2 );

421: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );

Line 426: hr_utility.trace('p_col3 is : '|| p_col3 );

422: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );

Line 427: hr_utility.trace('p_col4 is : '|| p_col4 );

423: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );

Line 428: hr_utility.trace('p_col5 is : '|| p_col5 );

424: hr_utility.trace('p_col1 is : '|| p_col1 );
425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );

Line 429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );

425: hr_utility.trace('p_col2 is : '|| p_col2 );
426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );

Line 430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );

426: hr_utility.trace('p_col3 is : '|| p_col3 );
427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
434:

Line 431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );

427: hr_utility.trace('p_col4 is : '|| p_col4 );
428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
434:
435: select batch_group_status into l_batch_group_status

Line 432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );

428: hr_utility.trace('p_col5 is : '|| p_col5 );
429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
434:
435: select batch_group_status into l_batch_group_status
436: from pay_adjust_batch_groups

Line 433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );

429: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
430: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
431: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
434:
435: select batch_group_status into l_batch_group_status
436: from pay_adjust_batch_groups
437: where batch_group_id = p_batch_group_id;

Line 495: hr_utility.trace('Cannot update Batch Lines');

491:
492:
493: exception when value_found then
494:
495: hr_utility.trace('Cannot update Batch Lines');
496: return;
497:
498: end update_batch_groups_lines;
499:

Line 828: --hr_utility.trace_on(null,'ram');

824: /* MAIN */
825:
826: Begin
827:
828: --hr_utility.trace_on(null,'ram');
829: hr_utility.trace('p_batch_id is : '|| p_batch_id );
830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );

Line 829: hr_utility.trace('p_batch_id is : '|| p_batch_id );

825:
826: Begin
827:
828: --hr_utility.trace_on(null,'ram');
829: hr_utility.trace('p_batch_id is : '|| p_batch_id );
830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );

Line 830: hr_utility.trace('p_batch_name is : '|| p_batch_name );

826: Begin
827:
828: --hr_utility.trace_on(null,'ram');
829: hr_utility.trace('p_batch_id is : '|| p_batch_id );
830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );

Line 831: hr_utility.trace('p_effective_date is : '|| p_effective_date );

827:
828: --hr_utility.trace_on(null,'ram');
829: hr_utility.trace('p_batch_id is : '|| p_batch_id );
830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );

Line 832: hr_utility.trace('p_mode is : '|| p_mode );

828: --hr_utility.trace_on(null,'ram');
829: hr_utility.trace('p_batch_id is : '|| p_batch_id );
830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);

Line 833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );

829: hr_utility.trace('p_batch_id is : '|| p_batch_id );
830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );

Line 834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );

830: hr_utility.trace('p_batch_name is : '|| p_batch_name );
831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );

Line 835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );

831: hr_utility.trace('p_effective_date is : '|| p_effective_date );
832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);

Line 836: hr_utility.trace('p_employee_id is : '|| p_employee_id);

832: hr_utility.trace('p_mode is : '|| p_mode );
833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );

Line 837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );

833: hr_utility.trace('p_batch_group_id is : '|| p_batch_group_id );
834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );

Line 838: hr_utility.trace('p_element_name is : '|| p_element_name );

834: hr_utility.trace('p_batch_line_id is : '|| p_batch_line_id );
835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );

Line 839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);

835: hr_utility.trace('p_batch_line_status is : '|| p_batch_line_status );
836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);

Line 840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );

836: hr_utility.trace('p_employee_id is : '|| p_employee_id);
837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );

Line 841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );

837: hr_utility.trace('p_assignment_id is : '|| p_assignment_id );
838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );

Line 842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );

838: hr_utility.trace('p_element_name is : '|| p_element_name );
839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );

Line 843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);

839: hr_utility.trace('p_element_type_id is : '|| p_element_type_id);
840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );

Line 844: hr_utility.trace('p_gre_id is : '|| p_gre_id );

840: hr_utility.trace('p_element_link_id is : '|| p_element_link_id );
841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );

Line 845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );

841: hr_utility.trace('p_payroll_id is : '|| p_payroll_id );
842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );

Line 846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );

842: hr_utility.trace('p_business_group_id is : '|| p_business_group_id );
843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );

Line 847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );

843: hr_utility.trace('p_consolidation_set_id is : '|| p_consolidation_set_id);
844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );

Line 848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );

844: hr_utility.trace('p_gre_id is : '|| p_gre_id );
845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );

Line 849: hr_utility.trace('segment1 is : '|| segment1 );

845: hr_utility.trace('p_prepay_flag is : '||p_prepay_flag );
846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );

Line 850: hr_utility.trace('segment2 is : '|| segment2 );

846: hr_utility.trace('p_costing_flag is : '|| p_costing_flag );
847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );

Line 851: hr_utility.trace('segment3 is : '|| segment3 );

847: hr_utility.trace('p_cost_allocation_keyflex is : '|| p_cost_allocation_keyflex );
848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );

Line 852: hr_utility.trace('segment4 is : '|| segment4 );

848: hr_utility.trace('p_concatenated_segments is : '|| p_concatenated_segments );
849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );

Line 853: hr_utility.trace('segment5 is : '|| segment5 );

849: hr_utility.trace('segment1 is : '|| segment1 );
850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );

Line 854: hr_utility.trace('segment6 is : '|| segment6 );

850: hr_utility.trace('segment2 is : '|| segment2 );
851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );

Line 855: hr_utility.trace('segment7 is : '|| segment7 );

851: hr_utility.trace('segment3 is : '|| segment3 );
852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );

Line 856: hr_utility.trace('segment8 is : '|| segment8 );

852: hr_utility.trace('segment4 is : '|| segment4 );
853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );

Line 857: hr_utility.trace('segment9 is : '|| segment9 );

853: hr_utility.trace('segment5 is : '|| segment5 );
854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );

Line 858: hr_utility.trace('segment10 is : '||segment10 );

854: hr_utility.trace('segment6 is : '|| segment6 );
855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );

Line 859: hr_utility.trace('segment11 is : '||segment11 );

855: hr_utility.trace('segment7 is : '|| segment7 );
856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );

Line 860: hr_utility.trace('segment12 is : '||segment12 );

856: hr_utility.trace('segment8 is : '|| segment8 );
857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);

Line 861: hr_utility.trace('segment13 is : '||segment13 );

857: hr_utility.trace('segment9 is : '|| segment9 );
858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );

Line 862: hr_utility.trace('segment14 is : '||segment14 );

858: hr_utility.trace('segment10 is : '||segment10 );
859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );

Line 863: hr_utility.trace('segment15 is : '||segment15 );

859: hr_utility.trace('segment11 is : '||segment11 );
860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );

Line 864: hr_utility.trace('segment16 is : '|| segment16);

860: hr_utility.trace('segment12 is : '||segment12 );
861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );

Line 865: hr_utility.trace('segment17 is : '|| segment17 );

861: hr_utility.trace('segment13 is : '||segment13 );
862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );

Line 866: hr_utility.trace('segment18 is : '|| segment18 );

862: hr_utility.trace('segment14 is : '||segment14 );
863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );

Line 867: hr_utility.trace('segment19 is : '|| segment19 );

863: hr_utility.trace('segment15 is : '||segment15 );
864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );

Line 868: hr_utility.trace('segment20 is : '|| segment20 );

864: hr_utility.trace('segment16 is : '|| segment16);
865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );

Line 869: hr_utility.trace('segment21 is : '|| segment21 );

865: hr_utility.trace('segment17 is : '|| segment17 );
866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );

Line 870: hr_utility.trace('segment22 is : '|| segment22 );

866: hr_utility.trace('segment18 is : '|| segment18 );
867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );

Line 871: hr_utility.trace('segment23 is : '|| segment23 );

867: hr_utility.trace('segment19 is : '|| segment19 );
868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );

Line 872: hr_utility.trace('segment24 is : '|| segment24 );

868: hr_utility.trace('segment20 is : '|| segment20 );
869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );

Line 873: hr_utility.trace('segment25 is : '||segment25 );

869: hr_utility.trace('segment21 is : '|| segment21 );
870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );

Line 874: hr_utility.trace('segment26 is : '||segment26 );

870: hr_utility.trace('segment22 is : '|| segment22 );
871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );

Line 875: hr_utility.trace('segment27 is : '||segment27 );

871: hr_utility.trace('segment23 is : '|| segment23 );
872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );

Line 876: hr_utility.trace('segment28 is : '||segment28 );

872: hr_utility.trace('segment24 is : '|| segment24 );
873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );

Line 877: hr_utility.trace('segment29 is : '||segment29 );

873: hr_utility.trace('segment25 is : '||segment25 );
874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );

Line 878: hr_utility.trace('segment30 is : '||segment30 );

874: hr_utility.trace('segment26 is : '||segment26 );
875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );

Line 879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );

875: hr_utility.trace('segment27 is : '||segment27 );
876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );

Line 880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );

876: hr_utility.trace('segment28 is : '||segment28 );
877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );

Line 881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );

877: hr_utility.trace('segment29 is : '||segment29 );
878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );

Line 882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );

878: hr_utility.trace('segment30 is : '||segment30 );
879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );

Line 883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );

879: hr_utility.trace('p_ee_value1 is : '|| p_ee_value1 );
880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );

Line 884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );

880: hr_utility.trace('p_ee_value2 is : '|| p_ee_value2 );
881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );

Line 885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );

881: hr_utility.trace('p_ee_value3 is : '|| p_ee_value3 );
882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );

Line 886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );

882: hr_utility.trace('p_ee_value4 is : '|| p_ee_value4 );
883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );

Line 887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );

883: hr_utility.trace('p_ee_value5 is : '|| p_ee_value5 );
884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );

Line 888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );

884: hr_utility.trace('p_ee_value6 is : '|| p_ee_value6 );
885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );

Line 889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );

885: hr_utility.trace('p_ee_value7 is : '|| p_ee_value7 );
886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );

Line 890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );

886: hr_utility.trace('p_ee_value8 is : '|| p_ee_value8 );
887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );

Line 891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );

887: hr_utility.trace('p_ee_value9 is : '|| p_ee_value9 );
888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );

Line 892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );

888: hr_utility.trace('p_ee_value10 is : '||p_ee_value10 );
889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );

Line 893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );

889: hr_utility.trace('p_ee_value11 is : '||p_ee_value11 );
890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );

Line 894: hr_utility.trace('p_col1 is : '|| p_col1 );

890: hr_utility.trace('p_ee_value12 is : '||p_ee_value12 );
891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );

Line 895: hr_utility.trace('p_col2 is : '|| p_col2 );

891: hr_utility.trace('p_ee_value13 is : '||p_ee_value13 );
892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );

Line 896: hr_utility.trace('p_col3 is : '|| p_col3 );

892: hr_utility.trace('p_ee_value14 is : '||p_ee_value14 );
893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );

Line 897: hr_utility.trace('p_col4 is : '|| p_col4 );

893: hr_utility.trace('p_ee_value15 is : '||p_ee_value15 );
894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );

Line 898: hr_utility.trace('p_col5 is : '|| p_col5 );

894: hr_utility.trace('p_col1 is : '|| p_col1 );
895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );

Line 899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );

895: hr_utility.trace('p_col2 is : '|| p_col2 );
896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );

Line 900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );

896: hr_utility.trace('p_col3 is : '|| p_col3 );
897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
904: hr_utility.set_location('p_col_val5 is : '|| p_col_val5,10 );

Line 901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );

897: hr_utility.trace('p_col4 is : '|| p_col4 );
898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
904: hr_utility.set_location('p_col_val5 is : '|| p_col_val5,10 );
905:

Line 902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );

898: hr_utility.trace('p_col5 is : '|| p_col5 );
899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
904: hr_utility.set_location('p_col_val5 is : '|| p_col_val5,10 );
905:
906: -- Bug: 5200900

Line 903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );

899: hr_utility.trace('p_col_val1 is : '|| p_col_val1 );
900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
904: hr_utility.set_location('p_col_val5 is : '|| p_col_val5,10 );
905:
906: -- Bug: 5200900
907: -- Storing input values in Global variables.

Line 904: hr_utility.set_location('p_col_val5 is : '|| p_col_val5,10 );

900: hr_utility.trace('p_col_val2 is : '|| p_col_val2 );
901: hr_utility.trace('p_col_val3 is : '|| p_col_val3 );
902: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
903: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
904: hr_utility.set_location('p_col_val5 is : '|| p_col_val5,10 );
905:
906: -- Bug: 5200900
907: -- Storing input values in Global variables.
908:

Line 926: hr_utility.trace('p_costing_flag is null satisfied');

922: g_ee_value14 := p_ee_value14;
923: g_ee_value15 := p_ee_value15;
924:
925: if p_costing_flag is null then
926: hr_utility.trace('p_costing_flag is null satisfied');
927: l_costing_flag := 'N';
928: else
929: l_costing_flag := p_costing_flag;
930: end if;

Line 934: hr_utility.trace('p_prepay_flag is null satisfied');

930: end if;
931:
932:
933: if p_prepay_flag is null then
934: hr_utility.trace('p_prepay_flag is null satisfied');
935: l_prepay_flag := 'N';
936: else
937: l_prepay_flag := p_prepay_flag;
938: end if;

Line 941: hr_utility.trace('g_element_type_id is null satisfied ');

937: l_prepay_flag := p_prepay_flag;
938: end if;
939:
940: if g_element_type_id is null then
941: hr_utility.trace('g_element_type_id is null satisfied ');
942: g_element_type_id := -1;
943: end if;
944:
945: i := 0;

Line 955: hr_utility.trace('ln_payroll_id is null satisfied');

951:
952: -- If payroll is not attached, raise an error.
953:
954: if ln_payroll_id is null then
955: hr_utility.trace('ln_payroll_id is null satisfied');
956: hr_utility.raise_error;
957: end if;
958:
959: OPEN csr_get_asg_id;

Line 956: hr_utility.raise_error;

952: -- If payroll is not attached, raise an error.
953:
954: if ln_payroll_id is null then
955: hr_utility.trace('ln_payroll_id is null satisfied');
956: hr_utility.raise_error;
957: end if;
958:
959: OPEN csr_get_asg_id;
960: FETCH csr_get_asg_id into ln_assignment_id;

Line 962: hr_utility.raise_error;

958:
959: OPEN csr_get_asg_id;
960: FETCH csr_get_asg_id into ln_assignment_id;
961: IF csr_get_asg_id%NOTFOUND THEN
962: hr_utility.raise_error;
963: END IF;
964: CLOSE csr_get_asg_id;
965: hr_utility.trace('Assignment_id :'||to_char(ln_assignment_id));
966:

Line 965: hr_utility.trace('Assignment_id :'||to_char(ln_assignment_id));

961: IF csr_get_asg_id%NOTFOUND THEN
962: hr_utility.raise_error;
963: END IF;
964: CLOSE csr_get_asg_id;
965: hr_utility.trace('Assignment_id :'||to_char(ln_assignment_id));
966:
967: -- Fetch Consolidation Set Id if user did not enter it.
968:
969: if l_consolidation_set_id is null then

Line 994: hr_utility.trace('l_default_jd: ' || l_default_jd);

990: null,
991: p_effective_date,
992: 'EMPPROV');
993:
994: hr_utility.trace('l_default_jd: ' || l_default_jd);
995:
996: END IF;
997:
998: -- Fetch GRE name if user did not enter it.

Line 1005: hr_utility.trace('l_leg_code = CA is satisfied');

1001: if p_gre_id is null then
1002:
1003: IF l_leg_code = 'CA' then
1004:
1005: hr_utility.trace('l_leg_code = CA is satisfied');
1006: hr_utility.trace('Opening cursor: get_gre_ca ...');
1007:
1008: open get_gre_ca;
1009: fetch get_gre_ca into ln_segment1, ln_segment11,

Line 1006: hr_utility.trace('Opening cursor: get_gre_ca ...');

1002:
1003: IF l_leg_code = 'CA' then
1004:
1005: hr_utility.trace('l_leg_code = CA is satisfied');
1006: hr_utility.trace('Opening cursor: get_gre_ca ...');
1007:
1008: open get_gre_ca;
1009: fetch get_gre_ca into ln_segment1, ln_segment11,
1010: ln_segment12,ln_ca_gre;

Line 1024: hr_utility.trace('l_element_information_type = T4/RL1');

1020: ELSE
1021:
1022: IF l_element_information_type = 'T4/RL1' THEN
1023:
1024: hr_utility.trace('l_element_information_type = T4/RL1');
1025: ln_gre_id := ln_segment1;
1026:
1027: ELSIF l_element_information_type = 'T4A/RL1' THEN
1028:

Line 1029: hr_utility.trace('l_element_information_type = T4A/RL1');

1025: ln_gre_id := ln_segment1;
1026:
1027: ELSIF l_element_information_type = 'T4A/RL1' THEN
1028:
1029: hr_utility.trace('l_element_information_type = T4A/RL1');
1030: ln_gre_id := ln_segment11;
1031:
1032: ELSIF l_element_information_type = 'T4A/RL2' THEN
1033:

Line 1034: hr_utility.trace('l_element_information_type = T4A/RL2');

1030: ln_gre_id := ln_segment11;
1031:
1032: ELSIF l_element_information_type = 'T4A/RL2' THEN
1033:
1034: hr_utility.trace('l_element_information_type = T4A/RL2');
1035: ln_gre_id := ln_segment12;
1036:
1037: END IF;
1038:

Line 1050: hr_utility.trace('l_leg_code != CA is satisfied');

1046:
1047: CLOSE get_element_type;
1048:
1049: else
1050: hr_utility.trace('l_leg_code != CA is satisfied');
1051: open get_gre;
1052: fetch get_gre into ln_gre_id;
1053: close get_gre;
1054: end if;

Line 1063: hr_utility.trace('GRE_Id :'||to_char(ln_gre_id));

1059: close c_get_gre_id;
1060: end if;
1061:
1062:
1063: hr_utility.trace('GRE_Id :'||to_char(ln_gre_id));
1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));
1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));

Line 1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));

1060: end if;
1061:
1062:
1063: hr_utility.trace('GRE_Id :'||to_char(ln_gre_id));
1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));
1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));

Line 1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));

1061:
1062:
1063: hr_utility.trace('GRE_Id :'||to_char(ln_gre_id));
1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));
1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));

Line 1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));

1062:
1063: hr_utility.trace('GRE_Id :'||to_char(ln_gre_id));
1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));
1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));

Line 1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));

1063: hr_utility.trace('GRE_Id :'||to_char(ln_gre_id));
1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));
1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));

Line 1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));

1064: hr_utility.trace('Payroll Id : '||to_char(ln_payroll_id));
1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));

Line 1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));

1065: hr_utility.trace('G_Element_type_Id : '||to_char(g_element_type_id));
1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));

Line 1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));

1066: hr_utility.trace('G_ip_id1 : '||to_char(g_ip_id1));
1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));

Line 1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));

1067: hr_utility.trace('G_ip_id2 : '||to_char(g_ip_id2));
1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));

Line 1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));

1068: hr_utility.trace('G_ip_id3 : '||to_char(g_ip_id3));
1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));

Line 1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));

1069: hr_utility.trace('G_ip_id4 : '||to_char(g_ip_id4));
1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));

Line 1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));

1070: hr_utility.trace('G_ip_id5 : '||to_char(g_ip_id5));
1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));

Line 1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));

1071: hr_utility.trace('G_ip_id6 : '||to_char(g_ip_id6));
1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));
1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));

Line 1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));

1072: hr_utility.trace('G_ip_id7 : '||to_char(g_ip_id7));
1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));
1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));
1080: hr_utility.trace('G_ip_id15 : '||to_char(g_ip_id15));

Line 1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));

1073: hr_utility.trace('G_ip_id8 : '||to_char(g_ip_id8));
1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));
1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));
1080: hr_utility.trace('G_ip_id15 : '||to_char(g_ip_id15));
1081:

Line 1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));

1074: hr_utility.trace('G_ip_id9 : '||to_char(g_ip_id9));
1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));
1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));
1080: hr_utility.trace('G_ip_id15 : '||to_char(g_ip_id15));
1081:
1082: -- for the element find the input value ids

Line 1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));

1075: hr_utility.trace('G_ip_id10 : '||to_char(g_ip_id10));
1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));
1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));
1080: hr_utility.trace('G_ip_id15 : '||to_char(g_ip_id15));
1081:
1082: -- for the element find the input value ids
1083:

Line 1080: hr_utility.trace('G_ip_id15 : '||to_char(g_ip_id15));

1076: hr_utility.trace('G_ip_id11 : '||to_char(g_ip_id11));
1077: hr_utility.trace('G_ip_id12 : '||to_char(g_ip_id12));
1078: hr_utility.trace('G_ip_id13 : '||to_char(g_ip_id13));
1079: hr_utility.trace('G_ip_id14 : '||to_char(g_ip_id14));
1080: hr_utility.trace('G_ip_id15 : '||to_char(g_ip_id15));
1081:
1082: -- for the element find the input value ids
1083:
1084:

Line 1092: hr_utility.trace('g_element_type_id <> p_element_type_id satisfied ');

1088: open c_get_caflexnum(p_business_group_id);
1089: fetch c_get_caflexnum into g_flex_num;
1090: close c_get_caflexnum;
1091:
1092: hr_utility.trace('g_element_type_id <> p_element_type_id satisfied ');
1093: g_element_type_id := p_element_type_id;
1094:
1095: open c_get_input_value_id(p_element_type_id,p_effective_date);
1096: loop

Line 1099: hr_utility.trace('Input_value_id is : '|| to_char(l_inp_id));

1095: open c_get_input_value_id(p_element_type_id,p_effective_date);
1096: loop
1097: fetch c_get_input_value_id into l_inp_id, l_inp_name,l_inp_ds;
1098:
1099: hr_utility.trace('Input_value_id is : '|| to_char(l_inp_id));
1100: hr_utility.trace('Input value Name is : '|| l_inp_name);
1101: hr_utility.trace('Input value sequence is : '|| to_char(l_inp_ds));
1102:
1103: exit when c_get_input_value_id%NOTFOUND;

Line 1100: hr_utility.trace('Input value Name is : '|| l_inp_name);

1096: loop
1097: fetch c_get_input_value_id into l_inp_id, l_inp_name,l_inp_ds;
1098:
1099: hr_utility.trace('Input_value_id is : '|| to_char(l_inp_id));
1100: hr_utility.trace('Input value Name is : '|| l_inp_name);
1101: hr_utility.trace('Input value sequence is : '|| to_char(l_inp_ds));
1102:
1103: exit when c_get_input_value_id%NOTFOUND;
1104:

Line 1101: hr_utility.trace('Input value sequence is : '|| to_char(l_inp_ds));

1097: fetch c_get_input_value_id into l_inp_id, l_inp_name,l_inp_ds;
1098:
1099: hr_utility.trace('Input_value_id is : '|| to_char(l_inp_id));
1100: hr_utility.trace('Input value Name is : '|| l_inp_name);
1101: hr_utility.trace('Input value sequence is : '|| to_char(l_inp_ds));
1102:
1103: exit when c_get_input_value_id%NOTFOUND;
1104:
1105: i := i + 1 ;

Line 1233: hr_utility.trace('Done with c_get_input_value_id cursor ');

1229:
1230: end loop;
1231: close c_get_input_value_id;
1232:
1233: hr_utility.trace('Done with c_get_input_value_id cursor ');
1234:
1235: end if; -- g_element_type_id <> p_element_type_id
1236:
1237:

Line 1243: hr_utility.trace('Modifed g_ee_value1: ' || g_ee_value1);

1239: CASE g_display_sequence
1240:
1241: WHEN 1 THEN IF g_ee_value1 is null THEN
1242: g_ee_value1 := l_default_jd;
1243: hr_utility.trace('Modifed g_ee_value1: ' || g_ee_value1);
1244: END IF;
1245: WHEN 2 THEN IF g_ee_value2 is null THEN
1246: g_ee_value2 := l_default_jd;
1247: hr_utility.trace('Modifed l_ee_value2: ' || g_ee_value2);

Line 1247: hr_utility.trace('Modifed l_ee_value2: ' || g_ee_value2);

1243: hr_utility.trace('Modifed g_ee_value1: ' || g_ee_value1);
1244: END IF;
1245: WHEN 2 THEN IF g_ee_value2 is null THEN
1246: g_ee_value2 := l_default_jd;
1247: hr_utility.trace('Modifed l_ee_value2: ' || g_ee_value2);
1248: END IF;
1249: WHEN 3 THEN IF g_ee_value3 is null THEN
1250: g_ee_value3 := l_default_jd;
1251: hr_utility.trace('Modifed g_ee_value3: ' || g_ee_value3);

Line 1251: hr_utility.trace('Modifed g_ee_value3: ' || g_ee_value3);

1247: hr_utility.trace('Modifed l_ee_value2: ' || g_ee_value2);
1248: END IF;
1249: WHEN 3 THEN IF g_ee_value3 is null THEN
1250: g_ee_value3 := l_default_jd;
1251: hr_utility.trace('Modifed g_ee_value3: ' || g_ee_value3);
1252: END IF;
1253: WHEN 4 THEN IF g_ee_value4 is null THEN
1254: g_ee_value4 := l_default_jd;
1255: hr_utility.trace('Modifed g_ee_value4: ' || g_ee_value4);

Line 1255: hr_utility.trace('Modifed g_ee_value4: ' || g_ee_value4);

1251: hr_utility.trace('Modifed g_ee_value3: ' || g_ee_value3);
1252: END IF;
1253: WHEN 4 THEN IF g_ee_value4 is null THEN
1254: g_ee_value4 := l_default_jd;
1255: hr_utility.trace('Modifed g_ee_value4: ' || g_ee_value4);
1256: END IF;
1257: WHEN 5 THEN IF g_ee_value5 is null THEN
1258: g_ee_value5 := l_default_jd;
1259: hr_utility.trace('Modifed g_ee_value5: ' || g_ee_value5);

Line 1259: hr_utility.trace('Modifed g_ee_value5: ' || g_ee_value5);

1255: hr_utility.trace('Modifed g_ee_value4: ' || g_ee_value4);
1256: END IF;
1257: WHEN 5 THEN IF g_ee_value5 is null THEN
1258: g_ee_value5 := l_default_jd;
1259: hr_utility.trace('Modifed g_ee_value5: ' || g_ee_value5);
1260: END IF;
1261: WHEN 6 THEN IF g_ee_value6 is null THEN
1262: g_ee_value6 := l_default_jd;
1263: hr_utility.trace('Modifed g_ee_value6: ' || g_ee_value6);

Line 1263: hr_utility.trace('Modifed g_ee_value6: ' || g_ee_value6);

1259: hr_utility.trace('Modifed g_ee_value5: ' || g_ee_value5);
1260: END IF;
1261: WHEN 6 THEN IF g_ee_value6 is null THEN
1262: g_ee_value6 := l_default_jd;
1263: hr_utility.trace('Modifed g_ee_value6: ' || g_ee_value6);
1264: END IF;
1265: WHEN 7 THEN IF g_ee_value7 is null THEN
1266: g_ee_value7 := l_default_jd;
1267: hr_utility.trace('Modifed g_ee_value7: ' || g_ee_value7);

Line 1267: hr_utility.trace('Modifed g_ee_value7: ' || g_ee_value7);

1263: hr_utility.trace('Modifed g_ee_value6: ' || g_ee_value6);
1264: END IF;
1265: WHEN 7 THEN IF g_ee_value7 is null THEN
1266: g_ee_value7 := l_default_jd;
1267: hr_utility.trace('Modifed g_ee_value7: ' || g_ee_value7);
1268: END IF;
1269: WHEN 8 THEN IF g_ee_value8 is null THEN
1270: g_ee_value8 := l_default_jd;
1271: hr_utility.trace('Modifed g_ee_value8: ' || g_ee_value8);

Line 1271: hr_utility.trace('Modifed g_ee_value8: ' || g_ee_value8);

1267: hr_utility.trace('Modifed g_ee_value7: ' || g_ee_value7);
1268: END IF;
1269: WHEN 8 THEN IF g_ee_value8 is null THEN
1270: g_ee_value8 := l_default_jd;
1271: hr_utility.trace('Modifed g_ee_value8: ' || g_ee_value8);
1272: END IF;
1273: WHEN 9 THEN IF g_ee_value9 is null THEN
1274: g_ee_value9 := l_default_jd;
1275: hr_utility.trace('Modifed g_ee_value9: ' || g_ee_value9);

Line 1275: hr_utility.trace('Modifed g_ee_value9: ' || g_ee_value9);

1271: hr_utility.trace('Modifed g_ee_value8: ' || g_ee_value8);
1272: END IF;
1273: WHEN 9 THEN IF g_ee_value9 is null THEN
1274: g_ee_value9 := l_default_jd;
1275: hr_utility.trace('Modifed g_ee_value9: ' || g_ee_value9);
1276: END IF;
1277: WHEN 10 THEN IF g_ee_value10 is null THEN
1278: g_ee_value10 := l_default_jd;
1279: hr_utility.trace('Modifed g_ee_value10: ' || g_ee_value10);

Line 1279: hr_utility.trace('Modifed g_ee_value10: ' || g_ee_value10);

1275: hr_utility.trace('Modifed g_ee_value9: ' || g_ee_value9);
1276: END IF;
1277: WHEN 10 THEN IF g_ee_value10 is null THEN
1278: g_ee_value10 := l_default_jd;
1279: hr_utility.trace('Modifed g_ee_value10: ' || g_ee_value10);
1280: END IF;
1281: WHEN 11 THEN IF g_ee_value11 is null THEN
1282: g_ee_value11 := l_default_jd;
1283: hr_utility.trace('Modifed g_ee_value11: ' || g_ee_value11);

Line 1283: hr_utility.trace('Modifed g_ee_value11: ' || g_ee_value11);

1279: hr_utility.trace('Modifed g_ee_value10: ' || g_ee_value10);
1280: END IF;
1281: WHEN 11 THEN IF g_ee_value11 is null THEN
1282: g_ee_value11 := l_default_jd;
1283: hr_utility.trace('Modifed g_ee_value11: ' || g_ee_value11);
1284: END IF;
1285: WHEN 12 THEN IF g_ee_value12 is null THEN
1286: g_ee_value12 := l_default_jd;
1287: hr_utility.trace('Modifed g_ee_value12: ' || g_ee_value12);

Line 1287: hr_utility.trace('Modifed g_ee_value12: ' || g_ee_value12);

1283: hr_utility.trace('Modifed g_ee_value11: ' || g_ee_value11);
1284: END IF;
1285: WHEN 12 THEN IF g_ee_value12 is null THEN
1286: g_ee_value12 := l_default_jd;
1287: hr_utility.trace('Modifed g_ee_value12: ' || g_ee_value12);
1288: END IF;
1289: WHEN 13 THEN IF g_ee_value13 is null THEN
1290: g_ee_value13 := l_default_jd;
1291: hr_utility.trace('Modifed g_ee_value13: ' || g_ee_value13);

Line 1291: hr_utility.trace('Modifed g_ee_value13: ' || g_ee_value13);

1287: hr_utility.trace('Modifed g_ee_value12: ' || g_ee_value12);
1288: END IF;
1289: WHEN 13 THEN IF g_ee_value13 is null THEN
1290: g_ee_value13 := l_default_jd;
1291: hr_utility.trace('Modifed g_ee_value13: ' || g_ee_value13);
1292: END IF;
1293: WHEN 14 THEN IF g_ee_value14 is null THEN
1294: g_ee_value14 := l_default_jd;
1295: hr_utility.trace('Modifed g_ee_value14: ' || g_ee_value14);

Line 1295: hr_utility.trace('Modifed g_ee_value14: ' || g_ee_value14);

1291: hr_utility.trace('Modifed g_ee_value13: ' || g_ee_value13);
1292: END IF;
1293: WHEN 14 THEN IF g_ee_value14 is null THEN
1294: g_ee_value14 := l_default_jd;
1295: hr_utility.trace('Modifed g_ee_value14: ' || g_ee_value14);
1296: END IF;
1297: WHEN 15 THEN IF g_ee_value15 is null THEN
1298: g_ee_value15 := l_default_jd;
1299: hr_utility.trace('Modifed g_ee_value15: ' || g_ee_value15);

Line 1299: hr_utility.trace('Modifed g_ee_value15: ' || g_ee_value15);

1295: hr_utility.trace('Modifed g_ee_value14: ' || g_ee_value14);
1296: END IF;
1297: WHEN 15 THEN IF g_ee_value15 is null THEN
1298: g_ee_value15 := l_default_jd;
1299: hr_utility.trace('Modifed g_ee_value15: ' || g_ee_value15);
1300: END IF;
1301: END CASE;
1302:
1303: end if;

Line 1341: hr_utility.trace('#################################################');

1337:
1338: exception
1339:
1340: when others then
1341: hr_utility.trace('#################################################');
1342: hr_utility.trace('ERROR while uploading input values');
1343: hr_utility.trace('Enter valide input values for element input types');
1344: hr_utility.trace('#################################################');
1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');

Line 1342: hr_utility.trace('ERROR while uploading input values');

1338: exception
1339:
1340: when others then
1341: hr_utility.trace('#################################################');
1342: hr_utility.trace('ERROR while uploading input values');
1343: hr_utility.trace('Enter valide input values for element input types');
1344: hr_utility.trace('#################################################');
1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');
1346: --hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

Line 1343: hr_utility.trace('Enter valide input values for element input types');

1339:
1340: when others then
1341: hr_utility.trace('#################################################');
1342: hr_utility.trace('ERROR while uploading input values');
1343: hr_utility.trace('Enter valide input values for element input types');
1344: hr_utility.trace('#################################################');
1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');
1346: --hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1347:

Line 1344: hr_utility.trace('#################################################');

1340: when others then
1341: hr_utility.trace('#################################################');
1342: hr_utility.trace('ERROR while uploading input values');
1343: hr_utility.trace('Enter valide input values for element input types');
1344: hr_utility.trace('#################################################');
1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');
1346: --hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1347:
1348: case l_input_value_counter

Line 1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');

1341: hr_utility.trace('#################################################');
1342: hr_utility.trace('ERROR while uploading input values');
1343: hr_utility.trace('Enter valide input values for element input types');
1344: hr_utility.trace('#################################################');
1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');
1346: --hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1347:
1348: case l_input_value_counter
1349: when 1 then l_exception_id := g_ip_id1;

Line 1346: --hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

1342: hr_utility.trace('ERROR while uploading input values');
1343: hr_utility.trace('Enter valide input values for element input types');
1344: hr_utility.trace('#################################################');
1345: --hr_utility.set_message('PAY','PAY_449776_INPUT_VALUE_FORMAT');
1346: --hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1347:
1348: case l_input_value_counter
1349: when 1 then l_exception_id := g_ip_id1;
1350: when 2 then l_exception_id := g_ip_id2;

Line 1366: hr_utility.trace('l_exception_id: '|| l_exception_id);

1362: when 14 then l_exception_id := g_ip_id14;
1363: when 15 then l_exception_id := g_ip_id15;
1364: end case;
1365:
1366: hr_utility.trace('l_exception_id: '|| l_exception_id);
1367:
1368: SELECT name INTO l_exception_message
1369: FROM pay_input_values_f
1370: WHERE element_type_id= p_element_type_id

Line 1375: hr_utility.trace('l_exception_message: '|| l_exception_message);

1371: AND p_effective_date between effective_start_date and effective_end_date
1372: AND input_value_id = l_exception_id
1373: ORDER BY display_sequence, name;
1374:
1375: hr_utility.trace('l_exception_message: '|| l_exception_message);
1376:
1377: hr_utility.set_message('PAY',l_exception_message);
1378:
1379: --hr_utility.set_message_token('COLUMN', l_exception_message);

Line 1377: hr_utility.set_message('PAY',l_exception_message);

1373: ORDER BY display_sequence, name;
1374:
1375: hr_utility.trace('l_exception_message: '|| l_exception_message);
1376:
1377: hr_utility.set_message('PAY',l_exception_message);
1378:
1379: --hr_utility.set_message_token('COLUMN', l_exception_message);
1380: hr_utility.trace('l_exception_message:'||l_exception_id);
1381: hr_utility.raise_error;

Line 1379: --hr_utility.set_message_token('COLUMN', l_exception_message);

1375: hr_utility.trace('l_exception_message: '|| l_exception_message);
1376:
1377: hr_utility.set_message('PAY',l_exception_message);
1378:
1379: --hr_utility.set_message_token('COLUMN', l_exception_message);
1380: hr_utility.trace('l_exception_message:'||l_exception_id);
1381: hr_utility.raise_error;
1382: end;
1383:

Line 1380: hr_utility.trace('l_exception_message:'||l_exception_id);

1376:
1377: hr_utility.set_message('PAY',l_exception_message);
1378:
1379: --hr_utility.set_message_token('COLUMN', l_exception_message);
1380: hr_utility.trace('l_exception_message:'||l_exception_id);
1381: hr_utility.raise_error;
1382: end;
1383:
1384: -- This moved to above condition.

Line 1381: hr_utility.raise_error;

1377: hr_utility.set_message('PAY',l_exception_message);
1378:
1379: --hr_utility.set_message_token('COLUMN', l_exception_message);
1380: hr_utility.trace('l_exception_message:'||l_exception_id);
1381: hr_utility.raise_error;
1382: end;
1383:
1384: -- This moved to above condition.
1385: -- Bug: 5079557

Line 1411: hr_utility.trace('l_batch_line_exists: ' || l_batch_line_exists);

1407: l_batch_line_exists := 'Y';
1408: END IF;
1409: CLOSE csr_get_batch_line_details;
1410:
1411: hr_utility.trace('l_batch_line_exists: ' || l_batch_line_exists);
1412:
1413: /* If we need to raise an error if user updates the above mentioned columns we can reuse the following code.
1414:
1415: IF l_batch_line_exists = 'Y' THEN

Line 1417: hr_utility.trace('ln_old_assignment_id: ' || ln_old_assignment_id);

1413: /* If we need to raise an error if user updates the above mentioned columns we can reuse the following code.
1414:
1415: IF l_batch_line_exists = 'Y' THEN
1416: IF ln_old_assignment_id != ln_assignment_id THEN
1417: hr_utility.trace('ln_old_assignment_id: ' || ln_old_assignment_id);
1418: hr_utility.trace('ln_assignment_id: ' || ln_assignment_id);
1419: hr_utility.trace('ERROR: Assignment Number can not be modified');
1420: hr_utility.raise_error;
1421: ELSE

Line 1418: hr_utility.trace('ln_assignment_id: ' || ln_assignment_id);

1414:
1415: IF l_batch_line_exists = 'Y' THEN
1416: IF ln_old_assignment_id != ln_assignment_id THEN
1417: hr_utility.trace('ln_old_assignment_id: ' || ln_old_assignment_id);
1418: hr_utility.trace('ln_assignment_id: ' || ln_assignment_id);
1419: hr_utility.trace('ERROR: Assignment Number can not be modified');
1420: hr_utility.raise_error;
1421: ELSE
1422: OPEN csr_get_batch_group_details(l_old_batch_group_id);

Line 1419: hr_utility.trace('ERROR: Assignment Number can not be modified');

1415: IF l_batch_line_exists = 'Y' THEN
1416: IF ln_old_assignment_id != ln_assignment_id THEN
1417: hr_utility.trace('ln_old_assignment_id: ' || ln_old_assignment_id);
1418: hr_utility.trace('ln_assignment_id: ' || ln_assignment_id);
1419: hr_utility.trace('ERROR: Assignment Number can not be modified');
1420: hr_utility.raise_error;
1421: ELSE
1422: OPEN csr_get_batch_group_details(l_old_batch_group_id);
1423: FETCH csr_get_batch_group_details INTO l_old_batch_group_status, l_old_consolidation_set_id, l_old_effective_date, l_old_prepay_flag;

Line 1420: hr_utility.raise_error;

1416: IF ln_old_assignment_id != ln_assignment_id THEN
1417: hr_utility.trace('ln_old_assignment_id: ' || ln_old_assignment_id);
1418: hr_utility.trace('ln_assignment_id: ' || ln_assignment_id);
1419: hr_utility.trace('ERROR: Assignment Number can not be modified');
1420: hr_utility.raise_error;
1421: ELSE
1422: OPEN csr_get_batch_group_details(l_old_batch_group_id);
1423: FETCH csr_get_batch_group_details INTO l_old_batch_group_status, l_old_consolidation_set_id, l_old_effective_date, l_old_prepay_flag;
1424: CLOSE csr_get_batch_group_details;

Line 1449: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);

1445:
1446:
1447:
1448:
1449: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);
1450: lv_batch_group_exists := 'N';
1451:
1452: hr_utility.trace('pay_batch_balanceadj_wrapper.gtr_batch_group_data.count'||pay_batch_balanceadj_wrapper.gtr_batch_group_data.count);
1453: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);

Line 1452: hr_utility.trace('pay_batch_balanceadj_wrapper.gtr_batch_group_data.count'||pay_batch_balanceadj_wrapper.gtr_batch_group_data.count);

1448:
1449: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);
1450: lv_batch_group_exists := 'N';
1451:
1452: hr_utility.trace('pay_batch_balanceadj_wrapper.gtr_batch_group_data.count'||pay_batch_balanceadj_wrapper.gtr_batch_group_data.count);
1453: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);
1454:
1455: begin
1456:

Line 1453: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);

1449: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);
1450: lv_batch_group_exists := 'N';
1451:
1452: hr_utility.trace('pay_batch_balanceadj_wrapper.gtr_batch_group_data.count'||pay_batch_balanceadj_wrapper.gtr_batch_group_data.count);
1453: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);
1454:
1455: begin
1456:
1457: hr_utility.trace('p_batch_id-->'||p_batch_id);

Line 1457: hr_utility.trace('p_batch_id-->'||p_batch_id);

1453: hr_utility.trace('lv_batch_group_exists'|| lv_batch_group_exists);
1454:
1455: begin
1456:
1457: hr_utility.trace('p_batch_id-->'||p_batch_id);
1458: hr_utility.trace('l_consolidation_set_id-->' || l_consolidation_set_id);
1459: hr_utility.trace('ln_payroll_id -->' || ln_payroll_id);
1460: hr_utility.trace('p_effective_date -->' || p_effective_date);
1461: hr_utility.trace('l_prepay_flag -->' || l_prepay_flag);

Line 1458: hr_utility.trace('l_consolidation_set_id-->' || l_consolidation_set_id);

1454:
1455: begin
1456:
1457: hr_utility.trace('p_batch_id-->'||p_batch_id);
1458: hr_utility.trace('l_consolidation_set_id-->' || l_consolidation_set_id);
1459: hr_utility.trace('ln_payroll_id -->' || ln_payroll_id);
1460: hr_utility.trace('p_effective_date -->' || p_effective_date);
1461: hr_utility.trace('l_prepay_flag -->' || l_prepay_flag);
1462:

Line 1459: hr_utility.trace('ln_payroll_id -->' || ln_payroll_id);

1455: begin
1456:
1457: hr_utility.trace('p_batch_id-->'||p_batch_id);
1458: hr_utility.trace('l_consolidation_set_id-->' || l_consolidation_set_id);
1459: hr_utility.trace('ln_payroll_id -->' || ln_payroll_id);
1460: hr_utility.trace('p_effective_date -->' || p_effective_date);
1461: hr_utility.trace('l_prepay_flag -->' || l_prepay_flag);
1462:
1463: OPEN csr_check_batch_group(p_batch_id,l_consolidation_set_id,ln_payroll_id,p_effective_date,l_prepay_flag);

Line 1460: hr_utility.trace('p_effective_date -->' || p_effective_date);

1456:
1457: hr_utility.trace('p_batch_id-->'||p_batch_id);
1458: hr_utility.trace('l_consolidation_set_id-->' || l_consolidation_set_id);
1459: hr_utility.trace('ln_payroll_id -->' || ln_payroll_id);
1460: hr_utility.trace('p_effective_date -->' || p_effective_date);
1461: hr_utility.trace('l_prepay_flag -->' || l_prepay_flag);
1462:
1463: OPEN csr_check_batch_group(p_batch_id,l_consolidation_set_id,ln_payroll_id,p_effective_date,l_prepay_flag);
1464: FETCH csr_check_batch_group INTO l_batch_group_id, l_batch_group_status;

Line 1461: hr_utility.trace('l_prepay_flag -->' || l_prepay_flag);

1457: hr_utility.trace('p_batch_id-->'||p_batch_id);
1458: hr_utility.trace('l_consolidation_set_id-->' || l_consolidation_set_id);
1459: hr_utility.trace('ln_payroll_id -->' || ln_payroll_id);
1460: hr_utility.trace('p_effective_date -->' || p_effective_date);
1461: hr_utility.trace('l_prepay_flag -->' || l_prepay_flag);
1462:
1463: OPEN csr_check_batch_group(p_batch_id,l_consolidation_set_id,ln_payroll_id,p_effective_date,l_prepay_flag);
1464: FETCH csr_check_batch_group INTO l_batch_group_id, l_batch_group_status;
1465: IF csr_check_batch_group%NOTFOUND THEN

Line 1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');

1470: CLOSE csr_check_batch_group;
1471:
1472: if lv_batch_group_exists = 'N' then
1473:
1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');
1475: select pay_adjust_batch_groups_s.nextval into l_batch_group_id
1476: from dual;
1477:
1478: insert into pay_adjust_batch_groups

Line 1495: hr_utility.trace('Done inserting into pay_adjust_batch_groups table');

1491: p_effective_date,
1492: l_prepay_flag);
1493:
1494: l_batch_group_status := 'U';
1495: hr_utility.trace('Done inserting into pay_adjust_batch_groups table');
1496: hr_utility.trace('New Batch Group id: '||to_char(l_batch_group_id));
1497:
1498: end if; /* lv_batch_group_exists = 'N' */
1499:

Line 1496: hr_utility.trace('New Batch Group id: '||to_char(l_batch_group_id));

1492: l_prepay_flag);
1493:
1494: l_batch_group_status := 'U';
1495: hr_utility.trace('Done inserting into pay_adjust_batch_groups table');
1496: hr_utility.trace('New Batch Group id: '||to_char(l_batch_group_id));
1497:
1498: end if; /* lv_batch_group_exists = 'N' */
1499:
1500: end;

Line 1513: hr_utility.trace('l_batch_group_status : '||l_batch_group_status);

1509: 'T' --> Transferred
1510: 'C' --> Completed
1511: */
1512:
1513: hr_utility.trace('l_batch_group_status : '||l_batch_group_status);
1514:
1515: if l_batch_group_status not in ('L','T','C') then
1516:
1517: /* check if batch line exists */

Line 1518: hr_utility.trace('l_batch_group_status satisfied not in L, T, C ');

1514:
1515: if l_batch_group_status not in ('L','T','C') then
1516:
1517: /* check if batch line exists */
1518: hr_utility.trace('l_batch_group_status satisfied not in L, T, C ');
1519:
1520: begin
1521:
1522: IF l_batch_line_id IS NULL THEN

Line 1533: hr_utility.trace('l_batch_line_id : '|| l_batch_line_id);

1529: END IF;
1530: CLOSE csr_check_batch_line;
1531: END IF;
1532:
1533: hr_utility.trace('l_batch_line_id : '|| l_batch_line_id);
1534: hr_utility.trace('l_batch_line_status : '||l_batch_line_status);
1535:
1536:
1537: IF l_batch_line_exists = 'Y' THEN

Line 1534: hr_utility.trace('l_batch_line_status : '||l_batch_line_status);

1530: CLOSE csr_check_batch_line;
1531: END IF;
1532:
1533: hr_utility.trace('l_batch_line_id : '|| l_batch_line_id);
1534: hr_utility.trace('l_batch_line_status : '||l_batch_line_status);
1535:
1536:
1537: IF l_batch_line_exists = 'Y' THEN
1538:

Line 1541: hr_utility.trace('l_batch_line_status is C, T raise exception ');

1537: IF l_batch_line_exists = 'Y' THEN
1538:
1539: if l_batch_line_status in ('C','T') then
1540:
1541: hr_utility.trace('l_batch_line_status is C, T raise exception ');
1542: raise ex_cannot_update_bl; -- cannot update a completed/ transferred line
1543:
1544: else
1545:

Line 1548: hr_utility.trace('Costing Flag is set to Yes ');

1544: else
1545:
1546: if l_costing_flag = 'Y' then
1547:
1548: hr_utility.trace('Costing Flag is set to Yes ');
1549: l_cakff_id := get_costing_info(p_concatenated_segments,
1550: segment1,segment2,segment3,segment4,segment5,
1551: segment6,segment7,segment8,segment9,segment10,
1552: segment11,segment12,segment13,segment14,segment15,

Line 1557: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));

1553: segment16,segment17,segment18,segment19,segment20,
1554: segment21,segment22,segment23,segment24,segment25,
1555: segment26,segment27,segment28,segment29,segment30);
1556:
1557: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1558:
1559: end if;
1560:
1561: hr_utility.trace('Update of pay_adjust_batch_lines ');

Line 1561: hr_utility.trace('Update of pay_adjust_batch_lines ');

1557: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1558:
1559: end if;
1560:
1561: hr_utility.trace('Update of pay_adjust_batch_lines ');
1562:
1563: UPDATE pay_adjust_batch_lines
1564: SET entry_value1 = g_ee_value1,
1565: entry_value2 = g_ee_value2,

Line 1590: hr_utility.trace('No data found for pay_adjust_batch_lines ');

1586:
1587: end if; /*End of If l_batch_line_status in ('C','T') */
1588:
1589: else
1590: hr_utility.trace('No data found for pay_adjust_batch_lines ');
1591:
1592: IF l_costing_flag = 'Y' THEN
1593: hr_utility.trace('Costing Flag is set to Yes ');
1594: l_cakff_id := get_costing_info(p_concatenated_segments,

Line 1593: hr_utility.trace('Costing Flag is set to Yes ');

1589: else
1590: hr_utility.trace('No data found for pay_adjust_batch_lines ');
1591:
1592: IF l_costing_flag = 'Y' THEN
1593: hr_utility.trace('Costing Flag is set to Yes ');
1594: l_cakff_id := get_costing_info(p_concatenated_segments,
1595: segment1,segment2,segment3,segment4,segment5,
1596: segment6,segment7,segment8,segment9,segment10,
1597: segment11,segment12,segment13,segment14,segment15,

Line 1601: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));

1597: segment11,segment12,segment13,segment14,segment15,
1598: segment16,segment17,segment18,segment19,segment20,
1599: segment21,segment22,segment23,segment24,segment25,
1600: segment26,segment27,segment28,segment29,segment30);
1601: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1602: END IF;
1603:
1604: hr_utility.trace('inserting into pay_adjust_batch_lines table');
1605: insert into pay_adjust_batch_lines(batch_line_id,

Line 1604: hr_utility.trace('inserting into pay_adjust_batch_lines table');

1600: segment26,segment27,segment28,segment29,segment30);
1601: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1602: END IF;
1603:
1604: hr_utility.trace('inserting into pay_adjust_batch_lines table');
1605: insert into pay_adjust_batch_lines(batch_line_id,
1606: batch_id,
1607: batch_line_status,
1608: batch_group_id,

Line 1692: hr_utility.trace('raising exception l_batch_group_status : '||l_batch_group_status);

1688: END; /* End of block started at l_batch_group_status not in ('L','T','C') */
1689:
1690: else /* l_batch_group_status */
1691:
1692: hr_utility.trace('raising exception l_batch_group_status : '||l_batch_group_status);
1693: raise ex_cannot_update_bg;
1694:
1695: end if; /* l_batch_group_status */
1696:

Line 1701: hr_utility.trace('Batch Group is either Transferred or Complete, cannot update the batch');

1697: exception
1698:
1699: when ex_cannot_update_bg then
1700:
1701: hr_utility.trace('Batch Group is either Transferred or Complete, cannot update the batch');
1702:
1703: when ex_cannot_update_bl then
1704:
1705: hr_utility.trace('Batch Line is either Transferred or Complete, cannot update the batch');

Line 1705: hr_utility.trace('Batch Line is either Transferred or Complete, cannot update the batch');

1701: hr_utility.trace('Batch Group is either Transferred or Complete, cannot update the batch');
1702:
1703: when ex_cannot_update_bl then
1704:
1705: hr_utility.trace('Batch Line is either Transferred or Complete, cannot update the batch');
1706:
1707:
1708: --hr_utility.trace_off;
1709: end;

Line 1708: --hr_utility.trace_off;

1704:
1705: hr_utility.trace('Batch Line is either Transferred or Complete, cannot update the batch');
1706:
1707:
1708: --hr_utility.trace_off;
1709: end;
1710:
1711: /*
1712: Function to be used to display input values in correct format

Line 1789: --hr_utility.trace_on(null,'RK');

1785: AND p_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
1786: ORDER BY piv.display_sequence,piv.name;
1787: --
1788: begin
1789: --hr_utility.trace_on(null,'RK');
1790: hr_utility.trace(' p_input_value ->' || p_input_value);
1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);

Line 1790: hr_utility.trace(' p_input_value ->' || p_input_value);

1786: ORDER BY piv.display_sequence,piv.name;
1787: --
1788: begin
1789: --hr_utility.trace_on(null,'RK');
1790: hr_utility.trace(' p_input_value ->' || p_input_value);
1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1794: hr_utility.trace(' p_session_date -> ' || p_session_date );

Line 1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );

1787: --
1788: begin
1789: --hr_utility.trace_on(null,'RK');
1790: hr_utility.trace(' p_input_value ->' || p_input_value);
1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1794: hr_utility.trace(' p_session_date -> ' || p_session_date );
1795: hr_utility.trace(' p_batch_id -> ' || p_batch_id );

Line 1792: hr_utility.trace(' p_input_value -> ' || p_input_value );

1788: begin
1789: --hr_utility.trace_on(null,'RK');
1790: hr_utility.trace(' p_input_value ->' || p_input_value);
1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1794: hr_utility.trace(' p_session_date -> ' || p_session_date );
1795: hr_utility.trace(' p_batch_id -> ' || p_batch_id );
1796:

Line 1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);

1789: --hr_utility.trace_on(null,'RK');
1790: hr_utility.trace(' p_input_value ->' || p_input_value);
1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1794: hr_utility.trace(' p_session_date -> ' || p_session_date );
1795: hr_utility.trace(' p_batch_id -> ' || p_batch_id );
1796:
1797: --

Line 1794: hr_utility.trace(' p_session_date -> ' || p_session_date );

1790: hr_utility.trace(' p_input_value ->' || p_input_value);
1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1794: hr_utility.trace(' p_session_date -> ' || p_session_date );
1795: hr_utility.trace(' p_batch_id -> ' || p_batch_id );
1796:
1797: --
1798: if p_input_value is null then

Line 1795: hr_utility.trace(' p_batch_id -> ' || p_batch_id );

1791: hr_utility.trace(' p_element_type_id -> ' || p_element_type_id );
1792: hr_utility.trace(' p_input_value -> ' || p_input_value );
1793: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1794: hr_utility.trace(' p_session_date -> ' || p_session_date );
1795: hr_utility.trace(' p_batch_id -> ' || p_batch_id );
1796:
1797: --
1798: if p_input_value is null then
1799: return p_input_value;

Line 1833: hr_utility.trace('======================================================');

1829: END IF; */
1830:
1831:
1832:
1833: hr_utility.trace('======================================================');
1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );
1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );
1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);

Line 1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);

1830:
1831:
1832:
1833: hr_utility.trace('======================================================');
1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );
1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );
1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);
1838: hr_utility.trace('======================================================');

Line 1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );

1831:
1832:
1833: hr_utility.trace('======================================================');
1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );
1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );
1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);
1838: hr_utility.trace('======================================================');
1839:

Line 1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );

1832:
1833: hr_utility.trace('======================================================');
1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );
1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );
1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);
1838: hr_utility.trace('======================================================');
1839:
1840: --

Line 1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);

1833: hr_utility.trace('======================================================');
1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );
1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );
1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);
1838: hr_utility.trace('======================================================');
1839:
1840: --
1841: -- BBA now handles input value of date in canonical format.

Line 1838: hr_utility.trace('======================================================');

1834: hr_utility.trace(' p_input_value_id -> ' || p_input_value_number);
1835: hr_utility.trace(' l_uom_value -> ' || l_uom_value );
1836: hr_utility.trace(' l_lookup_type -> ' || l_lookup_type );
1837: hr_utility.trace(' l_value_set_id -> ' || l_value_set_id);
1838: hr_utility.trace('======================================================');
1839:
1840: --
1841: -- BBA now handles input value of date in canonical format.
1842: -- However the EE API expects the data in the DD-MON-YYYY format.

Line 1845: hr_utility.trace('p_input_value, before D ->' || p_input_value);

1841: -- BBA now handles input value of date in canonical format.
1842: -- However the EE API expects the data in the DD-MON-YYYY format.
1843: -- The DD-MON-YYYY is the default format of the fnd_date.
1844: --
1845: hr_utility.trace('p_input_value, before D ->' || p_input_value);
1846: hr_utility.trace('l_display_value, before D ->' || l_display_value);
1847: if l_uom_value = 'D' then
1848:
1849: begin

Line 1846: hr_utility.trace('l_display_value, before D ->' || l_display_value);

1842: -- However the EE API expects the data in the DD-MON-YYYY format.
1843: -- The DD-MON-YYYY is the default format of the fnd_date.
1844: --
1845: hr_utility.trace('p_input_value, before D ->' || p_input_value);
1846: hr_utility.trace('l_display_value, before D ->' || l_display_value);
1847: if l_uom_value = 'D' then
1848:
1849: begin
1850:

Line 1857: hr_utility.trace('after usind fnd_date package l_display_value: ' || l_display_value);

1853: END IF;
1854:
1855: l_display_value := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_input_value));
1856:
1857: hr_utility.trace('after usind fnd_date package l_display_value: ' || l_display_value);
1858: hr_utility.trace('p_input_value in D ->' || p_input_value);
1859: hr_utility.trace('l_display_value in D ->' || l_display_value);
1860:
1861: exception

Line 1858: hr_utility.trace('p_input_value in D ->' || p_input_value);

1854:
1855: l_display_value := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_input_value));
1856:
1857: hr_utility.trace('after usind fnd_date package l_display_value: ' || l_display_value);
1858: hr_utility.trace('p_input_value in D ->' || p_input_value);
1859: hr_utility.trace('l_display_value in D ->' || l_display_value);
1860:
1861: exception
1862:

Line 1859: hr_utility.trace('l_display_value in D ->' || l_display_value);

1855: l_display_value := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_input_value));
1856:
1857: hr_utility.trace('after usind fnd_date package l_display_value: ' || l_display_value);
1858: hr_utility.trace('p_input_value in D ->' || p_input_value);
1859: hr_utility.trace('l_display_value in D ->' || l_display_value);
1860:
1861: exception
1862:
1863: when others then

Line 1864: hr_utility.trace(' In Exception -> ' || l_display_value);

1860:
1861: exception
1862:
1863: when others then
1864: hr_utility.trace(' In Exception -> ' || l_display_value);
1865: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1866: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1867: hr_utility.raise_error;
1868: end;

Line 1865: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

1861: exception
1862:
1863: when others then
1864: hr_utility.trace(' In Exception -> ' || l_display_value);
1865: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1866: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1867: hr_utility.raise_error;
1868: end;
1869:

Line 1866: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));

1862:
1863: when others then
1864: hr_utility.trace(' In Exception -> ' || l_display_value);
1865: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1866: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1867: hr_utility.raise_error;
1868: end;
1869:
1870: else

Line 1867: hr_utility.raise_error;

1863: when others then
1864: hr_utility.trace(' In Exception -> ' || l_display_value);
1865: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1866: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1867: hr_utility.raise_error;
1868: end;
1869:
1870: else
1871:

Line 1874: hr_utility.trace('p_input_value in else ->' || p_input_value);

1870: else
1871:
1872: begin
1873:
1874: hr_utility.trace('p_input_value in else ->' || p_input_value);
1875: hr_utility.trace('l_display_value in else ->' || l_display_value);
1876: l_display_value := p_input_value;
1877:
1878: exception

Line 1875: hr_utility.trace('l_display_value in else ->' || l_display_value);

1871:
1872: begin
1873:
1874: hr_utility.trace('p_input_value in else ->' || p_input_value);
1875: hr_utility.trace('l_display_value in else ->' || l_display_value);
1876: l_display_value := p_input_value;
1877:
1878: exception
1879:

Line 1881: hr_utility.trace(' In Exception ->l_display_value := p_input_value; ' || l_display_value);

1877:
1878: exception
1879:
1880: when others then
1881: hr_utility.trace(' In Exception ->l_display_value := p_input_value; ' || l_display_value);
1882: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1883: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1884: hr_utility.raise_error;
1885:

Line 1882: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

1878: exception
1879:
1880: when others then
1881: hr_utility.trace(' In Exception ->l_display_value := p_input_value; ' || l_display_value);
1882: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1883: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1884: hr_utility.raise_error;
1885:
1886: end;

Line 1883: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));

1879:
1880: when others then
1881: hr_utility.trace(' In Exception ->l_display_value := p_input_value; ' || l_display_value);
1882: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1883: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1884: hr_utility.raise_error;
1885:
1886: end;
1887:

Line 1884: hr_utility.raise_error;

1880: when others then
1881: hr_utility.trace(' In Exception ->l_display_value := p_input_value; ' || l_display_value);
1882: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1883: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1884: hr_utility.raise_error;
1885:
1886: end;
1887:
1888: end if;

Line 1913: hr_utility.trace('ERROR: Invalid lookup Value');

1909: -- Bug: 5200900
1910:
1911: IF csr_valid_lookup%NOTFOUND THEN
1912:
1913: hr_utility.trace('ERROR: Invalid lookup Value');
1914: hr_utility.raise_error();
1915:
1916: ELSE
1917:

Line 1914: hr_utility.raise_error();

1910:
1911: IF csr_valid_lookup%NOTFOUND THEN
1912:
1913: hr_utility.trace('ERROR: Invalid lookup Value');
1914: hr_utility.raise_error();
1915:
1916: ELSE
1917:
1918: hr_utility.trace('Info: Valid lookup');

Line 1918: hr_utility.trace('Info: Valid lookup');

1914: hr_utility.raise_error();
1915:
1916: ELSE
1917:
1918: hr_utility.trace('Info: Valid lookup');
1919:
1920: CASE p_input_value_number
1921:
1922: WHEN 1 THEN g_ee_value1 := l_display_value;

Line 1923: hr_utility.trace('Updated g_ee_value1 :' || g_ee_value1);

1919:
1920: CASE p_input_value_number
1921:
1922: WHEN 1 THEN g_ee_value1 := l_display_value;
1923: hr_utility.trace('Updated g_ee_value1 :' || g_ee_value1);
1924: WHEN 2 THEN g_ee_value2 := l_display_value;
1925: hr_utility.trace('Updated g_ee_value2 :' || g_ee_value2);
1926: WHEN 3 THEN g_ee_value3 := l_display_value;
1927: hr_utility.trace('Updated g_ee_value3 :' || g_ee_value3);

Line 1925: hr_utility.trace('Updated g_ee_value2 :' || g_ee_value2);

1921:
1922: WHEN 1 THEN g_ee_value1 := l_display_value;
1923: hr_utility.trace('Updated g_ee_value1 :' || g_ee_value1);
1924: WHEN 2 THEN g_ee_value2 := l_display_value;
1925: hr_utility.trace('Updated g_ee_value2 :' || g_ee_value2);
1926: WHEN 3 THEN g_ee_value3 := l_display_value;
1927: hr_utility.trace('Updated g_ee_value3 :' || g_ee_value3);
1928: WHEN 4 THEN g_ee_value4 := l_display_value;
1929: hr_utility.trace('Updated g_ee_value4 :' || g_ee_value4);

Line 1927: hr_utility.trace('Updated g_ee_value3 :' || g_ee_value3);

1923: hr_utility.trace('Updated g_ee_value1 :' || g_ee_value1);
1924: WHEN 2 THEN g_ee_value2 := l_display_value;
1925: hr_utility.trace('Updated g_ee_value2 :' || g_ee_value2);
1926: WHEN 3 THEN g_ee_value3 := l_display_value;
1927: hr_utility.trace('Updated g_ee_value3 :' || g_ee_value3);
1928: WHEN 4 THEN g_ee_value4 := l_display_value;
1929: hr_utility.trace('Updated g_ee_value4 :' || g_ee_value4);
1930: WHEN 5 THEN g_ee_value5 := l_display_value;
1931: hr_utility.trace('Updated g_ee_value5 :' || g_ee_value5);

Line 1929: hr_utility.trace('Updated g_ee_value4 :' || g_ee_value4);

1925: hr_utility.trace('Updated g_ee_value2 :' || g_ee_value2);
1926: WHEN 3 THEN g_ee_value3 := l_display_value;
1927: hr_utility.trace('Updated g_ee_value3 :' || g_ee_value3);
1928: WHEN 4 THEN g_ee_value4 := l_display_value;
1929: hr_utility.trace('Updated g_ee_value4 :' || g_ee_value4);
1930: WHEN 5 THEN g_ee_value5 := l_display_value;
1931: hr_utility.trace('Updated g_ee_value5 :' || g_ee_value5);
1932: WHEN 6 THEN g_ee_value6 := l_display_value;
1933: hr_utility.trace('Updated g_ee_value6 :' || g_ee_value6);

Line 1931: hr_utility.trace('Updated g_ee_value5 :' || g_ee_value5);

1927: hr_utility.trace('Updated g_ee_value3 :' || g_ee_value3);
1928: WHEN 4 THEN g_ee_value4 := l_display_value;
1929: hr_utility.trace('Updated g_ee_value4 :' || g_ee_value4);
1930: WHEN 5 THEN g_ee_value5 := l_display_value;
1931: hr_utility.trace('Updated g_ee_value5 :' || g_ee_value5);
1932: WHEN 6 THEN g_ee_value6 := l_display_value;
1933: hr_utility.trace('Updated g_ee_value6 :' || g_ee_value6);
1934: WHEN 7 THEN g_ee_value7 := l_display_value;
1935: hr_utility.trace('Updated g_ee_value7 :' || g_ee_value7);

Line 1933: hr_utility.trace('Updated g_ee_value6 :' || g_ee_value6);

1929: hr_utility.trace('Updated g_ee_value4 :' || g_ee_value4);
1930: WHEN 5 THEN g_ee_value5 := l_display_value;
1931: hr_utility.trace('Updated g_ee_value5 :' || g_ee_value5);
1932: WHEN 6 THEN g_ee_value6 := l_display_value;
1933: hr_utility.trace('Updated g_ee_value6 :' || g_ee_value6);
1934: WHEN 7 THEN g_ee_value7 := l_display_value;
1935: hr_utility.trace('Updated g_ee_value7 :' || g_ee_value7);
1936: WHEN 8 THEN g_ee_value8 := l_display_value;
1937: hr_utility.trace('Updated g_ee_value8 :' || g_ee_value8);

Line 1935: hr_utility.trace('Updated g_ee_value7 :' || g_ee_value7);

1931: hr_utility.trace('Updated g_ee_value5 :' || g_ee_value5);
1932: WHEN 6 THEN g_ee_value6 := l_display_value;
1933: hr_utility.trace('Updated g_ee_value6 :' || g_ee_value6);
1934: WHEN 7 THEN g_ee_value7 := l_display_value;
1935: hr_utility.trace('Updated g_ee_value7 :' || g_ee_value7);
1936: WHEN 8 THEN g_ee_value8 := l_display_value;
1937: hr_utility.trace('Updated g_ee_value8 :' || g_ee_value8);
1938: WHEN 9 THEN g_ee_value9 := l_display_value;
1939: hr_utility.trace('Updated g_ee_value9 :' || g_ee_value9);

Line 1937: hr_utility.trace('Updated g_ee_value8 :' || g_ee_value8);

1933: hr_utility.trace('Updated g_ee_value6 :' || g_ee_value6);
1934: WHEN 7 THEN g_ee_value7 := l_display_value;
1935: hr_utility.trace('Updated g_ee_value7 :' || g_ee_value7);
1936: WHEN 8 THEN g_ee_value8 := l_display_value;
1937: hr_utility.trace('Updated g_ee_value8 :' || g_ee_value8);
1938: WHEN 9 THEN g_ee_value9 := l_display_value;
1939: hr_utility.trace('Updated g_ee_value9 :' || g_ee_value9);
1940: WHEN 10 THEN g_ee_value10 := l_display_value;
1941: hr_utility.trace('Updated g_ee_value10 :' || g_ee_value10);

Line 1939: hr_utility.trace('Updated g_ee_value9 :' || g_ee_value9);

1935: hr_utility.trace('Updated g_ee_value7 :' || g_ee_value7);
1936: WHEN 8 THEN g_ee_value8 := l_display_value;
1937: hr_utility.trace('Updated g_ee_value8 :' || g_ee_value8);
1938: WHEN 9 THEN g_ee_value9 := l_display_value;
1939: hr_utility.trace('Updated g_ee_value9 :' || g_ee_value9);
1940: WHEN 10 THEN g_ee_value10 := l_display_value;
1941: hr_utility.trace('Updated g_ee_value10 :' || g_ee_value10);
1942: WHEN 11 THEN g_ee_value11 := l_display_value;
1943: hr_utility.trace('Updated g_ee_value11 :' || g_ee_value11);

Line 1941: hr_utility.trace('Updated g_ee_value10 :' || g_ee_value10);

1937: hr_utility.trace('Updated g_ee_value8 :' || g_ee_value8);
1938: WHEN 9 THEN g_ee_value9 := l_display_value;
1939: hr_utility.trace('Updated g_ee_value9 :' || g_ee_value9);
1940: WHEN 10 THEN g_ee_value10 := l_display_value;
1941: hr_utility.trace('Updated g_ee_value10 :' || g_ee_value10);
1942: WHEN 11 THEN g_ee_value11 := l_display_value;
1943: hr_utility.trace('Updated g_ee_value11 :' || g_ee_value11);
1944: WHEN 12 THEN g_ee_value12 := l_display_value;
1945: hr_utility.trace('Updated g_ee_value12 :' || g_ee_value12);

Line 1943: hr_utility.trace('Updated g_ee_value11 :' || g_ee_value11);

1939: hr_utility.trace('Updated g_ee_value9 :' || g_ee_value9);
1940: WHEN 10 THEN g_ee_value10 := l_display_value;
1941: hr_utility.trace('Updated g_ee_value10 :' || g_ee_value10);
1942: WHEN 11 THEN g_ee_value11 := l_display_value;
1943: hr_utility.trace('Updated g_ee_value11 :' || g_ee_value11);
1944: WHEN 12 THEN g_ee_value12 := l_display_value;
1945: hr_utility.trace('Updated g_ee_value12 :' || g_ee_value12);
1946: WHEN 13 THEN g_ee_value13 := l_display_value;
1947: hr_utility.trace('Updated g_ee_value13 :' || g_ee_value13);

Line 1945: hr_utility.trace('Updated g_ee_value12 :' || g_ee_value12);

1941: hr_utility.trace('Updated g_ee_value10 :' || g_ee_value10);
1942: WHEN 11 THEN g_ee_value11 := l_display_value;
1943: hr_utility.trace('Updated g_ee_value11 :' || g_ee_value11);
1944: WHEN 12 THEN g_ee_value12 := l_display_value;
1945: hr_utility.trace('Updated g_ee_value12 :' || g_ee_value12);
1946: WHEN 13 THEN g_ee_value13 := l_display_value;
1947: hr_utility.trace('Updated g_ee_value13 :' || g_ee_value13);
1948: WHEN 14 THEN g_ee_value14 := l_display_value;
1949: hr_utility.trace('Updated g_ee_value14 :' || g_ee_value14);

Line 1947: hr_utility.trace('Updated g_ee_value13 :' || g_ee_value13);

1943: hr_utility.trace('Updated g_ee_value11 :' || g_ee_value11);
1944: WHEN 12 THEN g_ee_value12 := l_display_value;
1945: hr_utility.trace('Updated g_ee_value12 :' || g_ee_value12);
1946: WHEN 13 THEN g_ee_value13 := l_display_value;
1947: hr_utility.trace('Updated g_ee_value13 :' || g_ee_value13);
1948: WHEN 14 THEN g_ee_value14 := l_display_value;
1949: hr_utility.trace('Updated g_ee_value14 :' || g_ee_value14);
1950: WHEN 15 THEN g_ee_value15 := l_display_value;
1951: hr_utility.trace('Updated g_ee_value15 :' || g_ee_value15);

Line 1949: hr_utility.trace('Updated g_ee_value14 :' || g_ee_value14);

1945: hr_utility.trace('Updated g_ee_value12 :' || g_ee_value12);
1946: WHEN 13 THEN g_ee_value13 := l_display_value;
1947: hr_utility.trace('Updated g_ee_value13 :' || g_ee_value13);
1948: WHEN 14 THEN g_ee_value14 := l_display_value;
1949: hr_utility.trace('Updated g_ee_value14 :' || g_ee_value14);
1950: WHEN 15 THEN g_ee_value15 := l_display_value;
1951: hr_utility.trace('Updated g_ee_value15 :' || g_ee_value15);
1952: END CASE;
1953:

Line 1951: hr_utility.trace('Updated g_ee_value15 :' || g_ee_value15);

1947: hr_utility.trace('Updated g_ee_value13 :' || g_ee_value13);
1948: WHEN 14 THEN g_ee_value14 := l_display_value;
1949: hr_utility.trace('Updated g_ee_value14 :' || g_ee_value14);
1950: WHEN 15 THEN g_ee_value15 := l_display_value;
1951: hr_utility.trace('Updated g_ee_value15 :' || g_ee_value15);
1952: END CASE;
1953:
1954: END IF;
1955:

Line 1969: hr_utility.trace(' In Exception l_value_set_id is not null and-> ' || l_display_value);

1965:
1966: exception
1967:
1968: when others then
1969: hr_utility.trace(' In Exception l_value_set_id is not null and-> ' || l_display_value);
1970: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1971: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1972: hr_utility.raise_error;
1973:

Line 1970: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

1966: exception
1967:
1968: when others then
1969: hr_utility.trace(' In Exception l_value_set_id is not null and-> ' || l_display_value);
1970: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1971: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1972: hr_utility.raise_error;
1973:
1974: end;

Line 1971: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));

1967:
1968: when others then
1969: hr_utility.trace(' In Exception l_value_set_id is not null and-> ' || l_display_value);
1970: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1971: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1972: hr_utility.raise_error;
1973:
1974: end;
1975:

Line 1972: hr_utility.raise_error;

1968: when others then
1969: hr_utility.trace(' In Exception l_value_set_id is not null and-> ' || l_display_value);
1970: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
1971: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
1972: hr_utility.raise_error;
1973:
1974: end;
1975:
1976: --

Line 2003: hr_utility.trace(' In Exception hr_chkfmt.changeformat(-> ' || l_display_value);

1999:
2000: exception
2001:
2002: when others then
2003: hr_utility.trace(' In Exception hr_chkfmt.changeformat(-> ' || l_display_value);
2004: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2005: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2006: hr_utility.raise_error;
2007:

Line 2004: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

2000: exception
2001:
2002: when others then
2003: hr_utility.trace(' In Exception hr_chkfmt.changeformat(-> ' || l_display_value);
2004: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2005: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2006: hr_utility.raise_error;
2007:
2008: end;

Line 2005: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));

2001:
2002: when others then
2003: hr_utility.trace(' In Exception hr_chkfmt.changeformat(-> ' || l_display_value);
2004: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2005: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2006: hr_utility.raise_error;
2007:
2008: end;
2009:

Line 2006: hr_utility.raise_error;

2002: when others then
2003: hr_utility.trace(' In Exception hr_chkfmt.changeformat(-> ' || l_display_value);
2004: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2005: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2006: hr_utility.raise_error;
2007:
2008: end;
2009:
2010:

Line 2020: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');

2016: return l_display_value;
2017: --
2018: exception
2019: when others then
2020: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2021: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2022:
2023: hr_utility.raise_error;
2024: --

Line 2021: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));

2017: --
2018: exception
2019: when others then
2020: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2021: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2022:
2023: hr_utility.raise_error;
2024: --
2025: end convert_internal_to_display;

Line 2023: hr_utility.raise_error;

2019: when others then
2020: hr_utility.set_message('PAY','PAY_6306_INPUT_VALUE_FORMAT');
2021: hr_utility.set_message_token('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', l_uom_value ));
2022:
2023: hr_utility.raise_error;
2024: --
2025: end convert_internal_to_display;
2026:
2027: end pay_batch_balanceadj_wrapper;