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

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

32: ln_period_of_service_id number;
33: ln_new_object_number number;
34: l_proc constant varchar2(100) := g_package || ' update_object_version';
35: BEGIN
36: hr_utility.set_location('Entering: '|| l_proc,5);
37: ln_period_of_service_id :=
38: hr_transaction_api.get_number_value
39: (p_transaction_step_id => p_transaction_step_id
40: ,p_name => 'P_PERIOD_OF_SERVICE_ID');

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

56: ,p_name => 'P_OBJECT_VERSION_NUMBER'
57: ,p_value => ln_new_object_number);
58: END IF;
59:
60: hr_utility.set_location('Leaving: '|| l_proc,10);
61: END update_object_version;
62:
63: -- Bug 2098595 Fix Ends
64: --

Line 145: (p_single_error_message => hr_utility.get_message);

141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: l_err_msg := hr_java_conv_util_ss.get_formatted_error_message
145: (p_single_error_message => hr_utility.get_message);
146: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': '|| l_proc,560);
147: rollback TO update_person_details;
148: raise;
149: END update_per_details;

Line 146: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': '|| l_proc,560);

142: EXCEPTION
143: WHEN OTHERS THEN
144: l_err_msg := hr_java_conv_util_ss.get_formatted_error_message
145: (p_single_error_message => hr_utility.get_message);
146: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': '|| l_proc,560);
147: rollback TO update_person_details;
148: raise;
149: END update_per_details;
150:

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

263:
264:
265: BEGIN
266: --
267: hr_utility.set_location('Entering: '|| l_proc,5);
268: l_number_value := wf_engine.GetItemAttrNumber
269: (itemtype => itemtype
270: ,itemkey => itemkey
271: ,aname => 'CURRENT_PERSON_ID');

Line 286: hr_utility.trace('In (if l_text_value IS NOT NULL): '|| l_proc);

282: -- Bug 2476134 - 07/29/2002
283: -- Changed the <> null to IS NOT NULL.
284: IF l_text_value IS NOT NULL
285: THEN
286: hr_utility.trace('In (if l_text_value IS NOT NULL): '|| l_proc);
287: l_effective_date := trunc(
288: to_date(l_text_value, hr_transaction_ss.g_date_format)
289: );
290: ELSE

Line 291: hr_utility.trace('In else of (if l_text_value IS NOT NULL): '|| l_proc);

287: l_effective_date := trunc(
288: to_date(l_text_value, hr_transaction_ss.g_date_format)
289: );
290: ELSE
291: hr_utility.trace('In else of (if l_text_value IS NOT NULL): '|| l_proc);
292: -- Use sysdate if the wf item attribute contains null value
293: l_effective_date := trunc(sysdate);
294: END IF;
295:

Line 320: hr_utility.set_location('Leaving: '|| l_proc,15);

316: ,itemkey => itemkey
317: ,aname => 'HR_TERM_SUP_FLAG'
318: ,avalue => 'Y');
319: --
320: hr_utility.set_location('Leaving: '|| l_proc,15);
321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: resultout := null;

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

321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: resultout := null;
325: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
326: WF_CORE.CONTEXT(g_package
327: ,'branch_on_subordinate_presence'
328: ,itemtype
329: ,itemkey

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

476:
477: BEGIN
478:
479:
480: hr_utility.set_location('Entering: ' || l_proc,5);
481:
482: -- Bug 2098595 Fix Begins: 12/03/2001
483: -- Need to switch the order of calling the api. We need to call
484: -- hr_termination_ss.update_pds_details first to set the flex segments

Line 527: hr_utility.trace('checking FR legislation ' || l_proc);

523: into l_business_group_id
524: from per_periods_of_service
525: where period_of_service_id = p_period_of_service_id;
526:
527: hr_utility.trace('checking FR legislation ' || l_proc);
528: --
529: l_legislation_code :=
530: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
531: --

Line 543: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);

539: end if;
540: end if;
541: --
542:
543: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);
544: hr_termination_ss.update_pds_details
545: (p_validate => 0
546: ,p_effective_date => p_effective_date
547: ,p_period_of_service_id => p_period_of_service_id

Line 611: hr_utility.trace('Calling hr_ex_employee_api.actual_termination_emp ' || l_proc);

607: );
608:
609:
610: -- Now actually call API
611: hr_utility.trace('Calling hr_ex_employee_api.actual_termination_emp ' || l_proc);
612:
613: hr_ex_employee_api.actual_termination_emp
614: (p_validate => false
615: ,p_effective_date => p_effective_date

Line 658: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);

654: --
655: -- Core HR API will not support update of field Rehire Recommendation
656: -- and Rehire Reason. Hence we make following call to Person API
657: -- to update the Fields.
658: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);
659: -- moved cursor definitions to new procedure , which can be called from
660: -- proces_api also.
661: update_per_details(
662: p_validate => 0, -- false

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

691: END IF;
692: --
693: --
694:
695: hr_utility.set_location(' Leaving: ' || l_proc,10);
696: EXCEPTION
697:
698: WHEN OTHERS THEN
699:

Line 714: (p_single_error_message => hr_utility.get_message);

710: -- ("HR"."PER_PERSON_LIST_CHANGES"."SECURITY_PROFILE_ID").
711:
712:
713: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
714: (p_single_error_message => hr_utility.get_message);
715: hr_utility.set_location('EXCEPTION '|| p_error_message|| ' :' || l_proc,575);
716: -- rollback the changes in case of exception
717: rollback to terminate_ee;
718: p_supervisor_warning := null;

Line 715: hr_utility.set_location('EXCEPTION '|| p_error_message|| ' :' || l_proc,575);

711:
712:
713: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
714: (p_single_error_message => hr_utility.get_message);
715: hr_utility.set_location('EXCEPTION '|| p_error_message|| ' :' || l_proc,575);
716: -- rollback the changes in case of exception
717: rollback to terminate_ee;
718: p_supervisor_warning := null;
719: p_event_warning := null;

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

822: )
823: IS
824: l_proc constant varchar2(100) := g_package || ' update_pds_details';
825: BEGIN
826: hr_utility.set_location('Entering: '|| l_proc,5);
827: -- Call Actual API
828: hr_periods_of_service_api.update_pds_details
829: (p_validate => hr_java_conv_util_ss.get_boolean (p_number => p_validate)
830: ,p_effective_date => p_effective_date

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

888: ,p_pds_information28 => p_pds_information28
889: ,p_pds_information29 => p_pds_information29
890: ,p_pds_information30 => p_pds_information30);
891:
892: hr_utility.set_location('Leaving: '|| l_proc,10);
893:
894:
895: EXCEPTION
896: WHEN OTHERS THEN

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

893:
894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
898: RAISE;
899:
900: END update_pds_details;
901:

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

1018: ln_supervisor_count NUMBER;
1019: l_proc constant varchar2(100) := g_package || ' process_save';
1020: BEGIN
1021:
1022: hr_utility.set_location('Entering: '|| l_proc,5);
1023: ----------------------------------------------------------------------
1024: -- Save data to transaction table.
1025: ----------------------------------------------------------------------
1026:

Line 1606: hr_utility.trace('In (iF ln_transaction_id IS NULL): '|| l_proc);

1602: );
1603:
1604: IF ln_transaction_id IS NULL
1605: THEN
1606: hr_utility.trace('In (iF ln_transaction_id IS NULL): '|| l_proc);
1607: -------------------------------------------------------------------
1608: -- Create a new transaction
1609: -------------------------------------------------------------------
1610: hr_transaction_ss.start_transaction (

Line 1643: hr_utility.trace('In (IF ln_trans_step_rows < 1): '|| l_proc);

1639: );
1640:
1641: IF ln_trans_step_rows < 1
1642: THEN
1643: hr_utility.trace('In (IF ln_trans_step_rows < 1): '|| l_proc);
1644: --------------------------------------------------------------------
1645: -- There is no transaction step for this transaction.
1646: -- Create a step within this new transaction
1647: --------------------------------------------------------------------

Line 1660: hr_utility.trace('In else of (IF ln_trans_step_rows < 1): '|| l_proc);

1656: p_transaction_step_id => ln_transaction_step_id,
1657: p_object_version_number => ln_ovn
1658: );
1659: ELSE
1660: hr_utility.trace('In else of (IF ln_trans_step_rows < 1): '|| l_proc);
1661: --------------------------------------------------------------------
1662: -- There are transaction steps for this transaction.
1663: -- Get the Transaction Step ID for this activity.
1664: --------------------------------------------------------------------

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

1684: -- The code to check for existence of subordinates for the
1685: -- terminated employee has been moved to the new procedure
1686: -- branch_on_subordinate_presence.
1687:
1688: hr_utility.set_location('Leaving: '|| l_proc,20);
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1692: RAISE; -- Raise error here relevant to the new tech stack.

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

1687:
1688: hr_utility.set_location('Leaving: '|| l_proc,20);
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1692: RAISE; -- Raise error here relevant to the new tech stack.
1693:
1694: END process_save;
1695:

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

