APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_SP_FEES_PKG

Line 7574: IF igs_ps_usec_sp_fees_pkg.get_uk_for_validation ( x_fee_type => p_usec_sp_fee_rec.fee_type,

7570: BEGIN
7571:
7572: IF p_insert_update = 'I' THEN
7573: /* Unique Key Validation */
7574: IF igs_ps_usec_sp_fees_pkg.get_uk_for_validation ( x_fee_type => p_usec_sp_fee_rec.fee_type,
7575: x_uoo_id => l_n_uoo_id ) THEN
7576: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'FEE_TYPE', 'IGS_FI_LOCKBOX', FALSE);
7577: p_usec_sp_fee_rec.status := 'W';
7578: RETURN;

Line 7600: igs_ps_usec_sp_fees_pkg.check_constraints('CLOSED_FLAG', p_usec_sp_fee_rec.closed_flag);

7596: p_usec_sp_fee_rec.status :='E';
7597: END;
7598:
7599: BEGIN
7600: igs_ps_usec_sp_fees_pkg.check_constraints('CLOSED_FLAG', p_usec_sp_fee_rec.closed_flag);
7601: EXCEPTION
7602: WHEN OTHERS THEN
7603: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','CLOSED_FLAG','LEGACY_TOKENS',TRUE);
7604: p_usec_sp_fee_rec.status :='E';

Line 7608: igs_ps_usec_sp_fees_pkg.check_constraints('SP_FEE_AMT', p_usec_sp_fee_rec.sp_fee_amt);

7604: p_usec_sp_fee_rec.status :='E';
7605: END;
7606:
7607: BEGIN
7608: igs_ps_usec_sp_fees_pkg.check_constraints('SP_FEE_AMT', p_usec_sp_fee_rec.sp_fee_amt);
7609: EXCEPTION
7610: WHEN OTHERS THEN
7611: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99','FEE_AMOUNT','LEGACY_TOKENS',TRUE);
7612: p_usec_sp_fee_rec.status :='E';