DBA Data[Home] [Help]

APPS.IGS_FI_CREDITS_PKG dependencies on IGS_GE_MSG_STACK

Line 124: igs_ge_msg_stack.add;

120: FETCH cur_old_ref_values INTO old_references;
121: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
122: CLOSE cur_old_ref_values;
123: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: RETURN;
127: END IF;
128: CLOSE cur_old_ref_values;

Line 229: igs_ge_msg_stack.add;

225: fnd_message.set_name('IGS','IGS_FI_REV_DT_LESS_RECT_DT');
226: fnd_message.set_token('REVDATE',TRUNC(new_references.reversal_date));
227: fnd_message.set_token('PMTDATE',TRUNC(new_references.transaction_date));
228: fnd_message.set_token('CREDIT',new_references.credit_number);
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232: END IF;
233: END BeforeRowInsertUpdate;

Line 255: igs_ge_msg_stack.add;

251: new_references.party_id
252: )
253: ) THEN
254: fnd_message.set_name ('IGS', 'IGS_FI_CREDIT_DUPLICATE');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258:
259: END check_uniqueness;

Line 322: igs_ge_msg_stack.add;

318: CLOSE cur_rowid;
319: ELSE
320: CLOSE cur_rowid;
321: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: END IF;
326:

Line 335: IGS_GE_MSG_STACK.ADD;

331: 'IGS_FI_CREDIT_STATUS',
332: new_references.status
333: )THEN
334: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338:
339: IF (((old_references.credit_source = new_references.credit_source)) OR

Line 350: igs_ge_msg_stack.add;

346: CLOSE cur_igf_lookup;
347: ELSE
348: CLOSE cur_igf_lookup;
349: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353: END IF;
354:

Line 363: IGS_GE_MSG_STACK.ADD;

359: 'IGS_FI_CREDIT_INSTRUMENT',
360: new_references.credit_instrument
361: )THEN
362: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: --Added the IGS_FI_WAV_REVERSAL_REASON lookup code validation as a part of Tution Waiver Build.
367: IF (((old_references.reversal_reason_code = new_references.reversal_reason_code)) OR

Line 374: IGS_GE_MSG_STACK.ADD;

370: ELSIF NOT ( IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_REVERSAL_REASON',new_references.reversal_reason_code)
371: OR IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_WAV_REVERSAL_REASON',new_references.reversal_reason_code)
372: )THEN
373: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377:
378: IF (((old_references.credit_type_id = new_references.credit_type_id)) OR

Line 385: igs_ge_msg_stack.add;

381: ELSIF NOT igs_fi_cr_types_pkg.get_pk_for_validation (
382: new_references.credit_type_id
383: ) THEN
384: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: --removed call to igs_fi_subaccts_pkg.get_pk_for_validation and related code as part of subaccount

Line 404: igs_ge_msg_stack.add;

400: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
401: new_references.awd_yr_cal_type , new_references.awd_yr_ci_sequence_number
402: ) THEN
403: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: IF (

Line 420: igs_ge_msg_stack.add;

416: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
417: new_references.fee_cal_type , new_references.fee_ci_sequence_number
418: ) THEN
419: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
420: igs_ge_msg_stack.add;
421: app_exception.raise_exception;
422: END IF;
423:
424: -- Following check of foreign key has been added as part of Deposits Build, Bug# 2584741

Line 433: IGS_GE_MSG_STACK.ADD;

429: 'IGS_FI_SOURCE_TRANSACTION_REF',
430: new_references.source_transaction_type
431: )THEN
432: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: App_Exception.Raise_Exception;
435: END IF;
436:
437: -- Following check of foreign key has been added as part of Lockbox Build, Enh#2831582.

Line 444: igs_ge_msg_stack.add;

440: ) THEN
441: NULL;
442: ELSIF NOT igs_fi_lockboxes_pkg.get_pk_for_validation(new_references.receipt_lockbox_number)THEN
443: fnd_message.set_name('FND','FORM_RECORD_DELETED');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447:
448: -- Source Invoice Id as a FK with igs_fi_inv_int_all

Line 455: igs_ge_msg_stack.add;

451: ) THEN
452: NULL;
453: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation(new_references.source_invoice_id) THEN
454: fnd_message.set_name('FND','FORM_RECORD_DELETED');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: END IF;
458:
459: END check_parent_existance;

Line 593: igs_ge_msg_stack.add;

589: FETCH cur_rowid INTO lv_rowid;
590: IF (cur_rowid%FOUND) THEN
591: CLOSE cur_rowid;
592: fnd_message.set_name ('IGS', 'IGS_FI_CRDT_CRTY_FK');
593: igs_ge_msg_stack.add;
594: app_exception.raise_exception;
595: RETURN;
596: END IF;
597: CLOSE cur_rowid;

Line 630: igs_ge_msg_stack.add;

626: FETCH cur_rowid INTO lv_rowid;
627: IF (cur_rowid%FOUND) THEN
628: CLOSE cur_rowid;
629: fnd_message.set_name ('IGS', 'IGS_FI_CRD_CI_FK');
630: igs_ge_msg_stack.add;
631: app_exception.raise_exception;
632: RETURN;
633: END IF;
634: CLOSE cur_rowid;

Line 666: igs_ge_msg_stack.add;

662: FETCH cur_rowid INTO lv_rowid;
663: IF (cur_rowid%FOUND) THEN
664: CLOSE cur_rowid;
665: fnd_message.set_name ('IGS', 'IGS_FI_FTCI_CI_FK');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception;
668: RETURN;
669: END IF;
670: CLOSE cur_rowid;

Line 860: igs_ge_msg_stack.add;

856: new_references.credit_id
857: )
858: ) THEN
859: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
860: igs_ge_msg_stack.add;
861: app_exception.raise_exception;
862: END IF;
863: BeforeRowInsertUpdate;
864: check_uniqueness;

Line 881: igs_ge_msg_stack.add;

877: new_references.credit_id
878: )
879: ) THEN
880: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
881: igs_ge_msg_stack.add;
882: app_exception.raise_exception;
883: END IF;
884: BeforeRowInsertUpdate;
885: check_uniqueness;

Line 1034: igs_ge_msg_stack.add;

1030: x_program_update_date := SYSDATE;
1031: END IF;
1032: ELSE
1033: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1034: igs_ge_msg_stack.add;
1035: app_exception.raise_exception;
1036: END IF;
1037:
1038: SELECT igs_fi_credits_s.NEXTVAL

Line 1451: igs_ge_msg_stack.add;

1447: OPEN c1;
1448: FETCH c1 INTO tlinfo;
1449: IF (c1%notfound) THEN
1450: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1451: igs_ge_msg_stack.add;
1452: CLOSE c1;
1453: app_exception.raise_exception;
1454: RETURN;
1455: END IF;

Line 1525: igs_ge_msg_stack.add;

1521: ) THEN
1522: NULL;
1523: ELSE
1524: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1525: igs_ge_msg_stack.add;
1526: app_exception.raise_exception;
1527: END IF;
1528:
1529: RETURN;

Line 1654: igs_ge_msg_stack.add;

1650: x_last_update_login := -1;
1651: END IF;
1652: ELSE
1653: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1654: igs_ge_msg_stack.add;
1655: app_exception.raise_exception;
1656: END IF;
1657:
1658: before_dml(