[Home] [Help]
41: Open cur_old_ref_values;
42: Fetch cur_old_ref_values INTO old_references;
43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
44: Close cur_old_ref_values;
45: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
46: IGS_GE_MSG_STACK.ADD;
47: App_Exception.Raise_Exception;
48: Return;
49: END IF;
101:
102: IF upper(column_name) = 'PERCENTAGE' OR
103: column_name is null Then
104: IF new_references.percentage < 000.01 OR new_references.percentage > 100.00 Then
105: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:
111: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR
112: column_name is null Then
113: IF new_references.ci_sequence_number < 1 OR new_references.ci_sequence_number > 999999 Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119:
120: IF upper(column_name) = 'CAL_TYPE' OR
121: column_name is null Then
122: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: IF upper(column_name) = 'LOCATION_CD' OR
130: column_name is null Then
131: IF new_references.location_cd <> UPPER(new_references.location_cd) Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137:
138: IF upper(column_name) = 'UNIT_CLASS' OR
139: column_name is null Then
140: IF new_references.unit_class <> UPPER(new_references.unit_class) Then
141: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:
147: IF upper(column_name) = 'UNIT_CD' OR
148: column_name is null Then
149: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
150: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
167: IF NOT IGS_OR_UNIT_PKG.Get_PK_For_Validation (
168: new_references.org_unit_cd,
169: new_references.ou_start_dt
170: ) THEN
171: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
195: new_references.ci_sequence_number,
196: new_references.location_cd,
197: new_references.unit_class
198: ) THEN
199: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
263: Open cur_rowid;
264: Fetch cur_rowid INTO lv_rowid;
265: IF (cur_rowid%FOUND) THEN
266: Close cur_rowid;
267: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TROH_OU_FK');
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: Return;
271: END IF;
299: Open cur_rowid;
300: Fetch cur_rowid INTO lv_rowid;
301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TROH_UOO_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;
369: new_references.org_unit_cd,
370: new_references.ou_start_dt,
371: new_references.hist_start_dt
372: ) THEN
373: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;
393: new_references.org_unit_cd,
394: new_references.ou_start_dt,
395: new_references.hist_start_dt
396: ) THEN
397: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
398: IGS_GE_MSG_STACK.ADD;
399: App_Exception.Raise_Exception;
400: END IF;
401: Check_Constraints;
460: if X_LAST_UPDATE_LOGIN is NULL then
461: X_LAST_UPDATE_LOGIN := -1;
462: end if;
463: else
464: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: end if;
468:
571: open c1;
572: fetch c1 into tlinfo;
573: if (c1%notfound) then
574: close c1;
575: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: return;
579: end if;
584: AND (tlinfo.PERCENTAGE = X_PERCENTAGE)
585: ) then
586: null;
587: else
588: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
589: IGS_GE_MSG_STACK.ADD;
590: app_exception.raise_exception;
591: end if;
592: return;
625: if X_LAST_UPDATE_LOGIN is NULL then
626: X_LAST_UPDATE_LOGIN := -1;
627: end if;
628: else
629: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
630: IGS_GE_MSG_STACK.ADD;
631: app_exception.raise_exception;
632: end if;
633: Before_DML(