APPS.IGS_FI_FEE_AS_RT_PKG dependencies on IGS_SC_GEN_001

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

661: x_last_updated_by=>X_LAST_UPDATED_BY,
662: x_last_update_login=>X_LAST_UPDATE_LOGIN
663: );
664: IF (x_mode = 'S') THEN
665: igs_sc_gen_001.set_ctx('R');
666: END IF;
667: insert into IGS_FI_FEE_AS_RT (
668: PERSON_ID,
669: COURSE_CD,

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

705: X_PROGRAM_APPLICATION_ID,
706: X_PROGRAM_UPDATE_DATE
707: );
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.unset_ctx('R');
710: END IF;
711:
712: open c;
713: fetch c into X_ROWID;

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

725: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
726: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
727: fnd_message.set_token ('ERR_CD', SQLCODE);
728: igs_ge_msg_stack.add;
729: igs_sc_gen_001.unset_ctx('R');
730: app_exception.raise_exception;
731: ELSE
732: igs_sc_gen_001.unset_ctx('R');
733: RAISE;

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

728: igs_ge_msg_stack.add;
729: igs_sc_gen_001.unset_ctx('R');
730: app_exception.raise_exception;
731: ELSE
732: igs_sc_gen_001.unset_ctx('R');
733: RAISE;
734: END IF;
735:
736: end INSERT_ROW;

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

862: IGS_GE_MSG_STACK.ADD;
863: app_exception.raise_exception;
864: end if;
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.set_ctx('R');
867: END IF;
868: update IGS_FI_FEE_AS_RT set
869: END_DT = NEW_REFERENCES.END_DT,
870: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,

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

882: where ROWID = X_ROWID;
883: if (sql%notfound) then
884: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
885: igs_ge_msg_stack.add;
886: igs_sc_gen_001.unset_ctx('R');
887: app_exception.raise_exception;
888: end if;
889: IF (x_mode = 'S') THEN
890: igs_sc_gen_001.unset_ctx('R');

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

886: igs_sc_gen_001.unset_ctx('R');
887: app_exception.raise_exception;
888: end if;
889: IF (x_mode = 'S') THEN
890: igs_sc_gen_001.unset_ctx('R');
891: END IF;
892:
893: After_DML(
894: p_action => 'UPDATE',

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

899: IF (SQLCODE = (-28115)) THEN
900: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
901: fnd_message.set_token ('ERR_CD', SQLCODE);
902: igs_ge_msg_stack.add;
903: igs_sc_gen_001.unset_ctx('R');
904: app_exception.raise_exception;
905: ELSE
906: igs_sc_gen_001.unset_ctx('R');
907: RAISE;

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

902: igs_ge_msg_stack.add;
903: igs_sc_gen_001.unset_ctx('R');
904: app_exception.raise_exception;
905: ELSE
906: igs_sc_gen_001.unset_ctx('R');
907: RAISE;
908: END IF;
909:
910: end UPDATE_ROW;

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

972: p_action => 'DELETE',
973: x_rowid => X_ROWID
974: );
975: IF (x_mode = 'S') THEN
976: igs_sc_gen_001.set_ctx('R');
977: END IF;
978: delete from IGS_FI_FEE_AS_RT
979: where ROWID = X_ROWID;
980: if (sql%notfound) then

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

979: where ROWID = X_ROWID;
980: if (sql%notfound) then
981: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
982: igs_ge_msg_stack.add;
983: igs_sc_gen_001.unset_ctx('R');
984: app_exception.raise_exception;
985: end if;
986: IF (x_mode = 'S') THEN
987: igs_sc_gen_001.unset_ctx('R');

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

983: igs_sc_gen_001.unset_ctx('R');
984: app_exception.raise_exception;
985: end if;
986: IF (x_mode = 'S') THEN
987: igs_sc_gen_001.unset_ctx('R');
988: END IF;
989:
990: After_DML(
991: p_action => 'DELETE',