[Home] [Help]
38: -- Populate Old Values.
39: Open cur_old_ref_values;
40: Fetch cur_old_ref_values INTO old_references;
41: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: Close cur_old_ref_values;
45: App_Exception.Raise_Exception;
46: Return;
106: new_references.ass_pattern_id,
107: new_references.ass_id,
108: new_references.uai_sequence_number,
109: v_message_name) = FALSE THEN
110: Fnd_Message.Set_Name('IGS', v_message_name);
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
165: new_references.ci_sequence_number,
166: new_references.ass_id,
167: new_references.uai_sequence_number
168: )THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
190: new_references.cal_type,
191: new_references.ci_sequence_number,
192: new_references.ass_pattern_id
193: ))THEN
194: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
220: END IF;
221: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR
222: column_name is null Then
223: IF new_references.ci_sequence_number < 1 AND new_references.ci_sequence_number > 999999 Then
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:
230: IF upper(column_name) = 'APPORTIONMENT_PERCENTAGE' OR
231: column_name is null Then
232: IF new_references.apportionment_percentage < 0 AND new_references.apportionment_percentage > 100 Then
233: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
237: END IF;
238: IF upper(column_name) = 'UAI_SEQUENCE_NUMBER' OR
239: column_name is null Then
240: IF new_references.uai_sequence_number < 1 AND new_references.uai_sequence_number > 999999 Then
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
245: END IF;
246: IF upper(column_name) = 'CAL_TYPE' OR
247: column_name is null Then
248: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
253: END IF;
254: IF upper(column_name) = 'UNIT_CD' OR
255: column_name is null Then
256: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;
326:
327: Open cur_rowid;
328: Fetch cur_rowid INTO lv_rowid;
329: IF (cur_rowid%FOUND) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UAPI_UAI_FK');
331: IGS_GE_MSG_STACK.ADD;
332: Close cur_rowid;
333: App_Exception.Raise_Exception;
334: Return;
360:
361: Open cur_rowid;
362: Fetch cur_rowid INTO lv_rowid;
363: IF (cur_rowid%FOUND) THEN
364: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UAPI_UAP_FK');
365: IGS_GE_MSG_STACK.ADD;
366: Close cur_rowid;
367: App_Exception.Raise_Exception;
368: Return;
419: new_references.ass_pattern_id ,
420: new_references.ass_id ,
421: new_references.uai_sequence_number
422: ) THEN
423: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
424: IGS_GE_MSG_STACK.ADD;
425: App_Exception.Raise_Exception;
426: END IF;
427: Check_Constraints;
443: new_references.ass_pattern_id ,
444: new_references.ass_id ,
445: new_references.uai_sequence_number
446: ) THEN
447: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451: Check_Constraints;
512: else
513: X_PROGRAM_UPDATE_DATE := SYSDATE;
514: end if;
515: else
516: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
517: IGS_GE_MSG_STACK.ADD;
518: app_exception.raise_exception;
519: end if;
520: --
607: begin
608: open c1;
609: fetch c1 into tlinfo;
610: if (c1%notfound) then
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
612: IGS_GE_MSG_STACK.ADD;
613: close c1;
614: app_exception.raise_exception;
615: return;
621: AND (X_APPORTIONMENT_PERCENTAGE is null)))
622: ) then
623: null;
624: else
625: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
626: IGS_GE_MSG_STACK.ADD;
627: app_exception.raise_exception;
628: end if;
629: return;
662: if X_LAST_UPDATE_LOGIN is NULL then
663: X_LAST_UPDATE_LOGIN := -1;
664: end if;
665: else
666: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
667: IGS_GE_MSG_STACK.ADD;
668: app_exception.raise_exception;
669: end if;
670: Before_DML(