[Home] [Help]
58: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
59: CLOSE cur_old_ref_values;
60: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
61: igs_ge_msg_stack.add;
62: app_exception.raise_exception;
63: RETURN;
64: END IF;
65: CLOSE cur_old_ref_values;
66:
118: new_references.cr_account_cd
119: ) THEN
120: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125: IF ((old_references.dr_account_cd = new_references.dr_account_cd) OR
126: (new_references.dr_account_cd IS NULL)) THEN
130: new_references.dr_account_cd
131: ) THEN
132: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137:
138: IF (((old_references.status = new_references.status)) OR
143: new_references.status
144: )THEN
145: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: IF (((old_references.bill_id = new_references.bill_id)) OR
151: ((new_references.bill_id IS NULL))) THEN
154: new_references.bill_id
155: ) THEN
156: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160:
161: IF (((old_references.credit_id = new_references.credit_id)) OR
162: ((new_references.credit_id IS NULL))) THEN
165: new_references.credit_id
166: ) THEN
167: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;
171:
172: IF (((old_references.posting_id = new_references.posting_id)) OR
173: ((new_references.posting_id IS NULL))) THEN
176: new_references.posting_id
177: ) THEN
178: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182:
183: END check_parent_existance;
184:
272: IF (cur_rowid%FOUND) THEN
273: CLOSE cur_rowid;
274: fnd_message.set_name ('IGS', 'IGS_FI_CRAC_FBLLA_FK');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: RETURN;
278: END IF;
279: CLOSE cur_rowid;
280:
306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: fnd_message.set_name ('IGS', 'IGS_FI_CRAC_CRTY_FK');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: RETURN;
312: END IF;
313: CLOSE cur_rowid;
314:
341: IF (cur_rowid%FOUND) THEN
342: CLOSE cur_rowid;
343: fnd_message.set_name ('IGS', 'IGS_FI_CRAC_PINT_FK');
344: igs_ge_msg_stack.add;
345: app_exception.raise_exception;
346: RETURN;
347: END IF;
348: CLOSE cur_rowid;
349:
423: )
424: ) THEN
425: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429: check_parent_existance;
430: ELSIF (p_action = 'UPDATE') THEN
431: -- Call all the procedures related to Before Update.
440: )
441: ) THEN
442: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446: ELSIF (p_action = 'VALIDATE_DELETE') THEN
447: check_child_existance;
448: END IF;
523: END IF;
524: ELSE
525: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
530: SELECT igs_fi_cr_activities_s.NEXTVAL
531: INTO x_credit_activity_id
683: IF (c1%notfound) THEN
684: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
685: igs_ge_msg_stack.add;
686: CLOSE c1;
687: app_exception.raise_exception;
688: RETURN;
689: END IF;
690: CLOSE c1;
691:
709: NULL;
710: ELSE
711: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714: END IF;
715:
716: RETURN;
717:
774: END IF;
775: ELSE
776: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
777: igs_ge_msg_stack.add;
778: app_exception.raise_exception;
779: END IF;
780:
781: before_dml(
782: p_action => 'UPDATE',