APPS.IGS_OR_STATUS_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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

Line 135: App_Exception.Raise_Exception;

131: new_references.org_status
132: ) 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:
138: Check_Constraints ;
139:

Line 156: App_Exception.Raise_Exception;

152: new_references.org_status
153: ) THEN
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158:
159: Check_Constraints ;
160:

Line 214: app_exception.raise_exception;

210:
211: else
212: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
213: IGS_GE_MSG_STACK.ADD;
214: app_exception.raise_exception;
215: end if;
216:
217: Before_DML(
218: p_action=>'INSERT',

Line 289: app_exception.raise_exception;

285: open c1;
286: fetch c1 into tlinfo;
287: if (c1%notfound) then
288: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
289: app_exception.raise_exception;
290: close c1;
291: return;
292: end if;
293: close c1;

Line 302: app_exception.raise_exception;

298: ) then
299: null;
300: else
301: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
302: app_exception.raise_exception;
303: end if;
304: return;
305: end LOCK_ROW;
306:

Line 335: app_exception.raise_exception;

331: end if;
332: else
333: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
334: IGS_GE_MSG_STACK.ADD;
335: app_exception.raise_exception;
336: end if;
337:
338: Before_DML(
339: p_action=>'UPDATE',

Line 454: App_Exception.Raise_Exception ;

450: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
451: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
452: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
453: IGS_GE_MSG_STACK.ADD;
454: App_Exception.Raise_Exception ;
455: END IF;
456:
457: IF new_references.CLOSED_IND not in ('Y','N') then
458: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 460: App_Exception.Raise_Exception ;

456:
457: IF new_references.CLOSED_IND not in ('Y','N') then
458: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
459: IGS_GE_MSG_STACK.ADD;
460: App_Exception.Raise_Exception ;
461: END IF;
462:
463: END IF ;
464:

Line 469: App_Exception.Raise_Exception ;

465: IF upper(Column_name) = 'ORG_STATUS' OR COLUMN_NAME IS NULL THEN
466: IF new_references.ORG_STATUS<> upper(new_references.ORG_STATUS) then
467: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
468: IGS_GE_MSG_STACK.ADD;
469: App_Exception.Raise_Exception ;
470: END IF;
471:
472: END IF ;
473:

Line 478: App_Exception.Raise_Exception ;

474: IF upper(Column_name) = 'S_ORG_STATUS' OR COLUMN_NAME IS NULL THEN
475: IF new_references.S_ORG_STATUS<> upper(new_references.S_ORG_STATUS) then
476: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
477: IGS_GE_MSG_STACK.ADD;
478: App_Exception.Raise_Exception ;
479: END IF;
480: IF new_references.S_ORG_STATUS NOT IN ( 'INACTIVE' , 'ACTIVE' ) then
481: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
482: IGS_GE_MSG_STACK.ADD;

Line 483: App_Exception.Raise_Exception ;

479: END IF;
480: IF new_references.S_ORG_STATUS NOT IN ( 'INACTIVE' , 'ACTIVE' ) then
481: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
482: IGS_GE_MSG_STACK.ADD;
483: App_Exception.Raise_Exception ;
484: END IF;
485:
486: END IF ;
487: