DBA Data[Home] [Help]

APPS.IGS_PR_OU_PS_PKG dependencies on FND_MESSAGE

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

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

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

71: ELSE
72: IF NOT IGS_PS_COURSE_PKG.Get_PK_For_Validation (
73: new_references.course_cd
74: ) THEN
75: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;

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

90: new_references.progression_rule_cat,
91: new_references.pra_sequence_number,
92: new_references.pro_sequence_number
93: ) THEN
94: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;

Line 148: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POC_CRS_FK');

144:
145: Open cur_rowid;
146: Fetch cur_rowid INTO lv_rowid;
147: IF (cur_rowid%FOUND) THEN
148: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POC_CRS_FK');
149: IGS_GE_MSG_STACK.ADD;
150: Close cur_rowid;
151: App_Exception.Raise_Exception;
152: Return;

Line 178: Fnd_Message.Set_Name ('IGS','IGS_PR_POC_PRO_FK');

174:
175: Open cur_rowid;
176: Fetch cur_rowid INTO lv_rowid;
177: IF (cur_rowid%FOUND) THEN
178: Fnd_Message.Set_Name ('IGS','IGS_PR_POC_PRO_FK');
179: IGS_GE_MSG_STACK.ADD;
180: Close cur_rowid;
181: App_Exception.Raise_Exception;
182: Return;

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

213: OPEN c_parent( new_references.progression_rule_cat, new_references.pra_sequence_number, new_references.pro_sequence_number );
214: FETCH c_parent INTO l_dummy;
215: IF c_parent%NOTFOUND THEN
216: CLOSE c_parent;
217: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
218: IGS_GE_MSG_STACK.ADD;
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: END IF;
221: CLOSE c_parent;

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

226: OPEN c_parent( new_references.progression_rule_cat, new_references.pra_sequence_number, new_references.pro_sequence_number );
227: FETCH c_parent INTO l_dummy;
228: IF c_parent%NOTFOUND THEN
229: CLOSE c_parent;
230: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
231: IGS_GE_MSG_STACK.ADD;
232: APP_EXCEPTION.RAISE_EXCEPTION;
233: END IF;
234: CLOSE c_parent;

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

275: new_references.pra_sequence_number,
276: new_references.pro_sequence_number,
277: new_references.course_cd
278: ) THEN
279: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: Check_Constraints;

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

293: new_references.pra_sequence_number,
294: new_references.pro_sequence_number,
295: new_references.course_cd
296: ) THEN
297: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: END IF;
301: Check_Constraints;

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

340: if X_LAST_UPDATE_LOGIN is NULL then
341: X_LAST_UPDATE_LOGIN := -1;
342: end if;
343: else
344: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348:

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

410: begin
411: open c1;
412: fetch c1 into tlinfo;
413: if (c1%notfound) then
414: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
415: IGS_GE_MSG_STACK.ADD;
416: close c1;
417: app_exception.raise_exception;
418: return;

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

462: END IF ;
463:
464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
465: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
466: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception ;
469: END IF;
470:

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

471: END IF ;
472:
473: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
474: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
475: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception ;
478: END IF;
479:

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

480: END IF ;
481:
482: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
483: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
484: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception ;
487: END IF;
488:

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

489: END IF ;
490:
491: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
492: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
493: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception ;
496: END IF;
497: