DBA Data[Home] [Help]

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 282: hr_utility.set_location('Entering: '|| l_proc,5);

278: AND WAAV.NAME = name;
279:
280: BEGIN
281: --
282: hr_utility.set_location('Entering: '|| l_proc,5);
283: l_number_value := wf_engine.GetItemAttrNumber
284: (itemtype => itemtype
285: ,itemkey => itemkey
286: ,aname => 'CURRENT_PERSON_ID');

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

297: -- Bug 2476134 - 07/29/2002
298: -- Changed the <> null to IS NOT NULL.
299: IF l_text_value IS NOT NULL
300: THEN
301: hr_utility.trace('In (if l_text_value IS NOT NULL): '|| l_proc);
302: l_effective_date := trunc(
303: to_date(l_text_value, hr_transaction_ss.g_date_format)
304: );
305: ELSE

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

302: l_effective_date := trunc(
303: to_date(l_text_value, hr_transaction_ss.g_date_format)
304: );
305: ELSE
306: hr_utility.trace('In else of (if l_text_value IS NOT NULL): '|| l_proc);
307: -- Use sysdate if the wf item attribute contains null value
308: l_effective_date := trunc(sysdate);
309: END IF;
310:

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

364: ,itemkey => itemkey
365: ,aname => 'HR_TERM_SUP_FLAG'
366: ,avalue => 'Y');
367: --
368: hr_utility.set_location('Leaving: '|| l_proc,15);
369:
370: EXCEPTION
371: WHEN OTHERS THEN
372: resultout := null;

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

369:
370: EXCEPTION
371: WHEN OTHERS THEN
372: resultout := null;
373: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
374: WF_CORE.CONTEXT(g_package
375: ,'branch_on_subordinate_presence'
376: ,itemtype
377: ,itemkey

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

524:
525: BEGIN
526:
527:
528: hr_utility.set_location('Entering: ' || l_proc,5);
529:
530: -- Bug 2098595 Fix Begins: 12/03/2001
531: -- Need to switch the order of calling the api. We need to call
532: -- hr_termination_ss.update_pds_details first to set the flex segments

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

571: into l_business_group_id
572: from per_periods_of_service
573: where period_of_service_id = p_period_of_service_id;
574:
575: hr_utility.trace('checking FR legislation ' || l_proc);
576: --
577: l_legislation_code :=
578: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
579: --

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

587: end if;
588: end if;
589: --
590:
591: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);
592: hr_termination_ss.update_pds_details
593: (p_validate => 0
594: ,p_effective_date => p_effective_date
595: ,p_period_of_service_id => p_period_of_service_id

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

661:
662: -- Core HR API will not support update of field Rehire Recommendation
663: -- and Rehire Reason. Hence we make following call to Person API
664: -- to update the Fields.
665: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);
666: -- moved cursor definitions to new procedure , which can be called from
667: -- proces_api also.
668:
669: update_per_details(

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

677:
678: -- Fix for the bug 13846099 Ends
679:
680: -- Now actually call API
681: hr_utility.trace('Calling hr_ex_employee_api.actual_termination_emp ' || l_proc);
682:
683: hr_ex_employee_api.actual_termination_emp
684: (p_validate => false
685: ,p_effective_date => p_effective_date

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

748: END IF;
749: --
750: --
751:
752: hr_utility.set_location(' Leaving: ' || l_proc,10);
753: EXCEPTION
754:
755: WHEN OTHERS THEN
756:

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

767: -- ("HR"."PER_PERSON_LIST_CHANGES"."SECURITY_PROFILE_ID").
768:
769:
770: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
771: (p_single_error_message => hr_utility.get_message);
772: hr_utility.set_location('EXCEPTION '|| p_error_message|| ' :' || l_proc,575);
773: -- rollback the changes in case of exception
774: rollback to terminate_ee;
775: p_supervisor_warning := null;

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

768:
769:
770: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
771: (p_single_error_message => hr_utility.get_message);
772: hr_utility.set_location('EXCEPTION '|| p_error_message|| ' :' || l_proc,575);
773: -- rollback the changes in case of exception
774: rollback to terminate_ee;
775: p_supervisor_warning := null;
776: p_event_warning := null;

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

879: )
880: IS
881: l_proc constant varchar2(100) := g_package || ' update_pds_details';
882: BEGIN
883: hr_utility.set_location('Entering: '|| l_proc,5);
884: -- Call Actual API
885: hr_periods_of_service_api.update_pds_details
886: (p_validate => hr_java_conv_util_ss.get_boolean (p_number => p_validate)
887: ,p_effective_date => p_effective_date

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

945: ,p_pds_information28 => p_pds_information28
946: ,p_pds_information29 => p_pds_information29
947: ,p_pds_information30 => p_pds_information30);
948:
949: hr_utility.set_location('Leaving: '|| l_proc,10);
950:
951:
952: EXCEPTION
953: WHEN OTHERS THEN

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

950:
951:
952: EXCEPTION
953: WHEN OTHERS THEN
954: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
955: RAISE;
956:
957: END update_pds_details;
958:

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

1090: l_proc constant varchar2(100) := g_package || ' process_save';
1091:
1092: BEGIN
1093:
1094: hr_utility.set_location('Entering: '|| l_proc,5);
1095: ----------------------------------------------------------------------
1096: -- Save data to transaction table.
1097: ----------------------------------------------------------------------
1098:

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

1674: );
1675:
1676: IF ln_transaction_id IS NULL
1677: THEN
1678: hr_utility.trace('In (iF ln_transaction_id IS NULL): '|| l_proc);
1679: -------------------------------------------------------------------
1680: -- Create a new transaction
1681: -------------------------------------------------------------------
1682: hr_transaction_ss.start_transaction (

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

1711: );
1712:
1713: IF ln_trans_step_rows < 1
1714: THEN
1715: hr_utility.trace('In (IF ln_trans_step_rows < 1): '|| l_proc);
1716: --------------------------------------------------------------------
1717: -- There is no transaction step for this transaction.
1718: -- Create a step within this new transaction
1719: --------------------------------------------------------------------

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

