573: l_result = 2
574: )
575: THEN
576: arp_util.debug('Form periods exist validation failed');
577: fnd_message.set_name('AR', 'AR_RAXTRX-1783');
578: app_exception.raise_exception;
579: END IF;
580:
581:
591:
592: IF ( l_count <> 0 )
593: THEN
594: arp_util.debug('Form overlapping periods validation failed');
595: fnd_message.set_name('AR', 'AR_RAXTRX-1784');
596: app_exception.raise_exception;
597: END IF;
598:
599:
906: +---------------------------*/
907:
908: IF ( p_customer_trx_id IS NULL )
909: THEN
910: fnd_message.set_name('AR', 'AR_INV_ARGS');
911: fnd_message.set_token('PROCEDURE',
912: 'derive_gl_trx_dates_from_rules()');
913: app_exception.raise_exception;
914:
907:
908: IF ( p_customer_trx_id IS NULL )
909: THEN
910: fnd_message.set_name('AR', 'AR_INV_ARGS');
911: fnd_message.set_token('PROCEDURE',
912: 'derive_gl_trx_dates_from_rules()');
913: app_exception.raise_exception;
914:
915: END IF;
1045: to_char( l_candidate_date ) ||
1046: ' closing status: ' ||
1047: l_closing_status);
1048:
1049: fnd_message.set_name('AR', 'AR_TW_NO_PERIOD_DEFINED');
1050: fnd_message.set_token('DATE',
1051: to_char( l_candidate_date ));
1052: app_exception.raise_exception;
1053: END IF;
1046: ' closing status: ' ||
1047: l_closing_status);
1048:
1049: fnd_message.set_name('AR', 'AR_TW_NO_PERIOD_DEFINED');
1050: fnd_message.set_token('DATE',
1051: to_char( l_candidate_date ));
1052: app_exception.raise_exception;
1053: END IF;
1054:
1078: l_defaulting_rule_used,
1079: l_error_message
1080: ) = FALSE
1081: )
1082: THEN fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1083: fnd_message.set_token('GENERIC_TEXT',
1084: l_error_message);
1085: fnd_message.set_name('AR', 'AR_TW_DERIVE_FAILURE');
1086: arp_util.debug(l_error_message);
1079: l_error_message
1080: ) = FALSE
1081: )
1082: THEN fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1083: fnd_message.set_token('GENERIC_TEXT',
1084: l_error_message);
1085: fnd_message.set_name('AR', 'AR_TW_DERIVE_FAILURE');
1086: arp_util.debug(l_error_message);
1087: app_exception.raise_exception;
1081: )
1082: THEN fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1083: fnd_message.set_token('GENERIC_TEXT',
1084: l_error_message);
1085: fnd_message.set_name('AR', 'AR_TW_DERIVE_FAILURE');
1086: arp_util.debug(l_error_message);
1087: app_exception.raise_exception;
1088: ELSE arp_util.debug('defaulting rule used: ' ||
1089: l_defaulting_rule_used,