DBA Data[Home] [Help]

APPS.IGS_FI_REFUND_INT_PKG dependencies on IGS_GE_MSG_STACK

Line 81: igs_ge_msg_stack.add;

77: FETCH cur_old_ref_values INTO old_references;
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;

Line 167: igs_ge_msg_stack.add;

163: ELSIF NOT igs_fi_refunds_pkg.get_pk_for_validation (
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

Line 180: igs_ge_msg_stack.add;

176: FETCH cur_hzp INTO l_var;
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;

Line 195: igs_ge_msg_stack.add;

191: FETCH cur_hzp INTO l_var;
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;

Line 214: igs_ge_msg_stack.add;

210: new_references.fee_cal_type,
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

Line 225: igs_ge_msg_stack.add;

221: ELSIF NOT igs_fi_acc_pkg.get_pk_for_validation (
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

Line 236: igs_ge_msg_stack.add;

232: ELSIF NOT igs_fi_acc_pkg.get_pk_for_validation (
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

Line 247: igs_ge_msg_stack.add;

243: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (
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

Line 258: igs_ge_msg_stack.add;

254: ELSIF NOT igs_fi_refund_int_pkg.get_pk_for_validation (
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;

Line 345: igs_ge_msg_stack.add;

341: FETCH cur_rowid INTO lv_rowid;
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;

Line 380: igs_ge_msg_stack.add;

376: FETCH cur_rowid INTO lv_rowid;
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;

Line 415: igs_ge_msg_stack.add;

411: FETCH cur_rowid INTO lv_rowid;
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;

Line 537: igs_ge_msg_stack.add;

533: new_references.refund_id
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

Line 554: igs_ge_msg_stack.add;

550: new_references.refund_id
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;

Line 659: igs_ge_msg_stack.add;

655: x_program_update_date := SYSDATE;
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

Line 923: igs_ge_msg_stack.add;

919: OPEN c1;
920: FETCH c1 INTO tlinfo;
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;

Line 971: igs_ge_msg_stack.add;

967: ) THEN
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;

Line 1056: igs_ge_msg_stack.add;

1052: x_last_update_login := -1;
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(