APPS.IGS_AD_TERM_DETAILS_PKG dependencies on IGS_SC_GEN_001

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

544: x_last_update_date=>X_LAST_UPDATE_DATE,
545: x_last_updated_by=>X_LAST_UPDATED_BY,
546: x_last_update_login=>X_LAST_UPDATE_LOGIN);
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.set_ctx('R');
549: END IF;
550: insert into IGS_AD_TERM_DETAILS (
551: TERM_DETAILS_ID
552: ,TRANSCRIPT_ID

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

588: ,X_PROGRAM_APPLICATION_ID
589: ,X_PROGRAM_UPDATE_DATE
590: )RETURNING TERM_DETAILS_ID INTO X_TERM_DETAILS_ID;
591: IF (x_mode = 'S') THEN
592: igs_sc_gen_001.unset_ctx('R');
593: END IF;
594:
595: open c;
596: fetch c into X_ROWID;

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

607: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
608: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
609: fnd_message.set_token ('ERR_CD', SQLCODE);
610: igs_ge_msg_stack.add;
611: igs_sc_gen_001.unset_ctx('R');
612: app_exception.raise_exception;
613: ELSE
614: igs_sc_gen_001.unset_ctx('R');
615: RAISE;

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

610: igs_ge_msg_stack.add;
611: igs_sc_gen_001.unset_ctx('R');
612: app_exception.raise_exception;
613: ELSE
614: igs_sc_gen_001.unset_ctx('R');
615: RAISE;
616: END IF;
617:
618: end INSERT_ROW;

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

776: end if;
777: end if;
778:
779: IF (x_mode = 'S') THEN
780: igs_sc_gen_001.set_ctx('R');
781: END IF;
782: update IGS_AD_TERM_DETAILS set
783: TRANSCRIPT_ID = NEW_REFERENCES.TRANSCRIPT_ID,
784: TERM = NEW_REFERENCES.TERM,

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

799: where ROWID = X_ROWID;
800: if (sql%notfound) then
801: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
802: igs_ge_msg_stack.add;
803: igs_sc_gen_001.unset_ctx('R');
804: app_exception.raise_exception;
805: end if;
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.unset_ctx('R');

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

803: igs_sc_gen_001.unset_ctx('R');
804: app_exception.raise_exception;
805: end if;
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.unset_ctx('R');
808: END IF;
809:
810:
811: After_DML (

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

817: IF (SQLCODE = (-28115)) THEN
818: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
819: fnd_message.set_token ('ERR_CD', SQLCODE);
820: igs_ge_msg_stack.add;
821: igs_sc_gen_001.unset_ctx('R');
822: app_exception.raise_exception;
823: ELSE
824: igs_sc_gen_001.unset_ctx('R');
825: RAISE;

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

820: igs_ge_msg_stack.add;
821: igs_sc_gen_001.unset_ctx('R');
822: app_exception.raise_exception;
823: ELSE
824: igs_sc_gen_001.unset_ctx('R');
825: RAISE;
826: END IF;
827:
828: end UPDATE_ROW;

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

909: p_action => 'DELETE',
910: x_rowid => X_ROWID
911: );
912: IF (x_mode = 'S') THEN
913: igs_sc_gen_001.set_ctx('R');
914: END IF;
915: delete from IGS_AD_TERM_DETAILS
916: where ROWID = X_ROWID;
917: if (sql%notfound) then

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

916: where ROWID = X_ROWID;
917: if (sql%notfound) then
918: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: end if;
923: IF (x_mode = 'S') THEN
924: igs_sc_gen_001.unset_ctx('R');

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

920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: end if;
923: IF (x_mode = 'S') THEN
924: igs_sc_gen_001.unset_ctx('R');
925: END IF;
926:
927: After_DML (
928: p_action => 'DELETE',