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.PAY_DK_ARCHIVE dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3:
4:
5: ----------------- Globals , Record types , Tables -------------------------------------------------
6:
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: /*Bug fix 6193177*/
10: TYPE element_rec IS RECORD (
11: classification_name VARCHAR2(60)

Line 72: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

68: BEGIN
69: -- fnd_file.put_line(fnd_file.log,'Entering Function GET_PARAMETER');
70: --
71: IF g_debug THEN
72: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
73: END IF;
74: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
75: --
76:

Line 98: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

94: --
95: RETURN l_parameter;
96:
97: IF g_debug THEN
98: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
99: END IF;
100: -- fnd_file.put_line(fnd_file.log,'Leaving Function GET_PARAMETER');
101: END;
102:

Line 141: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

137: ,p_business_group_id;
138: CLOSE csr_parameter_info;
139: --
140: IF g_debug THEN
141: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
142: END IF;
143: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure GET_ALL_PARAMETERS');
144:
145: END GET_ALL_PARAMETERS;

Line 267: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);

263:
264: BEGIN
265: -- fnd_file.put_line(fnd_file.log,'Entering Procedure RANGE_CODE');
266: IF g_debug THEN
267: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
268: END IF;
269:
270: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
271: ,l_business_group_id

Line 424: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

420: AND ppa.business_group_id = ppf.business_group_id
421: ORDER BY ppf.person_id';
422:
423: IF g_debug THEN
424: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
425: END IF;
426:
427: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure RANGE_CODE');
428:

Line 535: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

531: BEGIN
532:
533: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ASSIGNMENT_ACTION_CODE');
534: IF g_debug THEN
535: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
536: END IF;
537:
538: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
539: ,l_business_group_id

Line 585: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

581:
582: END LOOP;
583:
584: IF g_debug THEN
585: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
586: END IF;
587: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ASSIGNMENT_ACTION_CODE');
588:
589: END ASSIGNMENT_ACTION_CODE;

Line 668: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

664:
665: -- fnd_file.put_line(fnd_file.log,'Entering Procedure INITIALIZATION_CODE');
666:
667: IF g_debug THEN
668: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
669: END IF;
670:
671: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
672:

Line 724: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

720: p_date_earned => NULL,
721: p_archive_flag => 'N');
722:
723: IF g_debug THEN
724: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
725: END IF;
726: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');
727:
728:

Line 734: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);

730: g_err_num := SQLCODE;
731: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');
732:
733: IF g_debug THEN
734: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
735: END IF;
736:
737: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');
738:

Line 755: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);

751:
752: BEGIN
753:
754: IF g_debug THEN
755: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);
756: END IF;
757:
758: g_index := g_index + 1;
759: /* Initialize global tables that hold Additional Element details */

Line 769: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);

765: g_element_table(g_index).uom := p_uom;
766: g_element_table(g_index).archive_flag := p_archive_flag;
767:
768: IF g_debug THEN
769: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);
770: END IF;
771:
772: END SETUP_ELEMENT_DEFINITIONS;
773:

Line 783: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);

779: IS
780: BEGIN
781:
782: IF g_debug THEN
783: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);
784: END IF;
785:
786: g_index_bal := g_index_bal + 1;
787: /* Initialize global tables that hold Other Balances details */

Line 795: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);

791:
792: --fnd_file.put_line(fnd_file.log,'SETUP_BALANCE_DEFINITIONS ' ||p_balance_name);
793:
794: IF g_debug THEN
795: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);
796: END IF;
797:
798: END SETUP_BALANCE_DEFINITIONS;
799:

Line 818: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);

814:
815: BEGIN
816:
817: IF g_debug THEN
818: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
819: END IF;
820:
821: OPEN csr_get_territory_name(p_territory_code);
822: FETCH csr_get_territory_name into l_country;

Line 828: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);

824:
825: RETURN l_country;
826:
827: IF g_debug THEN
828: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);
829: END IF;
830:
831: END GET_COUNTRY_NAME;
832:

Line 1090: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);

1086:
1087: BEGIN
1088:
1089: IF g_debug THEN
1090: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
1091: END IF;
1092:
1093: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
1094:

Line 1393: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);

1389:
1390:
1391: --
1392: IF g_debug THEN
1393: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);
1394: END IF;
1395: --
1396:
1397: EXCEPTION WHEN OTHERS THEN

Line 1402: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);

1398: g_err_num := SQLCODE;
1399: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1400:
1401: IF g_debug THEN
1402: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1403: END IF;
1404:
1405: END ARCHIVE_EMPLOYEE_DETAILS;
1406:

Line 1488: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);

1484: BEGIN
1485:
1486:
1487: IF g_debug THEN
1488: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);
1489: END IF;
1490:
1491: ------------------------
1492: /* EARNINGS ELEMENT */

Line 1497: hr_utility.trace('p_payroll_action_id***************** '||p_payroll_action_id);

1493:
1494: FOR rec_earnings IN csr_ear_element_info LOOP
1495:
1496: BEGIN
1497: hr_utility.trace('p_payroll_action_id***************** '||p_payroll_action_id);
1498: -- check if the Element definition has already been archived
1499: SELECT 1 INTO l_flag
1500: FROM pay_action_information
1501: WHERE action_context_id = p_payroll_action_id

Line 1511: hr_utility.trace(' rec_earnings.element_type_id ******** '||rec_earnings.element_type_id);

1507:
1508:
1509: EXCEPTION WHEN NO_DATA_FOUND THEN
1510: -- archive the element definition as it has not been archived
1511: hr_utility.trace(' rec_earnings.element_type_id ******** '||rec_earnings.element_type_id);
1512:
1513: pay_action_information_api.create_action_information (
1514: p_action_information_id => l_action_info_id
1515: ,p_action_context_id => p_payroll_action_id

Line 1574: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);

1570: END;
1571: END LOOP;
1572:
1573: IF g_debug THEN
1574: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);
1575: END IF;
1576:
1577: EXCEPTION WHEN OTHERS THEN
1578: g_err_num := SQLCODE;

Line 1582: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);

1578: g_err_num := SQLCODE;
1579: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1580:
1581: IF g_debug THEN
1582: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1583: END IF;
1584:
1585: END ARCHIVE_ELEMENT_INFO;
1586:

Line 1612: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);

1608:
1609: BEGIN
1610:
1611: IF g_debug THEN
1612: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
1613: END IF;
1614:
1615: OPEN csr_def_bal_id(p_user_name);
1616: FETCH csr_def_bal_id INTO l_defined_balance_id;

Line 1621: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);

1617: CLOSE csr_def_bal_id;
1618: RETURN l_defined_balance_id;
1619:
1620: IF g_debug THEN
1621: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
1622: END IF;
1623:
1624: END GET_DEFINED_BALANCE_ID;
1625: --------------------------------------------------------------------------------------------------

Line 1715: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);

1711:
1712: BEGIN
1713:
1714: IF g_debug THEN
1715: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);
1716: END IF;
1717:
1718: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 1');*/
1719:

Line 1846: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);

1842: END LOOP;
1843: CLOSE csr_chk;
1844:
1845: IF g_debug THEN
1846: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);
1847: END IF;
1848:
1849: EXCEPTION WHEN OTHERS THEN
1850: g_err_num := SQLCODE;

Line 1855: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);

1851:
1852: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1853:
1854: IF g_debug THEN
1855: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1856: END IF;
1857:
1858: END ARCHIVE_PAYMENT_INFO;
1859: ----------------------------------------- PROCEDURE ARCHIVE_ACCRUAL_PLAN ---------------------------------------------------------

Line 1926: hr_utility.set_location(' Entering Procedure ARCHIVE_ACCRUAL_PLAN',290);

1922: --
1923: BEGIN
1924: --
1925: IF g_debug THEN
1926: hr_utility.set_location(' Entering Procedure ARCHIVE_ACCRUAL_PLAN',290);
1927: END IF;
1928: OPEN csr_leave_balance;
1929: FETCH csr_leave_balance INTO
1930: l_accrual_plan_name

Line 1988: hr_utility.set_location(' Leaving Procedure ARCHIVE_ACCRUAL_PLAN',300);

1984: END IF;
1985: --
1986: CLOSE csr_leave_balance;
1987: IF g_debug THEN
1988: hr_utility.set_location(' Leaving Procedure ARCHIVE_ACCRUAL_PLAN',300);
1989: END IF;
1990: --
1991: EXCEPTION
1992: WHEN OTHERS THEN

Line 2002: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);

1998: --
1999: g_err_num := SQLCODE;
2000: --fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ACCRUAL_PLAN');
2001: IF g_debug THEN
2002: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);
2003: END IF;
2004: RAISE;
2005: END ARCHIVE_ACCRUAL_PLAN;*/
2006:

Line 2214: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);

2210:
2211: BEGIN
2212:
2213: IF g_debug THEN
2214: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);
2215: END IF;
2216: /*
2217: IF p_archive_flag = 'N' THEN
2218: ---------------------------------------------------

Line 2294: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);

2290: g_err_num := SQLCODE;
2291: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
2292:
2293: /* IF g_debug THEN
2294: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
2295: END IF;
2296: END;
2297: END LOOP;
2298:

Line 2553: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);

2549: EXCEPTION WHEN OTHERS THEN
2550: g_err_num := SQLCODE;
2551: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
2552: IF g_debug THEN
2553: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
2554: END IF;
2555: END;
2556: END LOOP;
2557: END IF;

Line 2560: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);

2556: END LOOP;
2557: END IF;
2558:
2559: IF g_debug THEN
2560: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);
2561: END IF;
2562:
2563: END ARCHIVE_ADD_ELEMENT;
2564:

Line 2619: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);

2615:
2616: BEGIN
2617:
2618: IF g_debug THEN
2619: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
2620: END IF;
2621:
2622: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 0');
2623: /*fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');*/

Line 2815: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);

2811: g_err_num := SQLCODE;
2812: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);
2813:
2814: IF g_debug THEN
2815: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
2816: END IF;
2817:
2818: END ARCHIVE_OTH_BALANCE;
2819:

Line 2906: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);

2902:
2903: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_CODE');
2904:
2905: IF g_debug THEN
2906: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
2907: END IF;
2908:
2909: OPEN csr_archive_payact(p_assignment_action_id);
2910: FETCH csr_archive_payact INTO l_archive_payact_id;

Line 3066: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);

3062:
3063: END LOOP;
3064:
3065: IF g_debug THEN
3066: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3067: END IF;
3068:
3069: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');
3070:

Line 3936: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);

3932:
3933: BEGIN
3934:
3935: IF g_debug THEN
3936: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);
3937: END IF;
3938: /*********************************************************************************************/
3939: /**********************************************Old Code - Starts******************************/
3940: /********************************************************************************************

Line 4000: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);

3996: g_err_num := SQLCODE;
3997: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');
3998:
3999: IF g_debug THEN
4000: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
4001: END IF;
4002: END;
4003: END LOOP;
4004:

Line 4363: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);

4359: EXCEPTION WHEN OTHERS THEN
4360: g_err_num := SQLCODE;
4361: fnd_file.put_line(fnd_file.log,'ORA_ERR: Earnings' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');
4362: IF g_debug THEN
4363: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
4364: END IF;
4365:
4366:
4367: END;

Line 4820: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);

4816: g_err_num := SQLCODE;
4817: fnd_file.put_line(fnd_file.log,'ORA_ERR: Deductions' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');
4818:
4819: IF g_debug THEN
4820: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
4821: END IF;
4822: END;
4823: END LOOP;
4824:

Line 4827: hr_utility.set_location(' Leaving Procedure ARCHIVE_MAIN_ELEMENTS',340);

4823: END LOOP;
4824:
4825:
4826: IF g_debug THEN
4827: hr_utility.set_location(' Leaving Procedure ARCHIVE_MAIN_ELEMENTS',340);
4828: END IF;
4829:
4830: END ARCHIVE_MAIN_ELEMENTS;
4831: