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

APPS.HXT_PA_USER_EXITS dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXT_PA_USER_EXITS AS
2: /* $Header: hxtpainf.pkb 120.3 2006/10/13 08:58:45 nissharm noship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4:
5:
6: /*******************************************************************************
7: FUNCTION p_a_interface()

Line 200: g_debug :=hr_utility.debug_enabled;

196: l_denom_currency_code hr_organization_information.org_information10%TYPE;
197: -- End Bug 2177304
198:
199: BEGIN
200: g_debug :=hr_utility.debug_enabled;
201:
202: -- For bug: 5559930
203: BEGIN
204: SELECT for_person_id

Line 213: hr_utility.set_location('Exception in HXT_PA_USER_EXITS.P_A_INTERFACE', 5);

209: WHERE det.id = i_time_detail_id
210: );
211: EXCEPTION
212: WHEN OTHERS THEN
213: hr_utility.set_location('Exception in HXT_PA_USER_EXITS.P_A_INTERFACE', 5);
214: END;
215:
216: -- ONLY CALL THIS FOR RELEASE 12
217:

Line 223: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',10);

219:
220: l_sub_loc := 'Step 0';
221:
222: if g_debug then
223: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',10);
224: end if;
225:
226: --begin SIR94
227: IF i_retro_transaction = TRUE THEN

Line 229: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',20);

225:
226: --begin SIR94
227: IF i_retro_transaction = TRUE THEN
228: if g_debug then
229: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',20);
230: end if;
231: l_batch_name := 'ADJUSTMENT'; -- no more than 10 characters!
232: ELSE
233: if g_debug then

Line 234: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',30);

230: end if;
231: l_batch_name := 'ADJUSTMENT'; -- no more than 10 characters!
232: ELSE
233: if g_debug then
234: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',30);
235: end if;
236: l_batch_name := 'INITIAL'; -- no more than 10 characters!
237: END IF;
238:

Line 247: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',40);

243: l_sub_loc := 'Step 1';
244:
245: -- SIR151 l_expenditure_ending_date := i_period_end;
246: if g_debug then
247: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',40);
248: end if;
249: l_expenditure_ending_date := pa_misc.get_week_ending_date(i_date_worked);
250: -- SIR151
251: if g_debug then

Line 252: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);

248: end if;
249: l_expenditure_ending_date := pa_misc.get_week_ending_date(i_date_worked);
250: -- SIR151
251: if g_debug then
252: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);
253: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
254: end if;
255: l_employee_number := i_employee_number;
256: l_organization_name := i_organization_name;

Line 253: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);

249: l_expenditure_ending_date := pa_misc.get_week_ending_date(i_date_worked);
250: -- SIR151
251: if g_debug then
252: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);
253: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
254: end if;
255: l_employee_number := i_employee_number;
256: l_organization_name := i_organization_name;
257: l_expenditure_item_date := i_date_worked;

Line 260: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);

256: l_organization_name := i_organization_name;
257: l_expenditure_item_date := i_date_worked;
258:
259: if g_debug then
260: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);
261: hr_utility.trace('l_employee_number :'||l_employee_number);
262: hr_utility.trace('l_organization_name :'||l_organization_name);
263: hr_utility.trace('l_expenditure_item_date:'||l_expenditure_item_date);
264: end if;

Line 261: hr_utility.trace('l_employee_number :'||l_employee_number);

257: l_expenditure_item_date := i_date_worked;
258:
259: if g_debug then
260: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);
261: hr_utility.trace('l_employee_number :'||l_employee_number);
262: hr_utility.trace('l_organization_name :'||l_organization_name);
263: hr_utility.trace('l_expenditure_item_date:'||l_expenditure_item_date);
264: end if;
265:

Line 262: hr_utility.trace('l_organization_name :'||l_organization_name);

258:
259: if g_debug then
260: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);
261: hr_utility.trace('l_employee_number :'||l_employee_number);
262: hr_utility.trace('l_organization_name :'||l_organization_name);
263: hr_utility.trace('l_expenditure_item_date:'||l_expenditure_item_date);
264: end if;
265:
266: l_sub_loc := 'Step 2';

Line 263: hr_utility.trace('l_expenditure_item_date:'||l_expenditure_item_date);

259: if g_debug then
260: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',50);
261: hr_utility.trace('l_employee_number :'||l_employee_number);
262: hr_utility.trace('l_organization_name :'||l_organization_name);
263: hr_utility.trace('l_expenditure_item_date:'||l_expenditure_item_date);
264: end if;
265:
266: l_sub_loc := 'Step 2';
267:

Line 269: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',60);

265:
266: l_sub_loc := 'Step 2';
267:
268: if g_debug then
269: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',60);
270: end if;
271: l_project_number := i_segment1; -- SIR80
272: l_task_number := i_task_number; -- SIR80
273: if g_debug then

Line 274: hr_utility.trace('l_project_number :'||l_project_number);

270: end if;
271: l_project_number := i_segment1; -- SIR80
272: l_task_number := i_task_number; -- SIR80
273: if g_debug then
274: hr_utility.trace('l_project_number :'||l_project_number);
275: hr_utility.trace('l_task_number :'||l_task_number);
276: end if;
277:
278: OPEN c_denom_currency_code;

Line 275: hr_utility.trace('l_task_number :'||l_task_number);

271: l_project_number := i_segment1; -- SIR80
272: l_task_number := i_task_number; -- SIR80
273: if g_debug then
274: hr_utility.trace('l_project_number :'||l_project_number);
275: hr_utility.trace('l_task_number :'||l_task_number);
276: end if;
277:
278: OPEN c_denom_currency_code;
279: FETCH c_denom_currency_code into l_denom_currency_code;

Line 282: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',70);

278: OPEN c_denom_currency_code;
279: FETCH c_denom_currency_code into l_denom_currency_code;
280:
281: if g_debug then
282: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',70);
283: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
284: end if;
285:
286: CLOSE c_denom_currency_code;

Line 283: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);

279: FETCH c_denom_currency_code into l_denom_currency_code;
280:
281: if g_debug then
282: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',70);
283: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
284: end if;
285:
286: CLOSE c_denom_currency_code;
287:

Line 292: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',80);

288: -- SIR162 l_expenditure_type := i_employment_cat;
289: -- begin SIR162
290: OPEN exp_type;
291: if g_debug then
292: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',80);
293: end if;
294: FETCH exp_type INTO l_expenditure_type;
295: if g_debug then
296: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);

Line 296: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);

292: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',80);
293: end if;
294: FETCH exp_type INTO l_expenditure_type;
295: if g_debug then
296: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
297: end if;
298: IF exp_type%NOTFOUND OR l_expenditure_type IS NULL THEN
299: if g_debug then
300: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',90);

Line 300: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',90);

296: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
297: end if;
298: IF exp_type%NOTFOUND OR l_expenditure_type IS NULL THEN
299: if g_debug then
300: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',90);
301: end if;
302: raise exp_type_nf;
303: END IF;
304: -- end SIR162

Line 307: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',100);

303: END IF;
304: -- end SIR162
305:
306: if g_debug then
307: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',100);
308: end if;
309: l_transaction_status_code := 'P';
310:
311: l_sub_loc := 'Step 3';

Line 318: hr_utility.trace('l_orig_transaction_reference :'

314: l_orig_transaction_reference := fnd_date.date_to_chardate(i_effective_start_date)|| fnd_date.date_to_chardate(i_effective_end_date)|| to_char(i_time_detail_id);-- FORMS60
315: -- end SIR77
316:
317: if g_debug then
318: hr_utility.trace('l_orig_transaction_reference :'
319: ||l_orig_transaction_reference);
320: end if;
321: l_sub_loc := 'Step 4';
322: -- SIR151 l_org_id := i_organization_id;

Line 332: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',110);

328:
329: -- Process flat premium amounts separately
330: IF i_premium_amount IS NOT NULL THEN
331: if g_debug then
332: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',110);
333: end if;
334: l_sub_loc := 'Step 6a';
335: l_quantity := 1;
336: l_raw_cost := i_premium_amount;

Line 344: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',115);

340: -- All rates have already been
341: -- properly adjusted if necessary
342: ELSE
343: if g_debug then
344: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',115);
345: end if;
346: l_sub_loc := 'Step 6c';
347: l_quantity := i_hours_worked;
348: l_raw_cost := i_hours_worked * i_rate;

Line 358: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',120);

354:
355: -- Process flat premium amounts separately
356: IF i_premium_amount IS NOT NULL THEN
357: if g_debug then
358: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',120);
359: end if;
360: l_sub_loc := 'Step 7a';
361: l_quantity := 0 ; --1;
362: l_raw_cost := i_premium_amount;

Line 370: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',125);

366: -- All rates have already been
367: -- properly adjusted if necessary
368: ELSE
369: if g_debug then
370: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',125);
371: hr_utility.trace('i_hxt_earning_category:'||i_hxt_earning_category);
372: end if;
373: l_sub_loc := 'Step 7c';
374:

Line 371: hr_utility.trace('i_hxt_earning_category:'||i_hxt_earning_category);

367: -- properly adjusted if necessary
368: ELSE
369: if g_debug then
370: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',125);
371: hr_utility.trace('i_hxt_earning_category:'||i_hxt_earning_category);
372: end if;
373: l_sub_loc := 'Step 7c';
374:
375: IF i_hxt_earning_category in ('OSP','OTH','SDF') THEN

Line 377: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',126);

373: l_sub_loc := 'Step 7c';
374:
375: IF i_hxt_earning_category in ('OSP','OTH','SDF') THEN
376: if g_debug then
377: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',126);
378: end if;
379: l_quantity := 0; --i_hours_worked;
380: ELSE
381: if g_debug then

Line 382: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',127);

378: end if;
379: l_quantity := 0; --i_hours_worked;
380: ELSE
381: if g_debug then
382: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',127);
383: end if;
384: l_quantity := i_hours_worked;
385: END IF;
386:

Line 400: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',130);

396: l_unmatched_negative_txn_flag := 'Y'; --SIR94
397: l_sub_loc := 'Step 9';
398:
399: if g_debug then
400: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',130);
401: end if;
402: --Insert Project Accounting entry to the PA Interface Table
403: if g_debug then
404: hr_utility.trace('l_trans_source :'||l_trans_source);

Line 404: hr_utility.trace('l_trans_source :'||l_trans_source);

400: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',130);
401: end if;
402: --Insert Project Accounting entry to the PA Interface Table
403: if g_debug then
404: hr_utility.trace('l_trans_source :'||l_trans_source);
405: hr_utility.trace('l_batch_name :'||l_batch_name);
406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);

Line 405: hr_utility.trace('l_batch_name :'||l_batch_name);

401: end if;
402: --Insert Project Accounting entry to the PA Interface Table
403: if g_debug then
404: hr_utility.trace('l_trans_source :'||l_trans_source);
405: hr_utility.trace('l_batch_name :'||l_batch_name);
406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);

Line 406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);

402: --Insert Project Accounting entry to the PA Interface Table
403: if g_debug then
404: hr_utility.trace('l_trans_source :'||l_trans_source);
405: hr_utility.trace('l_batch_name :'||l_batch_name);
406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);

Line 407: hr_utility.trace('i_period_end :'||i_period_end);

403: if g_debug then
404: hr_utility.trace('l_trans_source :'||l_trans_source);
405: hr_utility.trace('l_batch_name :'||l_batch_name);
406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);

Line 408: hr_utility.trace('l_employee_number :'||l_employee_number);

404: hr_utility.trace('l_trans_source :'||l_trans_source);
405: hr_utility.trace('l_batch_name :'||l_batch_name);
406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);

Line 409: hr_utility.trace('l_organization_name :'||l_organization_name);

405: hr_utility.trace('l_batch_name :'||l_batch_name);
406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);

Line 410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);

406: hr_utility.trace('l_expenditure_ending_date :'||l_expenditure_ending_date);
407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);

Line 411: hr_utility.trace('l_project_number :'||l_project_number);

407: hr_utility.trace('i_period_end :'||i_period_end);
408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'

Line 412: hr_utility.trace('l_task_number :'||l_task_number);

408: hr_utility.trace('l_employee_number :'||l_employee_number);
409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);

Line 413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);

409: hr_utility.trace('l_organization_name :'||l_organization_name);
410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);

Line 414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);

410: hr_utility.trace('l_expenditure_item_date :'||l_expenditure_item_date);
411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);
418: hr_utility.trace('l_raw_cost :'||l_raw_cost);

Line 415: hr_utility.trace('l_non_labor_resource_org_name :'

411: hr_utility.trace('l_project_number :'||l_project_number);
412: hr_utility.trace('l_task_number :'||l_task_number);
413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);
418: hr_utility.trace('l_raw_cost :'||l_raw_cost);
419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);

Line 417: hr_utility.trace('l_quantity :'||l_quantity);

413: hr_utility.trace('l_expenditure_type :'||l_expenditure_type);
414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);
418: hr_utility.trace('l_raw_cost :'||l_raw_cost);
419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);
420: hr_utility.trace('l_transaction_status_code :'
421: ||l_transaction_status_code);

Line 418: hr_utility.trace('l_raw_cost :'||l_raw_cost);

414: hr_utility.trace('l_non_labor_resource :'||l_non_labor_resource);
415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);
418: hr_utility.trace('l_raw_cost :'||l_raw_cost);
419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);
420: hr_utility.trace('l_transaction_status_code :'
421: ||l_transaction_status_code);
422: hr_utility.trace('l_transaction_rejection_code :'

Line 419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);

415: hr_utility.trace('l_non_labor_resource_org_name :'
416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);
418: hr_utility.trace('l_raw_cost :'||l_raw_cost);
419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);
420: hr_utility.trace('l_transaction_status_code :'
421: ||l_transaction_status_code);
422: hr_utility.trace('l_transaction_rejection_code :'
423: ||l_transaction_rejection_code);

Line 420: hr_utility.trace('l_transaction_status_code :'

416: ||l_non_labor_resource_org_name);
417: hr_utility.trace('l_quantity :'||l_quantity);
418: hr_utility.trace('l_raw_cost :'||l_raw_cost);
419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);
420: hr_utility.trace('l_transaction_status_code :'
421: ||l_transaction_status_code);
422: hr_utility.trace('l_transaction_rejection_code :'
423: ||l_transaction_rejection_code);
424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);

Line 422: hr_utility.trace('l_transaction_rejection_code :'

418: hr_utility.trace('l_raw_cost :'||l_raw_cost);
419: hr_utility.trace('l_expenditure_comment :'||l_expenditure_comment);
420: hr_utility.trace('l_transaction_status_code :'
421: ||l_transaction_status_code);
422: hr_utility.trace('l_transaction_rejection_code :'
423: ||l_transaction_rejection_code);
424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);
425: hr_utility.trace('l_orig_transaction_reference :'
426: ||l_orig_transaction_reference);

Line 424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);

420: hr_utility.trace('l_transaction_status_code :'
421: ||l_transaction_status_code);
422: hr_utility.trace('l_transaction_rejection_code :'
423: ||l_transaction_rejection_code);
424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);
425: hr_utility.trace('l_orig_transaction_reference :'
426: ||l_orig_transaction_reference);
427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);

Line 425: hr_utility.trace('l_orig_transaction_reference :'

421: ||l_transaction_status_code);
422: hr_utility.trace('l_transaction_rejection_code :'
423: ||l_transaction_rejection_code);
424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);
425: hr_utility.trace('l_orig_transaction_reference :'
426: ||l_orig_transaction_reference);
427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);

Line 427: hr_utility.trace('l_attribute_category :'||l_attribute_category);

423: ||l_transaction_rejection_code);
424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);
425: hr_utility.trace('l_orig_transaction_reference :'
426: ||l_orig_transaction_reference);
427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);

Line 428: hr_utility.trace('l_attribute1 :'||l_attribute1);

424: hr_utility.trace('l_expenditure_id :'||l_expenditure_id);
425: hr_utility.trace('l_orig_transaction_reference :'
426: ||l_orig_transaction_reference);
427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);

Line 429: hr_utility.trace('l_attribute2 :'||l_attribute2);

425: hr_utility.trace('l_orig_transaction_reference :'
426: ||l_orig_transaction_reference);
427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);

Line 430: hr_utility.trace('l_attribute3 :'||l_attribute3);

426: ||l_orig_transaction_reference);
427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);

Line 431: hr_utility.trace('l_attribute4 :'||l_attribute4);

427: hr_utility.trace('l_attribute_category :'||l_attribute_category);
428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);

Line 432: hr_utility.trace('l_attribute5 :'||l_attribute5);

428: hr_utility.trace('l_attribute1 :'||l_attribute1);
429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);

Line 433: hr_utility.trace('l_attribute6 :'||l_attribute6);

429: hr_utility.trace('l_attribute2 :'||l_attribute2);
430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);

Line 434: hr_utility.trace('l_attribute7 :'||l_attribute7);

430: hr_utility.trace('l_attribute3 :'||l_attribute3);
431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);

Line 435: hr_utility.trace('l_attribute8 :'||l_attribute8);

431: hr_utility.trace('l_attribute4 :'||l_attribute4);
432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);

Line 436: hr_utility.trace('l_attribute9 :'||l_attribute9);

432: hr_utility.trace('l_attribute5 :'||l_attribute5);
433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);

Line 437: hr_utility.trace('l_attribute10 :'||l_attribute10);

433: hr_utility.trace('l_attribute6 :'||l_attribute6);
434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);

Line 438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);

434: hr_utility.trace('l_attribute7 :'||l_attribute7);
435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'

Line 439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);

435: hr_utility.trace('l_attribute8 :'||l_attribute8);
436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);

Line 440: hr_utility.trace('l_raw_cost :'||l_raw_cost);

436: hr_utility.trace('l_attribute9 :'||l_attribute9);
437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);

Line 441: hr_utility.trace('l_interface_id :'||l_interface_id);

437: hr_utility.trace('l_attribute10 :'||l_attribute10);
438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);

Line 442: hr_utility.trace('l_unmatched_negative_txn_flag :'

438: hr_utility.trace('l_raw_cost_rate :'||l_raw_cost_rate);
439: hr_utility.trace('l_denom_currency_code :'||l_denom_currency_code);
440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);

Line 444: hr_utility.trace('l_org_id :'||l_org_id);

440: hr_utility.trace('l_raw_cost :'||l_raw_cost);
441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);

Line 445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);

441: hr_utility.trace('l_interface_id :'||l_interface_id);
442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);

Line 446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);

442: hr_utility.trace('l_unmatched_negative_txn_flag :'
443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);
450: hr_utility.trace('l_gl_date :'||l_gl_date);

Line 447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);

443: ||l_unmatched_negative_txn_flag);
444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);
450: hr_utility.trace('l_gl_date :'||l_gl_date);
451: end if;

Line 448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);

444: hr_utility.trace('l_org_id :'||l_org_id);
445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);
450: hr_utility.trace('l_gl_date :'||l_gl_date);
451: end if;
452: INSERT INTO pa_transaction_interface_all

Line 449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);

445: hr_utility.trace('l_dr_code_combination_id :'||l_dr_code_combination_id);
446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);
450: hr_utility.trace('l_gl_date :'||l_gl_date);
451: end if;
452: INSERT INTO pa_transaction_interface_all
453: ( TRANSACTION_SOURCE

Line 450: hr_utility.trace('l_gl_date :'||l_gl_date);

446: hr_utility.trace('l_cr_code_combination_id :'||l_cr_code_combination_id);
447: hr_utility.trace('l_cdl_system_reference1 :'||l_cdl_system_reference1);
448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);
450: hr_utility.trace('l_gl_date :'||l_gl_date);
451: end if;
452: INSERT INTO pa_transaction_interface_all
453: ( TRANSACTION_SOURCE
454: ,BATCH_NAME

Line 546: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',140);

542: ,l_cdl_system_reference3
543: ,l_gl_date);
544:
545: if g_debug then
546: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',140);
547: end if;
548: HXT_UTIL.DEBUG('after insert to pa_transaction_interface.'); --HXT115
549: RETURN 0;
550:

Line 554: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',150);

550:
551: EXCEPTION
552: WHEN exp_type_nf THEN
553: if g_debug then
554: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',150);
555: end if;
556: HXT_UTIL.DEBUG('exp_type not found. element_id '||to_char(i_element_type_id)||' '||l_sub_loc||' '||SQLERRM); --HXT115
557: o_location := 'hxt_pa_user_exits.p_a_interface '||l_sub_loc;
558: FND_MESSAGE.SET_NAME('HXT','HXT_39464_EXP_TYP_NOT_FND'); --HXT111

Line 567: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',160);

563: RETURN 1;
564:
565: WHEN OTHERS THEN
566: if g_debug then
567: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',160);
568: end if;
569: HXT_UTIL.DEBUG('exception in hxt_pa_user_exits.p_a_interface:'||l_sub_loc||' '||SQLERRM); --HXT115
570: o_location := 'hxt_pa_user_exits.p_a_interface '||l_sub_loc;
571: o_error_text := NULL;