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

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hrtrhapi.pkb 120.9 2007/03/08 06:56:44 ddeb ship $ */
3: -- Global variables
4: g_date_format varchar2(10) := 'RRRR/MM/DD';
5: g_package varchar2(33) := 'HR_TRANS_HISTORY_API.';
6: g_debug boolean := hr_utility.debug_enabled;
7: --
8: --
9:
10: TYPE NumberTblType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 163: hr_utility.set_location('Entering: '|| l_proc,5);

159: stateTbl TransStateHistTbl;
160: l_cnt INTEGER;
161:
162: BEGIN
163: hr_utility.set_location('Entering: '|| l_proc,5);
164: OPEN getMaxSeq;
165: FETCH getMaxSeq into l_seq_id;
166: CLOSE getMaxSeq;
167: -- Check if this is old transaction, if yes, fetch from approval table.

Line 238: hr_utility.set_location('Leaving: '|| l_proc,10);

234: );
235: END LOOP;
236: END IF;
237: END IF;
238: hr_utility.set_location('Leaving: '|| l_proc,10);
239: RETURN l_seq_id;
240:
241: EXCEPTION
242: WHEN OTHERS THEN

Line 243: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

239: RETURN l_seq_id;
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
244: If getMaxSeq%ISOPEN Then
245: CLOSE getMaxSeq;
246: End If;
247:

Line 527: hr_utility.set_location('Entering: '|| l_proc,5);

523: l_cnt Integer;
524: l_proc constant varchar2(100) := g_package || ' RevertTransSteps';
525: TxStepTbl TransStepTbl;
526: BEGIN
527: hr_utility.set_location('Entering: '|| l_proc,5);
528: OPEN cur_step_hist;
529: FETCH cur_step_hist BULK COLLECT INTO
530: TxStepTbl.STEP_HISTORY_ID
531: ,TxStepTbl.TRANSACTION_HISTORY_ID

Line 710: hr_utility.set_location('Leaving: '|| l_proc,10);

706: TxStepTbl.STEP_HISTORY_ID(i),
707: P_APPROVAL_HISTORY_ID
708: );
709: END LOOP;
710: hr_utility.set_location('Leaving: '|| l_proc,10);
711: Exception
712: when OTHERS then
713: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
714: If cur_step_hist%IsOpen Then

Line 713: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

709: END LOOP;
710: hr_utility.set_location('Leaving: '|| l_proc,10);
711: Exception
712: when OTHERS then
713: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
714: If cur_step_hist%IsOpen Then
715: CLOSE cur_step_hist;
716: End If;
717: raise;

Line 753: hr_utility.set_location('Entering: '|| l_proc,5);

749: l_proc constant varchar2(100) := g_package || ' RevertTransValues';
750: TxValueTbl TransValueTbl;
751:
752: BEGIN
753: hr_utility.set_location('Entering: '|| l_proc,5);
754: OPEN cur_trans_value;
755: FETCH cur_trans_value BULK COLLECT INTO
756: TxValueTbl.transaction_value_id
757: ,TxValueTbl.step_history_id

Line 808: hr_utility.set_location('Calling: RevertPerPayTransValues '|| l_proc,10);

804: ,TxValueTbl.last_updated_by(i)
805: ,TxValueTbl.last_update_login(i)
806: );
807: END LOOP;
808: hr_utility.set_location('Calling: RevertPerPayTransValues '|| l_proc,10);
809: --
810: --RevertPerPayTransValues(P_APPROVAL_HISTORY_ID);
811: --
812: hr_utility.set_location('Leaving: '|| l_proc,20);

Line 812: hr_utility.set_location('Leaving: '|| l_proc,20);

808: hr_utility.set_location('Calling: RevertPerPayTransValues '|| l_proc,10);
809: --
810: --RevertPerPayTransValues(P_APPROVAL_HISTORY_ID);
811: --
812: hr_utility.set_location('Leaving: '|| l_proc,20);
813: Exception
814: when OTHERS then
815: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
816: If cur_trans_value%IsOpen Then

Line 815: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

811: --
812: hr_utility.set_location('Leaving: '|| l_proc,20);
813: Exception
814: when OTHERS then
815: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
816: If cur_trans_value%IsOpen Then
817: CLOSE cur_trans_value;
818: End If;
819: raise;

Line 855: hr_utility.set_location('Entering: '|| l_proc,5);

851: and val.value IS NOT NULL;
852:
853:
854: Begin
855: hr_utility.set_location('Entering: '|| l_proc,5);
856: -- archive data correction logic
857: -- correct ONLY if max history id is 0 and min -1
858: -- delete current txn values all the time if max history id is >0
859: -- if max history id is 0 and module is LOA DONOT Delete

Line 889: hr_utility.set_location('Leaving: '|| l_proc,10);

885: END IF;
886: CLOSE PsuedoValUpgTrans;
887: END IF;
888:
889: hr_utility.set_location('Leaving: '|| l_proc,10);
890:
891: end correctOldTxnHistoryData ;
892:
893:

Line 910: hr_utility.set_location('Entering: '|| l_proc,5);

906: l_seq_id NUMBER(5);
907: lv_found VarChar2(2);
908: l_proc constant varchar2(100) := g_package || ' RevertToLastSave';
909: Begin
910: hr_utility.set_location('Entering: '|| l_proc,5);
911: l_seq_id := getTransStateSequence(P_TRANSACTION_ID => P_TRANSACTION_ID);
912:
913: -- Copy Transaction details from history.
914: UPDATE HR_API_TRANSACTIONS

Line 995: hr_utility.set_location('Leaving: '|| l_proc,10);

991: (
992: P_TRANSACTION_ID => P_TRANSACTION_ID
993: ,P_APPROVAL_HISTORY_ID => l_seq_id
994: );
995: hr_utility.set_location('Leaving: '|| l_proc,10);
996: Exception
997: when OTHERS then
998: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
999: raise;

Line 998: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

994: );
995: hr_utility.set_location('Leaving: '|| l_proc,10);
996: Exception
997: when OTHERS then
998: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
999: raise;
1000: End RevertToLastSave;
1001:
1002: Procedure DeleteStaleData

Line 1020: --hr_utility.trace_on(null, 'TIGER');

1016: and approval_history_id = l_seq_id
1017: and action = 'SFL';
1018:
1019: Begin
1020: --hr_utility.trace_on(null, 'TIGER');
1021: --g_debug := TRUE;
1022: hr_utility.set_location('Entering: '|| l_proc,5);
1023: IF P_ACTION NOT IN ('QUESTION', 'ANSWER') THEN
1024: l_seq_id := getTransStateSequence(P_TRANSACTION_ID => P_TRANSACTION_ID);

Line 1022: hr_utility.set_location('Entering: '|| l_proc,5);

1018:
1019: Begin
1020: --hr_utility.trace_on(null, 'TIGER');
1021: --g_debug := TRUE;
1022: hr_utility.set_location('Entering: '|| l_proc,5);
1023: IF P_ACTION NOT IN ('QUESTION', 'ANSWER') THEN
1024: l_seq_id := getTransStateSequence(P_TRANSACTION_ID => P_TRANSACTION_ID);
1025:
1026: OPEN cur_chk_stale_data;

Line 1030: hr_utility.set_location('Entering If: '|| l_proc,15);

1026: OPEN cur_chk_stale_data;
1027: FETCH cur_chk_stale_data into l_action;
1028:
1029: If cur_chk_stale_data%found AND l_seq_id IS NOT NULL THEN
1030: hr_utility.set_location('Entering If: '|| l_proc,15);
1031: -- Delete State History
1032: DELETE pqh_ss_trans_state_history
1033: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1034: and approval_history_id = l_seq_id;

Line 1068: hr_utility.set_location('Leaving: '|| l_proc,10);

1064:
1065: END If;
1066: CLOSE cur_chk_stale_data;
1067: END IF;
1068: hr_utility.set_location('Leaving: '|| l_proc,10);
1069: Exception
1070: when OTHERS then
1071: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1072: If cur_chk_stale_data%IsOpen Then

Line 1071: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1067: END IF;
1068: hr_utility.set_location('Leaving: '|| l_proc,10);
1069: Exception
1070: when OTHERS then
1071: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1072: If cur_chk_stale_data%IsOpen Then
1073: CLOSE cur_chk_stale_data;
1074: End If;
1075: raise;

Line 1105: hr_utility.set_location('Entering: '|| l_proc,5);

1101: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
1102:
1103: l_row cur_trans_details%RowType;
1104: Begin
1105: hr_utility.set_location('Entering: '|| l_proc,5);
1106: Open cur_trans_details;
1107: Fetch cur_trans_details into l_row;
1108: CLOSE cur_trans_details;
1109:

Line 1132: hr_utility.set_location('Leaving: '|| l_proc,10);

1128: ,p_user_comment => P_USER_COMMENT
1129: ,p_approval_history_id => P_APPROVAL_HISTORY_ID
1130: ,p_transaction_history_id => P_TRANSACTION_ID
1131: );
1132: hr_utility.set_location('Leaving: '|| l_proc,10);
1133: Exception
1134: when OTHERS then
1135: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1136: If cur_trans_details%IsOpen Then

Line 1135: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1131: );
1132: hr_utility.set_location('Leaving: '|| l_proc,10);
1133: Exception
1134: when OTHERS then
1135: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1136: If cur_trans_details%IsOpen Then
1137: CLOSE cur_trans_details;
1138: End If;
1139: raise;

Line 1370: hr_utility.set_location('Entering: '|| l_proc,5);

1366: l_cnt integer;
1367: l_proc constant varchar2(100) := g_package || ' SaveTransValueHisroty';
1368: TxValueTbl TransValueTbl;
1369: BEGIN
1370: hr_utility.set_location('Entering: '|| l_proc,5);
1371:
1372: OPEN cur_trans_value;
1373: FETCH cur_trans_value BULK COLLECT INTO
1374: TxValueTbl.transaction_value_id

Line 1418: hr_utility.set_location('Calling: savePerPayTransHistory '|| l_proc,10);

1414: ,TxValueTbl.last_updated_by(i)
1415: ,TxValueTbl.last_update_login(i));
1416:
1417: END LOOP;
1418: hr_utility.set_location('Calling: savePerPayTransHistory '|| l_proc,10);
1419: --
1420: --SavePerPayTransHistory(P_APPROVAL_HISTORY_ID);
1421: --
1422: hr_utility.set_location('Leaving: '|| l_proc,20);

Line 1422: hr_utility.set_location('Leaving: '|| l_proc,20);

1418: hr_utility.set_location('Calling: savePerPayTransHistory '|| l_proc,10);
1419: --
1420: --SavePerPayTransHistory(P_APPROVAL_HISTORY_ID);
1421: --
1422: hr_utility.set_location('Leaving: '|| l_proc,20);
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1426: If cur_trans_value%Isopen Then

Line 1425: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1421: --
1422: hr_utility.set_location('Leaving: '|| l_proc,20);
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1426: If cur_trans_value%Isopen Then
1427: CLOSE cur_trans_value;
1428: End If;
1429: RAISE;

Line 1501: hr_utility.set_location('Entering: '|| l_proc,5);

1497: l_cnt integer;
1498: l_proc constant varchar2(100) := g_package || 'SaveTransStepHisroty';
1499: TxStepTbl TransStepTbl;
1500: Begin
1501: hr_utility.set_location('Entering: '|| l_proc,5);
1502: OPEN cur_trans_steps;
1503: FETCH cur_trans_steps BULK COLLECT INTO
1504: TxStepTbl.STEP_HISTORY_ID
1505: ,TxStepTbl.TRANSACTION_HISTORY_ID

Line 1688: hr_utility.set_location('Leaving: '|| l_proc,10);

1684: TxStepTbl.STEP_HISTORY_ID(i),
1685: P_APPROVAL_HISTORY_ID
1686: );
1687: End Loop;
1688: hr_utility.set_location('Leaving: '|| l_proc,10);
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1692: If cur_trans_steps%Isopen Then

Line 1691: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1687: End Loop;
1688: hr_utility.set_location('Leaving: '|| l_proc,10);
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1692: If cur_trans_steps%Isopen Then
1693: CLOSE cur_trans_steps;
1694: End If;
1695: RAISE;

Line 1743: hr_utility.set_location('Entering: '|| l_proc,5);

1739: l_seq_id PQH_SS_TRANS_STATE_HISTORY.approval_history_id%TYPE;
1740: l_proc constant varchar2(100) := g_package || ' SaveTransactionHistory';
1741:
1742: Begin
1743: hr_utility.set_location('Entering: '|| l_proc,5);
1744: P_APPROVAL_HISTORY_ID := getTransStateSequence(P_TRANSACTION_ID);
1745: OPEN cur_trans_details;
1746: FETCH cur_trans_details INTO l_trans_details_row;
1747: If l_trans_details_row.transaction_history_id IS NULL then

Line 1794: hr_utility.set_location('Leaving: '|| l_proc,10);

1790: P_TRANSACTION_ID => P_TRANSACTION_ID
1791: ,P_APPROVAL_HISTORY_ID => P_APPROVAL_HISTORY_ID
1792: );
1793: CLOSE cur_trans_details;
1794: hr_utility.set_location('Leaving: '|| l_proc,10);
1795: Exception
1796: when OTHERS then
1797: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1798: If cur_trans_details%IsOpen Then

Line 1797: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1793: CLOSE cur_trans_details;
1794: hr_utility.set_location('Leaving: '|| l_proc,10);
1795: Exception
1796: when OTHERS then
1797: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1798: If cur_trans_details%IsOpen Then
1799: CLOSE cur_trans_details;
1800: End If;
1801: raise;

Line 1822: --hr_utility.trace_on(null, 'TIGER');

1818: l_proc constant varchar2(100) := g_package || ' ARCHIVE_ACTION';
1819:
1820: Begin
1821: --
1822: --hr_utility.trace_on(null, 'TIGER');
1823: --g_debug := TRUE;
1824: --
1825: hr_utility.set_location('Entering: '|| l_proc,5);
1826: deleteStaleData(P_TRANSACTION_ID, P_ACTION);

Line 1825: hr_utility.set_location('Entering: '|| l_proc,5);

1821: --
1822: --hr_utility.trace_on(null, 'TIGER');
1823: --g_debug := TRUE;
1824: --
1825: hr_utility.set_location('Entering: '|| l_proc,5);
1826: deleteStaleData(P_TRANSACTION_ID, P_ACTION);
1827: l_trans_id := P_TRANSACTION_ID;
1828: If (P_ACTION = 'RESUBMIT' AND P_NOTIFICATION_ID IS NULL)
1829: OR (P_ACTION IN ('SFL','SUBMIT')) Then

Line 1855: hr_utility.set_location('Leaving: '|| l_proc,10);

1851: ,P_USER_COMMENT => P_USER_COMMENT
1852: );
1853: END IF;
1854:
1855: hr_utility.set_location('Leaving: '|| l_proc,10);
1856: Exception
1857: when OTHERS then
1858: --ROLLBACK;
1859: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 1859: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1855: hr_utility.set_location('Leaving: '|| l_proc,10);
1856: Exception
1857: when OTHERS then
1858: --ROLLBACK;
1859: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1860: raise;
1861: End ARCHIVE_ACTION;
1862:
1863: --

Line 1876: -- hr_utility.trace_on(null, 'TIGER');

1872: IS
1873: l_proc constant varchar2(100) := g_package || ' ARCHIVE_SUBMIT';
1874: Begin
1875: --
1876: -- hr_utility.trace_on(null, 'TIGER');
1877: --g_debug := TRUE;
1878: --
1879: hr_utility.set_location('Entering: '|| l_proc,5);
1880: ARCHIVE_ACTION

Line 1879: hr_utility.set_location('Entering: '|| l_proc,5);

1875: --
1876: -- hr_utility.trace_on(null, 'TIGER');
1877: --g_debug := TRUE;
1878: --
1879: hr_utility.set_location('Entering: '|| l_proc,5);
1880: ARCHIVE_ACTION
1881: (
1882: P_TRANSACTION_ID => P_TRANSACTION_ID
1883: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 1888: hr_utility.set_location('Leaving: '|| l_proc,10);

1884: ,P_USER_NAME => P_USER_NAME
1885: ,P_USER_COMMENT => P_USER_COMMENT
1886: ,P_ACTION => 'SUBMIT'
1887: );
1888: hr_utility.set_location('Leaving: '|| l_proc,10);
1889: Exception
1890: when OTHERS then
1891: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1892: raise;

Line 1891: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1887: );
1888: hr_utility.set_location('Leaving: '|| l_proc,10);
1889: Exception
1890: when OTHERS then
1891: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1892: raise;
1893: End ARCHIVE_SUBMIT;
1894:
1895: --

Line 1907: hr_utility.set_location('Entering: '|| l_proc,5);

1903: )
1904: IS
1905: l_proc constant varchar2(100) := g_package || ' ARCHIVE_RESUBMIT';
1906: Begin
1907: hr_utility.set_location('Entering: '|| l_proc,5);
1908: ARCHIVE_ACTION
1909: (
1910: P_TRANSACTION_ID => P_TRANSACTION_ID
1911: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 1916: hr_utility.set_location('Leaving: '|| l_proc,10);

1912: ,P_USER_NAME => P_USER_NAME
1913: ,P_USER_COMMENT => P_USER_COMMENT
1914: ,P_ACTION => 'RESUBMIT'
1915: );
1916: hr_utility.set_location('Leaving: '|| l_proc,10);
1917: Exception
1918: when OTHERS then
1919: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1920: raise;

Line 1919: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1915: );
1916: hr_utility.set_location('Leaving: '|| l_proc,10);
1917: Exception
1918: when OTHERS then
1919: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1920: raise;
1921: End ARCHIVE_RESUBMIT;
1922:
1923: Procedure ARCHIVE_SFL

Line 1934: -- hr_utility.trace_on(null, 'TIGER');

1930: l_proc constant varchar2(100) := g_package || ' ARCHIVE_SFL';
1931:
1932: Begin
1933: --
1934: -- hr_utility.trace_on(null, 'TIGER');
1935: --g_debug := TRUE;
1936: --
1937: hr_utility.set_location('Entering: '|| l_proc,5);
1938: ARCHIVE_ACTION

Line 1937: hr_utility.set_location('Entering: '|| l_proc,5);

1933: --
1934: -- hr_utility.trace_on(null, 'TIGER');
1935: --g_debug := TRUE;
1936: --
1937: hr_utility.set_location('Entering: '|| l_proc,5);
1938: ARCHIVE_ACTION
1939: (
1940: P_TRANSACTION_ID => P_TRANSACTION_ID
1941: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 1945: hr_utility.set_location('Leaving: '|| l_proc,10);

1941: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID
1942: ,P_USER_NAME => P_USER_NAME
1943: ,P_ACTION => 'SFL'
1944: );
1945: hr_utility.set_location('Leaving: '|| l_proc,10);
1946: Exception
1947: when OTHERS then
1948: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1949: raise;

Line 1948: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1944: );
1945: hr_utility.set_location('Leaving: '|| l_proc,10);
1946: Exception
1947: when OTHERS then
1948: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1949: raise;
1950: End ARCHIVE_SFL;
1951:
1952: Procedure ARCHIVE_APPROVE

Line 1962: hr_utility.set_location('Entering: '|| l_proc,5);

1958: )
1959: IS
1960: l_proc constant varchar2(100) := g_package || ' ARCHIVE_APPROVE';
1961: Begin
1962: hr_utility.set_location('Entering: '|| l_proc,5);
1963: ARCHIVE_ACTION
1964: (
1965: P_TRANSACTION_ID => P_TRANSACTION_ID
1966: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 1971: hr_utility.set_location('Leaving: '|| l_proc,10);

1967: ,P_USER_NAME => P_USER_NAME
1968: ,P_USER_COMMENT => P_USER_COMMENT
1969: ,P_ACTION => 'APPROVED'
1970: );
1971: hr_utility.set_location('Leaving: '|| l_proc,10);
1972: Exception
1973: when OTHERS then
1974: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1975: raise;

Line 1974: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1970: );
1971: hr_utility.set_location('Leaving: '|| l_proc,10);
1972: Exception
1973: when OTHERS then
1974: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1975: raise;
1976: End ARCHIVE_APPROVE;
1977:
1978: Procedure ARCHIVE_DELETE

Line 1988: hr_utility.set_location('Entering: '|| l_proc,5);

1984: )
1985: IS
1986: l_proc constant varchar2(100) := g_package || ' ARCHIVE_DELETE';
1987: Begin
1988: hr_utility.set_location('Entering: '|| l_proc,5);
1989: ARCHIVE_ACTION
1990: (
1991: P_TRANSACTION_ID => P_TRANSACTION_ID
1992: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 1997: hr_utility.set_location('Leaving: '|| l_proc,10);

1993: ,P_USER_NAME => P_USER_NAME
1994: ,P_USER_COMMENT => P_USER_COMMENT
1995: ,P_ACTION => 'DELETED'
1996: );
1997: hr_utility.set_location('Leaving: '|| l_proc,10);
1998: Exception
1999: when OTHERS then
2000: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2001: raise;

Line 2000: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1996: );
1997: hr_utility.set_location('Leaving: '|| l_proc,10);
1998: Exception
1999: when OTHERS then
2000: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2001: raise;
2002: End ARCHIVE_DELETE;
2003:
2004: Procedure ARCHIVE_REJECT

Line 2014: hr_utility.set_location('Entering: '|| l_proc,5);

2010: )
2011: IS
2012: l_proc constant varchar2(100) := g_package || ' ARCHIVE_REJECT';
2013: Begin
2014: hr_utility.set_location('Entering: '|| l_proc,5);
2015: ARCHIVE_ACTION
2016: (
2017: P_TRANSACTION_ID => P_TRANSACTION_ID
2018: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2023: hr_utility.set_location('Leaving: '|| l_proc,10);

2019: ,P_USER_NAME => P_USER_NAME
2020: ,P_USER_COMMENT => P_USER_COMMENT
2021: ,P_ACTION => 'REJECTED'
2022: );
2023: hr_utility.set_location('Leaving: '|| l_proc,10);
2024: Exception
2025: when OTHERS then
2026: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2027: raise;

Line 2026: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2022: );
2023: hr_utility.set_location('Leaving: '|| l_proc,10);
2024: Exception
2025: when OTHERS then
2026: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2027: raise;
2028: End ARCHIVE_REJECT;
2029:
2030: Procedure ARCHIVE_RFC

Line 2040: hr_utility.set_location('Entering: '|| l_proc,5);

2036: )
2037: IS
2038: l_proc constant varchar2(100) := g_package || ' ARCHIVE_RFC';
2039: Begin
2040: hr_utility.set_location('Entering: '|| l_proc,5);
2041: ARCHIVE_ACTION
2042: (
2043: P_TRANSACTION_ID => P_TRANSACTION_ID
2044: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2049: hr_utility.set_location('Leaving: '|| l_proc,10);

2045: ,P_USER_NAME => P_USER_NAME
2046: ,P_USER_COMMENT => P_USER_COMMENT
2047: ,P_ACTION => 'RFC'
2048: );
2049: hr_utility.set_location('Leaving: '|| l_proc,10);
2050: Exception
2051: when OTHERS then
2052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2053: raise;

Line 2052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2048: );
2049: hr_utility.set_location('Leaving: '|| l_proc,10);
2050: Exception
2051: when OTHERS then
2052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2053: raise;
2054: End ARCHIVE_RFC;
2055:
2056: Procedure ARCHIVE_TRANSFER

Line 2067: -- hr_utility.trace_on(null, 'TIGER');

2063: IS
2064: l_proc constant varchar2(100) := g_package || ' ARCHIVE_TRANSFER';
2065: Begin
2066: --
2067: -- hr_utility.trace_on(null, 'TIGER');
2068: --g_debug := TRUE;
2069: --
2070: hr_utility.set_location('Entering: '|| l_proc,5);
2071: ARCHIVE_ACTION

Line 2070: hr_utility.set_location('Entering: '|| l_proc,5);

2066: --
2067: -- hr_utility.trace_on(null, 'TIGER');
2068: --g_debug := TRUE;
2069: --
2070: hr_utility.set_location('Entering: '|| l_proc,5);
2071: ARCHIVE_ACTION
2072: (
2073: P_TRANSACTION_ID => P_TRANSACTION_ID
2074: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2079: hr_utility.set_location('Leaving: '|| l_proc,10);

2075: ,P_USER_NAME => P_USER_NAME
2076: ,P_USER_COMMENT => P_USER_COMMENT
2077: ,P_ACTION => 'TRANSFER'
2078: );
2079: hr_utility.set_location('Leaving: '|| l_proc,10);
2080: Exception
2081: when OTHERS then
2082: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2083: raise;

Line 2082: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2078: );
2079: hr_utility.set_location('Leaving: '|| l_proc,10);
2080: Exception
2081: when OTHERS then
2082: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2083: raise;
2084: End ARCHIVE_TRANSFER;
2085:
2086: Procedure ARCHIVE_FORWARD

Line 2096: hr_utility.set_location('Entering: '|| l_proc,5);

2092: )
2093: IS
2094: l_proc constant varchar2(100) := g_package || ' ARCHIVE_FORWARD';
2095: Begin
2096: hr_utility.set_location('Entering: '|| l_proc,5);
2097: ARCHIVE_ACTION
2098: (
2099: P_TRANSACTION_ID => P_TRANSACTION_ID
2100: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2105: hr_utility.set_location('Leaving: '|| l_proc,10);

2101: ,P_USER_NAME => P_USER_NAME
2102: ,P_USER_COMMENT => P_USER_COMMENT
2103: ,P_ACTION => 'FORWARD'
2104: );
2105: hr_utility.set_location('Leaving: '|| l_proc,10);
2106: Exception
2107: when OTHERS then
2108: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2109: raise;

Line 2108: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2104: );
2105: hr_utility.set_location('Leaving: '|| l_proc,10);
2106: Exception
2107: when OTHERS then
2108: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2109: raise;
2110: End ARCHIVE_FORWARD;
2111:
2112: Procedure ARCHIVE_REQ_MOREINFO

Line 2122: hr_utility.set_location('Entering: '|| l_proc,5);

2118: )
2119: IS
2120: l_proc constant varchar2(100) := g_package || ' ARCHIVE_REQ_MOREINFO';
2121: Begin
2122: hr_utility.set_location('Entering: '|| l_proc,5);
2123: ARCHIVE_ACTION
2124: (
2125: P_TRANSACTION_ID => P_TRANSACTION_ID
2126: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2131: hr_utility.set_location('Leaving: '|| l_proc,10);

2127: ,P_USER_NAME => P_USER_NAME
2128: ,P_USER_COMMENT => P_USER_COMMENT
2129: ,P_ACTION => 'QUESTION'
2130: );
2131: hr_utility.set_location('Leaving: '|| l_proc,10);
2132: Exception
2133: when OTHERS then
2134: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2135: raise;

Line 2134: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2130: );
2131: hr_utility.set_location('Leaving: '|| l_proc,10);
2132: Exception
2133: when OTHERS then
2134: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2135: raise;
2136: End ARCHIVE_REQ_MOREINFO;
2137:
2138: Procedure ARCHIVE_ANSWER_MOREINFO

Line 2148: hr_utility.set_location('Entering: '|| l_proc,5);

2144: )
2145: IS
2146: l_proc constant varchar2(100) := g_package || ' ARCHIVE_ANSWER_MOREINFO';
2147: Begin
2148: hr_utility.set_location('Entering: '|| l_proc,5);
2149: ARCHIVE_ACTION
2150: (
2151: P_TRANSACTION_ID => P_TRANSACTION_ID
2152: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2157: hr_utility.set_location('Leaving: '|| l_proc,10);

2153: ,P_USER_NAME => P_USER_NAME
2154: ,P_USER_COMMENT => P_USER_COMMENT
2155: ,P_ACTION => 'ANSWER'
2156: );
2157: hr_utility.set_location('Leaving: '|| l_proc,10);
2158: Exception
2159: when OTHERS then
2160: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2161: raise;

Line 2160: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2156: );
2157: hr_utility.set_location('Leaving: '|| l_proc,10);
2158: Exception
2159: when OTHERS then
2160: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2161: raise;
2162: End ARCHIVE_ANSWER_MOREINFO;
2163:
2164: Procedure CANCEL_ACTION

Line 2173: -- hr_utility.trace_on(null, 'TIGER');

2169: l_proc constant varchar2(100) := g_package || ' CANCEL_ACTION';
2170: PRAGMA AUTONOMOUS_TRANSACTION;
2171: BEGIN
2172: --
2173: -- hr_utility.trace_on(null, 'TIGER');
2174: --g_debug := TRUE;
2175: --
2176: hr_utility.set_location('Entering: '|| l_proc,5);
2177:

Line 2176: hr_utility.set_location('Entering: '|| l_proc,5);

2172: --
2173: -- hr_utility.trace_on(null, 'TIGER');
2174: --g_debug := TRUE;
2175: --
2176: hr_utility.set_location('Entering: '|| l_proc,5);
2177:
2178: RevertToLastSave
2179: (
2180: P_TRANSACTION_ID => P_TRANSACTION_ID

Line 2182: hr_utility.set_location('Leaving: '|| l_proc,10);

2178: RevertToLastSave
2179: (
2180: P_TRANSACTION_ID => P_TRANSACTION_ID
2181: );
2182: hr_utility.set_location('Leaving: '|| l_proc,10);
2183: commit;
2184: Exception
2185: when OTHERS then
2186: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2186: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2182: hr_utility.set_location('Leaving: '|| l_proc,10);
2183: commit;
2184: Exception
2185: when OTHERS then
2186: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2187: ROLLBACK;
2188: RAISE;
2189: END CANCEL_ACTION;
2190:

Line 2201: hr_utility.set_location('Entering: '|| l_proc,5);

2197: )
2198: IS
2199: l_proc constant varchar2(100) := g_package || ' ARCHIVE_TIMEOUT';
2200: Begin
2201: hr_utility.set_location('Entering: '|| l_proc,5);
2202: ARCHIVE_ACTION
2203: (
2204: P_TRANSACTION_ID => P_TRANSACTION_ID
2205: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

Line 2210: hr_utility.set_location('Leaving: '|| l_proc,10);

2206: ,P_USER_NAME => P_USER_NAME
2207: ,P_USER_COMMENT => P_USER_COMMENT
2208: ,P_ACTION => 'TIMEOUT'
2209: );
2210: hr_utility.set_location('Leaving: '|| l_proc,10);
2211: Exception
2212: when OTHERS then
2213: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2214: raise;

Line 2213: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2209: );
2210: hr_utility.set_location('Leaving: '|| l_proc,10);
2211: Exception
2212: when OTHERS then
2213: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2214: raise;
2215: End ARCHIVE_TIMEOUT;
2216:
2217: END HR_TRANS_HISTORY_API;