DBA Data[Home] [Help]

APPS.IGS_PE_INCOME_TAX_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 126: App_Exception.Raise_Exception;

122: new_references.TAX_INFO
123: ) THEN
124: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128:
129: IF (((old_references.person_id = new_references.person_id)) OR
130: ((new_references.person_id IS NULL))) THEN

Line 137: App_Exception.Raise_Exception;

133: new_references.person_id
134: ) THEN
135: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139:
140: END Check_Parent_Existance;
141:

Line 207: App_Exception.Raise_Exception;

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

Line 281: app_exception.raise_exception;

277: ,new_references.type_code,new_references.type_code_id
278: ) THEN
279: Fnd_Message.Set_Name ('IGS', 'IGS_PE_INCTAX_DUP_EXISTS');
280: IGS_GE_MSG_STACK.ADD;
281: app_exception.raise_exception;
282: END IF;
283: END Check_Uniqueness ;
284:
285:

Line 341: App_Exception.Raise_Exception;

337: IF Get_Pk_For_Validation(
338: new_references.tax_id) THEN
339: Fnd_Message.Set_name('IGS','IGS_PE_INCTAX_DUP_EXISTS');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: END IF;
343: Check_Uniqueness;
344: Check_Constraints;
345: Check_Parent_Existance;

Line 361: App_Exception.Raise_Exception;

357: IF Get_PK_For_Validation (
358: new_references.tax_id) THEN
359: Fnd_Message.Set_name('IGS','IGS_PE_INCTAX_DUP_EXISTS');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: END IF;
363: Check_Uniqueness;
364: Check_Constraints;
365: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 456: app_exception.raise_exception;

452: end if;
453: else
454: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
455: IGS_GE_MSG_STACK.ADD;
456: app_exception.raise_exception;
457: end if;
458: SELECT IGS_PE_INCOME_TAX_S.NEXTVAL
459: INTO X_TAX_ID
460: FROM Dual;

Line 543: app_exception.raise_exception;

539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
540: fnd_message.set_token ('ERR_CD', SQLCODE);
541: igs_ge_msg_stack.add;
542: igs_sc_gen_001.unset_ctx('R');
543: app_exception.raise_exception;
544: ELSE
545: igs_sc_gen_001.unset_ctx('R');
546: RAISE;
547: END IF;

Line 592: app_exception.raise_exception;

588: if (c1%notfound) then
589: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
590: IGS_GE_MSG_STACK.ADD;
591: close c1;
592: app_exception.raise_exception;
593: return;
594: end if;
595: close c1;
596:

Line 621: app_exception.raise_exception;

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

Line 670: app_exception.raise_exception;

666: end if;
667: else
668: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
669: IGS_GE_MSG_STACK.ADD;
670: app_exception.raise_exception;
671: end if;
672:
673: IF (x_TAX_INFO='COUNTRY') THEN
674: l_TYPE_CODE_ID := NULL;

Line 714: app_exception.raise_exception;

710: if (sql%notfound) then
711: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
712: igs_ge_msg_stack.add;
713: igs_sc_gen_001.unset_ctx('R');
714: app_exception.raise_exception;
715: end if;
716: IF (x_mode = 'S') THEN
717: igs_sc_gen_001.unset_ctx('R');
718: END IF;

Line 732: app_exception.raise_exception;

728: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
729: fnd_message.set_token ('ERR_CD', SQLCODE);
730: igs_ge_msg_stack.add;
731: igs_sc_gen_001.unset_ctx('R');
732: app_exception.raise_exception;
733: ELSE
734: igs_sc_gen_001.unset_ctx('R');
735: RAISE;
736: END IF;

Line 827: app_exception.raise_exception;

823: if (sql%notfound) then
824: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: end if;
829: IF (x_mode = 'S') THEN
830: igs_sc_gen_001.unset_ctx('R');
831: END IF;