[Home] [Help]
58: OPEN cur_old_ref_values;
59: FETCH cur_old_ref_values INTO old_references;
60: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
61: CLOSE cur_old_ref_values;
62: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
63: igs_ge_msg_stack.add;
64: app_exception.raise_exception;
65: RETURN;
66: END IF;
119: ELSE
120: IF NOT IGS_FI_ACC_PKG.Get_PK_For_Validation (
121: new_references.cr_account_cd
122: ) THEN
123: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
131: ELSE
132: IF NOT IGS_FI_ACC_PKG.Get_PK_For_Validation (
133: new_references.dr_account_cd
134: ) THEN
135: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
144: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
145: 'IGS_FI_APPLICATION_TYPE',
146: new_references.application_type
147: )THEN
148: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152:
155: NULL;
156: ELSIF NOT igs_fi_credits_pkg.get_pk_for_validation (
157: new_references.credit_id
158: ) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: END IF;
163:
166: NULL;
167: ELSIF NOT igs_fi_cr_activities_pkg.get_pk_for_validation (
168: new_references.credit_activity_id
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
177: NULL;
178: ELSIF NOT igs_fi_posting_int_pkg.get_pk_for_validation (
179: new_references.posting_id
180: ) THEN
181: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: END IF;
185:
188: NULL;
189: ELSIF NOT igs_fi_a_hierarchies_pkg.get_pk_for_validation (
190: new_references.appl_hierarchy_id
191: ) THEN
192: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: END IF;
196:
199: NULL;
200: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (
201: new_references.invoice_id
202: ) THEN
203: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
210: NULL;
211: ELSIF NOT igs_fi_invln_int_pkg.get_pk_for_validation (
212: new_references.applied_invoice_lines_id
213: ) THEN
214: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218:
278: OPEN cur_rowid;
279: FETCH cur_rowid INTO lv_rowid;
280: IF (cur_rowid%FOUND) THEN
281: CLOSE cur_rowid;
282: fnd_message.set_name ('IGS', 'IGS_FI_APPL_CRDT_FK');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: RETURN;
286: END IF;
313: OPEN cur_rowid;
314: FETCH cur_rowid INTO lv_rowid;
315: IF (cur_rowid%FOUND) THEN
316: CLOSE cur_rowid;
317: fnd_message.set_name ('IGS', 'IGS_FI_APPL_CRAC_FK');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: RETURN;
321: END IF;
348: OPEN cur_rowid;
349: FETCH cur_rowid INTO lv_rowid;
350: IF (cur_rowid%FOUND) THEN
351: CLOSE cur_rowid;
352: fnd_message.set_name ('IGS', 'IGS_FI_APPL_PINT_FK');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: RETURN;
356: END IF;
383: OPEN cur_rowid;
384: FETCH cur_rowid INTO lv_rowid;
385: IF (cur_rowid%FOUND) THEN
386: CLOSE cur_rowid;
387: fnd_message.set_name ('IGS', 'IGS_FI_APPL_APHR_FK');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: RETURN;
391: END IF;
418: OPEN cur_rowid;
419: FETCH cur_rowid INTO lv_rowid;
420: IF (cur_rowid%FOUND) THEN
421: CLOSE cur_rowid;
422: fnd_message.set_name ('IGS', 'IGS_FI_APPL_INVI_FK');
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: RETURN;
426: END IF;
453: OPEN cur_rowid;
454: FETCH cur_rowid INTO lv_rowid;
455: IF (cur_rowid%FOUND) THEN
456: CLOSE cur_rowid;
457: fnd_message.set_name ('IGS', 'IGS_FI_APPL_INLI_FK');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: RETURN;
461: END IF;
539: IF ( get_pk_for_validation(
540: new_references.application_id
541: )
542: ) THEN
543: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
544: igs_ge_msg_stack.add;
545: app_exception.raise_exception;
546: END IF;
547: check_parent_existance;
553: IF ( get_pk_for_validation (
554: new_references.application_id
555: )
556: ) THEN
557: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
558: igs_ge_msg_stack.add;
559: app_exception.raise_exception;
560: END IF;
561: END IF;
636: ELSE
637: x_program_update_date := SYSDATE;
638: END IF;
639: ELSE
640: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644:
804:
805: OPEN c1;
806: FETCH c1 INTO tlinfo;
807: IF (c1%notfound) THEN
808: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
809: igs_ge_msg_stack.add;
810: CLOSE c1;
811: app_exception.raise_exception;
812: RETURN;
833: AND ((tlinfo.posting_control_id = x_posting_control_id) OR ((tlinfo.posting_control_id IS NULL) AND (X_posting_control_id IS NULL)))
834: ) THEN
835: NULL;
836: ELSE
837: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
838: igs_ge_msg_stack.add;
839: app_exception.raise_exception;
840: END IF;
841:
900: IF (x_last_update_login IS NULL) THEN
901: x_last_update_login := -1;
902: END IF;
903: ELSE
904: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
905: igs_ge_msg_stack.add;
906: app_exception.raise_exception;
907: END IF;
908: