APPS.IGS_PE_GOVCITIZEN_CD_PKG dependencies on APP_EXCEPTION

Line 71: App_Exception.Raise_Exception;

67: IGS_GE_MSG_STACK.ADD;
68:
69:
70: Close cur_old_ref_values;
71: App_Exception.Raise_Exception;
72: Return;
73:
74: END IF;
75:

Line 148: App_Exception.Raise_Exception;

144: v_message_name ) = FALSE THEN
145:
146: Fnd_Message.Set_Name('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150:
151: END IF;
152:

Line 179: App_Exception.Raise_Exception;

175: column_name is null Then
176: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
177: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;
182:
183: IF upper(column_name) = 'GOVT_CITIZENSHIP_CD' OR

Line 189: App_Exception.Raise_Exception;

185: IF new_references.govt_citizenship_cd < 0 OR
186: new_references.govt_citizenship_cd > 9 Then
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
193: END Check_Constraints;

Line 307: App_Exception.Raise_Exception;

303: IF Get_PK_For_Validation (
304: new_references.govt_citizenship_cd ) THEN
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309:
310: Check_Constraints; -- if procedure present
311:

Line 328: App_Exception.Raise_Exception;

324: IF Get_PK_For_Validation (
325: new_references.govt_citizenship_cd ) THEN
326: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: END IF;
330:
331: Check_Constraints; -- if procedure present
332: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 415: app_exception.raise_exception;

411: end if;
412: else
413: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
414: IGS_GE_MSG_STACK.ADD;
415: app_exception.raise_exception;
416: end if;
417:
418: Before_DML(
419:

Line 501: App_Exception.Raise_Exception;

497: if (c1%notfound) then
498: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
499:
500: close c1;
501: App_Exception.Raise_Exception;
502: return;
503: end if;
504: close c1;
505:

Line 512: app_exception.raise_exception;

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

Line 545: app_exception.raise_exception;

541: end if;
542: else
543: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
544: IGS_GE_MSG_STACK.ADD;
545: app_exception.raise_exception;
546: end if;
547:
548: Before_DML(
549: