DBA Data[Home] [Help]

APPS.IGS_FI_FND_SRC_RSTN_PKG dependencies on APP_EXCEPTION

Line 75: App_Exception.Raise_Exception;

71:
72: Close cur_old_ref_values;
73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76:
77:
78: Return;
79:

Line 186: App_Exception.Raise_Exception;

182: v_message_name) = FALSE THEN
183:
184: Fnd_Message.Set_Name('IGS',v_message_name);
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187:
188: END IF;
189:
190: -- Validate funding source. Funding source is not updateable.

Line 202: App_Exception.Raise_Exception;

198: v_message_name) = FALSE THEN
199:
200: Fnd_Message.Set_Name('IGS',v_message_name);
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203:
204: END IF;
205:
206: END IF;

Line 222: App_Exception.Raise_Exception;

218: v_message_name) = FALSE THEN
219:
220: Fnd_Message.Set_Name('IGS',v_message_name);
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223:
224: END IF;
225:
226: END IF;

Line 321: App_Exception.Raise_Exception;

317: new_references.restricted_ind <> 'N'
318: THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: END IF;
324:
325: IF upper(Column_Name) = 'DFLT_IND' OR column_name is NULL THEN

Line 331: App_Exception.Raise_Exception;

327: new_references.dflt_ind <> 'N'
328: THEN
329: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: END IF;
334: IF upper(Column_Name) = 'COURSE_CD' OR
335: column_name is NULL THEN

Line 339: App_Exception.Raise_Exception;

335: column_name is NULL THEN
336: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
337: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: END IF;
342: IF upper(Column_Name) = 'FUNDING_SOURCE' OR
343: column_name is NULL THEN

Line 347: App_Exception.Raise_Exception;

343: column_name is NULL THEN
344: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
345: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
346: IGS_GE_MSG_STACK.ADD;
347: App_Exception.Raise_Exception;
348: END IF;
349: END IF;
350:
351: END Check_Constraints;

Line 363: App_Exception.Raise_Exception;

359: new_references.funding_source
360: ) THEN
361: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
362: IGS_GE_MSG_STACK.ADD;
363: App_Exception.Raise_Exception;
364: END IF;
365: IF (((old_references.course_cd = new_references.course_cd) AND
366: (old_references.version_number = new_references.version_number)) OR
367: ((new_references.course_cd IS NULL) OR

Line 376: App_Exception.Raise_Exception;

372: new_references.version_number
373: ) THEN
374: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
375: IGS_GE_MSG_STACK.ADD;
376: App_Exception.Raise_Exception;
377: END IF;
378: END Check_Parent_Existance;
379:
380: FUNCTION Get_PK_For_Validation (

Line 422: App_Exception.Raise_Exception;

418: IF (cur_rowid%FOUND) THEN
419: Close cur_rowid;
420: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FSR_FS_FK');
421: IGS_GE_MSG_STACK.ADD;
422: App_Exception.Raise_Exception;
423: Return;
424: END IF;
425: Close cur_rowid;
426:

Line 470: App_Exception.Raise_Exception;

466:
467: Close cur_rowid;
468: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FSR_CRV_FK');
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471:
472:
473: Return;
474:

Line 544: App_Exception.Raise_Exception;

540: new_references.version_number,
541: new_references.funding_source ) THEN
542: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
543: IGS_GE_MSG_STACK.ADD;
544: App_Exception.Raise_Exception;
545: END IF;
546:
547: Check_Constraints;
548:

Line 574: App_Exception.Raise_Exception;

570: new_references.version_number,
571: new_references.funding_source ) THEN
572: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
573: IGS_GE_MSG_STACK.ADD;
574: App_Exception.Raise_Exception;
575: END IF;
576: Check_Constraints;
577: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
578: Check_Constraints;

Line 615: app_exception.raise_exception;

611: end if;
612: else
613: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
614: IGS_GE_MSG_STACK.ADD;
615: app_exception.raise_exception;
616: end if;
617:
618:
619:

Line 692: app_exception.raise_exception;

688: if (c1%notfound) then
689: close c1;
690: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
691: IGS_GE_MSG_STACK.ADD;
692: app_exception.raise_exception;
693: return;
694: end if;
695: close c1;
696:

Line 704: app_exception.raise_exception;

700: null;
701: else
702: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
703: IGS_GE_MSG_STACK.ADD;
704: app_exception.raise_exception;
705: end if;
706: return;
707: end LOCK_ROW;
708:

Line 738: app_exception.raise_exception;

734: end if;
735: else
736: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
737: IGS_GE_MSG_STACK.ADD;
738: app_exception.raise_exception;
739: end if;
740:
741: Before_DML(
742: