[Home] [Help]
54: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
55: Close cur_old_ref_values;
56: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
57: IGS_GE_MSG_STACK.ADD;
58: App_Exception.Raise_Exception;
59: Return;
60: END IF;
61: Close cur_old_ref_values;
62:
119: Column_Name IS NULL THEN
120: IF NOT (new_references.include_ind IN ('Y','N')) THEN
121: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
126:
127: -- The following code checks for check constraints on the Columns.
129: Column_Name IS NULL THEN
130: IF NOT (new_references.mandatory_ind IN ('Y','N')) THEN
131: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137:
140: Column_Name IS NULL THEN
141: IF NOT (new_references.detail_level_ind IN ('Y','N')) THEN
142: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:
148:
165: ,new_references.category_name
166: ) THEN
167: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
168: IGS_GE_MSG_STACK.ADD;
169: app_exception.raise_exception;
170: END IF;
171: END Check_Uniqueness;
172:
173:
194: new_references.discrepancy_rule_cd
195: ) THEN
196: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200:
201: IF (((old_references.source_type_id = new_references.source_type_id)) OR
202: ((new_references.source_type_id IS NULL))) THEN
205: new_references.source_type_id
206: ) THEN
207: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: END IF;
211:
212: END Check_Parent_Existance;
213:
314: IF (cur_rowid%FOUND) THEN
315: Close cur_rowid;
316: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASRC_PST_FK');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: Return;
320: END IF;
321: Close cur_rowid;
322:
386: IF Get_Pk_For_Validation(
387: new_references.src_cat_id) THEN
388: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
389: IGS_GE_MSG_STACK.ADD;
390: App_Exception.Raise_Exception;
391: END IF;
392: Check_Uniqueness;
393: Check_Constraints;
394: Check_Parent_Existance;
407: IF Get_PK_For_Validation (
408: new_references.src_cat_id) THEN
409: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: Check_Uniqueness;
414: Check_Constraints;
415: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
509: end if;
510: else
511: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
512: IGS_GE_MSG_STACK.ADD;
513: app_exception.raise_exception;
514: end if;
515:
516: X_SRC_CAT_ID := -1;
517:
632: if (c1%notfound) then
633: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
634: IGS_GE_MSG_STACK.ADD;
635: close c1;
636: app_exception.raise_exception;
637: return;
638: end if;
639: close c1;
640: ----Removed the check for SS_IND,DISPLAY_SEQUENCE,SS_MANDATORY_IND ( pbondugu Bug #3032535)
657: null;
658: else
659: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
660: IGS_GE_MSG_STACK.ADD;
661: app_exception.raise_exception;
662: end if;
663: return;
664: end LOCK_ROW;
665: Procedure UPDATE_ROW (
708: end if;
709: else
710: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
711: IGS_GE_MSG_STACK.ADD;
712: app_exception.raise_exception;
713: end if;
714: Before_DML(
715: p_action=>'UPDATE',
716: x_rowid=>X_ROWID,