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

Line 5: hr_utility.set_location(' Entering: p_rollback' , 10);

1: PACKAGE body ben_whatif_elig as
2: /* $Header: benwatif.pkb 120.0 2005/05/28 09:35:40 appldev noship $ */
3: procedure p_rollback is
4: begin
5: hr_utility.set_location(' Entering: p_rollback' , 10);
6: rollback;
7: hr_utility.set_location(' Leaving: p_rollback' , 10);
8: end;
9:

Line 7: hr_utility.set_location(' Leaving: p_rollback' , 10);

3: procedure p_rollback is
4: begin
5: hr_utility.set_location(' Entering: p_rollback' , 10);
6: rollback;
7: hr_utility.set_location(' Leaving: p_rollback' , 10);
8: end;
9:
10: --
11: -- This procedure returns the update mode appropriate

Line 28: hr_utility.set_location(' Entering: Get_DT_Upd_Mode' , 10);

24: l_update_override boolean := FALSE;
25: l_update_change_insert boolean := FALSE;
26: --
27: begin
28: hr_utility.set_location(' Entering: Get_DT_Upd_Mode' , 10);
29: --
30: -- Get the appropriate update mode.
31: --
32: DT_Api.Find_DT_Upd_Modes(p_effective_date => p_effective_date,

Line 49: hr_utility.set_location(' Leaving: Get_DT_Upd_Mode' , 10);

45: else
46: p_mode := 'CORRECTION';
47: end if;
48: --
49: hr_utility.set_location(' Leaving: Get_DT_Upd_Mode' , 10);
50: end;
51:
52: procedure WATIF_ABSENCE_ATTENDANCES_API(
53: p_person_id in number

Line 77: hr_utility.set_location(' Entering: WATIF_ABSENCE_ATTENDANCES_API' , 10);

73: per_abs_att_rec c_abs_att%rowtype;
74: --
75: l_rowid varchar2(50);
76: begin
77: hr_utility.set_location(' Entering: WATIF_ABSENCE_ATTENDANCES_API' , 10);
78: --
79: If p_DATE_START is null and p_DATE_END is null and
80: p_ABSENCE_ATTENDANCE_TYPE_ID is null and
81: p_ABS_ATTENDANCE_REASON_ID is null then

Line 294: hr_utility.set_location(' Leaving: WATIF_ABSENCE_ATTENDANCES_API' , 10);

290: X_ABS_INFORMATION30 => NULL
291: );
292: End If;
293: --
294: hr_utility.set_location(' Leaving: WATIF_ABSENCE_ATTENDANCES_API' , 10);
295: --
296: end;
297:
298:

Line 348: hr_utility.set_location(' Entering: WATIF_CONTACT_RELATIONSHIP_API' , 10);

344: --
345: l_personal_flag varchar2(1);
346: begin
347: --
348: hr_utility.set_location(' Entering: WATIF_CONTACT_RELATIONSHIP_API' , 10);
349: --
350: If p_DATE_START is null and p_DATE_END is null and
351: p_CONTACT_TYPE is null and p_PERSONAL_FLAG is null and
352: p_PERSONAL_FLAG is null and p_START_LIFE_REASON_ID is null and

Line 718: hr_utility.set_location(' Leaving: WATIF_CONTACT_RELATIONSHIP_API' , 10);

714: ,p_orig_hire_warning => l_orig_hire_warning
715: );
716: end if;
717: --
718: hr_utility.set_location(' Leaving: WATIF_CONTACT_RELATIONSHIP_API' , 10);
719: --
720: end;
721:
722: procedure WATIF_ADDRESSES_API(

Line 770: hr_utility.set_location(' Entering: WATIF_ADDRESSES_API' , 10);

766:
767: --
768: begin
769: --
770: hr_utility.set_location(' Entering: WATIF_ADDRESSES_API' , 10);
771: -- If postal code is null ????
772: If p_postal_code is null and p_PRIMARY_FLAG is null and
773: p_DATE_FROM is null and p_DATE_TO is null and
774: p_REGION_2 is null and p_ADDRESS_TYPE is null

Line 1013: hr_utility.set_location(' Leaving: WATIF_ADDRESSES_API' , 10);

1009: ,p_addr_attribute20 =>per_addr_rec.addr_attribute20
1010: ); */ --Bug 2856143 APi used now is the one being used on the form PERACADR.fmb
1011: End If;
1012: --
1013: hr_utility.set_location(' Leaving: WATIF_ADDRESSES_API' , 10);
1014: end;
1015:
1016:
1017:

Line 1105: hr_utility.set_location(' Entering: WATIF_ALL_ASSIGNMENTS_F_API' , 10);

1101: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1102: --
1103: begin
1104: --
1105: hr_utility.set_location(' Entering: WATIF_ALL_ASSIGNMENTS_F_API' , 10);
1106: --
1107: If p_PAY_BASIS_ID is null and
1108: p_EMPLOYMENT_CATEGORY is null and
1109: p_JOB_ID is null and

Line 1221: hr_utility.set_location('p_PAY_BASIS_ID = ' || p_PAY_BASIS_ID, 999);

1217: --
1218: -- Use hr_assignment_api.update_emp_asg_criteria to update
1219: -- above data.
1220: --
1221: hr_utility.set_location('p_PAY_BASIS_ID = ' || p_PAY_BASIS_ID, 999);
1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);
1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);

Line 1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);

1218: -- Use hr_assignment_api.update_emp_asg_criteria to update
1219: -- above data.
1220: --
1221: hr_utility.set_location('p_PAY_BASIS_ID = ' || p_PAY_BASIS_ID, 999);
1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);
1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);

Line 1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);

1219: -- above data.
1220: --
1221: hr_utility.set_location('p_PAY_BASIS_ID = ' || p_PAY_BASIS_ID, 999);
1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);
1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);

Line 1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);

1220: --
1221: hr_utility.set_location('p_PAY_BASIS_ID = ' || p_PAY_BASIS_ID, 999);
1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);
1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);

Line 1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);

1221: hr_utility.set_location('p_PAY_BASIS_ID = ' || p_PAY_BASIS_ID, 999);
1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);
1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);

Line 1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);

1222: hr_utility.set_location('p_EMPLOYMENT_CATEGORY = ' || p_EMPLOYMENT_CATEGORY, 999);
1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);

Line 1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);

1223: hr_utility.set_location('p_JOB_ID = ' || p_JOB_ID, 999);
1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);
1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);

Line 1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);

1224: hr_utility.set_location('p_PAYROLL_ID = ' || p_PAYROLL_ID, 999);
1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);
1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);
1232: hr_utility.set_location('p_PEOPLE_GROUP_ID = ' || p_PEOPLE_GROUP_ID, 999);

Line 1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);

1225: hr_utility.set_location('p_PRIMARY_FLAG = ' || p_PRIMARY_FLAG, 999);
1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);
1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);
1232: hr_utility.set_location('p_PEOPLE_GROUP_ID = ' || p_PEOPLE_GROUP_ID, 999);
1233: --

Line 1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);

1226: hr_utility.set_location('p_LOCATION_ID = ' || p_LOCATION_ID, 999);
1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);
1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);
1232: hr_utility.set_location('p_PEOPLE_GROUP_ID = ' || p_PEOPLE_GROUP_ID, 999);
1233: --
1234: open c_assign;

Line 1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);

1227: hr_utility.set_location('p_ASSIGNMENT_TYPE = ' || p_ASSIGNMENT_TYPE, 999);
1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);
1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);
1232: hr_utility.set_location('p_PEOPLE_GROUP_ID = ' || p_PEOPLE_GROUP_ID, 999);
1233: --
1234: open c_assign;
1235: fetch c_assign into per_assign_rec;

Line 1232: hr_utility.set_location('p_PEOPLE_GROUP_ID = ' || p_PEOPLE_GROUP_ID, 999);

1228: hr_utility.set_location('p_ORGANIZATION_ID = ' || p_ORGANIZATION_ID, 999);
1229: hr_utility.set_location('p_POSITION_ID = ' || p_POSITION_ID, 999);
1230: hr_utility.set_location('p_GRADE_ID = ' || p_GRADE_ID, 999);
1231: hr_utility.set_location('p_ASSIGNMENT_STATUS_TYPE_ID = ' || p_ASSIGNMENT_STATUS_TYPE_ID, 999);
1232: hr_utility.set_location('p_PEOPLE_GROUP_ID = ' || p_PEOPLE_GROUP_ID, 999);
1233: --
1234: open c_assign;
1235: fetch c_assign into per_assign_rec;
1236: if c_assign%notfound Then

Line 1606: hr_utility.set_location(' Leaving: WATIF_ALL_ASSIGNMENTS_F_API' , 10);

1602: ,p_other_manager_warning => l_other_manager_warning
1603: );
1604: --
1605: end if;
1606: hr_utility.set_location(' Leaving: WATIF_ALL_ASSIGNMENTS_F_API' , 10);
1607: end;
1608:
1609:
1610:

Line 1680: hr_utility.set_location(' Entering: WATIF_ALL_PEOPLE_F_API' , 10);

1676: l_upd_mode varchar2(25);
1677: --
1678: begin
1679: --
1680: hr_utility.set_location(' Entering: WATIF_ALL_PEOPLE_F_API' , 10);
1681: --
1682: If p_STUDENT_STATUS is null and
1683: p_MARITAL_STATUS is null and
1684: p_DATE_OF_DEATH is null and

Line 2050: hr_utility.set_location(' Leaving: WATIF_ALL_PEOPLE_F_API' , 10);

2046: ,p_assign_payroll_warning => l_assign_payroll_warning
2047: ,P_ORIG_HIRE_WARNING => l_ORIG_HIRE_WARNING
2048: );
2049: --
2050: hr_utility.set_location(' Leaving: WATIF_ALL_PEOPLE_F_API' , 10);
2051: end;
2052:
2053:
2054:

Line 2139: hr_utility.set_location(' Entering: WATIF_PERIODS_OF_SERVICE_API' , 10);

2135: L_DODWARNING varchar2(1);
2136: --
2137: begin
2138: --
2139: hr_utility.set_location(' Entering: WATIF_PERIODS_OF_SERVICE_API' , 10);
2140: hr_utility.set_location('p_ADJUSTED_SVC_DATE ' || p_ADJUSTED_SVC_DATE , 11);
2141: hr_utility.set_location('p_ACTUAL_TERMINATION_DATE ' ||p_ACTUAL_TERMINATION_DATE , 11);
2142: hr_utility.set_location('p_LEAVING_REASON ' ||p_LEAVING_REASON , 11);
2143: --

Line 2140: hr_utility.set_location('p_ADJUSTED_SVC_DATE ' || p_ADJUSTED_SVC_DATE , 11);

2136: --
2137: begin
2138: --
2139: hr_utility.set_location(' Entering: WATIF_PERIODS_OF_SERVICE_API' , 10);
2140: hr_utility.set_location('p_ADJUSTED_SVC_DATE ' || p_ADJUSTED_SVC_DATE , 11);
2141: hr_utility.set_location('p_ACTUAL_TERMINATION_DATE ' ||p_ACTUAL_TERMINATION_DATE , 11);
2142: hr_utility.set_location('p_LEAVING_REASON ' ||p_LEAVING_REASON , 11);
2143: --
2144: If p_DATE_START is null and p_LEAVING_REASON is null and

Line 2141: hr_utility.set_location('p_ACTUAL_TERMINATION_DATE ' ||p_ACTUAL_TERMINATION_DATE , 11);

2137: begin
2138: --
2139: hr_utility.set_location(' Entering: WATIF_PERIODS_OF_SERVICE_API' , 10);
2140: hr_utility.set_location('p_ADJUSTED_SVC_DATE ' || p_ADJUSTED_SVC_DATE , 11);
2141: hr_utility.set_location('p_ACTUAL_TERMINATION_DATE ' ||p_ACTUAL_TERMINATION_DATE , 11);
2142: hr_utility.set_location('p_LEAVING_REASON ' ||p_LEAVING_REASON , 11);
2143: --
2144: If p_DATE_START is null and p_LEAVING_REASON is null and
2145: p_ADJUSTED_SVC_DATE is null and

Line 2142: hr_utility.set_location('p_LEAVING_REASON ' ||p_LEAVING_REASON , 11);

2138: --
2139: hr_utility.set_location(' Entering: WATIF_PERIODS_OF_SERVICE_API' , 10);
2140: hr_utility.set_location('p_ADJUSTED_SVC_DATE ' || p_ADJUSTED_SVC_DATE , 11);
2141: hr_utility.set_location('p_ACTUAL_TERMINATION_DATE ' ||p_ACTUAL_TERMINATION_DATE , 11);
2142: hr_utility.set_location('p_LEAVING_REASON ' ||p_LEAVING_REASON , 11);
2143: --
2144: If p_DATE_START is null and p_LEAVING_REASON is null and
2145: p_ADJUSTED_SVC_DATE is null and
2146: p_ATTRIBUTE1 is null and

Line 2181: hr_utility.set_location(' l_per_object_version_number = '||

2177: open c_per;
2178: fetch c_per into l_per_object_version_number;
2179: close c_per;
2180: --
2181: hr_utility.set_location(' l_per_object_version_number = '||
2182: to_char(l_per_object_version_number) , 10);
2183: -- Re hire case
2184: hr_employee_api.re_hire_ex_employee
2185: (p_validate => FALSE

Line 2531: hr_utility.set_location(' Leaving: WATIF_PERIODS_OF_SERVICE_API' , 10);

2527: ,p_pds_information29 => per_service_rec.PDS_INFORMATION29
2528: ,p_pds_information30 => per_service_rec.PDS_INFORMATION30
2529: );
2530: end if;
2531: hr_utility.set_location(' Leaving: WATIF_PERIODS_OF_SERVICE_API' , 10);
2532: --
2533: end;
2534:
2535:

Line 2612: hr_utility.set_location(' Entering: WATIF_PERSON_TYPE_USAGES_F_API' , 10);

2608: l_new_ptu_rec ben_ptu_ler.g_ptu_ler_rec;
2609: --
2610: begin
2611: --
2612: hr_utility.set_location(' Entering: WATIF_PERSON_TYPE_USAGES_F_API' , 10);
2613: --
2614: If p_PERSON_TYPE_ID is null then
2615: --
2616: fnd_message.set_name('BEN','BEN_91447_ALL_NULL');

Line 2657: hr_utility.set_location('l_old_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);

2653: l_new_ptu_rec.PERSON_TYPE_ID := p_person_type_id;
2654: l_new_ptu_rec.EFFECTIVE_START_DATE := p_effective_date;
2655: l_new_ptu_rec.EFFECTIVE_END_DATE := null;
2656:
2657: hr_utility.set_location('l_old_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);

Line 2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);

2654: l_new_ptu_rec.EFFECTIVE_START_DATE := p_effective_date;
2655: l_new_ptu_rec.EFFECTIVE_END_DATE := null;
2656:
2657: hr_utility.set_location('l_old_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);

Line 2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);

2655: l_new_ptu_rec.EFFECTIVE_END_DATE := null;
2656:
2657: hr_utility.set_location('l_old_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:

Line 2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);

2656:
2657: hr_utility.set_location('l_old_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);

Line 2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);

2657: hr_utility.set_location('l_old_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);

Line 2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);

2658: hr_utility.set_location('l_old_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2659: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);

Line 2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);

2660: hr_utility.set_location('l_old_ptu_rec.PERSON_TYPE_USAGE_ID ' || l_old_ptu_rec.PERSON_TYPE_USAGE_ID, 9999);
2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2667: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2668: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_END_DATE, 9999);

Line 2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);

2661: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2667: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2668: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_END_DATE, 9999);
2669:

Line 2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);

2662: hr_utility.set_location('l_old_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2667: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2668: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_END_DATE, 9999);
2669:
2670: ben_ptu_ler.ler_chk(p_old => l_old_ptu_rec

Line 2667: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);

2663:
2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2667: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2668: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_END_DATE, 9999);
2669:
2670: ben_ptu_ler.ler_chk(p_old => l_old_ptu_rec
2671: ,p_new => l_new_ptu_rec

Line 2668: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_END_DATE, 9999);

2664: hr_utility.set_location('l_new_ptu_rec.PERSON_ID ' || l_old_ptu_rec.PERSON_ID, 9999);
2665: hr_utility.set_location('l_new_ptu_rec.BUSINESS_GROUP_ID ' || l_old_ptu_rec.BUSINESS_GROUP_ID, 9999);
2666: hr_utility.set_location('l_new_ptu_rec.PERSON_TYPE_ID ' || l_old_ptu_rec.PERSON_TYPE_ID, 9999);
2667: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_START_DATE ' || l_old_ptu_rec.EFFECTIVE_START_DATE, 9999);
2668: hr_utility.set_location('l_new_ptu_rec.EFFECTIVE_END_DATE ' || l_old_ptu_rec.EFFECTIVE_END_DATE, 9999);
2669:
2670: ben_ptu_ler.ler_chk(p_old => l_old_ptu_rec
2671: ,p_new => l_new_ptu_rec
2672: ,p_effective_date => p_effective_date);

Line 2699: hr_utility.set_location('Person system type = ' || l_sys_per_typ, 30);

2695: );
2696: --
2697: end if;
2698: --
2699: hr_utility.set_location('Person system type = ' || l_sys_per_typ, 30);
2700: hr_utility.set_location('Desired Person type = ' || l_desired_per_typ, 31);
2701: --
2702: if p_PERSON_TYPE_ID is not null then
2703: per_per_usg_rec.PERSON_TYPE_ID := p_PERSON_TYPE_ID;

Line 2700: hr_utility.set_location('Desired Person type = ' || l_desired_per_typ, 31);

2696: --
2697: end if;
2698: --
2699: hr_utility.set_location('Person system type = ' || l_sys_per_typ, 30);
2700: hr_utility.set_location('Desired Person type = ' || l_desired_per_typ, 31);
2701: --
2702: if p_PERSON_TYPE_ID is not null then
2703: per_per_usg_rec.PERSON_TYPE_ID := p_PERSON_TYPE_ID;
2704: end if;

Line 2780: hr_utility.set_location('Before hr_person_type_usage_api ' ||

2776: p_mode => l_upd_mode);
2777: --
2778: -- Call the API -
2779: --
2780: hr_utility.set_location('Before hr_person_type_usage_api ' ||
2781: to_char(per_per_usg_rec.person_type_id), 10);
2782: hr_person_type_usage_api.update_person_type_usage
2783: (p_validate => FALSE
2784: ,p_person_type_usage_id => per_per_usg_rec.PERSON_TYPE_USAGE_ID

Line 2815: hr_utility.set_location(' Leaving: WATIF_PERSON_TYPE_USAGES_F_API' , 10);

2811: ,p_effective_end_date => l_effective_end_date
2812: );
2813: */
2814: --
2815: hr_utility.set_location(' Leaving: WATIF_PERSON_TYPE_USAGES_F_API' , 10);
2816: --
2817: end;
2818: --
2819:

Line 2843: hr_utility.set_location(' Leaving: WATIF_CRT_ORDR_API' , 10);

2839: l_object_version_number number;
2840: --
2841: begin
2842: --
2843: hr_utility.set_location(' Leaving: WATIF_CRT_ORDR_API' , 10);
2844: --
2845: If p_CRT_ORDR_TYP_CD is null and p_APLS_PERD_STRTG_DT is null and
2846: p_APLS_PERD_ENDG_DT is null and p_pl_id is null
2847: then

Line 3004: hr_utility.set_location(' Leaving: WATIF_CRT_ORDR_API' , 80);

3000: ,p_effective_date => p_effective_date);
3001: --
3002: end if;
3003: --
3004: hr_utility.set_location(' Leaving: WATIF_CRT_ORDR_API' , 80);
3005: --
3006: end;
3007:
3008:

Line 3036: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 10);

3032: cvrd_dpnt_rec ben_elig_cvrd_dpnt_f%rowtype;
3033: --
3034: begin
3035: --
3036: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 10);
3037: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 80);
3038: --
3039: end;
3040:

Line 3037: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 80);

3033: --
3034: begin
3035: --
3036: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 10);
3037: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 80);
3038: --
3039: end;
3040:
3041:

Line 3074: hr_utility.set_location(' Entering: WATIF_PER_ASG_BUDG_VAL_F_API' , 10);

3070: asg_bud_rec per_assignment_budget_values_f%rowtype;
3071: --
3072: begin
3073: --
3074: hr_utility.set_location(' Entering: WATIF_PER_ASG_BUDG_VAL_F_API' , 10);
3075: --
3076: If p_ASSIGNMENT_BUDGET_VALUE_ID is null and p_VALUE is null
3077: then
3078: --

Line 3113: hr_utility.set_location(' Entering: WATIF_PER_ASG_BUDG_VAL_F_API' , 80);

3109: end if;
3110: --
3111: close c_asg_bud;
3112: --
3113: hr_utility.set_location(' Entering: WATIF_PER_ASG_BUDG_VAL_F_API' , 80);
3114: --
3115: end;
3116:
3117:

Line 3147: hr_utility.set_location(' Entering: WATIF_PER_BNFTS_BAL_F_API' , 10);

3143: per_bnft_bal_rec ben_per_bnfts_bal_f%rowtype;
3144: --
3145: begin
3146: --
3147: hr_utility.set_location(' Entering: WATIF_PER_BNFTS_BAL_F_API' , 10);
3148: --
3149: If p_BNFTS_BAL_ID is null and p_VAL is null and
3150: p_EFFECTIVE_START_DATE is null and p_EFFECTIVE_END_DATE is null
3151: then

Line 3278: hr_utility.set_location(' Leaving: WATIF_PER_BNFTS_BAL_F_API' , 80);

3274: --
3275: end if;
3276: Close c_bnfts_bal;
3277: --
3278: hr_utility.set_location(' Leaving: WATIF_PER_BNFTS_BAL_F_API' , 80);
3279: --
3280: end;
3281:
3282:

Line 4370: hr_utility.set_location(' Entering: WATIF_AGE_TEMPORAL_LF_EVT_API' , 10);

4366: and pab.unit = 'FTE';
4367: --
4368: begin
4369: --
4370: hr_utility.set_location(' Entering: WATIF_AGE_TEMPORAL_LF_EVT_API' , 10);
4371: --
4372: -- Store the user entered temporal values in the globals.
4373: -- When profile with compensations factor attached is looked
4374: -- for eligibility this value will be used instead of

Line 4510: hr_utility.set_location(' Leaving: WATIF_AGE_TEMPORAL_LF_EVT_API' , 10);

4506: ,p_object_version_number => l_object_version_number
4507: ,p_effective_date => p_effective_date
4508: ,p_dtctd_dt => p_effective_date);
4509: --
4510: hr_utility.set_location(' Leaving: WATIF_AGE_TEMPORAL_LF_EVT_API' , 10);
4511: --
4512: end;
4513: --
4514: procedure p_init_watif_globals is