DBA Data[Home] [Help]

APPS.PAY_NO_ABS_VALIDATION dependencies on FND_MESSAGE

Line 276: Fnd_message.set_name('PAY','PAY_376933_NO_ABS_OVERLAP');

272: --
273: -- Raise the error message
274: --
275: hr_utility.set_location (l_proc,15);
276: Fnd_message.set_name('PAY','PAY_376933_NO_ABS_OVERLAP');
277: CLOSE csr_abs_overlap_another;
278: Fnd_message.raise_error;
279: END IF;
280:

Line 278: Fnd_message.raise_error;

274: --
275: hr_utility.set_location (l_proc,15);
276: Fnd_message.set_name('PAY','PAY_376933_NO_ABS_OVERLAP');
277: CLOSE csr_abs_overlap_another;
278: Fnd_message.raise_error;
279: END IF;
280:
281: hr_utility.set_location (l_proc,20);
282: CLOSE csr_abs_overlap_another;

Line 830: fnd_message.set_name('PAY','PAY_376876_NO_MATERNITY_LEAVE');

826: CLOSE csr_get_gender;
827: --Error If gender is Male and apply leave for Maternity or Part Time Maternity
828: IF P_ABS_INFORMATION_CATEGORY IN ('NO_M','NO_PTM') THEN
829: IF l_gender = 'M' then
830: fnd_message.set_name('PAY','PAY_376876_NO_MATERNITY_LEAVE');
831: fnd_message.raise_error;
832: END IF;
833: END IF;
834:

Line 831: fnd_message.raise_error;

827: --Error If gender is Male and apply leave for Maternity or Part Time Maternity
828: IF P_ABS_INFORMATION_CATEGORY IN ('NO_M','NO_PTM') THEN
829: IF l_gender = 'M' then
830: fnd_message.set_name('PAY','PAY_376876_NO_MATERNITY_LEAVE');
831: fnd_message.raise_error;
832: END IF;
833: END IF;
834:
835: --Error If gender is Female and apply leave for Paternity or Part Time Paternity

Line 838: fnd_message.set_name('PAY','PAY_376877_NO_PATERNITY_LEAVE');

834:
835: --Error If gender is Female and apply leave for Paternity or Part Time Paternity
836: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
837: IF l_gender = 'F' then
838: fnd_message.set_name('PAY','PAY_376877_NO_PATERNITY_LEAVE');
839: fnd_message.raise_error;
840: END IF;
841: END IF;
842:

Line 839: fnd_message.raise_error;

835: --Error If gender is Female and apply leave for Paternity or Part Time Paternity
836: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
837: IF l_gender = 'F' then
838: fnd_message.set_name('PAY','PAY_376877_NO_PATERNITY_LEAVE');
839: fnd_message.raise_error;
840: END IF;
841: END IF;
842:
843: -- Error If initial absence is set to Yes and also a linking absence attached to the same absence

Line 845: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');

841: END IF;
842:
843: -- Error If initial absence is set to Yes and also a linking absence attached to the same absence
844: IF (P_ABS_INFORMATION15 = 'Y' AND P_ABS_INFORMATION16 is NOT NULL) THEN
845: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
846: fnd_message.raise_error;
847: END IF;
848: -- Error - If initial absence is set to No and no linking absence is provided
849: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN

Line 846: fnd_message.raise_error;

842:
843: -- Error If initial absence is set to Yes and also a linking absence attached to the same absence
844: IF (P_ABS_INFORMATION15 = 'Y' AND P_ABS_INFORMATION16 is NOT NULL) THEN
845: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
846: fnd_message.raise_error;
847: END IF;
848: -- Error - If initial absence is set to No and no linking absence is provided
849: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN
850: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');

Line 850: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');

846: fnd_message.raise_error;
847: END IF;
848: -- Error - If initial absence is set to No and no linking absence is provided
849: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN
850: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');
851: fnd_message.raise_error;
852: END IF;
853: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
854: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN

Line 851: fnd_message.raise_error;

847: END IF;
848: -- Error - If initial absence is set to No and no linking absence is provided
849: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN
850: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');
851: fnd_message.raise_error;
852: END IF;
853: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
854: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN
855: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');

Line 855: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');

851: fnd_message.raise_error;
852: END IF;
853: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
854: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN
855: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
856: fnd_message.raise_error;
857: END IF;
858:
859: l_person_id := P_PERSON_ID;

Line 856: fnd_message.raise_error;

852: END IF;
853: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
854: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN
855: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
856: fnd_message.raise_error;
857: END IF;
858:
859: l_person_id := P_PERSON_ID;
860: l_abs_start_date := NVL(P_DATE_START,P_DATE_PROJECTED_START);

Line 879: Fnd_message.set_name('PAY','PAY_376908_NO_ST_END_DATE_VAL');

875:
876: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS','NO_CMS') THEN
877: -- Error - if the certificate end date is earlier than the certificate start date
878: IF P_ABS_INFORMATION3 < P_ABS_INFORMATION2 THEN
879: Fnd_message.set_name('PAY','PAY_376908_NO_ST_END_DATE_VAL');
880: fnd_message.raise_error;
881: END IF;
882:
883: --Find the eligiblity date

Line 880: fnd_message.raise_error;

876: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS','NO_CMS') THEN
877: -- Error - if the certificate end date is earlier than the certificate start date
878: IF P_ABS_INFORMATION3 < P_ABS_INFORMATION2 THEN
879: Fnd_message.set_name('PAY','PAY_376908_NO_ST_END_DATE_VAL');
880: fnd_message.raise_error;
881: END IF;
882:
883: --Find the eligiblity date
884: l_elig_start_date := l_person_hire_date + l_abs_min_gap ;

Line 899: Fnd_message.set_name('PAY','PAY_376910_NO_EMP_NOT_ELIGIBLE');

895: CLOSE csr_reason_code ;
896:
897: -- Error - When an absence is recorded before eligibility 28 days
898: IF (l_abs_start_date < l_elig_start_date) AND (l_reason_code is NULL or l_reason_code <> 'ABS_WA') THEN
899: Fnd_message.set_name('PAY','PAY_376910_NO_EMP_NOT_ELIGIBLE');
900: Fnd_message.raise_error;
901: END IF;
902:
903: -- Error - if Self-Certificate is selected and the employee has had Self-Certified Sickness absences

Line 900: Fnd_message.raise_error;

896:
897: -- Error - When an absence is recorded before eligibility 28 days
898: IF (l_abs_start_date < l_elig_start_date) AND (l_reason_code is NULL or l_reason_code <> 'ABS_WA') THEN
899: Fnd_message.set_name('PAY','PAY_376910_NO_EMP_NOT_ELIGIBLE');
900: Fnd_message.raise_error;
901: END IF;
902:
903: -- Error - if Self-Certificate is selected and the employee has had Self-Certified Sickness absences
904: -- totaling more than 3 days in the previous 14 days

Line 912: Fnd_message.set_name('PAY','PAY_376929_ABS_SC_CONSECUTIVE');

908: /* --SC Warning 1 -- Bug# 14073252
909: IF l_tot_abs > get_rule_value(p_rule => 'CONSECUTIVE_DAYS'
910: ,p_person_id => P_PERSON_ID
911: ,p_effective_date => P_EFFECTIVE_DATE) THEN
912: Fnd_message.set_name('PAY','PAY_376929_ABS_SC_CONSECUTIVE');
913: Fnd_message.raise_error;
914: END IF;
915: */
916: FOR I IN CSR_3SC_SICKNESS_CHECK (l_person_id,l_abs_start_date,l_abs_link_period )

Line 913: Fnd_message.raise_error;

909: IF l_tot_abs > get_rule_value(p_rule => 'CONSECUTIVE_DAYS'
910: ,p_person_id => P_PERSON_ID
911: ,p_effective_date => P_EFFECTIVE_DATE) THEN
912: Fnd_message.set_name('PAY','PAY_376929_ABS_SC_CONSECUTIVE');
913: Fnd_message.raise_error;
914: END IF;
915: */
916: FOR I IN CSR_3SC_SICKNESS_CHECK (l_person_id,l_abs_start_date,l_abs_link_period )
917: LOOP

Line 934: Fnd_message.set_name('PAY','PAY_376932_ABS_SC_EMPLR_PERIOD');

930: /* --SC Warning 2 -- Bug# 14073252
931: IF l_tot_abs > get_rule_value(p_rule => 'EMPLOYER_PERIOD_DAYS'
932: ,p_person_id => P_PERSON_ID
933: ,p_effective_date => P_EFFECTIVE_DATE) THEN
934: Fnd_message.set_name('PAY','PAY_376932_ABS_SC_EMPLR_PERIOD');
935: Fnd_message.raise_error;
936: END IF;
937:
938:

Line 935: Fnd_message.raise_error;

931: IF l_tot_abs > get_rule_value(p_rule => 'EMPLOYER_PERIOD_DAYS'
932: ,p_person_id => P_PERSON_ID
933: ,p_effective_date => P_EFFECTIVE_DATE) THEN
934: Fnd_message.set_name('PAY','PAY_376932_ABS_SC_EMPLR_PERIOD');
935: Fnd_message.raise_error;
936: END IF;
937:
938:
939: IF l_tot_abs > 3 THEN -- Bug#8905705 fix

Line 940: Fnd_message.set_name('PAY','PAY_376869_NO_ABS_SELF_CERT');

936: END IF;
937:
938:
939: IF l_tot_abs > 3 THEN -- Bug#8905705 fix
940: Fnd_message.set_name('PAY','PAY_376869_NO_ABS_SELF_CERT');
941: Fnd_message.raise_error;
942: END IF;
943:
944: --Error - Only 4 self certificate absences are allowed for an year.

Line 941: Fnd_message.raise_error;

937:
938:
939: IF l_tot_abs > 3 THEN -- Bug#8905705 fix
940: Fnd_message.set_name('PAY','PAY_376869_NO_ABS_SELF_CERT');
941: Fnd_message.raise_error;
942: END IF;
943:
944: --Error - Only 4 self certificate absences are allowed for an year.
945: BEGIN

Line 968: Fnd_message.set_name('PAY','PAY_376931_ABS_SC_YEARLY_COUNT');

964: --SC Warning 3 --Bug# 14073252
965: IF r_absences_in_12months.counts > get_rule_value(p_rule => 'YEARLY_COUNT'
966: ,p_person_id => P_PERSON_ID
967: ,p_effective_date => P_EFFECTIVE_DATE) THEN
968: Fnd_message.set_name('PAY','PAY_376931_ABS_SC_YEARLY_COUNT');
969: Fnd_message.raise_error;
970: END IF;
971:
972: --SC Warning 4 --Bug# 14073252

Line 969: Fnd_message.raise_error;

965: IF r_absences_in_12months.counts > get_rule_value(p_rule => 'YEARLY_COUNT'
966: ,p_person_id => P_PERSON_ID
967: ,p_effective_date => P_EFFECTIVE_DATE) THEN
968: Fnd_message.set_name('PAY','PAY_376931_ABS_SC_YEARLY_COUNT');
969: Fnd_message.raise_error;
970: END IF;
971:
972: --SC Warning 4 --Bug# 14073252
973: IF r_absences_in_12months.days > get_rule_value(p_rule => 'YEARLY_DAYS'

Line 976: Fnd_message.set_name('PAY','PAY_376930_ABS_SC_YEARLY_DAYS');

972: --SC Warning 4 --Bug# 14073252
973: IF r_absences_in_12months.days > get_rule_value(p_rule => 'YEARLY_DAYS'
974: ,p_person_id => P_PERSON_ID
975: ,p_effective_date => P_EFFECTIVE_DATE) THEN
976: Fnd_message.set_name('PAY','PAY_376930_ABS_SC_YEARLY_DAYS');
977: Fnd_message.raise_error;
978: END IF;
979:
980:

Line 977: Fnd_message.raise_error;

973: IF r_absences_in_12months.days > get_rule_value(p_rule => 'YEARLY_DAYS'
974: ,p_person_id => P_PERSON_ID
975: ,p_effective_date => P_EFFECTIVE_DATE) THEN
976: Fnd_message.set_name('PAY','PAY_376930_ABS_SC_YEARLY_DAYS');
977: Fnd_message.raise_error;
978: END IF;
979:
980:
981:

Line 983: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');

979:
980:
981:
982: IF l_abs_count >= 4 THEN
983: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
984: Fnd_message.raise_error;
985: END IF;
986: */ -- All SC Warnings not applicable in Self Service. Only below Error appears.
987:

Line 984: Fnd_message.raise_error;

980:
981:
982: IF l_abs_count >= 4 THEN
983: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
984: Fnd_message.raise_error;
985: END IF;
986: */ -- All SC Warnings not applicable in Self Service. Only below Error appears.
987:
988: --SC Error 1 --Bug# 14073252

Line 993: Fnd_message.set_name('PAY','PAY_376888_ABS_SC_REIMB_DAY');

989: IF is_reimbursement_day (p_person_id => P_PERSON_ID
990: ,p_abs_link_period => l_abs_link_period
991: ,p_start_date => l_abs_start_date
992: ,p_end_date => NVL(l_abs_end_date,l_abs_start_date)) =1 THEN
993: Fnd_message.set_name('PAY','PAY_376888_ABS_SC_REIMB_DAY');
994: Fnd_message.raise_error;
995: END IF;
996:
997: END IF;

Line 994: Fnd_message.raise_error;

990: ,p_abs_link_period => l_abs_link_period
991: ,p_start_date => l_abs_start_date
992: ,p_end_date => NVL(l_abs_end_date,l_abs_start_date)) =1 THEN
993: Fnd_message.set_name('PAY','PAY_376888_ABS_SC_REIMB_DAY');
994: Fnd_message.raise_error;
995: END IF;
996:
997: END IF;
998:

Line 1002: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');

998:
999: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') THEN
1000: -- Error - if the Entitltment for self certificate is No and type is selected as Self certification
1001: IF l_entitled_sc = 'N' AND P_ABS_INFORMATION1 = 'SC' THEN
1002: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
1003: Fnd_message.raise_error;
1004: END IF;
1005:
1006: -- Error - if the Self certification is used and the service is less than 2 months

Line 1003: Fnd_message.raise_error;

999: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') THEN
1000: -- Error - if the Entitltment for self certificate is No and type is selected as Self certification
1001: IF l_entitled_sc = 'N' AND P_ABS_INFORMATION1 = 'SC' THEN
1002: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
1003: Fnd_message.raise_error;
1004: END IF;
1005:
1006: -- Error - if the Self certification is used and the service is less than 2 months
1007: l_months_employed_curr := trunc(months_between(l_abs_start_date,l_person_hire_date),2);

Line 1009: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');

1005:
1006: -- Error - if the Self certification is used and the service is less than 2 months
1007: l_months_employed_curr := trunc(months_between(l_abs_start_date,l_person_hire_date),2);
1008: IF l_months_employed_curr < 2 AND P_ABS_INFORMATION1 = 'SC' THEN
1009: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
1010: Fnd_message.raise_error; -- This is warning not error
1011: END IF;
1012: END IF;
1013:

Line 1010: Fnd_message.raise_error; -- This is warning not error

1006: -- Error - if the Self certification is used and the service is less than 2 months
1007: l_months_employed_curr := trunc(months_between(l_abs_start_date,l_person_hire_date),2);
1008: IF l_months_employed_curr < 2 AND P_ABS_INFORMATION1 = 'SC' THEN
1009: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
1010: Fnd_message.raise_error; -- This is warning not error
1011: END IF;
1012: END IF;
1013:
1014: -- Bug#8510300 start

Line 1106: --fnd_message.debug ('Person is not eligible to avail this absence as he/she is not employed for 6/10 months'); -- put proper warning message

1102: l_within_n_months := -1 * l_within_n_months;
1103: END IF;
1104:
1105: IF l_eligible = 'N' THEN
1106: --fnd_message.debug ('Person is not eligible to avail this absence as he/she is not employed for 6/10 months'); -- put proper warning message
1107: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
1108: fnd_message.set_token('MIN',to_char(l_min_worked_months));
1109: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
1110: Fnd_message.raise_error;

Line 1107: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');

1103: END IF;
1104:
1105: IF l_eligible = 'N' THEN
1106: --fnd_message.debug ('Person is not eligible to avail this absence as he/she is not employed for 6/10 months'); -- put proper warning message
1107: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
1108: fnd_message.set_token('MIN',to_char(l_min_worked_months));
1109: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
1110: Fnd_message.raise_error;
1111:

Line 1108: fnd_message.set_token('MIN',to_char(l_min_worked_months));

1104:
1105: IF l_eligible = 'N' THEN
1106: --fnd_message.debug ('Person is not eligible to avail this absence as he/she is not employed for 6/10 months'); -- put proper warning message
1107: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
1108: fnd_message.set_token('MIN',to_char(l_min_worked_months));
1109: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
1110: Fnd_message.raise_error;
1111:
1112: END IF;

Line 1109: fnd_message.set_token('LIMIT',to_char(l_within_n_months));

1105: IF l_eligible = 'N' THEN
1106: --fnd_message.debug ('Person is not eligible to avail this absence as he/she is not employed for 6/10 months'); -- put proper warning message
1107: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
1108: fnd_message.set_token('MIN',to_char(l_min_worked_months));
1109: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
1110: Fnd_message.raise_error;
1111:
1112: END IF;
1113: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN

Line 1110: Fnd_message.raise_error;

1106: --fnd_message.debug ('Person is not eligible to avail this absence as he/she is not employed for 6/10 months'); -- put proper warning message
1107: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
1108: fnd_message.set_token('MIN',to_char(l_min_worked_months));
1109: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
1110: Fnd_message.raise_error;
1111:
1112: END IF;
1113: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
1114: -- Error - if the absence start date is earlier than the date of birth

Line 1117: Fnd_message.set_name('PAY','PAY_376905_NO_DOB_ST_DT_CHECK');

1113: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
1114: -- Error - if the absence start date is earlier than the date of birth
1115: l_date_of_birth := fnd_date.canonical_to_date(P_ABS_INFORMATION1) ;
1116: IF l_date_of_birth > P_DATE_START THEN
1117: Fnd_message.set_name('PAY','PAY_376905_NO_DOB_ST_DT_CHECK');
1118: Fnd_message.raise_error;
1119: END IF;
1120: END IF;
1121: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN

Line 1118: Fnd_message.raise_error;

1114: -- Error - if the absence start date is earlier than the date of birth
1115: l_date_of_birth := fnd_date.canonical_to_date(P_ABS_INFORMATION1) ;
1116: IF l_date_of_birth > P_DATE_START THEN
1117: Fnd_message.set_name('PAY','PAY_376905_NO_DOB_ST_DT_CHECK');
1118: Fnd_message.raise_error;
1119: END IF;
1120: END IF;
1121: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN
1122: IF NVL(P_ABS_INFORMATION5,'N') = 'N' AND P_ABS_INFORMATION6 IS NOT NULL THEN

Line 1123: fnd_message.set_name('PER','HR_376901_NO_ABS_NO_SPOUSE');

1119: END IF;
1120: END IF;
1121: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN
1122: IF NVL(P_ABS_INFORMATION5,'N') = 'N' AND P_ABS_INFORMATION6 IS NOT NULL THEN
1123: fnd_message.set_name('PER','HR_376901_NO_ABS_NO_SPOUSE');
1124: fnd_message.raise_error;
1125: END IF;
1126: END IF ;
1127: END IF;

Line 1124: fnd_message.raise_error;

1120: END IF;
1121: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN
1122: IF NVL(P_ABS_INFORMATION5,'N') = 'N' AND P_ABS_INFORMATION6 IS NOT NULL THEN
1123: fnd_message.set_name('PER','HR_376901_NO_ABS_NO_SPOUSE');
1124: fnd_message.raise_error;
1125: END IF;
1126: END IF ;
1127: END IF;
1128: END CREATE_ABS_VALIDATION ;