DBA Data[Home] [Help]

APPS.IGS_PE_VOTE_INFO_PKG dependencies on IGS_GE_MSG_STACK

Line 53: IGS_GE_MSG_STACK.ADD;

49: Fetch cur_old_ref_values INTO old_references;
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;

Line 128: IGS_GE_MSG_STACK.ADD;

124: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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

Line 134: IGS_GE_MSG_STACK.ADD;

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');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: end if;
137:
138:

Line 206: IGS_GE_MSG_STACK.ADD;

202: Fetch cur_rowid INTO lv_rowid;
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;

Line 283: IGS_GE_MSG_STACK.ADD;

279: ,new_references.type_code
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:

Line 343: IGS_GE_MSG_STACK.ADD;

339: Null;
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;

Line 363: IGS_GE_MSG_STACK.ADD;

359: -- Call all the procedures related to Before Insert.
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;

Line 460: IGS_GE_MSG_STACK.ADD;

456: X_LAST_UPDATE_LOGIN := -1;
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

Line 547: igs_ge_msg_stack.add;

543: WHEN OTHERS THEN
544: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 599: IGS_GE_MSG_STACK.ADD;

595: open c1;
596: fetch c1 into tlinfo;
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;

Line 628: IGS_GE_MSG_STACK.ADD;

624: ) THEN
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;

Line 678: IGS_GE_MSG_STACK.ADD;

674: X_LAST_UPDATE_LOGIN := -1;
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

Line 721: igs_ge_msg_stack.add;

717: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
718: where ROWID = X_ROWID;
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

Line 739: igs_ge_msg_stack.add;

735: WHEN OTHERS THEN
736: IF (SQLCODE = (-28115)) THEN
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');

Line 830: igs_ge_msg_stack.add;

826: delete from igs_pe_vote_info_all
827: where ROWID = X_ROWID;
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