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