APPS.IGS_ST_GVT_SPSHT_CTL_PKG dependencies on IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

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;
41: END IF;

Line 78: IGS_GE_MSG_STACK.ADD;

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 (
82: new_references.submission_yr,

Line 86: IGS_GE_MSG_STACK.ADD;

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;
90: END AfterRowInsertUpdate1;

Line 104: IGS_GE_MSG_STACK.ADD;

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;
108:

Line 208: IGS_GE_MSG_STACK.ADD;

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;
212: Close cur_rowid;

Line 233: IGS_GE_MSG_STACK.ADD;

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;
237: IF upper(column_name) = 'SUBMISSION_NUMBER' OR column_name IS NULL THEN

Line 240: IGS_GE_MSG_STACK.ADD;

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;
244:

Line 288: IGS_GE_MSG_STACK.ADD;

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;
292: Check_Parent_Existance;

Line 310: IGS_GE_MSG_STACK.ADD;

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;
314: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 389: IGS_GE_MSG_STACK.ADD;

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:
393: Before_DML (

Line 475: IGS_GE_MSG_STACK.ADD;

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;
479: end if;

Line 492: IGS_GE_MSG_STACK.ADD;

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;
496: end LOCK_ROW;

Line 529: IGS_GE_MSG_STACK.ADD;

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:
533: Before_DML (