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

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_SA_ARCHIVE AS
2: /* $Header: pysaparc.pkb 120.14.12020000.2 2012/12/20 09:33:06 bkeshary ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: TYPE element_rec IS RECORD (
7: classification_name pay_element_classifications.classification_name%type
8: ,element_name pay_element_types_f.element_name%type

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

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

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

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

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

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

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

242:
243: BEGIN
244:
245: IF g_debug THEN
246: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
247: END IF;
248:
249: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
250: ,l_business_group_id

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

398: AND ppa.business_group_id = ppf.business_group_id
399: ORDER BY ppf.person_id';
400:
401: IF g_debug THEN
402: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
403: END IF;
404:
405: EXCEPTION
406: WHEN OTHERS THEN

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

507:
508: BEGIN
509:
510: IF g_debug THEN
511: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
512: END IF;
513:
514: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
515: ,l_business_group_id

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

567:
568:
569:
570: IF g_debug THEN
571: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
572: END IF;
573: END ASSIGNMENT_ACTION_CODE;
574:
575:

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

638:
639: BEGIN
640:
641: IF g_debug THEN
642: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
643: END IF;
644:
645: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
646:

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

700: p_date_earned => NULL,
701: p_archive_flag => 'N');
702:
703: IF g_debug THEN
704: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
705: END IF;
706:
707: EXCEPTION WHEN OTHERS THEN
708: g_err_num := SQLCODE;

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

708: g_err_num := SQLCODE;
709:
710: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');*/
711: IF g_debug THEN
712: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
713: END IF;
714:
715: END INITIALIZATION_CODE;
716:

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

725:
726: BEGIN
727:
728: IF g_debug THEN
729: hr_utility.set_location(' Entering Procedure SETUP_ELEMENT_DEFINITIONS',100);
730: END IF;
731:
732:
733: g_index := g_index + 1;

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

741: g_element_table(g_index).uom := p_uom;
742: g_element_table(g_index).archive_flag := p_archive_flag;
743:
744: IF g_debug THEN
745: hr_utility.set_location(' Leaving Procedure SETUP_ELEMENT_DEFINITIONS',110);
746: END IF;
747:
748: END SETUP_ELEMENT_DEFINITIONS;
749:

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

754: IS
755: BEGIN
756:
757: IF g_debug THEN
758: hr_utility.set_location(' Entering Procedure SETUP_BALANCE_DEFINITIONS',120);
759: END IF;
760:
761: g_index_bal := g_index_bal + 1;
762: /* Initialize global tables that hold Other Balances details */

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

764: g_user_balance_table(g_index_bal).defined_balance_id := p_defined_balance_id;
765: g_user_balance_table(g_index_bal).balance_type_id := p_balance_type_id;
766:
767: IF g_debug THEN
768: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);
769: END IF;
770:
771: END SETUP_BALANCE_DEFINITIONS;
772:

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

784: l_country fnd_territories_vl.territory_short_name%TYPE;
785: BEGIN
786:
787: IF g_debug THEN
788: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);
789: END IF;
790:
791: OPEN csr_get_territory_name(p_territory_code);
792: FETCH csr_get_territory_name into l_country;

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

794:
795: RETURN l_country;
796:
797: IF g_debug THEN
798: hr_utility.set_location(' Leaving Function GET_COUNTRY_NAME',150);
799: END IF;
800:
801: END GET_COUNTRY_NAME;
802:

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

1027:
1028: BEGIN
1029:
1030: IF g_debug THEN
1031: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
1032: END IF;
1033: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
1034:
1035: /* PERSON AND ADDRESS DETAILS */

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

1318: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
1319: --
1320:
1321: IF g_debug THEN
1322: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);
1323: END IF;
1324: --
1325: EXCEPTION WHEN OTHERS THEN
1326: g_err_num := SQLCODE;

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

1326: g_err_num := SQLCODE;
1327:
1328: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1329: IF g_debug THEN
1330: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1331: END IF;
1332:
1333: END ARCHIVE_EMPLOYEE_DETAILS;
1334:

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

1399:
1400: BEGIN
1401:
1402: IF g_debug THEN
1403: hr_utility.set_location(' Entering Procedure ARCHIVE_ELEMENT_INFO',210);
1404: END IF;
1405:
1406: /* EARNINGS ELEMENT */
1407:

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

1480: END LOOP;
1481:
1482:
1483: IF g_debug THEN
1484: hr_utility.set_location(' Leaving Procedure ARCHIVE_ELEMENT_INFO',220);
1485: END IF;
1486:
1487: EXCEPTION WHEN OTHERS THEN
1488: g_err_num := SQLCODE;

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

1488: g_err_num := SQLCODE;
1489:
1490: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1491: IF g_debug THEN
1492: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1493: END IF;
1494:
1495:
1496: END ARCHIVE_ELEMENT_INFO;

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

1537:
1538:
1539: BEGIN
1540: IF g_debug THEN
1541: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);
1542: END IF;
1543:
1544: IF g_debug THEN
1545: hr_utility.set_location(' Archivng earning and deduction elements',325);

Line 1545: hr_utility.set_location(' Archivng earning and deduction elements',325);

1541: hr_utility.set_location(' Entering Procedure ARCHIVE_MAIN_ELEMENTS',320);
1542: END IF;
1543:
1544: IF g_debug THEN
1545: hr_utility.set_location(' Archivng earning and deduction elements',325);
1546: END IF;
1547:
1548: -- Archiving Earnings and deduction Elements
1549:

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

1573: END LOOP;
1574: CLOSE csr_result_value;
1575:
1576: IF g_debug THEN
1577: hr_utility.set_location(' Leaving Procedure ARCHIVE_MAIN_ELEMENTS',340);
1578: END IF;
1579:
1580: EXCEPTION WHEN OTHERS THEN
1581: g_err_num := SQLCODE;

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

1581: g_err_num := SQLCODE;
1582: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');*/
1583:
1584: IF g_debug THEN
1585: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
1586: END IF;
1587:
1588:
1589: END ARCHIVE_MAIN_ELEMENTS;

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

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

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

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

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

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

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

1847: END LOOP;
1848: CLOSE csr_chk;
1849:
1850: IF g_debug THEN
1851: hr_utility.set_location(' Leaving Procedure ARCHIVE_PAYMENT_INFO',270);
1852: END IF;
1853:
1854: EXCEPTION WHEN OTHERS THEN
1855: g_err_num := SQLCODE;

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

1854: EXCEPTION WHEN OTHERS THEN
1855: g_err_num := SQLCODE;
1856: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1857: IF g_debug THEN
1858: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1859: END IF;
1860:
1861: END ARCHIVE_PAYMENT_INFO;
1862:

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

1925: BEGIN
1926: --
1927:
1928: IF g_debug THEN
1929: hr_utility.set_location(' Entering Procedure ARCHIVE_ACCRUAL_PLAN',290);
1930: END IF;
1931:
1932: -- Bug 6915966
1933: -- Fetch and archive the accruals cursor in loop

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

1996: --
1997: END LOOP ;
1998:
1999: IF g_debug THEN
2000: hr_utility.set_location(' Leaving Procedure ARCHIVE_ACCRUAL_PLAN',300);
2001: END IF;
2002: --
2003: EXCEPTION
2004: WHEN OTHERS THEN

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

2011: g_err_num := SQLCODE;
2012:
2013: --fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ACCRUAL_PLAN');
2014: IF g_debug THEN
2015: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);
2016: END IF;
2017: RAISE;
2018:
2019: END ARCHIVE_ACCRUAL_PLAN;

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

2076:
2077: BEGIN
2078:
2079: IF g_debug THEN
2080: hr_utility.set_location(' Entering Procedure ARCHIVE_ADD_ELEMENT',320);
2081: END IF;
2082:
2083:
2084: IF p_archive_flag = 'N' THEN

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

2167: EXCEPTION WHEN OTHERS THEN
2168: g_err_num := SQLCODE;
2169: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
2170: IF g_debug THEN
2171: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
2172: END IF;
2173:
2174: END;
2175:

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

2177:
2178: END IF;
2179:
2180: IF g_debug THEN
2181: hr_utility.set_location(' Leaving Procedure ARCHIVE_ADD_ELEMENT',340);
2182: END IF;
2183:
2184: END ARCHIVE_ADD_ELEMENT;
2185:

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

2228:
2229: BEGIN
2230:
2231: IF g_debug THEN
2232: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
2233: END IF;
2234:
2235: /*fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');*/
2236:

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

2309: g_err_num := SQLCODE;
2310:
2311: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);*/
2312: IF g_debug THEN
2313: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
2314: END IF;
2315:
2316: END ARCHIVE_OTH_BALANCE;
2317:

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

2395:
2396: BEGIN
2397:
2398: IF g_debug THEN
2399: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
2400: END IF;
2401:
2402:
2403: OPEN csr_archive_payact(p_assignment_action_id);

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

2501: l_record_count := l_record_count + 1;
2502: END LOOP;
2503:
2504: IF g_debug THEN
2505: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2506: END IF;
2507:
2508: END ARCHIVE_CODE;
2509: END PAY_SA_ARCHIVE;