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

Line 61: hr_utility.set_location('entering '||l_proc,10);

57: l_bgd_status varchar2(30);
58: l_proc varchar2(100) := g_package||'propagate_version_changes' ;
59: l_code varchar2(30) := p_change_mode;
60: begin
61: hr_utility.set_location('entering '||l_proc,10);
62: hr_utility.set_location('entering with bgv'||p_budget_version_id||l_proc,11);
63: hr_utility.set_location('l_code is'||l_code||l_proc,35);
64: for i in c1 loop
65: hr_utility.set_location('for each budgeted row '||l_proc,40);

Line 62: hr_utility.set_location('entering with bgv'||p_budget_version_id||l_proc,11);

58: l_proc varchar2(100) := g_package||'propagate_version_changes' ;
59: l_code varchar2(30) := p_change_mode;
60: begin
61: hr_utility.set_location('entering '||l_proc,10);
62: hr_utility.set_location('entering with bgv'||p_budget_version_id||l_proc,11);
63: hr_utility.set_location('l_code is'||l_code||l_proc,35);
64: for i in c1 loop
65: hr_utility.set_location('for each budgeted row '||l_proc,40);
66: if l_code = 'RV' then

Line 63: hr_utility.set_location('l_code is'||l_code||l_proc,35);

59: l_code varchar2(30) := p_change_mode;
60: begin
61: hr_utility.set_location('entering '||l_proc,10);
62: hr_utility.set_location('entering with bgv'||p_budget_version_id||l_proc,11);
63: hr_utility.set_location('l_code is'||l_code||l_proc,35);
64: for i in c1 loop
65: hr_utility.set_location('for each budgeted row '||l_proc,40);
66: if l_code = 'RV' then
67: hr_utility.set_location('unit1 for RV'||l_proc,45);

Line 65: hr_utility.set_location('for each budgeted row '||l_proc,40);

61: hr_utility.set_location('entering '||l_proc,10);
62: hr_utility.set_location('entering with bgv'||p_budget_version_id||l_proc,11);
63: hr_utility.set_location('l_code is'||l_code||l_proc,35);
64: for i in c1 loop
65: hr_utility.set_location('for each budgeted row '||l_proc,40);
66: if l_code = 'RV' then
67: hr_utility.set_location('unit1 for RV'||l_proc,45);
68: if nvl(p_new_bgv_unit1_value,0) <> 0 then
69: l_budget_unit1_percent := round((i.budget_unit1_value * 100)/p_new_bgv_unit1_value,2) ;

Line 67: hr_utility.set_location('unit1 for RV'||l_proc,45);

63: hr_utility.set_location('l_code is'||l_code||l_proc,35);
64: for i in c1 loop
65: hr_utility.set_location('for each budgeted row '||l_proc,40);
66: if l_code = 'RV' then
67: hr_utility.set_location('unit1 for RV'||l_proc,45);
68: if nvl(p_new_bgv_unit1_value,0) <> 0 then
69: l_budget_unit1_percent := round((i.budget_unit1_value * 100)/p_new_bgv_unit1_value,2) ;
70: else
71: l_budget_unit1_percent := null;

Line 76: hr_utility.set_location('unit1 for RP'||l_proc,50);

72: end if;
73: l_budget_unit1_value := i.budget_unit1_value;
74: l_budget_unit1_available := i.budget_unit1_available;
75: elsif l_code = 'RP' then
76: hr_utility.set_location('unit1 for RP'||l_proc,50);
77: if nvl(p_new_bgv_unit1_value,0) <> 0 then
78: l_budget_unit1_value := round(p_new_bgv_unit1_value * nvl(i.budget_unit1_percent,0)/100,p_unit1_precision) ;
79: l_budget_unit1_available := nvl(i.budget_unit1_available,0) + nvl(l_budget_unit1_value,0) - nvl(i.budget_unit1_value,0);
80: p_bgv_unit1_available := nvl(p_bgv_unit1_available,0) - nvl(l_budget_unit1_value,0) + nvl(i.budget_unit1_value,0);

Line 87: hr_utility.set_location('unit1 for UE'||l_proc,55);

83: l_budget_unit1_available := i.budget_unit1_available;
84: end if;
85: l_budget_unit1_percent := i.budget_unit1_percent;
86: else
87: hr_utility.set_location('unit1 for UE'||l_proc,55);
88: if nvl(p_new_bgv_unit1_value,0) <> 0 then
89: if i.budget_unit1_value_type_cd = 'P' then
90: l_budget_unit1_value := round(p_new_bgv_unit1_value * nvl(i.budget_unit1_percent,0)/100,p_unit1_precision) ;
91: l_budget_unit1_available := nvl(i.budget_unit1_available,0) + nvl(l_budget_unit1_value,0) - nvl(i.budget_unit1_value,0);

Line 107: hr_utility.set_location('unit2 for RV'||l_proc,60);

103: end if;
104: end if;
105:
106: if l_code ='RV' then
107: hr_utility.set_location('unit2 for RV'||l_proc,60);
108: if nvl(p_new_bgv_unit2_value,0) <> 0 then
109: l_budget_unit2_percent := round((i.budget_unit2_value * 100)/p_new_bgv_unit2_value,2) ;
110: else
111: l_budget_unit2_percent := null;

Line 116: hr_utility.set_location('unit2 for RP'||l_proc,65);

112: end if;
113: l_budget_unit2_value := i.budget_unit2_value;
114: l_budget_unit2_available := i.budget_unit2_available;
115: elsif l_code ='RP' then
116: hr_utility.set_location('unit2 for RP'||l_proc,65);
117: if nvl(p_new_bgv_unit2_value,0) <> 0 then
118: l_budget_unit2_value := round(p_new_bgv_unit2_value * nvl(i.budget_unit2_percent,0)/100,p_unit2_precision) ;
119: l_budget_unit2_available := nvl(i.budget_unit2_available,0) + nvl(l_budget_unit2_value,0) - nvl(i.budget_unit2_value,0);
120: p_bgv_unit2_available := nvl(p_bgv_unit2_available,0) - nvl(l_budget_unit2_value,0) + nvl(i.budget_unit2_value,0);

Line 127: hr_utility.set_location('unit2 for UE'||l_proc,70);

123: l_budget_unit2_available := i.budget_unit2_available;
124: end if;
125: l_budget_unit2_percent := i.budget_unit2_percent;
126: else
127: hr_utility.set_location('unit2 for UE'||l_proc,70);
128: if nvl(p_new_bgv_unit2_value,0) <> 0 then
129: if i.budget_unit2_value_type_cd = 'P' then
130: l_budget_unit2_value := round(p_new_bgv_unit2_value * nvl(i.budget_unit2_percent,0)/100,p_unit2_precision) ;
131: l_budget_unit2_available := nvl(i.budget_unit2_available,0) + nvl(l_budget_unit2_value,0) - nvl(i.budget_unit2_value,0);

Line 147: hr_utility.set_location('unit3 for RV'||l_proc,75);

143: end if;
144: end if;
145:
146: if l_code ='RV' then
147: hr_utility.set_location('unit3 for RV'||l_proc,75);
148: if nvl(p_new_bgv_unit3_value,0) <> 0 then
149: l_budget_unit3_percent := round((i.budget_unit3_value * 100)/p_new_bgv_unit3_value,2) ;
150: else
151: l_budget_unit3_percent := null;

Line 156: hr_utility.set_location('unit3 for RP'||l_proc,80);

152: end if;
153: l_budget_unit3_value := i.budget_unit3_value;
154: l_budget_unit3_available := i.budget_unit3_available;
155: elsif l_code ='RP' then
156: hr_utility.set_location('unit3 for RP'||l_proc,80);
157: if nvl(p_new_bgv_unit3_value,0) <> 0 then
158: l_budget_unit3_value := round(p_new_bgv_unit3_value * nvl(i.budget_unit3_percent,0)/100,p_unit3_precision) ;
159: l_budget_unit3_available := nvl(i.budget_unit3_available,0) + nvl(l_budget_unit3_value,0) - nvl(i.budget_unit3_value,0);
160: p_bgv_unit3_available := nvl(p_bgv_unit3_available,0) - nvl(l_budget_unit3_value,0) + nvl(i.budget_unit3_value,0);

Line 167: hr_utility.set_location('unit3 for UE'||l_proc,85);

163: l_budget_unit3_available := i.budget_unit3_available;
164: end if;
165: l_budget_unit3_percent := i.budget_unit3_percent;
166: else
167: hr_utility.set_location('unit3 for UE'||l_proc,85);
168: if nvl(p_new_bgv_unit3_value,0) <> 0 then
169: if i.budget_unit3_value_type_cd = 'P' then
170: l_budget_unit3_value := round(p_new_bgv_unit3_value * nvl(i.budget_unit3_percent,0)/100,p_unit3_precision) ;
171: l_budget_unit3_available := nvl(i.budget_unit3_available,0) + nvl(l_budget_unit3_value,0) - nvl(i.budget_unit3_value,0);

Line 185: hr_utility.set_location('before calling propagate_budget_changes'||l_proc,90);

181: l_budget_unit3_available := i.budget_unit3_available;
182: l_budget_unit3_percent := null;
183: end if;
184: end if;
185: hr_utility.set_location('before calling propagate_budget_changes'||l_proc,90);
186: hr_utility.set_location('values passed are'||l_proc,95);
187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);

Line 186: hr_utility.set_location('values passed are'||l_proc,95);

182: l_budget_unit3_percent := null;
183: end if;
184: end if;
185: hr_utility.set_location('before calling propagate_budget_changes'||l_proc,90);
186: hr_utility.set_location('values passed are'||l_proc,95);
187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);

Line 187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);

183: end if;
184: end if;
185: hr_utility.set_location('before calling propagate_budget_changes'||l_proc,90);
186: hr_utility.set_location('values passed are'||l_proc,95);
187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);
191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);

Line 188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);

184: end if;
185: hr_utility.set_location('before calling propagate_budget_changes'||l_proc,90);
186: hr_utility.set_location('values passed are'||l_proc,95);
187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);
191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);
192: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,105);

Line 189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);

185: hr_utility.set_location('before calling propagate_budget_changes'||l_proc,90);
186: hr_utility.set_location('values passed are'||l_proc,95);
187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);
191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);
192: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,105);
193: l_object_version_number := i.object_version_number;

Line 190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);

186: hr_utility.set_location('values passed are'||l_proc,95);
187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);
191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);
192: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,105);
193: l_object_version_number := i.object_version_number;
194: propagate_budget_changes (p_change_mode => l_code,

Line 191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);

187: hr_utility.set_location('unit1_value'||l_budget_unit1_value||l_proc,100);
188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);
191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);
192: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,105);
193: l_object_version_number := i.object_version_number;
194: propagate_budget_changes (p_change_mode => l_code,
195: p_budget_detail_id => i.budget_detail_id,

Line 192: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,105);

188: hr_utility.set_location('unit2_value'||l_budget_unit2_value||l_proc,101);
189: hr_utility.set_location('unit3_value'||l_budget_unit3_value||l_proc,102);
190: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,103);
191: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,104);
192: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,105);
193: l_object_version_number := i.object_version_number;
194: propagate_budget_changes (p_change_mode => l_code,
195: p_budget_detail_id => i.budget_detail_id,
196: p_new_bgt_unit1_value => l_budget_unit1_value,

Line 208: hr_utility.set_location('values returned are'||l_proc,110);

204: p_unit3_aggregate => p_unit3_aggregate,
205: p_bgt_unit1_available => l_budget_unit1_available,
206: p_bgt_unit2_available => l_budget_unit2_available,
207: p_bgt_unit3_available => l_budget_unit3_available);
208: hr_utility.set_location('values returned are'||l_proc,110);
209: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,113);
210: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,114);
211: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,115);
212: if nvl(p_budget_version_status,'X') in ('POST','ERROR') then

Line 209: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,113);

205: p_bgt_unit1_available => l_budget_unit1_available,
206: p_bgt_unit2_available => l_budget_unit2_available,
207: p_bgt_unit3_available => l_budget_unit3_available);
208: hr_utility.set_location('values returned are'||l_proc,110);
209: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,113);
210: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,114);
211: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,115);
212: if nvl(p_budget_version_status,'X') in ('POST','ERROR') then
213: l_bgd_status := 'ERROR';

Line 210: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,114);

206: p_bgt_unit2_available => l_budget_unit2_available,
207: p_bgt_unit3_available => l_budget_unit3_available);
208: hr_utility.set_location('values returned are'||l_proc,110);
209: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,113);
210: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,114);
211: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,115);
212: if nvl(p_budget_version_status,'X') in ('POST','ERROR') then
213: l_bgd_status := 'ERROR';
214: p_budget_version_status := 'ERROR';

Line 211: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,115);

207: p_bgt_unit3_available => l_budget_unit3_available);
208: hr_utility.set_location('values returned are'||l_proc,110);
209: hr_utility.set_location('unit1_available'||l_budget_unit1_available||l_proc,113);
210: hr_utility.set_location('unit2_available'||l_budget_unit2_available||l_proc,114);
211: hr_utility.set_location('unit3_available'||l_budget_unit3_available||l_proc,115);
212: if nvl(p_budget_version_status,'X') in ('POST','ERROR') then
213: l_bgd_status := 'ERROR';
214: p_budget_version_status := 'ERROR';
215: else

Line 233: hr_utility.set_location('budget row updated '||l_proc,120);

229: p_budget_unit3_available => l_budget_unit3_available,
230: p_gl_status => l_bgd_status,
231: p_object_version_number => l_object_version_number
232: );
233: hr_utility.set_location('budget row updated '||l_proc,120);
234: end loop;
235: hr_utility.set_location('values passed out nocopy are'||l_proc,270);
236: p_bgv_unit1_available := round(p_bgv_unit1_available,p_unit1_precision);
237: p_bgv_unit2_available := round(p_bgv_unit2_available,p_unit2_precision);

Line 235: hr_utility.set_location('values passed out nocopy are'||l_proc,270);

231: p_object_version_number => l_object_version_number
232: );
233: hr_utility.set_location('budget row updated '||l_proc,120);
234: end loop;
235: hr_utility.set_location('values passed out nocopy are'||l_proc,270);
236: p_bgv_unit1_available := round(p_bgv_unit1_available,p_unit1_precision);
237: p_bgv_unit2_available := round(p_bgv_unit2_available,p_unit2_precision);
238: p_bgv_unit3_available := round(p_bgv_unit3_available,p_unit3_precision);
239: hr_utility.set_location('unit1_available'||p_bgv_unit1_available||l_proc,273);

Line 239: hr_utility.set_location('unit1_available'||p_bgv_unit1_available||l_proc,273);

235: hr_utility.set_location('values passed out nocopy are'||l_proc,270);
236: p_bgv_unit1_available := round(p_bgv_unit1_available,p_unit1_precision);
237: p_bgv_unit2_available := round(p_bgv_unit2_available,p_unit2_precision);
238: p_bgv_unit3_available := round(p_bgv_unit3_available,p_unit3_precision);
239: hr_utility.set_location('unit1_available'||p_bgv_unit1_available||l_proc,273);
240: hr_utility.set_location('unit2_available'||p_bgv_unit2_available||l_proc,274);
241: hr_utility.set_location('unit3_available'||p_bgv_unit3_available||l_proc,275);
242: hr_utility.set_location('exiting '||l_proc,1000);
243: exception when others then

Line 240: hr_utility.set_location('unit2_available'||p_bgv_unit2_available||l_proc,274);

236: p_bgv_unit1_available := round(p_bgv_unit1_available,p_unit1_precision);
237: p_bgv_unit2_available := round(p_bgv_unit2_available,p_unit2_precision);
238: p_bgv_unit3_available := round(p_bgv_unit3_available,p_unit3_precision);
239: hr_utility.set_location('unit1_available'||p_bgv_unit1_available||l_proc,273);
240: hr_utility.set_location('unit2_available'||p_bgv_unit2_available||l_proc,274);
241: hr_utility.set_location('unit3_available'||p_bgv_unit3_available||l_proc,275);
242: hr_utility.set_location('exiting '||l_proc,1000);
243: exception when others then
244: p_bgv_unit1_available := ini_budget_unit1_available;

Line 241: hr_utility.set_location('unit3_available'||p_bgv_unit3_available||l_proc,275);

