DBA Data[Home] [Help]

APPS.IGS_AS_EXM_LOC_SPVSR_PKG dependencies on FND_MESSAGE

Line 34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

30: -- Populate Old Values.
31: Open cur_old_ref_values;
32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: Close cur_old_ref_values;
37: APP_EXCEPTION.RAISE_EXCEPTION;
38:

Line 69: FND_MESSAGE.SET_NAME('IGS',v_message_name);

65: BEGIN
66: -- Validate that the location is an exam location (ie. type of 'EXAM_CTR')
67: IF IGS_AS_VAL_ELS.assp_val_ve_lot(new_references.exam_location_cd,
68: v_message_name) = FALSE THEN
69: FND_MESSAGE.SET_NAME('IGS',v_message_name);
70: IGS_GE_MSG_STACK.ADD;
71: APP_EXCEPTION.RAISE_EXCEPTION;
72: END IF;
73: -- Validate that the exam location is not closed.

Line 76: FND_MESSAGE.SET_NAME('IGS',v_message_name);

72: END IF;
73: -- Validate that the exam location is not closed.
74: IF IGS_AS_VAL_ELS.orgp_val_loc_closed(new_references.exam_location_cd,
75: v_message_name) = FALSE THEN
76: FND_MESSAGE.SET_NAME('IGS',v_message_name);
77: IGS_GE_MSG_STACK.ADD;
78: APP_EXCEPTION.RAISE_EXCEPTION;
79: END IF;
80:

Line 93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

89: NULL;
90: ELSIF NOT IGS_AS_EXM_SUPRVISOR_PKG.Get_PK_For_Validation (
91: new_references.person_id
92: ) THEN
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: APP_EXCEPTION.RAISE_EXCEPTION;
96:
97: END IF;

Line 106: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

102: ELSIF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
103: new_references.exam_location_cd ,
104: 'N'
105: ) THEN
106: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
107: IGS_GE_MSG_STACK.ADD;
108: APP_EXCEPTION.RAISE_EXCEPTION;
109:
110: END IF;

Line 159: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ELS_ESU_FK');

155:
156: Open cur_rowid;
157: Fetch cur_rowid INTO lv_rowid;
158: IF (cur_rowid%FOUND) THEN
159: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ELS_ESU_FK');
160: IGS_GE_MSG_STACK.ADD;
161: Close cur_rowid;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163:

Line 186: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ELS_LOC_FK');

182:
183: Open cur_rowid;
184: Fetch cur_rowid INTO lv_rowid;
185: IF (cur_rowid%FOUND) THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ELS_LOC_FK');
187: IGS_GE_MSG_STACK.ADD;
188: Close cur_rowid;
189: APP_EXCEPTION.RAISE_EXCEPTION;
190:

Line 229: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

225:
226: IF Get_PK_For_Validation (
227: new_references.PERSON_ID,
228: new_references.EXAM_LOCATION_CD) THEN
229: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233: Check_Constraints;

Line 246: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

242: ELSIF (p_action = 'VALIDATE_INSERT') THEN
243: IF Get_PK_For_Validation ( new_references.PERSON_ID,
244: new_references.EXAM_LOCATION_CD
245: ) THEN
246: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
247: IGS_GE_MSG_STACK.ADD;
248: APP_EXCEPTION.RAISE_EXCEPTION;
249: END IF;
250:

Line 295: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

291: if X_LAST_UPDATE_LOGIN is NULL then
292: X_LAST_UPDATE_LOGIN := -1;
293: end if;
294: else
295: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
296: IGS_GE_MSG_STACK.ADD;
297: APP_EXCEPTION.RAISE_EXCEPTION;
298: end if;
299:

Line 354: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

350: begin
351: open c1;
352: fetch c1 into tlinfo;
353: if (c1%notfound) then
354: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
355: IGS_GE_MSG_STACK.ADD;
356: APP_EXCEPTION.RAISE_EXCEPTION;
357: close c1;
358: return;

Line 394: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

390:
391: IF upper(column_name) = 'EXAM_LOCATION_CD' OR
392: column_name is null Then
393: IF new_references.EXAM_LOCATION_CD <> UPPER(new_references.EXAM_LOCATION_CD) Then
394: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
395: IGS_GE_MSG_STACK.ADD;
396: APP_EXCEPTION.RAISE_EXCEPTION;
397: END IF;
398: END IF;