44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
94: new_references.fee_ci_sequence_number,
95: new_references.transaction_type
96: )
97: ) THEN
98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
126: new_references.fee_type,
127: new_references.fee_cal_type,
128: new_references.fee_ci_sequence_number
129: ) THEN
130: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
134: new_references.person_id
132: app_exception.raise_exception;
133: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
134: new_references.person_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
140: 'TRANSACTION_TYPE',
139: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
140: 'TRANSACTION_TYPE',
141: new_references.transaction_type
142: ) THEN
143: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147:
261: Open cur_rowid;
262: Fetch cur_rowid INTO lv_rowid;
263: IF (cur_rowid%FOUND) THEN
264: Close cur_rowid;
265: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FIMP_LKUPV_FK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
287: Open cur_rowid;
288: Fetch cur_rowid INTO lv_rowid;
289: IF (cur_rowid%FOUND) THEN
290: Close cur_rowid;
291: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FIMP_PE_FK');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: Return;
295: END IF;
346: IF ( get_pk_for_validation(
347: new_references.import_charges_id
348: )
349: ) THEN
350: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: check_uniqueness;
365: IF ( get_pk_for_validation (
366: new_references.import_charges_id
367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: check_uniqueness;
439: ELSE
440: x_program_update_date := SYSDATE;
441: END IF;
442: ELSE
443: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447:
548:
549: OPEN c1;
550: FETCH c1 INTO tlinfo;
551: IF (c1%notfound) THEN
552: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
553: igs_ge_msg_stack.add;
554: CLOSE c1;
555: app_exception.raise_exception;
556: RETURN;
565: AND (tlinfo.transaction_type = x_transaction_type)
566: ) THEN
567: NULL;
568: ELSE
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
619: IF (x_last_update_login IS NULL) THEN
620: x_last_update_login := -1;
621: END IF;
622: ELSE
623: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627: