DBA Data[Home] [Help]

APPS.IGS_GR_CRMN_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 81: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

77: new_references.grd_cal_type,
78: new_references.grd_ci_sequence_number,
79: new_references.ceremony_number
80: ) THEN
81: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
82: IGS_GE_MSG_STACK.ADD;
83: APP_EXCEPTION.RAISE_EXCEPTION;
84: END IF;
85:

Line 95: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

91: ELSE
92: IF NOT IGS_GR_NOTE_TYPE_PKG.Get_PK_For_Validation (
93: new_references.grd_note_type
94: ) THEN
95: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
96: IGS_GE_MSG_STACK.ADD;
97: APP_EXCEPTION.RAISE_EXCEPTION;
98: END IF;
99:

Line 109: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

105: ELSE
106: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
107: new_references.reference_number
108: ) THEN
109: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
110: IGS_GE_MSG_STACK.ADD;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113:

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

134: END IF ;
135:
136: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
137: IF new_references.GRD_CI_SEQUENCE_NUMBER <1 OR NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER > 999999 then
138: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception ;
141: END IF;
142: END IF ;

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

142: END IF ;
143:
144: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
145: IF new_references.GRD_CAL_TYPE<> upper(NEW_REFERENCES.GRD_CAL_TYPE) then
146: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception ;
149: END IF;
150:

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

151: END IF ;
152:
153: IF upper(Column_name) = 'GRD_NOTE_TYPE' OR COLUMN_NAME IS NULL THEN
154: IF new_references.GRD_NOTE_TYPE<> upper(NEW_REFERENCES.GRD_NOTE_TYPE) then
155: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception ;
158: END IF;
159:

Line 215: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_GC_FK');

211: Open cur_rowid;
212: Fetch cur_rowid INTO lv_rowid;
213: IF (cur_rowid%FOUND) THEN
214: Close cur_rowid;
215: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_GC_FK');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: Return;
219: END IF;

Line 241: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_GNT_FK');

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

Line 267: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GCN_NOTE_FK');

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

Line 317: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

313: NEW_REFERENCES.grd_ci_sequence_number,
314: NEW_REFERENCES.ceremony_number,
315: NEW_REFERENCES.reference_number
316: ) THEN
317: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321:

Line 336: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

332: NEW_REFERENCES.grd_ci_sequence_number,
333: NEW_REFERENCES.ceremony_number,
334: NEW_REFERENCES.reference_number
335: ) THEN
336: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception;
339: END IF;
340:

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

378: if X_LAST_UPDATE_LOGIN is NULL then
379: X_LAST_UPDATE_LOGIN := -1;
380: end if;
381: else
382: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
383: IGS_GE_MSG_STACK.ADD;
384: app_exception.raise_exception;
385: end if;
386:

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

454: open c1;
455: fetch c1 into tlinfo;
456: if (c1%notfound) then
457: close c1;
458: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
459: app_exception.raise_exception;
460: return;
461: end if;
462: close c1;

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

465:
466: ) then
467: null;
468: else
469: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
470: app_exception.raise_exception;
471: end if;
472: return;
473: end LOCK_ROW;

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

498: if X_LAST_UPDATE_LOGIN is NULL then
499: X_LAST_UPDATE_LOGIN := -1;
500: end if;
501: else
502: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: