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.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 262: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);

258:
259: BEGIN
260: -- fnd_file.put_line(fnd_file.log,'Entering Procedure RANGE_CODE');
261: IF g_debug THEN
262: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
263: END IF;
264:
265: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
266: ,l_business_group_id

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

413: AND ppa.business_group_id = ppf.business_group_id
414: ORDER BY ppf.person_id';
415:
416: IF g_debug THEN
417: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
418: END IF;
419:
420: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure RANGE_CODE');
421:

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

524: BEGIN
525:
526: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ASSIGNMENT_ACTION_CODE');
527: IF g_debug THEN
528: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
529: END IF;
530:
531: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
532: ,l_business_group_id

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

574:
575: END LOOP;
576:
577: IF g_debug THEN
578: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
579: END IF;
580: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ASSIGNMENT_ACTION_CODE');
581:
582: END ASSIGNMENT_ACTION_CODE;

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

657:
658: -- fnd_file.put_line(fnd_file.log,'Entering Procedure INITIALIZATION_CODE');
659:
660: IF g_debug THEN
661: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
662: END IF;
663:
664: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
665:

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

711: p_date_earned => NULL,
712: p_archive_flag => 'N');
713:
714: IF g_debug THEN
715: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
716: END IF;
717: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');
718:
719:

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

721: g_err_num := SQLCODE;
722: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');
723:
724: IF g_debug THEN
725: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
726: END IF;
727:
728: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');
729:

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

742:
743: BEGIN
744:
745: IF g_debug THEN
746: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);
747: END IF;
748:
749: g_index := g_index + 1;
750: /* Initialize global tables that hold Additional Element details */

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

756: g_element_table(g_index).uom := p_uom;
757: g_element_table(g_index).archive_flag := p_archive_flag;
758:
759: IF g_debug THEN
760: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);
761: END IF;
762:
763: END SETUP_ELEMENT_DEFINITIONS;
764:

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

770: IS
771: BEGIN
772:
773: IF g_debug THEN
774: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);
775: END IF;
776:
777: g_index_bal := g_index_bal + 1;
778: /* Initialize global tables that hold Other Balances details */

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

782:
783: --fnd_file.put_line(fnd_file.log,'SETUP_BALANCE_DEFINITIONS ' ||p_balance_name);
784:
785: IF g_debug THEN
786: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);
787: END IF;
788:
789: END SETUP_BALANCE_DEFINITIONS;
790:

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

805:
806: BEGIN
807:
808: IF g_debug THEN
809: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
810: END IF;
811:
812: OPEN csr_get_territory_name(p_territory_code);
813: FETCH csr_get_territory_name into l_country;

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

815:
816: RETURN l_country;
817:
818: IF g_debug THEN
819: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);
820: END IF;
821:
822: END GET_COUNTRY_NAME;
823:

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

1077:
1078: BEGIN
1079:
1080: IF g_debug THEN
1081: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
1082: END IF;
1083:
1084: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
1085:

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

1374: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
1375:
1376: --
1377: IF g_debug THEN
1378: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);
1379: END IF;
1380: --
1381:
1382: EXCEPTION WHEN OTHERS THEN

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

1383: g_err_num := SQLCODE;
1384: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1385:
1386: IF g_debug THEN
1387: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1388: END IF;
1389:
1390: END ARCHIVE_EMPLOYEE_DETAILS;
1391:

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

1456: BEGIN
1457:
1458:
1459: IF g_debug THEN
1460: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);
1461: END IF;
1462:
1463: ------------------------
1464: /* EARNINGS ELEMENT */

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

1465:
1466: FOR rec_earnings IN csr_ear_element_info LOOP
1467:
1468: BEGIN
1469: hr_utility.trace('p_payroll_action_id***************** '||p_payroll_action_id);
1470: -- check if the Element definition has already been archived
1471: SELECT 1 INTO l_flag
1472: FROM pay_action_information
1473: WHERE action_context_id = p_payroll_action_id

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

1479:
1480:
1481: EXCEPTION WHEN NO_DATA_FOUND THEN
1482: -- archive the element definition as it has not been archived
1483: hr_utility.trace(' rec_earnings.element_type_id ******** '||rec_earnings.element_type_id);
1484:
1485: pay_action_information_api.create_action_information (
1486: p_action_information_id => l_action_info_id
1487: ,p_action_context_id => p_payroll_action_id

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

1542: END;
1543: END LOOP;
1544:
1545: IF g_debug THEN
1546: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);
1547: END IF;
1548:
1549: EXCEPTION WHEN OTHERS THEN
1550: g_err_num := SQLCODE;

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

1550: g_err_num := SQLCODE;
1551: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1552:
1553: IF g_debug THEN
1554: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1555: END IF;
1556:
1557: END ARCHIVE_ELEMENT_INFO;
1558:

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

1580:
1581: BEGIN
1582:
1583: IF g_debug THEN
1584: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
1585: END IF;
1586:
1587: OPEN csr_def_bal_id(p_user_name);
1588: FETCH csr_def_bal_id INTO l_defined_balance_id;

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

1589: CLOSE csr_def_bal_id;
1590: RETURN l_defined_balance_id;
1591:
1592: IF g_debug THEN
1593: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
1594: END IF;
1595:
1596: END GET_DEFINED_BALANCE_ID;
1597: --------------------------------------------------------------------------------------------------

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

1683:
1684: BEGIN
1685:
1686: IF g_debug THEN
1687: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);
1688: END IF;
1689:
1690: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 1');*/
1691:

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

1814: END LOOP;
1815: CLOSE csr_chk;
1816:
1817: IF g_debug THEN
1818: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);
1819: END IF;
1820:
1821: EXCEPTION WHEN OTHERS THEN
1822: g_err_num := SQLCODE;

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

1823:
1824: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1825:
1826: IF g_debug THEN
1827: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1828: END IF;
1829:
1830: END ARCHIVE_PAYMENT_INFO;
1831: ----------------------------------------- PROCEDURE ARCHIVE_ACCRUAL_PLAN ---------------------------------------------------------

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

1894: --
1895: BEGIN
1896: --
1897: IF g_debug THEN
1898: hr_utility.set_location(' Entering Procedure ARCHIVE_ACCRUAL_PLAN',290);
1899: END IF;
1900: OPEN csr_leave_balance;
1901: FETCH csr_leave_balance INTO
1902: l_accrual_plan_name

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

1956: END IF;
1957: --
1958: CLOSE csr_leave_balance;
1959: IF g_debug THEN
1960: hr_utility.set_location(' Leaving Procedure ARCHIVE_ACCRUAL_PLAN',300);
1961: END IF;
1962: --
1963: EXCEPTION
1964: WHEN OTHERS THEN

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

1970: --
1971: g_err_num := SQLCODE;
1972: --fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ACCRUAL_PLAN');
1973: IF g_debug THEN
1974: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);
1975: END IF;
1976: RAISE;
1977: END ARCHIVE_ACCRUAL_PLAN;*/
1978:

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

2043:
2044: BEGIN
2045:
2046: IF g_debug THEN
2047: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);
2048: END IF;
2049:
2050: IF p_archive_flag = 'N' THEN
2051: ---------------------------------------------------

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

2123: g_err_num := SQLCODE;
2124: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
2125:
2126: IF g_debug THEN
2127: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
2128: END IF;
2129: END;
2130: END LOOP;
2131:

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

2131:
2132: END IF;
2133:
2134: IF g_debug THEN
2135: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);
2136: END IF;
2137:
2138: END ARCHIVE_ADD_ELEMENT;
2139:

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

2190:
2191: BEGIN
2192:
2193: IF g_debug THEN
2194: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
2195: END IF;
2196:
2197: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 0');
2198: /*fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');*/

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

2369: g_err_num := SQLCODE;
2370: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);
2371:
2372: IF g_debug THEN
2373: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
2374: END IF;
2375:
2376: END ARCHIVE_OTH_BALANCE;
2377:

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

2460:
2461: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_CODE');
2462:
2463: IF g_debug THEN
2464: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
2465: END IF;
2466:
2467: OPEN csr_archive_payact(p_assignment_action_id);
2468: FETCH csr_archive_payact INTO l_archive_payact_id;

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

2620:
2621: END LOOP;
2622:
2623: IF g_debug THEN
2624: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2625: END IF;
2626:
2627: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');
2628:

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

3311:
3312: BEGIN
3313:
3314: IF g_debug THEN
3315: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);
3316: END IF;
3317:
3318: -- Archiving Earnings Elements
3319:

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

3367: g_err_num := SQLCODE;
3368: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');*/
3369:
3370: IF g_debug THEN
3371: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
3372: END IF;
3373: END;
3374: END LOOP;
3375:

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

3465: g_err_num := SQLCODE;
3466: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');*/
3467:
3468: IF g_debug THEN
3469: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
3470: END IF;
3471: END;
3472: END LOOP;
3473:

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

3472: END LOOP;
3473:
3474:
3475: IF g_debug THEN
3476: hr_utility.set_location(' Leaving Procedure ARCHIVE_MAIN_ELEMENTS',340);
3477: END IF;
3478:
3479: END ARCHIVE_MAIN_ELEMENTS;
3480: