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.12 2011/05/17 14:33:34 nchinnam 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 1371: hr_utility.set_location('Entering: '|| l_proc,5);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1823:
1824:
1825: Begin
1826: --
1827: --hr_utility.trace_on(null, 'TIGER');
1828: --g_debug := TRUE;
1829: --
1830:
1831: hr_multi_message.enable_message_list;

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

1829: --
1830:
1831: hr_multi_message.enable_message_list;
1832:
1833: hr_utility.set_location('Entering: '|| l_proc,5);
1834: deleteStaleData(P_TRANSACTION_ID, P_ACTION);
1835: l_trans_id := P_TRANSACTION_ID;
1836: If (P_ACTION = 'RESUBMIT' AND P_NOTIFICATION_ID IS NULL)
1837: OR (P_ACTION IN ('SFL','SUBMIT')) Then

Line 1873: hr_utility.set_location('Error in Multi Message List : ' || l_encoded, 545);

1869: fnd_message.set_encoded(l_encoded);
1870: l_message_type := fnd_message.get_token
1871: (token => fnd_msg_pub.g_message_type_token_name);
1872: if l_message_type = hr_multi_message.g_error_msg then
1873: hr_utility.set_location('Error in Multi Message List : ' || l_encoded, 545);
1874: end if;
1875: end loop;
1876:
1877: end if;

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

1877: end if;
1878: -- End of Fix for Bug 10302076
1879:
1880:
1881: hr_utility.set_location('Leaving: '|| l_proc,10);
1882: Exception
1883: when OTHERS then
1884: --ROLLBACK;
1885: -- Fix for Bug 10302076

Line 1895: hr_utility.set_location('Error in Multi Message List : ' || l_encoded,550);

1891: fnd_message.set_encoded(l_encoded);
1892: l_message_type := fnd_message.get_token
1893: (token => fnd_msg_pub.g_message_type_token_name);
1894: if l_message_type = hr_multi_message.g_error_msg then
1895: hr_utility.set_location('Error in Multi Message List : ' || l_encoded,550);
1896: end if;
1897: end loop;
1898:
1899: end if;

Line 1900: hr_utility.set_location('SQLERRM : '|| SQLERRM,555);

1896: end if;
1897: end loop;
1898:
1899: end if;
1900: hr_utility.set_location('SQLERRM : '|| SQLERRM,555);
1901: hr_utility.set_location('SQLCODE : '|| to_char(SQLCODE),555);
1902: raise;
1903:
1904: --Emd of Fix for Bug 10302076

Line 1901: hr_utility.set_location('SQLCODE : '|| to_char(SQLCODE),555);

1897: end loop;
1898:
1899: end if;
1900: hr_utility.set_location('SQLERRM : '|| SQLERRM,555);
1901: hr_utility.set_location('SQLCODE : '|| to_char(SQLCODE),555);
1902: raise;
1903:
1904: --Emd of Fix for Bug 10302076
1905: End ARCHIVE_ACTION;

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

1916: IS
1917: l_proc constant varchar2(100) := g_package || ' ARCHIVE_SUBMIT';
1918: Begin
1919: --
1920: -- hr_utility.trace_on(null, 'TIGER');
1921: --g_debug := TRUE;
1922: --
1923: hr_utility.set_location('Entering: '|| l_proc,5);
1924: ARCHIVE_ACTION

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

1919: --
1920: -- hr_utility.trace_on(null, 'TIGER');
1921: --g_debug := TRUE;
1922: --
1923: hr_utility.set_location('Entering: '|| l_proc,5);
1924: ARCHIVE_ACTION
1925: (
1926: P_TRANSACTION_ID => P_TRANSACTION_ID
1927: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

1928: ,P_USER_NAME => P_USER_NAME
1929: ,P_USER_COMMENT => P_USER_COMMENT
1930: ,P_ACTION => 'SUBMIT'
1931: );
1932: hr_utility.set_location('Leaving: '|| l_proc,10);
1933: Exception
1934: when OTHERS then
1935: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1936: raise;

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

1931: );
1932: hr_utility.set_location('Leaving: '|| l_proc,10);
1933: Exception
1934: when OTHERS then
1935: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1936: raise;
1937: End ARCHIVE_SUBMIT;
1938:
1939: --

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

1947: )
1948: IS
1949: l_proc constant varchar2(100) := g_package || ' ARCHIVE_RESUBMIT';
1950: Begin
1951: hr_utility.set_location('Entering: '|| l_proc,5);
1952: ARCHIVE_ACTION
1953: (
1954: P_TRANSACTION_ID => P_TRANSACTION_ID
1955: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

1956: ,P_USER_NAME => P_USER_NAME
1957: ,P_USER_COMMENT => P_USER_COMMENT
1958: ,P_ACTION => 'RESUBMIT'
1959: );
1960: hr_utility.set_location('Leaving: '|| l_proc,10);
1961: Exception
1962: when OTHERS then
1963: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1964: raise;

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

1959: );
1960: hr_utility.set_location('Leaving: '|| l_proc,10);
1961: Exception
1962: when OTHERS then
1963: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1964: raise;
1965: End ARCHIVE_RESUBMIT;
1966:
1967: Procedure ARCHIVE_SFL

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

1974: l_proc constant varchar2(100) := g_package || ' ARCHIVE_SFL';
1975:
1976: Begin
1977: --
1978: -- hr_utility.trace_on(null, 'TIGER');
1979: --g_debug := TRUE;
1980: --
1981: hr_utility.set_location('Entering: '|| l_proc,5);
1982: ARCHIVE_ACTION

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

1977: --
1978: -- hr_utility.trace_on(null, 'TIGER');
1979: --g_debug := TRUE;
1980: --
1981: hr_utility.set_location('Entering: '|| l_proc,5);
1982: ARCHIVE_ACTION
1983: (
1984: P_TRANSACTION_ID => P_TRANSACTION_ID
1985: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

1985: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID
1986: ,P_USER_NAME => P_USER_NAME
1987: ,P_ACTION => 'SFL'
1988: );
1989: hr_utility.set_location('Leaving: '|| l_proc,10);
1990: Exception
1991: when OTHERS then
1992: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1993: raise;

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

1988: );
1989: hr_utility.set_location('Leaving: '|| l_proc,10);
1990: Exception
1991: when OTHERS then
1992: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1993: raise;
1994: End ARCHIVE_SFL;
1995:
1996: Procedure ARCHIVE_APPROVE

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

2002: )
2003: IS
2004: l_proc constant varchar2(100) := g_package || ' ARCHIVE_APPROVE';
2005: Begin
2006: hr_utility.set_location('Entering: '|| l_proc,5);
2007: ARCHIVE_ACTION
2008: (
2009: P_TRANSACTION_ID => P_TRANSACTION_ID
2010: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2011: ,P_USER_NAME => P_USER_NAME
2012: ,P_USER_COMMENT => P_USER_COMMENT
2013: ,P_ACTION => 'APPROVED'
2014: );
2015: hr_utility.set_location('Leaving: '|| l_proc,10);
2016: Exception
2017: when OTHERS then
2018: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2019: raise;

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

2014: );
2015: hr_utility.set_location('Leaving: '|| l_proc,10);
2016: Exception
2017: when OTHERS then
2018: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2019: raise;
2020: End ARCHIVE_APPROVE;
2021:
2022: Procedure ARCHIVE_DELETE

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

2028: )
2029: IS
2030: l_proc constant varchar2(100) := g_package || ' ARCHIVE_DELETE';
2031: Begin
2032: hr_utility.set_location('Entering: '|| l_proc,5);
2033: ARCHIVE_ACTION
2034: (
2035: P_TRANSACTION_ID => P_TRANSACTION_ID
2036: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2037: ,P_USER_NAME => P_USER_NAME
2038: ,P_USER_COMMENT => P_USER_COMMENT
2039: ,P_ACTION => 'DELETED'
2040: );
2041: hr_utility.set_location('Leaving: '|| l_proc,10);
2042: Exception
2043: when OTHERS then
2044: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2045: raise;

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

2040: );
2041: hr_utility.set_location('Leaving: '|| l_proc,10);
2042: Exception
2043: when OTHERS then
2044: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2045: raise;
2046: End ARCHIVE_DELETE;
2047:
2048: Procedure ARCHIVE_REJECT

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

2054: )
2055: IS
2056: l_proc constant varchar2(100) := g_package || ' ARCHIVE_REJECT';
2057: Begin
2058: hr_utility.set_location('Entering: '|| l_proc,5);
2059: ARCHIVE_ACTION
2060: (
2061: P_TRANSACTION_ID => P_TRANSACTION_ID
2062: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2063: ,P_USER_NAME => P_USER_NAME
2064: ,P_USER_COMMENT => P_USER_COMMENT
2065: ,P_ACTION => 'REJECTED'
2066: );
2067: hr_utility.set_location('Leaving: '|| l_proc,10);
2068: Exception
2069: when OTHERS then
2070: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2071: raise;

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

2066: );
2067: hr_utility.set_location('Leaving: '|| l_proc,10);
2068: Exception
2069: when OTHERS then
2070: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2071: raise;
2072: End ARCHIVE_REJECT;
2073:
2074: Procedure ARCHIVE_RFC

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

2080: )
2081: IS
2082: l_proc constant varchar2(100) := g_package || ' ARCHIVE_RFC';
2083: Begin
2084: hr_utility.set_location('Entering: '|| l_proc,5);
2085: ARCHIVE_ACTION
2086: (
2087: P_TRANSACTION_ID => P_TRANSACTION_ID
2088: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2089: ,P_USER_NAME => P_USER_NAME
2090: ,P_USER_COMMENT => P_USER_COMMENT
2091: ,P_ACTION => 'RFC'
2092: );
2093: hr_utility.set_location('Leaving: '|| l_proc,10);
2094: Exception
2095: when OTHERS then
2096: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2097: raise;

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

2092: );
2093: hr_utility.set_location('Leaving: '|| l_proc,10);
2094: Exception
2095: when OTHERS then
2096: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2097: raise;
2098: End ARCHIVE_RFC;
2099:
2100: Procedure ARCHIVE_TRANSFER

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

2107: IS
2108: l_proc constant varchar2(100) := g_package || ' ARCHIVE_TRANSFER';
2109: Begin
2110: --
2111: -- hr_utility.trace_on(null, 'TIGER');
2112: --g_debug := TRUE;
2113: --
2114: hr_utility.set_location('Entering: '|| l_proc,5);
2115: ARCHIVE_ACTION

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

2110: --
2111: -- hr_utility.trace_on(null, 'TIGER');
2112: --g_debug := TRUE;
2113: --
2114: hr_utility.set_location('Entering: '|| l_proc,5);
2115: ARCHIVE_ACTION
2116: (
2117: P_TRANSACTION_ID => P_TRANSACTION_ID
2118: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2119: ,P_USER_NAME => P_USER_NAME
2120: ,P_USER_COMMENT => P_USER_COMMENT
2121: ,P_ACTION => 'TRANSFER'
2122: );
2123: hr_utility.set_location('Leaving: '|| l_proc,10);
2124: Exception
2125: when OTHERS then
2126: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2127: raise;

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

2122: );
2123: hr_utility.set_location('Leaving: '|| l_proc,10);
2124: Exception
2125: when OTHERS then
2126: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2127: raise;
2128: End ARCHIVE_TRANSFER;
2129:
2130: Procedure ARCHIVE_FORWARD

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

2136: )
2137: IS
2138: l_proc constant varchar2(100) := g_package || ' ARCHIVE_FORWARD';
2139: Begin
2140: hr_utility.set_location('Entering: '|| l_proc,5);
2141: ARCHIVE_ACTION
2142: (
2143: P_TRANSACTION_ID => P_TRANSACTION_ID
2144: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2145: ,P_USER_NAME => P_USER_NAME
2146: ,P_USER_COMMENT => P_USER_COMMENT
2147: ,P_ACTION => 'FORWARD'
2148: );
2149: hr_utility.set_location('Leaving: '|| l_proc,10);
2150: Exception
2151: when OTHERS then
2152: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2153: raise;

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

2148: );
2149: hr_utility.set_location('Leaving: '|| l_proc,10);
2150: Exception
2151: when OTHERS then
2152: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2153: raise;
2154: End ARCHIVE_FORWARD;
2155:
2156: Procedure ARCHIVE_REQ_MOREINFO

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

2162: )
2163: IS
2164: l_proc constant varchar2(100) := g_package || ' ARCHIVE_REQ_MOREINFO';
2165: Begin
2166: hr_utility.set_location('Entering: '|| l_proc,5);
2167: ARCHIVE_ACTION
2168: (
2169: P_TRANSACTION_ID => P_TRANSACTION_ID
2170: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2171: ,P_USER_NAME => P_USER_NAME
2172: ,P_USER_COMMENT => P_USER_COMMENT
2173: ,P_ACTION => 'QUESTION'
2174: );
2175: hr_utility.set_location('Leaving: '|| l_proc,10);
2176: Exception
2177: when OTHERS then
2178: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2179: raise;

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

2174: );
2175: hr_utility.set_location('Leaving: '|| l_proc,10);
2176: Exception
2177: when OTHERS then
2178: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2179: raise;
2180: End ARCHIVE_REQ_MOREINFO;
2181:
2182: Procedure ARCHIVE_ANSWER_MOREINFO

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

2188: )
2189: IS
2190: l_proc constant varchar2(100) := g_package || ' ARCHIVE_ANSWER_MOREINFO';
2191: Begin
2192: hr_utility.set_location('Entering: '|| l_proc,5);
2193: ARCHIVE_ACTION
2194: (
2195: P_TRANSACTION_ID => P_TRANSACTION_ID
2196: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2197: ,P_USER_NAME => P_USER_NAME
2198: ,P_USER_COMMENT => P_USER_COMMENT
2199: ,P_ACTION => 'ANSWER'
2200: );
2201: hr_utility.set_location('Leaving: '|| l_proc,10);
2202: Exception
2203: when OTHERS then
2204: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2205: raise;

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

2200: );
2201: hr_utility.set_location('Leaving: '|| l_proc,10);
2202: Exception
2203: when OTHERS then
2204: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2205: raise;
2206: End ARCHIVE_ANSWER_MOREINFO;
2207:
2208: Procedure CANCEL_ACTION

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

2213: l_proc constant varchar2(100) := g_package || ' CANCEL_ACTION';
2214: PRAGMA AUTONOMOUS_TRANSACTION;
2215: BEGIN
2216: --
2217: -- hr_utility.trace_on(null, 'TIGER');
2218: --g_debug := TRUE;
2219: --
2220: hr_utility.set_location('Entering: '|| l_proc,5);
2221:

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

2216: --
2217: -- hr_utility.trace_on(null, 'TIGER');
2218: --g_debug := TRUE;
2219: --
2220: hr_utility.set_location('Entering: '|| l_proc,5);
2221:
2222: RevertToLastSave
2223: (
2224: P_TRANSACTION_ID => P_TRANSACTION_ID

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

2222: RevertToLastSave
2223: (
2224: P_TRANSACTION_ID => P_TRANSACTION_ID
2225: );
2226: hr_utility.set_location('Leaving: '|| l_proc,10);
2227: commit;
2228: Exception
2229: when OTHERS then
2230: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

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

2226: hr_utility.set_location('Leaving: '|| l_proc,10);
2227: commit;
2228: Exception
2229: when OTHERS then
2230: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2231: ROLLBACK;
2232: RAISE;
2233: END CANCEL_ACTION;
2234:

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

2241: )
2242: IS
2243: l_proc constant varchar2(100) := g_package || ' ARCHIVE_TIMEOUT';
2244: Begin
2245: hr_utility.set_location('Entering: '|| l_proc,5);
2246: ARCHIVE_ACTION
2247: (
2248: P_TRANSACTION_ID => P_TRANSACTION_ID
2249: ,P_NOTIFICATION_ID => P_NOTIFICATION_ID

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

2250: ,P_USER_NAME => P_USER_NAME
2251: ,P_USER_COMMENT => P_USER_COMMENT
2252: ,P_ACTION => 'TIMEOUT'
2253: );
2254: hr_utility.set_location('Leaving: '|| l_proc,10);
2255: Exception
2256: when OTHERS then
2257: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2258: raise;

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

2253: );
2254: hr_utility.set_location('Leaving: '|| l_proc,10);
2255: Exception
2256: when OTHERS then
2257: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2258: raise;
2259: End ARCHIVE_TIMEOUT;
2260:
2261: END HR_TRANS_HISTORY_API;