[Home] [Help]
80: Fetch cur_old_ref_values INTO old_references;
81: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
82: Close cur_old_ref_values;
83: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: Return;
87: END IF;
88: Close cur_old_ref_values;
170: IF Upper(Column_Name) = 'STATUS' OR
171: Column_Name IS NULL THEN
172: IF NOT (new_references.status IN ('O', 'E', 'I')) THEN
173: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: END IF;
178:
204: ,new_references.uoo_id,
205: new_references.org_unit_cd
206: ) THEN
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
208: IGS_GE_MSG_STACK.ADD;
209: app_exception.raise_exception;
210: END IF;
211: END Check_Uniqueness ;
212:
230: NULL;
231: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('CHG_METHOD',
232: new_references.s_chg_method_type) THEN
233: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237:
238: IF ((old_references.person_id = new_references.person_id) AND
242: IF NOT IGS_FI_FEE_AS_PKG.Get_PK_For_Validation (
243: new_references.person_id,
244: new_references.transaction_id) THEN
245: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;
250:
257: IF NOT igs_en_unit_set_pkg.Get_PK_For_Validation (
258: new_references.unit_set_cd,
259: new_references.us_version_number) THEN
260: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;
265:
323: Fetch cur_rowid INTO lv_rowid;
324: IF (cur_rowid%FOUND) THEN
325: Close cur_rowid;
326: Fnd_Message.Set_Name ('IGS', 'IGS_FI_AITM_FAS_FK');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: Return;
330: END IF;
331: Close cur_rowid;
508: Null;
509: IF Get_Pk_For_Validation(
510: new_references.fee_ass_item_id) THEN
511: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
512: IGS_GE_MSG_STACK.ADD;
513: App_Exception.Raise_Exception;
514: END IF;
515: Check_Uniqueness;
516: Check_Constraints;
529: -- Call all the procedures related to Before Insert.
530: IF Get_PK_For_Validation (
531: new_references.fee_ass_item_id) THEN
532: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
533: IGS_GE_MSG_STACK.ADD;
534: App_Exception.Raise_Exception;
535: END IF;
536: Check_Uniqueness;
537: Check_Constraints;
651: X_LAST_UPDATE_LOGIN := -1;
652: end if;
653: else
654: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
655: IGS_GE_MSG_STACK.ADD;
656: app_exception.raise_exception;
657: end if;
658: ----------------------------------
659: SELECT igs_fi_fee_as_items_s.nextval
916: open c1;
917: fetch c1 into tlinfo;
918: if (c1%notfound) then
919: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
920: IGS_GE_MSG_STACK.ADD;
921: close c1;
922: app_exception.raise_exception;
923: return;
924: end if;
1008: ) THEN
1009: NULL;
1010: ELSE
1011: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1012: igs_ge_msg_stack.add;
1013: app_exception.raise_exception;
1014: END IF;
1015: RETURN;
1016: END lock_row;
1089: X_LAST_UPDATE_LOGIN := -1;
1090: end if;
1091: else
1092: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1093: IGS_GE_MSG_STACK.ADD;
1094: app_exception.raise_exception;
1095: end if;
1096: Before_DML(
1097: p_action=>'UPDATE',
1405: FETCH cur_rowid INTO lv_rowid;
1406: IF (cur_rowid%FOUND) THEN
1407: CLOSE cur_rowid;
1408: fnd_message.set_name('IGS', 'IGS_FI_FAI_EUS_FK');
1409: igs_ge_msg_stack.add;
1410: app_exception.raise_exception;
1411: RETURN;
1412: END IF;
1413: CLOSE cur_rowid;