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_ACTUAL_CMMTMNT_PKG dependencies on HR_UTILITY

Line 84: hr_utility.set_location('Payroll calculation, dates passed: '||p_start_date ||' - '||p_end_date||' > '||p_assignment_id, 71);

80:
81: l_last_date date;
82:
83: BEGIN
84: hr_utility.set_location('Payroll calculation, dates passed: '||p_start_date ||' - '||p_end_date||' > '||p_assignment_id, 71);
85: OPEN csr_last_dt;
86: FETCH csr_last_dt INTO l_last_date;
87: CLOSE csr_last_dt;
88:

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

103: l_proc varchar2(72) := g_package || 'Validate_budget';
104: --
105: Begin
106: --
107: hr_utility.set_location('Entering :'||l_proc,5);
108: --
109: -- VALIDATE IF THIS IS A VALID BUDGET IN PQH_BUDGETS
110: --
111: Open csr_bdgt;

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

120: End if;
121: --
122: Close csr_bdgt;
123: --
124: hr_utility.set_location('Leaving :'||l_proc,10);
125: EXCEPTION
126: WHEN OTHERS THEN
127: p_budget_id := null;
128: hr_utility.set_location('Exception :'||l_proc,15);

Line 128: hr_utility.set_location('Exception :'||l_proc,15);

124: hr_utility.set_location('Leaving :'||l_proc,10);
125: EXCEPTION
126: WHEN OTHERS THEN
127: p_budget_id := null;
128: hr_utility.set_location('Exception :'||l_proc,15);
129: raise;
130: End;
131: ------------------------------------------------------------------------------
132: PROCEDURE Validate_position(p_position_id in number,

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

154: l_proc varchar2(72) := g_package ||'Validate_position';
155: --
156: Begin
157: --
158: hr_utility.set_location('Entering :'||l_proc,5);
159: --
160: --
161: -- validate if the position is in hr_all_positions_f
162: --

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

180: End if;
181: --
182: Close csr_positions_in_bdgt;
183: --
184: hr_utility.set_location('Leaving :'||l_proc,10);
185: EXCEPTION
186: WHEN OTHERS THEN
187: hr_utility.set_location('Exception :'||l_proc,15);
188: raise;

Line 187: hr_utility.set_location('Exception :'||l_proc,15);

183: --
184: hr_utility.set_location('Leaving :'||l_proc,10);
185: EXCEPTION
186: WHEN OTHERS THEN
187: hr_utility.set_location('Exception :'||l_proc,15);
188: raise;
189: End;
190: --------------------------------------------------------------------------
191: PROCEDURE Validate_job(p_job_id in number,

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

212: l_proc varchar2(72) := g_package ||'Validate_job';
213: --
214: Begin
215: --
216: hr_utility.set_location('Entering :'||l_proc,5);
217: --
218: --
219: -- validate if the job is in per_jobs
220: --

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

243: FND_MESSAGE.SET_TOKEN('ENTITY',hr_general.decode_lookup('PQH_BUDGET_ENTITY','JOB'));
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: End if;
246: Close csr_jobs_in_bdgt;
247: hr_utility.set_location('Leaving :'||l_proc,10);
248: --
249: EXCEPTION
250: WHEN OTHERS THEN
251: hr_utility.set_location('Exception :'||l_proc,15);

Line 251: hr_utility.set_location('Exception :'||l_proc,15);

247: hr_utility.set_location('Leaving :'||l_proc,10);
248: --
249: EXCEPTION
250: WHEN OTHERS THEN
251: hr_utility.set_location('Exception :'||l_proc,15);
252: raise;
253: End;
254: --------------------------------------------------------------------------
255: PROCEDURE Validate_grade(p_grade_id in number,

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

276: l_proc varchar2(72) := g_package ||'Validate_grade';
277: --
278: Begin
279: --
280: hr_utility.set_location('Entering :'||l_proc,5);
281: --
282: -- validate if the grade is in per_grades
283: --
284: Open csr_grade;

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

305: APP_EXCEPTION.RAISE_EXCEPTION;
306: End if;
307: Close csr_grades_in_bdgt;
308: --
309: hr_utility.set_location('Leaving :'||l_proc,10);
310: --
311: EXCEPTION
312: WHEN OTHERS THEN
313: hr_utility.set_location('Exception :'||l_proc,15);

Line 313: hr_utility.set_location('Exception :'||l_proc,15);

309: hr_utility.set_location('Leaving :'||l_proc,10);
310: --
311: EXCEPTION
312: WHEN OTHERS THEN
313: hr_utility.set_location('Exception :'||l_proc,15);
314: raise;
315: End;
316: --------------------------------------------------------------------------
317: PROCEDURE Validate_organization(p_organization_id in number,

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

339: l_proc varchar2(72) := g_package ||'Validate_organization';
340: --
341: Begin
342: --
343: hr_utility.set_location('Entering :'||l_proc,5);
344: --
345: -- validate if the organization is in hr_organization_units
346: --
347: Open csr_organization;

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

367: APP_EXCEPTION.RAISE_EXCEPTION;
368: End if;
369: Close csr_orgs_in_bdgt;
370: --
371: hr_utility.set_location('Leaving :'||l_proc,10);
372: --
373: EXCEPTION
374: WHEN OTHERS THEN
375: hr_utility.set_location('Exception :'||l_proc,15);

Line 375: hr_utility.set_location('Exception :'||l_proc,15);

371: hr_utility.set_location('Leaving :'||l_proc,10);
372: --
373: EXCEPTION
374: WHEN OTHERS THEN
375: hr_utility.set_location('Exception :'||l_proc,15);
376: raise;
377: End;
378: --------------------------------------------------------------------------
379: PROCEDURE Validate_assignment(p_assignment_id in number)

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

388: l_proc varchar2(72) := g_package ||'Validate_assignment';
389: --
390: Begin
391: --
392: hr_utility.set_location('Entering :'||l_proc,5);
393: --
394: Open csr_assg;
395: Fetch csr_assg into l_dummy;
396: If csr_assg%notfound then

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

399: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ASSIGNMENT');
400: APP_EXCEPTION.RAISE_EXCEPTION;
401: --
402: End if;
403: hr_utility.set_location('Leaving :'||l_proc,10);
404: Close csr_assg;
405: --
406: EXCEPTION
407: WHEN OTHERS THEN

Line 408: hr_utility.set_location('Exception :'||l_proc,15);

404: Close csr_assg;
405: --
406: EXCEPTION
407: WHEN OTHERS THEN
408: hr_utility.set_location('Exception :'||l_proc,15);
409: raise;
410: End;
411: --------------------------------------------------------------------------
412: PROCEDURE Validate_element_type(p_element_type_id in number)

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

420: l_proc varchar2(72) := g_package ||'Validate_element_type';
421: --
422: Begin
423: --
424: hr_utility.set_location('Entering :'||l_proc,5);
425: --
426: if p_element_type_id is not null then
427: Open csr_elmnt_type;
428: Fetch csr_elmnt_type into l_dummy;

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

436: FND_MESSAGE.SET_NAME('PQH','PQH_ACT_INVALID_ELMNT_TYPE');
437: APP_EXCEPTION.RAISE_EXCEPTION;
438: end if;
439: --
440: hr_utility.set_location('Leaving :'||l_proc,10);
441: EXCEPTION
442: WHEN OTHERS THEN
443: hr_utility.set_location('Leaving :'||l_proc,15);
444: raise;

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

439: --
440: hr_utility.set_location('Leaving :'||l_proc,10);
441: EXCEPTION
442: WHEN OTHERS THEN
443: hr_utility.set_location('Leaving :'||l_proc,15);
444: raise;
445: End;
446: -------------------------------------------------------------------------------
447: Procedure Validate_unit_of_measure(p_unit_of_measure_id in number,

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

455: AND lookup_type = 'BUDGET_MEASUREMENT_TYPE';
456: --
457: l_proc varchar2(72) := g_package||'Validate_unit_of_measure';
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: -- Check if the unit of measure exists in per_shared_types
461: Open csr_uom;
462: Fetch csr_uom into p_unit_of_measure_desc;
463: If csr_uom%notfound then

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

465: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BUDGET_UOM');
466: APP_EXCEPTION.RAISE_EXCEPTION;
467: End if;
468: Close csr_uom;
469: hr_utility.set_location('Leaving:'||l_proc, 10);
470: --
471: Exception
472: When others then
473: p_unit_of_measure_desc := null;

Line 474: hr_utility.set_location('Exception:'||l_proc, 15);

470: --
471: Exception
472: When others then
473: p_unit_of_measure_desc := null;
474: hr_utility.set_location('Exception:'||l_proc, 15);
475: raise;
476: End;
477: -----------------------------------------------------------------------
478: Procedure Validate_uom_in_budget(p_unit_of_measure_id in number,

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

490: l_proc varchar2(72) := g_package||'Validate_uom_in_budget';
491: l_dummy varchar2(1);
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: -- Check if the budget includes the unit of measure
496: Open csr_uom_in_bdgt;
497: Fetch csr_uom_in_bdgt into l_dummy;
498: If csr_uom_in_bdgt%notfound then

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

500: FND_MESSAGE.SET_NAME('PQH','PQH_UOM_NOT_IN_BDGT');
501: APP_EXCEPTION.RAISE_EXCEPTION;
502: End if;
503: Close csr_uom_in_bdgt;
504: hr_utility.set_location('Leaving:'||l_proc, 10);
505: Exception When others then
506: hr_utility.set_location('Exception:'||l_proc, 15);
507: raise;
508: End;

Line 506: hr_utility.set_location('Exception:'||l_proc, 15);

502: End if;
503: Close csr_uom_in_bdgt;
504: hr_utility.set_location('Leaving:'||l_proc, 10);
505: Exception When others then
506: hr_utility.set_location('Exception:'||l_proc, 15);
507: raise;
508: End;
509: -------------------------------------------------------------------------------
510: PROCEDURE Validate_actuals_dates(p_actuals_start_dt in date,

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

521: From pqh_budgets
522: Where budget_id = p_budget_id;
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: -- 1) Check if p_actuals_end_dt > p_actuals_start_dt.
527: If p_actuals_end_dt < p_actuals_start_dt then
528: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');
529: APP_EXCEPTION.RAISE_EXCEPTION;

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

543: if p_actuals_end_dt > l_budget_end_date then
544: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_ACTUALS_END_DT');
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: End if;
547: hr_utility.set_location('Leaving:'||l_proc, 10);
548: Exception When others then
549: hr_utility.set_location('Exception:'||l_proc, 15);
550: raise;
551: End;

Line 549: hr_utility.set_location('Exception:'||l_proc, 15);

545: APP_EXCEPTION.RAISE_EXCEPTION;
546: End if;
547: hr_utility.set_location('Leaving:'||l_proc, 10);
548: Exception When others then
549: hr_utility.set_location('Exception:'||l_proc, 15);
550: raise;
551: End;
552: -------------------------------------------------------------------------
553: PROCEDURE Validate_commitment_dates(p_cmmtmnt_start_dt in date,

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

565: Where budget_id = p_budget_id;
566: --
567: Begin
568: --
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: If p_cmmtmnt_end_dt < p_cmmtmnt_start_dt then
572: FND_MESSAGE.SET_NAME('PQH','PQH_END_DT_LESS_THAN_START_DT');
573: APP_EXCEPTION.RAISE_EXCEPTION;

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

589: if p_cmmtmnt_end_dt > l_budget_end_date then
590: FND_MESSAGE.SET_NAME('PQH','PQH_CMTMNT_END_AFT_BDGT_END');
591: APP_EXCEPTION.RAISE_EXCEPTION;
592: End if;
593: hr_utility.set_location('Leaving:'||l_proc, 10);
594: Exception When others then
595: hr_utility.set_location('Exception:'||l_proc, 15);
596: raise;
597: End;

Line 595: hr_utility.set_location('Exception:'||l_proc, 15);

591: APP_EXCEPTION.RAISE_EXCEPTION;
592: End if;
593: hr_utility.set_location('Leaving:'||l_proc, 10);
594: Exception When others then
595: hr_utility.set_location('Exception:'||l_proc, 15);
596: raise;
597: End;
598: --------------------------------------------------------------------------
599: FUNCTION get_bg_legislation_code (p_business_group_id in number)

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

636: l_proc varchar2(72) := g_package || 'Convert_actuals';
637: --
638: Begin
639: --
640: hr_utility.set_location('Entering :'||l_proc,5);
641: -- No conversion needed if the periods are the same.
642: If p_from_start_date = p_to_start_date
643: AND p_from_end_date = p_to_end_date then
644: RETURN p_figure;

Line 651: hr_utility.set_location('Convert :'||to_char(p_figure) || ' For ' || to_char(l_days_in_from_period

647: l_days_in_from_period := (p_from_end_date - p_from_start_date) + 1;
648: -- Find the days between l_calc_end_date,l_calc_start_date
649: l_days_in_to_period := (p_to_end_date - p_to_start_date) + 1;
650: --
651: hr_utility.set_location('Convert :'||to_char(p_figure) || ' For ' || to_char(l_days_in_from_period
652: ) ||
653: ' days ' || ' To ' || to_char(l_days_in_to_period),10);
654: --
655: l_converted_amt := p_figure * l_days_in_to_period/ l_days_in_from_period ;

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

653: ' days ' || ' To ' || to_char(l_days_in_to_period),10);
654: --
655: l_converted_amt := p_figure * l_days_in_to_period/ l_days_in_from_period ;
656: --
657: hr_utility.set_location('Leaving :'||l_proc,10);
658: RETURN l_converted_amt;
659: Exception When others then
660: hr_utility.set_location('Exception:'||l_proc, 15);
661: raise;

Line 660: hr_utility.set_location('Exception:'||l_proc, 15);

656: --
657: hr_utility.set_location('Leaving :'||l_proc,10);
658: RETURN l_converted_amt;
659: Exception When others then
660: hr_utility.set_location('Exception:'||l_proc, 15);
661: raise;
662: End;
663: --------------------------------------------------------------------------
664: FUNCTION get_pos_budget_values(p_position_id in number,

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

679: l_proc varchar2(72) := g_package||'get_pos_budget_values';
680: --
681: Begin
682: --
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: -- Obtain the business group of the position.
685: Open csr_pos;
686: Fetch csr_pos into l_business_group_id;
687: Close csr_pos;

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

698: p_start_date => p_period_start_dt ,
699: p_end_date => p_period_end_dt ,
700: p_actual_val => NULL
701: );
702: hr_utility.set_location('Leaving:'||l_proc, 10);
703: RETURN l_pbv;
704: Exception When others then
705: hr_utility.set_location('Exception:'||l_proc, 15);
706: raise;

Line 705: hr_utility.set_location('Exception:'||l_proc, 15);

701: );
702: hr_utility.set_location('Leaving:'||l_proc, 10);
703: RETURN l_pbv;
704: Exception When others then
705: hr_utility.set_location('Exception:'||l_proc, 15);
706: raise;
707: End;
708: ---------------------------------------------------------------------
709: FUNCTION get_assignment_budget_values(p_assignment_id in number,

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

734: l_proc varchar2(72) := g_package||'get_assignment_budget_values';
735: --
736: Begin
737: --
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: OPEN CSR_ABV;
741: FETCH CSR_ABV INTO l_abv;
742: IF (CSR_ABV%NOTFOUND) THEN

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

742: IF (CSR_ABV%NOTFOUND) THEN
743: l_abv := 0;
744: END IF;
745: CLOSE CSR_ABV;
746: hr_utility.set_location('Leaving:'||l_proc, 10);
747: RETURN l_abv;
748: Exception When others then
749: hr_utility.set_location('Exception:'||l_proc, 15);
750: raise;

Line 749: hr_utility.set_location('Exception:'||l_proc, 15);

745: CLOSE CSR_ABV;
746: hr_utility.set_location('Leaving:'||l_proc, 10);
747: RETURN l_abv;
748: Exception When others then
749: hr_utility.set_location('Exception:'||l_proc, 15);
750: raise;
751: End;
752: --
753: -- get_sum_actuals

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

866: from pay_assignment_actions
867: where assignment_id = p_assignment_id);
868:
869: Begin
870: hr_utility.set_location('Entering :'||l_proc,5);
871: l_assignment_actuals := 0;
872:
873: open csr_asg_act_exists;
874: fetch csr_asg_act_exists into l_dummy;

Line 876: hr_utility.set_location('** Exists, element_Type'||p_element_type_id,5);

872:
873: open csr_asg_act_exists;
874: fetch csr_asg_act_exists into l_dummy;
875: if csr_asg_act_exists%found then
876: hr_utility.set_location('** Exists, element_Type'||p_element_type_id,5);
877: if (p_element_type_id is not null) then
878: open csr_assg_actuals1(p_element_type_id);
879: fetch csr_assg_actuals1 into l_last_payroll_dt, l_result_value;
880: close csr_assg_actuals1;

Line 885: hr_utility.set_location('** Opened cursor 2, date:'||l_last_payroll_dt||' Result: '||l_result_value,5);

881: else
882: open csr_assg_actuals2;
883: fetch csr_assg_actuals2 into l_last_payroll_dt, l_result_value;
884: close csr_assg_actuals2;
885: hr_utility.set_location('** Opened cursor 2, date:'||l_last_payroll_dt||' Result: '||l_result_value,5);
886: end if;
887: l_last_payroll_dt := get_last_payroll_dt(p_assignment_id,
888: p_actuals_start_date, p_actuals_end_date);
889: p_last_payroll_dt := l_last_payroll_dt;

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

891: close csr_asg_act_exists;
892:
893:
894:
895: hr_utility.set_location('Leaving :'||l_proc,20);
896: RETURN l_result_value;
897: Exception When others then
898: if (csr_asg_act_exists%isopen) then
899: close csr_asg_act_exists;

Line 902: hr_utility.set_location('Exception:'||l_proc, 25);

898: if (csr_asg_act_exists%isopen) then
899: close csr_asg_act_exists;
900: end if;
901: p_last_payroll_dt := null;
902: hr_utility.set_location('Exception:'||l_proc, 25);
903: raise;
904: End get_sum_actuals;
905: ------------------------------------------------------------------------
906: --

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

972: from pay_assignment_actions
973: where assignment_id = p_assignment_id);
974:
975: Begin
976: hr_utility.set_location('Entering :'||l_proc,5);
977: l_assignment_actuals := 0;
978:
979: open csr_asg_act_exists;
980: fetch csr_asg_act_exists into l_dummy;

Line 982: hr_utility.set_location('** Exists, element_Type'||p_element_type_id,5);

978:
979: open csr_asg_act_exists;
980: fetch csr_asg_act_exists into l_dummy;
981: if csr_asg_act_exists%found then
982: hr_utility.set_location('** Exists, element_Type'||p_element_type_id,5);
983: if (p_element_type_id is not null) then
984: open csr_assg_actuals(p_element_type_id);
985: fetch csr_assg_actuals into l_last_payroll_dt, l_result_value;
986: close csr_assg_actuals;

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

989: p_actuals_start_date, p_actuals_end_date);
990: p_last_payroll_dt := l_last_payroll_dt;
991: End if;
992: close csr_asg_act_exists;
993: hr_utility.set_location('Leaving :'||l_proc,20);
994: RETURN l_result_value;
995: Exception When others then
996: if (csr_asg_act_exists%isopen) then
997: close csr_asg_act_exists;

Line 1000: hr_utility.set_location('Exception:'||l_proc, 25);

996: if (csr_asg_act_exists%isopen) then
997: close csr_asg_act_exists;
998: end if;
999: p_last_payroll_dt := null;
1000: hr_utility.set_location('Exception:'||l_proc, 25);
1001: raise;
1002: End get_element_actuals;
1003: --
1004: ------------------------------------------------------------------------

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

1037: from pay_assignment_actions
1038: where assignment_id = p_assignment_id);
1039:
1040: Begin
1041: hr_utility.set_location('Entering :'||l_proc,5);
1042:
1043: open csr_asg_act_exists;
1044: fetch csr_asg_act_exists into l_dummy;
1045: if csr_asg_act_exists%found then

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

1048: close csr_pay_date;
1049: p_last_payroll_dt := l_last_payroll_dt;
1050: End if;
1051: close csr_asg_act_exists;
1052: hr_utility.set_location('Leaving :'||l_proc,20);
1053: Exception When others then
1054: if (csr_asg_act_exists%isopen) then
1055: close csr_asg_act_exists;
1056: end if;

Line 1058: hr_utility.set_location('Exception:'||l_proc, 25);

1054: if (csr_asg_act_exists%isopen) then
1055: close csr_asg_act_exists;
1056: end if;
1057: p_last_payroll_dt := null;
1058: hr_utility.set_location('Exception:'||l_proc, 25);
1059: raise;
1060: End get_payroll_run_date;
1061: --
1062: ------------------------------------------------------------------------

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

1145: l_proc varchar2(72) := g_package || 'get_actuals';
1146: l_last_payroll_dt date;
1147: Begin
1148:
1149: hr_utility.set_location('Entering :'||l_proc,5);
1150:
1151: /* If ((p_budget_id is not null) AND (p_element_type_id is not null)) then */
1152: --Bug Fix 3717620
1153: If (p_budget_id is not null) then

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

1230: -- p_last_payroll_dt := p_last_payroll_dt;
1231: end if;
1232:
1233: p_last_payroll_dt := l_last_payroll_dt;
1234: hr_utility.set_location('Leaving :'||l_proc,20);
1235: RETURN l_assignment_actuals;
1236: --
1237: Exception When others then
1238: if (csr_actual_exists%isopen) then

Line 1242: hr_utility.set_location('Exception:'||l_proc, 25);

1238: if (csr_actual_exists%isopen) then
1239: close csr_actual_exists;
1240: end if;
1241: p_last_payroll_dt := null;
1242: hr_utility.set_location('Exception:'||l_proc, 25);
1243: raise;
1244: End get_actuals;
1245: --
1246: -- ********************

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

1358: from pay_assignment_actions
1359: where assignment_id = p_assignment_id);
1360: Begin
1361: --
1362: hr_utility.set_location('Entering :'||l_proc,5);
1363: --
1364: l_assignment_actuals := 0;
1365: --
1366: open csr_asg_act_exists;

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

1411: End loop; /** Clasifications */
1412: End loop; /** csr_asg_time_periods */
1413: End if;
1414: close csr_asg_act_exists;
1415: hr_utility.set_location('Leaving :'||l_proc,20);
1416: --
1417: RETURN l_assignment_actuals;
1418: Exception When others then
1419: if (csr_asg_act_exists%isopen) then

Line 1423: hr_utility.set_location('Exception:'||l_proc, 25);

1419: if (csr_asg_act_exists%isopen) then
1420: close csr_asg_act_exists;
1421: end if;
1422: p_last_payroll_dt := null;
1423: hr_utility.set_location('Exception:'||l_proc, 25);
1424: raise;
1425: End get_actuals;
1426: --
1427:

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

1465: l_proc varchar2(72) := g_package||'get_assign_money_actuals';
1466: --
1467: Begin
1468: --
1469: hr_utility.set_location('Entering :'||l_proc,5);
1470: --
1471: l_assignment_actuals := 0;
1472: --
1473: Open csr_assg;

Line 1487: hr_utility.set_location('Assignment :'||to_char(l_assignment_id),10);

1483: if l_legislation_code is null then
1484: l_legislation_code := get_bg_legislation_code(l_business_group_id);
1485: end if;
1486: --
1487: hr_utility.set_location('Assignment :'||to_char(l_assignment_id),10);
1488: hr_utility.set_location('Payroll :'||to_char(l_payroll_id),15);
1489: --
1490: l_actuals := 0;
1491: --

Line 1488: hr_utility.set_location('Payroll :'||to_char(l_payroll_id),15);

1484: l_legislation_code := get_bg_legislation_code(l_business_group_id);
1485: end if;
1486: --
1487: hr_utility.set_location('Assignment :'||to_char(l_assignment_id),10);
1488: hr_utility.set_location('Payroll :'||to_char(l_payroll_id),15);
1489: --
1490: l_actuals := 0;
1491: --
1492: If l_payroll_id IS NOT NULL then

Line 1510: hr_utility.set_location('Calculating for :'||to_char(l_actuals_sub_start_dt,'DD/MM/RRRR') || ' to ' || to_char(l_actuals_sub_end_dt,'DD/MM/RRRR'),20);

1506: -- actuals end date .
1507: --
1508: l_actuals_sub_end_dt := least(p_actuals_end_date,l_effective_end_date);
1509: --
1510: hr_utility.set_location('Calculating for :'||to_char(l_actuals_sub_start_dt,'DD/MM/RRRR') || ' to ' || to_char(l_actuals_sub_end_dt,'DD/MM/RRRR'),20);
1511: /* l_actuals := get_sum_actuals(p_assignment_id => l_assignment_id,
1512: p_legislation_code => l_legislation_code,
1513: p_payroll_id => l_payroll_id,
1514: p_element_type_id => p_element_type_id,

Line 1537: hr_utility.set_location('Leaving :'||l_proc,25);

1533: Close csr_assg;
1534: --
1535: -- At this point , we will have an assignments actuals for a given period.
1536: --
1537: hr_utility.set_location('Leaving :'||l_proc,25);
1538: --
1539: RETURN l_assignment_actuals;
1540: --
1541: Exception When others then

Line 1543: hr_utility.set_location('Exception:'||l_proc, 30);

1539: RETURN l_assignment_actuals;
1540: --
1541: Exception When others then
1542: p_last_payroll_dt := null;
1543: hr_utility.set_location('Exception:'||l_proc, 30);
1544: raise;
1545: End get_assign_money_actuals;
1546: --
1547: ------------------------------------------------------------------------

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

1578: l_proc varchar2(72) := g_package||'get_assign_money_cmmtmnt';
1579: --
1580: Begin
1581: --
1582: hr_utility.set_location('Entering:'||l_proc, 5);
1583: --
1584: l_assign_cmmtmnt := 0;
1585: --
1586: Open csr_assg_commitment;

Line 1601: hr_utility.set_location('Dates used for evaluating prorated amount: '||l_prorate_start_dt||' - '||l_prorate_end_dt, 66);

1597: --
1598: l_prorate_start_dt := greatest(p_period_start_date,l_commitment_start_date);
1599: l_prorate_end_dt := least(p_period_end_date,l_commitment_end_date);
1600: --
1601: hr_utility.set_location('Dates used for evaluating prorated amount: '||l_prorate_start_dt||' - '||l_prorate_end_dt, 66);
1602: l_prorate_amt := l_amount *
1603: (
1604: (l_prorate_end_dt - l_prorate_start_dt +1)/
1605: (l_commitment_end_date - l_commitment_start_date + 1)

Line 1608: hr_utility.set_location('Amount Found: '||l_amount||' Prorated amount: '||l_prorate_amt, 67);

1604: (l_prorate_end_dt - l_prorate_start_dt +1)/
1605: (l_commitment_end_date - l_commitment_start_date + 1)
1606: );
1607: --
1608: hr_utility.set_location('Amount Found: '||l_amount||' Prorated amount: '||l_prorate_amt, 67);
1609: l_assign_cmmtmnt := l_assign_cmmtmnt + l_prorate_amt;
1610: --
1611: End loop;
1612: --

Line 1614: hr_utility.set_location('Assignment Commitment returned '||l_assign_cmmtmnt, 68);

1610: --
1611: End loop;
1612: --
1613: Close csr_assg_commitment;
1614: hr_utility.set_location('Assignment Commitment returned '||l_assign_cmmtmnt, 68);
1615: --
1616: hr_utility.set_location('Leaving:'||l_proc, 10);
1617: --
1618: RETURN l_assign_cmmtmnt;

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

1612: --
1613: Close csr_assg_commitment;
1614: hr_utility.set_location('Assignment Commitment returned '||l_assign_cmmtmnt, 68);
1615: --
1616: hr_utility.set_location('Leaving:'||l_proc, 10);
1617: --
1618: RETURN l_assign_cmmtmnt;
1619: --
1620: Exception When others then

Line 1622: hr_utility.set_location('Exception:'||l_proc, 15);

1618: RETURN l_assign_cmmtmnt;
1619: --
1620: Exception When others then
1621: --
1622: hr_utility.set_location('Exception:'||l_proc, 15);
1623: raise;
1624: --
1625: End get_assign_money_cmmtmnt;
1626: --

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

1643: l_proc varchar2(72) := g_package ||'get_assignment_actuals';
1644: --
1645: Begin
1646: --
1647: hr_utility.set_location('Entering :'||l_proc,5);
1648: --
1649: -- Check if input unit of measure is valid in per_shared_types.
1650: --
1651: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,

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

1701: --
1702: End if;
1703: --
1704: --
1705: hr_utility.set_location('Leaving :'||l_proc,10);
1706: --
1707: RETURN l_actuals;
1708: --
1709: Exception When others then

Line 1712: hr_utility.set_location('Exception:'||l_proc, 15);

1708: --
1709: Exception When others then
1710: p_last_payroll_dt := null;
1711: --
1712: hr_utility.set_location('Exception:'||l_proc, 15);
1713: raise;
1714:
1715: --
1716: End get_assignment_actuals;

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

1738:
1739: --
1740: Begin
1741: --
1742: hr_utility.set_location('Entering :'||l_proc,5);
1743: --
1744: Open csr_version;
1745: --
1746: -- Selecting the first budget version

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

1754: End if;
1755: --
1756: Close csr_version;
1757: --
1758: hr_utility.set_location('Leaving :'||l_proc,10);
1759: --
1760: Exception When others then
1761: p_budget_version_id := null;
1762: --

Line 1764: hr_utility.set_location('Exception:'||l_proc, 15);

1760: Exception When others then
1761: p_budget_version_id := null;
1762: --
1763:
1764: hr_utility.set_location('Exception:'||l_proc, 15);
1765: raise;
1766: --
1767: End get_version_from_cmmtmnt_table;
1768: --

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

1791: l_proc varchar2(72) := g_package||'get_assignment_commitment';
1792: --
1793: Begin
1794: --
1795: hr_utility.set_location('Entering:'||l_proc, 5);
1796: --
1797: --
1798: -- Check if this is a valid assignment
1799: --

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

1893: p_period_end_dt => p_period_end_date,
1894: p_unit_of_measure => l_unit_of_measure);
1895: End if;
1896: --
1897: hr_utility.set_location('Leaving:'||l_proc, 10);
1898: --
1899: RETURN l_assign_commitment;
1900: --
1901: Exception When others then

Line 1903: hr_utility.set_location('Exception:'||l_proc, 15);

1899: RETURN l_assign_commitment;
1900: --
1901: Exception When others then
1902: --
1903: hr_utility.set_location('Exception:'||l_proc, 15);
1904:
1905: raise;
1906: --
1907: End get_assignment_commitment;

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

1951: l_proc varchar2(72) := g_package||'get_pos_money_amounts';
1952: --
1953: BEGIN
1954: --
1955: hr_utility.set_location('Entering:'||l_proc, 5);
1956: --
1957: --
1958: /*2716884*/
1959: If p_budget_version_id IS NOT NULL then

Line 2009: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);

2005: --
2006: l_last_actuals_date := get_last_payroll_dt(l_assignment_id,
2007: p_start_date, p_end_date);
2008:
2009: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2010: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2011: --
2012: IF l_last_actuals_date IS NULL OR
2013: l_last_actuals_date <= p_start_date THEN

Line 2010: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

2006: l_last_actuals_date := get_last_payroll_dt(l_assignment_id,
2007: p_start_date, p_end_date);
2008:
2009: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2010: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2011: --
2012: IF l_last_actuals_date IS NULL OR
2013: l_last_actuals_date <= p_start_date THEN
2014: --

Line 2027: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);

2023: p_period_start_date => p_start_date,
2024: p_period_end_date => p_end_date
2025: );
2026: --
2027: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);
2028: --
2029: ELSIF l_last_actuals_date >= p_end_date then
2030: --
2031: -- Actuals is available beyond the required period end date .

Line 2049: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);

2045: p_period_start_date => l_last_actuals_date + 1,
2046: p_period_end_date => p_end_date
2047: );
2048: --
2049: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);
2050: --
2051: END IF;
2052: --
2053: -- Total up assignment commitment and actual information.

Line 2068: hr_utility.set_location('All assignments processed',50);

2064: --
2065: End Loop;
2066: l_position_total := l_position_actuals + l_position_commitment;
2067: --
2068: hr_utility.set_location('All assignments processed',50);
2069: -- Return the actuals , commitment and total
2070: --
2071: p_total_amount := l_position_total;
2072: --

Line 2082: hr_utility.set_location('Exception :'||l_proc,60);

2078: WHEN OTHERS THEN
2079: p_actual_amount := null;
2080: p_commitment_amount := null;
2081: p_total_amount := null;
2082: hr_utility.set_location('Exception :'||l_proc,60);
2083: hr_utility.raise_error;
2084: --
2085: End;
2086: --

Line 2083: hr_utility.raise_error;

2079: p_actual_amount := null;
2080: p_commitment_amount := null;
2081: p_total_amount := null;
2082: hr_utility.set_location('Exception :'||l_proc,60);
2083: hr_utility.raise_error;
2084: --
2085: End;
2086: --
2087: -----------------------------------------------------------------------

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

2141: l_day_of_date varchar2(1);
2142: l_days_removed number(1) := 0;
2143:
2144: Begin
2145: hr_utility.set_location('Entering:'||l_proc, 5);
2146: Open c_assg;
2147: Fetch c_assg Into l_start_date, l_end_date, l_frequency,
2148: l_normal_hours, l_assg_start_time, l_assg_end_time,
2149: l_position_id, l_organization_id, l_bg_id;

Line 2155: hr_utility.set_location('l_assignment_id:'||l_assignment_id, 6);

2151: close c_assg;
2152: return null;
2153: end if;
2154: close c_assg;
2155: hr_utility.set_location('l_assignment_id:'||l_assignment_id, 6);
2156:
2157: l_actual_start_date := greatest(l_start_date, p_start_date);
2158: l_actual_end_date := least(l_end_date, p_end_date);
2159:

Line 2160: hr_utility.set_location('l_normal_day_hours:'||l_normal_day_hours, 7);

2156:
2157: l_actual_start_date := greatest(l_start_date, p_start_date);
2158: l_actual_end_date := least(l_end_date, p_end_date);
2159:
2160: hr_utility.set_location('l_normal_day_hours:'||l_normal_day_hours, 7);
2161: -- Get the total number of weeks in the date range
2162: l_total_weeks := trunc(((l_actual_end_date - l_actual_start_date) + 1)/7);
2163: -- Get the remaining days
2164: l_remaining_days := mod((l_actual_end_date - l_actual_start_date) + 1, 7);

Line 2194: hr_utility.set_location('l_frequency:'||l_frequency ||' l_normal_hours:'||l_normal_hours, 8);

2190: Fetch c_bg_freq Into l_frequency, l_normal_hours;
2191: Close c_bg_freq;
2192: end if;
2193: end If;
2194: hr_utility.set_location('l_frequency:'||l_frequency ||' l_normal_hours:'||l_normal_hours, 8);
2195: If (l_frequency is not null and l_normal_hours is not null) Then
2196: If l_frequency in ('HO','H') Then
2197: l_hours_per_day := (l_normal_hours * 8); -- taking 8 hrs/day
2198: Elsif l_frequency = 'D' Then

Line 2213: hr_utility.set_location('l_total_hours:'||l_total_hours, 8);

2209: Else
2210: l_total_hours := (8 * 5 * l_total_weeks) + (8 * l_remaining_days);
2211: -- taking 8 hours per day as default.
2212: End If;
2213: hr_utility.set_location('l_total_hours:'||l_total_hours, 8);
2214: RETURN (l_total_hours);
2215: Exception
2216: when others then
2217: hr_utility.set_location('Exception :'||l_proc,70);

Line 2217: hr_utility.set_location('Exception :'||l_proc,70);

2213: hr_utility.set_location('l_total_hours:'||l_total_hours, 8);
2214: RETURN (l_total_hours);
2215: Exception
2216: when others then
2217: hr_utility.set_location('Exception :'||l_proc,70);
2218: hr_utility.raise_error;
2219: End;
2220: --- Function to get the actual hours for an entity
2221: ---

Line 2218: hr_utility.raise_error;

2214: RETURN (l_total_hours);
2215: Exception
2216: when others then
2217: hr_utility.set_location('Exception :'||l_proc,70);
2218: hr_utility.raise_error;
2219: End;
2220: --- Function to get the actual hours for an entity
2221: ---
2222: FUNCTION get_actual_hours(p_business_grp_id in number

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

2264: and effective_end_date >= p_start_date
2265: and effective_start_date <= p_end_date ;
2266:
2267: Begin
2268: hr_utility.set_location('Entering:'||l_proc, 5);
2269: if p_organization_id is not null then
2270: for i in c_org_assg loop
2271: l_asg_hours := get_actual_hours (p_assignment_id => i.assignment_id,
2272: p_asg_start_date => i.effective_start_date,

Line 2309: hr_utility.set_location('Exception :'||l_proc,70);

2305: end if;
2306: RETURN (l_total_hours);
2307: Exception
2308: when others then
2309: hr_utility.set_location('Exception :'||l_proc,70);
2310: hr_utility.raise_error;
2311: End;
2312: ----------------------------------------------------------------
2313: --

Line 2310: hr_utility.raise_error;

2306: RETURN (l_total_hours);
2307: Exception
2308: when others then
2309: hr_utility.set_location('Exception :'||l_proc,70);
2310: hr_utility.raise_error;
2311: End;
2312: ----------------------------------------------------------------
2313: --
2314: -- This function calculates commitment / actuals / total for a position.

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

2362: l_proc varchar2(72) := g_package||'get_pos_actual_and_cmmtmnt';
2363: --
2364: BEGIN
2365: --
2366: hr_utility.set_location('Entering:'||l_proc, 5);
2367: IF ( p_validate = 'Y') THEN
2368: --
2369: --
2370: -- CHECK IF THIS IS A VALID BUDGET .

Line 2394: hr_utility.set_location('Dates for Commitment Calc: '||p_start_date||' - '||p_end_date, 61);

2390: p_budget_id => l_budget_id);
2391: --
2392: ElsIf p_value_type = 'C' OR p_value_type = 'T' then
2393: --
2394: hr_utility.set_location('Dates for Commitment Calc: '||p_start_date||' - '||p_end_date, 61);
2395: Validate_commitment_dates(p_cmmtmnt_start_dt => p_start_date,
2396: p_cmmtmnt_end_dt => p_end_date,
2397: p_budget_id => l_budget_id);
2398: --

Line 2421: hr_utility.set_location('Assignments found: '||l_assignment_id, 62);

2417: --
2418: for i in csr_pos_assg Loop
2419: l_assignment_id := i.assignment_id;
2420: --
2421: hr_utility.set_location('Assignments found: '||l_assignment_id, 62);
2422: l_assignment_total := 0;
2423: l_assignment_actuals := 0;
2424: l_assignment_commitment := 0;
2425: l_last_actuals_date := NULL;

Line 2441: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);

2437: p_actuals_end_date => p_end_date,
2438: p_last_payroll_dt => l_last_actuals_date
2439: );
2440: --
2441: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2442: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2443: --
2444: l_position_actuals := l_position_actuals + NVL(l_assignment_actuals,0);
2445: End If;

Line 2442: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

2438: p_last_payroll_dt => l_last_actuals_date
2439: );
2440: --
2441: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2442: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2443: --
2444: l_position_actuals := l_position_actuals + NVL(l_assignment_actuals,0);
2445: End If;
2446:

Line 2452: hr_utility.set_location('Last Actual Date: '||to_char(l_last_actuals_date)||' - '||to_char(p_start_date), 63);

2448: -- Get last_actuals_date only if 'C' (in case of T, it is already evaluated
2449: if ( p_value_type = 'C') then
2450: l_last_actuals_date := get_last_payroll_dt (l_assignment_id, p_start_date, p_end_date);
2451: end if;
2452: hr_utility.set_location('Last Actual Date: '||to_char(l_last_actuals_date)||' - '||to_char(p_start_date), 63);
2453: IF (l_last_actuals_date IS NULL OR
2454: l_last_actuals_date <= p_start_date ) THEN
2455: --
2456: -- payroll has never been run for the position. So actual is zero

Line 2468: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);

2464: p_period_start_date => p_start_date,
2465: p_period_end_date => p_end_date
2466: );
2467: --
2468: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);
2469: --
2470: ELSIF l_last_actuals_date >= p_end_date then
2471: --
2472: -- Actuals is available beyond the required period end date .

Line 2478: hr_utility.set_location('Payroll has run..: '||to_char(l_last_actuals_date+1)||' - '||to_char(p_end_date), 64);

2474: --
2475: l_assignment_commitment := 0;
2476: --
2477: ELSE
2478: hr_utility.set_location('Payroll has run..: '||to_char(l_last_actuals_date+1)||' - '||to_char(p_end_date), 64);
2479: --
2480: -- payroll has been run for the position. calculate commitment
2481: -- from the next day of the last payroll run.
2482: --

Line 2491: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);

2487: p_period_start_date => l_last_actuals_date + 1,
2488: p_period_end_date => p_end_date
2489: );
2490: --
2491: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);
2492: --
2493: END IF;
2494: l_position_commitment := l_position_commitment + NVL(l_assignment_commitment,0);
2495: End If;

Line 2504: hr_utility.set_location('All assignments processed',50);

2500: --
2501: End If;
2502: End Loop;
2503: --
2504: hr_utility.set_location('All assignments processed',50);
2505:
2506: --
2507: --
2508: -- Return the actuals or commitment or total

Line 2517: hr_utility.set_location('Returning Commitment amount: '||l_position_commitment,65);

2513: RETURN l_position_total;
2514: --
2515: Elsif p_value_type = 'C' then
2516: --
2517: hr_utility.set_location('Returning Commitment amount: '||l_position_commitment,65);
2518: RETURN l_position_commitment;
2519: --
2520: Elsif p_value_type = 'A' then
2521: --

Line 2558: hr_utility.set_location('Exception :'||l_proc,60);

2554: --
2555:
2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: hr_utility.set_location('Exception :'||l_proc,60);
2559: hr_utility.set_location(sqlerrm,99);
2560: hr_utility.raise_error;
2561:
2562: End;

Line 2559: hr_utility.set_location(sqlerrm,99);

2555:
2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: hr_utility.set_location('Exception :'||l_proc,60);
2559: hr_utility.set_location(sqlerrm,99);
2560: hr_utility.raise_error;
2561:
2562: End;
2563:

Line 2560: hr_utility.raise_error;

2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: hr_utility.set_location('Exception :'||l_proc,60);
2559: hr_utility.set_location(sqlerrm,99);
2560: hr_utility.raise_error;
2561:
2562: End;
2563:
2564: --

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

2639: l_proc varchar2(72) := g_package||'get_ent_actual_and_cmmtmnt';
2640: --
2641: BEGIN
2642: --
2643: hr_utility.set_location('Entering:'||l_proc, 5);
2644: --
2645: --
2646: -- CHECK IF THIS IS A VALID BUDGET .
2647: --

Line 2750: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);

2746: p_actuals_end_date => p_end_date,
2747: p_last_payroll_dt => l_last_actuals_date
2748: );
2749: --
2750: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2751: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2752: --
2753: IF l_last_actuals_date IS NULL OR
2754: l_last_actuals_date <= p_start_date THEN

Line 2751: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

2747: p_last_payroll_dt => l_last_actuals_date
2748: );
2749: --
2750: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2751: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2752: --
2753: IF l_last_actuals_date IS NULL OR
2754: l_last_actuals_date <= p_start_date THEN
2755: --

Line 2768: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);

2764: p_period_start_date => p_start_date,
2765: p_period_end_date => p_end_date
2766: );
2767: --
2768: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);
2769: --
2770: ELSIF l_last_actuals_date >= p_end_date then
2771: --
2772: -- Actuals is available beyond the required period end date .

Line 2790: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);

2786: p_period_start_date => l_last_actuals_date + 1,
2787: p_period_end_date => p_end_date
2788: );
2789: --
2790: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);
2791: --
2792: END IF;
2793: --
2794: -- Total up assignment commitment and actual information.

Line 2808: hr_utility.set_location('All assignments processed',50);

2804: l_entity_total := l_entity_total + l_assignment_total;
2805: --
2806: End Loop;
2807: --
2808: hr_utility.set_location('All assignments processed',50);
2809: Elsif p_budgeted_entity_cd = 'JOB' Then
2810: for i in csr_job_assg(l_business_group_id) loop
2811: l_assignment_id := i.assignment_id;
2812: --

Line 2831: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);

2827: p_actuals_end_date => p_end_date,
2828: p_last_payroll_dt => l_last_actuals_date
2829: );
2830: --
2831: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2832: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2833: --
2834: IF l_last_actuals_date IS NULL OR
2835: l_last_actuals_date <= p_start_date THEN

Line 2832: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

2828: p_last_payroll_dt => l_last_actuals_date
2829: );
2830: --
2831: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2832: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2833: --
2834: IF l_last_actuals_date IS NULL OR
2835: l_last_actuals_date <= p_start_date THEN
2836: --

Line 2849: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);

2845: p_period_start_date => p_start_date,
2846: p_period_end_date => p_end_date
2847: );
2848: --
2849: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);
2850: --
2851: ELSIF l_last_actuals_date >= p_end_date then
2852: --
2853: -- Actuals is available beyond the required period end date .

Line 2871: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);

2867: p_period_start_date => l_last_actuals_date + 1,
2868: p_period_end_date => p_end_date
2869: );
2870: --
2871: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);
2872: --
2873: END IF;
2874: --
2875: -- Total up assignment commitment and actual information.

Line 2889: hr_utility.set_location('All assignments processed',50);

2885: l_entity_total := l_entity_total + l_assignment_total;
2886: --
2887: End Loop;
2888: --
2889: hr_utility.set_location('All assignments processed',50);
2890: Elsif p_budgeted_entity_cd = 'GRADE' Then
2891: for i in csr_grade_assg(l_business_group_id) loop
2892: l_assignment_id := i.assignment_id;
2893: --

Line 2912: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);

2908: p_actuals_end_date => p_end_date,
2909: p_last_payroll_dt => l_last_actuals_date
2910: );
2911: --
2912: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2913: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2914: --
2915: IF l_last_actuals_date IS NULL OR
2916: l_last_actuals_date <= p_start_date THEN

Line 2913: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

2909: p_last_payroll_dt => l_last_actuals_date
2910: );
2911: --
2912: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2913: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2914: --
2915: IF l_last_actuals_date IS NULL OR
2916: l_last_actuals_date <= p_start_date THEN
2917: --

Line 2930: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);

2926: p_period_start_date => p_start_date,
2927: p_period_end_date => p_end_date
2928: );
2929: --
2930: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);
2931: --
2932: ELSIF l_last_actuals_date >= p_end_date then
2933: --
2934: -- Actuals is available beyond the required period end date .

Line 2952: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);

2948: p_period_start_date => l_last_actuals_date + 1,
2949: p_period_end_date => p_end_date
2950: );
2951: --
2952: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);
2953: --
2954: END IF;
2955: --
2956: -- Total up assignment commitment and actual information.

Line 2970: hr_utility.set_location('All assignments processed',50);

2966: l_entity_total := l_entity_total + l_assignment_total;
2967: --
2968: End Loop;
2969: --
2970: hr_utility.set_location('All assignments processed',50);
2971: Elsif p_budgeted_entity_cd = 'ORGANIZATION' Then
2972: for i in csr_org_assg(l_business_group_id) loop
2973: l_assignment_id := i.assignment_id;
2974:

Line 2994: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);

2990: p_actuals_end_date => p_end_date,
2991: p_last_payroll_dt => l_last_actuals_date
2992: );
2993: --
2994: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2995: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2996: --
2997: IF l_last_actuals_date IS NULL OR
2998: l_last_actuals_date <= p_start_date THEN

Line 2995: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

2991: p_last_payroll_dt => l_last_actuals_date
2992: );
2993: --
2994: hr_utility.set_location('Assignment Actual:'||l_assignment_actuals,10);
2995: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
2996: --
2997: IF l_last_actuals_date IS NULL OR
2998: l_last_actuals_date <= p_start_date THEN
2999: --

Line 3012: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);

3008: p_period_start_date => p_start_date,
3009: p_period_end_date => p_end_date
3010: );
3011: --
3012: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 30);
3013: --
3014: ELSIF l_last_actuals_date >= p_end_date then
3015: --
3016: -- Actuals is available beyond the required period end date .

Line 3034: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);

3030: p_period_start_date => l_last_actuals_date + 1,
3031: p_period_end_date => p_end_date
3032: );
3033: --
3034: hr_utility.set_location('Assignment Commitment : '||l_assignment_commitment, 40);
3035: --
3036: END IF;
3037: --
3038: -- Total up assignment commitment and actual information.

Line 3052: hr_utility.set_location('All assignments processed',50);

3048: l_entity_total := l_entity_total + l_assignment_total;
3049: --
3050: End Loop;
3051: --
3052: hr_utility.set_location('All assignments processed',50);
3053: End if;
3054: --
3055: -- Return the actuals or commitment or total
3056: -- depending on what value type was passed.

Line 3168: hr_utility.set_location('Exception :'||l_proc,60);

3164: RETURN l_entity_total;
3165: --
3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: hr_utility.set_location('Exception :'||l_proc,60);
3169: hr_utility.raise_error;
3170: End;
3171: --
3172: ------------------------------------------------------------------------

Line 3169: hr_utility.raise_error;

3165: --
3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: hr_utility.set_location('Exception :'||l_proc,60);
3169: hr_utility.raise_error;
3170: End;
3171: --
3172: ------------------------------------------------------------------------
3173: -- The foll two functions return actuals and commitment for a budget

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

3199: l_proc varchar2(72) := g_package||'get_budget_actuals';
3200: --
3201: Begin
3202: --
3203: hr_utility.set_location('Entering:'||l_proc, 5);
3204: --
3205: -- Validate if the budget version is valid .
3206: --
3207: Validate_budget(p_budget_version_id => p_budget_version_id,

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

3236: p_value_type => 'A');
3237: l_budget_actuals := nvl(l_budget_actuals,0) + nvl(l_position_actuals,0);
3238: End Loop;
3239: --
3240: hr_utility.set_location('Leaving:'||l_proc, 10);
3241: --
3242: RETURN l_budget_actuals;
3243: --
3244: Exception When others then

Line 3245: hr_utility.set_location('Exception:'||l_proc, 15);

3241: --
3242: RETURN l_budget_actuals;
3243: --
3244: Exception When others then
3245: hr_utility.set_location('Exception:'||l_proc, 15);
3246: raise ;
3247: --
3248: End;
3249: --

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

3276: l_proc varchar2(72) := g_package||'get_budget_commitment';
3277: --
3278: Begin
3279: --
3280: hr_utility.set_location('Entering:'||l_proc, 5);
3281: --
3282: -- Validate if the budget version is valid .
3283: --
3284: Validate_budget(p_budget_version_id => p_budget_version_id,

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

3314: --
3315: l_budget_commitment := nvl(l_budget_commitment,0) + nvl(l_position_commitment,0);
3316: --
3317: End Loop;
3318: hr_utility.set_location('Leaving:'||l_proc, 10);
3319: --
3320: RETURN l_budget_commitment;
3321: --
3322: Exception When others then

Line 3323: hr_utility.set_location('Exception:'||l_proc, 15);

3319: --
3320: RETURN l_budget_commitment;
3321: --
3322: Exception When others then
3323: hr_utility.set_location('Exception:'||l_proc, 15);
3324: raise;
3325: End;
3326:
3327: -----------------------------------------------------------------------------

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

3388: l_proc varchar2(72) := g_package||'get_budget_actuals';
3389: --
3390: Begin
3391: --
3392: hr_utility.set_location('Entering:'||l_proc, 5);
3393: --
3394: -- Validate if the budget version is valid .
3395: --
3396: Validate_budget(p_budget_version_id => p_budget_version_id,

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

3539: Close csr_orgs_in_bdgt;
3540: --
3541: End If;
3542: --
3543: hr_utility.set_location('Leaving:'||l_proc, 10);
3544: --
3545: RETURN l_budget_actuals;
3546: --
3547: Exception When others then

Line 3550: hr_utility.set_location('Exception:'||l_proc, 15);

3546: --
3547: Exception When others then
3548: --
3549:
3550: hr_utility.set_location('Exception:'||l_proc, 15);
3551: raise;
3552: --
3553: End;
3554: --

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

3611: l_proc varchar2(72) := g_package||'get_budget_commitment';
3612: --
3613: Begin
3614: --
3615: hr_utility.set_location('Entering:'||l_proc, 5);
3616: --
3617: -- Validate if the budget version is valid .
3618: --
3619: Validate_budget(p_budget_version_id => p_budget_version_id,

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

3687: l_budget_commitment := nvl(l_budget_commitment,0) + nvl(l_entity_commitment,0);
3688: End Loop;
3689: End If;
3690: --
3691: hr_utility.set_location('Leaving:'||l_proc, 10);
3692: --
3693: RETURN l_budget_commitment;
3694: --
3695: Exception When others then

Line 3696: hr_utility.set_location('Exception:'||l_proc, 15);

3692: --
3693: RETURN l_budget_commitment;
3694: --
3695: Exception When others then
3696: hr_utility.set_location('Exception:'||l_proc, 15);
3697: raise;
3698: End;
3699: --
3700: procedure get_asg_actual_cmmt(p_assignment_id number

Line 3741: hr_utility.set_location('Assignment Actual:'||p_assignment_actuals,10);

3737: p_actuals_end_date => p_end_date,
3738: p_last_payroll_dt => l_last_actuals_date
3739: );
3740: --
3741: hr_utility.set_location('Assignment Actual:'||p_assignment_actuals,10);
3742: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
3743: --
3744: IF l_last_actuals_date IS NULL OR
3745: l_last_actuals_date <= p_start_date THEN

Line 3742: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);

3738: p_last_payroll_dt => l_last_actuals_date
3739: );
3740: --
3741: hr_utility.set_location('Assignment Actual:'||p_assignment_actuals,10);
3742: hr_utility.set_location('Last Actual Date :'||l_last_actuals_date, 20);
3743: --
3744: IF l_last_actuals_date IS NULL OR
3745: l_last_actuals_date <= p_start_date THEN
3746: --

Line 3759: hr_utility.set_location('Assignment Commitment : '||p_assignment_commitment, 30);

3755: p_period_start_date => p_start_date,
3756: p_period_end_date => p_end_date
3757: );
3758: --
3759: hr_utility.set_location('Assignment Commitment : '||p_assignment_commitment, 30);
3760: --
3761: ELSIF l_last_actuals_date >= p_end_date then
3762: --
3763: -- Actuals is available beyond the required period end date .

Line 3781: hr_utility.set_location('Assignment Commitment : '||p_assignment_commitment, 40);

3777: p_period_start_date => l_last_actuals_date + 1,
3778: p_period_end_date => p_end_date
3779: );
3780: --
3781: hr_utility.set_location('Assignment Commitment : '||p_assignment_commitment, 40);
3782: --
3783: END IF;
3784: --
3785: -- Total up assignment commitment and actual information.

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

3884: l_proc varchar2(72) := g_package||'get_actual_and_cmmtmnt';
3885:
3886:
3887: Begin
3888: hr_utility.set_location('Entering:'||l_proc, 5);
3889: hr_utility.set_location('l_unit_of_measure:'||p_unit_of_measure, 5);
3890: --
3891: --
3892: If p_unit_of_measure = 'MONEY' then

Line 3889: hr_utility.set_location('l_unit_of_measure:'||p_unit_of_measure, 5);

3885:
3886:
3887: Begin
3888: hr_utility.set_location('Entering:'||l_proc, 5);
3889: hr_utility.set_location('l_unit_of_measure:'||p_unit_of_measure, 5);
3890: --
3891: --
3892: If p_unit_of_measure = 'MONEY' then
3893: --

Line 3896: hr_utility.set_location('~~NS:Before Loop Position: '||p_position_id, 8);

3892: If p_unit_of_measure = 'MONEY' then
3893: --
3894: -- calculate actuals and commitment for each assignment.
3895: --
3896: hr_utility.set_location('~~NS:Before Loop Position: '||p_position_id, 8);
3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);
3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);
3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);
3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);

Line 3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);

3893: --
3894: -- calculate actuals and commitment for each assignment.
3895: --
3896: hr_utility.set_location('~~NS:Before Loop Position: '||p_position_id, 8);
3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);
3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);
3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);
3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);
3901: hr_utility.set_location('~~NS:p_end_date: '||p_end_date, 8);

Line 3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);

3894: -- calculate actuals and commitment for each assignment.
3895: --
3896: hr_utility.set_location('~~NS:Before Loop Position: '||p_position_id, 8);
3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);
3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);
3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);
3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);
3901: hr_utility.set_location('~~NS:p_end_date: '||p_end_date, 8);
3902:

Line 3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);

3895: --
3896: hr_utility.set_location('~~NS:Before Loop Position: '||p_position_id, 8);
3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);
3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);
3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);
3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);
3901: hr_utility.set_location('~~NS:p_end_date: '||p_end_date, 8);
3902:
3903:

Line 3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);

3896: hr_utility.set_location('~~NS:Before Loop Position: '||p_position_id, 8);
3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);
3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);
3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);
3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);
3901: hr_utility.set_location('~~NS:p_end_date: '||p_end_date, 8);
3902:
3903:
3904: For l_budget in c_budgets

Line 3901: hr_utility.set_location('~~NS:p_end_date: '||p_end_date, 8);

3897: hr_utility.set_location('~~NS:p_effective_date: '||p_effective_date, 8);
3898: hr_utility.set_location('~~NS:p_business_group_id: '||p_business_group_id, 8);
3899: hr_utility.set_location('~~NS:p_budget_entity: '||p_budget_entity, 8);
3900: hr_utility.set_location('~~NS:p_start_date: '||p_start_date, 8);
3901: hr_utility.set_location('~~NS:p_end_date: '||p_end_date, 8);
3902:
3903:
3904: For l_budget in c_budgets
3905: Loop

Line 3906: hr_utility.set_location('~~NS:Budget Version: '||l_budget.budget_version_id, 8);

3902:
3903:
3904: For l_budget in c_budgets
3905: Loop
3906: hr_utility.set_location('~~NS:Budget Version: '||l_budget.budget_version_id, 8);
3907: -- modified by svorugan Bug Fix : 2432715
3908: l_assignment_total :=0;
3909: l_entity_commitment :=0;
3910: l_entity_actuals :=0;

Line 3915: hr_utility.set_location('~~NS:Before Calling get asg actual cmmt: '||p_position_id, 8);

3911: -- upto here
3912: if p_position_id is not null then
3913: for i in csr_position_assg loop
3914: l_assignment_id := i.assignment_id;
3915: hr_utility.set_location('~~NS:Before Calling get asg actual cmmt: '||p_position_id, 8);
3916: get_asg_actual_cmmt(l_assignment_id
3917: ,l_budget.budget_version_id
3918: ,p_element_type_id
3919: ,p_start_date

Line 3929: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);

3925: l_entity_commitment := nvl(l_entity_commitment,0) + NVL(l_assignment_commitment,0);
3926: --
3927: l_entity_actuals := nvl(l_entity_actuals,0) + NVL(l_assignment_actuals,0);
3928: --
3929: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);
3930: --
3931: End Loop; -- csr_assg
3932: elsif p_organization_id is not null then
3933: for i in csr_org_assg loop

Line 3948: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);

3944: l_entity_commitment := nvl(l_entity_commitment,0) + NVL(l_assignment_commitment,0);
3945: --
3946: l_entity_actuals := nvl(l_entity_actuals,0) + NVL(l_assignment_actuals,0);
3947: --
3948: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);
3949: --
3950: End Loop; -- csr_assg
3951: elsif p_job_id is not null then
3952: for i in csr_job_assg loop

Line 3967: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);

3963: l_entity_commitment := nvl(l_entity_commitment,0) + NVL(l_assignment_commitment,0);
3964: --
3965: l_entity_actuals := nvl(l_entity_actuals,0) + NVL(l_assignment_actuals,0);
3966: --
3967: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);
3968: --
3969: End Loop; -- csr_assg
3970: elsif p_grade_id is not null then
3971: for i in csr_grade_assg loop

Line 3986: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);

3982: l_entity_commitment := nvl(l_entity_commitment,0) + NVL(l_assignment_commitment,0);
3983: --
3984: l_entity_actuals := nvl(l_entity_actuals,0) + NVL(l_assignment_actuals,0);
3985: --
3986: hr_utility.set_location('svorugan..2'||l_entity_actuals,50);
3987: --
3988: End Loop; -- csr_assg
3989: end if;
3990: --

Line 3991: hr_utility.set_location('All assignments processed',50);

3987: --
3988: End Loop; -- csr_assg
3989: end if;
3990: --
3991: hr_utility.set_location('All assignments processed',50);
3992: l_total_actuals := nvl(l_total_actuals,0) + nvl(l_entity_actuals,0);
3993: l_total_commitment := nvl(l_total_commitment,0) + nvl(l_entity_commitment,0);
3994:
3995: hr_utility.set_location('Totals: Commitment | Actuals'||l_total_commitment||' | '||l_total_actuals,50);

Line 3995: hr_utility.set_location('Totals: Commitment | Actuals'||l_total_commitment||' | '||l_total_actuals,50);

3991: hr_utility.set_location('All assignments processed',50);
3992: l_total_actuals := nvl(l_total_actuals,0) + nvl(l_entity_actuals,0);
3993: l_total_commitment := nvl(l_total_commitment,0) + nvl(l_entity_commitment,0);
3994:
3995: hr_utility.set_location('Totals: Commitment | Actuals'||l_total_commitment||' | '||l_total_actuals,50);
3996:
3997: End Loop; -- csr_budgets
3998:
3999: p_actual_value := l_total_actuals;

Line 4013: hr_utility.set_location('Actual Hours:'||p_actual_value, 10);

4009: ,p_start_date => p_start_date
4010: ,p_end_date => p_end_date
4011: ,p_effective_date => p_effective_date);
4012: p_commt_value := 0;
4013: hr_utility.set_location('Actual Hours:'||p_actual_value, 10);
4014: Else
4015: -- Calculate the actual value for an entity if the unit is FTE/HEADCOUNT etc.
4016: p_actual_value := hr_discoverer.get_actual_budget_values
4017: (p_bus_group_id => p_business_group_id,

Line 4033: hr_utility.set_location('Exception :'||l_proc,60);

4029: Exception
4030: when others then
4031: p_actual_value := null;
4032: p_commt_value := null;
4033: hr_utility.set_location('Exception :'||l_proc,60);
4034: hr_utility.raise_error;
4035: End get_actual_and_cmmtmnt;
4036: --
4037: --

Line 4034: hr_utility.raise_error;

4030: when others then
4031: p_actual_value := null;
4032: p_commt_value := null;
4033: hr_utility.set_location('Exception :'||l_proc,60);
4034: hr_utility.raise_error;
4035: End get_actual_and_cmmtmnt;
4036: --
4037: --
4038: FUNCTION get_pos_money_total9(

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

4160: l_budget_id pqh_budgets.budget_id%type := NULL;
4161: --
4162: Begin
4163:
4164: hr_utility.set_location('Entering :'||l_proc,5);
4165:
4166: l_position_actuals := 0;
4167:
4168: If p_budget_version_id IS NOT NULL then

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

4225: --
4226: end if;
4227: end if;
4228: --
4229: hr_utility.set_location('Leaving :'||l_proc,20);
4230: --
4231: RETURN nvl(l_position_actuals,0);
4232: Exception When others then
4233: hr_utility.set_location('Exception:'||l_proc, 25);

Line 4233: hr_utility.set_location('Exception:'||l_proc, 25);

4229: hr_utility.set_location('Leaving :'||l_proc,20);
4230: --
4231: RETURN nvl(l_position_actuals,0);
4232: Exception When others then
4233: hr_utility.set_location('Exception:'||l_proc, 25);
4234: RAISE;
4235: End get_pos_money_total9;
4236: --
4237: