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

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pyjpdefs.pkb 120.8 2011/02/25 09:40:17 keyazawa ship $ */
3: --
4: -- Constants
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: c_package constant varchar2(31) := 'pay_jp_def_ss.';
8: c_def_elm constant number := hr_jp_id_pkg.element_type_id('YEA_DEP_EXM_PROC', null, 'JP');
9: c_disability_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'DISABLE_TYPE');
10: c_aged_type_iv constant varchar2(30) := hr_jp_id_pkg.input_value_id(c_def_elm, 'ELDER_TYPE');

Line 325: hr_utility.set_location('Entering : ' || c_proc, 10);

321: l_eed date;
322: l_warning boolean;
323: l_element_link_id number;
324: begin
325: hr_utility.set_location('Entering : ' || c_proc, 10);
326: hr_utility.trace('status : ' || p_rec.status);
327: --
328: if p_rec.status = 'I' then
329: l_element_link_id := hr_entry_api.get_link(

Line 326: hr_utility.trace('status : ' || p_rec.status);

322: l_warning boolean;
323: l_element_link_id number;
324: begin
325: hr_utility.set_location('Entering : ' || c_proc, 10);
326: hr_utility.trace('status : ' || p_rec.status);
327: --
328: if p_rec.status = 'I' then
329: l_element_link_id := hr_entry_api.get_link(
330: p_assignment_id => p_rec.assignment_id,

Line 449: hr_utility.set_location('Leaving : ' || c_proc, 20);

445: P_EE_OBJECT_VERSION_NUMBER => p_rec.ee_object_version_number);
446: end if;
447: end if;
448: --
449: hr_utility.set_location('Leaving : ' || c_proc, 20);
450: end transfer_entry;
451: -- |---------------------------------------------------------------------------|
452: -- |----------------------------< rollback_entry >-----------------------------|
453: -- |---------------------------------------------------------------------------|

Line 466: hr_utility.set_location('Entering : ' || c_proc, 10);

462: l_warning boolean;
463: l_vsd date;
464: l_ved date;
465: begin
466: hr_utility.set_location('Entering : ' || c_proc, 10);
467: hr_utility.trace('status : ' || p_rec.status);
468: --
469: if p_rec.status = 'I' then
470: pay_element_entry_api.delete_element_entry(

Line 467: hr_utility.trace('status : ' || p_rec.status);

463: l_vsd date;
464: l_ved date;
465: begin
466: hr_utility.set_location('Entering : ' || c_proc, 10);
467: hr_utility.trace('status : ' || p_rec.status);
468: --
469: if p_rec.status = 'I' then
470: pay_element_entry_api.delete_element_entry(
471: p_validate => false,

Line 576: hr_utility.set_location('Leaving : ' || c_proc, 20);

572: P_STATUS => p_rec.status,
573: P_EE_OBJECT_VERSION_NUMBER => p_rec.ee_object_version_number);
574: end if;
575: --
576: hr_utility.set_location('Leaving : ' || c_proc, 20);
577: end rollback_entry;
578: -- |---------------------------------------------------------------------------|
579: -- |-----------------------------< transfer_dep >------------------------------|
580: -- |---------------------------------------------------------------------------|

Line 588: hr_utility.set_location('Entering : ' || c_proc, 10);

584: l_esd date;
585: l_eed date;
586: l_effective_date date;
587: begin
588: hr_utility.set_location('Entering : ' || c_proc, 10);
589: hr_utility.trace('status : ' || p_rec.status);
590: --
591: if p_rec.status = 'I' then
592: hr_contact_extra_info_api.create_contact_extra_info(

Line 589: hr_utility.trace('status : ' || p_rec.status);

585: l_eed date;
586: l_effective_date date;
587: begin
588: hr_utility.set_location('Entering : ' || c_proc, 10);
589: hr_utility.trace('status : ' || p_rec.status);
590: --
591: if p_rec.status = 'I' then
592: hr_contact_extra_info_api.create_contact_extra_info(
593: p_validate => false,

Line 674: hr_utility.set_location('Leaving : ' || c_proc, 20);

670: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
671: end if;
672: end if;
673: --
674: hr_utility.set_location('Leaving : ' || c_proc, 20);
675: end transfer_dep;
676: -- |---------------------------------------------------------------------------|
677: -- |-----------------------------< rollback_dep >------------------------------|
678: -- |---------------------------------------------------------------------------|

Line 687: hr_utility.set_location('Entering : ' || c_proc, 10);

683: l_eed date;
684: l_vsd date;
685: l_ved date;
686: begin
687: hr_utility.set_location('Entering : ' || c_proc, 10);
688: hr_utility.trace('status : ' || p_rec.status);
689: --
690: if p_rec.status = 'I' then
691: hr_contact_extra_info_api.delete_contact_extra_info(

Line 688: hr_utility.trace('status : ' || p_rec.status);

684: l_vsd date;
685: l_ved date;
686: begin
687: hr_utility.set_location('Entering : ' || c_proc, 10);
688: hr_utility.trace('status : ' || p_rec.status);
689: --
690: if p_rec.status = 'I' then
691: hr_contact_extra_info_api.delete_contact_extra_info(
692: p_validate => false,

Line 806: hr_utility.set_location('Leaving : ' || c_proc, 20);

802: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
803: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
804: end if;
805: --
806: hr_utility.set_location('Leaving : ' || c_proc, 20);
807: end rollback_dep;
808: -- |---------------------------------------------------------------------------|
809: -- |----------------------------< transfer_dep_oe >----------------------------|
810: -- |---------------------------------------------------------------------------|

Line 818: hr_utility.set_location('Entering : ' || c_proc, 10);

814: l_esd date;
815: l_eed date;
816: l_effective_date date;
817: begin
818: hr_utility.set_location('Entering : ' || c_proc, 10);
819: hr_utility.trace('status : ' || p_rec.status);
820: --
821: if p_rec.status = 'I' then
822: hr_contact_extra_info_api.create_contact_extra_info(

Line 819: hr_utility.trace('status : ' || p_rec.status);

815: l_eed date;
816: l_effective_date date;
817: begin
818: hr_utility.set_location('Entering : ' || c_proc, 10);
819: hr_utility.trace('status : ' || p_rec.status);
820: --
821: if p_rec.status = 'I' then
822: hr_contact_extra_info_api.create_contact_extra_info(
823: p_validate => false,

Line 895: hr_utility.set_location('Leaving : ' || c_proc, 20);

891: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
892: end if;
893: end if;
894: --
895: hr_utility.set_location('Leaving : ' || c_proc, 20);
896: end transfer_dep_oe;
897: -- |---------------------------------------------------------------------------|
898: -- |-----------------------------< rollback_dep >------------------------------|
899: -- |---------------------------------------------------------------------------|

Line 908: hr_utility.set_location('Entering : ' || c_proc, 10);

904: l_eed date;
905: l_vsd date;
906: l_ved date;
907: begin
908: hr_utility.set_location('Entering : ' || c_proc, 10);
909: hr_utility.trace('status : ' || p_rec.status);
910: --
911: if p_rec.status = 'I' then
912: hr_contact_extra_info_api.delete_contact_extra_info(

Line 909: hr_utility.trace('status : ' || p_rec.status);

905: l_vsd date;
906: l_ved date;
907: begin
908: hr_utility.set_location('Entering : ' || c_proc, 10);
909: hr_utility.trace('status : ' || p_rec.status);
910: --
911: if p_rec.status = 'I' then
912: hr_contact_extra_info_api.delete_contact_extra_info(
913: p_validate => false,

Line 1021: hr_utility.set_location('Leaving : ' || c_proc, 20);

1017: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1018: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
1019: end if;
1020: --
1021: hr_utility.set_location('Leaving : ' || c_proc, 20);
1022: end rollback_dep_oe;
1023: -- |---------------------------------------------------------------------------|
1024: -- |----------------------------< transfer_dep_os >----------------------------|
1025: -- |---------------------------------------------------------------------------|

Line 1033: hr_utility.set_location('Entering : ' || c_proc, 10);

1029: l_esd date;
1030: l_eed date;
1031: l_effective_date date;
1032: begin
1033: hr_utility.set_location('Entering : ' || c_proc, 10);
1034: hr_utility.trace('status : ' || p_rec.status);
1035: --
1036: if p_rec.status = 'I' then
1037: hr_contact_extra_info_api.create_contact_extra_info(

Line 1034: hr_utility.trace('status : ' || p_rec.status);

1030: l_eed date;
1031: l_effective_date date;
1032: begin
1033: hr_utility.set_location('Entering : ' || c_proc, 10);
1034: hr_utility.trace('status : ' || p_rec.status);
1035: --
1036: if p_rec.status = 'I' then
1037: hr_contact_extra_info_api.create_contact_extra_info(
1038: p_validate => false,

Line 1109: hr_utility.set_location('Leaving : ' || c_proc, 20);

1105: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
1106: end if;
1107: end if;
1108: --
1109: hr_utility.set_location('Leaving : ' || c_proc, 20);
1110: end transfer_dep_os;
1111: -- |---------------------------------------------------------------------------|
1112: -- |-----------------------------< rollback_dep_os >---------------------------|
1113: -- |---------------------------------------------------------------------------|

Line 1122: hr_utility.set_location('Entering : ' || c_proc, 10);

1118: l_eed date;
1119: l_vsd date;
1120: l_ved date;
1121: begin
1122: hr_utility.set_location('Entering : ' || c_proc, 10);
1123: hr_utility.trace('status : ' || p_rec.status);
1124: --
1125: if p_rec.status = 'I' then
1126: hr_contact_extra_info_api.delete_contact_extra_info(

Line 1123: hr_utility.trace('status : ' || p_rec.status);

1119: l_vsd date;
1120: l_ved date;
1121: begin
1122: hr_utility.set_location('Entering : ' || c_proc, 10);
1123: hr_utility.trace('status : ' || p_rec.status);
1124: --
1125: if p_rec.status = 'I' then
1126: hr_contact_extra_info_api.delete_contact_extra_info(
1127: p_validate => false,

Line 1236: hr_utility.set_location('Leaving : ' || c_proc, 20);

1232: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1233: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
1234: end if;
1235: --
1236: hr_utility.set_location('Leaving : ' || c_proc, 20);
1237: end rollback_dep_os;
1238: --
1239: -- -------------------------------------------------------------------------
1240: -- transfer_entry_os

Line 1256: hr_utility.set_location('Entering : '|| c_proc, 10);

1252: l_element_link_id number;
1253: --
1254: begin
1255: --
1256: hr_utility.set_location('Entering : '|| c_proc, 10);
1257: hr_utility.trace('status : '|| p_rec.status);
1258: --
1259: if p_rec.status = 'I' then
1260: --

Line 1257: hr_utility.trace('status : '|| p_rec.status);

1253: --
1254: begin
1255: --
1256: hr_utility.set_location('Entering : '|| c_proc, 10);
1257: hr_utility.trace('status : '|| p_rec.status);
1258: --
1259: if p_rec.status = 'I' then
1260: --
1261: l_element_link_id := hr_entry_api.get_link(

Line 1319: hr_utility.set_location('Leaving : ' || c_proc, 20);

1315: end if;
1316: --
1317: end if;
1318: --
1319: hr_utility.set_location('Leaving : ' || c_proc, 20);
1320: --
1321: end transfer_entry_os;
1322: --
1323: -- -------------------------------------------------------------------------

Line 1341: hr_utility.set_location('Entering : '|| c_proc, 10);

1337: l_ved date;
1338: --
1339: begin
1340: --
1341: hr_utility.set_location('Entering : '|| c_proc, 10);
1342: hr_utility.trace('status : '|| p_rec.status);
1343: --
1344: if p_rec.status = 'I' then
1345: --

Line 1342: hr_utility.trace('status : '|| p_rec.status);

1338: --
1339: begin
1340: --
1341: hr_utility.set_location('Entering : '|| c_proc, 10);
1342: hr_utility.trace('status : '|| p_rec.status);
1343: --
1344: if p_rec.status = 'I' then
1345: --
1346: pay_element_entry_api.delete_element_entry(

Line 1430: hr_utility.set_location('Leaving : ' || c_proc, 20);

1426: P_EE_OBJECT_VERSION_NUMBER => p_rec.ee_object_version_number);
1427: --
1428: end if;
1429: --
1430: hr_utility.set_location('Leaving : ' || c_proc, 20);
1431: --
1432: end rollback_entry_os;
1433: --
1434: -- |---------------------------------------------------------------------------|

Line 1802: hr_utility.set_location(l_proc,0);

1798: --
1799: begin
1800: --
1801: if g_debug then
1802: hr_utility.set_location(l_proc,0);
1803: end if;
1804: --
1805: l_action_information_id := null;
1806: l_object_version_number := null;

Line 1885: hr_utility.set_location(l_proc,10);

1881: --
1882: end loop;
1883: --
1884: if g_debug then
1885: hr_utility.set_location(l_proc,10);
1886: end if;
1887: --
1888: pay_jp_def_api.create_entry(
1889: P_ASSIGNMENT_ACTION_ID => p_assignment_action_id,

Line 1928: hr_utility.set_location(l_proc,15);

1924: --
1925: if to_number(to_char(p_effective_date,'YYYY')) >= 2011 then
1926: --
1927: if g_debug then
1928: hr_utility.set_location(l_proc,15);
1929: end if;
1930: --
1931: l_action_information_id := null;
1932: l_object_version_number := null;

Line 1946: hr_utility.set_location(l_proc,20);

1942: --
1943: end if;
1944: --
1945: if g_debug then
1946: hr_utility.set_location(l_proc,20);
1947: end if;
1948: --
1949: l_action_information_id := null;
1950: l_object_version_number := null;

Line 1957: hr_utility.set_location(l_proc,30);

1953: fetch csr_emp into l_csr_emp;
1954: close csr_emp;
1955: --
1956: if g_debug then
1957: hr_utility.set_location(l_proc,30);
1958: hr_utility.trace('person_id : '||to_char(l_csr_emp.person_id));
1959: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1960: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1961: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);

Line 1958: hr_utility.trace('person_id : '||to_char(l_csr_emp.person_id));

1954: close csr_emp;
1955: --
1956: if g_debug then
1957: hr_utility.set_location(l_proc,30);
1958: hr_utility.trace('person_id : '||to_char(l_csr_emp.person_id));
1959: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1960: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1961: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1962: end if;

Line 1959: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);

1955: --
1956: if g_debug then
1957: hr_utility.set_location(l_proc,30);
1958: hr_utility.trace('person_id : '||to_char(l_csr_emp.person_id));
1959: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1960: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1961: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1962: end if;
1963: --

Line 1960: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);

1956: if g_debug then
1957: hr_utility.set_location(l_proc,30);
1958: hr_utility.trace('person_id : '||to_char(l_csr_emp.person_id));
1959: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1960: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1961: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1962: end if;
1963: --
1964: open csr_household_head(l_csr_emp.person_id);

Line 1961: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);

1957: hr_utility.set_location(l_proc,30);
1958: hr_utility.trace('person_id : '||to_char(l_csr_emp.person_id));
1959: hr_utility.trace('employee_number : '||l_csr_emp.employee_number);
1960: hr_utility.trace('last_name_kana : '||l_csr_emp.last_name_kana);
1961: hr_utility.trace('first_name_kana : '||l_csr_emp.first_name_kana);
1962: end if;
1963: --
1964: open csr_household_head(l_csr_emp.person_id);
1965: fetch csr_household_head into l_csr_household_head;

Line 1969: hr_utility.set_location(l_proc,40);

1965: fetch csr_household_head into l_csr_household_head;
1966: close csr_household_head;
1967: --
1968: if g_debug then
1969: hr_utility.set_location(l_proc,40);
1970: hr_utility.trace('contact_relationship_id : '||to_char(l_csr_household_head.contact_relationship_id));
1971: end if;
1972: --
1973: open csr_married_flag(l_csr_emp.person_id);

Line 1970: hr_utility.trace('contact_relationship_id : '||to_char(l_csr_household_head.contact_relationship_id));

1966: close csr_household_head;
1967: --
1968: if g_debug then
1969: hr_utility.set_location(l_proc,40);
1970: hr_utility.trace('contact_relationship_id : '||to_char(l_csr_household_head.contact_relationship_id));
1971: end if;
1972: --
1973: open csr_married_flag(l_csr_emp.person_id);
1974: fetch csr_married_flag into l_csr_married_flag;

Line 1978: hr_utility.set_location(l_proc,50);

1974: fetch csr_married_flag into l_csr_married_flag;
1975: close csr_married_flag;
1976: --
1977: if g_debug then
1978: hr_utility.set_location(l_proc,50);
1979: hr_utility.trace('married_flag : '||to_char(l_csr_married_flag.married_flag));
1980: end if;
1981: --
1982: --

Line 1979: hr_utility.trace('married_flag : '||to_char(l_csr_married_flag.married_flag));

1975: close csr_married_flag;
1976: --
1977: if g_debug then
1978: hr_utility.set_location(l_proc,50);
1979: hr_utility.trace('married_flag : '||to_char(l_csr_married_flag.married_flag));
1980: end if;
1981: --
1982: --
1983: -- If widower, change the widow_type from "1" to "3".

Line 2009: hr_utility.set_location(l_proc,60);

2005: --
2006: l_working_student_type := nvl(l_entry_rec.working_student_type_o, '0');
2007: --
2008: if g_debug then
2009: hr_utility.set_location(l_proc,60);
2010: hr_utility.trace('l_disability_type : '||l_disability_type);
2011: hr_utility.trace('l_aged_type : '||l_aged_type);
2012: hr_utility.trace('l_widow_type : '||l_widow_type);
2013: hr_utility.trace('l_working_student_type : '||l_working_student_type);

Line 2010: hr_utility.trace('l_disability_type : '||l_disability_type);

2006: l_working_student_type := nvl(l_entry_rec.working_student_type_o, '0');
2007: --
2008: if g_debug then
2009: hr_utility.set_location(l_proc,60);
2010: hr_utility.trace('l_disability_type : '||l_disability_type);
2011: hr_utility.trace('l_aged_type : '||l_aged_type);
2012: hr_utility.trace('l_widow_type : '||l_widow_type);
2013: hr_utility.trace('l_working_student_type : '||l_working_student_type);
2014: end if;

Line 2011: hr_utility.trace('l_aged_type : '||l_aged_type);

2007: --
2008: if g_debug then
2009: hr_utility.set_location(l_proc,60);
2010: hr_utility.trace('l_disability_type : '||l_disability_type);
2011: hr_utility.trace('l_aged_type : '||l_aged_type);
2012: hr_utility.trace('l_widow_type : '||l_widow_type);
2013: hr_utility.trace('l_working_student_type : '||l_working_student_type);
2014: end if;
2015: --

Line 2012: hr_utility.trace('l_widow_type : '||l_widow_type);

2008: if g_debug then
2009: hr_utility.set_location(l_proc,60);
2010: hr_utility.trace('l_disability_type : '||l_disability_type);
2011: hr_utility.trace('l_aged_type : '||l_aged_type);
2012: hr_utility.trace('l_widow_type : '||l_widow_type);
2013: hr_utility.trace('l_working_student_type : '||l_working_student_type);
2014: end if;
2015: --
2016: if to_number(to_char(p_effective_date,'YYYY')) >= 2011 then

Line 2013: hr_utility.trace('l_working_student_type : '||l_working_student_type);

2009: hr_utility.set_location(l_proc,60);
2010: hr_utility.trace('l_disability_type : '||l_disability_type);
2011: hr_utility.trace('l_aged_type : '||l_aged_type);
2012: hr_utility.trace('l_widow_type : '||l_widow_type);
2013: hr_utility.trace('l_working_student_type : '||l_working_student_type);
2014: end if;
2015: --
2016: if to_number(to_char(p_effective_date,'YYYY')) >= 2011 then
2017: --

Line 2034: hr_utility.set_location(l_proc,70);

2030: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(p_assignment_id));
2031: l_itax_organization_id := pay_balance_pkg.run_db_item(c_org_iv_name,g_leg_business_group_id,g_legislation_code);
2032: --
2033: if g_debug then
2034: hr_utility.set_location(l_proc,70);
2035: end if;
2036: --
2037: open csr_emp_address(l_csr_emp.district_code);
2038: fetch csr_emp_address into l_csr_emp_address;

Line 2063: hr_utility.set_location(l_proc,80);

2059: --
2060: end loop;
2061: --
2062: if g_debug then
2063: hr_utility.set_location(l_proc,80);
2064: end if;
2065: --
2066: l_action_information_id := null;
2067: l_object_version_number := null;

Line 2083: hr_utility.set_location(l_proc,90);

2079: p_action_information_id => l_action_information_id,
2080: p_object_version_number => l_object_version_number);
2081: --
2082: if g_debug then
2083: hr_utility.set_location(l_proc,90);
2084: end if;
2085: --
2086: end if;
2087: --

Line 2089: hr_utility.set_location(l_proc,100);

2085: --
2086: end if;
2087: --
2088: if g_debug then
2089: hr_utility.set_location(l_proc,100);
2090: end if;
2091: --
2092: pay_jp_def_api.create_emp(
2093: P_ASSIGNMENT_ACTION_ID => p_assignment_action_id,

Line 2126: hr_utility.set_location(l_proc,110);

2122: P_ACTION_INFORMATION_ID => l_action_information_id,
2123: P_OBJECT_VERSION_NUMBER => l_object_version_number);
2124: --
2125: if g_debug then
2126: hr_utility.set_location(l_proc,110);
2127: end if;
2128: --
2129: for l_rec in csr_dep(l_csr_emp.person_id) loop
2130: --

Line 2178: hr_utility.set_location(l_proc,120);

2174: --
2175: end loop;
2176: --
2177: if g_debug then
2178: hr_utility.set_location(l_proc,120);
2179: end if;
2180: --
2181: for l_rec in csr_dep_oe(l_csr_emp.person_id) loop
2182: --

Line 2229: hr_utility.set_location(l_proc,130);

2225: --
2226: end loop;
2227: --
2228: if g_debug then
2229: hr_utility.set_location(l_proc,130);
2230: end if;
2231: --
2232: if to_number(to_char(p_effective_date,'YYYY')) < 2011 then
2233: --

Line 2235: hr_utility.set_location(l_proc,140);

2231: --
2232: if to_number(to_char(p_effective_date,'YYYY')) < 2011 then
2233: --
2234: if g_debug then
2235: hr_utility.set_location(l_proc,140);
2236: end if;
2237: --
2238: for l_rec in csr_dep_os(l_csr_emp.person_id) loop
2239: --

Line 2282: hr_utility.set_location(l_proc,1000);

2278: --
2279: end if;
2280: --
2281: if g_debug then
2282: hr_utility.set_location(l_proc,1000);
2283: end if;
2284: --
2285: end archive_default;
2286: --

Line 2300: hr_utility.set_location('Entering : ' || c_proc, 10);

2296: l_assact_rec pay_jp_def_assact_v%rowtype;
2297: --
2298: begin
2299: --
2300: hr_utility.set_location('Entering : ' || c_proc, 10);
2301: --
2302: lock_assact(p_action_information_id, p_object_version_number, g_business_group_id, l_assact_rec);
2303: --
2304: check_submission_period(p_action_information_id);

Line 2329: hr_utility.set_location('Leaving : ' || c_proc, 20);

2325: P_TRANSACTION_STATUS => l_assact_rec.transaction_status);
2326: --
2327: p_object_version_number := l_assact_rec.object_version_number;
2328: --
2329: hr_utility.set_location('Leaving : ' || c_proc, 20);
2330: --
2331: end do_init;
2332: --
2333: procedure do_init(

Line 2418: hr_utility.set_location('Entering : ' || c_proc, 10);

2414: order by decode(contact_type, 'S', 1, 2), date_of_birth, last_name_kana, first_name_kana;
2415: --
2416: begin
2417: --
2418: hr_utility.set_location('Entering : ' || c_proc, 10);
2419: --
2420: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
2421: --
2422: l_submission_date := check_submission_period(p_action_information_id);

Line 2588: hr_utility.set_location('Leaving : ' || c_proc, 20);

2584: P_USER_COMMENTS => p_user_comments);
2585: --
2586: p_object_version_number := l_assact_rec.object_version_number;
2587: --
2588: hr_utility.set_location('Leaving : ' || c_proc, 20);
2589: --
2590: end do_finalize;
2591: --
2592: procedure do_finalize(

Line 2636: hr_utility.set_location('Entering : ' || c_proc, 10);

2632: l_business_group_id number;
2633: --
2634: l_assact_rec pay_jp_def_assact_v%rowtype;
2635: begin
2636: hr_utility.set_location('Entering : ' || c_proc, 10);
2637: --
2638: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
2639: --
2640: check_submission_period(p_action_information_id);

Line 2671: hr_utility.set_location('Leaving : ' || c_proc, 20);

2667: P_ADMIN_COMMENTS => p_admin_comments);
2668: --
2669: p_object_version_number := l_assact_rec.object_version_number;
2670: --
2671: hr_utility.set_location('Leaving : ' || c_proc, 20);
2672: end do_reject;
2673: --
2674: procedure do_reject(
2675: p_action_information_id in number,

Line 2718: hr_utility.set_location('Entering : ' || c_proc, 10);

2714: l_business_group_id number;
2715: --
2716: l_assact_rec pay_jp_def_assact_v%rowtype;
2717: begin
2718: hr_utility.set_location('Entering : ' || c_proc, 10);
2719: --
2720: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
2721: --
2722: check_submission_period(p_action_information_id);

Line 2747: hr_utility.set_location('Leaving : ' || c_proc, 20);

2743: P_ADMIN_COMMENTS => p_admin_comments);
2744: --
2745: p_object_version_number := l_assact_rec.object_version_number;
2746: --
2747: hr_utility.set_location('Leaving : ' || c_proc, 20);
2748: end do_return;
2749: --
2750: procedure do_return(
2751: p_action_information_id in number,

Line 2793: hr_utility.set_location('Entering : ' || c_proc, 10);

2789: l_business_group_id number;
2790: --
2791: l_assact_rec pay_jp_def_assact_v%rowtype;
2792: begin
2793: hr_utility.set_location('Entering : ' || c_proc, 10);
2794: --
2795: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
2796: --
2797: if l_assact_rec.transaction_status <> 'F' then

Line 2812: hr_utility.set_location('Leaving : ' || c_proc, 20);

2808: P_TRANSACTION_STATUS => l_assact_rec.transaction_status);
2809: --
2810: p_object_version_number := l_assact_rec.object_version_number;
2811: --
2812: hr_utility.set_location('Leaving : ' || c_proc, 20);
2813: end do_approve;
2814: --
2815: procedure do_approve(
2816: p_action_information_id in number,

Line 3005: hr_utility.set_location('Entering : ' || c_proc, 10);

3001: for update nowait;
3002: --
3003: begin
3004: --
3005: hr_utility.set_location('Entering : ' || c_proc, 10);
3006: --
3007: if p_create_session then
3008: g_business_group_id := null;
3009: end if;

Line 3129: hr_utility.set_location('Leaving : ' || c_proc, 20);

3125: P_TRANSFER_STATUS => l_assact_rec.transfer_status);
3126: --
3127: p_object_version_number := l_assact_rec.object_version_number;
3128: --
3129: hr_utility.set_location('Leaving : ' || c_proc, 20);
3130: --
3131: end do_transfer;
3132: --
3133: procedure do_transfer(

Line 3361: hr_utility.set_location('Entering : ' || c_proc, 10);

3357: for update nowait;
3358: --
3359: begin
3360: --
3361: hr_utility.set_location('Entering : ' || c_proc, 10);
3362: --
3363: if p_create_session then
3364: g_business_group_id := null;
3365: end if;

Line 3484: hr_utility.set_location('Leaving : ' || c_proc, 20);

3480: P_TRANSFER_STATUS => l_assact_rec.transfer_status);
3481: --
3482: p_object_version_number := l_assact_rec.object_version_number;
3483: --
3484: hr_utility.set_location('Leaving : ' || c_proc, 20);
3485: --
3486: end rollback_transfer;
3487: --
3488: procedure rollback_transfer(

Line 3606: hr_utility.set_location('Entering : ' || c_proc, 10);

3602: for update nowait;
3603: --
3604: begin
3605: --
3606: hr_utility.set_location('Entering : ' || c_proc, 10);
3607: --
3608: hr_api.mandatory_arg_error(c_proc, 'expiry_date', p_expiry_date);
3609: --
3610: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);

Line 3751: hr_utility.set_location('Leaving : ' || c_proc, 20);

3747: P_EXPIRY_DATE => l_assact_rec.expiry_date);
3748: --
3749: p_object_version_number := l_assact_rec.object_version_number;
3750: --
3751: hr_utility.set_location('Leaving : ' || c_proc, 20);
3752: --
3753: end do_expire;
3754: --
3755: procedure do_expire(

Line 3882: hr_utility.set_location('Entering : ' || c_proc, 10);

3878: for update nowait;
3879: --
3880: begin
3881: --
3882: hr_utility.set_location('Entering : ' || c_proc, 10);
3883: --
3884: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
3885: --
3886: if l_assact_rec.transfer_status <> 'E' then

Line 4012: hr_utility.set_location('Leaving : ' || c_proc, 20);

4008: P_EXPIRY_DATE => l_assact_rec.expiry_date);
4009: --
4010: p_object_version_number := l_assact_rec.object_version_number;
4011: --
4012: hr_utility.set_location('Leaving : ' || c_proc, 20);
4013: --
4014: end rollback_expire;
4015: --
4016: procedure rollback_expire(