APPS.IGS_ST_CITIZENSHP_CD_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 80: App_Exception.Raise_Exception;

76: new_references.govt_citizenship_cd,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83:
84: END BeforeRowInsertUpdate1;

Line 106: App_Exception.Raise_Exception ;

102: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
103: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) 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:
109: IF new_references.CLOSED_IND not in ('Y','N') then
110: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 112: App_Exception.Raise_Exception ;

108:
109: IF new_references.CLOSED_IND not in ('Y','N') then
110: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception ;
113: END IF;
114:
115: END IF ;
116:

Line 121: App_Exception.Raise_Exception ;

117: IF upper(Column_name) = 'CITIZENSHIP_CD' OR COLUMN_NAME IS NULL THEN
118: IF new_references.CITIZENSHIP_CD<> upper(new_references.CITIZENSHIP_CD) then
119: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception ;
122: END IF;
123:
124: END IF ;
125:

Line 135: App_Exception.Raise_Exception;

131: IF Get_PK_For_Validation (
132: new_references.citizenship_cd ) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END Check_Uniqueness ;
138:
139:

Line 152: App_Exception.Raise_Exception;

148: new_references.govt_citizenship_cd
149: ) THEN
150: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF ;
155: END Check_Parent_Existance;
156:

Line 203: App_Exception.Raise_Exception;

199: IF (cur_rowid%FOUND) THEN
200: Close cur_rowid;
201: Fnd_Message.Set_Name ('IGS', 'IGS_ST_CIC_GCC_FK');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
206: Close cur_rowid;
207:

Line 249: App_Exception.Raise_Exception;

245: new_references.govt_citizenship_cd
246: ) THEN
247: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: Check_Constraints;
252: Check_Parent_Existance;
253: Check_Uniqueness;

Line 270: App_Exception.Raise_Exception;

266: new_references.govt_citizenship_cd
267: ) THEN
268: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: Check_Constraints;
273: Check_Uniqueness;
274: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 324: app_exception.raise_exception;

320: end if;
321: else
322: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
323: IGS_GE_MSG_STACK.ADD;
324: app_exception.raise_exception;
325: end if;
326:
327: Before_DML(
328: p_action=>'INSERT' ,

Line 404: app_exception.raise_exception;

400: if (c1%notfound) then
401: close c1;
402: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
403: IGS_GE_MSG_STACK.ADD;
404: app_exception.raise_exception;
405: return;
406: end if;
407: close c1;
408:

Line 420: app_exception.raise_exception;

416: null;
417: else
418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: return;
423: end LOCK_ROW;
424:

Line 454: app_exception.raise_exception;

450: end if;
451: else
452: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: end if;
456:
457: Before_DML(
458: p_action=>'UPDATE' ,