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 1237: hr_utility.set_location('Leaving :'||l_proc,20);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1513: 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);

1509: -- actuals end date .
1510: --
1511: l_actuals_sub_end_dt := least(p_actuals_end_date,l_effective_end_date);
1512: --
1513: 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);
1514: /* l_actuals := get_sum_actuals(p_assignment_id => l_assignment_id,
1515: p_legislation_code => l_legislation_code,
1516: p_payroll_id => l_payroll_id,
1517: p_element_type_id => p_element_type_id,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2086: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2221: hr_utility.raise_error;

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

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

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

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

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

Line 2313: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2563: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3172: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4037: hr_utility.raise_error;

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

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

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

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

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

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

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