DBA Data[Home] [Help]

APPS.IGS_AS_ASSESSMNT_ITM_PKG dependencies on IGS_GE_MSG_STACK

Line 74: IGS_GE_MSG_STACK.ADD;

70: Open cur_old_ref_values;
71: Fetch cur_old_ref_values INTO old_references;
72: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
74: IGS_GE_MSG_STACK.ADD;
75: Close cur_old_ref_values;
76: App_Exception.Raise_Exception;
77: Return;
78: END IF;

Line 157: IGS_GE_MSG_STACK.ADD;

153: -- Validate assessment type closed indicator
154: IF IGS_AS_VAL_AI.assp_val_atyp_closed(new_references.assessment_type,
155: v_message_name) = FALSE THEN
156: Fnd_Message.Set_Name('IGS', v_message_name);
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161: -- Validate that inserts/updates are allowed

Line 181: IGS_GE_MSG_STACK.ADD;

177: new_references.question_or_title,
178: new_references.ass_length_or_duration,
179: v_message_name) = FALSE THEN
180: Fnd_Message.Set_Name('IGS', v_message_name);
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: --
185: -- Validate exam times

Line 191: IGS_GE_MSG_STACK.ADD;

187: new_references.exam_working_time,
188: new_references.exam_perusal_time,
189: v_message_name) = FALSE THEN
190: Fnd_Message.Set_Name('IGS', v_message_name);
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194: END IF;
195:

Line 225: IGS_GE_MSG_STACK.ADD;

221: new_references.assessment_type,
222: v_message_name) = FALSE THEN
223: -- Error.
224: Fnd_Message.Set_Name('IGS', v_message_name);
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228:
229:

Line 253: IGS_GE_MSG_STACK.ADD;

249: IF NOT(IGS_AS_ASSESSMNT_TYP_PKG.Get_PK_For_Validation (
250: new_references.assessment_type
251: ))THEN
252: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256:
257: END IF;

Line 279: IGS_GE_MSG_STACK.ADD;

275: IF upper(column_name) = 'ASSESSMENT_TYPE' OR
276: column_name is null Then
277: IF new_references.assessment_type <> UPPER(new_references.assessment_type) Then
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
283:

Line 288: IGS_GE_MSG_STACK.ADD;

284: IF upper(column_name) = 'ASS_LENGTH_OR_DURATION' OR
285: column_name is null Then
286: IF new_references.ass_length_or_duration <> UPPER(new_references.ass_length_or_duration) Then
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: END IF;
292:

Line 297: IGS_GE_MSG_STACK.ADD;

293: IF upper(column_name) = 'EXAM_SCHEDULED_IND' OR
294: column_name is null Then
295: IF new_references.exam_scheduled_ind <> UPPER(new_references.exam_scheduled_ind) OR new_references.exam_scheduled_ind NOT IN ( 'Y' , 'N' ) Then
296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300: END IF;
301:

Line 376: IGS_GE_MSG_STACK.ADD;

372: Open cur_rowid;
373: Fetch cur_rowid INTO lv_rowid;
374: IF (cur_rowid%FOUND) THEN
375: Fnd_Message.Set_Name ('IGS', 'IGS_AS_AI_ATYP_FK');
376: IGS_GE_MSG_STACK.ADD;
377: Close cur_rowid;
378: App_Exception.Raise_Exception;
379: Return;
380: END IF;

Line 497: IGS_GE_MSG_STACK.ADD;

493: IF Get_PK_For_Validation (
494: new_references.ass_id
495: ) THEN
496: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
497: IGS_GE_MSG_STACK.ADD;
498: App_Exception.Raise_Exception;
499: END IF;
500:
501: Check_Constraints;

Line 517: IGS_GE_MSG_STACK.ADD;

513: IF Get_PK_For_Validation (
514: new_references.ass_id
515: ) THEN
516: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
517: IGS_GE_MSG_STACK.ADD;
518: App_Exception.Raise_Exception;
519: END IF;
520: Check_Constraints;
521: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 597: IGS_GE_MSG_STACK.ADD;

593: X_LAST_UPDATE_LOGIN := -1;
594: end if;
595: else
596: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600: Before_DML(
601: p_action=>'INSERT',

Line 851: IGS_GE_MSG_STACK.ADD;

847: open c1;
848: fetch c1 into tlinfo;
849: if (c1%notfound) then
850: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
851: IGS_GE_MSG_STACK.ADD;
852: close c1;
853: app_exception.raise_exception;
854: return;
855: end if;

Line 931: IGS_GE_MSG_STACK.ADD;

927: ) then
928: null;
929: else
930: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
931: IGS_GE_MSG_STACK.ADD;
932: app_exception.raise_exception;
933: end if;
934: return;
935: end LOCK_ROW;

Line 1000: IGS_GE_MSG_STACK.ADD;

996: X_LAST_UPDATE_LOGIN := -1;
997: end if;
998: else
999: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1000: IGS_GE_MSG_STACK.ADD;
1001: app_exception.raise_exception;
1002: end if;
1003: Before_DML(
1004: p_action=>'UPDATE',