DBA Data[Home] [Help]

APPS.ARH_CSU_PKG dependencies on APP_EXCEPTION

Line 361: app_exception.raise_exception;

357: elsif ( p_site_use_code = 'STMTS' ) then
358: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');
359: end if;
360: --
361: app_exception.raise_exception;
362: end if;
363: --
364: end if;
365: --

Line 378: app_exception.raise_exception;

374: and ( ( p_site_use_id is null ) or site_use_id <> p_site_use_id);
375: --
376: if (dummy >= 1) then
377: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_BS_PER_ADDR');
378: app_exception.raise_exception;
379: end if;
380: --
381: --
382: end check_unique_site_use_code;

Line 452: --app_exception.raise_exception;

448: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');
449: x_msg_data := 'AR_CUST_ONE_ACTIVE_STMTS_SITE';
450: end if;
451: --
452: --app_exception.raise_exception;
453: FND_MSG_PUB.ADD;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: x_msg_count := 1;
456: return;

Line 473: --app_exception.raise_exception;

469: and ( ( p_site_use_id is null ) or site_use_id <> p_site_use_id);
470: --
471: if (dummy >= 1) then
472: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_BS_PER_ADDR');
473: --app_exception.raise_exception;
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: x_msg_count := 1;
477: x_msg_data := 'AR_CUST_ONE_ACTIVE_BS_PER_ADDR';

Line 546: app_exception.raise_exception;

542: and rownum = 1;
543: --
544: IF ( dummy >= 1 ) THEN
545: fnd_message.set_name('AR','AR_CUST_DUP_CODE_LOCATION');
546: app_exception.raise_exception;
547: END IF;
548:
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN

Line 619: --app_exception.raise_exception;

615: and rownum = 1;
616: --
617: IF ( dummy >= 1 ) THEN
618: fnd_message.set_name('AR','AR_CUST_DUP_CODE_LOCATION');
619: --app_exception.raise_exception;
620: FND_MSG_PUB.ADD;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: x_msg_count := 1;
623: x_msg_data := 'AR_CUST_DUP_CODE_LOCATION';

Line 692: app_exception.raise_exception;

688: and lookup_code = p_site_use_code;
689: --
690: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_SU');
691: fnd_message.set_token('SITE_CODE',l_site_use_meaning);
692: app_exception.raise_exception;
693: end if;
694: --
695: end check_primary;
696: --