DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_NSUS_RTN_PKG

Line 10243: IF igs_ps_nsus_rtn_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,

10239: BEGIN
10240:
10241: IF p_insert_update = 'I' AND p_usec_ret_rec.definition_level='UNIT_SECTION_FEE_TYPE' THEN
10242: -- Unique Key Validation
10243: IF igs_ps_nsus_rtn_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,
10244: x_fee_type => p_usec_ret_rec.fee_type ) THEN
10245: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'RETENTION', 'LEGACY_TOKENS', FALSE);
10246: p_usec_ret_rec.status := 'W';
10247: RETURN;

Line 10261: igs_ps_nsus_rtn_pkg.check_constraints('FORMULA_METHOD', p_usec_ret_rec.formula_method);

10257:
10258:
10259: --Check constraint
10260: BEGIN
10261: igs_ps_nsus_rtn_pkg.check_constraints('FORMULA_METHOD', p_usec_ret_rec.formula_method);
10262: EXCEPTION
10263: WHEN OTHERS THEN
10264: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','FORMULA_METHOD','LEGACY_TOKENS',TRUE);
10265: p_usec_ret_rec.status :='E';

Line 10269: igs_ps_nsus_rtn_pkg.check_constraints('ROUND_METHOD', p_usec_ret_rec.round_method);

10265: p_usec_ret_rec.status :='E';
10266: END;
10267:
10268: BEGIN
10269: igs_ps_nsus_rtn_pkg.check_constraints('ROUND_METHOD', p_usec_ret_rec.round_method);
10270: EXCEPTION
10271: WHEN OTHERS THEN
10272: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','ROUND_METHOD','LEGACY_TOKENS',TRUE);
10273: p_usec_ret_rec.status :='E';

Line 10277: igs_ps_nsus_rtn_pkg.check_constraints('INCL_WKEND_DURATION_FLAG', p_usec_ret_rec.incl_wkend_duration_flag);

10273: p_usec_ret_rec.status :='E';
10274: END;
10275:
10276: BEGIN
10277: igs_ps_nsus_rtn_pkg.check_constraints('INCL_WKEND_DURATION_FLAG', p_usec_ret_rec.incl_wkend_duration_flag);
10278: EXCEPTION
10279: WHEN OTHERS THEN
10280: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','INCL_WKEND_DURATION_FLAG','LEGACY_TOKENS',TRUE);
10281: p_usec_ret_rec.status :='E';