APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_NSUS_RTN_DTL_PKG

Line 10900: IF igs_ps_nsus_rtn_dtl_pkg.get_uk_for_validation ( x_non_std_usec_rtn_id => l_n_non_std_usec_rtn_id,

10896: BEGIN
10897:
10898: IF p_insert_update = 'I' THEN
10899: -- Unique Key Validation
10900: IF igs_ps_nsus_rtn_dtl_pkg.get_uk_for_validation ( x_non_std_usec_rtn_id => l_n_non_std_usec_rtn_id,
10901: x_offset_value => p_usec_ret_dtl_rec.offset_value ) THEN
10902: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'RETENTION', 'LEGACY_TOKENS', FALSE);
10903: p_usec_ret_dtl_rec.status := 'W';
10904: RETURN;

Line 10912: igs_ps_nsus_rtn_dtl_pkg.check_constraints('OFFSET_VALUE', p_usec_ret_dtl_rec.offset_value);

10908:
10909:
10910: --Check constraint
10911: BEGIN
10912: igs_ps_nsus_rtn_dtl_pkg.check_constraints('OFFSET_VALUE', p_usec_ret_dtl_rec.offset_value);
10913: EXCEPTION
10914: WHEN OTHERS THEN
10915: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','OFFSET_VALUE','LEGACY_TOKENS',TRUE);
10916: p_usec_ret_dtl_rec.status :='E';

Line 10920: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_PERCENT', p_usec_ret_dtl_rec.retention_percent);

10916: p_usec_ret_dtl_rec.status :='E';
10917: END;
10918:
10919: BEGIN
10920: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_PERCENT', p_usec_ret_dtl_rec.retention_percent);
10921: EXCEPTION
10922: WHEN OTHERS THEN
10923: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','RETENTION_PERCENT','LEGACY_TOKENS',TRUE);
10924: p_usec_ret_dtl_rec.status :='E';

Line 10928: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_AMOUNT', p_usec_ret_dtl_rec.retention_amount);

10924: p_usec_ret_dtl_rec.status :='E';
10925: END;
10926:
10927: BEGIN
10928: igs_ps_nsus_rtn_dtl_pkg.check_constraints('RETENTION_AMOUNT', p_usec_ret_dtl_rec.retention_amount);
10929: EXCEPTION
10930: WHEN OTHERS THEN
10931: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','RETENTION_AMOUNT','LEGACY_TOKENS',TRUE);
10932: p_usec_ret_dtl_rec.status :='E';