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.PAY_NO_ABS_VALIDATION dependencies on FND_MESSAGE

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

87: CLOSE csr_get_gender;
88: --Error If gender is Male and apply leave for Maternity or Part Time Maternity
89: IF P_ABS_INFORMATION_CATEGORY IN ('NO_M','NO_PTM') THEN
90: IF l_gender = 'M' then
91: fnd_message.set_name('PAY','PAY_376876_NO_MATERNITY_LEAVE');
92: fnd_message.raise_error;
93: END IF;
94: END IF;
95:

Line 92: fnd_message.raise_error;

88: --Error If gender is Male and apply leave for Maternity or Part Time Maternity
89: IF P_ABS_INFORMATION_CATEGORY IN ('NO_M','NO_PTM') THEN
90: IF l_gender = 'M' then
91: fnd_message.set_name('PAY','PAY_376876_NO_MATERNITY_LEAVE');
92: fnd_message.raise_error;
93: END IF;
94: END IF;
95:
96: --Error If gender is Female and apply leave for Paternity or Part Time Paternity

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

95:
96: --Error If gender is Female and apply leave for Paternity or Part Time Paternity
97: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
98: IF l_gender = 'F' then
99: fnd_message.set_name('PAY','PAY_376877_NO_PATERNITY_LEAVE');
100: fnd_message.raise_error;
101: END IF;
102: END IF;
103:

Line 100: fnd_message.raise_error;

96: --Error If gender is Female and apply leave for Paternity or Part Time Paternity
97: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
98: IF l_gender = 'F' then
99: fnd_message.set_name('PAY','PAY_376877_NO_PATERNITY_LEAVE');
100: fnd_message.raise_error;
101: END IF;
102: END IF;
103:
104: -- Error If initial absence is set to Yes and also a linking absence attached to the same absence

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

102: END IF;
103:
104: -- Error If initial absence is set to Yes and also a linking absence attached to the same absence
105: IF (P_ABS_INFORMATION15 = 'Y' AND P_ABS_INFORMATION16 is NOT NULL) THEN
106: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
107: fnd_message.raise_error;
108: END IF;
109: -- Error - If initial absence is set to No and no linking absence is provided
110: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN

Line 107: fnd_message.raise_error;

103:
104: -- Error If initial absence is set to Yes and also a linking absence attached to the same absence
105: IF (P_ABS_INFORMATION15 = 'Y' AND P_ABS_INFORMATION16 is NOT NULL) THEN
106: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
107: fnd_message.raise_error;
108: END IF;
109: -- Error - If initial absence is set to No and no linking absence is provided
110: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN
111: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');

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

107: fnd_message.raise_error;
108: END IF;
109: -- Error - If initial absence is set to No and no linking absence is provided
110: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN
111: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');
112: fnd_message.raise_error;
113: END IF;
114: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
115: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN

Line 112: fnd_message.raise_error;

108: END IF;
109: -- Error - If initial absence is set to No and no linking absence is provided
110: IF (P_ABS_INFORMATION15 = 'N' AND P_ABS_INFORMATION16 is NULL) THEN
111: Fnd_message.set_name('PAY','PAY_376917_NO_ABS_LINKING_DTL');
112: fnd_message.raise_error;
113: END IF;
114: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
115: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN
116: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');

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

112: fnd_message.raise_error;
113: END IF;
114: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
115: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN
116: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
117: fnd_message.raise_error;
118: END IF;
119:
120: l_person_id := P_PERSON_ID;

Line 117: fnd_message.raise_error;

113: END IF;
114: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') AND
115: P_ABS_INFORMATION15 is null AND P_ABS_INFORMATION16 is NOT NULL THEN
116: Fnd_message.set_name('PAY','PAY_376916_NO_ABS_LINKING_INI');
117: fnd_message.raise_error;
118: END IF;
119:
120: l_person_id := P_PERSON_ID;
121: l_abs_start_date := NVL(P_DATE_START,P_DATE_PROJECTED_START);

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

136:
137: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS','NO_CMS') THEN
138: -- Error - if the certificate end date is earlier than the certificate start date
139: IF P_ABS_INFORMATION3 < P_ABS_INFORMATION2 THEN
140: Fnd_message.set_name('PAY','PAY_376908_NO_ST_END_DATE_VAL');
141: fnd_message.raise_error;
142: END IF;
143:
144: --Find the eligiblity date

Line 141: fnd_message.raise_error;

137: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS','NO_CMS') THEN
138: -- Error - if the certificate end date is earlier than the certificate start date
139: IF P_ABS_INFORMATION3 < P_ABS_INFORMATION2 THEN
140: Fnd_message.set_name('PAY','PAY_376908_NO_ST_END_DATE_VAL');
141: fnd_message.raise_error;
142: END IF;
143:
144: --Find the eligiblity date
145: l_elig_start_date := l_person_hire_date + l_abs_min_gap ;

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

156: CLOSE csr_reason_code ;
157:
158: -- Error - When an absence is recorded before eligibility 28 days
159: IF (l_abs_start_date < l_elig_start_date) AND (l_reason_code is NULL or l_reason_code <> 'ABS_WA') THEN
160: Fnd_message.set_name('PAY','PAY_376910_NO_EMP_NOT_ELIGIBLE');
161: Fnd_message.raise_error;
162: END IF;
163:
164: -- Error - if Self-Certificate is selected and the employee has had Self-Certified Sickness absences

Line 161: Fnd_message.raise_error;

157:
158: -- Error - When an absence is recorded before eligibility 28 days
159: IF (l_abs_start_date < l_elig_start_date) AND (l_reason_code is NULL or l_reason_code <> 'ABS_WA') THEN
160: Fnd_message.set_name('PAY','PAY_376910_NO_EMP_NOT_ELIGIBLE');
161: Fnd_message.raise_error;
162: END IF;
163:
164: -- Error - if Self-Certificate is selected and the employee has had Self-Certified Sickness absences
165: -- totaling more than 3 days in the previous 14 days

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

178: END IF;
179: END LOOP;
180:
181: IF l_abs_count > 3 THEN
182: Fnd_message.set_name('PAY','PAY_376869_NO_ABS_SELF_CERT');
183: Fnd_message.raise_error;
184: END IF;
185:
186: --Error - Only 4 self certificate absences are allowed for an year.

Line 183: Fnd_message.raise_error;

179: END LOOP;
180:
181: IF l_abs_count > 3 THEN
182: Fnd_message.set_name('PAY','PAY_376869_NO_ABS_SELF_CERT');
183: Fnd_message.raise_error;
184: END IF;
185:
186: --Error - Only 4 self certificate absences are allowed for an year.
187: BEGIN

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

197: WHEN OTHERS THEN
198: l_abs_count := 0;
199: END;
200: IF l_abs_count >= 4 THEN
201: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
202: Fnd_message.raise_error;
203: END IF;
204:
205: END IF;

Line 202: Fnd_message.raise_error;

198: l_abs_count := 0;
199: END;
200: IF l_abs_count >= 4 THEN
201: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
202: Fnd_message.raise_error;
203: END IF;
204:
205: END IF;
206:

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

206:
207: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') THEN
208: -- Error - if the Entitltment for self certificate is No and type is selected as Self certification
209: IF l_entitled_sc = 'N' AND P_ABS_INFORMATION1 = 'SC' THEN
210: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
211: Fnd_message.raise_error;
212: END IF;
213:
214: -- Error - if the Self certification is used and the service is less than 2 months

Line 211: Fnd_message.raise_error;

207: IF P_ABS_INFORMATION_CATEGORY IN ('NO_S','NO_PTS') THEN
208: -- Error - if the Entitltment for self certificate is No and type is selected as Self certification
209: IF l_entitled_sc = 'N' AND P_ABS_INFORMATION1 = 'SC' THEN
210: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
211: Fnd_message.raise_error;
212: END IF;
213:
214: -- Error - if the Self certification is used and the service is less than 2 months
215: l_months_employed_curr := trunc(months_between(l_abs_start_date,l_person_hire_date),2);

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

213:
214: -- Error - if the Self certification is used and the service is less than 2 months
215: l_months_employed_curr := trunc(months_between(l_abs_start_date,l_person_hire_date),2);
216: IF l_months_employed_curr < 2 AND P_ABS_INFORMATION1 = 'SC' THEN
217: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
218: Fnd_message.raise_error; -- This is warning not error
219: END IF;
220: END IF;
221:

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

214: -- Error - if the Self certification is used and the service is less than 2 months
215: l_months_employed_curr := trunc(months_between(l_abs_start_date,l_person_hire_date),2);
216: IF l_months_employed_curr < 2 AND P_ABS_INFORMATION1 = 'SC' THEN
217: Fnd_message.set_name('PAY','PAY_376907_NO_SC_NOT_ELIGIBLE');
218: Fnd_message.raise_error; -- This is warning not error
219: END IF;
220: END IF;
221:
222: END IF;

Line 256: --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

252: l_within_n_months := -1 * l_within_n_months;
253: END IF;
254:
255: IF l_eligible = 'N' THEN
256: --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
257: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
258: fnd_message.set_token('MIN',to_char(l_min_worked_months));
259: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
260: Fnd_message.raise_error;

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

253: END IF;
254:
255: IF l_eligible = 'N' THEN
256: --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
257: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
258: fnd_message.set_token('MIN',to_char(l_min_worked_months));
259: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
260: Fnd_message.raise_error;
261:

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

254:
255: IF l_eligible = 'N' THEN
256: --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
257: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
258: fnd_message.set_token('MIN',to_char(l_min_worked_months));
259: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
260: Fnd_message.raise_error;
261:
262: END IF;

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

255: IF l_eligible = 'N' THEN
256: --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
257: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
258: fnd_message.set_token('MIN',to_char(l_min_worked_months));
259: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
260: Fnd_message.raise_error;
261:
262: END IF;
263: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN

Line 260: Fnd_message.raise_error;

256: --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
257: fnd_message.set_name('PAY','PAY_376875_NO_PARENTAL_ELIGIBL');
258: fnd_message.set_token('MIN',to_char(l_min_worked_months));
259: fnd_message.set_token('LIMIT',to_char(l_within_n_months));
260: Fnd_message.raise_error;
261:
262: END IF;
263: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
264: -- Error - if the absence start date is earlier than the date of birth

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

263: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
264: -- Error - if the absence start date is earlier than the date of birth
265: l_date_of_birth := fnd_date.canonical_to_date(P_ABS_INFORMATION1) ;
266: IF l_date_of_birth > P_DATE_START THEN
267: Fnd_message.set_name('PAY','PAY_376905_NO_DOB_ST_DT_CHECK');
268: Fnd_message.raise_error;
269: END IF;
270: END IF;
271: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN

Line 268: Fnd_message.raise_error;

264: -- Error - if the absence start date is earlier than the date of birth
265: l_date_of_birth := fnd_date.canonical_to_date(P_ABS_INFORMATION1) ;
266: IF l_date_of_birth > P_DATE_START THEN
267: Fnd_message.set_name('PAY','PAY_376905_NO_DOB_ST_DT_CHECK');
268: Fnd_message.raise_error;
269: END IF;
270: END IF;
271: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN
272: IF NVL(P_ABS_INFORMATION5,'N') = 'N' AND P_ABS_INFORMATION6 IS NOT NULL THEN

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

269: END IF;
270: END IF;
271: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN
272: IF NVL(P_ABS_INFORMATION5,'N') = 'N' AND P_ABS_INFORMATION6 IS NOT NULL THEN
273: fnd_message.set_name('PER','HR_376901_NO_ABS_NO_SPOUSE');
274: fnd_message.raise_error;
275: END IF;
276: END IF ;
277: END IF;

Line 274: fnd_message.raise_error;

270: END IF;
271: IF P_ABS_INFORMATION_CATEGORY ='NO_M' THEN
272: IF NVL(P_ABS_INFORMATION5,'N') = 'N' AND P_ABS_INFORMATION6 IS NOT NULL THEN
273: fnd_message.set_name('PER','HR_376901_NO_ABS_NO_SPOUSE');
274: fnd_message.raise_error;
275: END IF;
276: END IF ;
277: END IF;
278: END CREATE_ABS_VALIDATION ;