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_KW_ARCHIVE dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_KW_ARCHIVE AS
2: /* $Header: pykwparc.pkb 120.8 2012/01/19 10:27:10 rpahune ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: TYPE element_rec IS RECORD (
7: classification_name VARCHAR2(60)
8: ,element_name VARCHAR2(60)

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

60: BEGIN
61: --
62:
63: IF g_debug THEN
64: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
65: END IF;
66:
67: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
68: --

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

89: --
90: RETURN l_parameter;
91:
92: IF g_debug THEN
93: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
94: END IF;
95:
96: END;
97:

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

128: CLOSE csr_parameter_info;
129: --
130:
131: IF g_debug THEN
132: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
133: END IF;
134: END GET_ALL_PARAMETERS;
135:
136:

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

247:
248: BEGIN
249:
250: IF g_debug THEN
251: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
252: END IF;
253:
254: PAY_KW_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
255: ,l_business_group_id

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

404: AND ppa.business_group_id = ppf.business_group_id
405: ORDER BY ppf.person_id';
406:
407: IF g_debug THEN
408: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
409: END IF;
410:
411: EXCEPTION
412: WHEN OTHERS THEN

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

513:
514: BEGIN
515:
516: IF g_debug THEN
517: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
518: END IF;
519:
520: PAY_KW_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
521: ,l_business_group_id

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

573:
574:
575:
576: IF g_debug THEN
577: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
578: END IF;
579: END ASSIGNMENT_ACTION_CODE;
580:
581:

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

644:
645: BEGIN
646:
647: IF g_debug THEN
648: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
649: END IF;
650:
651: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
652:

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

706: p_date_earned => NULL,
707: p_archive_flag => 'N');
708:
709: IF g_debug THEN
710: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
711: END IF;
712:
713: EXCEPTION WHEN OTHERS THEN
714: g_err_num := SQLCODE;

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

713: EXCEPTION WHEN OTHERS THEN
714: g_err_num := SQLCODE;
715:
716: IF g_debug THEN
717: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
718: END IF;
719:
720: END INITIALIZATION_CODE;
721:

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

731:
732: BEGIN
733:
734: IF g_debug THEN
735: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);
736: END IF;
737:
738: g_index := g_index + 1;
739:

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

747: g_element_table(g_index).uom := p_uom;
748: g_element_table(g_index).archive_flag := p_archive_flag;
749:
750: IF g_debug THEN
751: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);
752: END IF;
753:
754: END SETUP_ELEMENT_DEFINITIONS;
755:

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

761: IS
762: BEGIN
763:
764: IF g_debug THEN
765: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);
766: END IF;
767:
768: g_index_bal := g_index_bal + 1;
769: /* Initialize global tables that hold Other Balances details */

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

772: g_user_balance_table(g_index_bal).balance_type_id := p_balance_type_id;
773: g_user_balance_table(g_index_bal).uom := p_uom;
774:
775: IF g_debug THEN
776: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);
777: END IF;
778:
779: END SETUP_BALANCE_DEFINITIONS;
780:

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

791: l_country fnd_territories_vl.territory_short_name%TYPE;
792: BEGIN
793:
794: IF g_debug THEN
795: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
796: END IF;
797:
798: OPEN csr_get_territory_name(p_territory_code);
799: FETCH csr_get_territory_name into l_country;

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

801:
802: RETURN l_country;
803:
804: IF g_debug THEN
805: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);
806: END IF;
807:
808: END GET_COUNTRY_NAME;
809:

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

1009:
1010: BEGIN
1011:
1012: IF g_debug THEN
1013: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
1014: END IF;
1015: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
1016:
1017: /* PERSON AND ADDRESS DETAILS */

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

1274: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
1275: --
1276:
1277: IF g_debug THEN
1278: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);
1279: END IF;
1280: --
1281: EXCEPTION WHEN OTHERS THEN
1282: g_err_num := SQLCODE;

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

1282: g_err_num := SQLCODE;
1283:
1284: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1285: IF g_debug THEN
1286: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1287: END IF;
1288:
1289: END ARCHIVE_EMPLOYEE_DETAILS;
1290:

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

1353:
1354: BEGIN
1355:
1356: IF g_debug THEN
1357: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);
1358: END IF;
1359:
1360: /* EARNINGS ELEMENT */
1361:

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

1434: END LOOP;
1435:
1436:
1437: IF g_debug THEN
1438: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);
1439: END IF;
1440:
1441: EXCEPTION WHEN OTHERS THEN
1442: g_err_num := SQLCODE;

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

1442: g_err_num := SQLCODE;
1443:
1444: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1445: IF g_debug THEN
1446: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1447: END IF;
1448:
1449:
1450: END ARCHIVE_ELEMENT_INFO;

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

1466: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1467:
1468: BEGIN
1469: IF g_debug THEN
1470: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
1471: END IF;
1472:
1473: OPEN csr_def_bal_id(p_user_name);
1474: FETCH csr_def_bal_id INTO l_defined_balance_id;

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

1475: CLOSE csr_def_bal_id;
1476: RETURN l_defined_balance_id;
1477:
1478: IF g_debug THEN
1479: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
1480: END IF;
1481:
1482: END GET_DEFINED_BALANCE_ID;
1483:

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

1581:
1582: BEGIN
1583:
1584: IF g_debug THEN
1585: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);
1586: END IF;
1587: fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 1');
1588:
1589:

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

1719: END LOOP;
1720: CLOSE csr_chk;
1721:
1722: IF g_debug THEN
1723: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);
1724: END IF;
1725:
1726: EXCEPTION WHEN OTHERS THEN
1727: g_err_num := SQLCODE;

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

1726: EXCEPTION WHEN OTHERS THEN
1727: g_err_num := SQLCODE;
1728: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1729: IF g_debug THEN
1730: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1731: END IF;
1732:
1733: END ARCHIVE_PAYMENT_INFO;
1734:

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

1792:
1793: BEGIN
1794:
1795: IF g_debug THEN
1796: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);
1797: END IF;
1798:
1799:
1800: IF p_archive_flag = 'N' THEN

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

1882: EXCEPTION WHEN OTHERS THEN
1883: g_err_num := SQLCODE;
1884: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
1885: IF g_debug THEN
1886: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
1887: END IF;
1888:
1889: END;
1890:

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

1892:
1893: END IF;
1894:
1895: IF g_debug THEN
1896: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);
1897: END IF;
1898:
1899: END ARCHIVE_ADD_ELEMENT;
1900:

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

1950:
1951: BEGIN
1952:
1953: IF g_debug THEN
1954: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
1955: END IF;
1956:
1957:
1958: IF p_archive_flag = 'N' THEN

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

2035: g_err_num := SQLCODE;
2036:
2037: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);*/
2038: IF g_debug THEN
2039: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
2040: END IF;
2041:
2042: END ARCHIVE_OTH_BALANCE;
2043:

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

2121:
2122: BEGIN
2123:
2124: IF g_debug THEN
2125: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
2126: END IF;
2127:
2128:
2129: OPEN csr_archive_payact(p_assignment_action_id);

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

2198: l_record_count := l_record_count + 1;
2199: END LOOP;
2200:
2201: IF g_debug THEN
2202: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2203: END IF;
2204:
2205: END ARCHIVE_CODE;
2206: END PAY_KW_ARCHIVE;