1728: p_transaction_step_id => ln_transaction_step_id,
1729: p_object_version_number => ln_ovn
1730: );
1731: ELSE
1732: hr_utility.trace('In else of (IF ln_trans_step_rows < 1): '|| l_proc);
1733: --------------------------------------------------------------------
1734: -- There are transaction steps for this transaction.
1735: -- Get the Transaction Step ID for this activity.
1736: --------------------------------------------------------------------

Line 1792: hr_utility.trace('Called moveAllDirectReports from process_save');

1788: l_new_sup_asg_id is not null and
1789: l_login_person_id is not null
1790: ) then
1791:
1792: hr_utility.trace('Called moveAllDirectReports from process_save');
1793:
1794: moveAllDirectReports(
1795: p_validate => 'Y',
1796: p_item_type => p_item_type,

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

1808: end if;
1809: -- Quick Termination changes ends here
1810:
1811:
1812: hr_utility.set_location('Leaving: '|| l_proc,20);
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1816: RAISE; -- Raise error here relevant to the new tech stack.

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

1811:
1812: hr_utility.set_location('Leaving: '|| l_proc,20);
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1816: RAISE; -- Raise error here relevant to the new tech stack.
1817:
1818: END process_save;
1819:

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

1911: --
1912:
1913: BEGIN
1914:
1915: hr_utility.set_location('Entering: ' || l_proc,5 );
1916:
1917: -- The following is for SAVE_FOR_LATER code change.
1918: -- 1)When the Action page re-launch a suspended workflow process, it does
1919: -- a validation by calling the process_api with the new user entered

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

2015: l_legislation_code :=
2016: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);
2017: --
2018: if l_legislation_code = 'FR' then
2019: hr_utility.trace('In if l_legislation_code = FR'|| l_proc);
2020: if ld_actual_term_date is not null and
2021: (lt_term_flex(30) = hr_api.g_varchar2
2022: or lt_term_flex(30) is null ) then
2023: lt_term_flex(30)

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

2026: end if;
2027: end if;
2028:
2029: exception when others then
2030: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2031: raise;
2032: end;
2033:
2034: -- Bug 2098595 Fix Begins: 11/12/2001

Line 2222: hr_utility.trace('Called moveAllDirectReports from process_api');

2218: else
2219: l_validate := 'N';
2220: end if;
2221:
2222: hr_utility.trace('Called moveAllDirectReports from process_api');
2223:
2224: moveAllDirectReports(
2225: p_validate => l_validate,
2226: p_item_type => ItemType,

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

2237:
2238: end if;
2239: -- Quick Termination changes ends here
2240:
2241: hr_utility.set_location(' Leaving: ' || l_proc,15);
2242:
2243:
2244: EXCEPTION
2245: WHEN OTHERS THEN

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

2243:
2244: EXCEPTION
2245: WHEN OTHERS THEN
2246: l_err_msg := hr_java_conv_util_ss.get_formatted_error_message
2247: (p_single_error_message => hr_utility.get_message);
2248: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);
2249: rollback to ex_emp_savepoint;
2250: RAISE;
2251: END process_api;

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

2244: EXCEPTION
2245: WHEN OTHERS THEN
2246: l_err_msg := hr_java_conv_util_ss.get_formatted_error_message
2247: (p_single_error_message => hr_utility.get_message);
2248: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);
2249: rollback to ex_emp_savepoint;
2250: RAISE;
2251: END process_api;
2252:

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

2266: IS
2267: lrt_termination hr_termination_ss.rt_termination;
2268: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2269: BEGIN
2270: hr_utility.set_location('Entering: '|| l_proc,5);
2271: lrt_termination.notified_termination_date :=
2272: hr_transaction_api.get_date_value (
2273: p_transaction_step_id => p_transaction_step_id,
2274: p_name => 'P_NOTIFIED_TERMINATION_DATE'

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

2344: hr_transaction_api.get_varchar2_value (
2345: p_transaction_step_id => p_transaction_step_id,
2346: p_name => 'P_REHIRE_REASON'
2347: );
2348: hr_utility.set_location('Leaving: '|| l_proc,10);
2349: RETURN lrt_termination;
2350: EXCEPTION
2351: WHEN OTHERS THEN
2352: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

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

2348: hr_utility.set_location('Leaving: '|| l_proc,10);
2349: RETURN lrt_termination;
2350: EXCEPTION
2351: WHEN OTHERS THEN
2352: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2353: RAISE;
2354: END get_termination_details;
2355:
2356: /*

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

2370: l_proc constant varchar2(100) := g_package || 'get_term_flex_detail ';
2371: BEGIN
2372: ---- First 20 DFF Data
2373: ---- Next 30, DDF Data
2374: hr_utility.set_location('Entering: '|| l_proc,5);
2375: FOR ln_counter IN 1..20 LOOP
2376: lt_term_flex(ln_counter) := NULL;
2377: END LOOP;
2378: FOR ln_counter IN 1..20 LOOP

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

2396: p_name => 'P_PDS_INFORMATION' ||
2397: to_char(ln_counter - 20)
2398: );
2399: END LOOP;
2400: hr_utility.set_location('Leaving: '|| l_proc,10);
2401: RETURN lt_term_flex;
2402: END get_term_flex_detail;
2403:
2404:

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

2506: lv_date varchar2(200) default null;
2507: l_proc constant varchar2(100) := g_package || ' get_term_transaction';
2508:
2509: BEGIN
2510: hr_utility.set_location('Entering: '|| l_proc,5);
2511: --
2512: p_period_of_service_id:=
2513: hr_transaction_api.get_number_value
2514: (p_transaction_step_id => p_transaction_step_id

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

2858: hr_transaction_api.get_varchar2_value
2859: (p_transaction_step_id => p_transaction_step_id
2860: ,p_name => 'P_PDS_INFORMATION30');
2861: --
2862: hr_utility.set_location('Leaving: '|| l_proc,10);
2863: EXCEPTION
2864: WHEN OTHERS THEN
2865: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2866: p_period_of_service_id := null;

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

2861: --
2862: hr_utility.set_location('Leaving: '|| l_proc,10);
2863: EXCEPTION
2864: WHEN OTHERS THEN
2865: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2866: p_period_of_service_id := null;
2867: p_object_version_number := null;
2868: p_actual_termination_date := null;
2869: p_notified_termination_date := null;

Line 3265: hr_utility.trace('allowMultipleAsg = ' || allowMultipleAsg);

3261: --
3262: allowMultipleAsg := fnd_profile.value('HR_ALLOW_MULTIPLE_ASSIGNMENTS');
3263: xBgProfileValue := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
3264:
3265: hr_utility.trace('allowMultipleAsg = ' || allowMultipleAsg);
3266: hr_utility.trace('xBgProfileValue = ' || xBgProfileValue);
3267:
3268: if ( allowMultipleAsg is not null and allowMultipleAsg = 'Y' ) then
3269: lv_param_1 := 'Y';

Line 3266: hr_utility.trace('xBgProfileValue = ' || xBgProfileValue);

3262: allowMultipleAsg := fnd_profile.value('HR_ALLOW_MULTIPLE_ASSIGNMENTS');
3263: xBgProfileValue := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
3264:
3265: hr_utility.trace('allowMultipleAsg = ' || allowMultipleAsg);
3266: hr_utility.trace('xBgProfileValue = ' || xBgProfileValue);
3267:
3268: if ( allowMultipleAsg is not null and allowMultipleAsg = 'Y' ) then
3269: lv_param_1 := 'Y';
3270: lv_param_2 := 'N';

Line 3366: hr_utility.trace('In exception moveAllDirectReports !!');

3362: end if;
3363:
3364: exception
3365: when others then
3366: hr_utility.trace('In exception moveAllDirectReports !!');
3367: if ( p_validate = 'Y' ) then
3368: rollback to savepoint madr_sp;
3369: end if;
3370: raise;