[Home] [Help]
32: -- Populate Old Values.
33: Open cur_old_ref_values;
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;
73: IF IGS_ST_VAL_GSC.stap_val_gsc_sdt (
74: new_references.submission_yr,
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 (
81: IF IGS_ST_VAL_GSC.stap_val_gsc_sdt_upd (
82: new_references.submission_yr,
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;
99: ELSE
100: IF NOT IGS_EN_ST_SPSHT_CTL_PKG.Get_PK_For_Validation (
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;
203: Open cur_rowid;
204: Fetch cur_rowid INTO lv_rowid;
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;
228: END IF;
229:
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;
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
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;
283: IF GET_PK_FOR_VALIDATION(
284: new_references.submission_yr,
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;
305: IF GET_PK_FOR_VALIDATION(
306: new_references.submission_yr,
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;
384: else
385: X_PROGRAM_UPDATE_DATE := SYSDATE;
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:
470: begin
471: open c1;
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;
487: AND (X_COMPLETION_DT is null)))
488: ) then
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;
524: if X_LAST_UPDATE_LOGIN is NULL then
525: X_LAST_UPDATE_LOGIN := -1;
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: