[Home] [Help]
43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
196: IF ( get_pk_for_validation(
197: new_references.refund_setup_id
198: )
199: ) THEN
200: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204:
203: END IF;
204:
205: --Start date should be greater then sysdate date.
206: IF new_references.start_date < l_sysdate THEN
207: fnd_message.set_name('IGS','IGS_FI_EFF_DATE');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210:
211: END IF;
212:
213: --End date should be greater then sysdate date.
214: IF new_references.end_date IS NOT NULL THEN
215: IF new_references.end_date < l_sysdate THEN
216: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_SD');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: END IF;
220: END IF;
222: --upper limit should be positive.
223:
224: IF new_references.amount_high IS NOT NULL THEN
225: IF new_references.amount_high < 0 THEN
226: fnd_message.set_name('IGS','IGS_FI_REFUND_AMNT_NEGATIVE');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230: END IF;
231:
232: --lower limit should be positive.
233: IF new_references.amount_low IS NOT NULL THEN
234: IF new_references.amount_low < 0 THEN
235: fnd_message.set_name('IGS','IGS_FI_REFUND_AMNT_NEGATIVE');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: END IF;
240:
241: --start date should be lesser than end date
242: IF new_references.end_date IS NOT NULL THEN
243: IF new_references.end_date < new_references.start_date THEN
244: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_ST_DT');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: END IF;
248: END IF;
248: END IF;
249:
250: --Upper and lower limit both should not be null.
251: IF new_references.amount_high IS NULL AND new_references.amount_low IS NULL THEN
252: fnd_message.set_name('IGS','IGS_FI_REFUND_LMT_NULL');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: ELSE
256: --lower limit should be less than upper limit.
256: --lower limit should be less than upper limit.
257: IF new_references.amount_high IS NOT NULL AND new_references.amount_low IS NOT NULL THEN
258: IF new_references.amount_low > new_references.amount_high THEN
259:
260: fnd_message.set_name('IGS','IGS_FI_RFND_AMNT_INVALID');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;
271: new_references.refund_setup_id
272: )
273: ) THEN
274: -- Removed the space after the message name as per Bug# 2684818 by shtatiko
275: fnd_message.set_name('IGS','IGS_FI_RFND_TOL_OVERLAP');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: END IF;
279:
283:
284: --start date should be lesser than end date
285: IF new_references.end_date IS NOT NULL THEN
286: IF new_references.end_date < new_references.start_date THEN
287: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_ST_DT');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291: END IF;
293:
294: --End date should be greater then sysdate date.
295: IF new_references.end_date IS NOT NULL THEN
296: IF new_references.end_date < l_sysdate THEN
297: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_SD');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: END IF;
301: END IF;
307: new_references.end_date,
308: new_references.refund_setup_id
309: )
310: ) THEN
311: fnd_message.set_name('IGS','IGS_FI_RFND_TOL_OVERLAP');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315:
412: IF (x_last_update_login IS NULL) THEN
413: x_last_update_login := -1;
414: END IF;
415: ELSE
416: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
505:
506: OPEN c1;
507: FETCH c1 INTO tlinfo;
508: IF (c1%notfound) THEN
509: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
510: igs_ge_msg_stack.add;
511: CLOSE c1;
512: app_exception.raise_exception;
513: RETURN;
521: AND ((tlinfo.amount_low = x_amount_low) OR ((tlinfo.amount_low IS NULL) AND (X_amount_low IS NULL)))
522: ) THEN
523: NULL;
524: ELSE
525: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
569: IF (x_last_update_login IS NULL) THEN
570: x_last_update_login := -1;
571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577: