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

Line 78: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_RECORDS_INVALID');

74: p_information_type,
75: p_aei_information1);
76: fetch ir8s_c_invalid_records into l_invalid_record;
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:

Line 79: fnd_message.raise_error;

75: p_aei_information1);
76: fetch ir8s_c_invalid_records into l_invalid_record;
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;

Line 108: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_ADD_WAGES_INVALID');

104: (nvl(p_aei_information2, 0) = 0 or
105: p_aei_information3 is null or
106: p_aei_information4 is null)) then
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:

Line 109: fnd_message.raise_error;

105: p_aei_information3 is null or
106: p_aei_information4 is null)) then
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

Line 118: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID2');

114: -- Period From Date of Additional Wages
115: -- Modified the condition for Bug# 3249303
116:
117: elsif fnd_date.canonical_to_date(p_aei_information4) <= fnd_date.canonical_to_date(p_aei_information3) then
118: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID2');
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:

Line 119: fnd_message.set_token('DATE1', 'Period To Date of Additional Wages');

115: -- Modified the condition for Bug# 3249303
116:
117: elsif fnd_date.canonical_to_date(p_aei_information4) <= fnd_date.canonical_to_date(p_aei_information3) then
118: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID2');
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);

Line 120: fnd_message.set_token('DATE2', 'Period From Date of Additional Wages');

116:
117: elsif fnd_date.canonical_to_date(p_aei_information4) <= fnd_date.canonical_to_date(p_aei_information3) then
118: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID2');
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:

Line 121: fnd_message.raise_error;

117: elsif fnd_date.canonical_to_date(p_aei_information4) <= fnd_date.canonical_to_date(p_aei_information3) then
118: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID2');
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

Line 129: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');

125: -- Check Pay date for additional wages must be greater or equal to
126: -- Payment for additional wages to date
127:
128: elsif fnd_date.canonical_to_date(p_aei_information5) < fnd_date.canonical_to_date(p_aei_information4) then
129: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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:

Line 130: fnd_message.set_token('DATE1', 'Pay Date of Additional Wages');

126: -- Payment for additional wages to date
127:
128: elsif fnd_date.canonical_to_date(p_aei_information5) < fnd_date.canonical_to_date(p_aei_information4) then
129: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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);

Line 131: fnd_message.set_token('DATE2', 'Period To Date of Additional Wages');

127:
128: elsif fnd_date.canonical_to_date(p_aei_information5) < fnd_date.canonical_to_date(p_aei_information4) then
129: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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:

Line 132: fnd_message.raise_error;

128: elsif fnd_date.canonical_to_date(p_aei_information5) < fnd_date.canonical_to_date(p_aei_information4) then
129: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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

Line 141: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');

137: -- ensure Pay date for additional wages must be entered
138:
139: elsif p_aei_information8 is not null and
140: p_aei_information5 is null then
141: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 142: fnd_message.set_token('FIELD1', 'Date of Refund of Employer Amount');

138:
139: elsif p_aei_information8 is not null and
140: p_aei_information5 is null then
141: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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);

Line 143: fnd_message.set_token('FIELD2', 'Pay Date of Additional Wages');

139: elsif p_aei_information8 is not null and
140: p_aei_information5 is null then
141: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 144: fnd_message.raise_error;

140: p_aei_information5 is null then
141: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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

Line 151: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');

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
151: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 152: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');

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
151: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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);

Line 153: fnd_message.set_token('FIELD2', 'Date of Refund of Employer Amount');

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
151: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 154: fnd_message.raise_error;

150: elsif nvl(p_aei_information6, 0) <> 0 and p_aei_information8 is null then
151: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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

Line 163: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');

159: -- is entered then ensure Date of refund on ER CPF contribution on amount
160: -- of refund must be entered
161:
162: elsif nvl(p_aei_information7, 0) <> 0 and p_aei_information8 is null then
163: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 164: fnd_message.set_token('FIELD1', 'Interest on Refund of Employer Contribution');

160: -- of refund must be entered
161:
162: elsif nvl(p_aei_information7, 0) <> 0 and p_aei_information8 is null then
163: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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);

Line 165: fnd_message.set_token('FIELD2', 'Date of Refund of Employer Amount');

161:
162: elsif nvl(p_aei_information7, 0) <> 0 and p_aei_information8 is null then
163: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 166: fnd_message.raise_error;

162: elsif nvl(p_aei_information7, 0) <> 0 and p_aei_information8 is null then
163: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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

Line 176: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');

172: -- Interest paid on ER CPF contribution on amount of refund must be entered
173:
174: elsif ((p_aei_information8 is not null) and
175: (nvl(p_aei_information6, 0) = 0 and nvl(p_aei_information7, 0) =0)) then
176: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
177: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');
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;

Line 177: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');

173:
174: elsif ((p_aei_information8 is not null) and
175: (nvl(p_aei_information6, 0) = 0 and nvl(p_aei_information7, 0) =0)) then
176: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
177: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');
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:

Line 178: fnd_message.set_token('FIELD2', 'Interest on Refund of Employer Contribution');

174: elsif ((p_aei_information8 is not null) and
175: (nvl(p_aei_information6, 0) = 0 and nvl(p_aei_information7, 0) =0)) then
176: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
177: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');
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);

Line 179: fnd_message.set_token('FIELD3', 'Date of Refund of Employer Amount');

175: (nvl(p_aei_information6, 0) = 0 and nvl(p_aei_information7, 0) =0)) then
176: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
177: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');
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:

Line 180: fnd_message.raise_error;

176: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
177: fnd_message.set_token('FIELD1', 'Amount of Refund of Employer Contribution');
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

Line 188: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');

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:
187: elsif fnd_date.canonical_to_date(p_aei_information8) < fnd_date.canonical_to_date(p_aei_information5) then
188: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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:

Line 189: fnd_message.set_token('DATE1', 'Date of Refund of Employer Amount');

185: -- be greater or equal to Pay date for additional wages
186:
187: elsif fnd_date.canonical_to_date(p_aei_information8) < fnd_date.canonical_to_date(p_aei_information5) then
188: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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);

Line 190: fnd_message.set_token('DATE2', 'Pay Date of Additional Wages');

186:
187: elsif fnd_date.canonical_to_date(p_aei_information8) < fnd_date.canonical_to_date(p_aei_information5) then
188: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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:

Line 191: fnd_message.raise_error;

187: elsif fnd_date.canonical_to_date(p_aei_information8) < fnd_date.canonical_to_date(p_aei_information5) then
188: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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

Line 200: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');

196: -- ensure Pay date for additional wages must be entered
197:
198: elsif p_aei_information11 is not null and
199: p_aei_information5 is null then
200: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 201: fnd_message.set_token('FIELD1', 'Date of Refund of Employee Amount');

197:
198: elsif p_aei_information11 is not null and
199: p_aei_information5 is null then
200: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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);

Line 202: fnd_message.set_token('FIELD2', 'Pay Date of Additional Wages');

198: elsif p_aei_information11 is not null and
199: p_aei_information5 is null then
200: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 203: fnd_message.raise_error;

199: p_aei_information5 is null then
200: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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

Line 211: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');

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:
210: elsif nvl(p_aei_information9, 0) <> 0 and p_aei_information11 is null then
211: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 212: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');

208: -- Date of refund on ER CPF contribution on amount of refund must be entered
209:
210: elsif nvl(p_aei_information9, 0) <> 0 and p_aei_information11 is null then
211: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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);

Line 213: fnd_message.set_token('FIELD2', 'Date of Refund of Employee Amount');

209:
210: elsif nvl(p_aei_information9, 0) <> 0 and p_aei_information11 is null then
211: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 214: fnd_message.raise_error;

210: elsif nvl(p_aei_information9, 0) <> 0 and p_aei_information11 is null then
211: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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

Line 223: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');

219: -- is entered then ensure Date of refund on EE CPF contribution on amount
220: -- of refund must be entered
221:
222: elsif nvl(p_aei_information10, 0) <> 0 and p_aei_information11 is null then
223: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 224: fnd_message.set_token('FIELD1', 'Interest on Refund of Employee Contribution');

220: -- of refund must be entered
221:
222: elsif nvl(p_aei_information10, 0) <> 0 and p_aei_information11 is null then
223: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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);

Line 225: fnd_message.set_token('FIELD2', 'Date of Refund of Employee Amount');

221:
222: elsif nvl(p_aei_information10, 0) <> 0 and p_aei_information11 is null then
223: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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:

Line 226: fnd_message.raise_error;

222: elsif nvl(p_aei_information10, 0) <> 0 and p_aei_information11 is null then
223: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID1');
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

Line 236: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');

232: -- Interest paid on EE CPF contribution on amount of refund must be entered
233:
234: elsif ((p_aei_information11 is not null) and
235: (nvl(p_aei_information9, 0) = 0 and nvl(p_aei_information10, 0) = 0)) then
236: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
237: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');
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;

Line 237: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');

233:
234: elsif ((p_aei_information11 is not null) and
235: (nvl(p_aei_information9, 0) = 0 and nvl(p_aei_information10, 0) = 0)) then
236: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
237: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');
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:

Line 238: fnd_message.set_token('FIELD2', 'Interest on Refund of Employee Contribution');

234: elsif ((p_aei_information11 is not null) and
235: (nvl(p_aei_information9, 0) = 0 and nvl(p_aei_information10, 0) = 0)) then
236: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
237: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');
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);

Line 239: fnd_message.set_token('FIELD3', 'Date of Refund of Employee Amount');

235: (nvl(p_aei_information9, 0) = 0 and nvl(p_aei_information10, 0) = 0)) then
236: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
237: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');
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:

Line 240: fnd_message.raise_error;

236: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_CPF_INVALID');
237: fnd_message.set_token('FIELD1', 'Amount of Refund of Employee Contribution');
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

Line 248: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');

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:
247: elsif fnd_date.canonical_to_date(p_aei_information11) < fnd_date.canonical_to_date(p_aei_information5) then
248: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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:

Line 249: fnd_message.set_token('DATE1', 'Date of Refund of Employee Amount');

245: -- be greater or equal to Pay date for additional wages
246:
247: elsif fnd_date.canonical_to_date(p_aei_information11) < fnd_date.canonical_to_date(p_aei_information5) then
248: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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);

Line 250: fnd_message.set_token('DATE2', 'Pay Date of Additional Wages');

246:
247: elsif fnd_date.canonical_to_date(p_aei_information11) < fnd_date.canonical_to_date(p_aei_information5) then
248: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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:

Line 251: fnd_message.raise_error;

247: elsif fnd_date.canonical_to_date(p_aei_information11) < fnd_date.canonical_to_date(p_aei_information5) then
248: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
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

Line 265: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_SAME_YEAR');

261: p_aei_information1) <> p_aei_information1 or
262: nvl(to_char(fnd_date.canonical_to_date(p_aei_information5), 'YYYY'),
263: p_aei_information1) <> p_aei_information1 then
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:

Line 266: fnd_message.raise_error;

262: nvl(to_char(fnd_date.canonical_to_date(p_aei_information5), 'YYYY'),
263: p_aei_information1) <> p_aei_information1 then
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;

Line 362: fnd_message.set_name('PER','PER_7901_SYS_DUPLICATE_RECORDS');

358: p_aei_information2,
359: p_aei_information3);
360: fetch multi_csn_dup_records into l_invalid_record;
361: if multi_csn_dup_records%found then
362: fnd_message.set_name('PER','PER_7901_SYS_DUPLICATE_RECORDS');
363: fnd_message.raise_error;
364:
365: hr_utility.set_location(l_proc, 20);
366: close multi_csn_dup_records;

Line 363: fnd_message.raise_error;

359: p_aei_information3);
360: fetch multi_csn_dup_records into l_invalid_record;
361: if multi_csn_dup_records%found then
362: fnd_message.set_name('PER','PER_7901_SYS_DUPLICATE_RECORDS');
363: fnd_message.raise_error;
364:
365: hr_utility.set_location(l_proc, 20);
366: close multi_csn_dup_records;
367: else

Line 377: fnd_message.set_name('PAY','HR_78429_SG_CSN_SAME_PAY');

373: p_aei_information2,
374: p_aei_information3);
375: fetch multi_csn_dup_records_p into l_invalid_record;
376: if multi_csn_dup_records_p%found then
377: fnd_message.set_name('PAY','HR_78429_SG_CSN_SAME_PAY');
378: fnd_message.raise_error;
379:
380: hr_utility.set_location(l_proc, 30);
381: end if;

Line 378: fnd_message.raise_error;

374: p_aei_information3);
375: fetch multi_csn_dup_records_p into l_invalid_record;
376: if multi_csn_dup_records_p%found then
377: fnd_message.set_name('PAY','HR_78429_SG_CSN_SAME_PAY');
378: fnd_message.raise_error;
379:
380: hr_utility.set_location(l_proc, 30);
381: end if;
382: close multi_csn_dup_records_p;

Line 387: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');

383: end if;
384: close multi_csn_dup_records;
385:
386: if fnd_date.canonical_to_date(p_aei_information3) < fnd_date.canonical_to_date(p_aei_information2) then
387: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
388: fnd_message.set_token('DATE1', 'End Date');
389: fnd_message.set_token('DATE2', 'Start Date');
390: fnd_message.raise_error;
391: end if;

Line 388: fnd_message.set_token('DATE1', 'End Date');

384: close multi_csn_dup_records;
385:
386: if fnd_date.canonical_to_date(p_aei_information3) < fnd_date.canonical_to_date(p_aei_information2) then
387: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
388: fnd_message.set_token('DATE1', 'End Date');
389: fnd_message.set_token('DATE2', 'Start Date');
390: fnd_message.raise_error;
391: end if;
392:

Line 389: fnd_message.set_token('DATE2', 'Start Date');

385:
386: if fnd_date.canonical_to_date(p_aei_information3) < fnd_date.canonical_to_date(p_aei_information2) then
387: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
388: fnd_message.set_token('DATE1', 'End Date');
389: fnd_message.set_token('DATE2', 'Start Date');
390: fnd_message.raise_error;
391: end if;
392:
393: end if;

Line 390: fnd_message.raise_error;

386: if fnd_date.canonical_to_date(p_aei_information3) < fnd_date.canonical_to_date(p_aei_information2) then
387: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
388: fnd_message.set_token('DATE1', 'End Date');
389: fnd_message.set_token('DATE2', 'Start Date');
390: fnd_message.raise_error;
391: end if;
392:
393: end if;
394: --