APPS.IGS_PE_PERSON_ALIAS_PKG dependencies on IGS_SC_GEN_001

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

439: x_last_update_login=>X_LAST_UPDATE_LOGIN
440: );
441:
442: IF (x_mode = 'S') THEN
443: igs_sc_gen_001.set_ctx('R');
444: END IF;
445: insert into IGS_PE_PERSON_ALIAS (
446: TITLE,
447: ALIAS_COMMENT,

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

473: X_LAST_UPDATED_BY,
474: X_LAST_UPDATE_LOGIN
475: );
476: IF (x_mode = 'S') THEN
477: igs_sc_gen_001.unset_ctx('R');
478: END IF;
479:
480:
481: open c;

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

495: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
497: fnd_message.set_token ('ERR_CD', SQLCODE);
498: igs_ge_msg_stack.add;
499: igs_sc_gen_001.unset_ctx('R');
500: app_exception.raise_exception;
501: ELSE
502: igs_sc_gen_001.unset_ctx('R');
503: RAISE;

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

498: igs_ge_msg_stack.add;
499: igs_sc_gen_001.unset_ctx('R');
500: app_exception.raise_exception;
501: ELSE
502: igs_sc_gen_001.unset_ctx('R');
503: RAISE;
504: END IF;
505:
506: end INSERT_ROW;

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

621: x_last_updated_by=>X_LAST_UPDATED_BY,
622: x_last_update_login=>X_LAST_UPDATE_LOGIN
623: );
624: IF (x_mode = 'S') THEN
625: igs_sc_gen_001.set_ctx('R');
626: END IF;
627: update IGS_PE_PERSON_ALIAS set
628: TITLE = NEW_REFERENCES.TITLE,
629: ALIAS_COMMENT = NEW_REFERENCES.ALIAS_COMMENT,

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

638: ;
639: if (sql%notfound) then
640: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
641: igs_ge_msg_stack.add;
642: igs_sc_gen_001.unset_ctx('R');
643: app_exception.raise_exception;
644: end if;
645: IF (x_mode = 'S') THEN
646: igs_sc_gen_001.unset_ctx('R');

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

642: igs_sc_gen_001.unset_ctx('R');
643: app_exception.raise_exception;
644: end if;
645: IF (x_mode = 'S') THEN
646: igs_sc_gen_001.unset_ctx('R');
647: END IF;
648:
649: After_DML(
650: p_action => 'UPDATE',

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

655: IF (SQLCODE = (-28115)) THEN
656: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
657: fnd_message.set_token ('ERR_CD', SQLCODE);
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: ELSE
662: igs_sc_gen_001.unset_ctx('R');
663: RAISE;

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

658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: ELSE
662: igs_sc_gen_001.unset_ctx('R');
663: RAISE;
664: END IF;
665:
666: end UPDATE_ROW;

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

726: p_action => 'DELETE',
727: x_rowid => X_ROWID
728: );
729: IF (x_mode = 'S') THEN
730: igs_sc_gen_001.set_ctx('R');
731: END IF;
732: delete from IGS_PE_PERSON_ALIAS
733: where ROWID = X_ROWID;
734: if (sql%notfound) then

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

733: where ROWID = X_ROWID;
734: if (sql%notfound) then
735: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
736: igs_ge_msg_stack.add;
737: igs_sc_gen_001.unset_ctx('R');
738: app_exception.raise_exception;
739: end if;
740: IF (x_mode = 'S') THEN
741: igs_sc_gen_001.unset_ctx('R');

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

737: igs_sc_gen_001.unset_ctx('R');
738: app_exception.raise_exception;
739: end if;
740: IF (x_mode = 'S') THEN
741: igs_sc_gen_001.unset_ctx('R');
742: END IF;
743:
744: After_DML(
745: p_action => 'DELETE',