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

Line 194: hr_utility.set_location('Entering:'||l_proc,1);

190: l_sunday_txt varchar2(100) := rtrim(to_char(to_date('07/01/2001','DD/MM/YYYY'),'DAY'));
191: --
192: begin
193: --
194: hr_utility.set_location('Entering:'||l_proc,1);
195: --
196: hr_utility.trace(' p_date: '||to_char (p_date));
197: --
198: if p_date is not null and p_date <> hr_general.end_of_time

Line 196: hr_utility.trace(' p_date: '||to_char (p_date));

192: begin
193: --
194: hr_utility.set_location('Entering:'||l_proc,1);
195: --
196: hr_utility.trace(' p_date: '||to_char (p_date));
197: --
198: if p_date is not null and p_date <> hr_general.end_of_time
199: then
200: if rtrim (to_char (p_date, 'DAY')) <> l_sunday_txt then

Line 205: hr_utility.set_location('Leaving :'||l_proc,100);

201: l_Sunday := next_day (p_date, l_sunday_txt) -7;
202: end if;
203: end if;
204: --
205: hr_utility.set_location('Leaving :'||l_proc,100);
206: --
207: return l_Sunday;
208: --
209: end start_of_week;

Line 222: hr_utility.set_location('Entering:'||l_proc,1);

218: l_saturday_txt varchar2(100) := rtrim(to_char(to_date('06/01/2001','DD/MM/YYYY'),'DAY'));
219: --
220: begin
221: --
222: hr_utility.set_location('Entering:'||l_proc,1);
223: --
224: hr_utility.trace(' p_date: '||to_char (p_date));
225: --
226: if p_date is not null and p_date <> hr_general.end_of_time

Line 224: hr_utility.trace(' p_date: '||to_char (p_date));

220: begin
221: --
222: hr_utility.set_location('Entering:'||l_proc,1);
223: --
224: hr_utility.trace(' p_date: '||to_char (p_date));
225: --
226: if p_date is not null and p_date <> hr_general.end_of_time
227: then
228: if rtrim (to_char (p_date, 'DAY')) <> l_saturday_txt then

Line 233: hr_utility.set_location('Leaving :'||l_proc,100);

229: l_Saturday := next_day (p_date, l_saturday_txt);
230: end if;
231: end if;
232: --
233: hr_utility.set_location('Leaving :'||l_proc,100);
234: --
235: return l_Saturday;
236: --
237: end end_of_week;

Line 252: hr_utility.set_location('Entering:'||l_proc,1);

248: l_day_txt varchar2(100);
249: --
250: begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,1);
253: hr_utility.trace(' p_start_date: '||to_char (p_date));
254: hr_utility.trace(' p_date: '||to_char (p_date));
255: --
256: if p_start_date is not null then

Line 253: hr_utility.trace(' p_start_date: '||to_char (p_date));

249: --
250: begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,1);
253: hr_utility.trace(' p_start_date: '||to_char (p_date));
254: hr_utility.trace(' p_date: '||to_char (p_date));
255: --
256: if p_start_date is not null then
257: l_day_txt := rtrim(to_char(p_start_date -1,'DAY'));

Line 254: hr_utility.trace(' p_date: '||to_char (p_date));

250: begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,1);
253: hr_utility.trace(' p_start_date: '||to_char (p_date));
254: hr_utility.trace(' p_date: '||to_char (p_date));
255: --
256: if p_start_date is not null then
257: l_day_txt := rtrim(to_char(p_start_date -1,'DAY'));
258: if p_date is not null and p_date <> hr_general.end_of_time

Line 266: hr_utility.set_location('Leaving :'||l_proc,100);

262: end if;
263: end if;
264: end if;
265: --
266: hr_utility.set_location('Leaving :'||l_proc,100);
267: --
268: return l_date;
269: --
270: end end_of_rolling_week;

Line 296: hr_utility.trace (l_proc||' p_effective_date = '

292: and p_effective_date = trunc (p_effective_date));
293: --
294: begin
295: --
296: hr_utility.trace (l_proc||' p_effective_date = '
297: ||to_char (p_effective_date));
298: --
299: hr_general.assert_condition (all_parameters_valid);
300: --

Line 305: hr_utility.set_location('Entering:'||l_proc,1);

301: end check_parameters;
302: --
303: begin
304: --
305: hr_utility.set_location('Entering:'||l_proc,1);
306: --
307: check_parameters;
308: --
309: open csr_LEL;

Line 320: hr_utility.trace (' No LEL defined on user tables; hard-coding value');

316: -- tax years before 95/96 so if the customer has need for the LEL value
317: -- before this date (eg for historic absences) then we must set the historic
318: -- value before returning.
319: --
320: hr_utility.trace (' No LEL defined on user tables; hard-coding value');
321: --
322: if p_effective_date between to_date ('06-04-1991', 'DD-MM-YYYY')
323: and to_date ('05-04-1992', 'DD-MM-YYYY')
324: then

Line 344: hr_utility.set_location('Leaving :'||l_proc, 100);

340: l_LEL := 57.00; -- Tax Year 94/95
341: end if;
342: end if;
343: --
344: hr_utility.set_location('Leaving :'||l_proc, 100);
345: --
346: return l_LEL;
347: --
348: end NI_Lower_Earnings_Limit;

Line 576: hr_utility.set_location('Entering:'||l_proc,1);

572: -- which is being modified by the code which caused the trigger to fire.
573: --
574: BEGIN
575: --
576: hr_utility.set_location('Entering:'||l_proc,1);
577: --
578: if ssp_ssp_pkg.ssp_is_installed
579: then
580: if csr_affected_PIWs%IsOpen then

Line 594: hr_utility.trace (' Recalculate SSP for PIW #'||

590: -- Make sure all the linked PIWs are correctly defined.
591: ssp_ssp_pkg.update_linked_absence_IDs;
592: --
593: for each_PIW in csr_affected_PIWs LOOP
594: hr_utility.trace (' Recalculate SSP for PIW #'||
595: to_char(each_PIW.PIW_ID));
596: --
597: if each_PIW.locked <> 'Y'
598: then

Line 610: hr_utility.trace (' Recalculate SMP for maternity_id # '

606: --
607: -- Recalculate SMP for all maternities affected by inserts/updates/deletes
608: --
609: for each_maternity in csr_affected_maternities LOOP
610: hr_utility.trace (' Recalculate SMP for maternity_id # '
611: ||to_char (each_maternity.maternity_id));
612: --
613: update ssp_temp_affected_rows
614: set locked = 'Y'

Line 649: hr_utility.set_location('ssp_del_orphaned_rows:'||l_proc,50);

645: close csr_count_absences;
646:
647: if l_deleting and l_count < 1
648: then
649: hr_utility.set_location('ssp_del_orphaned_rows:'||l_proc,50);
650: --
651: delete ssp_stoppages
652: where maternity_id = each_maternity.maternity_id;
653: end if;

Line 662: hr_utility.set_location('Leaving :'||l_proc,100);

658: or locked is null
659: or locked not in (select to_char(AUDSID) from v$session);
660: end if;
661: --
662: hr_utility.set_location('Leaving :'||l_proc,100);
663: --
664: exception
665: --
666: when mutating_table or row_deleted then

Line 676: hr_utility.set_location (l_proc,999);

672: -- second and subsequent calls to do anything so just exit silently.
673: --
674: null;
675: --
676: hr_utility.set_location (l_proc,999);
677: --
678: end recalculate_SSP_and_SMP;
679: ------------------------------------------------------------------------------
680: procedure get_entry_details(p_date_earned in date,

Line 777: hr_utility.trace (' p_date_earned = '||to_char (p_date_earned, 'DD-MON-YYYY'));

773: p_date_earned is not null and
774: p_date_earned = trunc (p_date_earned) and
775: p_last_process_date = trunc (p_last_process_date));
776: begin
777: hr_utility.trace (' p_date_earned = '||to_char (p_date_earned, 'DD-MON-YYYY'));
778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));
779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));

Line 778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));

774: p_date_earned = trunc (p_date_earned) and
775: p_last_process_date = trunc (p_last_process_date));
776: begin
777: hr_utility.trace (' p_date_earned = '||to_char (p_date_earned, 'DD-MON-YYYY'));
778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));
779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));

Line 779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));

775: p_last_process_date = trunc (p_last_process_date));
776: begin
777: hr_utility.trace (' p_date_earned = '||to_char (p_date_earned, 'DD-MON-YYYY'));
778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));
779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);

Line 780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));

776: begin
777: hr_utility.trace (' p_date_earned = '||to_char (p_date_earned, 'DD-MON-YYYY'));
778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));
779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);
784: --

Line 781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));

777: hr_utility.trace (' p_date_earned = '||to_char (p_date_earned, 'DD-MON-YYYY'));
778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));
779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);
784: --
785: hr_general.assert_condition (all_parameters_valid);

Line 782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));

778: hr_utility.trace (' p_last_process_date = '||to_char (p_last_process_date));
779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);
784: --
785: hr_general.assert_condition (all_parameters_valid);
786: --

Line 783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);

779: hr_utility.trace (' p_person_id = ' ||to_char (p_person_id));
780: hr_utility.trace (' p_element_type_id = '||to_char (p_element_type_id));
781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);
784: --
785: hr_general.assert_condition (all_parameters_valid);
786: --
787: end check_parameters;

Line 791: hr_utility.set_location ('Entering:'||l_proc,1);

787: end check_parameters;
788: --
789: begin
790: --
791: hr_utility.set_location ('Entering:'||l_proc,1);
792: --
793: check_parameters;
794: --
795: -- Get the effective date

Line 804: hr_utility.trace(l_proc||' effective date = '||to_char(l_effective_date, 'DD-MON-YYYY'));

800: if l_effective_date is null then
801: l_effective_date := trunc (sysdate);
802: end if;
803: --
804: hr_utility.trace(l_proc||' effective date = '||to_char(l_effective_date, 'DD-MON-YYYY'));
805: --
806: -- 1. Find out which date to use when searching for payroll period
807: if l_pay_as_lump_sum = 'Y' then
808: l_temp_date := l_effective_date;

Line 863: hr_utility.trace(l_proc||' l_effective_start_date = ' ||to_char(l_effective_start_date, 'DD-MON-YYYY'));

859: else
860: l_found := true;
861: p_effective_start_date := l_effective_start_date;
862: p_effective_end_date := l_effective_end_date;
863: hr_utility.trace(l_proc||' l_effective_start_date = ' ||to_char(l_effective_start_date, 'DD-MON-YYYY'));
864: hr_utility.trace(l_proc||' l_effective_end_date = ' ||to_char(l_effective_end_date, 'DD-MON-YYYY'));
865: end if;
866: end if;
867: end loop;

Line 864: hr_utility.trace(l_proc||' l_effective_end_date = ' ||to_char(l_effective_end_date, 'DD-MON-YYYY'));

860: l_found := true;
861: p_effective_start_date := l_effective_start_date;
862: p_effective_end_date := l_effective_end_date;
863: hr_utility.trace(l_proc||' l_effective_start_date = ' ||to_char(l_effective_start_date, 'DD-MON-YYYY'));
864: hr_utility.trace(l_proc||' l_effective_end_date = ' ||to_char(l_effective_end_date, 'DD-MON-YYYY'));
865: end if;
866: end if;
867: end loop;
868: --

Line 874: hr_utility.set_location ('Leaving :'||l_proc,1);

870: p_element_link_id := hr_entry_api.get_link (p_assignment_id => p_assignment_id,
871: p_element_type_id => p_element_type_id,
872: p_session_date => p_effective_start_date);
873: --
874: hr_utility.set_location ('Leaving :'||l_proc,1);
875: --
876: exception
877: when cannot_derive_payroll_period then
878: fnd_message.set_name ('SSP', 'SSP_35029_NO_PAYROLL_PERIOD');

Line 1166: hr_utility.trace('Entering ssp_entries_already_updated function');

1162:
1163:
1164: begin
1165:
1166: hr_utility.trace('Entering ssp_entries_already_updated function');
1167:
1168: /* Find SSP rate for new tax year */
1169: open csr_new_ssp_rate;
1170: fetch csr_new_ssp_rate into l_new_SSP_rate;

Line 1182: hr_utility.trace('New SSP rate: '||l_new_SSP_rate);

1178: end if;
1179:
1180: close csr_new_ssp_rate;
1181:
1182: hr_utility.trace('New SSP rate: '||l_new_SSP_rate);
1183:
1184: /* Find first element entry value holding SSP rate for new tax year */
1185: open csr_first_new_ssp_entry;
1186: fetch csr_first_new_ssp_entry into l_first_SSP_entry_rate;

Line 1198: hr_utility.trace('First SSP entry rate: '||l_first_SSP_entry_rate);

1194: end if;
1195:
1196: close csr_first_new_ssp_entry;
1197:
1198: hr_utility.trace('First SSP entry rate: '||l_first_SSP_entry_rate);
1199:
1200: if l_new_SSP_rate = l_first_SSP_entry_rate
1201: then
1202:

Line 1309: hr_utility.trace('Entering smp_rate_changed function');

1305: l_old_std_smp_rate number;
1306:
1307: begin
1308:
1309: hr_utility.trace('Entering smp_rate_changed function');
1310: --
1311: /* Find SMP rate for new tax year */
1312: open csr_new_smp_rate;
1313: fetch csr_new_smp_rate into l_new_SMP_rate, l_new_high_smp_rate, l_new_std_smp_rate;

Line 1325: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);

1321: end if;
1322: --
1323: close csr_new_smp_rate;
1324: --
1325: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
1326: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
1327: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
1328: --
1329: /* Find SMP rate for current tax year */

Line 1326: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);

1322: --
1323: close csr_new_smp_rate;
1324: --
1325: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
1326: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
1327: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
1328: --
1329: /* Find SMP rate for current tax year */
1330: open csr_old_smp_rate;

Line 1327: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);

1323: close csr_new_smp_rate;
1324: --
1325: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
1326: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
1327: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
1328: --
1329: /* Find SMP rate for current tax year */
1330: open csr_old_smp_rate;
1331: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;

Line 1334: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);

1330: open csr_old_smp_rate;
1331: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;
1332: close csr_old_smp_rate;
1333: --
1334: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
1335: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
1336: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
1337: --
1338: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)

Line 1335: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);

1331: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;
1332: close csr_old_smp_rate;
1333: --
1334: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
1335: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
1336: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
1337: --
1338: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
1339: then

Line 1336: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);

1332: close csr_old_smp_rate;
1333: --
1334: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
1335: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
1336: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
1337: --
1338: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
1339: then
1340: return false;

Line 1431: hr_utility.trace('Entering sap_rate_changed function');

1427: l_old_std_sap_rate number;
1428: --
1429: begin
1430: --
1431: hr_utility.trace('Entering sap_rate_changed function');
1432: --
1433: /* Find sap rate for new tax year */
1434: open csr_new_sap_rate;
1435: fetch csr_new_sap_rate into l_new_sap_rate, l_new_std_sap_rate;

Line 1446: hr_utility.trace('New sap rate: '||l_new_sap_rate);

1442: end if;
1443: --
1444: close csr_new_sap_rate;
1445: --
1446: hr_utility.trace('New sap rate: '||l_new_sap_rate);
1447: hr_utility.trace('New std sap rate: '||l_new_std_sap_rate);
1448: --
1449: /* Find sap rate for current tax year */
1450: open csr_old_sap_rate;

Line 1447: hr_utility.trace('New std sap rate: '||l_new_std_sap_rate);

1443: --
1444: close csr_new_sap_rate;
1445: --
1446: hr_utility.trace('New sap rate: '||l_new_sap_rate);
1447: hr_utility.trace('New std sap rate: '||l_new_std_sap_rate);
1448: --
1449: /* Find sap rate for current tax year */
1450: open csr_old_sap_rate;
1451: fetch csr_old_sap_rate into l_old_sap_rate, l_old_std_sap_rate;

Line 1454: hr_utility.trace('Old sap rate: '||l_old_sap_rate);

1450: open csr_old_sap_rate;
1451: fetch csr_old_sap_rate into l_old_sap_rate, l_old_std_sap_rate;
1452: close csr_old_sap_rate;
1453: --
1454: hr_utility.trace('Old sap rate: '||l_old_sap_rate);
1455: hr_utility.trace('Old std sap rate: '||l_old_std_sap_rate);
1456: --
1457: if (l_new_sap_rate = l_old_sap_rate) and (l_new_std_sap_rate = l_old_std_sap_rate) then
1458: return false;

Line 1455: hr_utility.trace('Old std sap rate: '||l_old_std_sap_rate);

1451: fetch csr_old_sap_rate into l_old_sap_rate, l_old_std_sap_rate;
1452: close csr_old_sap_rate;
1453: --
1454: hr_utility.trace('Old sap rate: '||l_old_sap_rate);
1455: hr_utility.trace('Old std sap rate: '||l_old_std_sap_rate);
1456: --
1457: if (l_new_sap_rate = l_old_sap_rate) and (l_new_std_sap_rate = l_old_std_sap_rate) then
1458: return false;
1459: else

Line 1547: hr_utility.trace('Entering sppa_rate_changed function');

1543: l_old_std_sppa_rate number;
1544: --
1545: begin
1546: --
1547: hr_utility.trace('Entering sppa_rate_changed function');
1548: --
1549: /* Find sppa rate for new tax year */
1550: open csr_new_sppa_rate;
1551: fetch csr_new_sppa_rate into l_new_sppa_rate, l_new_std_sppa_rate;

Line 1562: hr_utility.trace('New sppa rate: '||l_new_sppa_rate);

1558: end if;
1559: --
1560: close csr_new_sppa_rate;
1561: --
1562: hr_utility.trace('New sppa rate: '||l_new_sppa_rate);
1563: hr_utility.trace('New std sppa rate: '||l_new_std_sppa_rate);
1564: --
1565: open csr_old_sppa_rate;
1566: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;

Line 1563: hr_utility.trace('New std sppa rate: '||l_new_std_sppa_rate);

1559: --
1560: close csr_new_sppa_rate;
1561: --
1562: hr_utility.trace('New sppa rate: '||l_new_sppa_rate);
1563: hr_utility.trace('New std sppa rate: '||l_new_std_sppa_rate);
1564: --
1565: open csr_old_sppa_rate;
1566: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;
1567: close csr_old_sppa_rate;

Line 1569: hr_utility.trace('Old SPPA rate: '||l_old_sppa_rate);

1565: open csr_old_sppa_rate;
1566: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;
1567: close csr_old_sppa_rate;
1568: --
1569: hr_utility.trace('Old SPPA rate: '||l_old_sppa_rate);
1570: hr_utility.trace('Old Std SPPA rate: '||l_old_std_sppa_rate);
1571: --
1572: if (l_new_sppa_rate = l_old_sppa_rate) and (l_new_std_sppa_rate = l_old_std_sppa_rate) then
1573: return false;

Line 1570: hr_utility.trace('Old Std SPPA rate: '||l_old_std_sppa_rate);

1566: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;
1567: close csr_old_sppa_rate;
1568: --
1569: hr_utility.trace('Old SPPA rate: '||l_old_sppa_rate);
1570: hr_utility.trace('Old Std SPPA rate: '||l_old_std_sppa_rate);
1571: --
1572: if (l_new_sppa_rate = l_old_sppa_rate) and (l_new_std_sppa_rate = l_old_std_sppa_rate) then
1573: return false;
1574: else

Line 1661: hr_utility.trace('Entering sppb_rate_changed function');

1657: l_old_std_sppb_rate number;
1658: --
1659: begin
1660: --
1661: hr_utility.trace('Entering sppb_rate_changed function');
1662: --
1663: /* Find SPPB rate for new tax year */
1664: open csr_new_sppb_rate;
1665: fetch csr_new_sppb_rate into l_new_sppb_rate, l_new_std_sppb_rate;

Line 1676: hr_utility.trace('New SPPB rate: '||l_new_sppb_rate);

1672: end if;
1673: --
1674: close csr_new_sppb_rate;
1675: --
1676: hr_utility.trace('New SPPB rate: '||l_new_sppb_rate);
1677: hr_utility.trace('New Std SPPB rate: '||l_new_Std_sppb_rate);
1678: --
1679: open csr_old_sppb_rate;
1680: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;

Line 1677: hr_utility.trace('New Std SPPB rate: '||l_new_Std_sppb_rate);

1673: --
1674: close csr_new_sppb_rate;
1675: --
1676: hr_utility.trace('New SPPB rate: '||l_new_sppb_rate);
1677: hr_utility.trace('New Std SPPB rate: '||l_new_Std_sppb_rate);
1678: --
1679: open csr_old_sppb_rate;
1680: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;
1681: close csr_old_sppb_rate;

Line 1683: hr_utility.trace('old SPPB rate: '||l_old_sppb_rate);

1679: open csr_old_sppb_rate;
1680: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;
1681: close csr_old_sppb_rate;
1682: --
1683: hr_utility.trace('old SPPB rate: '||l_old_sppb_rate);
1684: hr_utility.trace('old Std SPPB rate: '||l_old_Std_sppb_rate);
1685: --
1686: if (l_new_sppb_rate = l_old_sppb_rate) and (l_new_std_sppb_rate = l_old_std_sppb_rate) then
1687: return false;

Line 1684: hr_utility.trace('old Std SPPB rate: '||l_old_Std_sppb_rate);

1680: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;
1681: close csr_old_sppb_rate;
1682: --
1683: hr_utility.trace('old SPPB rate: '||l_old_sppb_rate);
1684: hr_utility.trace('old Std SPPB rate: '||l_old_Std_sppb_rate);
1685: --
1686: if (l_new_sppb_rate = l_old_sppb_rate) and (l_new_std_sppb_rate = l_old_std_sppb_rate) then
1687: return false;
1688: else

Line 1724: hr_utility.trace('Entering asppb_rate_changed function');

1720: l_old_std_asppb_rate number;
1721: --
1722: begin
1723: --
1724: hr_utility.trace('Entering asppb_rate_changed function');
1725: --
1726: /* Find SPPB rate for new tax year */
1727: open csr_new_asppb_rate;
1728: fetch csr_new_asppb_rate into l_old_asppb_rate, l_new_std_asppb_rate;

Line 1739: hr_utility.trace('New ASPPB rate: '||l_new_asppb_rate);

1735: end if;
1736: --
1737: close csr_new_asppb_rate;
1738: --
1739: hr_utility.trace('New ASPPB rate: '||l_new_asppb_rate);
1740: hr_utility.trace('New Std ASPPB rate: '||l_new_std_asppb_rate);
1741: --
1742: open csr_old_asppb_rate;
1743: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;

Line 1740: hr_utility.trace('New Std ASPPB rate: '||l_new_std_asppb_rate);

1736: --
1737: close csr_new_asppb_rate;
1738: --
1739: hr_utility.trace('New ASPPB rate: '||l_new_asppb_rate);
1740: hr_utility.trace('New Std ASPPB rate: '||l_new_std_asppb_rate);
1741: --
1742: open csr_old_asppb_rate;
1743: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;
1744: close csr_old_asppb_rate;

Line 1746: hr_utility.trace('old ASPPB rate: '||l_old_asppb_rate);

1742: open csr_old_asppb_rate;
1743: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;
1744: close csr_old_asppb_rate;
1745: --
1746: hr_utility.trace('old ASPPB rate: '||l_old_asppb_rate);
1747: hr_utility.trace('old Std ASPPB rate: '||l_old_std_asppb_rate);
1748: --
1749: if (l_new_asppb_rate= l_old_asppb_rate) and (l_new_std_asppb_rate = l_old_std_asppb_rate) then
1750: return false;

Line 1747: hr_utility.trace('old Std ASPPB rate: '||l_old_std_asppb_rate);

1743: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;
1744: close csr_old_asppb_rate;
1745: --
1746: hr_utility.trace('old ASPPB rate: '||l_old_asppb_rate);
1747: hr_utility.trace('old Std ASPPB rate: '||l_old_std_asppb_rate);
1748: --
1749: if (l_new_asppb_rate= l_old_asppb_rate) and (l_new_std_asppb_rate = l_old_std_asppb_rate) then
1750: return false;
1751: else

Line 1785: hr_utility.trace('Entering asppa_rate_changed function');

1781: l_old_std_asppa_rate number;
1782: --
1783: begin
1784: --
1785: hr_utility.trace('Entering asppa_rate_changed function');
1786: --
1787: /* Find SPPB rate for new tax year */
1788: open csr_new_asppa_rate;
1789: fetch csr_new_asppa_rate into l_old_asppa_rate, l_new_std_asppa_rate;

Line 1800: hr_utility.trace('New ASPPA rate: '||l_new_asppa_rate);

1796: end if;
1797: --
1798: close csr_new_asppa_rate;
1799: --
1800: hr_utility.trace('New ASPPA rate: '||l_new_asppa_rate);
1801: hr_utility.trace('New Std ASPPA rate: '||l_new_std_asppa_rate);
1802: --
1803: open csr_old_asppa_rate;
1804: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;

Line 1801: hr_utility.trace('New Std ASPPA rate: '||l_new_std_asppa_rate);

1797: --
1798: close csr_new_asppa_rate;
1799: --
1800: hr_utility.trace('New ASPPA rate: '||l_new_asppa_rate);
1801: hr_utility.trace('New Std ASPPA rate: '||l_new_std_asppa_rate);
1802: --
1803: open csr_old_asppa_rate;
1804: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;
1805: close csr_old_asppa_rate;

Line 1807: hr_utility.trace('old ASPPA rate: '||l_old_asppa_rate);

1803: open csr_old_asppa_rate;
1804: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;
1805: close csr_old_asppa_rate;
1806: --
1807: hr_utility.trace('old ASPPA rate: '||l_old_asppa_rate);
1808: hr_utility.trace('old Std ASPPA rate: '||l_old_std_asppa_rate);
1809: --
1810: if (l_new_asppa_rate= l_old_asppa_rate) and (l_new_std_asppa_rate = l_old_std_asppa_rate) then
1811: return false;

Line 1808: hr_utility.trace('old Std ASPPA rate: '||l_old_std_asppa_rate);

1804: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;
1805: close csr_old_asppa_rate;
1806: --
1807: hr_utility.trace('old ASPPA rate: '||l_old_asppa_rate);
1808: hr_utility.trace('old Std ASPPA rate: '||l_old_std_asppa_rate);
1809: --
1810: if (l_new_asppa_rate= l_old_asppa_rate) and (l_new_std_asppa_rate = l_old_std_asppa_rate) then
1811: return false;
1812: else

Line 1828: hr_utility.trace('Entering: '||g_package||'.update_ssp_smp_entries');

1824:
1825: /* Main program body */
1826: begin
1827:
1828: hr_utility.trace('Entering: '||g_package||'.update_ssp_smp_entries');
1829:
1830: savepoint pre_update_status;
1831: /* Check first whether SSP element entries already updated for new tax year */
1832: /* SSP update block */

Line 1840: hr_utility.trace('SSP element entries not updated, updating ....');

1836:
1837: if not ssp_entries_already_updated
1838: then
1839:
1840: hr_utility.trace('SSP element entries not updated, updating ....');
1841:
1842: for r_affected_absences in csr_affected_absences loop
1843:
1844: /* SSP control call block */

Line 1847: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);

1843:
1844: /* SSP control call block */
1845: begin
1846:
1847: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
1848:
1849: ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
1850:
1851: l_count := l_count + 1;

Line 1856: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);

1852:
1853: exception
1854:
1855: when others then
1856: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
1857: hr_utility.trace('SQL error code: '||SQLCODE);
1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);
1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);

Line 1857: hr_utility.trace('SQL error code: '||SQLCODE);

1853: exception
1854:
1855: when others then
1856: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
1857: hr_utility.trace('SQL error code: '||SQLCODE);
1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);
1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
1861: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);

Line 1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

1854:
1855: when others then
1856: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
1857: hr_utility.trace('SQL error code: '||SQLCODE);
1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);
1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
1861: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
1862: l_update_error := true;

Line 1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);

1855: when others then
1856: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
1857: hr_utility.trace('SQL error code: '||SQLCODE);
1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);
1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
1861: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
1862: l_update_error := true;
1863:

Line 1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);

1856: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
1857: hr_utility.trace('SQL error code: '||SQLCODE);
1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);
1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
1861: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
1862: l_update_error := true;
1863:
1864: end;

Line 1861: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);

1857: hr_utility.trace('SQL error code: '||SQLCODE);
1858: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1859: hr_utility.trace('Person id: '||r_affected_absences.person_id);
1860: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
1861: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
1862: l_update_error := true;
1863:
1864: end;
1865:

Line 1870: hr_utility.trace('Updated entries for '||l_count||' absences');

1866:
1867:
1868: end loop;
1869:
1870: hr_utility.trace('Updated entries for '||l_count||' absences');
1871:
1872: else
1873:
1874: hr_utility.trace('SSP element entries already updated for new tax year');

Line 1874: hr_utility.trace('SSP element entries already updated for new tax year');

1870: hr_utility.trace('Updated entries for '||l_count||' absences');
1871:
1872: else
1873:
1874: hr_utility.trace('SSP element entries already updated for new tax year');
1875:
1876: end if;
1877:
1878: commit;

Line 1884: hr_utility.trace('Warning: SSP rate for new tax year not set');

1880: exception
1881:
1882: when e_ssp_rate_not_set
1883: then
1884: hr_utility.trace('Warning: SSP rate for new tax year not set');
1885: hr_utility.trace('Unable to proceed with updating SSP entries');
1886:
1887:
1888: when e_no_new_ssp_entry

