APPS.IGS_PE_ABORG_TORESCD_PKG dependencies on APP_EXCEPTION

Line 75: App_Exception.Raise_Exception;

71: IGS_GE_MSG_STACK.ADD;
72:
73:
74: Close cur_old_ref_values;
75: App_Exception.Raise_Exception;
76: Return;
77:
78: END IF;
79:

Line 152: App_Exception.Raise_Exception;

148: v_message_name) = FALSE THEN
149:
150: Fnd_Message.Set_Name('IGS', v_message_name);
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153:
154: END IF;
155:
156: END IF;

Line 184: App_Exception.Raise_Exception;

180: column_name is null Then
181: IF new_references.aborig_torres_cd <> UPPER(new_references.aborig_torres_cd ) Then
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187:
188: IF upper(column_name) = 'CLOSED_IND' OR

Line 194: App_Exception.Raise_Exception;

190: IF new_references.closed_ind<>
191: UPPER(new_references.closed_ind) Then
192: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: IF upper(column_name) = 'CLOSED_IND' OR
198: column_name is null Then

Line 202: App_Exception.Raise_Exception;

198: column_name is null Then
199: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )Then
200: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: END IF;
205:
206: END Check_Constraints;

Line 225: App_Exception.Raise_Exception;

221: IF NOT IGS_PE_GOV_ABRGRESCD_PKG.Get_PK_For_Validation (
222: new_references.govt_aborig_torres_cd) THEN
223: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227:
228: END IF;
229: END Check_Parent_Existance;

Line 306: App_Exception.Raise_Exception;

302: IGS_GE_MSG_STACK.ADD;
303:
304:
305: Close cur_rowid;
306: App_Exception.Raise_Exception;
307: Return;
308:
309: END IF;
310:

Line 388: App_Exception.Raise_Exception;

384: IF Get_PK_For_Validation (
385: new_references.aborig_torres_cd ) THEN
386: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
387: IGS_GE_MSG_STACK.ADD;
388: App_Exception.Raise_Exception;
389: END IF;
390:
391: Check_Constraints; -- if procedure present
392: Check_Parent_Existance; -- if procedure present

Line 409: App_Exception.Raise_Exception;

405: IF Get_PK_For_Validation (
406: new_references.aborig_torres_cd ) THEN
407: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411:
412: Check_Constraints; -- if procedure present
413: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 501: app_exception.raise_exception;

497: end if;
498: else
499: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
500: IGS_GE_MSG_STACK.ADD;
501: app_exception.raise_exception;
502: end if;
503:
504:
505:

Line 605: App_Exception.Raise_Exception;

601: if (c1%notfound) then
602: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
603:
604: close c1;
605: App_Exception.Raise_Exception;
606: return;
607: end if;
608: close c1;
609:

Line 620: app_exception.raise_exception;

616: ) then
617: null;
618: else
619: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
620: app_exception.raise_exception;
621: end if;
622: return;
623: end LOCK_ROW;
624:

Line 655: app_exception.raise_exception;

651: end if;
652: else
653: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
654: IGS_GE_MSG_STACK.ADD;
655: app_exception.raise_exception;
656: end if;
657:
658:
659: