APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_SC_GEN_001

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

3290: X_SS_SOURCE_IND => X_SS_SOURCE_IND
3291: );
3292: --
3293: IF (x_mode = 'S') THEN
3294: igs_sc_gen_001.set_ctx('R');
3295: END IF;
3296: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
3297: PERSON_ID,
3298: COURSE_CD,

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

3458: NEW_REFERENCES.CORE_INDICATOR_CODE,
3459: NEW_REFERENCES.UPD_AUDIT_FLAG,
3460: NEW_REFERENCES.SS_SOURCE_IND );
3461: IF (x_mode = 'S') THEN
3462: igs_sc_gen_001.unset_ctx('R');
3463: END IF;
3464:
3465: OPEN c;
3466: FETCH c INTO X_ROWID;

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

3488: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
3489: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
3490: fnd_message.set_token ('ERR_CD', SQLCODE);
3491: igs_ge_msg_stack.add;
3492: igs_sc_gen_001.unset_ctx('R');
3493: app_exception.raise_exception;
3494: ELSE
3495: igs_sc_gen_001.unset_ctx('R');
3496: RAISE;

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

3491: igs_ge_msg_stack.add;
3492: igs_sc_gen_001.unset_ctx('R');
3493: app_exception.raise_exception;
3494: ELSE
3495: igs_sc_gen_001.unset_ctx('R');
3496: RAISE;
3497: END IF;
3498:
3499: END INSERT_ROW;

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

4052: --
4053: END IF;
4054:
4055: IF (x_mode = 'S') THEN
4056: igs_sc_gen_001.set_ctx('R');
4057: END IF;
4058: UPDATE IGS_EN_SU_ATTEMPT_ALL SET
4059: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
4060: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,

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

4132: WHERE ROWID = X_ROWID;
4133: IF (SQL%NOTFOUND) THEN
4134: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
4135: igs_ge_msg_stack.add;
4136: igs_sc_gen_001.unset_ctx('R');
4137: app_exception.raise_exception;
4138: END IF;
4139: IF (x_mode = 'S') THEN
4140: igs_sc_gen_001.unset_ctx('R');

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

4136: igs_sc_gen_001.unset_ctx('R');
4137: app_exception.raise_exception;
4138: END IF;
4139: IF (x_mode = 'S') THEN
4140: igs_sc_gen_001.unset_ctx('R');
4141: END IF;
4142:
4143: --
4144: After_DML(

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

4156: IF (SQLCODE = (-28115)) THEN
4157: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
4158: fnd_message.set_token ('ERR_CD', SQLCODE);
4159: igs_ge_msg_stack.add;
4160: igs_sc_gen_001.unset_ctx('R');
4161: app_exception.raise_exception;
4162: ELSE
4163: igs_sc_gen_001.unset_ctx('R');
4164: RAISE;

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

4159: igs_ge_msg_stack.add;
4160: igs_sc_gen_001.unset_ctx('R');
4161: app_exception.raise_exception;
4162: ELSE
4163: igs_sc_gen_001.unset_ctx('R');
4164: RAISE;
4165: END IF;
4166:
4167: END UPDATE_ROW;

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

4529: x_rowid => X_ROWID
4530: );
4531:
4532: IF (x_mode = 'S') THEN
4533: igs_sc_gen_001.set_ctx('R');
4534: END IF;
4535: DELETE FROM IGS_EN_SU_ATTEMPT_ALL
4536: WHERE ROWID = X_ROWID;
4537:

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

4537:
4538: IF (SQL%NOTFOUND) THEN
4539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
4540: igs_ge_msg_stack.add;
4541: igs_sc_gen_001.unset_ctx('R');
4542: app_exception.raise_exception;
4543: END IF;
4544: IF (x_mode = 'S') THEN
4545: igs_sc_gen_001.unset_ctx('R');

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

4541: igs_sc_gen_001.unset_ctx('R');
4542: app_exception.raise_exception;
4543: END IF;
4544: IF (x_mode = 'S') THEN
4545: igs_sc_gen_001.unset_ctx('R');
4546: END IF;
4547:
4548: --
4549: After_DML(