DBA Data[Home] [Help]

APPS.IGS_PE_INCOME_TAX_PKG dependencies on IGS_SC_GEN_001

Line 489: igs_sc_gen_001.set_ctx('R');

485: x_last_update_login=>X_LAST_UPDATE_LOGIN);
486:
487:
488: IF (x_mode = 'S') THEN
489: igs_sc_gen_001.set_ctx('R');
490: END IF;
491: insert into IGS_PE_INCOME_TAX_ALL (
492: TAX_ID
493: ,PERSON_ID

Line 521: igs_sc_gen_001.unset_ctx('R');

517: ,X_LAST_UPDATED_BY
518: ,X_LAST_UPDATE_LOGIN
519: );
520: IF (x_mode = 'S') THEN
521: igs_sc_gen_001.unset_ctx('R');
522: END IF;
523:
524:
525:

Line 542: igs_sc_gen_001.unset_ctx('R');

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');
546: RAISE;

Line 545: igs_sc_gen_001.unset_ctx('R');

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;
548:
549: end INSERT_ROW;

Line 697: igs_sc_gen_001.set_ctx('R');

693: x_last_update_date=>X_LAST_UPDATE_DATE,
694: x_last_updated_by=>X_LAST_UPDATED_BY,
695: x_last_update_login=>X_LAST_UPDATE_LOGIN);
696: IF (x_mode = 'S') THEN
697: igs_sc_gen_001.set_ctx('R');
698: END IF;
699: update IGS_PE_INCOME_TAX_ALL set
700: PERSON_ID = NEW_REFERENCES.PERSON_ID,
701: TAX_INFO = NEW_REFERENCES.TAX_INFO,

Line 713: igs_sc_gen_001.unset_ctx('R');

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
717: igs_sc_gen_001.unset_ctx('R');

Line 717: igs_sc_gen_001.unset_ctx('R');

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;
719:
720:
721: After_DML (

Line 731: igs_sc_gen_001.unset_ctx('R');

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');
735: RAISE;

Line 734: igs_sc_gen_001.unset_ctx('R');

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;
737:
738: end UPDATE_ROW;

Line 819: igs_sc_gen_001.set_ctx('R');

815: p_action => 'DELETE',
816: x_rowid => X_ROWID
817: );
818: IF (x_mode = 'S') THEN
819: igs_sc_gen_001.set_ctx('R');
820: END IF;
821: delete from IGS_PE_INCOME_TAX_ALL
822: where ROWID = X_ROWID;
823: if (sql%notfound) then

Line 826: igs_sc_gen_001.unset_ctx('R');

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
830: igs_sc_gen_001.unset_ctx('R');

Line 830: igs_sc_gen_001.unset_ctx('R');

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;
832:
833: After_DML (
834: p_action => 'DELETE',