49: from ra_cust_trx_types
50: where cust_trx_type_id = p_trx_type_id ;
51:
52: if (l_rule_set_id = -1) then
53: fnd_message.set_name('AR','AR_NO_RULE_DEFINED');
54: app_exception.raise_exception;
55: end if;
56:
57: arp_util.debug('ARP_APP_CALC_PKG: GET_RULE_SET_ID()- Rule Set Id = '||to_char(l_rule_set_id));
424: OR (sign(charges_remaining) * sign(charges_tax_remaining) < 0 )
425: ) THEN
426:
427: --error an associated tax line cannot be negative when the main line is positive or viceversa.
428: fnd_message.set_name('AR','AR_INVALID_REMAINING');
429: app_exception.raise_exception;
430:
431: ELSE
432: t_line_remaining := line_remaining + line_tax_remaining ;
449:
450: -- error , if one of the remaining amounts is negative then the other have to be
451: -- zero or negative.
452:
453: fnd_message.set_name('AR','AR_INVALID_REMAINING' );
454: app_exception.raise_exception;
455:
456: END IF;
457:
1704: where rule_set_id = p_rule_set_id;
1705: else
1706: -- Error one of the data check rules is not followed the user has to update
1707: -- data before the rule can be frozen.
1708: fnd_message.set_name('AR','AR_INVALID_FREEZE_DATA');
1709: app_exception.raise_exception;
1710:
1711: end if;
1712: