DBA Data[Home] [Help]

APPS.IGS_PE_INCOME_TAX_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 125: IGS_GE_MSG_STACK.ADD;

121: 'TAX_INFO',
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

Line 136: IGS_GE_MSG_STACK.ADD;

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

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_PIT_PP_FK');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: Return;
209: END IF;
210: Close cur_rowid;

Line 280: IGS_GE_MSG_STACK.ADD;

276: new_references.person_id
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:

Line 340: IGS_GE_MSG_STACK.ADD;

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

Line 360: IGS_GE_MSG_STACK.ADD;

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

Line 455: IGS_GE_MSG_STACK.ADD;

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

Line 541: igs_ge_msg_stack.add;

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

Line 590: IGS_GE_MSG_STACK.ADD;

586: open c1;
587: fetch c1 into tlinfo;
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;

Line 620: IGS_GE_MSG_STACK.ADD;

616: ) then
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;

Line 669: IGS_GE_MSG_STACK.ADD;

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

Line 712: igs_ge_msg_stack.add;

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

Line 730: igs_ge_msg_stack.add;

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

Line 825: igs_ge_msg_stack.add;

821: delete from IGS_PE_INCOME_TAX_ALL
822: where ROWID = X_ROWID;
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