[Home] [Help]
63:
64: --
65: Begin
66: --
67: hr_utility.set_location('Entering:'||l_proc, 10);
68: --
69: if p_information_type = 'HR_CPF_CLAIMED_SG' then
70:
71: -- check if it has more than 3 claim details entered per basic year
77: if ir8s_c_invalid_records%found then
78: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_RECORDS_INVALID');
79: fnd_message.raise_error;
80:
81: hr_utility.set_location(l_proc, 20);
82:
83: end if;
84: close ir8s_c_invalid_records;
85:
107:
108: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_ADD_WAGES_INVALID');
109: fnd_message.raise_error;
110:
111: hr_utility.set_location(l_proc, 30);
112:
113: -- check if Period To Date of Additional Wages is greater then
114: -- Period From Date of Additional Wages
115: -- Modified the condition for Bug# 3249303
119: fnd_message.set_token('DATE1', 'Period To Date of Additional Wages');
120: fnd_message.set_token('DATE2', 'Period From Date of Additional Wages');
121: fnd_message.raise_error;
122:
123: hr_utility.set_location(l_proc, 40);
124:
125: -- Check Pay date for additional wages must be greater or equal to
126: -- Payment for additional wages to date
127:
130: fnd_message.set_token('DATE1', 'Pay Date of Additional Wages');
131: fnd_message.set_token('DATE2', 'Period To Date of Additional Wages');
132: fnd_message.raise_error;
133:
134: hr_utility.set_location(l_proc, 50);
135:
136: -- Check if Date of refund on employer CPF contribution is entered then
137: -- ensure Pay date for additional wages must be entered
138:
142: fnd_message.set_token('FIELD1', 'Date of Refund of Employer Amount');
143: fnd_message.set_token('FIELD2', 'Pay Date of Additional Wages');
144: fnd_message.raise_error;
145:
146: hr_utility.set_location(l_proc, 60);
147:
148: -- Check if ER CPF contribution on amount of refund is entered then ensure
149: -- Date of refund on ER CPF contribution on amount of refund must be entered
150: elsif nvl(p_aei_information6, 0) <> 0 and p_aei_information8 is null then
152: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');
153: fnd_message.set_token('FIELD2', 'Date of Refund of Employer Amount');
154: fnd_message.raise_error;
155:
156: hr_utility.set_location(l_proc, 70);
157:
158: -- Check if Interset paid on ER CPF contribution on amount of refund
159: -- is entered then ensure Date of refund on ER CPF contribution on amount
160: -- of refund must be entered
164: fnd_message.set_token('FIELD1', 'Interest on Refund of Employer Contribution');
165: fnd_message.set_token('FIELD2', 'Date of Refund of Employer Amount');
166: fnd_message.raise_error;
167:
168: hr_utility.set_location(l_proc, 80);
169:
170: -- Check if Date of refund on ER CPF contribution on amount of refund is
171: -- entered, then ensure ER CPF contribution on amount of refund or
172: -- Interest paid on ER CPF contribution on amount of refund must be entered
178: fnd_message.set_token('FIELD2', 'Interest on Refund of Employer Contribution');
179: fnd_message.set_token('FIELD3', 'Date of Refund of Employer Amount');
180: fnd_message.raise_error;
181:
182: hr_utility.set_location(l_proc, 90);
183:
184: -- Check date of refund on ER CPF Contribution on amount of refund must
185: -- be greater or equal to Pay date for additional wages
186:
189: fnd_message.set_token('DATE1', 'Date of Refund of Employer Amount');
190: fnd_message.set_token('DATE2', 'Pay Date of Additional Wages');
191: fnd_message.raise_error;
192:
193: hr_utility.set_location(l_proc, 100);
194:
195: -- Check if Date of refund on employee CPF contribution is entered then
196: -- ensure Pay date for additional wages must be entered
197:
201: fnd_message.set_token('FIELD1', 'Date of Refund of Employee Amount');
202: fnd_message.set_token('FIELD2', 'Pay Date of Additional Wages');
203: fnd_message.raise_error;
204:
205: hr_utility.set_location(l_proc, 110);
206:
207: -- Check if ER CPF contribution on amount of refund is entered then ensure
208: -- Date of refund on ER CPF contribution on amount of refund must be entered
209:
212: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');
213: fnd_message.set_token('FIELD2', 'Date of Refund of Employee Amount');
214: fnd_message.raise_error;
215:
216: hr_utility.set_location(l_proc, 120);
217:
218: -- Check if Interset paid on EE CPF contribution on amount of refund
219: -- is entered then ensure Date of refund on EE CPF contribution on amount
220: -- of refund must be entered
224: fnd_message.set_token('FIELD1', 'Interest on Refund of Employee Contribution');
225: fnd_message.set_token('FIELD2', 'Date of Refund of Employee Amount');
226: fnd_message.raise_error;
227:
228: hr_utility.set_location(l_proc, 130);
229:
230: -- Check if Date of refund on EE CPF contribution on amount of refund is
231: -- entered, then ensure EE CPF contribution on amount of refund or
232: -- Interest paid on EE CPF contribution on amount of refund must be entered
238: fnd_message.set_token('FIELD2', 'Interest on Refund of Employee Contribution');
239: fnd_message.set_token('FIELD3', 'Date of Refund of Employee Amount');
240: fnd_message.raise_error;
241:
242: hr_utility.set_location(l_proc, 140);
243:
244: -- Check date of refund on EE CPF Contribution on amount of refund must
245: -- be greater or equal to Pay date for additional wages
246:
249: fnd_message.set_token('DATE1', 'Date of Refund of Employee Amount');
250: fnd_message.set_token('DATE2', 'Pay Date of Additional Wages');
251: fnd_message.raise_error;
252:
253: hr_utility.set_location(l_proc, 150);
254:
255: -- Check all dates are in basis year
256: -- Bug 5960714, this validation check should not include Date of refund
257: -- p_aei_information8 &p_aei_information11
264:
265: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_SAME_YEAR');
266: fnd_message.raise_error;
267:
268: hr_utility.set_location(l_proc, 160);
269:
270: end if;
271: end if;
272: --
269:
270: end if;
271: end if;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 170);
274: --
275: End chk_ir8s_c_valid;
276: --
277: --