APPS.IGS_PS_OCCUP_TITLES_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;
55: Close cur_old_ref_values;
56:

Line 125: app_exception.raise_exception;

121: ,new_references.program_code
122: ) THEN
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
124: IGS_GE_MSG_STACK.ADD;
125: app_exception.raise_exception;
126: END IF;
127: END Check_Uniqueness ;
128: PROCEDURE Check_Parent_Existance AS
129:

Line 160: App_Exception.Raise_Exception;

156: new_references.occupational_title_code
157: ) THEN
158: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162:
163: Open cur_rowid;
164: Fetch cur_rowid INTO lv_rowid;

Line 169: App_Exception.Raise_Exception;

165: IF (cur_rowid%NOTFOUND) THEN
166: Close cur_rowid;
167: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171:
172: END Check_Parent_Existance;
173:

Line 280: App_Exception.Raise_Exception;

276: IF (cur_rowid%FOUND) THEN
277: Close cur_rowid;
278: Fnd_Message.Set_Name ('IGS', 'IGS_PS_OCT_DOT_FK');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: Return;
282: END IF;
283: Close cur_rowid;
284:

Line 317: App_Exception.Raise_Exception;

313: IF (cur_rowid%FOUND) THEN
314: Close cur_rowid;
315: Fnd_Message.Set_Name ('IGS', 'IGS_PS_OCT_CRV_FK');
316: IGS_GE_MSG_STACK.ADD;
317: App_Exception.Raise_Exception;
318: Return;
319: END IF;
320: Close cur_rowid;
321:

Line 375: App_Exception.Raise_Exception;

371: IF Get_Pk_For_Validation(
372: new_references.program_occupational_title_id) THEN
373: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Uniqueness;
378: Check_Constraints;
379: Check_Parent_Existance;

Line 395: App_Exception.Raise_Exception;

391: IF Get_PK_For_Validation (
392: new_references.program_occupational_title_id) THEN
393: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397: Check_Uniqueness;
398: Check_Constraints;
399: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 488: app_exception.raise_exception;

484: end if;
485: else
486: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490:
491: SELECT igs_ps_dic_occ_titls_s.nextval
492: INTO x_prgm_occupational_title_id

Line 569: app_exception.raise_exception;

565: if (c1%notfound) then
566: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
567: IGS_GE_MSG_STACK.ADD;
568: close c1;
569: app_exception.raise_exception;
570: return;
571: end if;
572: close c1;
573: if ( ( tlinfo.PROGRAM_CODE = X_PROGRAM_CODE)

Line 580: app_exception.raise_exception;

576: null;
577: else
578: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
579: IGS_GE_MSG_STACK.ADD;
580: app_exception.raise_exception;
581: end if;
582: return;
583: end LOCK_ROW;
584: Procedure UPDATE_ROW (

Line 622: app_exception.raise_exception;

618: end if;
619: else
620: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
621: IGS_GE_MSG_STACK.ADD;
622: app_exception.raise_exception;
623: end if;
624: Before_DML(
625: p_action=>'UPDATE',
626: x_rowid=>X_ROWID,