DBA Data[Home] [Help]

APPS.IGS_PE_VOTE_INFO_PKG dependencies on APP_EXCEPTION

Line 54: App_Exception.Raise_Exception;

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

Line 129: App_Exception.Raise_Exception;

125: new_references.person_id
126: ) THEN
127: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131:
132: If NOT igs_lookups_view_pkg.get_pk_for_validation('VOTER_INFO' , new_references.voter_info) then
133: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

Line 135: App_Exception.Raise_Exception;

131:
132: If NOT igs_lookups_view_pkg.get_pk_for_validation('VOTER_INFO' , new_references.voter_info) then
133: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: end if;
137:
138:
139: END Check_Parent_Existance;

Line 207: App_Exception.Raise_Exception;

203: IF (cur_rowid%FOUND) THEN
204: Close cur_rowid;
205: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PPT_PP_FK');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: Return;
209: END IF;
210: Close cur_rowid;
211:

Line 284: app_exception.raise_exception;

280: ,new_references.type_code_id
281: ) THEN
282: Fnd_Message.Set_Name ('IGS', 'IGS_PE_VOTE_DUP_EXISTS');
283: IGS_GE_MSG_STACK.ADD;
284: app_exception.raise_exception;
285: END IF;
286: END Check_Uniqueness ;
287:
288:

Line 344: App_Exception.Raise_Exception;

340: IF Get_Pk_For_Validation(
341: new_references.voter_id) THEN
342: Fnd_Message.Set_name('IGS','IGS_PE_VOTE_DUP_EXISTS');
343: IGS_GE_MSG_STACK.ADD;
344: App_Exception.Raise_Exception;
345: END IF;
346: Check_Uniqueness;
347: Check_Constraints;
348: Check_Parent_Existance;

Line 364: App_Exception.Raise_Exception;

360: IF Get_PK_For_Validation (
361: new_references.voter_id) THEN
362: Fnd_Message.Set_name('IGS','IGS_PE_VOTE_DUP_EXISTS');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: Check_Uniqueness;
367: Check_Constraints;
368: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 461: app_exception.raise_exception;

457: end if;
458: else
459: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
460: IGS_GE_MSG_STACK.ADD;
461: app_exception.raise_exception;
462: end if;
463:
464: SELECT IGS_PE_VOTE_INFO_S.NEXTVAL
465: INTO x_voter_id

Line 549: app_exception.raise_exception;

545: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
546: fnd_message.set_token ('ERR_CD', SQLCODE);
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: ELSE
551: igs_sc_gen_001.unset_ctx('R');
552: RAISE;
553: END IF;

Line 601: app_exception.raise_exception;

597: if (c1%notfound) then
598: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
599: IGS_GE_MSG_STACK.ADD;
600: close c1;
601: app_exception.raise_exception;
602: return;
603: end if;
604: close c1;
605: --skpandey. Bug: 4593149

Line 629: app_exception.raise_exception;

625: NULL;
626: ELSE
627: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
628: IGS_GE_MSG_STACK.ADD;
629: app_exception.raise_exception;
630: END IF;
631: RETURN;
632: END LOCK_ROW;
633:

Line 679: app_exception.raise_exception;

675: end if;
676: else
677: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
678: IGS_GE_MSG_STACK.ADD;
679: app_exception.raise_exception;
680: end if;
681:
682: IF (x_VOTER_INFO='COUNTRY') THEN
683: l_TYPE_CODE_ID := NULL;

Line 723: app_exception.raise_exception;

719: if (sql%notfound) then
720: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
721: igs_ge_msg_stack.add;
722: igs_sc_gen_001.unset_ctx('R');
723: app_exception.raise_exception;
724: end if;
725: IF (x_mode = 'S') THEN
726: igs_sc_gen_001.unset_ctx('R');
727: END IF;

Line 741: app_exception.raise_exception;

737: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
738: fnd_message.set_token ('ERR_CD', SQLCODE);
739: igs_ge_msg_stack.add;
740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: ELSE
743: igs_sc_gen_001.unset_ctx('R');
744: RAISE;
745: END IF;

Line 832: app_exception.raise_exception;

828: if (sql%notfound) then
829: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
830: igs_ge_msg_stack.add;
831: igs_sc_gen_001.unset_ctx('R');
832: app_exception.raise_exception;
833: end if;
834: IF (x_mode = 'S') THEN
835: igs_sc_gen_001.unset_ctx('R');
836: END IF;