237: p_bgv_unit2_available := round(p_bgv_unit2_available,p_unit2_precision);
238: p_bgv_unit3_available := round(p_bgv_unit3_available,p_unit3_precision);
239: hr_utility.set_location('unit1_available'||p_bgv_unit1_available||l_proc,273);
240: hr_utility.set_location('unit2_available'||p_bgv_unit2_available||l_proc,274);
241: hr_utility.set_location('unit3_available'||p_bgv_unit3_available||l_proc,275);
242: hr_utility.set_location('exiting '||l_proc,1000);
243: exception when others then
244: p_bgv_unit1_available := ini_budget_unit1_available;
245: p_bgv_unit2_available := ini_budget_unit2_available;

Line 242: hr_utility.set_location('exiting '||l_proc,1000);

238: p_bgv_unit3_available := round(p_bgv_unit3_available,p_unit3_precision);
239: hr_utility.set_location('unit1_available'||p_bgv_unit1_available||l_proc,273);
240: hr_utility.set_location('unit2_available'||p_bgv_unit2_available||l_proc,274);
241: hr_utility.set_location('unit3_available'||p_bgv_unit3_available||l_proc,275);
242: hr_utility.set_location('exiting '||l_proc,1000);
243: exception when others then
244: p_bgv_unit1_available := ini_budget_unit1_available;
245: p_bgv_unit2_available := ini_budget_unit2_available;
246: p_bgv_unit3_available := ini_budget_unit3_available;

Line 298: hr_utility.set_location('entering '||l_proc,10);

294: x_unit2_sum number;
295: x_unit3_sum number;
296: l_proc varchar2(100) := g_package||'propagate_budget_changes' ;
297: begin
298: hr_utility.set_location('entering '||l_proc,10);
299: if p_change_mode not in ('RP','RV','UE') then
300: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');
301: hr_utility.raise_error;
302: end if;

Line 300: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');

296: l_proc varchar2(100) := g_package||'propagate_budget_changes' ;
297: begin
298: hr_utility.set_location('entering '||l_proc,10);
299: if p_change_mode not in ('RP','RV','UE') then
300: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');
301: hr_utility.raise_error;
302: end if;
303:
304: /* make a call to sub_budgetrow to subtract the all period info. from the table*/

Line 301: hr_utility.raise_error;

297: begin
298: hr_utility.set_location('entering '||l_proc,10);
299: if p_change_mode not in ('RP','RV','UE') then
300: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');
301: hr_utility.raise_error;
302: end if;
303:
304: /* make a call to sub_budgetrow to subtract the all period info. from the table*/
305: pqh_budget.sub_budgetrow(p_budget_detail_id => p_budget_detail_id,

Line 311: hr_utility.set_location('for each period '||l_proc,20);

307: p_unit2_aggregate => p_unit2_aggregate,
308: p_unit3_aggregate => p_unit3_aggregate);
309:
310: for i in c1 loop
311: hr_utility.set_location('for each period '||l_proc,20);
312: if p_change_mode ='RV' then
313: hr_utility.set_location('unit1 for RV '||l_proc,30);
314: if nvl(p_new_bgt_unit1_value,0) <> 0 then
315: l_period_unit1_percent := round((i.budget_unit1_value * 100)/p_new_bgt_unit1_value,2) ;

Line 313: hr_utility.set_location('unit1 for RV '||l_proc,30);

309:
310: for i in c1 loop
311: hr_utility.set_location('for each period '||l_proc,20);
312: if p_change_mode ='RV' then
313: hr_utility.set_location('unit1 for RV '||l_proc,30);
314: if nvl(p_new_bgt_unit1_value,0) <> 0 then
315: l_period_unit1_percent := round((i.budget_unit1_value * 100)/p_new_bgt_unit1_value,2) ;
316: else
317: l_period_unit1_percent := null;

Line 322: hr_utility.set_location('unit1 for RP '||l_proc,35);

318: end if;
319: l_period_unit1_value := i.budget_unit1_value;
320: l_period_unit1_available := i.budget_unit1_available;
321: elsif p_change_mode ='RP' then
322: hr_utility.set_location('unit1 for RP '||l_proc,35);
323: if nvl(p_new_bgt_unit1_value,0) <> 0 then
324: l_period_unit1_value := round(p_new_bgt_unit1_value * nvl(i.budget_unit1_percent,0)/100,2) ;
325: l_period_unit1_available := nvl(i.budget_unit1_available,0) + nvl(l_period_unit1_value,0) - nvl(i.budget_unit1_value,0);
326: p_bgt_unit1_available := nvl(p_bgt_unit1_available,0) - nvl(l_period_unit1_value,0) + nvl(i.budget_unit1_value,0);

Line 333: hr_utility.set_location('unit1 for UE '||l_proc,40);

329: l_period_unit1_available := i.budget_unit1_available;
330: end if;
331: l_period_unit1_percent := i.budget_unit1_percent;
332: else
333: hr_utility.set_location('unit1 for UE '||l_proc,40);
334: if nvl(p_new_bgt_unit1_value,0) <> 0 then
335: if i.budget_unit1_value_type_cd = 'P' then
336: l_period_unit1_value := round(p_new_bgt_unit1_value * nvl(i.budget_unit1_percent,0)/100,2) ;
337: l_period_unit1_available := nvl(i.budget_unit1_available,0) + nvl(l_period_unit1_value,0) - nvl(i.budget_unit1_value,0);

Line 353: hr_utility.set_location('unit2 for RV '||l_proc,50);

349: end if;
350: end if;
351:
352: if p_change_mode ='RV' then
353: hr_utility.set_location('unit2 for RV '||l_proc,50);
354: if nvl(p_new_bgt_unit2_value,0) <> 0 then
355: l_period_unit2_percent := round((i.budget_unit2_value * 100)/p_new_bgt_unit2_value,2) ;
356: else
357: l_period_unit2_percent := null;

Line 362: hr_utility.set_location('unit2 for RP '||l_proc,60);

358: end if;
359: l_period_unit2_value := i.budget_unit2_value;
360: l_period_unit2_available := i.budget_unit2_available;
361: elsif p_change_mode ='RP' then
362: hr_utility.set_location('unit2 for RP '||l_proc,60);
363: if nvl(p_new_bgt_unit2_value,0) <> 0 then
364: l_period_unit2_value := round(p_new_bgt_unit2_value * nvl(i.budget_unit2_percent,0)/100,2) ;
365: l_period_unit2_available := nvl(i.budget_unit2_available,0) + nvl(l_period_unit2_value,0) - nvl(i.budget_unit2_value,0);
366: p_bgt_unit2_available := nvl(p_bgt_unit2_available,0) - nvl(l_period_unit2_value,0) + nvl(i.budget_unit2_value,0);

Line 373: hr_utility.set_location('unit2 for UE '||l_proc,70);

369: l_period_unit2_available := i.budget_unit2_available;
370: end if;
371: l_period_unit2_percent := i.budget_unit2_percent;
372: else
373: hr_utility.set_location('unit2 for UE '||l_proc,70);
374: if nvl(p_new_bgt_unit2_value,0) <> 0 then
375: if i.budget_unit2_value_type_cd = 'P' then
376: l_period_unit2_value := round(p_new_bgt_unit2_value * nvl(i.budget_unit2_percent,0)/100,2) ;
377: l_period_unit2_available := nvl(i.budget_unit2_available,0) + nvl(l_period_unit2_value,0) - nvl(i.budget_unit2_value,0);

Line 393: hr_utility.set_location('unit3 for RV '||l_proc,80);

389: end if;
390: end if;
391:
392: if p_change_mode ='RV' then
393: hr_utility.set_location('unit3 for RV '||l_proc,80);
394: if nvl(p_new_bgt_unit3_value,0) <> 0 then
395: l_period_unit3_percent := round((i.budget_unit3_value * 100)/p_new_bgt_unit3_value,2) ;
396: else
397: l_period_unit3_percent := null;

Line 402: hr_utility.set_location('unit3 for RP '||l_proc,90);

398: end if;
399: l_period_unit3_value := i.budget_unit3_value;
400: l_period_unit3_available := i.budget_unit3_available;
401: elsif p_change_mode ='RP' then
402: hr_utility.set_location('unit3 for RP '||l_proc,90);
403: if nvl(p_new_bgt_unit3_value,0) <> 0 then
404: l_period_unit3_value := round(p_new_bgt_unit3_value * nvl(i.budget_unit3_percent,0)/100,2) ;
405: l_period_unit3_available := nvl(i.budget_unit3_available,0) + nvl(l_period_unit3_value,0) - nvl(i.budget_unit3_value,0);
406: p_bgt_unit3_available := nvl(p_bgt_unit3_available,0) - nvl(l_period_unit3_value,0) + nvl(i.budget_unit3_value,0);

Line 413: hr_utility.set_location('unit3 for UE '||l_proc,100);

409: l_period_unit3_available := i.budget_unit3_available;
410: end if;
411: l_period_unit3_percent := i.budget_unit3_percent;
412: else
413: hr_utility.set_location('unit3 for UE '||l_proc,100);
414: if nvl(p_new_bgt_unit3_value,0) <> 0 then
415: if i.budget_unit3_value_type_cd = 'P' then
416: l_period_unit3_value := round(p_new_bgt_unit3_value * nvl(i.budget_unit3_percent,0)/100,2) ;
417: l_period_unit3_available := nvl(i.budget_unit3_available,0) + nvl(l_period_unit3_value,0) - nvl(i.budget_unit3_value,0);

Line 431: hr_utility.set_location('calling period changes with values '||l_proc,110);

427: l_period_unit3_available := i.budget_unit3_available;
428: l_period_unit3_percent := null;
429: end if;
430: end if;
431: hr_utility.set_location('calling period changes with values '||l_proc,110);
432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);
433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);

Line 432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);

428: l_period_unit3_percent := null;
429: end if;
430: end if;
431: hr_utility.set_location('calling period changes with values '||l_proc,110);
432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);
433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);
436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);

Line 433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);

429: end if;
430: end if;
431: hr_utility.set_location('calling period changes with values '||l_proc,110);
432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);
433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);
436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);
437: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,125);

Line 434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);

430: end if;
431: hr_utility.set_location('calling period changes with values '||l_proc,110);
432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);
433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);
436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);
437: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,125);
438: propagate_period_changes (p_change_mode => p_change_mode,

Line 435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);

431: hr_utility.set_location('calling period changes with values '||l_proc,110);
432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);
433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);
436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);
437: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,125);
438: propagate_period_changes (p_change_mode => p_change_mode,
439: p_budget_period_id => i.budget_period_id,

Line 436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);

432: hr_utility.set_location('unit1_value is '||l_period_unit1_value||l_proc,120);
433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);
436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);
437: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,125);
438: propagate_period_changes (p_change_mode => p_change_mode,
439: p_budget_period_id => i.budget_period_id,
440: p_new_prd_unit1_value => l_period_unit1_value,

Line 437: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,125);

433: hr_utility.set_location('unit2_value is '||l_period_unit2_value||l_proc,121);
434: hr_utility.set_location('unit3_value is '||l_period_unit3_value||l_proc,122);
435: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,123);
436: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,124);
437: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,125);
438: propagate_period_changes (p_change_mode => p_change_mode,
439: p_budget_period_id => i.budget_period_id,
440: p_new_prd_unit1_value => l_period_unit1_value,
441: p_new_prd_unit2_value => l_period_unit2_value,

Line 449: hr_utility.set_location('after period changes values '||l_proc,130);

445: p_unit3_precision => p_unit3_precision,
446: p_prd_unit1_available => l_period_unit1_available,
447: p_prd_unit2_available => l_period_unit2_available,
448: p_prd_unit3_available => l_period_unit3_available);
449: hr_utility.set_location('after period changes values '||l_proc,130);
450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
453: update pqh_budget_periods

Line 450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);

446: p_prd_unit1_available => l_period_unit1_available,
447: p_prd_unit2_available => l_period_unit2_available,
448: p_prd_unit3_available => l_period_unit3_available);
449: hr_utility.set_location('after period changes values '||l_proc,130);
450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
453: update pqh_budget_periods
454: set budget_unit1_value = l_period_unit1_value,

Line 451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);

447: p_prd_unit2_available => l_period_unit2_available,
448: p_prd_unit3_available => l_period_unit3_available);
449: hr_utility.set_location('after period changes values '||l_proc,130);
450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
453: update pqh_budget_periods
454: set budget_unit1_value = l_period_unit1_value,
455: budget_unit2_value = l_period_unit2_value,

Line 452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);

448: p_prd_unit3_available => l_period_unit3_available);
449: hr_utility.set_location('after period changes values '||l_proc,130);
450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
453: update pqh_budget_periods
454: set budget_unit1_value = l_period_unit1_value,
455: budget_unit2_value = l_period_unit2_value,
456: budget_unit3_value = l_period_unit3_value,

Line 464: hr_utility.set_location('after period updated '||l_proc,140);

460: budget_unit1_available = l_period_unit1_available,
461: budget_unit2_available = l_period_unit2_available,
462: budget_unit3_available = l_period_unit3_available
463: where current of c1;
464: hr_utility.set_location('after period updated '||l_proc,140);
465: end loop;
466:
467: /* make a call to add_budgetrow to add the all period info. from the table
468: and then get the available figures using each unit to be passed on to budget*/

Line 504: hr_utility.set_location('values passed out nocopy are'||l_proc,150);

500: p_bgt_unit3_available := nvl(p_new_bgt_unit3_value,0) - nvl(x_unit3_max,0);
501: elsif p_unit3_aggregate='AVERAGE' then
502: p_bgt_unit3_available := nvl(p_new_bgt_unit3_value,0) - nvl(x_unit3_avg,0);
503: end if;
504: hr_utility.set_location('values passed out nocopy are'||l_proc,150);
505: p_bgt_unit1_available := round(p_bgt_unit1_available,p_unit1_precision);
506: p_bgt_unit2_available := round(p_bgt_unit2_available,p_unit2_precision);
507: p_bgt_unit3_available := round(p_bgt_unit3_available,p_unit3_precision);
508: hr_utility.set_location('unit1_available is '||p_bgt_unit1_available||l_proc,153);

Line 508: hr_utility.set_location('unit1_available is '||p_bgt_unit1_available||l_proc,153);

504: hr_utility.set_location('values passed out nocopy are'||l_proc,150);
505: p_bgt_unit1_available := round(p_bgt_unit1_available,p_unit1_precision);
506: p_bgt_unit2_available := round(p_bgt_unit2_available,p_unit2_precision);
507: p_bgt_unit3_available := round(p_bgt_unit3_available,p_unit3_precision);
508: hr_utility.set_location('unit1_available is '||p_bgt_unit1_available||l_proc,153);
509: hr_utility.set_location('unit2_available is '||p_bgt_unit2_available||l_proc,154);
510: hr_utility.set_location('unit3_available is '||p_bgt_unit3_available||l_proc,155);
511: hr_utility.set_location('exiting '||l_proc,1000);
512: exception when others then

Line 509: hr_utility.set_location('unit2_available is '||p_bgt_unit2_available||l_proc,154);

505: p_bgt_unit1_available := round(p_bgt_unit1_available,p_unit1_precision);
506: p_bgt_unit2_available := round(p_bgt_unit2_available,p_unit2_precision);
507: p_bgt_unit3_available := round(p_bgt_unit3_available,p_unit3_precision);
508: hr_utility.set_location('unit1_available is '||p_bgt_unit1_available||l_proc,153);
509: hr_utility.set_location('unit2_available is '||p_bgt_unit2_available||l_proc,154);
510: hr_utility.set_location('unit3_available is '||p_bgt_unit3_available||l_proc,155);
511: hr_utility.set_location('exiting '||l_proc,1000);
512: exception when others then
513: p_bgt_unit1_available := ini_budget_unit1_available;

Line 510: hr_utility.set_location('unit3_available is '||p_bgt_unit3_available||l_proc,155);

506: p_bgt_unit2_available := round(p_bgt_unit2_available,p_unit2_precision);
507: p_bgt_unit3_available := round(p_bgt_unit3_available,p_unit3_precision);
508: hr_utility.set_location('unit1_available is '||p_bgt_unit1_available||l_proc,153);
509: hr_utility.set_location('unit2_available is '||p_bgt_unit2_available||l_proc,154);
510: hr_utility.set_location('unit3_available is '||p_bgt_unit3_available||l_proc,155);
511: hr_utility.set_location('exiting '||l_proc,1000);
512: exception when others then
513: p_bgt_unit1_available := ini_budget_unit1_available;
514: p_bgt_unit2_available := ini_budget_unit2_available;

Line 511: hr_utility.set_location('exiting '||l_proc,1000);

507: p_bgt_unit3_available := round(p_bgt_unit3_available,p_unit3_precision);
508: hr_utility.set_location('unit1_available is '||p_bgt_unit1_available||l_proc,153);
509: hr_utility.set_location('unit2_available is '||p_bgt_unit2_available||l_proc,154);
510: hr_utility.set_location('unit3_available is '||p_bgt_unit3_available||l_proc,155);
511: hr_utility.set_location('exiting '||l_proc,1000);
512: exception when others then
513: p_bgt_unit1_available := ini_budget_unit1_available;
514: p_bgt_unit2_available := ini_budget_unit2_available;
515: p_bgt_unit3_available := ini_budget_unit3_available;

Line 556: hr_utility.set_location('entering '||l_proc,10);

552: l_budgetset_unit3_percent number;
553:
554: l_proc varchar2(100) := g_package||'propagate_period_changes' ;
555: begin
556: hr_utility.set_location('entering '||l_proc,10);
557: if p_change_mode not in ('RP','RV','UE') then
558: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');
559: hr_utility.raise_error;
560: end if;

Line 558: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');

554: l_proc varchar2(100) := g_package||'propagate_period_changes' ;
555: begin
556: hr_utility.set_location('entering '||l_proc,10);
557: if p_change_mode not in ('RP','RV','UE') then
558: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');
559: hr_utility.raise_error;
560: end if;
561: for i in c1 loop
562: if p_change_mode ='RV' then

Line 559: hr_utility.raise_error;

555: begin
556: hr_utility.set_location('entering '||l_proc,10);
557: if p_change_mode not in ('RP','RV','UE') then
558: hr_utility.set_message(8302,'PQH_WKS_PROPAGATION_METHOD_ERR');
559: hr_utility.raise_error;
560: end if;
561: for i in c1 loop
562: if p_change_mode ='RV' then
563: hr_utility.set_location('unit1 for RV '||l_proc,20);

Line 563: hr_utility.set_location('unit1 for RV '||l_proc,20);

559: hr_utility.raise_error;
560: end if;
561: for i in c1 loop
562: if p_change_mode ='RV' then
563: hr_utility.set_location('unit1 for RV '||l_proc,20);
564: if nvl(p_new_prd_unit1_value,0) <> 0 then
565: l_budgetset_unit1_percent := round((i.budget_unit1_value * 100)/p_new_prd_unit1_value,2) ;
566: else
567: l_budgetset_unit1_percent := null;

Line 572: hr_utility.set_location('unit1 for RP '||l_proc,30);

568: end if;
569: l_budgetset_unit1_value := i.budget_unit1_value;
570: l_budgetset_unit1_available := i.budget_unit1_available;
571: elsif p_change_mode ='RP' then
572: hr_utility.set_location('unit1 for RP '||l_proc,30);
573: if nvl(p_new_prd_unit1_value,0) <> 0 then
574: l_budgetset_unit1_value := round(p_new_prd_unit1_value * nvl(i.budget_unit1_percent,0)/100,p_unit1_precision) ;
575: l_budgetset_unit1_available := nvl(i.budget_unit1_available,0) + nvl(l_budgetset_unit1_value,0) - nvl(i.budget_unit1_value,0);
576: p_prd_unit1_available := nvl(p_prd_unit1_available,0) - nvl(l_budgetset_unit1_value,0) + nvl(i.budget_unit1_value,0);

Line 583: hr_utility.set_location('unit1 for UE '||l_proc,40);

579: l_budgetset_unit1_available := i.budget_unit1_available;
580: end if;
581: l_budgetset_unit1_percent := i.budget_unit1_percent;
582: else
583: hr_utility.set_location('unit1 for UE '||l_proc,40);
584: if nvl(p_new_prd_unit1_value,0) <> 0 then
585: if i.budget_unit1_value_type_cd = 'P' then
586: l_budgetset_unit1_value := round(p_new_prd_unit1_value * nvl(i.budget_unit1_percent,0)/100,p_unit1_precision) ;
587: l_budgetset_unit1_available := nvl(i.budget_unit1_available,0) + nvl(l_budgetset_unit1_value,0) - nvl(i.budget_unit1_value,0);

Line 603: hr_utility.set_location('unit2 for RV '||l_proc,50);

599: end if;
600: end if;
601:
602: if p_change_mode ='RV' then
603: hr_utility.set_location('unit2 for RV '||l_proc,50);
604: if nvl(p_new_prd_unit2_value,0) <> 0 then
605: l_budgetset_unit2_percent := round((i.budget_unit2_value * 100)/p_new_prd_unit2_value,2) ;
606: else
607: l_budgetset_unit2_percent := null;

Line 612: hr_utility.set_location('unit2 for RP '||l_proc,60);

608: end if;
609: l_budgetset_unit2_value := i.budget_unit2_value;
610: l_budgetset_unit2_available := i.budget_unit2_available;
611: elsif p_change_mode ='RP' then
612: hr_utility.set_location('unit2 for RP '||l_proc,60);
613: if nvl(p_new_prd_unit2_value,0) <> 0 then
614: l_budgetset_unit2_value := round(p_new_prd_unit2_value * nvl(i.budget_unit2_percent,0)/100,p_unit2_precision) ;
615: l_budgetset_unit2_available := nvl(i.budget_unit2_available,0) + nvl(l_budgetset_unit2_value,0) - nvl(i.budget_unit2_value,0);
616: p_prd_unit2_available := nvl(p_prd_unit2_available,0) - nvl(l_budgetset_unit2_value,0) + nvl(i.budget_unit2_value,0);

Line 623: hr_utility.set_location('unit2 for UE '||l_proc,70);

619: l_budgetset_unit2_available := i.budget_unit2_available;
620: end if;
621: l_budgetset_unit2_percent := i.budget_unit2_percent;
622: else
623: hr_utility.set_location('unit2 for UE '||l_proc,70);
624: if nvl(p_new_prd_unit2_value,0) <> 0 then
625: if i.budget_unit2_value_type_cd = 'P' then
626: l_budgetset_unit2_value := round(p_new_prd_unit2_value * nvl(i.budget_unit2_percent,0)/100,p_unit2_precision) ;
627: l_budgetset_unit2_available := nvl(i.budget_unit2_available,0) + nvl(l_budgetset_unit2_value,0) - nvl(i.budget_unit2_value,0);

Line 643: hr_utility.set_location('unit3 for RV '||l_proc,80);

639: end if;
640: end if;
641:
642: if p_change_mode ='RV' then
643: hr_utility.set_location('unit3 for RV '||l_proc,80);
644: if nvl(p_new_prd_unit3_value,0) <> 0 then
645: l_budgetset_unit3_percent := round((i.budget_unit3_value * 100)/p_new_prd_unit3_value,2) ;
646: else
647: l_budgetset_unit3_percent := null;

Line 652: hr_utility.set_location('unit3 for RP '||l_proc,90);

648: end if;
649: l_budgetset_unit3_value := i.budget_unit3_value;
650: l_budgetset_unit3_available := i.budget_unit3_available;
651: elsif p_change_mode ='RP' then
652: hr_utility.set_location('unit3 for RP '||l_proc,90);
653: if nvl(p_new_prd_unit3_value,0) <> 0 then
654: l_budgetset_unit3_value := round(p_new_prd_unit3_value * nvl(i.budget_unit3_percent,0)/100,p_unit3_precision) ;
655: l_budgetset_unit3_available := nvl(i.budget_unit3_available,0) + nvl(l_budgetset_unit3_value,0) - nvl(i.budget_unit3_value,0);
656: p_prd_unit3_available := nvl(p_prd_unit3_available,0) - nvl(l_budgetset_unit3_value,0) + nvl(i.budget_unit3_value,0);

Line 663: hr_utility.set_location('unit3 for UE '||l_proc,100);

659: l_budgetset_unit3_available := i.budget_unit3_available;
660: end if;
661: l_budgetset_unit3_percent := i.budget_unit3_percent;
662: else
663: hr_utility.set_location('unit3 for UE '||l_proc,100);
664: if nvl(p_new_prd_unit3_value,0) <> 0 then
665: if i.budget_unit3_value_type_cd = 'P' then
666: l_budgetset_unit3_value := round(p_new_prd_unit3_value * nvl(i.budget_unit3_percent,0)/100,p_unit3_precision) ;
667: l_budgetset_unit3_available := nvl(i.budget_unit3_available,0) + nvl(l_budgetset_unit3_value,0) - nvl(i.budget_unit3_value,0);

Line 681: hr_utility.set_location('before update values passed are '||l_proc,110);

677: l_budgetset_unit3_available := i.budget_unit3_available;
678: l_budgetset_unit3_percent := null;
679: end if;
680: end if;
681: hr_utility.set_location('before update values passed are '||l_proc,110);
682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);
683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);

Line 682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);

678: l_budgetset_unit3_percent := null;
679: end if;
680: end if;
681: hr_utility.set_location('before update values passed are '||l_proc,110);
682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);
683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);

Line 683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);

679: end if;
680: end if;
681: hr_utility.set_location('before update values passed are '||l_proc,110);
682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);
683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);

Line 684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);

680: end if;
681: hr_utility.set_location('before update values passed are '||l_proc,110);
682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);
683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);

Line 685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);

681: hr_utility.set_location('before update values passed are '||l_proc,110);
682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);
683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);

Line 686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);

682: hr_utility.set_location('unit1_value '||l_budgetset_unit1_value||l_proc,120);
683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);

Line 687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);

683: hr_utility.set_location('unit2_value '||l_budgetset_unit2_value||l_proc,121);
684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
691: update pqh_budget_sets

Line 688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);

684: hr_utility.set_location('unit3_value '||l_budgetset_unit3_value||l_proc,122);
685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
691: update pqh_budget_sets
692: set budget_unit1_value = l_budgetset_unit1_value,

Line 689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);

685: hr_utility.set_location('unit1_percent '||l_budgetset_unit1_percent||l_proc,123);
686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
691: update pqh_budget_sets
692: set budget_unit1_value = l_budgetset_unit1_value,
693: budget_unit2_value = l_budgetset_unit2_value,

Line 690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);

686: hr_utility.set_location('unit2_percent '||l_budgetset_unit2_percent||l_proc,124);
687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
691: update pqh_budget_sets
692: set budget_unit1_value = l_budgetset_unit1_value,
693: budget_unit2_value = l_budgetset_unit2_value,
694: budget_unit3_value = l_budgetset_unit3_value,

Line 703: hr_utility.set_location('after update out nocopy values passed are '||l_proc,130);

699: budget_unit2_available = l_budgetset_unit2_available,
700: budget_unit3_available = l_budgetset_unit3_available
701: where current of c1;
702: end loop;
703: hr_utility.set_location('after update out nocopy values passed are '||l_proc,130);
704: p_prd_unit1_available := round(p_prd_unit1_available,p_unit1_precision);
705: p_prd_unit2_available := round(p_prd_unit2_available,p_unit2_precision);
706: p_prd_unit3_available := round(p_prd_unit3_available,p_unit3_precision);
707: hr_utility.set_location('unit1_available '||p_prd_unit1_available||l_proc,136);

Line 707: hr_utility.set_location('unit1_available '||p_prd_unit1_available||l_proc,136);

703: hr_utility.set_location('after update out nocopy values passed are '||l_proc,130);
704: p_prd_unit1_available := round(p_prd_unit1_available,p_unit1_precision);
705: p_prd_unit2_available := round(p_prd_unit2_available,p_unit2_precision);
706: p_prd_unit3_available := round(p_prd_unit3_available,p_unit3_precision);
707: hr_utility.set_location('unit1_available '||p_prd_unit1_available||l_proc,136);
708: hr_utility.set_location('unit2_available '||p_prd_unit2_available||l_proc,137);
709: hr_utility.set_location('unit3_available '||p_prd_unit3_available||l_proc,138);
710: hr_utility.set_location('exiting '||l_proc,1000);
711: exception when others then

Line 708: hr_utility.set_location('unit2_available '||p_prd_unit2_available||l_proc,137);

704: p_prd_unit1_available := round(p_prd_unit1_available,p_unit1_precision);
705: p_prd_unit2_available := round(p_prd_unit2_available,p_unit2_precision);
706: p_prd_unit3_available := round(p_prd_unit3_available,p_unit3_precision);
707: hr_utility.set_location('unit1_available '||p_prd_unit1_available||l_proc,136);
708: hr_utility.set_location('unit2_available '||p_prd_unit2_available||l_proc,137);
709: hr_utility.set_location('unit3_available '||p_prd_unit3_available||l_proc,138);
710: hr_utility.set_location('exiting '||l_proc,1000);
711: exception when others then
712: p_prd_unit1_available := l_prd_unit1_available;

Line 709: hr_utility.set_location('unit3_available '||p_prd_unit3_available||l_proc,138);

705: p_prd_unit2_available := round(p_prd_unit2_available,p_unit2_precision);
706: p_prd_unit3_available := round(p_prd_unit3_available,p_unit3_precision);
707: hr_utility.set_location('unit1_available '||p_prd_unit1_available||l_proc,136);
708: hr_utility.set_location('unit2_available '||p_prd_unit2_available||l_proc,137);
709: hr_utility.set_location('unit3_available '||p_prd_unit3_available||l_proc,138);
710: hr_utility.set_location('exiting '||l_proc,1000);
711: exception when others then
712: p_prd_unit1_available := l_prd_unit1_available;
713: p_prd_unit2_available := l_prd_unit2_available;

Line 710: hr_utility.set_location('exiting '||l_proc,1000);

706: p_prd_unit3_available := round(p_prd_unit3_available,p_unit3_precision);
707: hr_utility.set_location('unit1_available '||p_prd_unit1_available||l_proc,136);
708: hr_utility.set_location('unit2_available '||p_prd_unit2_available||l_proc,137);
709: hr_utility.set_location('unit3_available '||p_prd_unit3_available||l_proc,138);
710: hr_utility.set_location('exiting '||l_proc,1000);
711: exception when others then
712: p_prd_unit1_available := l_prd_unit1_available;
713: p_prd_unit2_available := l_prd_unit2_available;
714: p_prd_unit3_available := l_prd_unit3_available;

Line 795: hr_utility.set_location('entering'||l_proc,10);

791: ) is
792: l_proc varchar2(61) := g_package||'Update_bgd';
793: l_object_version_number number := p_object_version_number;
794: begin
795: hr_utility.set_location('entering'||l_proc,10);
796: hr_utility.set_location('bgd id is'||p_budget_detail_id||l_proc,11);
797: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,12);
798: pqh_budget_details_api.update_budget_detail(
799: p_validate => FALSE

Line 796: hr_utility.set_location('bgd id is'||p_budget_detail_id||l_proc,11);

792: l_proc varchar2(61) := g_package||'Update_bgd';
793: l_object_version_number number := p_object_version_number;
794: begin
795: hr_utility.set_location('entering'||l_proc,10);
796: hr_utility.set_location('bgd id is'||p_budget_detail_id||l_proc,11);
797: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,12);
798: pqh_budget_details_api.update_budget_detail(
799: p_validate => FALSE
800: ,p_budget_detail_id => p_budget_detail_id

Line 797: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,12);

793: l_object_version_number number := p_object_version_number;
794: begin
795: hr_utility.set_location('entering'||l_proc,10);
796: hr_utility.set_location('bgd id is'||p_budget_detail_id||l_proc,11);
797: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,12);
798: pqh_budget_details_api.update_budget_detail(
799: p_validate => FALSE
800: ,p_budget_detail_id => p_budget_detail_id
801: ,p_budget_version_id => p_budget_version_id

Line 821: hr_utility.set_location('wkd id is'||p_budget_detail_id||l_proc,20);

817: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
818: ,p_gl_status => p_gl_status
819: ,p_object_version_number => p_object_version_number
820: );
821: hr_utility.set_location('wkd id is'||p_budget_detail_id||l_proc,20);
822: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,30);
823: hr_utility.set_location('exiting'||l_proc,100);
824: exception when others then
825: p_object_version_number := l_object_version_number;

Line 822: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,30);

818: ,p_gl_status => p_gl_status
819: ,p_object_version_number => p_object_version_number
820: );
821: hr_utility.set_location('wkd id is'||p_budget_detail_id||l_proc,20);
822: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,30);
823: hr_utility.set_location('exiting'||l_proc,100);
824: exception when others then
825: p_object_version_number := l_object_version_number;
826: raise;

Line 823: hr_utility.set_location('exiting'||l_proc,100);

819: ,p_object_version_number => p_object_version_number
820: );
821: hr_utility.set_location('wkd id is'||p_budget_detail_id||l_proc,20);
822: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,30);
823: hr_utility.set_location('exiting'||l_proc,100);
824: exception when others then
825: p_object_version_number := l_object_version_number;
826: raise;
827: end update_budget_detail;

Line 868: hr_utility.set_location('entering '||l_proc,10);

864: l_ver_chk varchar2(15);
865: l_ver_start_date date;
866: l_proc varchar2(61) := g_package ||'bgv_date_validation' ;
867: begin
868: hr_utility.set_location('entering '||l_proc,10);
869: hr_utility.set_location('ver # entered is '||p_version_number||l_proc,10);
870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);
871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);
872: if p_budget_id is null then

Line 869: hr_utility.set_location('ver # entered is '||p_version_number||l_proc,10);

865: l_ver_start_date date;
866: l_proc varchar2(61) := g_package ||'bgv_date_validation' ;
867: begin
868: hr_utility.set_location('entering '||l_proc,10);
869: hr_utility.set_location('ver # entered is '||p_version_number||l_proc,10);
870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);
871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);
872: if p_budget_id is null then
873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');

Line 870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);

866: l_proc varchar2(61) := g_package ||'bgv_date_validation' ;
867: begin
868: hr_utility.set_location('entering '||l_proc,10);
869: hr_utility.set_location('ver # entered is '||p_version_number||l_proc,10);
870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);
871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);
872: if p_budget_id is null then
873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
874: hr_utility.raise_error;

Line 871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);

867: begin
868: hr_utility.set_location('entering '||l_proc,10);
869: hr_utility.set_location('ver # entered is '||p_version_number||l_proc,10);
870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);
871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);
872: if p_budget_id is null then
873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
874: hr_utility.raise_error;
875: elsif p_version_number is null then

Line 873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');

869: hr_utility.set_location('ver # entered is '||p_version_number||l_proc,10);
870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);
871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);
872: if p_budget_id is null then
873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
874: hr_utility.raise_error;
875: elsif p_version_number is null then
876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
877: hr_utility.raise_error;

Line 874: hr_utility.raise_error;

870: hr_utility.set_location('start_date is '||p_date_from||l_proc,10);
871: hr_utility.set_location('end_date is '||p_date_to||l_proc,10);
872: if p_budget_id is null then
873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
874: hr_utility.raise_error;
875: elsif p_version_number is null then
876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
877: hr_utility.raise_error;
878: elsif p_date_from is null then

Line 876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');

872: if p_budget_id is null then
873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
874: hr_utility.raise_error;
875: elsif p_version_number is null then
876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
877: hr_utility.raise_error;
878: elsif p_date_from is null then
879: hr_utility.set_message(8302,'PQH_START_DT_NULL');
880: hr_utility.raise_error;

Line 877: hr_utility.raise_error;

873: hr_utility.set_message(8302,'PQH_INVALID_BUDGET');
874: hr_utility.raise_error;
875: elsif p_version_number is null then
876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
877: hr_utility.raise_error;
878: elsif p_date_from is null then
879: hr_utility.set_message(8302,'PQH_START_DT_NULL');
880: hr_utility.raise_error;
881: elsif p_date_to is null then

Line 879: hr_utility.set_message(8302,'PQH_START_DT_NULL');

875: elsif p_version_number is null then
876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
877: hr_utility.raise_error;
878: elsif p_date_from is null then
879: hr_utility.set_message(8302,'PQH_START_DT_NULL');
880: hr_utility.raise_error;
881: elsif p_date_to is null then
882: hr_utility.set_message(8302,'PQH_END_DT_NULL');
883: hr_utility.raise_error;

Line 880: hr_utility.raise_error;

876: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
877: hr_utility.raise_error;
878: elsif p_date_from is null then
879: hr_utility.set_message(8302,'PQH_START_DT_NULL');
880: hr_utility.raise_error;
881: elsif p_date_to is null then
882: hr_utility.set_message(8302,'PQH_END_DT_NULL');
883: hr_utility.raise_error;
884: elsif p_date_from > p_date_to then

Line 882: hr_utility.set_message(8302,'PQH_END_DT_NULL');

878: elsif p_date_from is null then
879: hr_utility.set_message(8302,'PQH_START_DT_NULL');
880: hr_utility.raise_error;
881: elsif p_date_to is null then
882: hr_utility.set_message(8302,'PQH_END_DT_NULL');
883: hr_utility.raise_error;
884: elsif p_date_from > p_date_to then
885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));

Line 883: hr_utility.raise_error;

879: hr_utility.set_message(8302,'PQH_START_DT_NULL');
880: hr_utility.raise_error;
881: elsif p_date_to is null then
882: hr_utility.set_message(8302,'PQH_END_DT_NULL');
883: hr_utility.raise_error;
884: elsif p_date_from > p_date_to then
885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));
887: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_date_to));

Line 885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');

881: elsif p_date_to is null then
882: hr_utility.set_message(8302,'PQH_END_DT_NULL');
883: hr_utility.raise_error;
884: elsif p_date_from > p_date_to then
885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));
887: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_date_to));
888: hr_utility.raise_error;
889: end if;

Line 886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));

882: hr_utility.set_message(8302,'PQH_END_DT_NULL');
883: hr_utility.raise_error;
884: elsif p_date_from > p_date_to then
885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));
887: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_date_to));
888: hr_utility.raise_error;
889: end if;
890: -- we are here to correct a existing version or checking for the new version to be entered.

Line 887: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_date_to));

883: hr_utility.raise_error;
884: elsif p_date_from > p_date_to then
885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));
887: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_date_to));
888: hr_utility.raise_error;
889: end if;
890: -- we are here to correct a existing version or checking for the new version to be entered.
891: open c0;

Line 888: hr_utility.raise_error;

884: elsif p_date_from > p_date_to then
885: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
886: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_chardate(p_date_from));
887: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_chardate(p_date_to));
888: hr_utility.raise_error;
889: end if;
890: -- we are here to correct a existing version or checking for the new version to be entered.
891: open c0;
892: fetch c0 into l_max_version;

Line 894: hr_utility.set_location('max_version is'||l_max_version||l_proc,70);

890: -- we are here to correct a existing version or checking for the new version to be entered.
891: open c0;
892: fetch c0 into l_max_version;
893: close c0;
894: hr_utility.set_location('max_version is'||l_max_version||l_proc,70);
895: open c1;
896: fetch c1 into l_min_version;
897: close c1;
898: hr_utility.set_location('min_version is'||l_min_version||l_proc,80);

Line 898: hr_utility.set_location('min_version is'||l_min_version||l_proc,80);

894: hr_utility.set_location('max_version is'||l_max_version||l_proc,70);
895: open c1;
896: fetch c1 into l_min_version;
897: close c1;
898: hr_utility.set_location('min_version is'||l_min_version||l_proc,80);
899: hr_utility.set_location('max_end_date is'||l_max_end_date||l_proc,90);
900: hr_utility.set_location('min_start_date is'||l_min_start_date||l_proc,100);
901: if p_version_number = l_max_version then
902: open c6;

Line 899: hr_utility.set_location('max_end_date is'||l_max_end_date||l_proc,90);

895: open c1;
896: fetch c1 into l_min_version;
897: close c1;
898: hr_utility.set_location('min_version is'||l_min_version||l_proc,80);
899: hr_utility.set_location('max_end_date is'||l_max_end_date||l_proc,90);
900: hr_utility.set_location('min_start_date is'||l_min_start_date||l_proc,100);
901: if p_version_number = l_max_version then
902: open c6;
903: fetch c6 into l_prev_ver_end_date;

Line 900: hr_utility.set_location('min_start_date is'||l_min_start_date||l_proc,100);

896: fetch c1 into l_min_version;
897: close c1;
898: hr_utility.set_location('min_version is'||l_min_version||l_proc,80);
899: hr_utility.set_location('max_end_date is'||l_max_end_date||l_proc,90);
900: hr_utility.set_location('min_start_date is'||l_min_start_date||l_proc,100);
901: if p_version_number = l_max_version then
902: open c6;
903: fetch c6 into l_prev_ver_end_date;
904: close c6;

Line 905: hr_utility.set_location('version_number = max_version'||l_proc,140);

901: if p_version_number = l_max_version then
902: open c6;
903: fetch c6 into l_prev_ver_end_date;
904: close c6;
905: hr_utility.set_location('version_number = max_version'||l_proc,140);
906: -- last version is getting corrected
907: if p_version_number = l_min_version then
908: hr_utility.set_location('version_number = min version'||l_proc,142);
909: -- There is only one version and we are working on it.so any date user enters is okay.

Line 908: hr_utility.set_location('version_number = min version'||l_proc,142);

904: close c6;
905: hr_utility.set_location('version_number = max_version'||l_proc,140);
906: -- last version is getting corrected
907: if p_version_number = l_min_version then
908: hr_utility.set_location('version_number = min version'||l_proc,142);
909: -- There is only one version and we are working on it.so any date user enters is okay.
910: p_status := 'SUCCESS' ;
911: else
912: hr_utility.set_location('Lower limit should be > '||l_prev_ver_end_date||l_proc,162);

Line 912: hr_utility.set_location('Lower limit should be > '||l_prev_ver_end_date||l_proc,162);

908: hr_utility.set_location('version_number = min version'||l_proc,142);
909: -- There is only one version and we are working on it.so any date user enters is okay.
910: p_status := 'SUCCESS' ;
911: else
912: hr_utility.set_location('Lower limit should be > '||l_prev_ver_end_date||l_proc,162);
913: if p_date_from > l_prev_ver_end_date then
914: hr_utility.set_location('between valid dates '||l_proc,145);
915: p_status := 'SUCCESS' ;
916: else

Line 914: hr_utility.set_location('between valid dates '||l_proc,145);

910: p_status := 'SUCCESS' ;
911: else
912: hr_utility.set_location('Lower limit should be > '||l_prev_ver_end_date||l_proc,162);
913: if p_date_from > l_prev_ver_end_date then
914: hr_utility.set_location('between valid dates '||l_proc,145);
915: p_status := 'SUCCESS' ;
916: else
917: hr_utility.set_location('not between valid dates '||l_proc,148);
918: p_bgv_ll_date := l_prev_ver_end_date;

Line 917: hr_utility.set_location('not between valid dates '||l_proc,148);

913: if p_date_from > l_prev_ver_end_date then
914: hr_utility.set_location('between valid dates '||l_proc,145);
915: p_status := 'SUCCESS' ;
916: else
917: hr_utility.set_location('not between valid dates '||l_proc,148);
918: p_bgv_ll_date := l_prev_ver_end_date;
919: p_status := 'ERROR' ;
920: end if;
921: end if;

Line 927: hr_utility.set_location('version_number > max_version'||l_proc,150);

923: -- new version is getting added
924: open c2;
925: fetch c2 into l_max_end_date;
926: close c2;
927: hr_utility.set_location('version_number > max_version'||l_proc,150);
928: hr_utility.set_location('Lower limit should be > '||l_max_end_date||l_proc,162);
929: if p_date_from > l_max_end_date then
930: hr_utility.set_location('between valid dates '||l_proc,155);
931: p_status := 'SUCCESS' ;

Line 928: hr_utility.set_location('Lower limit should be > '||l_max_end_date||l_proc,162);

924: open c2;
925: fetch c2 into l_max_end_date;
926: close c2;
927: hr_utility.set_location('version_number > max_version'||l_proc,150);
928: hr_utility.set_location('Lower limit should be > '||l_max_end_date||l_proc,162);
929: if p_date_from > l_max_end_date then
930: hr_utility.set_location('between valid dates '||l_proc,155);
931: p_status := 'SUCCESS' ;
932: else

Line 930: hr_utility.set_location('between valid dates '||l_proc,155);

926: close c2;
927: hr_utility.set_location('version_number > max_version'||l_proc,150);
928: hr_utility.set_location('Lower limit should be > '||l_max_end_date||l_proc,162);
929: if p_date_from > l_max_end_date then
930: hr_utility.set_location('between valid dates '||l_proc,155);
931: p_status := 'SUCCESS' ;
932: else
933: hr_utility.set_location('not between valid dates '||l_proc,158);
934: p_bgv_ll_date := l_max_end_date;

Line 933: hr_utility.set_location('not between valid dates '||l_proc,158);

929: if p_date_from > l_max_end_date then
930: hr_utility.set_location('between valid dates '||l_proc,155);
931: p_status := 'SUCCESS' ;
932: else
933: hr_utility.set_location('not between valid dates '||l_proc,158);
934: p_bgv_ll_date := l_max_end_date;
935: p_status := 'ERROR' ;
936: end if;
937: elsif p_version_number = l_min_version then

Line 943: hr_utility.set_location('version_number = min_version'||l_proc,160);

939: fetch c5 into l_next_ver_start_date;
940: close c5;
941: -- first version is getting corrected
942: -- but end date should be equal to ver_end_date
943: hr_utility.set_location('version_number = min_version'||l_proc,160);
944: hr_utility.set_location('Upper limit should be < '||l_next_ver_start_date||l_proc,162);
945: if p_date_to < l_next_ver_start_date then
946: hr_utility.set_location('between valid dates '||l_proc,165);
947: p_status := 'SUCCESS' ;

Line 944: hr_utility.set_location('Upper limit should be < '||l_next_ver_start_date||l_proc,162);

940: close c5;
941: -- first version is getting corrected
942: -- but end date should be equal to ver_end_date
943: hr_utility.set_location('version_number = min_version'||l_proc,160);
944: hr_utility.set_location('Upper limit should be < '||l_next_ver_start_date||l_proc,162);
945: if p_date_to < l_next_ver_start_date then
946: hr_utility.set_location('between valid dates '||l_proc,165);
947: p_status := 'SUCCESS' ;
948: else

Line 946: hr_utility.set_location('between valid dates '||l_proc,165);

942: -- but end date should be equal to ver_end_date
943: hr_utility.set_location('version_number = min_version'||l_proc,160);
944: hr_utility.set_location('Upper limit should be < '||l_next_ver_start_date||l_proc,162);
945: if p_date_to < l_next_ver_start_date then
946: hr_utility.set_location('between valid dates '||l_proc,165);
947: p_status := 'SUCCESS' ;
948: else
949: hr_utility.set_location('not between valid dates '||l_proc,168);
950: p_bgv_ul_date := l_next_ver_start_date;

Line 949: hr_utility.set_location('not between valid dates '||l_proc,168);

945: if p_date_to < l_next_ver_start_date then
946: hr_utility.set_location('between valid dates '||l_proc,165);
947: p_status := 'SUCCESS' ;
948: else
949: hr_utility.set_location('not between valid dates '||l_proc,168);
950: p_bgv_ul_date := l_next_ver_start_date;
951: p_status := 'ERROR' ;
952: end if;
953: else

Line 960: hr_utility.set_location('version_number in middle '||l_proc,170);

956: close c5;
957: open c6;
958: fetch c6 into l_prev_ver_end_date;
959: close c6;
960: hr_utility.set_location('version_number in middle '||l_proc,170);
961: -- a version in middle is getting corrected
962: -- in this case start date of the worksheet should be less than or equal to start date
963: -- of the version and worksheet end date should be greater than or equal to version
964: -- and also version start date should be between last_ver_end_date and next_ver_start_date

Line 968: hr_utility.set_location('between valid dates '||l_proc,175);

964: -- and also version start date should be between last_ver_end_date and next_ver_start_date
965: -- and also version_end_date should be between last_ver_end date and next_ver_start_date
966: if p_date_from between l_prev_ver_end_date+1 and l_next_ver_start_date-1
967: and p_date_to between l_prev_ver_end_date+1 and l_next_ver_start_date-1 then
968: hr_utility.set_location('between valid dates '||l_proc,175);
969: p_status := 'SUCCESS' ;
970: else
971: hr_utility.set_location('not between valid dates '||l_proc,178);
972: p_bgv_ll_date := l_prev_ver_end_date+1;

Line 971: hr_utility.set_location('not between valid dates '||l_proc,178);

967: and p_date_to between l_prev_ver_end_date+1 and l_next_ver_start_date-1 then
968: hr_utility.set_location('between valid dates '||l_proc,175);
969: p_status := 'SUCCESS' ;
970: else
971: hr_utility.set_location('not between valid dates '||l_proc,178);
972: p_bgv_ll_date := l_prev_ver_end_date+1;
973: p_bgv_ul_date := l_next_ver_start_date-1;
974: p_status := 'ERROR' ;
975: end if;

Line 977: hr_utility.set_location('end of validation with status'||p_status||l_proc,270);

973: p_bgv_ul_date := l_next_ver_start_date-1;
974: p_status := 'ERROR' ;
975: end if;
976: end if;
977: hr_utility.set_location('end of validation with status'||p_status||l_proc,270);
978: exception when others then
979: p_bgv_ll_date := null;
980: p_bgv_ul_date := null;
981: p_status := null;