388: --
389: -- The cursor unexpectedly returned no rows.
390: --
391: close csr_absence_details;
392: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');
394: fnd_message.set_token ('STEP','1');
395: fnd_message.raise_error;
396: else
389: -- The cursor unexpectedly returned no rows.
390: --
391: close csr_absence_details;
392: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');
394: fnd_message.set_token ('STEP','1');
395: fnd_message.raise_error;
396: else
397: close csr_absence_details;
390: --
391: close csr_absence_details;
392: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');
394: fnd_message.set_token ('STEP','1');
395: fnd_message.raise_error;
396: else
397: close csr_absence_details;
398: end if;
391: close csr_absence_details;
392: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token ('PROCEDURE','ssp_ssp_pkg.get_absence_details');
394: fnd_message.set_token ('STEP','1');
395: fnd_message.raise_error;
396: else
397: close csr_absence_details;
398: end if;
399: --
474: -- elsewhere).
475: --
476: if g_SSP_legislation.element_type_id is null
477: then
478: fnd_message.set_name ('SSP', 'SSP_35077_NO_SSP_ELEMENT');
479: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
480: fnd_message.raise_error;
481: else
482: --
475: --
476: if g_SSP_legislation.element_type_id is null
477: then
478: fnd_message.set_name ('SSP', 'SSP_35077_NO_SSP_ELEMENT');
479: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
480: fnd_message.raise_error;
481: else
482: --
483: -- The element type exists
476: if g_SSP_legislation.element_type_id is null
477: then
478: fnd_message.set_name ('SSP', 'SSP_35077_NO_SSP_ELEMENT');
479: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
480: fnd_message.raise_error;
481: else
482: --
483: -- The element type exists
484: --
493: then
494: --
495: -- One of the input values is missing.
496: --
497: fnd_message.set_name ('SSP','SSP_36071_INCORRECT_INPUT_VALS');
498: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
499: fnd_message.raise_error;
500: end if;
501: --
494: --
495: -- One of the input values is missing.
496: --
497: fnd_message.set_name ('SSP','SSP_36071_INCORRECT_INPUT_VALS');
498: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
499: fnd_message.raise_error;
500: end if;
501: --
502: if (g_SSP_legislation.MAXIMUM_SSP_PERIOD is null
495: -- One of the input values is missing.
496: --
497: fnd_message.set_name ('SSP','SSP_36071_INCORRECT_INPUT_VALS');
498: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
499: fnd_message.raise_error;
500: end if;
501: --
502: if (g_SSP_legislation.MAXIMUM_SSP_PERIOD is null
503: or g_SSP_legislation.MAXIMUM_AGE is null
509: then
510: --
511: -- One of the DDF segments has not been entered.
512: --
513: fnd_message.set_name ('SSP','SSP_36070_MISSING_DDF_SEGMENT');
514: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
515: fnd_message.raise_error;
516: end if;
517: end if;
510: --
511: -- One of the DDF segments has not been entered.
512: --
513: fnd_message.set_name ('SSP','SSP_36070_MISSING_DDF_SEGMENT');
514: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
515: fnd_message.raise_error;
516: end if;
517: end if;
518: --
511: -- One of the DDF segments has not been entered.
512: --
513: fnd_message.set_name ('SSP','SSP_36070_MISSING_DDF_SEGMENT');
514: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
515: fnd_message.raise_error;
516: end if;
517: end if;
518: --
519: */
585: -- However, failing here may prevent more inexplicable errors elsewhere.
586: --
587: if g_SSP_correction.element_type_id is null
588: then
589: fnd_message.set_name ('SSP', 'SSP_35078_NO_SSP_CORR_ELEMENT');
590: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
591: fnd_message.raise_error;
592: else
593: --
586: --
587: if g_SSP_correction.element_type_id is null
588: then
589: fnd_message.set_name ('SSP', 'SSP_35078_NO_SSP_CORR_ELEMENT');
590: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
591: fnd_message.raise_error;
592: else
593: --
594: -- The element type exists
587: if g_SSP_correction.element_type_id is null
588: then
589: fnd_message.set_name ('SSP', 'SSP_35078_NO_SSP_CORR_ELEMENT');
590: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
591: fnd_message.raise_error;
592: else
593: --
594: -- The element type exists
595: --
604: then
605: --
606: -- One of the input values is missing.
607: --
608: fnd_message.set_name ('SSP','SSP_36071_INCORRECT_INPUT_VALS');
609: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
610: fnd_message.raise_error;
611: end if;
612: --
605: --
606: -- One of the input values is missing.
607: --
608: fnd_message.set_name ('SSP','SSP_36071_INCORRECT_INPUT_VALS');
609: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
610: fnd_message.raise_error;
611: end if;
612: --
613: if (g_SSP_correction.MAXIMUM_SSP_PERIOD is null
606: -- One of the input values is missing.
607: --
608: fnd_message.set_name ('SSP','SSP_36071_INCORRECT_INPUT_VALS');
609: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
610: fnd_message.raise_error;
611: end if;
612: --
613: if (g_SSP_correction.MAXIMUM_SSP_PERIOD is null
614: or g_SSP_correction.MAXIMUM_AGE is null
620: then
621: --
622: -- One of the DDF segments has not been entered.
623: --
624: fnd_message.set_name ('SSP','SSP_36070_MISSING_DDF_SEGMENT');
625: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
626: fnd_message.raise_error;
627: end if;
628: end if;
621: --
622: -- One of the DDF segments has not been entered.
623: --
624: fnd_message.set_name ('SSP','SSP_36070_MISSING_DDF_SEGMENT');
625: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
626: fnd_message.raise_error;
627: end if;
628: end if;
629: --
622: -- One of the DDF segments has not been entered.
623: --
624: fnd_message.set_name ('SSP','SSP_36070_MISSING_DDF_SEGMENT');
625: fnd_message.set_token ('ELEMENT_NAME',c_SSP_element_name);
626: fnd_message.raise_error;
627: end if;
628: end if;
629: --
630: hr_utility.set_location('Leaving :'||l_proc,100);
1116: exception
1117: --
1118: when PIW_broken then
1119: --
1120: fnd_message.set_name ('SSP','SSP_35037_PIW_BROKEN');
1121: fnd_message.raise_error;
1122: --
1123: end check_sickness_date_change;
1124: --------------------------------------------------------------------------------
1117: --
1118: when PIW_broken then
1119: --
1120: fnd_message.set_name ('SSP','SSP_35037_PIW_BROKEN');
1121: fnd_message.raise_error;
1122: --
1123: end check_sickness_date_change;
1124: --------------------------------------------------------------------------------
1125: procedure CHECK_FOR_BREAK_IN_LINKED_PIW
1269: -- get round this, you must first remove all the later sickness absences in
1270: -- the same PIW."
1271: --
1272: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
1273: fnd_message.set_name ('SSP','SSP_35037_PIW_BROKEN');
1274: fnd_message.raise_error;
1275: --
1276: end check_for_break_in_linked_PIW;
1277: --------------------------------------------------------------------------------
1270: -- the same PIW."
1271: --
1272: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
1273: fnd_message.set_name ('SSP','SSP_35037_PIW_BROKEN');
1274: fnd_message.raise_error;
1275: --
1276: end check_for_break_in_linked_PIW;
1277: --------------------------------------------------------------------------------
1278: function get_age_at_PIW(p_person_id in number,
2156: exception
2157: --
2158: when no_SSP_pattern then
2159: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
2160: fnd_message.set_name ('SSP','SSP_35048_NO_SSP_QUAL_PATTERN');
2161: fnd_message.raise_error;
2162: --
2163: end qualifying_days_in_period;
2164: --
2157: --
2158: when no_SSP_pattern then
2159: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
2160: fnd_message.set_name ('SSP','SSP_35048_NO_SSP_QUAL_PATTERN');
2161: fnd_message.raise_error;
2162: --
2163: end qualifying_days_in_period;
2164: --
2165: --------------------------------------------------------------------------------
2594: --
2595: exception
2596: when cannot_get_SSP_rate then
2597: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
2598: fnd_message.set_name ('SSP','SSP_35079_NO_SSP_RATE');
2599: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
2600: fnd_message.raise_error;
2601: end SSP_rate;
2602: --
2595: exception
2596: when cannot_get_SSP_rate then
2597: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
2598: fnd_message.set_name ('SSP','SSP_35079_NO_SSP_RATE');
2599: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
2600: fnd_message.raise_error;
2601: end SSP_rate;
2602: --
2603: /*--------------------------------------------------------------*/
2596: when cannot_get_SSP_rate then
2597: hr_utility.set_location('Leaving :'||l_proc||', Error',999);
2598: fnd_message.set_name ('SSP','SSP_35079_NO_SSP_RATE');
2599: fnd_message.set_token ('EFFECTIVE_DATE',p_effective_date);
2600: fnd_message.raise_error;
2601: end SSP_rate;
2602: --
2603: /*--------------------------------------------------------------*/
2604: /* Calculate number of temporary stoppage days within a period. */
3435: when zero_divide then
3436: --
3437: -- One of the calculations must have gone wrong
3438: --
3439: fnd_message.set_name ('PAY','HR_6153_ALL_PROCEDURE_FAIL');
3440: fnd_message.set_token ('PROCEDURE',l_proc);
3441: fnd_message.set_token ('STEP','1');
3442: fnd_message.raise_error;
3443: --
3436: --
3437: -- One of the calculations must have gone wrong
3438: --
3439: fnd_message.set_name ('PAY','HR_6153_ALL_PROCEDURE_FAIL');
3440: fnd_message.set_token ('PROCEDURE',l_proc);
3441: fnd_message.set_token ('STEP','1');
3442: fnd_message.raise_error;
3443: --
3444: end do_PIW_calculations;
3437: -- One of the calculations must have gone wrong
3438: --
3439: fnd_message.set_name ('PAY','HR_6153_ALL_PROCEDURE_FAIL');
3440: fnd_message.set_token ('PROCEDURE',l_proc);
3441: fnd_message.set_token ('STEP','1');
3442: fnd_message.raise_error;
3443: --
3444: end do_PIW_calculations;
3445: --
3438: --
3439: fnd_message.set_name ('PAY','HR_6153_ALL_PROCEDURE_FAIL');
3440: fnd_message.set_token ('PROCEDURE',l_proc);
3441: fnd_message.set_token ('STEP','1');
3442: fnd_message.raise_error;
3443: --
3444: end do_PIW_calculations;
3445: --
3446: /*-------------------------------------------------------*/