[Home] [Help]
426: * 05-26-2003 Ramesh Ch Bug No:2441276. Added Validation to make
427: * account_number as non updateable.
428: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
429: * ~ HZ Cache will be used instead of querying from
430: * AR System Parameters.
431: * ~ Tax Code, Order Type and Sales Rep are no longer set
432: * at the Cust Account level.
433: */
434:
444: l_dummy VARCHAR2(1);
445: l_rowid ROWID := NULL;
446:
447: -- Bug 3456489
448: -- l_profile AR_SYSTEM_PARAMETERS.generate_customer_number%TYPE;
449: l_profile VARCHAR2(1);
450:
451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
7786:
7787: l_debug_prefix VARCHAR2(30) := ''; -- 'validate_cust_site_use'
7788:
7789: l_dummy VARCHAR2(1);
7790: l_profile AR_SYSTEM_PARAMETERS.auto_site_numbering%TYPE;
7791:
7792: l_cust_acct_site_id NUMBER;
7793: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7794: l_cust_account_id NUMBER;
8210:
8211: -- check if need generate location.
8212: -- BEGIN
8213:
8214: /* 3456489 Refer new HZ_Cache instead of AR System Parameters */
8215:
8216: BEGIN
8217: IF (p_create_update_flag = 'C') THEN
8218: l_profile := HZ_MO_GLOBAL_CACHE.get_auto_site_numbering(
11246: IF p_entity = 'ACCOUNT' THEN
11247:
11248: BEGIN
11249: SELECT MIN(ORG_ID) INTO l_org_id
11250: FROM AR_SYSTEM_PARAMETERS;
11251:
11252: IF l_org_id IS NOT NULL THEN
11253: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
11254: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );