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 HXT_PA_USER_EXITS

Line 1: PACKAGE BODY HXT_PA_USER_EXITS AS

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:

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 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 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 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 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 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 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 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 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 557: o_location := 'hxt_pa_user_exits.p_a_interface '||l_sub_loc;

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
559: FND_MESSAGE.SET_TOKEN('ELEM_ID',to_char(i_element_type_id)); --HXT111
560: o_error_text := FND_MESSAGE.GET; --HXT111
561: FND_MESSAGE.CLEAR; --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;

Line 569: HXT_UTIL.DEBUG('exception in hxt_pa_user_exits.p_a_interface:'||l_sub_loc||' '||SQLERRM); --HXT115

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;
572: o_system_text := SQLERRM;
573: RETURN 1;

Line 570: o_location := 'hxt_pa_user_exits.p_a_interface '||l_sub_loc;

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;
572: o_system_text := SQLERRM;
573: RETURN 1;
574:

Line 579: END HXT_PA_USER_EXITS;

575: END p_a_interface;
576:
577: --
578:
579: END HXT_PA_USER_EXITS;