DBA Data[Home] [Help]

APPS.IGS_FI_REFUND_INT_PKG dependencies on APP_EXCEPTION

Line 82: app_exception.raise_exception;

78: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
79: CLOSE cur_old_ref_values;
80: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
81: igs_ge_msg_stack.add;
82: app_exception.raise_exception;
83: RETURN;
84: END IF;
85: CLOSE cur_old_ref_values;
86:

Line 168: app_exception.raise_exception;

164: new_references.refund_id
165: ) THEN
166: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
167: igs_ge_msg_stack.add;
168: app_exception.raise_exception;
169: END IF;
170:
171: IF (((old_references.person_id = new_references.person_id)) OR
172: ((new_references.person_id IS NULL))) THEN

Line 181: app_exception.raise_exception;

177: IF cur_hzp%NOTFOUND THEN
178: CLOSE cur_hzp;
179: fnd_message.set_name('FND','FORM_RECORD_DELETED');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END IF;
183: CLOSE cur_hzp;
184: END IF;
185:

Line 196: app_exception.raise_exception;

192: IF cur_hzp%NOTFOUND THEN
193: CLOSE cur_hzp;
194: fnd_message.set_name('FND','FORM_RECORD_DELETED');
195: igs_ge_msg_stack.add;
196: app_exception.raise_exception;
197: END IF;
198: CLOSE cur_hzp;
199: END IF;
200:

Line 215: app_exception.raise_exception;

211: new_references.fee_ci_sequence_number
212: ) THEN
213: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
214: igs_ge_msg_stack.add;
215: app_exception.raise_exception;
216: END IF;
217:
218: IF (((old_references.dr_account_cd = new_references.dr_account_cd)) OR
219: ((new_references.dr_account_cd IS NULL))) THEN

Line 226: app_exception.raise_exception;

222: new_references.dr_account_cd
223: ) THEN
224: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: END IF;
228:
229: IF (((old_references.cr_account_cd = new_references.cr_account_cd)) OR
230: ((new_references.cr_account_cd IS NULL))) THEN

Line 237: app_exception.raise_exception;

233: new_references.cr_account_cd
234: ) THEN
235: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239:
240: IF (((old_references.invoice_id = new_references.invoice_id)) OR
241: ((new_references.invoice_id IS NULL))) THEN

Line 248: app_exception.raise_exception;

244: new_references.invoice_id
245: ) THEN
246: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250:
251: IF (((old_references.source_refund_id = new_references.source_refund_id)) OR
252: ((new_references.source_refund_id IS NULL))) THEN

Line 259: app_exception.raise_exception;

255: new_references.source_refund_id
256: ) THEN
257: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END IF;
261:
262: END check_parent_existance;
263:

Line 346: app_exception.raise_exception;

342: IF (cur_rowid%FOUND) THEN
343: CLOSE cur_rowid;
344: fnd_message.set_name ('IGS', 'IGS_FI_RFND_RINT_FK');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: RETURN;
348: END IF;
349: CLOSE cur_rowid;
350:

Line 381: app_exception.raise_exception;

377: IF (cur_rowid%FOUND) THEN
378: CLOSE cur_rowid;
379: fnd_message.set_name ('IGS', 'IGS_FI_INV_RINT_FK');
380: igs_ge_msg_stack.add;
381: app_exception.raise_exception;
382: RETURN;
383: END IF;
384: CLOSE cur_rowid;
385:

Line 416: app_exception.raise_exception;

412: IF (cur_rowid%FOUND) THEN
413: CLOSE cur_rowid;
414: fnd_message.set_name ('IGS', 'IGS_FI_RINT_RINT_FK');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: RETURN;
418: END IF;
419: CLOSE cur_rowid;
420:

Line 538: app_exception.raise_exception;

534: )
535: ) THEN
536: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540: check_parent_existance;
541: ELSIF (p_action = 'UPDATE') THEN
542: -- Call all the procedures related to Before Update.

Line 555: app_exception.raise_exception;

551: )
552: ) THEN
553: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557: ELSIF (p_action = 'VALIDATE_DELETE') THEN
558: check_child_existance;
559: END IF;

Line 660: app_exception.raise_exception;

656: END IF;
657: ELSE
658: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
659: igs_ge_msg_stack.add;
660: app_exception.raise_exception;
661: END IF;
662:
663: -- Org Id is set to NULL, instead of inserting the value of
664: -- ar_int_org_id from igs_fi_control

Line 925: app_exception.raise_exception;

921: IF (c1%notfound) THEN
922: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
923: igs_ge_msg_stack.add;
924: CLOSE c1;
925: app_exception.raise_exception;
926: RETURN;
927: END IF;
928: CLOSE c1;
929:

Line 972: app_exception.raise_exception;

968: NULL;
969: ELSE
970: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
971: igs_ge_msg_stack.add;
972: app_exception.raise_exception;
973: END IF;
974:
975: RETURN;
976:

Line 1057: app_exception.raise_exception;

1053: END IF;
1054: ELSE
1055: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1056: igs_ge_msg_stack.add;
1057: app_exception.raise_exception;
1058: END IF;
1059:
1060: before_dml(
1061: p_action => 'UPDATE',