APPS.IGS_PS_UNIT_LVL_HIST_PKG dependencies on APP_EXCEPTION

Line 47: App_Exception.Raise_Exception;

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

Line 96: App_Exception.Raise_Exception;

92: IF new_references.unit_cd <> UPPER(new_references.unit_cd)
93: THEN
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99:
100: IF upper(column_name)= 'UNIT_LEVEL' OR

Line 106: App_Exception.Raise_Exception;

102: IF new_references.unit_level <> UPPER(new_references.unit_level)
103: THEN
104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109: END Check_Constraints;
110:

Line 124: App_Exception.Raise_Exception;

120: new_references.unit_level
121: )THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126:
127: END IF;
128:

Line 141: App_Exception.Raise_Exception;

137: new_references.version_number
138: )THEN
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:
145: IF (((old_references.course_cd = new_references.course_cd) AND

Line 157: App_Exception.Raise_Exception;

153: new_references.course_version_number
154: ) THEN
155: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160:
161: END Check_Parent_Existance;

Line 219: App_Exception.Raise_Exception;

215: IF (cur_rowid%FOUND) THEN
216: Close cur_rowid;
217: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CULH_UV_FK');
218: IGS_GE_MSG_STACK.ADD;
219: App_Exception.Raise_Exception;
220: Return;
221: END IF;
222: Close cur_rowid;
223:

Line 243: APP_EXCEPTION.RAISE_EXCEPTION;

239: IF cur_rowid%FOUND THEN
240: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_PRA_CRV_FK');
241: IGS_GE_MSG_STACK.ADD;
242: CLOSE CUR_ROWID;
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: RETURN;
245: END IF;
246: CLOSE cur_rowid;
247: END get_fk_igs_ps_ver;

Line 306: App_Exception.Raise_Exception;

302: new_references.course_version_number
303: ) THEN
304: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308: Check_Constraints;
309: Check_Parent_Existance;
310: ELSIF (p_action = 'UPDATE') THEN

Line 325: App_Exception.Raise_Exception;

321: new_references.course_version_number
322: ) THEN
323: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
324: IGS_GE_MSG_STACK.ADD;
325: App_Exception.Raise_Exception;
326: END IF;
327: Check_Constraints;
328: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
329: Check_Constraints;

Line 388: app_exception.raise_exception;

384: end if;
385: else
386: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
387: IGS_GE_MSG_STACK.ADD;
388: app_exception.raise_exception;
389: end if;
390:
391: Before_DML( p_action => 'INSERT',
392: x_rowid => X_ROWID,

Line 487: app_exception.raise_exception;

483: fetch c1 into tlinfo;
484: if (c1%notfound) then
485: close c1;
486: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
487: app_exception.raise_exception;
488: return;
489: end if;
490: close c1;
491:

Line 504: app_exception.raise_exception;

500: ) then
501: null;
502: else
503: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
504: app_exception.raise_exception;
505: end if;
506: return;
507: end LOCK_ROW;
508:

Line 543: app_exception.raise_exception;

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