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

Line 58: hr_utility.set_location('Entering: '||l_process_name, 5);

54: l_calc_method hr_organization_information.org_information1%TYPE;
55: l_to_with_amt number;
56: l_process_name Varchar2(150) := g_pkg_name||'Get_Arrearage_Info';
57: Begin
58: hr_utility.set_location('Entering: '||l_process_name, 5);
59: If g_legislation_code Is Null Then
60: Open csr_leg_code (c_business_grp_id => p_business_grp_id);
61: Fetch csr_leg_code Into l_legislation_code;
62: g_legislation_code := l_legislation_code;

Line 64: hr_utility.set_location('Could not find the Leg Code :',10);

60: Open csr_leg_code (c_business_grp_id => p_business_grp_id);
61: Fetch csr_leg_code Into l_legislation_code;
62: g_legislation_code := l_legislation_code;
63: If csr_leg_code%NOTFOUND Then
64: hr_utility.set_location('Could not find the Leg Code :',10);
65: Null;
66: End If;
67: Close csr_leg_code;
68: End If;

Line 69: hr_utility.set_location('Leg. Code :'||l_legislation_code,10);

65: Null;
66: End If;
67: Close csr_leg_code;
68: End If;
69: hr_utility.set_location('Leg. Code :'||l_legislation_code,10);
70: If g_legislation_code = 'GB' Then
71: l_ele_information_type := 'PQP_GB_ARREARAGE_INFO';
72: l_org_information_type := 'PQP_GB_ITERATIVE_RULES';
73: Elsif g_legislation_code = 'NL' Then

Line 77: hr_utility.set_location('Information Type :'||l_ele_information_type,15);

73: Elsif g_legislation_code = 'NL' Then
74: l_ele_information_type := 'PQP_NL_ARREARAGE_INFO';
75: l_org_information_type := 'PQP_NL_ITERATIVE_RULES';
76: End If;
77: hr_utility.set_location('Information Type :'||l_ele_information_type,15);
78: If l_ele_information_type = 'PQP_GB_ARREARAGE_INFO' Then
79: Open csr_arr_info (c_ele_type_id => p_ele_type_id
80: ,c_business_grp_id => p_business_grp_id
81: ,c_effective_date => p_effective_date

Line 85: hr_utility.set_location('Found Arrearage Info :',20);

81: ,c_effective_date => p_effective_date
82: ,c_information_type => l_ele_information_type);
83: Fetch csr_arr_info Into l_arr_info_rec;
84: If csr_arr_info%FOUND Then
85: hr_utility.set_location('Found Arrearage Info :',20);
86: p_arrears_allowed := l_arr_info_rec.eei_information1;
87: p_partial_allowed := l_arr_info_rec.eei_information2;
88: Else
89: hr_utility.set_location('Defaulting Arrearage Info :',20);

Line 89: hr_utility.set_location('Defaulting Arrearage Info :',20);

85: hr_utility.set_location('Found Arrearage Info :',20);
86: p_arrears_allowed := l_arr_info_rec.eei_information1;
87: p_partial_allowed := l_arr_info_rec.eei_information2;
88: Else
89: hr_utility.set_location('Defaulting Arrearage Info :',20);
90: p_arrears_allowed := 'N';
91: p_partial_allowed := 'N';
92: End If;
93: Close csr_arr_info;

Line 115: hr_utility.set_location('Leaving : '||l_process_name,90);

111: ElsIf l_org_information_type = 'PQP_NL_ITERATIVE_RULES' Then
112: Null;
113: End If;
114:
115: hr_utility.set_location('Leaving : '||l_process_name,90);
116: Exception
117: When Others Then
118: hr_utility.set_location('Error Code: '||SQLCODE,130);
119: hr_utility.set_location('Error Msg : '||SQLERRM,140);

Line 118: hr_utility.set_location('Error Code: '||SQLCODE,130);

114:
115: hr_utility.set_location('Leaving : '||l_process_name,90);
116: Exception
117: When Others Then
118: hr_utility.set_location('Error Code: '||SQLCODE,130);
119: hr_utility.set_location('Error Msg : '||SQLERRM,140);
120: hr_utility.set_location('Leaving : '||l_process_name,150);
121: End Get_Arrearage_Info;
122:

Line 119: hr_utility.set_location('Error Msg : '||SQLERRM,140);

115: hr_utility.set_location('Leaving : '||l_process_name,90);
116: Exception
117: When Others Then
118: hr_utility.set_location('Error Code: '||SQLCODE,130);
119: hr_utility.set_location('Error Msg : '||SQLERRM,140);
120: hr_utility.set_location('Leaving : '||l_process_name,150);
121: End Get_Arrearage_Info;
122:
123: -- ============================================================

Line 120: hr_utility.set_location('Leaving : '||l_process_name,150);

116: Exception
117: When Others Then
118: hr_utility.set_location('Error Code: '||SQLCODE,130);
119: hr_utility.set_location('Error Msg : '||SQLERRM,140);
120: hr_utility.set_location('Leaving : '||l_process_name,150);
121: End Get_Arrearage_Info;
122:
123: -- ============================================================
124: -- ~Get_Arrearage_Options: Returns the Arrears Allowed and

Line 140: hr_utility.set_location('Entering: '||l_process_name, 5);

136: ) Return Number Is
137: l_process_name Varchar2(150) := g_pkg_name||'Get_Arrearage_Options';
138: l_return_value number := 0;
139: Begin
140: hr_utility.set_location('Entering: '||l_process_name, 5);
141: Get_Arrearage_Info
142: (p_ele_type_id => p_ele_type_id
143: ,p_assignment_id => p_assignment_id
144: ,p_business_grp_id => p_business_grp_id

Line 149: hr_utility.set_location('Leaving : '||l_process_name,90);

145: ,p_effective_date => p_effective_date
146: ,p_arrears_allowed => p_arrears_allowed
147: ,p_partial_allowed => p_partial_allowed
148: );
149: hr_utility.set_location('Leaving : '||l_process_name,90);
150: Return l_return_value;
151:
152: Exception
153: When Others Then

Line 154: hr_utility.set_location('Error Code: '||SQLCODE,130);

150: Return l_return_value;
151:
152: Exception
153: When Others Then
154: hr_utility.set_location('Error Code: '||SQLCODE,130);
155: hr_utility.set_location('Error Msg : '||SQLERRM,140);
156: p_error_message := 'Exception: When Others at :'||l_process_name;
157: hr_utility.set_location('Leaving : '||l_process_name,150);
158: l_return_value := -1;

