DBA Data[Home] [Help]

APPS.IGS_PS_AWD_PKG dependencies on IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

38: FETCH cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
40: CLOSE cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception; RETURN;
44: END IF;
45: CLOSE cur_old_ref_values;
46:

Line 86: IGS_GE_MSG_STACK.ADD;

82: IF IGS_PS_VAL_AW.crsp_val_tt_closed(
83: new_references.testamur_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90: END IF;

Line 100: IGS_GE_MSG_STACK.ADD;

96: new_references.s_award_type,
97: old_references.s_award_type,
98: v_message_name) = FALSE THEN
99: Fnd_Message.Set_Name('IGS',v_message_name);
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:

Line 134: IGS_GE_MSG_STACK.ADD;

130: IF UPPER(column_name) = 'CLOSED_IND' OR
131: column_name IS NULL THEN
132: IF ( new_references.closed_ind NOT IN ( 'Y' , 'N' ) ) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:

Line 143: IGS_GE_MSG_STACK.ADD;

139: IF UPPER(column_name) = 'S_AWARD_TYPE' OR
140: column_name IS NULL THEN
141: IF ( new_references.s_award_type NOT IN ( 'COURSE' , 'HONORARY' , 'MEDAL' , 'PRIZE' ,'ENTRYQUAL') ) THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
147:

Line 152: IGS_GE_MSG_STACK.ADD;

148: IF UPPER(column_name) = 'AWARD_CD' OR
149: column_name IS NULL THEN
150: IF ( new_references.award_cd <> UPPER(new_references.award_cd) ) THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:

Line 161: IGS_GE_MSG_STACK.ADD;

157: IF UPPER(column_name) = 'CLOSED_IND' OR
158: column_name IS NULL THEN
159: IF ( new_references.closed_ind <> UPPER(new_references.closed_ind) ) THEN
160: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164: END IF;
165:

Line 170: IGS_GE_MSG_STACK.ADD;

166: IF UPPER(column_name) = 'S_AWARD_TYPE' OR
167: column_name IS NULL THEN
168: IF ( new_references.s_award_type <> UPPER(new_references.s_award_type) ) THEN
169: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:

Line 179: IGS_GE_MSG_STACK.ADD;

175: IF UPPER(column_name) = 'TESTAMUR_TYPE' OR
176: column_name IS NULL THEN
177: IF ( new_references.testamur_type <> UPPER(new_references.testamur_type) ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:

Line 189: IGS_GE_MSG_STACK.ADD;

185: IF UPPER(column_name) = 'GRADING_SCHEMA_CD' OR
186: column_name IS NULL THEN
187: IF new_references.GRADING_SCHEMA_CD <> UPPER(new_references.GRADING_SCHEMA_CD) THEN
188: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
189: IGS_GE_MSG_STACK.ADD;
190: APP_EXCEPTION.RAISE_EXCEPTION;
191: END IF;
192: END IF;
193:

Line 199: IGS_GE_MSG_STACK.ADD;

195: IF UPPER(column_name) = 'GS_VERSION_NUMBER' OR
196: column_name IS NULL THEN
197: IF new_references.GS_VERSION_NUMBER < 0 OR new_references.GS_VERSION_NUMBER > 999 THEN
198: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
199: IGS_GE_MSG_STACK.ADD;
200: APP_EXCEPTION.RAISE_EXCEPTION;
201: END IF;
202: END IF;
203:

Line 216: IGS_GE_MSG_STACK.ADD;

212: ELSE
213: IF NOT IGS_GR_TESTAMUR_TYPE_PKG.Get_PK_For_Validation (
214: new_references.testamur_type ) THEN
215: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
220:

Line 244: IGS_GE_MSG_STACK.ADD;

240: new_references.grading_schema_cd,
241: new_references.gs_version_number
242: ) THEN
243: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248:

Line 295: IGS_GE_MSG_STACK.ADD;

291: FETCH cur_rowid INTO lv_rowid;
292: IF (cur_rowid%FOUND) THEN
293: CLOSE cur_rowid;
294: Fnd_Message.Set_Name ('IGS', 'IGS_PS_AW_TT_FK');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: RETURN;
298: END IF;
299: CLOSE cur_rowid;

Line 326: IGS_GE_MSG_STACK.ADD;

322: FETCH cur_rowid INTO lv_rowid;
323: IF (cur_rowid%FOUND) THEN
324: CLOSE cur_rowid;
325: Fnd_Message.Set_Name ('IGS', 'IGS_PS_AW_GS_FK');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: RETURN;
329: END IF;
330: CLOSE cur_rowid;

Line 377: IGS_GE_MSG_STACK.ADD;

373: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
374: IF Get_PK_For_Validation (
375: new_references.award_cd) THEN
376: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: Check_Constraints;
381: Check_Parent_Existance;

Line 391: IGS_GE_MSG_STACK.ADD;

387: ELSIF (p_action = 'VALIDATE_INSERT') THEN
388: IF Get_PK_For_Validation (
389: new_references.award_cd ) THEN
390: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: Check_Constraints;
395: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 444: IGS_GE_MSG_STACK.ADD;

440: X_LAST_UPDATE_LOGIN := -1;
441: END IF;
442: ELSE
443: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: END IF;
447:
448: Before_DML (

Line 541: IGS_GE_MSG_STACK.ADD;

537: FETCH c1 INTO tlinfo;
538: IF (c1%NOTFOUND) THEN
539: CLOSE c1;
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: IGS_GE_MSG_STACK.ADD;
542: app_exception.raise_exception;
543: RETURN;
544: END IF;
545: CLOSE c1;

Line 580: IGS_GE_MSG_STACK.ADD;

576: ) THEN
577: NULL;
578: ELSE
579: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: END IF;
583: RETURN;
584: END LOCK_ROW;

Line 617: IGS_GE_MSG_STACK.ADD;

613: X_LAST_UPDATE_LOGIN := -1;
614: END IF;
615: ELSE
616: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
617: IGS_GE_MSG_STACK.ADD;
618: app_exception.raise_exception;
619: END IF;
620:
621: Before_DML (