[Home] [Help]
34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Close cur_old_ref_values;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
75: new_references.ess_snapshot_dt_time,
76: v_message_name) = FALSE THEN
77: FND_MESSAGE.SET_NAME('IGS',v_message_name);
78: IGS_GE_MSG_STACK.ADD;
79: APP_EXCEPTION.RAISE_EXCEPTION;
80: END IF;
81: IF IGS_ST_VAL_GSC.stap_val_gsc_sdt_upd (
82: new_references.submission_yr,
83: new_references.submission_number,
83: new_references.submission_number,
84: v_message_name) = FALSE THEN
85: FND_MESSAGE.SET_NAME('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: APP_EXCEPTION.RAISE_EXCEPTION;
88: END IF;
89: END IF;
90: END AfterRowInsertUpdate1;
91:
101: new_references.ess_snapshot_dt_time
102: )THEN
103: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
104: IGS_GE_MSG_STACK.ADD;
105: APP_EXCEPTION.RAISE_EXCEPTION;
106: END IF;
107: END IF;
108:
109: END Check_Parent_Existance;
205: IF (cur_rowid%FOUND) THEN
206: Close cur_rowid;
207: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSC_ESSC_FK');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: Return;
211: END IF;
212: Close cur_rowid;
213:
230: IF upper(column_name) = 'SUBMISSION_YR' OR column_name IS NULL THEN
231: IF new_references.submission_yr < 0 OR new_references.submission_yr > 9999 THEN
232: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
233: IGS_GE_MSG_STACK.ADD;
234: APP_EXCEPTION.RAISE_EXCEPTION;
235: END IF;
236: END IF;
237: IF upper(column_name) = 'SUBMISSION_NUMBER' OR column_name IS NULL THEN
238: IF new_references.submission_number < 1 OR new_references.submission_number > 3 THEN
237: IF upper(column_name) = 'SUBMISSION_NUMBER' OR column_name IS NULL THEN
238: IF new_references.submission_number < 1 OR new_references.submission_number > 3 THEN
239: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
240: IGS_GE_MSG_STACK.ADD;
241: APP_EXCEPTION.RAISE_EXCEPTION;
242: END IF;
243: END IF;
244:
245: END CHECK_CONSTRAINTS;
285: new_references.submission_number
286: )THEN
287: FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
288: IGS_GE_MSG_STACK.ADD;
289: APP_EXCEPTION.RAISE_EXCEPTION;
290: END IF;
291: Check_Constraints;
292: Check_Parent_Existance;
293: ELSIF (p_action = 'UPDATE') THEN
307: new_references.submission_number
308: )THEN
309: FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
310: IGS_GE_MSG_STACK.ADD;
311: APP_EXCEPTION.RAISE_EXCEPTION;
312: END IF;
313: Check_Constraints;
314: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
315: -- Call all the procedures related to Before Delete.
386: end if;
387: else
388: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
389: IGS_GE_MSG_STACK.ADD;
390: app_exception.raise_exception;
391: end if;
392:
393: Before_DML (
394: p_action =>'INSERT',
472: fetch c1 into tlinfo;
473: if (c1%notfound) then
474: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: close c1;
478: return;
479: end if;
480: close c1;
489: null;
490: else
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: return;
496: end LOCK_ROW;
497:
526: end if;
527: else
528: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
529: IGS_GE_MSG_STACK.ADD;
530: app_exception.raise_exception;
531: end if;
532:
533: Before_DML (
534: p_action =>'UPDATE',