APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on IGS_RE_SPRVSR_PKG

Line 79: igs_re_sprvsr_pkg.check_constraints ('RESEARCH_SUPERVISOR_TYPE', p_sprvsr_dtls_rec.research_supervisor_type);

75: -- If research supervisor is specified then validate it by calling the check constraints. Incase if there is
76: -- any error it will log an error message "IGS_GE_INVALID_VALUE", which doesn't give much info. to the user.
77: -- So we delete that message and add a meaningful message to the stack.
78:
79: igs_re_sprvsr_pkg.check_constraints ('RESEARCH_SUPERVISOR_TYPE', p_sprvsr_dtls_rec.research_supervisor_type);
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

Line 99: igs_re_sprvsr_pkg.check_constraints ('SUPERVISION_PERCENTAGE', p_sprvsr_dtls_rec.supervision_percentage);

95:
96:
97: IF p_sprvsr_dtls_rec.supervision_percentage IS NOT NULL THEN
98: BEGIN
99: igs_re_sprvsr_pkg.check_constraints ('SUPERVISION_PERCENTAGE', p_sprvsr_dtls_rec.supervision_percentage);
100: EXCEPTION
101: WHEN OTHERS THEN
102: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
103: p_data => l_msg_data);

Line 115: igs_re_sprvsr_pkg.check_constraints ('FUNDING_PERCENTAGE', p_sprvsr_dtls_rec.funding_percentage);

111:
112:
113: IF p_sprvsr_dtls_rec.funding_percentage IS NOT NULL THEN
114: BEGIN
115: igs_re_sprvsr_pkg.check_constraints ('FUNDING_PERCENTAGE', p_sprvsr_dtls_rec.funding_percentage);
116: EXCEPTION
117: WHEN OTHERS THEN
118: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
119: p_data => l_msg_data);

Line 131: igs_re_sprvsr_pkg.check_constraints ('ORG_UNIT_CD', p_sprvsr_dtls_rec.org_unit_cd);

127:
128:
129: IF p_sprvsr_dtls_rec.org_unit_cd IS NOT NULL THEN
130: BEGIN
131: igs_re_sprvsr_pkg.check_constraints ('ORG_UNIT_CD', p_sprvsr_dtls_rec.org_unit_cd);
132: EXCEPTION
133: WHEN OTHERS THEN
134: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
135: p_data => l_msg_data);

Line 430: IF igs_re_sprvsr_pkg.get_uk1_for_validation ( p_ca_person_id, p_ca_sequence_number,

426:
427: -- Check for Unique Key validation. If validation fails, stop the processing and return back
428: -- to the calling procedure.
429:
430: IF igs_re_sprvsr_pkg.get_uk1_for_validation ( p_ca_person_id, p_ca_sequence_number,
431: p_person_id, p_sprvsr_dtls_rec.start_dt ) THEN
432: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_EXTS');
433: FND_MSG_PUB.Add;
434: p_sprvsr_status := 'INVALID';