DBA Data[Home] [Help]

APPS.IGS_AS_GRD_SCH_TRN_PKG dependencies on APP_EXCEPTION

Line 36: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 79: APP_EXCEPTION.RAISE_EXCEPTION;

75: new_references.to_version_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: --
82: -- Validate rslt type for grade is same as rslt type for xlation grade
83: --ijeddy, this is now treated as a warning instead of an error, bug no 3216979

Line 94: -- APP_EXCEPTION.RAISE_EXCEPTION;

90: -- new_references.to_grade,
91: -- v_message_name) = FALSE THEN
92: -- FND_MESSAGE.SET_NAME('IGS',v_message_name);
93: -- IGS_GE_MSG_STACK.ADD;
94: -- APP_EXCEPTION.RAISE_EXCEPTION;
95: -- END IF;
96: END IF;
97: END BeforeRowInsertUpdate1;
98: -- Trigger description :-

Line 121: APP_EXCEPTION.RAISE_EXCEPTION;

117: new_references.to_grade,
118: v_message_name) = FALSE THEN
119: FND_MESSAGE.SET_NAME('IGS',v_message_name);
120: IGS_GE_MSG_STACK.ADD;
121: APP_EXCEPTION.RAISE_EXCEPTION;
122: END IF;
123: END IF;
124: END AfterRowInsertUpdate2;
125: -- Trigger description :-

Line 145: APP_EXCEPTION.RAISE_EXCEPTION;

141: new_references.grade
142: ) THEN
143: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: APP_EXCEPTION.RAISE_EXCEPTION;
146: END IF;
147: IF (((old_references.to_grading_schema_cd = new_references.to_grading_schema_cd) AND
148: (old_references.to_version_number = new_references.to_version_number) OR
149: (old_references.to_grade = new_references.to_grade)) OR

Line 161: APP_EXCEPTION.RAISE_EXCEPTION;

157: new_references.to_grade
158: ) THEN
159: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163: END Check_Parent_Existance;
164: FUNCTION Get_PK_For_Validation (
165: x_grading_schema_cd IN VARCHAR2,

Line 216: APP_EXCEPTION.RAISE_EXCEPTION;

212: IF (cur_rowid%FOUND) THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_AS_GSGT_GSG_FK');
214: IGS_GE_MSG_STACK.ADD;
215: Close cur_rowid;
216: APP_EXCEPTION.RAISE_EXCEPTION;
217:
218: Return;
219: END IF;
220: Close cur_rowid;

Line 267: APP_EXCEPTION.RAISE_EXCEPTION;

263: NEW_REFERENCES.to_version_number,
264: NEW_REFERENCES.to_grade) THEN
265: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
266: IGS_GE_MSG_STACK.ADD;
267: APP_EXCEPTION.RAISE_EXCEPTION;
268: END IF;
269:
270: Check_Constraints;
271:

Line 291: APP_EXCEPTION.RAISE_EXCEPTION;

287: NEW_REFERENCES.to_version_number,
288: NEW_REFERENCES.to_grade) THEN
289: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
290: IGS_GE_MSG_STACK.ADD;
291: APP_EXCEPTION.RAISE_EXCEPTION;
292: END IF;
293:
294: Check_Constraints;
295: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 341: APP_EXCEPTION.RAISE_EXCEPTION;

337: end if;
338: else
339: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
340: IGS_GE_MSG_STACK.ADD;
341: APP_EXCEPTION.RAISE_EXCEPTION;
342: end if;
343: Before_DML(
344: p_action=>'INSERT',
345: x_rowid=>X_ROWID,

Line 415: APP_EXCEPTION.RAISE_EXCEPTION;

411: fetch c1 into tlinfo;
412: if (c1%notfound) then
413: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
414: IGS_GE_MSG_STACK.ADD;
415: APP_EXCEPTION.RAISE_EXCEPTION;
416: close c1;
417: return;
418: end if;
419: close c1;

Line 459: APP_EXCEPTION.RAISE_EXCEPTION;

455: column_name is null Then
456: IF new_references.GRADE <> UPPER(new_references.GRADE) Then
457: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
458: IGS_GE_MSG_STACK.ADD;
459: APP_EXCEPTION.RAISE_EXCEPTION;
460: END IF;
461: END IF;
462:
463: IF upper(column_name) = 'GRADING_SCHEMA_CD' OR

Line 468: APP_EXCEPTION.RAISE_EXCEPTION;

464: column_name is null Then
465: IF new_references.GRADING_SCHEMA_CD <> UPPER(new_references.GRADING_SCHEMA_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: END IF;
471:
472: IF upper(column_name) = 'TO_GRADE' OR

Line 477: APP_EXCEPTION.RAISE_EXCEPTION;

473: column_name is null Then
474: IF new_references.TO_GRADE <> UPPER(new_references.TO_GRADE) 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: END IF;
480:
481: IF upper(column_name) = 'TO_GRADING_SCHEMA_CD' OR

Line 486: APP_EXCEPTION.RAISE_EXCEPTION;

482: column_name is null Then
483: IF new_references.TO_GRADING_SCHEMA_CD <> UPPER(new_references.TO_GRADING_SCHEMA_CD) 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: END IF;
489: END Check_Constraints;
490: