APPS.IGS_PS_TYPE_HIST_PKG dependencies on APP_EXCEPTION

Line 48: App_Exception.Raise_Exception;

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

Line 110: App_Exception.Raise_Exception;

106: IF new_references.course_type <> UPPER(new_references.course_type )
107: THEN
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:
114: IF upper(column_name)= 'COURSE_TYPE_GROUP_CD' OR

Line 120: App_Exception.Raise_Exception;

116: IF new_references.course_type_group_cd <> UPPER(new_references.course_type_group_cd )
117: THEN
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123:
124:

Line 131: App_Exception.Raise_Exception;

127: IF new_references.tac_course_level <> UPPER(new_references.tac_course_level)
128: THEN
129: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
130: IGS_GE_MSG_STACK.ADD;
131: App_Exception.Raise_Exception;
132: END IF;
133: END IF;
134:
135: IF upper(column_name)= 'RESEARCH_TYPE_IND' OR

Line 141: App_Exception.Raise_Exception;

137: IF new_references.research_type_ind NOT IN ( 'Y' , 'N' )
138: 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)= 'CLOSED_IND' OR
145: column_name is null THEN

Line 150: App_Exception.Raise_Exception;

146: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
147: THEN
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153: IF upper(column_name)= 'AWARD_COURSE_IND' OR
154: column_name is null THEN

Line 159: App_Exception.Raise_Exception;

155: IF new_references.award_course_ind NOT IN ( 'Y' , 'N' )
156: THEN
157: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162: IF upper(column_name) = 'PRIMARY_AUTO_SELECT' OR
163: column_name is null THEN

Line 168: App_Exception.Raise_Exception;

164: IF new_references.primary_auto_select NOT IN ( 'Y','N' )
165: THEN
166: Fnd_Message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170: END IF;
171: END Check_Constraints;
172:

Line 259: App_Exception.Raise_Exception;

255: new_references.hist_start_dt
256: ) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;
262: ELSIF (p_action = 'UPDATE') THEN
263: -- Call all the procedures related to Before Update.

Line 276: App_Exception.Raise_Exception;

272: new_references.hist_start_dt
273: ) THEN
274: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: Check_Constraints;
279: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
280: Check_Constraints;

Line 339: app_exception.raise_exception;

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

Line 459: app_exception.raise_exception;

455: if (c1%notfound) then
456: close c1;
457: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: return;
461: end if;
462: close c1;
463:

Line 498: app_exception.raise_exception;

494: null;
495: else
496: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
497: IGS_GE_MSG_STACK.ADD;
498: app_exception.raise_exception;
499: end if;
500: return;
501: end LOCK_ROW;
502:

Line 540: app_exception.raise_exception;

536: end if;
537: else
538: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
539: IGS_GE_MSG_STACK.ADD;
540: app_exception.raise_exception;
541: end if;
542: Before_DML( p_action => 'UPDATE',
543: x_rowid => X_ROWID,
544: x_course_type => X_COURSE_TYPE,