Line 155: hr_utility.set_location('Error Msg : '||SQLERRM,140);

151:
152: Exception
153: When Others Then
154: hr_utility.set_location('Error Code: '||SQLCODE,130);
155: hr_utility.set_location('Error Msg : '||SQLERRM,140);
156: p_error_message := 'Exception: When Others at :'||l_process_name;
157: hr_utility.set_location('Leaving : '||l_process_name,150);
158: l_return_value := -1;
159: Raise;

Line 157: hr_utility.set_location('Leaving : '||l_process_name,150);

153: When Others Then
154: hr_utility.set_location('Error Code: '||SQLCODE,130);
155: hr_utility.set_location('Error Msg : '||SQLERRM,140);
156: p_error_message := 'Exception: When Others at :'||l_process_name;
157: hr_utility.set_location('Leaving : '||l_process_name,150);
158: l_return_value := -1;
159: Raise;
160: End Get_Arrearage_Options;
161: -- ============================================================

Line 192: hr_utility.set_location('Entering: '||l_process_name, 5);

188: l_arrears_allowed Varchar2(2);
189: l_partial_allowed Varchar2(2);
190: l_process_name Varchar2(150) := g_pkg_name||'Arrearage';
191: Begin
192: hr_utility.set_location('Entering: '||l_process_name, 5);
193: p_to_arrears := 0;
194: p_not_taken := 0;
195: If p_partial_allowed Is Null And
196: p_arrears_allowed Is Null Then

Line 218: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);

214: g_Element_Arr_Values(p_eletype_id).partial_allowed := p_partial_allowed;
215: l_arrears_allowed := p_arrears_allowed;
216: l_partial_allowed := p_partial_allowed;
217: End If;
218: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);
219: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);
220: hr_utility.set_location('..p_dedn_amt: '||p_dedn_amt, 8);
221: hr_utility.set_location('..p_guaranteed_net: '||p_guaranteed_net, 9);
222: If l_arrears_allowed = 'N' Then

Line 219: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);

215: l_arrears_allowed := p_arrears_allowed;
216: l_partial_allowed := p_partial_allowed;
217: End If;
218: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);
219: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);
220: hr_utility.set_location('..p_dedn_amt: '||p_dedn_amt, 8);
221: hr_utility.set_location('..p_guaranteed_net: '||p_guaranteed_net, 9);
222: If l_arrears_allowed = 'N' Then
223: -- Arrears are not allowed

Line 220: hr_utility.set_location('..p_dedn_amt: '||p_dedn_amt, 8);

216: l_partial_allowed := p_partial_allowed;
217: End If;
218: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);
219: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);
220: hr_utility.set_location('..p_dedn_amt: '||p_dedn_amt, 8);
221: hr_utility.set_location('..p_guaranteed_net: '||p_guaranteed_net, 9);
222: If l_arrears_allowed = 'N' Then
223: -- Arrears are not allowed
224: hr_utility.set_location('Arrearage not allowed',10);

Line 221: hr_utility.set_location('..p_guaranteed_net: '||p_guaranteed_net, 9);

217: End If;
218: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);
219: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);
220: hr_utility.set_location('..p_dedn_amt: '||p_dedn_amt, 8);
221: hr_utility.set_location('..p_guaranteed_net: '||p_guaranteed_net, 9);
222: If l_arrears_allowed = 'N' Then
223: -- Arrears are not allowed
224: hr_utility.set_location('Arrearage not allowed',10);
225: If p_net_asg_run - p_dedn_amt >= p_guaranteed_net Then

Line 224: hr_utility.set_location('Arrearage not allowed',10);

220: hr_utility.set_location('..p_dedn_amt: '||p_dedn_amt, 8);
221: hr_utility.set_location('..p_guaranteed_net: '||p_guaranteed_net, 9);
222: If l_arrears_allowed = 'N' Then
223: -- Arrears are not allowed
224: hr_utility.set_location('Arrearage not allowed',10);
225: If p_net_asg_run - p_dedn_amt >= p_guaranteed_net Then
226: -- There are enough earnings to take the entire deduction amount.
227: hr_utility.set_location('Enough earnings to take the entire ded. amount', 15);
228: p_to_arrears := 0;

Line 227: hr_utility.set_location('Enough earnings to take the entire ded. amount', 15);

223: -- Arrears are not allowed
224: hr_utility.set_location('Arrearage not allowed',10);
225: If p_net_asg_run - p_dedn_amt >= p_guaranteed_net Then
226: -- There are enough earnings to take the entire deduction amount.
227: hr_utility.set_location('Enough earnings to take the entire ded. amount', 15);
228: p_to_arrears := 0;
229: p_not_taken := 0;
230: l_dedn_amt := p_dedn_amt;
231:

Line 235: hr_utility.set_location('Not enough earnings, so ded. amt goes as not taken amt',20);

231:
232: ElsIf p_net_asg_run <= p_guaranteed_net Then
233: -- Not enough earnings to take the deduction and as arrears are not
234: -- allowed the entire deduction amount goes as not taken.
235: hr_utility.set_location('Not enough earnings, so ded. amt goes as not taken amt',20);
236: p_to_arrears := 0;
237: p_not_taken := p_dedn_amt;
238: l_dedn_amt := 0;
239:

Line 245: hr_utility.set_location('Partial allowed and part of the ded. amt can be taken',25);

241: l_partial_allowed = 'Y' Then
242: -- If partial deduction amount can be taken and partial deductions are
243: -- allowed for the element then take partial amount and the rest goes
244: -- as not taken amount.
245: hr_utility.set_location('Partial allowed and part of the ded. amt can be taken',25);
246: p_to_arrears := 0;
247: p_not_taken := p_dedn_amt - (p_net_asg_run - p_guaranteed_net);
248: l_dedn_amt := p_net_asg_run - p_guaranteed_net;
249:

Line 254: hr_utility.set_location('Partial NOT allowed so entire ded. amt goes as not taken amt',30);

250: ElsIf p_net_asg_run - p_dedn_amt < p_guaranteed_net and
251: l_partial_allowed = 'N' Then
252: -- Even if partial deduction amount can be taken but partial deduction
253: -- is NOT allowed then the entire amount is considered as not_taken.
254: hr_utility.set_location('Partial NOT allowed so entire ded. amt goes as not taken amt',30);
255: p_to_arrears := 0;
256: p_not_taken := p_dedn_amt;
257: l_dedn_amt := 0;
258: End If;

Line 260: hr_utility.set_location('Arrearage Allowed',35);

256: p_not_taken := p_dedn_amt;
257: l_dedn_amt := 0;
258: End If;
259: Else -- Arrearage is on, try and clear any balance currently in arrears.
260: hr_utility.set_location('Arrearage Allowed',35);
261: If p_net_asg_run <= p_guaranteed_net Then
262: -- Earnings are not enough to take the deduction amount, hence put the
263: -- entire amount into arrears as well as not_taken.
264: hr_utility.set_location('Earnings not enough, so ded. amt goes into arrears',40);

Line 264: hr_utility.set_location('Earnings not enough, so ded. amt goes into arrears',40);

260: hr_utility.set_location('Arrearage Allowed',35);
261: If p_net_asg_run <= p_guaranteed_net Then
262: -- Earnings are not enough to take the deduction amount, hence put the
263: -- entire amount into arrears as well as not_taken.
264: hr_utility.set_location('Earnings not enough, so ded. amt goes into arrears',40);
265: p_to_arrears := p_dedn_amt;
266: p_not_taken := p_dedn_amt;
267: l_dedn_amt := 0;
268: Else

Line 270: hr_utility.set_location('Take the arrears amount if present',45);

266: p_not_taken := p_dedn_amt;
267: l_dedn_amt := 0;
268: Else
269: -- take into consideration the arrears amount.
270: hr_utility.set_location('Take the arrears amount if present',45);
271: If p_remaining_amount = p_maxarrears Then
272: p_arrears_taken := p_maxarrears;
273: l_total_dedn := p_dedn_amt + p_arrears_taken;
274: Else

Line 280: hr_utility.set_location('Earnings enough to take the ded + Arr Amt',50);

276: l_total_dedn := p_dedn_amt + p_arrears_taken;
277: End If;
278: If p_net_asg_run - p_guaranteed_net >= l_total_dedn Then
279: -- Enough earnings to the arrears along with the deduction amount
280: hr_utility.set_location('Earnings enough to take the ded + Arr Amt',50);
281: p_to_arrears := -1 * p_arrears_taken;
282: l_dedn_amt := l_total_dedn;
283: p_not_taken := 0;
284: ElsIf l_partial_allowed = 'Y' Then

Line 291: hr_utility.set_location('Enough earnings to take the entire ded amt',55);

287: p_to_arrears := (l_total_dedn - (p_net_asg_run - p_guaranteed_net)) +
288: (-1 * p_arrears_taken);
289: p_arrears_taken := abs(p_to_arrears);
290: If (p_net_asg_run - p_guaranteed_net) >= p_dedn_amt Then
291: hr_utility.set_location('Enough earnings to take the entire ded amt',55);
292: p_not_taken := 0;
293: Else
294: p_not_taken := p_dedn_amt - (p_net_asg_run - p_guaranteed_net);
295: hr_utility.set_location('Earnings NOT enough and taking partial amt',60);

Line 295: hr_utility.set_location('Earnings NOT enough and taking partial amt',60);

291: hr_utility.set_location('Enough earnings to take the entire ded amt',55);
292: p_not_taken := 0;
293: Else
294: p_not_taken := p_dedn_amt - (p_net_asg_run - p_guaranteed_net);
295: hr_utility.set_location('Earnings NOT enough and taking partial amt',60);
296: End If;
297: l_dedn_amt := p_net_asg_run - p_guaranteed_net;
298:
299: ElsIf l_partial_allowed = 'N' Then

Line 300: hr_utility.set_location('Partial NOT allowed',65);

296: End If;
297: l_dedn_amt := p_net_asg_run - p_guaranteed_net;
298:
299: ElsIf l_partial_allowed = 'N' Then
300: hr_utility.set_location('Partial NOT allowed',65);
301: If (p_net_asg_run - p_guaranteed_net) >= p_dedn_amt Then
302: hr_utility.set_location('Enough earnings to take the entire ded. amt',70);
303: l_dedn_amt := p_dedn_amt;
304: p_to_arrears := 0;

Line 302: hr_utility.set_location('Enough earnings to take the entire ded. amt',70);

298:
299: ElsIf l_partial_allowed = 'N' Then
300: hr_utility.set_location('Partial NOT allowed',65);
301: If (p_net_asg_run - p_guaranteed_net) >= p_dedn_amt Then
302: hr_utility.set_location('Enough earnings to take the entire ded. amt',70);
303: l_dedn_amt := p_dedn_amt;
304: p_to_arrears := 0;
305: p_not_taken := 0;
306: Else

Line 307: hr_utility.set_location('Earnings NOT enough, ded.amt goes into arrears',75);

303: l_dedn_amt := p_dedn_amt;
304: p_to_arrears := 0;
305: p_not_taken := 0;
306: Else
307: hr_utility.set_location('Earnings NOT enough, ded.amt goes into arrears',75);
308: p_to_arrears := p_dedn_amt;
309: p_not_taken := p_dedn_amt;
310: l_dedn_amt := 0;
311: End If;

Line 315: hr_utility.set_location('To Arrears ='||p_to_arrears,40);

311: End If;
312: End If;
313: End If;
314: End If;
315: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
316: hr_utility.set_location('Not Taken ='||p_not_taken,45);
317: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
318: hr_utility.set_location('Leaving : '||l_process_name,150);
319: Return l_dedn_amt;

Line 316: hr_utility.set_location('Not Taken ='||p_not_taken,45);

312: End If;
313: End If;
314: End If;
315: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
316: hr_utility.set_location('Not Taken ='||p_not_taken,45);
317: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
318: hr_utility.set_location('Leaving : '||l_process_name,150);
319: Return l_dedn_amt;
320:

Line 317: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);

313: End If;
314: End If;
315: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
316: hr_utility.set_location('Not Taken ='||p_not_taken,45);
317: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
318: hr_utility.set_location('Leaving : '||l_process_name,150);
319: Return l_dedn_amt;
320:
321: Exception

Line 318: hr_utility.set_location('Leaving : '||l_process_name,150);

314: End If;
315: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
316: hr_utility.set_location('Not Taken ='||p_not_taken,45);
317: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
318: hr_utility.set_location('Leaving : '||l_process_name,150);
319: Return l_dedn_amt;
320:
321: Exception
322: When Others Then

Line 324: hr_utility.set_location('Error Code :'||SQLCODE,150);

320:
321: Exception
322: When Others Then
323: l_dedn_amt := 0;
324: hr_utility.set_location('Error Code :'||SQLCODE,150);
325: hr_utility.set_location('Error Msg :'||SQLERRM,160);
326: hr_utility.set_location('Leaving :'||l_process_name, 170);
327: Raise;
328:

Line 325: hr_utility.set_location('Error Msg :'||SQLERRM,160);

321: Exception
322: When Others Then
323: l_dedn_amt := 0;
324: hr_utility.set_location('Error Code :'||SQLCODE,150);
325: hr_utility.set_location('Error Msg :'||SQLERRM,160);
326: hr_utility.set_location('Leaving :'||l_process_name, 170);
327: Raise;
328:
329: END Arrearage;

Line 326: hr_utility.set_location('Leaving :'||l_process_name, 170);

322: When Others Then
323: l_dedn_amt := 0;
324: hr_utility.set_location('Error Code :'||SQLCODE,150);
325: hr_utility.set_location('Error Msg :'||SQLERRM,160);
326: hr_utility.set_location('Leaving :'||l_process_name, 170);
327: Raise;
328:
329: END Arrearage;
330:

Line 366: hr_utility.set_location('Entering: '||l_process_name, 5);

362: l_partial_allowed Varchar2(2);
363: l_process_name Varchar2(150) := g_pkg_name||'Iterative_Arrearage';
364:
365: Begin
366: hr_utility.set_location('Entering: '||l_process_name, 5);
367: If Trim(p_partial_allowed) Is Null And
368: Trim(p_arrears_allowed) Is Null Then
369: If g_Element_Arr_Values.EXISTS(p_eletype_id) Then
370: l_arrears_allowed := g_Element_Arr_Values(p_eletype_id).arrears_allowed;

Line 390: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);

386: g_Element_Arr_Values(p_eletype_id).partial_allowed := p_partial_allowed;
387: l_arrears_allowed := p_arrears_allowed;
388: l_partial_allowed := p_partial_allowed;
389: End If;
390: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);
391: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);
392:
393: If p_iter_count <= 1 Then
394: If g_Element_Values.EXISTS(p_ele_entryid) Then

Line 391: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);

387: l_arrears_allowed := p_arrears_allowed;
388: l_partial_allowed := p_partial_allowed;
389: End If;
390: hr_utility.set_location('..l_arrears_allowed: '||l_arrears_allowed, 6);
391: hr_utility.set_location('..l_partial_allowed: '||l_partial_allowed, 7);
392:
393: If p_iter_count <= 1 Then
394: If g_Element_Values.EXISTS(p_ele_entryid) Then
395: l_actual_usercalc_amt := g_Element_Values(p_ele_entryid).actual_usercalc_amt;

Line 402: hr_utility.set_location('Deduction formula call the first time', 10);

398: l_actual_usercalc_amt := p_dedn_amt;
399: Else
400: l_actual_usercalc_amt := NVL(l_actual_usercalc_amt,0);
401: End If;
402: hr_utility.set_location('Deduction formula call the first time', 10);
403: hr_utility.set_location('Iteration Count='||p_iter_count,15);
404: l_dedn_amt := Arrearage
405: (p_eletype_id => p_eletype_id
406: ,p_ele_entryid => p_ele_entryid

Line 403: hr_utility.set_location('Iteration Count='||p_iter_count,15);

399: Else
400: l_actual_usercalc_amt := NVL(l_actual_usercalc_amt,0);
401: End If;
402: hr_utility.set_location('Deduction formula call the first time', 10);
403: hr_utility.set_location('Iteration Count='||p_iter_count,15);
404: l_dedn_amt := Arrearage
405: (p_eletype_id => p_eletype_id
406: ,p_ele_entryid => p_ele_entryid
407: ,p_assignment_id => p_assignment_id

Line 423: hr_utility.set_location('Iteration Count='||p_iter_count,15);

419: ,p_partial_allowed => l_partial_allowed
420: ,p_arrears_allowed => l_arrears_allowed
421: );
422: Else
423: hr_utility.set_location('Iteration Count='||p_iter_count,15);
424: p_to_arrears := 0;
425: p_not_taken := 0;
426:
427: If l_arrears_allowed = 'N' And

Line 429: hr_utility.set_location('Arrears as well as Partial amount is not allowed',20);

425: p_not_taken := 0;
426:
427: If l_arrears_allowed = 'N' And
428: l_partial_allowed = 'N' Then
429: hr_utility.set_location('Arrears as well as Partial amount is not allowed',20);
430: p_to_arrears := 0;
431: If p_dedn_amt <> p_maxdesired_amt Then
432: p_not_taken := p_maxdesired_amt;
433: l_dedn_amt := 0;

Line 440: hr_utility.set_location('Arrears not allowed, but Partial deduction is allowed',25);

436: l_dedn_amt := p_maxdesired_amt;
437: End If;
438: ElsIf l_arrears_allowed = 'N' And
439: l_partial_allowed = 'Y' Then
440: hr_utility.set_location('Arrears not allowed, but Partial deduction is allowed',25);
441: p_to_arrears := 0;
442: p_not_taken := p_maxdesired_amt - p_dedn_amt;
443: l_dedn_amt := p_dedn_amt;
444: ElsIf l_arrears_allowed = 'Y' And

Line 446: hr_utility.set_location('Arrears is allowed , but Partial deduction is not allowed',30);

442: p_not_taken := p_maxdesired_amt - p_dedn_amt;
443: l_dedn_amt := p_dedn_amt;
444: ElsIf l_arrears_allowed = 'Y' And
445: l_partial_allowed = 'N' Then
446: hr_utility.set_location('Arrears is allowed , but Partial deduction is not allowed',30);
447: If p_dedn_amt < p_maxdesired_amt Then
448: p_to_arrears := p_maxdesired_amt;
449: p_not_taken := p_maxdesired_amt;
450: l_dedn_amt := 0;

Line 458: hr_utility.set_location('Arrears as well as Partial deduction is allowed',35);

454: l_dedn_amt := p_dedn_amt;
455: End If;
456: ElsIf l_arrears_allowed = 'Y' And
457: l_partial_allowed = 'Y' Then
458: hr_utility.set_location('Arrears as well as Partial deduction is allowed',35);
459: If p_dedn_amt >= p_maxdesired_amt Then
460: p_not_taken := 0;
461: p_to_arrears := p_maxdesired_amt - p_dedn_amt;
462: Else

Line 469: hr_utility.set_location('To Arrears ='||p_to_arrears,40);

465: End If;
466: l_dedn_amt := p_dedn_amt;
467: End If;
468: End If; -- p_iter_count = 1
469: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
470: hr_utility.set_location('Not Taken ='||p_not_taken,45);
471: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
472: hr_utility.set_location('Leaving: '||l_process_name,150);
473: Return l_dedn_amt;

Line 470: hr_utility.set_location('Not Taken ='||p_not_taken,45);

466: l_dedn_amt := p_dedn_amt;
467: End If;
468: End If; -- p_iter_count = 1
469: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
470: hr_utility.set_location('Not Taken ='||p_not_taken,45);
471: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
472: hr_utility.set_location('Leaving: '||l_process_name,150);
473: Return l_dedn_amt;
474: Exception

Line 471: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);

467: End If;
468: End If; -- p_iter_count = 1
469: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
470: hr_utility.set_location('Not Taken ='||p_not_taken,45);
471: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
472: hr_utility.set_location('Leaving: '||l_process_name,150);
473: Return l_dedn_amt;
474: Exception
475: When Others Then

Line 472: hr_utility.set_location('Leaving: '||l_process_name,150);

468: End If; -- p_iter_count = 1
469: hr_utility.set_location('To Arrears ='||p_to_arrears,40);
470: hr_utility.set_location('Not Taken ='||p_not_taken,45);
471: hr_utility.set_location('Ded. Amount ='||l_dedn_amt,50);
472: hr_utility.set_location('Leaving: '||l_process_name,150);
473: Return l_dedn_amt;
474: Exception
475: When Others Then
476: l_dedn_amt := 0;

Line 478: hr_utility.set_location('Error Code :'||SQLCODE,150);

474: Exception
475: When Others Then
476: l_dedn_amt := 0;
477: p_error_message := 'Exception: When Others at :'||l_process_name;
478: hr_utility.set_location('Error Code :'||SQLCODE,150);
479: hr_utility.set_location('Error Msg :'||SQLERRM,160);
480: hr_utility.set_location('Leaving :'||l_process_name, 170);
481: Raise;
482: END Iterative_Arrearage;

Line 479: hr_utility.set_location('Error Msg :'||SQLERRM,160);

475: When Others Then
476: l_dedn_amt := 0;
477: p_error_message := 'Exception: When Others at :'||l_process_name;
478: hr_utility.set_location('Error Code :'||SQLCODE,150);
479: hr_utility.set_location('Error Msg :'||SQLERRM,160);
480: hr_utility.set_location('Leaving :'||l_process_name, 170);
481: Raise;
482: END Iterative_Arrearage;
483:

Line 480: hr_utility.set_location('Leaving :'||l_process_name, 170);

476: l_dedn_amt := 0;
477: p_error_message := 'Exception: When Others at :'||l_process_name;
478: hr_utility.set_location('Error Code :'||SQLCODE,150);
479: hr_utility.set_location('Error Msg :'||SQLERRM,160);
480: hr_utility.set_location('Leaving :'||l_process_name, 170);
481: Raise;
482: END Iterative_Arrearage;
483:
484: -- ============================================================

Line 518: hr_utility.set_location('Entering: '||l_process_name, 5);

514: l_to_with_amt number;
515: l_process_name Varchar2(250) := g_pkg_name||'Set_Iteration_Values';
516: Begin
517:
518: hr_utility.set_location('Entering: '||l_process_name, 5);
519: If g_Element_Values.EXISTS(p_ele_entryid) Then
520: hr_utility.set_location('Element Entry exits in PL/SQL table'||p_ele_entryid,10);
521: Else
522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);

Line 520: hr_utility.set_location('Element Entry exits in PL/SQL table'||p_ele_entryid,10);

516: Begin
517:
518: hr_utility.set_location('Entering: '||l_process_name, 5);
519: If g_Element_Values.EXISTS(p_ele_entryid) Then
520: hr_utility.set_location('Element Entry exits in PL/SQL table'||p_ele_entryid,10);
521: Else
522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);
523: End If;
524: hr_utility.set_location('ded amt='||p_deduction_amount,15);

Line 522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);

518: hr_utility.set_location('Entering: '||l_process_name, 5);
519: If g_Element_Values.EXISTS(p_ele_entryid) Then
520: hr_utility.set_location('Element Entry exits in PL/SQL table'||p_ele_entryid,10);
521: Else
522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);
523: End If;
524: hr_utility.set_location('ded amt='||p_deduction_amount,15);
525: hr_utility.set_location('max amt='||p_max_amount, 20);
526: hr_utility.set_location('min amt='||p_min_amount, 25);

Line 524: hr_utility.set_location('ded amt='||p_deduction_amount,15);

520: hr_utility.set_location('Element Entry exits in PL/SQL table'||p_ele_entryid,10);
521: Else
522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);
523: End If;
524: hr_utility.set_location('ded amt='||p_deduction_amount,15);
525: hr_utility.set_location('max amt='||p_max_amount, 20);
526: hr_utility.set_location('min amt='||p_min_amount, 25);
527: hr_utility.set_location('max desired amt='||p_maxdesired_amt,30);
528: If g_Element_Arr_Values.EXISTS(p_eletype_id) Then

Line 525: hr_utility.set_location('max amt='||p_max_amount, 20);

521: Else
522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);
523: End If;
524: hr_utility.set_location('ded amt='||p_deduction_amount,15);
525: hr_utility.set_location('max amt='||p_max_amount, 20);
526: hr_utility.set_location('min amt='||p_min_amount, 25);
527: hr_utility.set_location('max desired amt='||p_maxdesired_amt,30);
528: If g_Element_Arr_Values.EXISTS(p_eletype_id) Then
529: l_arrears_allowed := g_Element_Arr_Values(p_eletype_id).arrears_allowed;

Line 526: hr_utility.set_location('min amt='||p_min_amount, 25);

522: hr_utility.set_location('Element Entry does NOT exists in PL/SQL table'||p_ele_entryid,10);
523: End If;
524: hr_utility.set_location('ded amt='||p_deduction_amount,15);
525: hr_utility.set_location('max amt='||p_max_amount, 20);
526: hr_utility.set_location('min amt='||p_min_amount, 25);
527: hr_utility.set_location('max desired amt='||p_maxdesired_amt,30);
528: If g_Element_Arr_Values.EXISTS(p_eletype_id) Then
529: l_arrears_allowed := g_Element_Arr_Values(p_eletype_id).arrears_allowed;
530: l_partial_allowed := g_Element_Arr_Values(p_eletype_id).partial_allowed;

Line 527: hr_utility.set_location('max desired amt='||p_maxdesired_amt,30);

523: End If;
524: hr_utility.set_location('ded amt='||p_deduction_amount,15);
525: hr_utility.set_location('max amt='||p_max_amount, 20);
526: hr_utility.set_location('min amt='||p_min_amount, 25);
527: hr_utility.set_location('max desired amt='||p_maxdesired_amt,30);
528: If g_Element_Arr_Values.EXISTS(p_eletype_id) Then
529: l_arrears_allowed := g_Element_Arr_Values(p_eletype_id).arrears_allowed;
530: l_partial_allowed := g_Element_Arr_Values(p_eletype_id).partial_allowed;
531: Else

Line 559: hr_utility.set_location('Leaving: '||l_process_name, 150);

555: g_Element_Values(p_ele_entryid).calc_method := l_calc_method;
556: g_Element_Values(p_ele_entryid).to_within := l_to_with_amt;
557: g_Element_Values(p_ele_entryid).clr_add_amt := p_clr_add_amt;
558: g_Element_Values(p_ele_entryid).clr_rep_amt := p_clr_rep_amt;
559: hr_utility.set_location('Leaving: '||l_process_name, 150);
560:
561: Return l_return_value;
562:
563: Exception

Line 567: hr_utility.set_location('Error : '||p_error_message, 160);

563: Exception
564: When Others Then
565: l_return_value := -1;
566: p_error_message := 'Exception: When Others at '||l_process_name;
567: hr_utility.set_location('Error : '||p_error_message, 160);
568: hr_utility.set_location('Leaving: '||l_process_name, 170);
569:
570: Return l_return_value;
571:

Line 568: hr_utility.set_location('Leaving: '||l_process_name, 170);

564: When Others Then
565: l_return_value := -1;
566: p_error_message := 'Exception: When Others at '||l_process_name;
567: hr_utility.set_location('Error : '||p_error_message, 160);
568: hr_utility.set_location('Leaving: '||l_process_name, 170);
569:
570: Return l_return_value;
571:
572: End Set_Iteration_Values;

Line 589: hr_utility.set_location('Entering: '||l_process_name, 5);

585: l_process_name Varchar2(150) := g_pkg_name||'Set_Formula_Warning_Mesg';
586: l_return_value Number := 0;
587: l_error_message varchar2(3000);
588: Begin
589: hr_utility.set_location('Entering: '||l_process_name, 5);
590: If g_Element_Values.EXISTS(p_ele_entryid) Then
591: g_Element_Values(p_ele_entryid).formula_warning := NVL(p_warning_message,'X');
592: g_Element_Values(p_ele_entryid).warning_code := NVL(p_warning_code, 'X');
593: End If;

Line 594: hr_utility.set_location('Leaving: '||l_process_name, 150);

590: If g_Element_Values.EXISTS(p_ele_entryid) Then
591: g_Element_Values(p_ele_entryid).formula_warning := NVL(p_warning_message,'X');
592: g_Element_Values(p_ele_entryid).warning_code := NVL(p_warning_code, 'X');
593: End If;
594: hr_utility.set_location('Leaving: '||l_process_name, 150);
595: Return l_return_value;
596: Exception
597: When Others Then
598: l_return_value := -1;

Line 600: hr_utility.set_location('Error : '||l_error_message, 160);

596: Exception
597: When Others Then
598: l_return_value := -1;
599: l_error_message := SQLERRM;
600: hr_utility.set_location('Error : '||l_error_message, 160);
601: hr_utility.set_location('Leaving: '||l_process_name, 170);
602: Return l_return_value;
603: End Set_Formula_Warning_Mesg;
604: -- ============================================================

Line 601: hr_utility.set_location('Leaving: '||l_process_name, 170);

597: When Others Then
598: l_return_value := -1;
599: l_error_message := SQLERRM;
600: hr_utility.set_location('Error : '||l_error_message, 160);
601: hr_utility.set_location('Leaving: '||l_process_name, 170);
602: Return l_return_value;
603: End Set_Formula_Warning_Mesg;
604: -- ============================================================
605: -- ~ Get_Formula_Warning_Mesg: get the formula warn. messgage

Line 620: hr_utility.set_location('Entering: '||l_process_name, 5);

616: l_process_name Varchar2(150) := g_pkg_name||'Get_Formula_Warning_Mesg';
617: l_return_value Number := 0;
618: l_error_message varchar2(3000);
619: Begin
620: hr_utility.set_location('Entering: '||l_process_name, 5);
621: If g_Element_Values.EXISTS(p_ele_entryid) Then
622: p_warning_message := NVL(g_Element_Values(p_ele_entryid).formula_warning,'X');
623: p_warning_message := NVL(g_Element_Values(p_ele_entryid).warning_code, 'X');
624: End If;

Line 625: hr_utility.set_location('Leaving: '||l_process_name, 150);

621: If g_Element_Values.EXISTS(p_ele_entryid) Then
622: p_warning_message := NVL(g_Element_Values(p_ele_entryid).formula_warning,'X');
623: p_warning_message := NVL(g_Element_Values(p_ele_entryid).warning_code, 'X');
624: End If;
625: hr_utility.set_location('Leaving: '||l_process_name, 150);
626: Return l_return_value;
627: Exception
628: When Others Then
629: l_return_value := -1;

Line 631: hr_utility.set_location('Error : '||l_error_message, 160);

627: Exception
628: When Others Then
629: l_return_value := -1;
630: l_error_message := SQLERRM;
631: hr_utility.set_location('Error : '||l_error_message, 160);
632: hr_utility.set_location('Leaving: '||l_process_name, 170);
633: Return l_return_value;
634: End Get_Formula_Warning_Mesg;
635: -- ============================================================

Line 632: hr_utility.set_location('Leaving: '||l_process_name, 170);

628: When Others Then
629: l_return_value := -1;
630: l_error_message := SQLERRM;
631: hr_utility.set_location('Error : '||l_error_message, 160);
632: hr_utility.set_location('Leaving: '||l_process_name, 170);
633: Return l_return_value;
634: End Get_Formula_Warning_Mesg;
635: -- ============================================================
636: -- ~Get_Iteration_Values:

Line 669: hr_utility.set_location('Entering: '||l_process_name, 5);

665: l_partial_allowed Varchar2(2);
666:
667: Begin
668:
669: hr_utility.set_location('Entering: '||l_process_name, 5);
670: If g_Element_Values.EXISTS(p_ele_entryid) Then
671: p_iter_count := g_Element_Values(p_ele_entryid).iter_count;
672: p_max_amount := g_Element_Values(p_ele_entryid).max_amount;
673: p_min_amount := g_Element_Values(p_ele_entryid).min_amount;

Line 685: hr_utility.set_location('Iteration Count ='|| p_iter_count,145);

681: p_calc_method := g_Element_Values(p_ele_entryid).calc_method;
682: p_to_within := g_Element_Values(p_ele_entryid).to_within;
683: p_clr_add_amt := g_Element_Values(p_ele_entryid).clr_add_amt;
684: p_clr_rep_amt := g_Element_Values(p_ele_entryid).clr_rep_amt;
685: hr_utility.set_location('Iteration Count ='|| p_iter_count,145);
686: Else
687: If g_Element_Arr_Values.EXISTS(p_eletype_id) Then
688: l_arrears_allowed := g_Element_Arr_Values(p_eletype_id).arrears_allowed;
689: l_partial_allowed := g_Element_Arr_Values(p_eletype_id).partial_allowed;

Line 723: hr_utility.set_location('Element Values does not exists in PL/SQL table :g_Element_Values',145);

719: p_partial_allowed := l_partial_allowed;
720: p_clr_add_amt := 0;
721: p_clr_rep_amt := 0;
722: p_warning_message := 'Element Values does not exists in PL/SQL table :g_Element_Values';
723: hr_utility.set_location('Element Values does not exists in PL/SQL table :g_Element_Values',145);
724: hr_utility.set_location('Iteration Count ='|| p_iter_count,145);
725: End If;
726: hr_utility.set_location('Leaving: '||l_process_name, 150);
727:

Line 724: hr_utility.set_location('Iteration Count ='|| p_iter_count,145);

720: p_clr_add_amt := 0;
721: p_clr_rep_amt := 0;
722: p_warning_message := 'Element Values does not exists in PL/SQL table :g_Element_Values';
723: hr_utility.set_location('Element Values does not exists in PL/SQL table :g_Element_Values',145);
724: hr_utility.set_location('Iteration Count ='|| p_iter_count,145);
725: End If;
726: hr_utility.set_location('Leaving: '||l_process_name, 150);
727:
728: Return l_return_value;

Line 726: hr_utility.set_location('Leaving: '||l_process_name, 150);

722: p_warning_message := 'Element Values does not exists in PL/SQL table :g_Element_Values';
723: hr_utility.set_location('Element Values does not exists in PL/SQL table :g_Element_Values',145);
724: hr_utility.set_location('Iteration Count ='|| p_iter_count,145);
725: End If;
726: hr_utility.set_location('Leaving: '||l_process_name, 150);
727:
728: Return l_return_value;
729:
730: Exception

Line 734: hr_utility.set_location('Error : '||p_error_message, 160);

730: Exception
731: When Others Then
732: l_return_value := -1;
733: p_error_message := 'Exception: When Others at '||l_process_name;
734: hr_utility.set_location('Error : '||p_error_message, 160);
735: hr_utility.set_location('Leaving: '||l_process_name, 170);
736: Return l_return_value;
737:
738: End Get_Iteration_Values;

Line 735: hr_utility.set_location('Leaving: '||l_process_name, 170);

731: When Others Then
732: l_return_value := -1;
733: p_error_message := 'Exception: When Others at '||l_process_name;
734: hr_utility.set_location('Error : '||p_error_message, 160);
735: hr_utility.set_location('Leaving: '||l_process_name, 170);
736: Return l_return_value;
737:
738: End Get_Iteration_Values;
739:

Line 761: hr_utility.set_location('Entering: '||l_process_name, 5);

757: l_process_name Varchar2(150) := g_pkg_name||'Clear_Iteration_Values';
758:
759: Begin
760:
761: hr_utility.set_location('Entering: '||l_process_name, 5);
762: l_curr_ele_entry_id := g_Element_Values.FIRST;
763: While l_curr_ele_entry_id Is Not Null
764: Loop
765: If (g_Element_Values(l_curr_ele_entry_id).assignment_id <> p_assignment_id)

Line 777: hr_utility.set_location('Warning : '||p_warning_message, 145);

773: l_prev_ele_entry_id := l_curr_ele_entry_id;
774: l_curr_ele_entry_id := g_Element_Values.NEXT(l_prev_ele_entry_id);
775: End Loop;
776: p_warning_message := 'Records deleted from PL/SQL table :'||l_recs_deleted;
777: hr_utility.set_location('Warning : '||p_warning_message, 145);
778: hr_utility.set_location('Leaving : '||l_process_name, 150);
779:
780: Return l_return_value;
781:

Line 778: hr_utility.set_location('Leaving : '||l_process_name, 150);

774: l_curr_ele_entry_id := g_Element_Values.NEXT(l_prev_ele_entry_id);
775: End Loop;
776: p_warning_message := 'Records deleted from PL/SQL table :'||l_recs_deleted;
777: hr_utility.set_location('Warning : '||p_warning_message, 145);
778: hr_utility.set_location('Leaving : '||l_process_name, 150);
779:
780: Return l_return_value;
781:
782: Exception

Line 786: hr_utility.set_location('Error : '||p_error_message, 160);

782: Exception
783: When Others Then
784: l_return_value := -1;
785: p_error_message := 'Exception: When Others at '||l_process_name;
786: hr_utility.set_location('Error : '||p_error_message, 160);
787: hr_utility.set_location('Leaving: '||l_process_name, 170);
788: Return l_return_value;
789: End Clear_Iteration_Values;
790:

Line 787: hr_utility.set_location('Leaving: '||l_process_name, 170);

783: When Others Then
784: l_return_value := -1;
785: p_error_message := 'Exception: When Others at '||l_process_name;
786: hr_utility.set_location('Error : '||p_error_message, 160);
787: hr_utility.set_location('Leaving: '||l_process_name, 170);
788: Return l_return_value;
789: End Clear_Iteration_Values;
790:
791: -- ============================================================

Line 805: hr_utility.set_location('Entering: '||l_process_name, 5);

801: l_return_value Number := 0;
802: l_process_name Varchar2(150) := g_pkg_name||'Incr_Iteration_Count';
803: Begin
804:
805: hr_utility.set_location('Entering: '||l_process_name, 5);
806: If g_Element_Values.EXISTS(p_ele_entryid) Then
807: g_Element_Values(p_ele_entryid).iter_count := g_Element_Values(p_ele_entryid).iter_count + 1;
808: Else
809: l_return_value := 1;

Line 812: hr_utility.set_location('Iteration Count =0',145 );

808: Else
809: l_return_value := 1;
810: p_warning_message := 'Could not find record in PL/SQL table :g_Element_Values '||
811: 'to Incr. the iteration count';
812: hr_utility.set_location('Iteration Count =0',145 );
813: End If;
814: hr_utility.set_location('Leaving: '||l_process_name, 150);
815:
816: Return l_return_value;

Line 814: hr_utility.set_location('Leaving: '||l_process_name, 150);

810: p_warning_message := 'Could not find record in PL/SQL table :g_Element_Values '||
811: 'to Incr. the iteration count';
812: hr_utility.set_location('Iteration Count =0',145 );
813: End If;
814: hr_utility.set_location('Leaving: '||l_process_name, 150);
815:
816: Return l_return_value;
817: Exception
818: When Others Then

Line 821: hr_utility.set_location('Error : '||p_error_message, 160);

817: Exception
818: When Others Then
819: l_return_value := -1;
820: p_error_message := 'Exception: When Others at '||l_process_name;
821: hr_utility.set_location('Error : '||p_error_message, 160);
822: hr_utility.set_location('Leaving: '||l_process_name, 170);
823:
824: Return l_return_value;
825:

Line 822: hr_utility.set_location('Leaving: '||l_process_name, 170);

818: When Others Then
819: l_return_value := -1;
820: p_error_message := 'Exception: When Others at '||l_process_name;
821: hr_utility.set_location('Error : '||p_error_message, 160);
822: hr_utility.set_location('Leaving: '||l_process_name, 170);
823:
824: Return l_return_value;
825:
826: End Incr_Iteration_Count;

Line 843: hr_utility.set_location('Entering: '||l_process_name, 5);

839: l_return_value Number := 0;
840: l_process_name Varchar2(150) := g_pkg_name||'Stop_Iteration';
841: Begin
842:
843: hr_utility.set_location('Entering: '||l_process_name, 5);
844: If g_Element_Values.EXISTS(p_ele_entryid) Then
845: g_Element_Values(p_ele_entryid).stopper_flag := 'Y';
846: Else
847: l_return_value := -1;

Line 851: hr_utility.set_location('Leaving: '||l_process_name, 150);

847: l_return_value := -1;
848: p_warning_message := 'Could not find record in PL/SQL table :g_Element_Values '||
849: 'to set the stopper flag';
850: End If;
851: hr_utility.set_location('Leaving: '||l_process_name, 150);
852:
853: Return l_return_value;
854:
855: Exception

Line 859: hr_utility.set_location('Error : '||p_error_message, 160);

855: Exception
856: When Others Then
857: l_return_value := -1;
858: p_error_message := 'Exception: When Others at '||l_process_name;
859: hr_utility.set_location('Error : '||p_error_message, 160);
860: hr_utility.set_location('Leaving: '||l_process_name, 170);
861:
862: Return l_return_value;
863:

Line 860: hr_utility.set_location('Leaving: '||l_process_name, 170);

856: When Others Then
857: l_return_value := -1;
858: p_error_message := 'Exception: When Others at '||l_process_name;
859: hr_utility.set_location('Error : '||p_error_message, 160);
860: hr_utility.set_location('Leaving: '||l_process_name, 170);
861:
862: Return l_return_value;
863:
864: End Stop_Iteration;

Line 879: hr_utility.set_location('Entering: '||l_process_name, 5);

875: ) Return Number Is
876: l_return_value Number := 0;
877: l_process_name Varchar2(150) := g_pkg_name||'Get_Iteration_Count';
878: Begin
879: hr_utility.set_location('Entering: '||l_process_name, 5);
880: If g_Element_Values.EXISTS(p_ele_entryid) Then
881: l_return_value := g_Element_Values(p_ele_entryid).Iter_Count;
882: Else
883: l_return_value := 0;

Line 887: hr_utility.set_location('Leaving: '||l_process_name, 150);

883: l_return_value := 0;
884: p_warning_message := 'Could not find record in PL/SQL table :g_Element_Values '||
885: 'to get the Iteration Count';
886: End If;
887: hr_utility.set_location('Leaving: '||l_process_name, 150);
888: Return l_return_value;
889:
890: Exception
891: When Others Then

Line 894: hr_utility.set_location('Error : '||p_error_message, 145);

890: Exception
891: When Others Then
892: l_return_value := -1;
893: p_error_message := 'Exception: When Others at '||l_process_name;
894: hr_utility.set_location('Error : '||p_error_message, 145);
895: hr_utility.set_location('Leaving: '||l_process_name, 150);
896: Return l_return_value;
897:
898: End Get_Iteration_Count;

Line 895: hr_utility.set_location('Leaving: '||l_process_name, 150);

891: When Others Then
892: l_return_value := -1;
893: p_error_message := 'Exception: When Others at '||l_process_name;
894: hr_utility.set_location('Error : '||p_error_message, 145);
895: hr_utility.set_location('Leaving: '||l_process_name, 150);
896: Return l_return_value;
897:
898: End Get_Iteration_Count;
899: -- ============================================================

Line 913: hr_utility.set_location('Entering: '||l_process_name, 5);

909: ) Return Varchar2 Is
910: l_return_value Varchar2(2);
911: l_process_name Varchar2(150) := g_pkg_name||'Get_Stopper_Count';
912: Begin
913: hr_utility.set_location('Entering: '||l_process_name, 5);
914: If g_Element_Values.EXISTS(p_ele_entryid) Then
915: l_return_value := g_Element_Values(p_ele_entryid).Stopper_Flag;
916: Else
917: l_return_value := 'N';

Line 921: hr_utility.set_location('Leaving: '||l_process_name, 150);

917: l_return_value := 'N';
918: p_warning_message := 'Could not find record in PL/SQL table :g_Element_Values '||
919: 'to get the Stopper Flag';
920: End If;
921: hr_utility.set_location('Leaving: '||l_process_name, 150);
922: Return l_return_value;
923:
924: Exception
925: When Others Then

Line 928: hr_utility.set_location('Error : '||p_error_message, 145);

924: Exception
925: When Others Then
926: l_return_value := -1;
927: p_error_message := 'Exception: When Others at '||l_process_name;
928: hr_utility.set_location('Error : '||p_error_message, 145);
929: hr_utility.set_location('Leaving: '||l_process_name, 150);
930: Return l_return_value;
931:
932: End Get_Stopper_Flag;

Line 929: hr_utility.set_location('Leaving: '||l_process_name, 150);

925: When Others Then
926: l_return_value := -1;
927: p_error_message := 'Exception: When Others at '||l_process_name;
928: hr_utility.set_location('Error : '||p_error_message, 145);
929: hr_utility.set_location('Leaving: '||l_process_name, 150);
930: Return l_return_value;
931:
932: End Get_Stopper_Flag;
933: