APPS.PQH_RBC_ELPRO dependencies on HR_UTILITY

Line 35: hr_utility.set_location('Criteria details not found for the short_code '||p_short_code||' For business group '||p_business_group_id, 20);

31:
32: exception
33: when no_data_found then
34: begin
35: hr_utility.set_location('Criteria details not found for the short_code '||p_short_code||' For business group '||p_business_group_id, 20);
36: Select ELIGY_CRITERIA_ID, CRIT_COL1_DATATYPE,
37: CRITERIA_TYPE, ALLOW_RANGE_VALIDATION_FLAG,
38: CRIT_COL1_VAL_TYPE_CD,CRIT_COL2_DATATYPE,
39: ALLOW_RANGE_VALIDATION_FLAG2,CRIT_COL2_VAL_TYPE_CD

Line 49: hr_utility.set_location('More than one row found for the short_code '||p_short_code, 20);

45: where short_code = p_short_code
46: and business_group_id is null;
47: end;
48: when too_many_rows then
49: hr_utility.set_location('More than one row found for the short_code '||p_short_code, 20);
50: raise;
51: when others then
52: hr_utility.set_location('Issue in getting details for the short_code '||p_short_code, 20);
53: raise;

Line 52: hr_utility.set_location('Issue in getting details for the short_code '||p_short_code, 20);

48: when too_many_rows then
49: hr_utility.set_location('More than one row found for the short_code '||p_short_code, 20);
50: raise;
51: when others then
52: hr_utility.set_location('Issue in getting details for the short_code '||p_short_code, 20);
53: raise;
54: End get_criteria_details;
55:
56:

Line 71: hr_utility.set_location('inside '||l_proc,10);

67: l_elp_ovn number;
68:
69: Begin
70:
71: hr_utility.set_location('inside '||l_proc,10);
72:
73: BEN_ELIGY_PROFILE_API.CREATE_ELIGY_PROFILE(
74: P_EFFECTIVE_DATE => p_effective_date
75: ,P_BUSINESS_GROUP_ID => p_business_group_id

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

83: ,P_EFFECTIVE_END_DATE => l_effective_end_date
84: ,P_OBJECT_VERSION_NUMBER => l_elp_ovn
85: );
86:
87: hr_utility.set_location('Leaving '||l_proc,10);
88:
89: p_elig_prfl_id := l_elp_id;
90:
91: End create_elpro;

Line 133: hr_utility.set_location('inside '||l_proc,10);

129: l_CRIT_COL2_DATATYPE varchar2(80);
130: l_criteria_typ_id number;
131: Begin
132:
133: hr_utility.set_location('inside '||l_proc,10);
134:
135: -- get_criteria_details
136: get_criteria_details (p_short_code => p_criteria_code,
137: p_business_group_id => p_business_group_id,

Line 149: hr_utility.set_location('User defined criteria ',10);

145: p_CRIT_COL2_VAL_TYPE_CD => l_CRIT_COL2_VAL_TYPE_CD
146: );
147: if l_CRITERIA_TYPE = 'USER' then
148: -- User defined criteria
149: hr_utility.set_location('User defined criteria ',10);
150:
151: ben_eligy_crit_values_api.create_eligy_crit_values
152: (
153: p_eligy_crit_values_id => l_crit_values_id

Line 176: hr_utility.set_location('Standard criteria ',10);

172: ,p_date_value4 => p_date_value4
173: );
174:
175: elsif l_CRITERIA_TYPE = 'STD' then
176: hr_utility.set_location('Standard criteria ',10);
177:
178:
179: if l_CRIT_COL1_VAL_TYPE_CD is not null then
180: if l_CRIT_COL1_DATATYPE = 'N' then

Line 612: hr_utility.set_location('Not a valid criteria type ',10);

608: ,p_object_version_number => l_crit_ovn
609: ,p_effective_date => p_effective_date);
610: end if;
611: else
612: hr_utility.set_location('Not a valid criteria type ',10);
613:
614:
615: End if;
616:

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

615: End if;
616:
617:
618:
619: hr_utility.set_location('Leaving '||l_proc,10);
620:
621: -- p_elig_prfl_id := l_elp_id;
622:
623: End create_criteria;