DBA Data[Home] [Help]

APPS.IGS_AD_PRCS_CAT_LTR_PKG dependencies on FND_MESSAGE

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

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

Line 77: Fnd_Message.Set_Name('IGS',v_message_name);

73: IF IGS_AD_VAL_APCL.corp_val_slet_closed(
74: new_references.correspondence_type,
75: new_references.letter_reference_number,
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: -- Validate that the s_letter is of type 'ADM'

Line 87: Fnd_Message.Set_Name('IGS',v_message_name);

83: new_references.correspondence_type,
84: new_references.letter_reference_number,
85: 'ADM',
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;

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

110:
111: IF upper(column_name) = 'ADMISSION_CAT' OR
112: column_name is null Then
113: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;

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

119:
120: IF upper(column_name) = 'CORRESPONDENCE_TYPE' OR
121: column_name is null Then
122: IF new_references.correspondence_type <> UPPER(new_references.correspondence_type) Then
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;

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

128:
129: IF upper(column_name) = 'S_ADMISSION_PROCESS_TYPE' OR
130: column_name is null Then
131: IF new_references.s_admission_process_type <> UPPER(new_references.s_admission_process_type) Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;

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

149: new_references.admission_cat,
150: new_references.s_admission_process_type,
151: 'N'
152: ) THEN
153: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;

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

165: IF NOT IGS_CO_S_LTR_PKG.Get_PK_For_Validation (
166: new_references.correspondence_type,
167: new_references.letter_reference_number
168: ) THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;

Line 228: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCL_APC_FK');

224: Open cur_rowid;
225: Fetch cur_rowid INTO lv_rowid;
226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCL_APC_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;

Line 256: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCL_SLET_FK');

252: Open cur_rowid;
253: Fetch cur_rowid INTO lv_rowid;
254: IF (cur_rowid%FOUND) THEN
255: Close cur_rowid;
256: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCL_SLET_FK');
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: Return;
260: END IF;

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

298: new_references.admission_cat,
299: new_references.s_admission_process_type,
300: new_references.correspondence_type
301: ) THEN
302: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: Check_Constraints;

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

315: new_references.admission_cat,
316: new_references.s_admission_process_type,
317: new_references.correspondence_type
318: ) THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: Check_Constraints;

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

365: if X_LAST_UPDATE_LOGIN is NULL then
366: X_LAST_UPDATE_LOGIN := -1;
367: end if;
368: else
369: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: end if;
373:

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

435: open c1;
436: fetch c1 into tlinfo;
437: if (c1%notfound) then
438: close c1;
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: return;
443: end if;

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

446: if ( (tlinfo.LETTER_REFERENCE_NUMBER = X_LETTER_REFERENCE_NUMBER)
447: ) then
448: null;
449: else
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: IGS_GE_MSG_STACK.ADD;
452: app_exception.raise_exception;
453: end if;
454: return;

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

479: if X_LAST_UPDATE_LOGIN is NULL then
480: X_LAST_UPDATE_LOGIN := -1;
481: end if;
482: else
483: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
484: IGS_GE_MSG_STACK.ADD;
485: app_exception.raise_exception;
486: end if;
487: Before_DML(p_action =>'UPDATE',