187: ELSE
188:
189: IF (p_mode <> 'NO_EXCEPTION')
190: THEN
191: app_exception.raise_exception;
192: END IF;
193: END IF;
194:
195:
354: IF duptrx%FOUND THEN
355: -- a transaction number with the same value already exists,
356: -- so disallow the creation of another with the same name.
357: fnd_message.set_name('AR', 'AR_TW_INVALID_TRX_NUMBER');
358: app_exception.raise_exception;
359: END IF;
360:
361: CLOSE duptrx;
362:
438: AND ril.document_number = p_doc_sequence_value
439: AND ril.customer_trx_id <> NVL(p_customer_trx_id, -99);
440:
441: fnd_message.set_name('FND', 'UNIQUE-DUPLICATE SEQUENCE');
442: app_exception.raise_exception;
443:
444: END IF;
445:
446: EXCEPTION
510:
511: IF (l_count > 0)
512: THEN
513: fnd_message.set_name('AR', 'AR_TW_DUP_LINE_NUM');
514: app_exception.raise_exception;
515: END IF;
516:
517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');
518:
581: IF (p_display_message = 'Y')
582: THEN fnd_message.set_name('AR', '1210');
583: END IF;
584:
585: app_exception.raise_exception;
586: END IF;
587:
588: arp_util.debug('arp_trx_validate.check_has_one_line()-');
589:
2444: TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
2445:
2446: END IF;
2447:
2448: app_exception.raise_exception;
2449:
2450: END IF;
2451:
2452: IF PG_DEBUG in ('Y', 'C') THEN