1770: l_err_msg long default null;
1771:
1772: BEGIN
1773:
1774: hr_utility.set_location('Entering: ' || l_proc,5 );
1775:
1776: -- The following is for SAVE_FOR_LATER code change.
1777: -- 1)When the Action page re-launch a suspended workflow process, it does
1778: -- a validation by calling the process_api with the new user entered

Line 1878: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);

1874: l_legislation_code :=
1875: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
1876: --
1877: if l_legislation_code = 'FR' then
1878: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);
1879: if ld_actual_term_date is not null and
1880: (lt_term_flex(30) = hr_api.g_varchar2
1881: or lt_term_flex(30) is null ) then
1882: lt_term_flex(30)

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

1885: end if;
1886: end if;
1887:
1888: exception when others then
1889: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1890: raise;
1891: end;
1892:
1893: -- Bug 2098595 Fix Begins: 11/12/2001

Line 2028: hr_utility.set_location(' Leaving: ' || l_proc,15);

2024:
2025: END IF;
2026: --end of call bug 3843399
2027:
2028: hr_utility.set_location(' Leaving: ' || l_proc,15);
2029:
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN

Line 2034: (p_single_error_message => hr_utility.get_message);

2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: l_err_msg := hr_java_conv_util_ss.get_formatted_error_message
2034: (p_single_error_message => hr_utility.get_message);
2035: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);
2036: rollback to ex_emp_savepoint;
2037: RAISE;
2038: END process_api;

Line 2035: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);

2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: l_err_msg := hr_java_conv_util_ss.get_formatted_error_message
2034: (p_single_error_message => hr_utility.get_message);
2035: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);
2036: rollback to ex_emp_savepoint;
2037: RAISE;
2038: END process_api;
2039:

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

2053: IS
2054: lrt_termination hr_termination_ss.rt_termination;
2055: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2056: BEGIN
2057: hr_utility.set_location('Entering: '|| l_proc,5);
2058: lrt_termination.notified_termination_date :=
2059: hr_transaction_api.get_date_value (
2060: p_transaction_step_id => p_transaction_step_id,
2061: p_name => 'P_NOTIFIED_TERMINATION_DATE'

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

2131: hr_transaction_api.get_varchar2_value (
2132: p_transaction_step_id => p_transaction_step_id,
2133: p_name => 'P_REHIRE_REASON'
2134: );
2135: hr_utility.set_location('Leaving: '|| l_proc,10);
2136: RETURN lrt_termination;
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

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

2135: hr_utility.set_location('Leaving: '|| l_proc,10);
2136: RETURN lrt_termination;
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2140: RAISE;
2141: END get_termination_details;
2142:
2143: /*

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

2157: l_proc constant varchar2(100) := g_package || 'get_term_flex_detail ';
2158: BEGIN
2159: ---- First 20 DFF Data
2160: ---- Next 30, DDF Data
2161: hr_utility.set_location('Entering: '|| l_proc,5);
2162: FOR ln_counter IN 1..20 LOOP
2163: lt_term_flex(ln_counter) := NULL;
2164: END LOOP;
2165: FOR ln_counter IN 1..20 LOOP

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

2183: p_name => 'P_PDS_INFORMATION' ||
2184: to_char(ln_counter - 20)
2185: );
2186: END LOOP;
2187: hr_utility.set_location('Leaving: '|| l_proc,10);
2188: RETURN lt_term_flex;
2189: END get_term_flex_detail;
2190:
2191:

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

2293: lv_date varchar2(200) default null;
2294: l_proc constant varchar2(100) := g_package || ' get_term_transaction';
2295:
2296: BEGIN
2297: hr_utility.set_location('Entering: '|| l_proc,5);
2298: --
2299: p_period_of_service_id:=
2300: hr_transaction_api.get_number_value
2301: (p_transaction_step_id => p_transaction_step_id

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

2645: hr_transaction_api.get_varchar2_value
2646: (p_transaction_step_id => p_transaction_step_id
2647: ,p_name => 'P_PDS_INFORMATION30');
2648: --
2649: hr_utility.set_location('Leaving: '|| l_proc,10);
2650: EXCEPTION
2651: WHEN OTHERS THEN
2652: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2653: p_period_of_service_id := null;

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

2648: --
2649: hr_utility.set_location('Leaving: '|| l_proc,10);
2650: EXCEPTION
2651: WHEN OTHERS THEN
2652: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2653: p_period_of_service_id := null;
2654: p_object_version_number := null;
2655: p_actual_termination_date := null;
2656: p_notified_termination_date := null;