Line 1885: hr_utility.trace('Unable to proceed with updating SSP entries');

1881:
1882: when e_ssp_rate_not_set
1883: then
1884: hr_utility.trace('Warning: SSP rate for new tax year not set');
1885: hr_utility.trace('Unable to proceed with updating SSP entries');
1886:
1887:
1888: when e_no_new_ssp_entry
1889: then

Line 1890: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');

1886:
1887:
1888: when e_no_new_ssp_entry
1889: then
1890: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');
1891: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');
1892: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
1893:
1894: when others

Line 1891: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');

1887:
1888: when e_no_new_ssp_entry
1889: then
1890: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');
1891: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');
1892: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
1893:
1894: when others
1895: then

Line 1892: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');

1888: when e_no_new_ssp_entry
1889: then
1890: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');
1891: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');
1892: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
1893:
1894: when others
1895: then
1896: hr_utility.trace('Unexpected error occurred inside SSP update block');

Line 1896: hr_utility.trace('Unexpected error occurred inside SSP update block');

1892: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
1893:
1894: when others
1895: then
1896: hr_utility.trace('Unexpected error occurred inside SSP update block');
1897: hr_utility.trace('SQL error number: '||SQLCODE);
1898: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1899: rollback to pre_ssp_update_status;
1900: l_update_error := true;

Line 1897: hr_utility.trace('SQL error number: '||SQLCODE);

1893:
1894: when others
1895: then
1896: hr_utility.trace('Unexpected error occurred inside SSP update block');
1897: hr_utility.trace('SQL error number: '||SQLCODE);
1898: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1899: rollback to pre_ssp_update_status;
1900: l_update_error := true;
1901:

Line 1898: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

1894: when others
1895: then
1896: hr_utility.trace('Unexpected error occurred inside SSP update block');
1897: hr_utility.trace('SQL error number: '||SQLCODE);
1898: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1899: rollback to pre_ssp_update_status;
1900: l_update_error := true;
1901:
1902: end; /* SSP update block */

Line 1913: hr_utility.trace('SMP element entries updating ....');

1909: savepoint pre_smp_update_status;
1910: --
1911: if smp_rate_changed then
1912: --
1913: hr_utility.trace('SMP element entries updating ....');
1914: for r_affected_maternities in csr_affected_leave('MA') loop
1915: /* SMP Control call block */
1916: begin
1917: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);

Line 1917: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);

1913: hr_utility.trace('SMP element entries updating ....');
1914: for r_affected_maternities in csr_affected_leave('MA') loop
1915: /* SMP Control call block */
1916: begin
1917: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);
1918: ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
1919: p_deleting => FALSE);
1920: l_mat_count := l_mat_count + 1;
1921: exception

Line 1923: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);

1919: p_deleting => FALSE);
1920: l_mat_count := l_mat_count + 1;
1921: exception
1922: when others then
1923: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
1924: hr_utility.trace('SQL error code: '||SQLCODE);
1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);

Line 1924: hr_utility.trace('SQL error code: '||SQLCODE);

1920: l_mat_count := l_mat_count + 1;
1921: exception
1922: when others then
1923: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
1924: hr_utility.trace('SQL error code: '||SQLCODE);
1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);

Line 1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

1921: exception
1922: when others then
1923: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
1924: hr_utility.trace('SQL error code: '||SQLCODE);
1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);

Line 1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);

1922: when others then
1923: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
1924: hr_utility.trace('SQL error code: '||SQLCODE);
1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);

Line 1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);

1923: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
1924: hr_utility.trace('SQL error code: '||SQLCODE);
1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
1931: l_update_error := true;

Line 1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);

1924: hr_utility.trace('SQL error code: '||SQLCODE);
1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
1931: l_update_error := true;
1932: end;

Line 1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);

1925: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
1931: l_update_error := true;
1932: end;
1933: end loop;

Line 1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);

1926: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
1927: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
1928: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
1929: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
1931: l_update_error := true;
1932: end;
1933: end loop;
1934: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');

Line 1934: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');

1930: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
1931: l_update_error := true;
1932: end;
1933: end loop;
1934: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');
1935: else
1936: hr_utility.trace('SMP element entries already updated for new tax year');
1937: end if;
1938: --

Line 1936: hr_utility.trace('SMP element entries already updated for new tax year');

1932: end;
1933: end loop;
1934: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');
1935: else
1936: hr_utility.trace('SMP element entries already updated for new tax year');
1937: end if;
1938: --
1939: commit;
1940: --

Line 1943: hr_utility.trace('Warning: SMP rate for new tax year not set');

1939: commit;
1940: --
1941: exception
1942: when e_smp_rate_not_set then
1943: hr_utility.trace('Warning: SMP rate for new tax year not set');
1944: hr_utility.trace('Unable to proceed with updating SMP entries');
1945: when e_no_new_smp_entry then
1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');

Line 1944: hr_utility.trace('Unable to proceed with updating SMP entries');

1940: --
1941: exception
1942: when e_smp_rate_not_set then
1943: hr_utility.trace('Warning: SMP rate for new tax year not set');
1944: hr_utility.trace('Unable to proceed with updating SMP entries');
1945: when e_no_new_smp_entry then
1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');

1942: when e_smp_rate_not_set then
1943: hr_utility.trace('Warning: SMP rate for new tax year not set');
1944: hr_utility.trace('Unable to proceed with updating SMP entries');
1945: when e_no_new_smp_entry then
1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
1949: when others then
1950: hr_utility.trace('Unexpected error occurred inside SMP update block');

Line 1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');

1943: hr_utility.trace('Warning: SMP rate for new tax year not set');
1944: hr_utility.trace('Unable to proceed with updating SMP entries');
1945: when e_no_new_smp_entry then
1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
1949: when others then
1950: hr_utility.trace('Unexpected error occurred inside SMP update block');
1951: hr_utility.trace('SQL error number: '||SQLCODE);

Line 1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

1944: hr_utility.trace('Unable to proceed with updating SMP entries');
1945: when e_no_new_smp_entry then
1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
1949: when others then
1950: hr_utility.trace('Unexpected error occurred inside SMP update block');
1951: hr_utility.trace('SQL error number: '||SQLCODE);
1952: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 1950: hr_utility.trace('Unexpected error occurred inside SMP update block');

1946: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
1949: when others then
1950: hr_utility.trace('Unexpected error occurred inside SMP update block');
1951: hr_utility.trace('SQL error number: '||SQLCODE);
1952: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1953: rollback to pre_smp_update_status;
1954: l_update_error := true;

Line 1951: hr_utility.trace('SQL error number: '||SQLCODE);

1947: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
1949: when others then
1950: hr_utility.trace('Unexpected error occurred inside SMP update block');
1951: hr_utility.trace('SQL error number: '||SQLCODE);
1952: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1953: rollback to pre_smp_update_status;
1954: l_update_error := true;
1955: end; /* SMP update block */

Line 1952: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

1948: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
1949: when others then
1950: hr_utility.trace('Unexpected error occurred inside SMP update block');
1951: hr_utility.trace('SQL error number: '||SQLCODE);
1952: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1953: rollback to pre_smp_update_status;
1954: l_update_error := true;
1955: end; /* SMP update block */
1956: -- 05/12/2003 rmakhija: Uncommented section ends here

Line 1965: hr_utility.trace('SAP element entries updating ....');

1961: savepoint pre_sap_update_status;
1962: --
1963: if sap_rate_changed then
1964: --
1965: hr_utility.trace('SAP element entries updating ....');
1966: for r_affected_adoption in csr_affected_leave('AD') loop
1967: /* SAP Control call block */
1968: begin
1969: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);

Line 1969: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);

1965: hr_utility.trace('SAP element entries updating ....');
1966: for r_affected_adoption in csr_affected_leave('AD') loop
1967: /* SAP Control call block */
1968: begin
1969: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);
1970: ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
1971: p_deleting => FALSE);
1972: l_adop_count := l_adop_count + 1;
1973: exception

Line 1975: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);

1971: p_deleting => FALSE);
1972: l_adop_count := l_adop_count + 1;
1973: exception
1974: when others then
1975: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
1976: hr_utility.trace('SQL error code: '||SQLCODE);
1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);

Line 1976: hr_utility.trace('SQL error code: '||SQLCODE);

1972: l_adop_count := l_adop_count + 1;
1973: exception
1974: when others then
1975: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
1976: hr_utility.trace('SQL error code: '||SQLCODE);
1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);

Line 1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

1973: exception
1974: when others then
1975: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
1976: hr_utility.trace('SQL error code: '||SQLCODE);
1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);

Line 1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);

1974: when others then
1975: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
1976: hr_utility.trace('SQL error code: '||SQLCODE);
1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);

Line 1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);

1975: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
1976: hr_utility.trace('SQL error code: '||SQLCODE);
1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
1983: l_update_error := true;

Line 1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);

1976: hr_utility.trace('SQL error code: '||SQLCODE);
1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
1983: l_update_error := true;
1984: end;

Line 1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);

1977: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
1983: l_update_error := true;
1984: end;
1985: end loop;

Line 1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);

1978: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
1979: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
1980: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
1981: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
1983: l_update_error := true;
1984: end;
1985: end loop;
1986: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');

Line 1986: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');

1982: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
1983: l_update_error := true;
1984: end;
1985: end loop;
1986: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');
1987: else
1988: hr_utility.trace('SAP element entries already updated for new tax year');
1989: end if;
1990: --

Line 1988: hr_utility.trace('SAP element entries already updated for new tax year');

1984: end;
1985: end loop;
1986: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');
1987: else
1988: hr_utility.trace('SAP element entries already updated for new tax year');
1989: end if;
1990: --
1991: commit;
1992: --

Line 1995: hr_utility.trace('Warning: SAP rate for new tax year not set');

1991: commit;
1992: --
1993: exception
1994: when e_sap_rate_not_set then
1995: hr_utility.trace('Warning: SAP rate for new tax year not set');
1996: hr_utility.trace('Unable to proceed with updating SAP entries');
1997: when e_no_new_sap_entry then
1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');

Line 1996: hr_utility.trace('Unable to proceed with updating SAP entries');

1992: --
1993: exception
1994: when e_sap_rate_not_set then
1995: hr_utility.trace('Warning: SAP rate for new tax year not set');
1996: hr_utility.trace('Unable to proceed with updating SAP entries');
1997: when e_no_new_sap_entry then
1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');

1994: when e_sap_rate_not_set then
1995: hr_utility.trace('Warning: SAP rate for new tax year not set');
1996: hr_utility.trace('Unable to proceed with updating SAP entries');
1997: when e_no_new_sap_entry then
1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2001: when others then
2002: hr_utility.trace('Unexpected error occurred inside SAP update block');

Line 1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');

1995: hr_utility.trace('Warning: SAP rate for new tax year not set');
1996: hr_utility.trace('Unable to proceed with updating SAP entries');
1997: when e_no_new_sap_entry then
1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2001: when others then
2002: hr_utility.trace('Unexpected error occurred inside SAP update block');
2003: hr_utility.trace('SQL error number: '||SQLCODE);

Line 2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

1996: hr_utility.trace('Unable to proceed with updating SAP entries');
1997: when e_no_new_sap_entry then
1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2001: when others then
2002: hr_utility.trace('Unexpected error occurred inside SAP update block');
2003: hr_utility.trace('SQL error number: '||SQLCODE);
2004: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 2002: hr_utility.trace('Unexpected error occurred inside SAP update block');

1998: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2001: when others then
2002: hr_utility.trace('Unexpected error occurred inside SAP update block');
2003: hr_utility.trace('SQL error number: '||SQLCODE);
2004: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2005: rollback to pre_sap_update_status;
2006: l_update_error := true;

Line 2003: hr_utility.trace('SQL error number: '||SQLCODE);

1999: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2001: when others then
2002: hr_utility.trace('Unexpected error occurred inside SAP update block');
2003: hr_utility.trace('SQL error number: '||SQLCODE);
2004: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2005: rollback to pre_sap_update_status;
2006: l_update_error := true;
2007: end; /* SAP update block */

Line 2004: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2000: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2001: when others then
2002: hr_utility.trace('Unexpected error occurred inside SAP update block');
2003: hr_utility.trace('SQL error number: '||SQLCODE);
2004: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2005: rollback to pre_sap_update_status;
2006: l_update_error := true;
2007: end; /* SAP update block */
2008: -- Begin SPP Adoption Update Block

Line 2015: hr_utility.trace('SPP Adoption element entries updating ....');

2011: savepoint pre_sppa_update_status;
2012: --
2013: if sppa_rate_changed then
2014: --
2015: hr_utility.trace('SPP Adoption element entries updating ....');
2016: for r_affected_pat_adop in csr_affected_leave('PA') loop
2017: /* SPP Adoption Control call block */
2018: begin
2019: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);

Line 2019: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);

2015: hr_utility.trace('SPP Adoption element entries updating ....');
2016: for r_affected_pat_adop in csr_affected_leave('PA') loop
2017: /* SPP Adoption Control call block */
2018: begin
2019: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2020: ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
2021: p_deleting => FALSE);
2022: l_pat_adop_count := l_pat_adop_count + 1;
2023: exception

Line 2025: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);

2021: p_deleting => FALSE);
2022: l_pat_adop_count := l_pat_adop_count + 1;
2023: exception
2024: when others then
2025: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2026: hr_utility.trace('SQL error code: '||SQLCODE);
2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);

Line 2026: hr_utility.trace('SQL error code: '||SQLCODE);

2022: l_pat_adop_count := l_pat_adop_count + 1;
2023: exception
2024: when others then
2025: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2026: hr_utility.trace('SQL error code: '||SQLCODE);
2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);

Line 2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2023: exception
2024: when others then
2025: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2026: hr_utility.trace('SQL error code: '||SQLCODE);
2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);

Line 2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);

2024: when others then
2025: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2026: hr_utility.trace('SQL error code: '||SQLCODE);
2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);

Line 2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);

2025: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
2026: hr_utility.trace('SQL error code: '||SQLCODE);
2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
2033: l_update_error := true;

Line 2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);

2026: hr_utility.trace('SQL error code: '||SQLCODE);
2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
2033: l_update_error := true;
2034: end;

Line 2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);

2027: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
2033: l_update_error := true;
2034: end;
2035: end loop;

Line 2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);

2028: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
2029: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
2030: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
2031: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
2033: l_update_error := true;
2034: end;
2035: end loop;
2036: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');

Line 2036: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');

2032: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
2033: l_update_error := true;
2034: end;
2035: end loop;
2036: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');
2037: else
2038: hr_utility.trace('SPP Adoption element entries already updated for new tax year');
2039: end if;
2040: --

Line 2038: hr_utility.trace('SPP Adoption element entries already updated for new tax year');

2034: end;
2035: end loop;
2036: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');
2037: else
2038: hr_utility.trace('SPP Adoption element entries already updated for new tax year');
2039: end if;
2040: --
2041: commit;
2042: --

Line 2045: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');

2041: commit;
2042: --
2043: exception
2044: when e_sppa_rate_not_set then
2045: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
2046: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
2047: when e_no_new_sppa_entry then
2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');

Line 2046: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');

2042: --
2043: exception
2044: when e_sppa_rate_not_set then
2045: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
2046: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
2047: when e_no_new_sppa_entry then
2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');

2044: when e_sppa_rate_not_set then
2045: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
2046: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
2047: when e_no_new_sppa_entry then
2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2051: when others then
2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');

Line 2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');

2045: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
2046: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
2047: when e_no_new_sppa_entry then
2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2051: when others then
2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
2053: hr_utility.trace('SQL error number: '||SQLCODE);

Line 2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

2046: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
2047: when e_no_new_sppa_entry then
2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2051: when others then
2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
2053: hr_utility.trace('SQL error number: '||SQLCODE);
2054: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');

2048: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2051: when others then
2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
2053: hr_utility.trace('SQL error number: '||SQLCODE);
2054: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2055: rollback to pre_sppa_update_status;
2056: l_update_error := true;

Line 2053: hr_utility.trace('SQL error number: '||SQLCODE);

2049: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2051: when others then
2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
2053: hr_utility.trace('SQL error number: '||SQLCODE);
2054: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2055: rollback to pre_sppa_update_status;
2056: l_update_error := true;
2057: end; /* SPP Adoption update block */

Line 2054: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2050: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2051: when others then
2052: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
2053: hr_utility.trace('SQL error number: '||SQLCODE);
2054: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2055: rollback to pre_sppa_update_status;
2056: l_update_error := true;
2057: end; /* SPP Adoption update block */
2058: -- Begin SPP Birth Update Block

Line 2065: hr_utility.trace('SPP Birth element entries updating ....');

2061: savepoint pre_sppb_update_status;
2062: --
2063: if sppb_rate_changed then
2064: --
2065: hr_utility.trace('SPP Birth element entries updating ....');
2066: for r_affected_pat_Birth in csr_affected_leave('PB') loop
2067: /* SPP Birth Control call block */
2068: begin
2069: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);

Line 2069: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);

2065: hr_utility.trace('SPP Birth element entries updating ....');
2066: for r_affected_pat_Birth in csr_affected_leave('PB') loop
2067: /* SPP Birth Control call block */
2068: begin
2069: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2070: ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
2071: p_deleting => FALSE);
2072: l_pat_Birth_count := l_pat_birth_count + 1;
2073: exception

Line 2075: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);

2071: p_deleting => FALSE);
2072: l_pat_Birth_count := l_pat_birth_count + 1;
2073: exception
2074: when others then
2075: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2076: hr_utility.trace('SQL error code: '||SQLCODE);
2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);

Line 2076: hr_utility.trace('SQL error code: '||SQLCODE);

2072: l_pat_Birth_count := l_pat_birth_count + 1;
2073: exception
2074: when others then
2075: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2076: hr_utility.trace('SQL error code: '||SQLCODE);
2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);

Line 2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2073: exception
2074: when others then
2075: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2076: hr_utility.trace('SQL error code: '||SQLCODE);
2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);

Line 2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);

2074: when others then
2075: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2076: hr_utility.trace('SQL error code: '||SQLCODE);
2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);

Line 2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);

2075: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
2076: hr_utility.trace('SQL error code: '||SQLCODE);
2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
2083: l_update_error := true;

Line 2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);

2076: hr_utility.trace('SQL error code: '||SQLCODE);
2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
2083: l_update_error := true;
2084: end;

Line 2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);

2077: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
2083: l_update_error := true;
2084: end;
2085: end loop;

Line 2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);

2078: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
2079: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
2080: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
2081: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
2083: l_update_error := true;
2084: end;
2085: end loop;
2086: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');

Line 2086: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');

2082: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
2083: l_update_error := true;
2084: end;
2085: end loop;
2086: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');
2087: else
2088: hr_utility.trace('SPP Birth element entries already updated for new tax year');
2089: end if;
2090: --

Line 2088: hr_utility.trace('SPP Birth element entries already updated for new tax year');

2084: end;
2085: end loop;
2086: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');
2087: else
2088: hr_utility.trace('SPP Birth element entries already updated for new tax year');
2089: end if;
2090: --
2091: commit;
2092: --

Line 2095: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');

2091: commit;
2092: --
2093: exception
2094: when e_sppb_rate_not_set then
2095: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
2096: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
2097: when e_no_new_sppb_entry then
2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');

Line 2096: hr_utility.trace('Unable to proceed with updating SPP Birth entries');

2092: --
2093: exception
2094: when e_sppb_rate_not_set then
2095: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
2096: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
2097: when e_no_new_sppb_entry then
2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');

2094: when e_sppb_rate_not_set then
2095: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
2096: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
2097: when e_no_new_sppb_entry then
2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2101: when others then
2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');

Line 2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');

2095: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
2096: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
2097: when e_no_new_sppb_entry then
2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2101: when others then
2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
2103: hr_utility.trace('SQL error number: '||SQLCODE);

Line 2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

2096: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
2097: when e_no_new_sppb_entry then
2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2101: when others then
2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
2103: hr_utility.trace('SQL error number: '||SQLCODE);
2104: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');

2098: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2101: when others then
2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
2103: hr_utility.trace('SQL error number: '||SQLCODE);
2104: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2105: rollback to pre_sppb_update_status;
2106: l_update_error := true;

Line 2103: hr_utility.trace('SQL error number: '||SQLCODE);

2099: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2101: when others then
2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
2103: hr_utility.trace('SQL error number: '||SQLCODE);
2104: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2105: rollback to pre_sppb_update_status;
2106: l_update_error := true;
2107: end; /* SPP Birth update block */

Line 2104: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2100: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2101: when others then
2102: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
2103: hr_utility.trace('SQL error number: '||SQLCODE);
2104: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2105: rollback to pre_sppb_update_status;
2106: l_update_error := true;
2107: end; /* SPP Birth update block */
2108:

Line 2119: hr_utility.trace('ASPP Adoption element entries updating ....');

2115: savepoint pre_asppa_update_status;
2116: --
2117: if asppa_rate_changed then
2118: --
2119: hr_utility.trace('ASPP Adoption element entries updating ....');
2120: for r_affected_apat_adop in csr_affected_leave('AA') loop
2121: /* ASPP Adoption Control call block */
2122: begin
2123: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);

Line 2123: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);

2119: hr_utility.trace('ASPP Adoption element entries updating ....');
2120: for r_affected_apat_adop in csr_affected_leave('AA') loop
2121: /* ASPP Adoption Control call block */
2122: begin
2123: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2124:
2125: ssp_apad_pkg.apad_control(p_maternity_id => r_affected_apat_adop.maternity_id,
2126:
2127:

Line 2133: hr_utility.trace('Error occurred while processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);

2129: l_apad_count := l_apad_count + 1;
2130:
2131: exception
2132: when others then
2133: hr_utility.trace('Error occurred while processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2134: hr_utility.trace('SQL error code: '||SQLCODE);
2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);

Line 2134: hr_utility.trace('SQL error code: '||SQLCODE);

2130:
2131: exception
2132: when others then
2133: hr_utility.trace('Error occurred while processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2134: hr_utility.trace('SQL error code: '||SQLCODE);
2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);

Line 2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2131: exception
2132: when others then
2133: hr_utility.trace('Error occurred while processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2134: hr_utility.trace('SQL error code: '||SQLCODE);
2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);

Line 2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);

2132: when others then
2133: hr_utility.trace('Error occurred while processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2134: hr_utility.trace('SQL error code: '||SQLCODE);
2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);

Line 2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);

2133: hr_utility.trace('Error occurred while processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
2134: hr_utility.trace('SQL error code: '||SQLCODE);
2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
2141: l_update_error := true;

Line 2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);

2134: hr_utility.trace('SQL error code: '||SQLCODE);
2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
2141: l_update_error := true;
2142: end;

Line 2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);

2135: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
2141: l_update_error := true;
2142: end;
2143: end loop;

Line 2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);

2136: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
2137: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
2138: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
2139: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
2141: l_update_error := true;
2142: end;
2143: end loop;
2144: hr_utility.trace('Updated entries for '||l_apad_count||' additional paternity adoptions');

Line 2144: hr_utility.trace('Updated entries for '||l_apad_count||' additional paternity adoptions');

2140: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
2141: l_update_error := true;
2142: end;
2143: end loop;
2144: hr_utility.trace('Updated entries for '||l_apad_count||' additional paternity adoptions');
2145:
2146: else
2147: hr_utility.trace('ASPP Adoption element entries already updated for new tax year');
2148: end if;

Line 2147: hr_utility.trace('ASPP Adoption element entries already updated for new tax year');

2143: end loop;
2144: hr_utility.trace('Updated entries for '||l_apad_count||' additional paternity adoptions');
2145:
2146: else
2147: hr_utility.trace('ASPP Adoption element entries already updated for new tax year');
2148: end if;
2149: --
2150: commit;
2151: --

Line 2154: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');

2150: commit;
2151: --
2152: exception
2153: when e_asppa_rate_not_set then
2154: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
2155: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
2156: when e_no_new_asppa_entry then
2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');

Line 2155: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');

2151: --
2152: exception
2153: when e_asppa_rate_not_set then
2154: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
2155: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
2156: when e_no_new_asppa_entry then
2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');

2153: when e_asppa_rate_not_set then
2154: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
2155: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
2156: when e_no_new_asppa_entry then
2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2160: when others then
2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');

Line 2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');

2154: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
2155: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
2156: when e_no_new_asppa_entry then
2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2160: when others then
2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
2162: hr_utility.trace('SQL error number: '||SQLCODE);

Line 2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

2155: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
2156: when e_no_new_asppa_entry then
2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2160: when others then
2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
2162: hr_utility.trace('SQL error number: '||SQLCODE);
2163: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');

2157: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2160: when others then
2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
2162: hr_utility.trace('SQL error number: '||SQLCODE);
2163: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2164: rollback to pre_asppa_update_status;
2165: l_update_error := true;

Line 2162: hr_utility.trace('SQL error number: '||SQLCODE);

2158: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2160: when others then
2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
2162: hr_utility.trace('SQL error number: '||SQLCODE);
2163: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2164: rollback to pre_asppa_update_status;
2165: l_update_error := true;
2166:

Line 2163: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2159: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2160: when others then
2161: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
2162: hr_utility.trace('SQL error number: '||SQLCODE);
2163: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2164: rollback to pre_asppa_update_status;
2165: l_update_error := true;
2166:
2167: end;

Line 2175: hr_utility.trace('ASPP Birth element entries updating ....');

2171: savepoint pre_asppb_update_status;
2172: --
2173: if asppb_rate_changed then
2174: --
2175: hr_utility.trace('ASPP Birth element entries updating ....');
2176: for r_affected_apat_birth in csr_affected_leave('AB') loop
2177: /* ASPP Adoption Control call block */
2178: begin
2179: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);

Line 2179: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);

2175: hr_utility.trace('ASPP Birth element entries updating ....');
2176: for r_affected_apat_birth in csr_affected_leave('AB') loop
2177: /* ASPP Adoption Control call block */
2178: begin
2179: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2180:
2181: ssp_apab_pkg.apab_control(p_maternity_id => r_affected_apat_birth.maternity_id,
2182: p_deleting => FALSE);
2183: l_apab_count := l_apab_count + 1;

Line 2187: hr_utility.trace('Error occurred while processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);

2183: l_apab_count := l_apab_count + 1;
2184:
2185: exception
2186: when others then
2187: hr_utility.trace('Error occurred while processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2188: hr_utility.trace('SQL error code: '||SQLCODE);
2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);

Line 2188: hr_utility.trace('SQL error code: '||SQLCODE);

2184:
2185: exception
2186: when others then
2187: hr_utility.trace('Error occurred while processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2188: hr_utility.trace('SQL error code: '||SQLCODE);
2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);

Line 2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2185: exception
2186: when others then
2187: hr_utility.trace('Error occurred while processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2188: hr_utility.trace('SQL error code: '||SQLCODE);
2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);

Line 2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);

2186: when others then
2187: hr_utility.trace('Error occurred while processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2188: hr_utility.trace('SQL error code: '||SQLCODE);
2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);

Line 2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);

2187: hr_utility.trace('Error occurred while processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
2188: hr_utility.trace('SQL error code: '||SQLCODE);
2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
2195: l_update_error := true;

Line 2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);

2188: hr_utility.trace('SQL error code: '||SQLCODE);
2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
2195: l_update_error := true;
2196: end;

Line 2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);

2189: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
2195: l_update_error := true;
2196: end;
2197: end loop;

Line 2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);

2190: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
2191: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
2192: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
2193: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
2195: l_update_error := true;
2196: end;
2197: end loop;
2198: hr_utility.trace('Updated entries for '||l_apab_count||' additional paternity Birth');

Line 2198: hr_utility.trace('Updated entries for '||l_apab_count||' additional paternity Birth');

2194: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
2195: l_update_error := true;
2196: end;
2197: end loop;
2198: hr_utility.trace('Updated entries for '||l_apab_count||' additional paternity Birth');
2199:
2200: else
2201: hr_utility.trace('ASPP Birth element entries already updated for new tax year');
2202: end if;

Line 2201: hr_utility.trace('ASPP Birth element entries already updated for new tax year');

2197: end loop;
2198: hr_utility.trace('Updated entries for '||l_apab_count||' additional paternity Birth');
2199:
2200: else
2201: hr_utility.trace('ASPP Birth element entries already updated for new tax year');
2202: end if;
2203: --
2204: commit;
2205: --

Line 2208: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');

2204: commit;
2205: --
2206: exception
2207: when e_asppb_rate_not_set then
2208: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
2209: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
2210: when e_no_new_asppb_entry then
2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');

Line 2209: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');

2205: --
2206: exception
2207: when e_asppb_rate_not_set then
2208: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
2209: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
2210: when e_no_new_asppb_entry then
2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');

2207: when e_asppb_rate_not_set then
2208: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
2209: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
2210: when e_no_new_asppb_entry then
2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2214: when others then
2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');

Line 2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');

2208: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
2209: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
2210: when e_no_new_asppb_entry then
2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2214: when others then
2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
2216: hr_utility.trace('SQL error number: '||SQLCODE);

Line 2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

2209: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
2210: when e_no_new_asppb_entry then
2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2214: when others then
2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
2216: hr_utility.trace('SQL error number: '||SQLCODE);
2217: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');

2211: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2214: when others then
2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
2216: hr_utility.trace('SQL error number: '||SQLCODE);
2217: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2218: rollback to pre_asppb_update_status;
2219: l_update_error := true;

Line 2216: hr_utility.trace('SQL error number: '||SQLCODE);

2212: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2214: when others then
2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
2216: hr_utility.trace('SQL error number: '||SQLCODE);
2217: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2218: rollback to pre_asppb_update_status;
2219: l_update_error := true;
2220: end;

Line 2217: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2213: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
2214: when others then
2215: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
2216: hr_utility.trace('SQL error number: '||SQLCODE);
2217: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2218: rollback to pre_asppb_update_status;
2219: l_update_error := true;
2220: end;
2221:

Line 2224: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption,SPP Birth, ASPP Birth and ASPP Adoption entries complete');

2220: end;
2221:
2222:
2223: /*End of Bug 13400812*/
2224: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption,SPP Birth, ASPP Birth and ASPP Adoption entries complete');
2225:
2226: p_update_error := l_update_error;
2227:
2228: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');

Line 2228: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');

2224: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption,SPP Birth, ASPP Birth and ASPP Adoption entries complete');
2225:
2226: p_update_error := l_update_error;
2227:
2228: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');
2229:
2230:
2231: exception
2232:

Line 2236: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');

2232:
2233:
2234: when others
2235: then
2236: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');
2237: hr_utility.trace('SQL error number: '||SQLCODE);
2238: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2239: rollback to pre_update_status;
2240: p_update_error := true;

Line 2237: hr_utility.trace('SQL error number: '||SQLCODE);

2233:
2234: when others
2235: then
2236: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');
2237: hr_utility.trace('SQL error number: '||SQLCODE);
2238: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2239: rollback to pre_update_status;
2240: p_update_error := true;
2241:

Line 2238: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

2234: when others
2235: then
2236: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');
2237: hr_utility.trace('SQL error number: '||SQLCODE);
2238: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
2239: rollback to pre_update_status;
2240: p_update_error := true;
2241:
2242:

Line 2467: hr_utility.trace('Entering ssp_entries_already_updated function');

2463:
2464:
2465: begin
2466:
2467: hr_utility.trace('Entering ssp_entries_already_updated function');
2468:
2469: /* Find SSP rate for new tax year */
2470: open csr_new_ssp_rate;
2471: fetch csr_new_ssp_rate into l_new_SSP_rate;

Line 2483: hr_utility.trace('New SSP rate: '||l_new_SSP_rate);

2479: end if;
2480:
2481: close csr_new_ssp_rate;
2482:
2483: hr_utility.trace('New SSP rate: '||l_new_SSP_rate);
2484:
2485: /* Find first element entry value holding SSP rate for new tax year */
2486: open csr_first_new_ssp_entry;
2487: fetch csr_first_new_ssp_entry into l_first_SSP_entry_rate;

Line 2499: hr_utility.trace('First SSP entry rate: '||l_first_SSP_entry_rate);

2495: end if;
2496:
2497: close csr_first_new_ssp_entry;
2498:
2499: hr_utility.trace('First SSP entry rate: '||l_first_SSP_entry_rate);
2500:
2501: if l_new_SSP_rate = l_first_SSP_entry_rate
2502: then
2503:

Line 2610: hr_utility.trace('Entering smp_rate_changed function');

2606: l_old_std_smp_rate number;
2607:
2608: begin
2609:
2610: hr_utility.trace('Entering smp_rate_changed function');
2611: --
2612: /* Find SMP rate for new tax year */
2613: open csr_new_smp_rate;
2614: fetch csr_new_smp_rate into l_new_SMP_rate, l_new_high_smp_rate, l_new_std_smp_rate;

Line 2626: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);

2622: end if;
2623: --
2624: close csr_new_smp_rate;
2625: --
2626: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
2627: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
2628: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
2629: --
2630: /* Find SMP rate for current tax year */

Line 2627: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);

2623: --
2624: close csr_new_smp_rate;
2625: --
2626: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
2627: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
2628: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
2629: --
2630: /* Find SMP rate for current tax year */
2631: open csr_old_smp_rate;

Line 2628: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);

2624: close csr_new_smp_rate;
2625: --
2626: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
2627: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
2628: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
2629: --
2630: /* Find SMP rate for current tax year */
2631: open csr_old_smp_rate;
2632: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;

Line 2635: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);

2631: open csr_old_smp_rate;
2632: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;
2633: close csr_old_smp_rate;
2634: --
2635: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
2636: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
2637: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
2638: --
2639: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)

Line 2636: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);

2632: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;
2633: close csr_old_smp_rate;
2634: --
2635: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
2636: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
2637: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
2638: --
2639: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
2640: then

Line 2637: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);

2633: close csr_old_smp_rate;
2634: --
2635: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
2636: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
2637: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
2638: --
2639: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
2640: then
2641: return false;

Line 2732: hr_utility.trace('Entering sap_rate_changed function');

2728: l_old_std_sap_rate number;
2729: --
2730: begin
2731: --
2732: hr_utility.trace('Entering sap_rate_changed function');
2733: --
2734: /* Find sap rate for new tax year */
2735: open csr_new_sap_rate;
2736: fetch csr_new_sap_rate into l_new_sap_rate, l_new_std_sap_rate;

Line 2747: hr_utility.trace('New sap rate: '||l_new_sap_rate);

2743: end if;
2744: --
2745: close csr_new_sap_rate;
2746: --
2747: hr_utility.trace('New sap rate: '||l_new_sap_rate);
2748: hr_utility.trace('New std sap rate: '||l_new_std_sap_rate);
2749: --
2750: /* Find sap rate for current tax year */
2751: open csr_old_sap_rate;

Line 2748: hr_utility.trace('New std sap rate: '||l_new_std_sap_rate);

2744: --
2745: close csr_new_sap_rate;
2746: --
2747: hr_utility.trace('New sap rate: '||l_new_sap_rate);
2748: hr_utility.trace('New std sap rate: '||l_new_std_sap_rate);
2749: --
2750: /* Find sap rate for current tax year */
2751: open csr_old_sap_rate;
2752: fetch csr_old_sap_rate into l_old_sap_rate, l_old_std_sap_rate;

Line 2755: hr_utility.trace('Old sap rate: '||l_old_sap_rate);

2751: open csr_old_sap_rate;
2752: fetch csr_old_sap_rate into l_old_sap_rate, l_old_std_sap_rate;
2753: close csr_old_sap_rate;
2754: --
2755: hr_utility.trace('Old sap rate: '||l_old_sap_rate);
2756: hr_utility.trace('Old std sap rate: '||l_old_std_sap_rate);
2757: --
2758: if (l_new_sap_rate = l_old_sap_rate) and (l_new_std_sap_rate = l_old_std_sap_rate) then
2759: return false;

Line 2756: hr_utility.trace('Old std sap rate: '||l_old_std_sap_rate);

2752: fetch csr_old_sap_rate into l_old_sap_rate, l_old_std_sap_rate;
2753: close csr_old_sap_rate;
2754: --
2755: hr_utility.trace('Old sap rate: '||l_old_sap_rate);
2756: hr_utility.trace('Old std sap rate: '||l_old_std_sap_rate);
2757: --
2758: if (l_new_sap_rate = l_old_sap_rate) and (l_new_std_sap_rate = l_old_std_sap_rate) then
2759: return false;
2760: else

Line 2848: hr_utility.trace('Entering sppa_rate_changed function');

2844: l_old_std_sppa_rate number;
2845: --
2846: begin
2847: --
2848: hr_utility.trace('Entering sppa_rate_changed function');
2849: --
2850: /* Find sppa rate for new tax year */
2851: open csr_new_sppa_rate;
2852: fetch csr_new_sppa_rate into l_new_sppa_rate, l_new_std_sppa_rate;

Line 2863: hr_utility.trace('New sppa rate: '||l_new_sppa_rate);

2859: end if;
2860: --
2861: close csr_new_sppa_rate;
2862: --
2863: hr_utility.trace('New sppa rate: '||l_new_sppa_rate);
2864: hr_utility.trace('New std sppa rate: '||l_new_std_sppa_rate);
2865: --
2866: open csr_old_sppa_rate;
2867: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;

Line 2864: hr_utility.trace('New std sppa rate: '||l_new_std_sppa_rate);

2860: --
2861: close csr_new_sppa_rate;
2862: --
2863: hr_utility.trace('New sppa rate: '||l_new_sppa_rate);
2864: hr_utility.trace('New std sppa rate: '||l_new_std_sppa_rate);
2865: --
2866: open csr_old_sppa_rate;
2867: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;
2868: close csr_old_sppa_rate;

Line 2870: hr_utility.trace('Old SPPA rate: '||l_old_sppa_rate);

2866: open csr_old_sppa_rate;
2867: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;
2868: close csr_old_sppa_rate;
2869: --
2870: hr_utility.trace('Old SPPA rate: '||l_old_sppa_rate);
2871: hr_utility.trace('Old Std SPPA rate: '||l_old_std_sppa_rate);
2872: --
2873: if (l_new_sppa_rate = l_old_sppa_rate) and (l_new_std_sppa_rate = l_old_std_sppa_rate) then
2874: return false;

Line 2871: hr_utility.trace('Old Std SPPA rate: '||l_old_std_sppa_rate);

2867: fetch csr_old_sppa_rate into l_old_sppa_rate, l_old_std_sppa_rate;
2868: close csr_old_sppa_rate;
2869: --
2870: hr_utility.trace('Old SPPA rate: '||l_old_sppa_rate);
2871: hr_utility.trace('Old Std SPPA rate: '||l_old_std_sppa_rate);
2872: --
2873: if (l_new_sppa_rate = l_old_sppa_rate) and (l_new_std_sppa_rate = l_old_std_sppa_rate) then
2874: return false;
2875: else

Line 2962: hr_utility.trace('Entering sppb_rate_changed function');

2958: l_old_std_sppb_rate number;
2959: --
2960: begin
2961: --
2962: hr_utility.trace('Entering sppb_rate_changed function');
2963: --
2964: /* Find SPPB rate for new tax year */
2965: open csr_new_sppb_rate;
2966: fetch csr_new_sppb_rate into l_new_sppb_rate, l_new_std_sppb_rate;

Line 2977: hr_utility.trace('New SPPB rate: '||l_new_sppb_rate);

2973: end if;
2974: --
2975: close csr_new_sppb_rate;
2976: --
2977: hr_utility.trace('New SPPB rate: '||l_new_sppb_rate);
2978: hr_utility.trace('New Std SPPB rate: '||l_new_Std_sppb_rate);
2979: --
2980: open csr_old_sppb_rate;
2981: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;

Line 2978: hr_utility.trace('New Std SPPB rate: '||l_new_Std_sppb_rate);

2974: --
2975: close csr_new_sppb_rate;
2976: --
2977: hr_utility.trace('New SPPB rate: '||l_new_sppb_rate);
2978: hr_utility.trace('New Std SPPB rate: '||l_new_Std_sppb_rate);
2979: --
2980: open csr_old_sppb_rate;
2981: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;
2982: close csr_old_sppb_rate;

Line 2984: hr_utility.trace('old SPPB rate: '||l_old_sppb_rate);

2980: open csr_old_sppb_rate;
2981: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;
2982: close csr_old_sppb_rate;
2983: --
2984: hr_utility.trace('old SPPB rate: '||l_old_sppb_rate);
2985: hr_utility.trace('old Std SPPB rate: '||l_old_Std_sppb_rate);
2986: --
2987: if (l_new_sppb_rate = l_old_sppb_rate) and (l_new_std_sppb_rate = l_old_std_sppb_rate) then
2988: return false;

Line 2985: hr_utility.trace('old Std SPPB rate: '||l_old_Std_sppb_rate);

2981: fetch csr_old_sppb_rate into l_old_sppb_rate, l_old_std_sppb_rate;
2982: close csr_old_sppb_rate;
2983: --
2984: hr_utility.trace('old SPPB rate: '||l_old_sppb_rate);
2985: hr_utility.trace('old Std SPPB rate: '||l_old_Std_sppb_rate);
2986: --
2987: if (l_new_sppb_rate = l_old_sppb_rate) and (l_new_std_sppb_rate = l_old_std_sppb_rate) then
2988: return false;
2989: else

Line 3026: hr_utility.trace('Entering asppb_rate_changed function');

3022: l_old_std_asppb_rate number;
3023: --
3024: begin
3025: --
3026: hr_utility.trace('Entering asppb_rate_changed function');
3027: --
3028: /* Find ASPPB rate for new tax year */
3029: open csr_new_asppb_rate;
3030: fetch csr_new_asppb_rate into l_old_asppb_rate, l_new_std_asppb_rate;

Line 3041: hr_utility.trace('New ASPPB rate: '||l_new_asppb_rate);

3037: end if;
3038: --
3039: close csr_new_asppb_rate;
3040: --
3041: hr_utility.trace('New ASPPB rate: '||l_new_asppb_rate);
3042: hr_utility.trace('New Std ASPPB rate: '||l_new_std_asppb_rate);
3043: --
3044: open csr_old_asppb_rate;
3045: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;

Line 3042: hr_utility.trace('New Std ASPPB rate: '||l_new_std_asppb_rate);

3038: --
3039: close csr_new_asppb_rate;
3040: --
3041: hr_utility.trace('New ASPPB rate: '||l_new_asppb_rate);
3042: hr_utility.trace('New Std ASPPB rate: '||l_new_std_asppb_rate);
3043: --
3044: open csr_old_asppb_rate;
3045: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;
3046: close csr_old_asppb_rate;

Line 3048: hr_utility.trace('old ASPPB rate: '||l_old_asppb_rate);

3044: open csr_old_asppb_rate;
3045: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;
3046: close csr_old_asppb_rate;
3047: --
3048: hr_utility.trace('old ASPPB rate: '||l_old_asppb_rate);
3049: hr_utility.trace('old Std ASPPB rate: '||l_old_std_asppb_rate);
3050: --
3051: if (l_new_asppb_rate= l_old_asppb_rate) and (l_new_std_asppb_rate = l_old_std_asppb_rate) then
3052: return false;

Line 3049: hr_utility.trace('old Std ASPPB rate: '||l_old_std_asppb_rate);

3045: fetch csr_old_asppb_rate into l_old_asppb_rate, l_old_std_asppb_rate;
3046: close csr_old_asppb_rate;
3047: --
3048: hr_utility.trace('old ASPPB rate: '||l_old_asppb_rate);
3049: hr_utility.trace('old Std ASPPB rate: '||l_old_std_asppb_rate);
3050: --
3051: if (l_new_asppb_rate= l_old_asppb_rate) and (l_new_std_asppb_rate = l_old_std_asppb_rate) then
3052: return false;
3053: else

Line 3087: hr_utility.trace('Entering asppb_rate_changed function');

3083: l_old_std_asppa_rate number;
3084: --
3085: begin
3086: --
3087: hr_utility.trace('Entering asppb_rate_changed function');
3088: --
3089: /* Find SPPB rate for new tax year */
3090: open csr_new_asppa_rate;
3091: fetch csr_new_asppa_rate into l_old_asppa_rate, l_new_std_asppa_rate;

