APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_SC_GEN_001

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

3557: );
3558:
3559:
3560: IF (x_mode = 'S') THEN
3561: igs_sc_gen_001.set_ctx('R');
3562: END IF;
3563: INSERT INTO IGS_EN_STDNT_PS_ATT_ALL (
3564: org_id,
3565: ADVANCED_STANDING_IND,

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

3727: NEW_REFERENCES.ATTRIBUTE19,
3728: NEW_REFERENCES.ATTRIBUTE20
3729: );
3730: IF (x_mode = 'S') THEN
3731: igs_sc_gen_001.unset_ctx('R');
3732: END IF;
3733:
3734:
3735: OPEN c;

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

3751: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
3752: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
3753: fnd_message.set_token ('ERR_CD', SQLCODE);
3754: igs_ge_msg_stack.add;
3755: igs_sc_gen_001.unset_ctx('R');
3756: app_exception.raise_exception;
3757: ELSE
3758: igs_sc_gen_001.unset_ctx('R');
3759: RAISE;

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

3754: igs_ge_msg_stack.add;
3755: igs_sc_gen_001.unset_ctx('R');
3756: app_exception.raise_exception;
3757: ELSE
3758: igs_sc_gen_001.unset_ctx('R');
3759: RAISE;
3760: END IF;
3761:
3762: END INSERT_ROW;

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

4315: END IF;
4316: END IF;
4317:
4318: IF (x_mode = 'S') THEN
4319: igs_sc_gen_001.set_ctx('R');
4320: END IF;
4321: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET
4322: ADVANCED_STANDING_IND = NEW_REFERENCES.ADVANCED_STANDING_IND,
4323: FEE_CAT = NEW_REFERENCES.FEE_CAT,

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

4399: WHERE ROWID = X_ROWID;
4400: IF (SQL%NOTFOUND) THEN
4401: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
4402: igs_ge_msg_stack.add;
4403: igs_sc_gen_001.unset_ctx('R');
4404: app_exception.raise_exception;
4405: END IF;
4406: IF (x_mode = 'S') THEN
4407: igs_sc_gen_001.unset_ctx('R');

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

4403: igs_sc_gen_001.unset_ctx('R');
4404: app_exception.raise_exception;
4405: END IF;
4406: IF (x_mode = 'S') THEN
4407: igs_sc_gen_001.unset_ctx('R');
4408: END IF;
4409:
4410:
4411: After_DML (

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

4419: IF (SQLCODE = (-28115)) THEN
4420: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
4421: fnd_message.set_token ('ERR_CD', SQLCODE);
4422: igs_ge_msg_stack.add;
4423: igs_sc_gen_001.unset_ctx('R');
4424: app_exception.raise_exception;
4425: ELSE
4426: igs_sc_gen_001.unset_ctx('R');
4427: RAISE;

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

4422: igs_ge_msg_stack.add;
4423: igs_sc_gen_001.unset_ctx('R');
4424: app_exception.raise_exception;
4425: ELSE
4426: igs_sc_gen_001.unset_ctx('R');
4427: RAISE;
4428: END IF;
4429:
4430: END UPDATE_ROW;

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

4681: p_action => 'DELETE',
4682: x_rowid => X_ROWID
4683: );
4684: IF (x_mode = 'S') THEN
4685: igs_sc_gen_001.set_ctx('R');
4686: END IF;
4687: DELETE FROM IGS_EN_STDNT_PS_ATT_ALL
4688: WHERE ROWID = X_ROWID;
4689: IF (SQL%NOTFOUND) THEN

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

4688: WHERE ROWID = X_ROWID;
4689: IF (SQL%NOTFOUND) THEN
4690: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
4691: igs_ge_msg_stack.add;
4692: igs_sc_gen_001.unset_ctx('R');
4693: app_exception.raise_exception;
4694: END IF;
4695: IF (x_mode = 'S') THEN
4696: igs_sc_gen_001.unset_ctx('R');

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

4692: igs_sc_gen_001.unset_ctx('R');
4693: app_exception.raise_exception;
4694: END IF;
4695: IF (x_mode = 'S') THEN
4696: igs_sc_gen_001.unset_ctx('R');
4697: END IF;
4698:
4699:
4700: After_DML (