[Home] [Help]
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;
89:
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:
179: END Check_Constraints;
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:
213: PROCEDURE Check_Parent_Existance AS
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
239: (old_references.transaction_id = new_references.transaction_id)) THEN
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:
251: IF ( ((old_references.unit_set_cd = new_references.unit_set_cd)
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:
266: END Check_Parent_Existance;
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;
332:
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;
517: Check_Parent_Existance;
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;
538: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
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
660: INTO X_FEE_ASS_ITEM_ID
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;
925: close c1;
926: if ( (tlinfo.TRANSACTION_ID = X_TRANSACTION_ID)
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;
1017:
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',
1098: x_rowid=>X_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;
1414: END get_fk_igs_en_unit_set_all;