DBA Data[Home] [Help]

APPS.IGS_AS_GRD_SCH_TRN_PKG dependencies on IGS_GE_MSG_STACK

Line 34: IGS_GE_MSG_STACK.ADD;

30: Open cur_old_ref_values;
31: Fetch cur_old_ref_values INTO old_references;
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;

Line 78: IGS_GE_MSG_STACK.ADD;

74: new_references.to_grading_schema_cd,
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

Line 93: -- IGS_GE_MSG_STACK.ADD;

89: -- new_references.to_version_number,
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;

Line 120: IGS_GE_MSG_STACK.ADD;

116: new_references.to_version_number,
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;

Line 144: IGS_GE_MSG_STACK.ADD;

140: new_references.version_number,
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

Line 160: IGS_GE_MSG_STACK.ADD;

156: new_references.to_version_number,
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 (

Line 214: IGS_GE_MSG_STACK.ADD;

210: Open cur_rowid;
211: Fetch cur_rowid INTO lv_rowid;
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;

Line 266: IGS_GE_MSG_STACK.ADD;

262: NEW_REFERENCES.to_grading_schema_cd ,
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;

Line 290: IGS_GE_MSG_STACK.ADD;

286: NEW_REFERENCES.to_grading_schema_cd ,
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;

Line 340: IGS_GE_MSG_STACK.ADD;

336: X_LAST_UPDATE_LOGIN := -1;
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',

Line 414: IGS_GE_MSG_STACK.ADD;

410: open c1;
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;

Line 458: IGS_GE_MSG_STACK.ADD;

454: IF upper(column_name) = 'GRADE' OR
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:

Line 467: IGS_GE_MSG_STACK.ADD;

463: IF upper(column_name) = 'GRADING_SCHEMA_CD' OR
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:

Line 476: IGS_GE_MSG_STACK.ADD;

472: IF upper(column_name) = 'TO_GRADE' OR
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:

Line 485: IGS_GE_MSG_STACK.ADD;

481: IF upper(column_name) = 'TO_GRADING_SCHEMA_CD' OR
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;