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.

[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on HR_UTILITY

Line 41: g_debug boolean := hr_utility.debug_enabled;

37: is expired, send backout transaction to PayMIX.
38:
39: Step 5. Set rows on timecard to pay_status='C' if pay_status='R'.
40: */
41: g_debug boolean := hr_utility.debug_enabled;
42:
43: PROCEDURE mark_prev_hours_rows (p_tim_id IN NUMBER);
44:
45: PROCEDURE mark_prev_amount_rows (p_tim_id IN NUMBER);

Line 274: hr_utility.set_location ('insert_pay_batch_lines', 10);

270: lv_pbl_flag VARCHAR2 (1) := 'N';
271: BEGIN
272:
273: if g_debug then
274: hr_utility.set_location ('insert_pay_batch_lines', 10);
275: end if;
276:
277: -- Initialize tables
278: FOR i IN 1 .. 15

Line 337: hr_utility.set_location ('insert_pay_batch_lines', 20);

333: hxt_value (14).lookup,
334: hxt_value (15).lookup
335: );
336: if g_debug then
337: hr_utility.set_location ('insert_pay_batch_lines', 20);
338: end if;
339: -- Place OTM data into BEE values per input values
340: hxt_util.DEBUG ('Putting OTM data into BEE values per input values'); --HXT115
341:

Line 371: hr_utility.set_location ('insert_pay_batch_lines', 30);

367: -- the further logic on the screen value for the input values.
368: --
369: lv_pbl_flag := 'N';
370: if g_debug then
371: hr_utility.set_location ('insert_pay_batch_lines', 30);
372:
373: hr_utility.TRACE (
374: 'hxt_value_name_'
375: || TO_CHAR (i)

Line 373: hr_utility.TRACE (

369: lv_pbl_flag := 'N';
370: if g_debug then
371: hr_utility.set_location ('insert_pay_batch_lines', 30);
372:
373: hr_utility.TRACE (
374: 'hxt_value_name_'
375: || TO_CHAR (i)
376: || ' :'
377: || hxt_value (i).NAME

Line 379: hr_utility.TRACE ( 'p_date_worked:'

375: || TO_CHAR (i)
376: || ' :'
377: || hxt_value (i).NAME
378: );
379: hr_utility.TRACE ( 'p_date_worked:'
380: || p_date_worked);
381: end if;
382: l_value_meaning :=
383: get_lookup_code (hxt_value (i).NAME, p_date_worked);

Line 385: hr_utility.TRACE ( 'l_value_meaning :'

381: end if;
382: l_value_meaning :=
383: get_lookup_code (hxt_value (i).NAME, p_date_worked);
384: if g_debug then
385: hr_utility.TRACE ( 'l_value_meaning :'
386: || l_value_meaning);
387: end if;
388: --if hxt_value(i).name = 'Hours' then
389: IF l_value_meaning = 'HOURS'

Line 392: hr_utility.set_location ('insert_pay_batch_lines', 40);

388: --if hxt_value(i).name = 'Hours' then
389: IF l_value_meaning = 'HOURS'
390: THEN
391: if g_debug then
392: hr_utility.set_location ('insert_pay_batch_lines', 40);
393: end if;
394: pbl_value (i) :=
395: convert_lookup (p_hours, hxt_value (i).lookup, p_date_worked);
396: if g_debug then

Line 397: hr_utility.TRACE (

393: end if;
394: pbl_value (i) :=
395: convert_lookup (p_hours, hxt_value (i).lookup, p_date_worked);
396: if g_debug then
397: hr_utility.TRACE (
398: 'pbl_value_'
399: || TO_CHAR (i)
400: || ' :'
401: || pbl_value (i)

Line 408: hr_utility.set_location ('insert_pay_batch_lines', 50);

404: --elsif hxt_value(i).name = 'Pay Value' then
405: ELSIF l_value_meaning = 'AMOUNT'
406: THEN
407: if g_debug then
408: hr_utility.set_location ('insert_pay_batch_lines', 50);
409: end if;
410: pbl_value (i) :=
411: convert_lookup (p_amount, hxt_value (i).lookup, p_date_worked);
412: if g_debug then

Line 413: hr_utility.TRACE (

409: end if;
410: pbl_value (i) :=
411: convert_lookup (p_amount, hxt_value (i).lookup, p_date_worked);
412: if g_debug then
413: hr_utility.TRACE (
414: 'pbl_value_'
415: || TO_CHAR (i)
416: || ' :'
417: || pbl_value (i)

Line 424: hr_utility.set_location ('insert_pay_batch_lines', 60);

420: --elsif hxt_value(i).name = 'Multiple' then
421: ELSIF l_value_meaning = 'RATE_MULTIPLE'
422: THEN
423: if g_debug then
424: hr_utility.set_location ('insert_pay_batch_lines', 60);
425: end if;
426: pbl_value (i) := convert_lookup (
427: p_rate_multiple,
428: hxt_value (i).lookup,

Line 433: hr_utility.TRACE (

429: p_date_worked
430: );
431:
432: if g_debug then
433: hr_utility.TRACE (
434: 'pbl_value_'
435: || TO_CHAR (i)
436: || ' :'
437: || pbl_value (i)

Line 444: hr_utility.set_location ('insert_pay_batch_lines', 70);

440:
441: ELSIF l_value_meaning = 'HOURLY_RATE'
442: THEN
443: if g_debug then
444: hr_utility.set_location ('insert_pay_batch_lines', 70);
445: end if;
446: pbl_value (i) := convert_lookup (
447: p_hourly_rate,
448: hxt_value (i).lookup,

Line 453: hr_utility.TRACE (

449: p_date_worked
450: );
451: if g_debug then
452:
453: hr_utility.TRACE (
454: 'pbl_value_'
455: || TO_CHAR (i)
456: || ' :'
457: || pbl_value (i)

Line 466: hr_utility.set_location ('insert_pay_batch_lines', 70);

462: --elsif hxt_value(i).name = 'Rate' then
463: ELSIF l_value_meaning = 'RATE'
464: THEN
465: if g_debug then
466: hr_utility.set_location ('insert_pay_batch_lines', 70);
467: end if;
468: pbl_value (i) := convert_lookup (
469: p_hourly_rate,
470: hxt_value (i).lookup,

Line 475: hr_utility.TRACE (

471: p_date_worked
472: );
473: if g_debug then
474:
475: hr_utility.TRACE (
476: 'pbl_value_'
477: || TO_CHAR (i)
478: || ' :'
479: || pbl_value (i)

Line 486: hr_utility.set_location ('insert_pay_batch_lines', 80);

482: --elsif hxt_value(i).name = 'Rate Code' then
483: ELSIF l_value_meaning = 'RATE_CODE'
484: THEN
485: if g_debug then
486: hr_utility.set_location ('insert_pay_batch_lines', 80);
487: end if;
488: pbl_value (i) := convert_lookup (
489: p_rate_code,
490: hxt_value (i).lookup,

Line 494: hr_utility.TRACE (

490: hxt_value (i).lookup,
491: p_date_worked
492: );
493: if g_debug then
494: hr_utility.TRACE (
495: 'pbl_value_'
496: || TO_CHAR (i)
497: || ' :'
498: || pbl_value (i)

Line 506: hr_utility.set_location ('insert_pay_batch_lines', 90);

502: -- BEGIN US localization
503: ELSIF hxt_value (i).NAME = 'Jurisdiction'
504: THEN
505: if g_debug then
506: hr_utility.set_location ('insert_pay_batch_lines', 90);
507: end if;
508:
509: if(p_state_name is not null or
510: p_county_name is not null or

Line 527: hr_utility.TRACE (

523: p_date_worked
524: );
525: end if;
526: if g_debug then
527: hr_utility.TRACE (
528: 'pbl_value_'
529: || TO_CHAR (i)
530: || ' :'
531: || pbl_value (i)

Line 537: hr_utility.set_location ('insert_pay_batch_lines', 100);

533: end if;
534: ELSIF hxt_value (i).NAME = 'Deduction Processing'
535: THEN
536: if g_debug then
537: hr_utility.set_location ('insert_pay_batch_lines', 100);
538: end if;
539: pbl_value (i) := convert_lookup (
540: p_tax_separately_flag,
541: hxt_value (i).lookup,

Line 545: hr_utility.TRACE (

541: hxt_value (i).lookup,
542: p_date_worked
543: );
544: if g_debug then
545: hr_utility.TRACE (
546: 'pbl_value_'
547: || TO_CHAR (i)
548: || ' :'
549: || pbl_value (i)

Line 555: hr_utility.set_location ('insert_pay_batch_lines', 110);

551: end if;
552: ELSIF hxt_value (i).NAME = 'Separate Check'
553: THEN
554: if g_debug then
555: hr_utility.set_location ('insert_pay_batch_lines', 110);
556: end if;
557: pbl_value (i) := convert_lookup (
558: p_separate_check_flag,
559: hxt_value (i).lookup,

Line 563: hr_utility.TRACE (

559: hxt_value (i).lookup,
560: p_date_worked
561: );
562: if g_debug then
563: hr_utility.TRACE (
564: 'pbl_value_'
565: || TO_CHAR (i)
566: || ' :'
567: || pbl_value (i)

Line 576: hr_utility.set_location ('insert_pay_batch_lines', 120);

572:
573: ELSIF hxt_value (i).NAME IS NOT NULL
574: THEN -- pbl_value(i) := NULL;
575: if g_debug then
576: hr_utility.set_location ('insert_pay_batch_lines', 120);
577: hr_utility.TRACE ( 'p_element_type_id :'
578: || p_element_type_id);
579: hr_utility.TRACE ( 'p_assignment_id :'
580: || p_assignment_id);

Line 577: hr_utility.TRACE ( 'p_element_type_id :'

573: ELSIF hxt_value (i).NAME IS NOT NULL
574: THEN -- pbl_value(i) := NULL;
575: if g_debug then
576: hr_utility.set_location ('insert_pay_batch_lines', 120);
577: hr_utility.TRACE ( 'p_element_type_id :'
578: || p_element_type_id);
579: hr_utility.TRACE ( 'p_assignment_id :'
580: || p_assignment_id);
581: hr_utility.TRACE ( 'p_date_worked :'

Line 579: hr_utility.TRACE ( 'p_assignment_id :'

575: if g_debug then
576: hr_utility.set_location ('insert_pay_batch_lines', 120);
577: hr_utility.TRACE ( 'p_element_type_id :'
578: || p_element_type_id);
579: hr_utility.TRACE ( 'p_assignment_id :'
580: || p_assignment_id);
581: hr_utility.TRACE ( 'p_date_worked :'
582: || p_date_worked);
583: end if;

Line 581: hr_utility.TRACE ( 'p_date_worked :'

577: hr_utility.TRACE ( 'p_element_type_id :'
578: || p_element_type_id);
579: hr_utility.TRACE ( 'p_assignment_id :'
580: || p_assignment_id);
581: hr_utility.TRACE ( 'p_date_worked :'
582: || p_date_worked);
583: end if;
584: OPEN c_date_input_value (
585: p_element_type_id,

Line 592: hr_utility.set_location ('insert_pay_batch_lines', 130);

588: );
589:
590: LOOP
591: if g_debug then
592: hr_utility.set_location ('insert_pay_batch_lines', 130);
593: end if;
594: FETCH c_date_input_value INTO l_piv_name;
595: EXIT WHEN c_date_input_value%NOTFOUND;
596: if g_debug then

Line 597: hr_utility.TRACE ( 'l_piv_name :'

593: end if;
594: FETCH c_date_input_value INTO l_piv_name;
595: EXIT WHEN c_date_input_value%NOTFOUND;
596: if g_debug then
597: hr_utility.TRACE ( 'l_piv_name :'
598: || l_piv_name);
599: hr_utility.TRACE ( 'lv_pbl_flag :'
600: || lv_pbl_flag);
601: end if;

Line 599: hr_utility.TRACE ( 'lv_pbl_flag :'

595: EXIT WHEN c_date_input_value%NOTFOUND;
596: if g_debug then
597: hr_utility.TRACE ( 'l_piv_name :'
598: || l_piv_name);
599: hr_utility.TRACE ( 'lv_pbl_flag :'
600: || lv_pbl_flag);
601: end if;
602:
603: IF l_piv_name = hxt_value (i).NAME

Line 606: hr_utility.set_location ('insert_pay_batch_lines', 140);

602:
603: IF l_piv_name = hxt_value (i).NAME
604: THEN
605: if g_debug then
606: hr_utility.set_location ('insert_pay_batch_lines', 140);
607: end if;
608: --pbl_value(i) := to_char(p_date_worked,'DD-MON-YYYY');
609: pbl_value (i) := fnd_date.date_to_canonical (p_date_worked);
610: lv_pbl_flag := 'Y';

Line 612: hr_utility.TRACE (

608: --pbl_value(i) := to_char(p_date_worked,'DD-MON-YYYY');
609: pbl_value (i) := fnd_date.date_to_canonical (p_date_worked);
610: lv_pbl_flag := 'Y';
611: if g_debug then
612: hr_utility.TRACE (
613: 'pbl_value_'
614: || TO_CHAR (i)
615: || ' :'
616: || pbl_value (i)

Line 628: hr_utility.set_location ('insert_pay_batch_lines', 150);

624:
625: IF lv_pbl_flag = 'N'
626: THEN
627: if g_debug then
628: hr_utility.set_location ('insert_pay_batch_lines', 150);
629: end if;
630: pbl_value (i) := NULL;
631: if g_debug then
632: hr_utility.TRACE (

Line 632: hr_utility.TRACE (

628: hr_utility.set_location ('insert_pay_batch_lines', 150);
629: end if;
630: pbl_value (i) := NULL;
631: if g_debug then
632: hr_utility.TRACE (
633: 'pbl_value_'
634: || TO_CHAR (i)
635: || ' :'
636: || pbl_value (i)

Line 642: hr_utility.TRACE ( 'lv_pbl_flag :'

638: end if;
639: END IF;
640:
641: if g_debug then
642: hr_utility.TRACE ( 'lv_pbl_flag :'
643: || lv_pbl_flag);
644: end if;
645: ELSE
646: if g_debug then

Line 647: hr_utility.set_location ('insert_pay_batch_lines', 160);

643: || lv_pbl_flag);
644: end if;
645: ELSE
646: if g_debug then
647: hr_utility.set_location ('insert_pay_batch_lines', 160);
648: end if;
649: pbl_value (i) := NULL;
650: if g_debug then
651: hr_utility.TRACE (

Line 651: hr_utility.TRACE (

647: hr_utility.set_location ('insert_pay_batch_lines', 160);
648: end if;
649: pbl_value (i) := NULL;
650: if g_debug then
651: hr_utility.TRACE (
652: 'pbl_value_'
653: || TO_CHAR (i)
654: || ' :'
655: || pbl_value (i)

Line 661: hr_utility.set_location ('insert_pay_batch_lines', 170);

657: end if;
658: END IF;
659:
660: if g_debug then
661: hr_utility.set_location ('insert_pay_batch_lines', 170);
662: end if;
663: hxt_util.DEBUG ( 'value_'
664: || TO_CHAR (i)
665: || ' = '