DBA Data[Home] [Help]

APPS.IGS_EN_CAT_PRC_STEP_PKG dependencies on APP_EXCEPTION

Line 46: App_Exception.Raise_Exception;

42: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
43: Close cur_old_ref_values;
44: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
45: IGS_GE_MSG_STACK.ADD;
46: App_Exception.Raise_Exception;
47: Return;
48: END IF;
49: Close cur_old_ref_values;
50:

Line 92: app_exception.raise_exception;

88: new_references.s_enrolment_step_type,
89: v_message_name) = FALSE THEN
90: fnd_message.set_name('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: app_exception.raise_exception;
93: END IF;
94: END IF;
95: END IF;
96:

Line 124: App_Exception.Raise_Exception;

120: column_name is null then
121: if new_references.enrolment_cat <> upper(new_references.enrolment_cat) then
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: end if;
126: end if;
127: IF upper(column_name) = 'ENR_METHOD_TYPE' OR
128: column_name is null then

Line 132: App_Exception.Raise_Exception;

128: column_name is null then
129: if new_references.enr_method_type <>upper(new_references.enr_method_type) then
130: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: end if;
134: end if;
135: IF upper(column_name) = 'MANDATORY_STEP_IND' OR
136: column_name is null then

Line 141: App_Exception.Raise_Exception;

137: if new_references.mandatory_step_ind <> upper(new_references.mandatory_step_ind) OR
138: new_references.mandatory_step_ind NOT IN ('Y','N') then
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: end if;
143: end if;
144: IF upper(column_name) = 'S_ENROLMENT_STEP_TYPE' OR
145: column_name is null then

Line 149: App_Exception.Raise_Exception;

145: column_name is null then
146: if new_references.s_enrolment_step_type <> upper(new_references.s_enrolment_step_type) then
147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: end if;
151: end if;
152: IF upper(column_name) = 'S_STUDENT_COMM_TYPE' OR
153: column_name is null then

Line 157: App_Exception.Raise_Exception;

153: column_name is null then
154: if new_references.s_student_comm_type <> upper(new_references.s_student_comm_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: end if;
160: END check_constraints;
161:

Line 180: App_Exception.Raise_Exception;

176: new_references.enr_method_type
177: ) then
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: end if;
182: END IF;
183:
184: IF (((old_references.s_enrolment_step_type = new_references.s_enrolment_step_type)) OR

Line 194: App_Exception.Raise_Exception;

190: new_references.s_enrolment_step_type
191: ) then
192: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: end if;
196: END IF;
197:
198: END Check_Parent_Existance;

Line 255: App_Exception.Raise_Exception;

251: IF (cur_rowid%FOUND) THEN
252: Close cur_rowid;
253: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ECPS_ECPD_FK');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: Return;
257: END IF;
258: Close cur_rowid;
259:

Line 281: App_Exception.Raise_Exception;

277: IF (cur_rowid%FOUND) THEN
278: Close cur_rowid;
279: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ECPS_LKUPV_FK');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: Return;
283: END IF;
284: Close cur_rowid;
285:

Line 332: App_Exception.Raise_Exception;

328: new_references.s_enrolment_step_type
329: ) then
330: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: end if;
334: Check_constraints;
335: Check_Parent_Existance;
336: ELSIF (p_action = 'UPDATE') THEN

Line 353: App_Exception.Raise_Exception;

349: new_references.s_enrolment_step_type
350: ) then
351: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354: end if;
355: Check_constraints;
356: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
357: Check_constraints;

Line 419: app_exception.raise_exception;

415: end if;
416: else
417: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
418: IGS_GE_MSG_STACK.ADD;
419: app_exception.raise_exception;
420: end if;
421: Before_DML (
422: p_action => 'INSERT',
423: x_rowid => X_ROWID,

Line 499: app_exception.raise_exception;

495: if (c1%notfound) then
496: close c1;
497: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
498: IGS_GE_MSG_STACK.ADD;
499: app_exception.raise_exception;
500: return;
501: end if;
502: close c1;
503:

Line 512: app_exception.raise_exception;

508: null;
509: else
510: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
511: IGS_GE_MSG_STACK.ADD;
512: app_exception.raise_exception;
513: end if;
514: return;
515: end LOCK_ROW;
516:

Line 546: app_exception.raise_exception;

542: end if;
543: else
544: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
545: IGS_GE_MSG_STACK.ADD;
546: app_exception.raise_exception;
547: end if;
548: Before_DML (
549: p_action => 'UPDATE',
550: x_rowid => X_ROWID,