DBA Data[Home] [Help]

APPS.IGS_PS_OFR_NOTE_PKG dependencies on FND_MESSAGE

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

34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;

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

80:
81: IF upper(column_name) = 'CAL_TYPE' OR
82: column_name is null Then
83: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;

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

89:
90: IF upper(column_name) = 'COURSE_CD' OR
91: column_name is null Then
92: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
93: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: END IF;
97: END IF;

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

98:
99: IF upper(column_name) = 'CRS_NOTE_TYPE' OR
100: column_name is null Then
101: IF ( new_references.crs_note_type <> UPPER(new_references.crs_note_type) ) Then
102: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;

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

116: ELSE
117: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
118: new_references.crs_note_type
119: ) THEN
120: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;

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

135: new_references.course_cd,
136: new_references.version_number,
137: new_references.cal_type
138: ) THEN
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;

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

148: ELSE
149: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
150: new_references.reference_number
151: ) THEN
152: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: END IF;

Line 210: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_CNT_FK');

206: Open cur_rowid;
207: Fetch cur_rowid INTO lv_rowid;
208: IF (cur_rowid%FOUND) THEN
209: Close cur_rowid;
210: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_CNT_FK');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: Return;
214: END IF;

Line 240: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_CO_FK');

236: Open cur_rowid;
237: Fetch cur_rowid INTO lv_rowid;
238: IF (cur_rowid%FOUND) THEN
239: Close cur_rowid;
240: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_CO_FK');
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: Return;
244: END IF;

Line 266: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_NOTE_FK');

262: Open cur_rowid;
263: Fetch cur_rowid INTO lv_rowid;
264: IF (cur_rowid%FOUND) THEN
265: Close cur_rowid;
266: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_NOTE_FK');
267: IGS_GE_MSG_STACK.ADD;
268: App_Exception.Raise_Exception;
269: Return;
270: END IF;

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

309: new_references.course_cd,
310: new_references.version_number,
311: new_references.cal_type,
312: new_references.reference_number ) THEN
313: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
314: IGS_GE_MSG_STACK.ADD;
315: App_Exception.Raise_Exception;
316: END IF;
317: Check_Constraints;

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

329: new_references.course_cd,
330: new_references.version_number,
331: new_references.cal_type,
332: new_references.reference_number ) THEN
333: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: Check_Constraints;

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

383: if X_LAST_UPDATE_LOGIN is NULL then
384: X_LAST_UPDATE_LOGIN := -1;
385: end if;
386: else
387: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
388: IGS_GE_MSG_STACK.ADD;
389: app_exception.raise_exception;
390: end if;
391: Before_DML (

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

459: open c1;
460: fetch c1 into tlinfo;
461: if (c1%notfound) then
462: close c1;
463: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
464: IGS_GE_MSG_STACK.ADD;
465: app_exception.raise_exception;
466: return;
467: end if;

Line 474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

470: if ( (tlinfo.CRS_NOTE_TYPE = X_CRS_NOTE_TYPE)
471: ) then
472: null;
473: else
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: end if;
478: return;

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

504: if X_LAST_UPDATE_LOGIN is NULL then
505: X_LAST_UPDATE_LOGIN := -1;
506: end if;
507: else
508: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
509: IGS_GE_MSG_STACK.ADD;
510: app_exception.raise_exception;
511: end if;
512: Before_DML (