Line 3102: hr_utility.trace('New ASPPA rate: '||l_new_asppa_rate);

3098: end if;
3099: --
3100: close csr_new_asppa_rate;
3101: --
3102: hr_utility.trace('New ASPPA rate: '||l_new_asppa_rate);
3103: hr_utility.trace('New Std ASPPA rate: '||l_new_std_asppa_rate);
3104: --
3105: open csr_old_asppa_rate;
3106: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;

Line 3103: hr_utility.trace('New Std ASPPA rate: '||l_new_std_asppa_rate);

3099: --
3100: close csr_new_asppa_rate;
3101: --
3102: hr_utility.trace('New ASPPA rate: '||l_new_asppa_rate);
3103: hr_utility.trace('New Std ASPPA rate: '||l_new_std_asppa_rate);
3104: --
3105: open csr_old_asppa_rate;
3106: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;
3107: close csr_old_asppa_rate;

Line 3109: hr_utility.trace('old ASPPA rate: '||l_old_asppa_rate);

3105: open csr_old_asppa_rate;
3106: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;
3107: close csr_old_asppa_rate;
3108: --
3109: hr_utility.trace('old ASPPA rate: '||l_old_asppa_rate);
3110: hr_utility.trace('old Std ASPPA rate: '||l_old_std_asppa_rate);
3111: --
3112: if (l_new_asppa_rate= l_old_asppa_rate) and (l_new_std_asppa_rate = l_old_std_asppa_rate) then
3113: return false;

Line 3110: hr_utility.trace('old Std ASPPA rate: '||l_old_std_asppa_rate);

3106: fetch csr_old_asppa_rate into l_old_asppa_rate, l_old_std_asppa_rate;
3107: close csr_old_asppa_rate;
3108: --
3109: hr_utility.trace('old ASPPA rate: '||l_old_asppa_rate);
3110: hr_utility.trace('old Std ASPPA rate: '||l_old_std_asppa_rate);
3111: --
3112: if (l_new_asppa_rate= l_old_asppa_rate) and (l_new_std_asppa_rate = l_old_std_asppa_rate) then
3113: return false;
3114: else

Line 3128: hr_utility.trace('Entering: '||g_package||'.update_ssp_smp_entries');

3124:
3125: /* Main program body */
3126: begin
3127:
3128: hr_utility.trace('Entering: '||g_package||'.update_ssp_smp_entries');
3129:
3130: savepoint pre_update_status;
3131: /* Check first whether SSP element entries already updated for new tax year */
3132: /* SSP update block */

Line 3140: hr_utility.trace('SSP element entries not updated, updating ....');

3136:
3137: if not ssp_entries_already_updated
3138: then
3139:
3140: hr_utility.trace('SSP element entries not updated, updating ....');
3141:
3142: for r_affected_absences in csr_affected_absences loop
3143:
3144: /* SSP control call block */

Line 3147: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);

3143:
3144: /* SSP control call block */
3145: begin
3146:
3147: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
3148: --6800788 begin
3149: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
3150: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
3151: l_count := l_count + 1;

Line 3162: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);

3158: --6800788 end
3159: exception
3160:
3161: when others then
3162: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
3163: hr_utility.trace('SQL error code: '||SQLCODE);
3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);
3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);

Line 3163: hr_utility.trace('SQL error code: '||SQLCODE);

3159: exception
3160:
3161: when others then
3162: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
3163: hr_utility.trace('SQL error code: '||SQLCODE);
3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);
3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
3167: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);

Line 3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3160:
3161: when others then
3162: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
3163: hr_utility.trace('SQL error code: '||SQLCODE);
3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);
3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
3167: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
3168: l_update_error := true;

Line 3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);

3161: when others then
3162: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
3163: hr_utility.trace('SQL error code: '||SQLCODE);
3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);
3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
3167: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
3168: l_update_error := true;
3169:

Line 3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);

3162: hr_utility.trace('Error occurred while processing SSP absence: '||r_affected_absences.absence_id);
3163: hr_utility.trace('SQL error code: '||SQLCODE);
3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);
3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
3167: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
3168: l_update_error := true;
3169:
3170: end;

Line 3167: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);

3163: hr_utility.trace('SQL error code: '||SQLCODE);
3164: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3165: hr_utility.trace('Person id: '||r_affected_absences.person_id);
3166: hr_utility.trace('Absence start date: '||r_affected_absences.absence_start_date);
3167: hr_utility.trace('Absence end date: '||r_affected_absences.absence_end_date);
3168: l_update_error := true;
3169:
3170: end;
3171:

Line 3176: hr_utility.trace('Updated entries for '||l_count||' absences');

3172:
3173:
3174: end loop;
3175:
3176: hr_utility.trace('Updated entries for '||l_count||' absences');
3177: -- dbms_output.put_line(' Total SSP absences ='|| l_count);
3178: else
3179:
3180: hr_utility.trace('SSP element entries already updated for new tax year');

Line 3180: hr_utility.trace('SSP element entries already updated for new tax year');

3176: hr_utility.trace('Updated entries for '||l_count||' absences');
3177: -- dbms_output.put_line(' Total SSP absences ='|| l_count);
3178: else
3179:
3180: hr_utility.trace('SSP element entries already updated for new tax year');
3181:
3182: end if;
3183:
3184: commit;

Line 3190: hr_utility.trace('Warning: SSP rate for new tax year not set');

3186: exception
3187:
3188: when e_ssp_rate_not_set
3189: then
3190: hr_utility.trace('Warning: SSP rate for new tax year not set');
3191: hr_utility.trace('Unable to proceed with updating SSP entries');
3192:
3193:
3194: when e_no_new_ssp_entry

Line 3191: hr_utility.trace('Unable to proceed with updating SSP entries');

3187:
3188: when e_ssp_rate_not_set
3189: then
3190: hr_utility.trace('Warning: SSP rate for new tax year not set');
3191: hr_utility.trace('Unable to proceed with updating SSP entries');
3192:
3193:
3194: when e_no_new_ssp_entry
3195: then

Line 3196: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');

3192:
3193:
3194: when e_no_new_ssp_entry
3195: then
3196: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');
3197: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');
3198: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
3199:
3200: when others

Line 3197: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');

3193:
3194: when e_no_new_ssp_entry
3195: then
3196: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');
3197: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');
3198: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
3199:
3200: when others
3201: then

Line 3198: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');

3194: when e_no_new_ssp_entry
3195: then
3196: hr_utility.trace('Warning: Unable to locate SSP entry in new tax year');
3197: hr_utility.trace('Entries for SSP absences in new tax year may be non-existent');
3198: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
3199:
3200: when others
3201: then
3202: hr_utility.trace('Unexpected error occurred inside SSP update block');

Line 3202: hr_utility.trace('Unexpected error occurred inside SSP update block');

3198: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end dates of absences');
3199:
3200: when others
3201: then
3202: hr_utility.trace('Unexpected error occurred inside SSP update block');
3203: hr_utility.trace('SQL error number: '||SQLCODE);
3204: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3205: rollback to pre_ssp_update_status;
3206: l_update_error := true;

Line 3203: hr_utility.trace('SQL error number: '||SQLCODE);

3199:
3200: when others
3201: then
3202: hr_utility.trace('Unexpected error occurred inside SSP update block');
3203: hr_utility.trace('SQL error number: '||SQLCODE);
3204: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3205: rollback to pre_ssp_update_status;
3206: l_update_error := true;
3207:

Line 3204: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3200: when others
3201: then
3202: hr_utility.trace('Unexpected error occurred inside SSP update block');
3203: hr_utility.trace('SQL error number: '||SQLCODE);
3204: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3205: rollback to pre_ssp_update_status;
3206: l_update_error := true;
3207:
3208: end; /* SSP update block */

Line 3219: hr_utility.trace('SMP element entries updating ....');

3215: savepoint pre_smp_update_status;
3216: --
3217: if smp_rate_changed then
3218: --
3219: hr_utility.trace('SMP element entries updating ....');
3220: for r_affected_maternities in csr_affected_leave('MA') loop
3221: /* SMP Control call block */
3222: begin
3223: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);

Line 3223: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);

3219: hr_utility.trace('SMP element entries updating ....');
3220: for r_affected_maternities in csr_affected_leave('MA') loop
3221: /* SMP Control call block */
3222: begin
3223: hr_utility.trace('Processing SMP absence: '||r_affected_maternities.maternity_id);
3224: --6800788 begin
3225: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
3226: -- p_deleting => FALSE);
3227:

Line 3241: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);

3237: --6800788 end
3238:
3239: exception
3240: when others then
3241: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
3242: hr_utility.trace('SQL error code: '||SQLCODE);
3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);

Line 3242: hr_utility.trace('SQL error code: '||SQLCODE);

3238:
3239: exception
3240: when others then
3241: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
3242: hr_utility.trace('SQL error code: '||SQLCODE);
3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);

Line 3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3239: exception
3240: when others then
3241: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
3242: hr_utility.trace('SQL error code: '||SQLCODE);
3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);

Line 3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);

3240: when others then
3241: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
3242: hr_utility.trace('SQL error code: '||SQLCODE);
3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);

Line 3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);

3241: hr_utility.trace('Error occurred while processing SMP absence: '||r_affected_maternities.maternity_id);
3242: hr_utility.trace('SQL error code: '||SQLCODE);
3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
3249: l_update_error := true;

Line 3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);

3242: hr_utility.trace('SQL error code: '||SQLCODE);
3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
3249: l_update_error := true;
3250: end;

Line 3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);

3243: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
3249: l_update_error := true;
3250: end;
3251: end loop;

Line 3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);

3244: hr_utility.trace('Person id: '||r_affected_maternities.person_id);
3245: hr_utility.trace('Maternity start date: '||r_affected_maternities.date_start);
3246: hr_utility.trace('Maternity end date: '||r_affected_maternities.date_end);
3247: hr_utility.trace('Maternity projected start date: '||r_affected_maternities.date_projected_start);
3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
3249: l_update_error := true;
3250: end;
3251: end loop;
3252: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');

Line 3252: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');

3248: hr_utility.trace('Maternity projected end date: '||r_affected_maternities.date_projected_end);
3249: l_update_error := true;
3250: end;
3251: end loop;
3252: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');
3253: -- dbms_output.put_line(' Total SMP absences ='|| l_mat_count);
3254: else
3255: hr_utility.trace('SMP element entries already updated for new tax year');
3256: end if;

Line 3255: hr_utility.trace('SMP element entries already updated for new tax year');

3251: end loop;
3252: hr_utility.trace('Updated entries for '||l_mat_count||' maternities');
3253: -- dbms_output.put_line(' Total SMP absences ='|| l_mat_count);
3254: else
3255: hr_utility.trace('SMP element entries already updated for new tax year');
3256: end if;
3257: --
3258: commit;
3259: --

Line 3262: hr_utility.trace('Warning: SMP rate for new tax year not set');

3258: commit;
3259: --
3260: exception
3261: when e_smp_rate_not_set then
3262: hr_utility.trace('Warning: SMP rate for new tax year not set');
3263: hr_utility.trace('Unable to proceed with updating SMP entries');
3264: when e_no_new_smp_entry then
3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');

Line 3263: hr_utility.trace('Unable to proceed with updating SMP entries');

3259: --
3260: exception
3261: when e_smp_rate_not_set then
3262: hr_utility.trace('Warning: SMP rate for new tax year not set');
3263: hr_utility.trace('Unable to proceed with updating SMP entries');
3264: when e_no_new_smp_entry then
3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');

3261: when e_smp_rate_not_set then
3262: hr_utility.trace('Warning: SMP rate for new tax year not set');
3263: hr_utility.trace('Unable to proceed with updating SMP entries');
3264: when e_no_new_smp_entry then
3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3268: when others then
3269: hr_utility.trace('Unexpected error occurred inside SMP update block');

Line 3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');

3262: hr_utility.trace('Warning: SMP rate for new tax year not set');
3263: hr_utility.trace('Unable to proceed with updating SMP entries');
3264: when e_no_new_smp_entry then
3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3268: when others then
3269: hr_utility.trace('Unexpected error occurred inside SMP update block');
3270: hr_utility.trace('SQL error number: '||SQLCODE);

Line 3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

3263: hr_utility.trace('Unable to proceed with updating SMP entries');
3264: when e_no_new_smp_entry then
3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3268: when others then
3269: hr_utility.trace('Unexpected error occurred inside SMP update block');
3270: hr_utility.trace('SQL error number: '||SQLCODE);
3271: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 3269: hr_utility.trace('Unexpected error occurred inside SMP update block');

3265: hr_utility.trace('Warning: Unable to locate SMP entry in new tax year');
3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3268: when others then
3269: hr_utility.trace('Unexpected error occurred inside SMP update block');
3270: hr_utility.trace('SQL error number: '||SQLCODE);
3271: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3272: rollback to pre_smp_update_status;
3273: l_update_error := true;

Line 3270: hr_utility.trace('SQL error number: '||SQLCODE);

3266: hr_utility.trace('Entries for SMP absences in new tax year may be non-existent');
3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3268: when others then
3269: hr_utility.trace('Unexpected error occurred inside SMP update block');
3270: hr_utility.trace('SQL error number: '||SQLCODE);
3271: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3272: rollback to pre_smp_update_status;
3273: l_update_error := true;
3274: end; /* SMP update block */

Line 3271: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3267: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3268: when others then
3269: hr_utility.trace('Unexpected error occurred inside SMP update block');
3270: hr_utility.trace('SQL error number: '||SQLCODE);
3271: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3272: rollback to pre_smp_update_status;
3273: l_update_error := true;
3274: end; /* SMP update block */
3275: -- 05/12/2003 rmakhija: Uncommented section ends here

Line 3284: hr_utility.trace('SAP element entries updating ....');

3280: savepoint pre_sap_update_status;
3281: --
3282: if sap_rate_changed then
3283: --
3284: hr_utility.trace('SAP element entries updating ....');
3285: for r_affected_adoption in csr_affected_leave('AD') loop
3286: /* SAP Control call block */
3287: begin
3288: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);

Line 3288: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);

3284: hr_utility.trace('SAP element entries updating ....');
3285: for r_affected_adoption in csr_affected_leave('AD') loop
3286: /* SAP Control call block */
3287: begin
3288: hr_utility.trace('Processing SAP absence: '||r_affected_adoption.maternity_id);
3289: --6800788 begin
3290: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
3291: -- p_deleting => FALSE);
3292:

Line 3306: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);

3302: --6800788 end
3303:
3304: exception
3305: when others then
3306: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
3307: hr_utility.trace('SQL error code: '||SQLCODE);
3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);

Line 3307: hr_utility.trace('SQL error code: '||SQLCODE);

3303:
3304: exception
3305: when others then
3306: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
3307: hr_utility.trace('SQL error code: '||SQLCODE);
3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);

Line 3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3304: exception
3305: when others then
3306: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
3307: hr_utility.trace('SQL error code: '||SQLCODE);
3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);

Line 3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);

3305: when others then
3306: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
3307: hr_utility.trace('SQL error code: '||SQLCODE);
3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);

Line 3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);

3306: hr_utility.trace('Error occurred while processing SAP absence: '||r_affected_adoption.maternity_id);
3307: hr_utility.trace('SQL error code: '||SQLCODE);
3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
3314: l_update_error := true;

Line 3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);

3307: hr_utility.trace('SQL error code: '||SQLCODE);
3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
3314: l_update_error := true;
3315: end;

Line 3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);

3308: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
3314: l_update_error := true;
3315: end;
3316: end loop;

Line 3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);

3309: hr_utility.trace('Person id: '||r_affected_adoption.person_id);
3310: hr_utility.trace('Adoption start date: '||r_affected_adoption.date_start);
3311: hr_utility.trace('Adoption end date: '||r_affected_adoption.date_end);
3312: hr_utility.trace('Adoption projected start date: '||r_affected_adoption.date_projected_start);
3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
3314: l_update_error := true;
3315: end;
3316: end loop;
3317: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');

Line 3317: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');

3313: hr_utility.trace('Adoption projected end date: '||r_affected_adoption.date_projected_end);
3314: l_update_error := true;
3315: end;
3316: end loop;
3317: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');
3318: -- dbms_output.put_line(' Total SAP absences ='|| l_adop_count);
3319: else
3320: hr_utility.trace('SAP element entries already updated for new tax year');
3321: end if;

Line 3320: hr_utility.trace('SAP element entries already updated for new tax year');

3316: end loop;
3317: hr_utility.trace('Updated entries for '||l_adop_count||' adoptions');
3318: -- dbms_output.put_line(' Total SAP absences ='|| l_adop_count);
3319: else
3320: hr_utility.trace('SAP element entries already updated for new tax year');
3321: end if;
3322: --
3323: commit;
3324: --

Line 3327: hr_utility.trace('Warning: SAP rate for new tax year not set');

3323: commit;
3324: --
3325: exception
3326: when e_sap_rate_not_set then
3327: hr_utility.trace('Warning: SAP rate for new tax year not set');
3328: hr_utility.trace('Unable to proceed with updating SAP entries');
3329: when e_no_new_sap_entry then
3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');

Line 3328: hr_utility.trace('Unable to proceed with updating SAP entries');

3324: --
3325: exception
3326: when e_sap_rate_not_set then
3327: hr_utility.trace('Warning: SAP rate for new tax year not set');
3328: hr_utility.trace('Unable to proceed with updating SAP entries');
3329: when e_no_new_sap_entry then
3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');

3326: when e_sap_rate_not_set then
3327: hr_utility.trace('Warning: SAP rate for new tax year not set');
3328: hr_utility.trace('Unable to proceed with updating SAP entries');
3329: when e_no_new_sap_entry then
3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3333: when others then
3334: hr_utility.trace('Unexpected error occurred inside SAP update block');

Line 3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');

3327: hr_utility.trace('Warning: SAP rate for new tax year not set');
3328: hr_utility.trace('Unable to proceed with updating SAP entries');
3329: when e_no_new_sap_entry then
3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3333: when others then
3334: hr_utility.trace('Unexpected error occurred inside SAP update block');
3335: hr_utility.trace('SQL error number: '||SQLCODE);

Line 3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

3328: hr_utility.trace('Unable to proceed with updating SAP entries');
3329: when e_no_new_sap_entry then
3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3333: when others then
3334: hr_utility.trace('Unexpected error occurred inside SAP update block');
3335: hr_utility.trace('SQL error number: '||SQLCODE);
3336: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 3334: hr_utility.trace('Unexpected error occurred inside SAP update block');

3330: hr_utility.trace('Warning: Unable to locate SAP entry in new tax year');
3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3333: when others then
3334: hr_utility.trace('Unexpected error occurred inside SAP update block');
3335: hr_utility.trace('SQL error number: '||SQLCODE);
3336: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3337: rollback to pre_sap_update_status;
3338: l_update_error := true;

Line 3335: hr_utility.trace('SQL error number: '||SQLCODE);

3331: hr_utility.trace('Entries for SAP absences in new tax year may be non-existent');
3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3333: when others then
3334: hr_utility.trace('Unexpected error occurred inside SAP update block');
3335: hr_utility.trace('SQL error number: '||SQLCODE);
3336: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3337: rollback to pre_sap_update_status;
3338: l_update_error := true;
3339: end; /* SAP update block */

Line 3336: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3332: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3333: when others then
3334: hr_utility.trace('Unexpected error occurred inside SAP update block');
3335: hr_utility.trace('SQL error number: '||SQLCODE);
3336: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3337: rollback to pre_sap_update_status;
3338: l_update_error := true;
3339: end; /* SAP update block */
3340: -- Begin SPP Adoption Update Block

Line 3347: hr_utility.trace('SPP Adoption element entries updating ....');

3343: savepoint pre_sppa_update_status;
3344: --
3345: if sppa_rate_changed then
3346: --
3347: hr_utility.trace('SPP Adoption element entries updating ....');
3348: for r_affected_pat_adop in csr_affected_leave('PA') loop
3349: /* SPP Adoption Control call block */
3350: begin
3351: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);

Line 3351: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);

3347: hr_utility.trace('SPP Adoption element entries updating ....');
3348: for r_affected_pat_adop in csr_affected_leave('PA') loop
3349: /* SPP Adoption Control call block */
3350: begin
3351: hr_utility.trace('Processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3352: --6800788 begin
3353: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
3354: -- p_deleting => FALSE);
3355:

Line 3369: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);

3365: --6800788 end
3366:
3367: exception
3368: when others then
3369: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3370: hr_utility.trace('SQL error code: '||SQLCODE);
3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);

Line 3370: hr_utility.trace('SQL error code: '||SQLCODE);

3366:
3367: exception
3368: when others then
3369: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3370: hr_utility.trace('SQL error code: '||SQLCODE);
3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);

Line 3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3367: exception
3368: when others then
3369: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3370: hr_utility.trace('SQL error code: '||SQLCODE);
3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);

Line 3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);

3368: when others then
3369: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3370: hr_utility.trace('SQL error code: '||SQLCODE);
3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);

Line 3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);

3369: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_pat_adop.maternity_id);
3370: hr_utility.trace('SQL error code: '||SQLCODE);
3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
3377: l_update_error := true;

Line 3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);

3370: hr_utility.trace('SQL error code: '||SQLCODE);
3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
3377: l_update_error := true;
3378: end;

Line 3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);

3371: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
3377: l_update_error := true;
3378: end;
3379: end loop;

Line 3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);

3372: hr_utility.trace('Person id: '||r_affected_pat_adop.person_id);
3373: hr_utility.trace('Paternity Adoption start date: '||r_affected_pat_adop.date_start);
3374: hr_utility.trace('Paternity Adoption end date: '||r_affected_pat_adop.date_end);
3375: hr_utility.trace('Paternity Adoption projected start date: '||r_affected_pat_adop.date_projected_start);
3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
3377: l_update_error := true;
3378: end;
3379: end loop;
3380: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');

Line 3380: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');

3376: hr_utility.trace('Paternity Adoption projected end date: '||r_affected_pat_adop.date_projected_end);
3377: l_update_error := true;
3378: end;
3379: end loop;
3380: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');
3381: -- dbms_output.put_line(' Total SPPA absences ='|| l_pat_adop_count);
3382: else
3383: hr_utility.trace('SPP Adoption element entries already updated for new tax year');
3384: end if;

Line 3383: hr_utility.trace('SPP Adoption element entries already updated for new tax year');

3379: end loop;
3380: hr_utility.trace('Updated entries for '||l_pat_adop_count||' paternity adoptions');
3381: -- dbms_output.put_line(' Total SPPA absences ='|| l_pat_adop_count);
3382: else
3383: hr_utility.trace('SPP Adoption element entries already updated for new tax year');
3384: end if;
3385: --
3386: commit;
3387: --

Line 3390: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');

3386: commit;
3387: --
3388: exception
3389: when e_sppa_rate_not_set then
3390: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
3391: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
3392: when e_no_new_sppa_entry then
3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');

Line 3391: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');

3387: --
3388: exception
3389: when e_sppa_rate_not_set then
3390: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
3391: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
3392: when e_no_new_sppa_entry then
3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');

3389: when e_sppa_rate_not_set then
3390: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
3391: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
3392: when e_no_new_sppa_entry then
3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3396: when others then
3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');

Line 3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');

3390: hr_utility.trace('Warning: SPP ADoption rate for new tax year not set');
3391: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
3392: when e_no_new_sppa_entry then
3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3396: when others then
3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
3398: hr_utility.trace('SQL error number: '||SQLCODE);

Line 3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

3391: hr_utility.trace('Unable to proceed with updating SPP ADoption entries');
3392: when e_no_new_sppa_entry then
3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3396: when others then
3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
3398: hr_utility.trace('SQL error number: '||SQLCODE);
3399: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');

3393: hr_utility.trace('Warning: Unable to locate SPP ADoption entry in new tax year');
3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3396: when others then
3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
3398: hr_utility.trace('SQL error number: '||SQLCODE);
3399: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3400: rollback to pre_sppa_update_status;
3401: l_update_error := true;

Line 3398: hr_utility.trace('SQL error number: '||SQLCODE);

3394: hr_utility.trace('Entries for SPP ADoption absences in new tax year may be non-existent');
3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3396: when others then
3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
3398: hr_utility.trace('SQL error number: '||SQLCODE);
3399: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3400: rollback to pre_sppa_update_status;
3401: l_update_error := true;
3402: end; /* SPP Adoption update block */

Line 3399: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3395: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3396: when others then
3397: hr_utility.trace('Unexpected error occurred inside SPP ADoption update block');
3398: hr_utility.trace('SQL error number: '||SQLCODE);
3399: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3400: rollback to pre_sppa_update_status;
3401: l_update_error := true;
3402: end; /* SPP Adoption update block */
3403: -- Begin SPP Birth Update Block

Line 3410: hr_utility.trace('SPP Birth element entries updating ....');

3406: savepoint pre_sppb_update_status;
3407: --
3408: if sppb_rate_changed then
3409: --
3410: hr_utility.trace('SPP Birth element entries updating ....');
3411: --6800788 begin
3412: -- for r_affected_pat_Birth in csr_affected_leave('PA') loop
3413: for r_affected_pat_Birth in csr_affected_leave('PB') loop
3414: --6800788 end

Line 3417: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);

3413: for r_affected_pat_Birth in csr_affected_leave('PB') loop
3414: --6800788 end
3415: /* SPP Birth Control call block */
3416: begin
3417: hr_utility.trace('Processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3418: --6800788 begin
3419: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
3420: -- p_deleting => FALSE);
3421:

Line 3436: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);

3432:
3433:
3434: exception
3435: when others then
3436: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3437: hr_utility.trace('SQL error code: '||SQLCODE);
3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);

Line 3437: hr_utility.trace('SQL error code: '||SQLCODE);

3433:
3434: exception
3435: when others then
3436: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3437: hr_utility.trace('SQL error code: '||SQLCODE);
3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);

Line 3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3434: exception
3435: when others then
3436: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3437: hr_utility.trace('SQL error code: '||SQLCODE);
3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);

Line 3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);

3435: when others then
3436: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3437: hr_utility.trace('SQL error code: '||SQLCODE);
3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);

Line 3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);

3436: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_pat_Birth.maternity_id);
3437: hr_utility.trace('SQL error code: '||SQLCODE);
3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
3444: l_update_error := true;

Line 3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);

3437: hr_utility.trace('SQL error code: '||SQLCODE);
3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
3444: l_update_error := true;
3445: end;

Line 3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);

3438: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
3444: l_update_error := true;
3445: end;
3446: end loop;

Line 3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);

3439: hr_utility.trace('Person id: '||r_affected_pat_Birth.person_id);
3440: hr_utility.trace('Paternity Birth start date: '||r_affected_pat_Birth.date_start);
3441: hr_utility.trace('Paternity Birth end date: '||r_affected_pat_Birth.date_end);
3442: hr_utility.trace('Paternity Birth projected start date: '||r_affected_pat_Birth.date_projected_start);
3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
3444: l_update_error := true;
3445: end;
3446: end loop;
3447: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');

Line 3447: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');

3443: hr_utility.trace('Paternity Birth projected end date: '||r_affected_pat_Birth.date_projected_end);
3444: l_update_error := true;
3445: end;
3446: end loop;
3447: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');
3448: -- dbms_output.put_line(' Total SPPB absences ='|| l_pat_birth_count);
3449: else
3450: hr_utility.trace('SPP Birth element entries already updated for new tax year');
3451: end if;

Line 3450: hr_utility.trace('SPP Birth element entries already updated for new tax year');

3446: end loop;
3447: hr_utility.trace('Updated entries for '||l_pat_birth_count||' paternity births');
3448: -- dbms_output.put_line(' Total SPPB absences ='|| l_pat_birth_count);
3449: else
3450: hr_utility.trace('SPP Birth element entries already updated for new tax year');
3451: end if;
3452: --
3453: commit;
3454: --

Line 3457: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');

3453: commit;
3454: --
3455: exception
3456: when e_sppb_rate_not_set then
3457: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
3458: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
3459: when e_no_new_sppb_entry then
3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');

Line 3458: hr_utility.trace('Unable to proceed with updating SPP Birth entries');

3454: --
3455: exception
3456: when e_sppb_rate_not_set then
3457: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
3458: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
3459: when e_no_new_sppb_entry then
3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');

3456: when e_sppb_rate_not_set then
3457: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
3458: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
3459: when e_no_new_sppb_entry then
3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3463: when others then
3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');

Line 3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');

3457: hr_utility.trace('Warning: SPP Birth rate for new tax year not set');
3458: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
3459: when e_no_new_sppb_entry then
3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3463: when others then
3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
3465: hr_utility.trace('SQL error number: '||SQLCODE);

Line 3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

3458: hr_utility.trace('Unable to proceed with updating SPP Birth entries');
3459: when e_no_new_sppb_entry then
3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3463: when others then
3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
3465: hr_utility.trace('SQL error number: '||SQLCODE);
3466: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');

3460: hr_utility.trace('Warning: Unable to locate SPP Birth entry in new tax year');
3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3463: when others then
3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
3465: hr_utility.trace('SQL error number: '||SQLCODE);
3466: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3467: rollback to pre_sppb_update_status;
3468: l_update_error := true;

Line 3465: hr_utility.trace('SQL error number: '||SQLCODE);

3461: hr_utility.trace('Entries for SPP Birth absences in new tax year may be non-existent');
3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3463: when others then
3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
3465: hr_utility.trace('SQL error number: '||SQLCODE);
3466: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3467: rollback to pre_sppb_update_status;
3468: l_update_error := true;
3469: end; /* SPP Birth update block */

Line 3466: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3462: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3463: when others then
3464: hr_utility.trace('Unexpected error occurred inside SPP Birth update block');
3465: hr_utility.trace('SQL error number: '||SQLCODE);
3466: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3467: rollback to pre_sppb_update_status;
3468: l_update_error := true;
3469: end; /* SPP Birth update block */
3470:

Line 3480: hr_utility.trace('ASPP Adoption element entries updating ....');

3476: savepoint pre_asppa_update_status;
3477: --
3478: if asppa_rate_changed then
3479: --
3480: hr_utility.trace('ASPP Adoption element entries updating ....');
3481: for r_affected_apat_adop in csr_affected_leave('AA') loop
3482: /* ASPP Adoption Control call block */
3483: begin
3484: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);

Line 3484: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);

3480: hr_utility.trace('ASPP Adoption element entries updating ....');
3481: for r_affected_apat_adop in csr_affected_leave('AA') loop
3482: /* ASPP Adoption Control call block */
3483: begin
3484: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3485:
3486:
3487: DBMS_JOB.SUBMIT(l_job_no,'ssp_apad_pkg.apad_control('||r_affected_apat_adop.maternity_id||',FALSE);');
3488: l_apat_adop_count := l_apat_adop_count + 1;

Line 3499: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_apat_adop.maternity_id);

3495: end if;
3496:
3497: exception
3498: when others then
3499: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3500: hr_utility.trace('SQL error code: '||SQLCODE);
3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);

Line 3500: hr_utility.trace('SQL error code: '||SQLCODE);

3496:
3497: exception
3498: when others then
3499: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3500: hr_utility.trace('SQL error code: '||SQLCODE);
3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);

Line 3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3497: exception
3498: when others then
3499: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3500: hr_utility.trace('SQL error code: '||SQLCODE);
3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);

Line 3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);

3498: when others then
3499: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3500: hr_utility.trace('SQL error code: '||SQLCODE);
3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);

Line 3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);

3499: hr_utility.trace('Error occurred while processing SPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3500: hr_utility.trace('SQL error code: '||SQLCODE);
3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
3507: l_update_error := true;

Line 3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);

3500: hr_utility.trace('SQL error code: '||SQLCODE);
3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
3507: l_update_error := true;
3508: end;

Line 3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);

3501: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
3507: l_update_error := true;
3508: end;
3509: end loop;

Line 3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);

3502: hr_utility.trace('Person id: '||r_affected_apat_adop.person_id);
3503: hr_utility.trace('Additional Paternity Adoption start date: '||r_affected_apat_adop.date_start);
3504: hr_utility.trace('Additional Paternity Adoption end date: '||r_affected_apat_adop.date_end);
3505: hr_utility.trace('Additional Paternity Adoption projected start date: '||r_affected_apat_adop.date_projected_start);
3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
3507: l_update_error := true;
3508: end;
3509: end loop;
3510: hr_utility.trace('Updated entries for '||l_apat_adop_count||' paternity adoptions');

Line 3510: hr_utility.trace('Updated entries for '||l_apat_adop_count||' paternity adoptions');

3506: hr_utility.trace('Additional Paternity Adoption projected end date: '||r_affected_apat_adop.date_projected_end);
3507: l_update_error := true;
3508: end;
3509: end loop;
3510: hr_utility.trace('Updated entries for '||l_apat_adop_count||' paternity adoptions');
3511:
3512: else
3513: hr_utility.trace('ASPP Adoption element entries already updated for new tax year');
3514: end if;

Line 3513: hr_utility.trace('ASPP Adoption element entries already updated for new tax year');

3509: end loop;
3510: hr_utility.trace('Updated entries for '||l_apat_adop_count||' paternity adoptions');
3511:
3512: else
3513: hr_utility.trace('ASPP Adoption element entries already updated for new tax year');
3514: end if;
3515: --
3516: commit;
3517: --

Line 3520: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');

3516: commit;
3517: --
3518: exception
3519: when e_asppa_rate_not_set then
3520: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
3521: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
3522: when e_no_new_asppa_entry then
3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');

Line 3521: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');

3517: --
3518: exception
3519: when e_asppa_rate_not_set then
3520: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
3521: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
3522: when e_no_new_asppa_entry then
3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');

3519: when e_asppa_rate_not_set then
3520: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
3521: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
3522: when e_no_new_asppa_entry then
3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3526: when others then
3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');

Line 3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');

3520: hr_utility.trace('Warning: ASPP ADoption rate for new tax year not set');
3521: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
3522: when e_no_new_asppa_entry then
3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3526: when others then
3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
3528: hr_utility.trace('SQL error number: '||SQLCODE);

Line 3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

3521: hr_utility.trace('Unable to proceed with updating ASPP ADoption entries');
3522: when e_no_new_asppa_entry then
3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3526: when others then
3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
3528: hr_utility.trace('SQL error number: '||SQLCODE);
3529: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');

3523: hr_utility.trace('Warning: Unable to locate ASPP ADoption entry in new tax year');
3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3526: when others then
3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
3528: hr_utility.trace('SQL error number: '||SQLCODE);
3529: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3530: rollback to pre_asppa_update_status;
3531: l_update_error := true;

Line 3528: hr_utility.trace('SQL error number: '||SQLCODE);

3524: hr_utility.trace('Entries for ASPP ADoption absences in new tax year may be non-existent');
3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3526: when others then
3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
3528: hr_utility.trace('SQL error number: '||SQLCODE);
3529: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3530: rollback to pre_asppa_update_status;
3531: l_update_error := true;
3532:

Line 3529: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3525: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3526: when others then
3527: hr_utility.trace('Unexpected error occurred inside ASPP ADoption update block');
3528: hr_utility.trace('SQL error number: '||SQLCODE);
3529: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3530: rollback to pre_asppa_update_status;
3531: l_update_error := true;
3532:
3533: end;

Line 3541: hr_utility.trace('ASPP Birth element entries updating ....');

3537: savepoint pre_asppb_update_status;
3538: --
3539: if asppb_rate_changed then
3540: --
3541: hr_utility.trace('ASPP Birth element entries updating ....');
3542: for r_affected_apat_birth in csr_affected_leave('AB') loop
3543: /* ASPP Adoption Control call block */
3544: begin
3545: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);

Line 3545: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);

3541: hr_utility.trace('ASPP Birth element entries updating ....');
3542: for r_affected_apat_birth in csr_affected_leave('AB') loop
3543: /* ASPP Adoption Control call block */
3544: begin
3545: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
3546:
3547: DBMS_JOB.SUBMIT(l_job_no,'ssp_apab_pkg.apab_control('||r_affected_apat_birth.maternity_id||',FALSE);');
3548: l_apat_birth_count := l_apat_birth_count + 1;
3549: l_count := l_count + 1;

Line 3559: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_apat_birth.maternity_id);

3555: end if;
3556:
3557: exception
3558: when others then
3559: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_apat_birth.maternity_id);
3560: hr_utility.trace('SQL error code: '||SQLCODE);
3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);

Line 3560: hr_utility.trace('SQL error code: '||SQLCODE);

3556:
3557: exception
3558: when others then
3559: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_apat_birth.maternity_id);
3560: hr_utility.trace('SQL error code: '||SQLCODE);
3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);

Line 3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3557: exception
3558: when others then
3559: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_apat_birth.maternity_id);
3560: hr_utility.trace('SQL error code: '||SQLCODE);
3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);

Line 3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);

3558: when others then
3559: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_apat_birth.maternity_id);
3560: hr_utility.trace('SQL error code: '||SQLCODE);
3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);

Line 3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);

3559: hr_utility.trace('Error occurred while processing SPP Birth absence: '||r_affected_apat_birth.maternity_id);
3560: hr_utility.trace('SQL error code: '||SQLCODE);
3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
3567: l_update_error := true;

Line 3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);

3560: hr_utility.trace('SQL error code: '||SQLCODE);
3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
3567: l_update_error := true;
3568: end;

Line 3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);

3561: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
3567: l_update_error := true;
3568: end;
3569: end loop;

Line 3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);

3562: hr_utility.trace('Person id: '||r_affected_apat_birth.person_id);
3563: hr_utility.trace('Additional Paternity Birth start date: '||r_affected_apat_birth.date_start);
3564: hr_utility.trace('Additional Paternity Birth end date: '||r_affected_apat_birth.date_end);
3565: hr_utility.trace('Additional Paternity Birth projected start date: '||r_affected_apat_birth.date_projected_start);
3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
3567: l_update_error := true;
3568: end;
3569: end loop;
3570: hr_utility.trace('Updated entries for '||l_apat_birth_count||' paternity adoptions');

Line 3570: hr_utility.trace('Updated entries for '||l_apat_birth_count||' paternity adoptions');

3566: hr_utility.trace('Additional Paternity Birth projected end date: '||r_affected_apat_birth.date_projected_end);
3567: l_update_error := true;
3568: end;
3569: end loop;
3570: hr_utility.trace('Updated entries for '||l_apat_birth_count||' paternity adoptions');
3571:
3572: else
3573: hr_utility.trace('ASPP Birth element entries already updated for new tax year');
3574: end if;

Line 3573: hr_utility.trace('ASPP Birth element entries already updated for new tax year');

3569: end loop;
3570: hr_utility.trace('Updated entries for '||l_apat_birth_count||' paternity adoptions');
3571:
3572: else
3573: hr_utility.trace('ASPP Birth element entries already updated for new tax year');
3574: end if;
3575: --
3576: commit;
3577: --

Line 3580: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');

3576: commit;
3577: --
3578: exception
3579: when e_asppb_rate_not_set then
3580: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
3581: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
3582: when e_no_new_asppb_entry then
3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');

Line 3581: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');

3577: --
3578: exception
3579: when e_asppb_rate_not_set then
3580: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
3581: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
3582: when e_no_new_asppb_entry then
3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

Line 3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');

3579: when e_asppb_rate_not_set then
3580: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
3581: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
3582: when e_no_new_asppb_entry then
3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3586: when others then
3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');

Line 3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');

3580: hr_utility.trace('Warning: ASPP Birth rate for new tax year not set');
3581: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
3582: when e_no_new_asppb_entry then
3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3586: when others then
3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
3588: hr_utility.trace('SQL error number: '||SQLCODE);

Line 3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');

3581: hr_utility.trace('Unable to proceed with updating ASPP Birth entries');
3582: when e_no_new_asppb_entry then
3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3586: when others then
3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
3588: hr_utility.trace('SQL error number: '||SQLCODE);
3589: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

Line 3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');

3583: hr_utility.trace('Warning: Unable to locate ASPP Birth entry in new tax year');
3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3586: when others then
3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
3588: hr_utility.trace('SQL error number: '||SQLCODE);
3589: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3590: rollback to pre_asppb_update_status;
3591: l_update_error := true;

Line 3588: hr_utility.trace('SQL error number: '||SQLCODE);

3584: hr_utility.trace('Entries for ASPP Birth absences in new tax year may be non-existent');
3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3586: when others then
3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
3588: hr_utility.trace('SQL error number: '||SQLCODE);
3589: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3590: rollback to pre_asppb_update_status;
3591: l_update_error := true;
3592: end;

Line 3589: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3585: hr_utility.trace('Check for stoppages and employee terminations, as well as the start/end date of absences');
3586: when others then
3587: hr_utility.trace('Unexpected error occurred inside ASPP Birth update block');
3588: hr_utility.trace('SQL error number: '||SQLCODE);
3589: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3590: rollback to pre_asppb_update_status;
3591: l_update_error := true;
3592: end;
3593:

Line 3600: hr_utility.trace(' Total Absences to be processed '|| l_count);

3596:
3597: p_update_error := l_update_error;
3598:
3599: --6800788 begin
3600: hr_utility.trace(' Total Absences to be processed '|| l_count);
3601: --DBMS_OUTPUT.PUT_LINE(' Total Absences to be processed '|| l_count);
3602: for I in 1..l_count
3603: loop
3604: loop

Line 3619: hr_utility.trace(' Job '||l_tbl_job(I).job_no||' Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id);

3615: l_fail_count := l_fail_count + 1;
3616: DBMS_JOB.REMOVE(l_tbl_job(I).job_no);
3617: commit;
3618: p_job_err(l_fail_count) := ' Process Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id;
3619: hr_utility.trace(' Job '||l_tbl_job(I).job_no||' Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id);
3620: -- DBMS_OUTPUT.PUT_LINE(' Job '||l_tbl_job(I).job_no||' Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id);
3621: p_update_error := true;
3622: exit;
3623: ELSE

Line 3632: hr_utility.trace('Total Absences failed '||l_fail_count);

3628: exit;
3629: end;
3630: end loop;
3631: end loop;
3632: hr_utility.trace('Total Absences failed '||l_fail_count);
3633: --DBMS_OUTPUT.PUT_LINE('Total Absences failed '||l_fail_count);
3634: --6800788 end
3635: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption and SPP Birth entries complete');
3636: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');

Line 3635: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption and SPP Birth entries complete');

3631: end loop;
3632: hr_utility.trace('Total Absences failed '||l_fail_count);
3633: --DBMS_OUTPUT.PUT_LINE('Total Absences failed '||l_fail_count);
3634: --6800788 end
3635: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption and SPP Birth entries complete');
3636: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');
3637:
3638:
3639: exception

Line 3636: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');

3632: hr_utility.trace('Total Absences failed '||l_fail_count);
3633: --DBMS_OUTPUT.PUT_LINE('Total Absences failed '||l_fail_count);
3634: --6800788 end
3635: hr_utility.trace('Update of SSP, SMP, SAP, SPP Adoption and SPP Birth entries complete');
3636: hr_utility.trace('Leaving: '||g_package||'.update_ssp_smp_entries');
3637:
3638:
3639: exception
3640:

Line 3644: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');

3640:
3641:
3642: when others
3643: then
3644: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');
3645: hr_utility.trace('SQL error number: '||SQLCODE);
3646: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3647: rollback to pre_update_status;
3648: p_update_error := true;

Line 3645: hr_utility.trace('SQL error number: '||SQLCODE);

3641:
3642: when others
3643: then
3644: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');
3645: hr_utility.trace('SQL error number: '||SQLCODE);
3646: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3647: rollback to pre_update_status;
3648: p_update_error := true;
3649:

Line 3646: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));

3642: when others
3643: then
3644: hr_utility.trace('Unexpected error occurred inside SSP/SMP element entries update procedure');
3645: hr_utility.trace('SQL error number: '||SQLCODE);
3646: hr_utility.trace('SQL error message: '||substr(SQLERRM,1,235));
3647: rollback to pre_update_status;
3648: p_update_error := true;
3649:
3650: