[Home] [Help]
413: * 05-26-2003 Ramesh Ch Bug No:2441276. Added Validation to make
414: * account_number as non updateable.
415: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
416: * ~ HZ Cache will be used instead of querying from
417: * AR System Parameters.
418: * ~ Tax Code, Order Type and Sales Rep are no longer set
419: * at the Cust Account level.
420: */
421:
431: l_dummy VARCHAR2(1);
432: l_rowid ROWID := NULL;
433:
434: -- Bug 3456489
435: -- l_profile AR_SYSTEM_PARAMETERS.generate_customer_number%TYPE;
436: l_profile VARCHAR2(1);
437:
438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
7511:
7512: l_debug_prefix VARCHAR2(30) := ''; -- 'validate_cust_site_use'
7513:
7514: l_dummy VARCHAR2(1);
7515: l_profile AR_SYSTEM_PARAMETERS.auto_site_numbering%TYPE;
7516:
7517: l_cust_acct_site_id NUMBER;
7518: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7519: l_cust_account_id NUMBER;
7927:
7928: -- check if need generate location.
7929: -- BEGIN
7930:
7931: /* 3456489 Refer new HZ_Cache instead of AR System Parameters */
7932:
7933: BEGIN
7934: IF (p_create_update_flag = 'C') THEN
7935: l_profile := HZ_MO_GLOBAL_CACHE.get_auto_site_numbering(
10955: IF p_entity = 'ACCOUNT' THEN
10956:
10957: BEGIN
10958: SELECT MIN(ORG_ID) INTO l_org_id
10959: FROM AR_SYSTEM_PARAMETERS;
10960:
10961: IF l_org_id IS NOT NULL THEN
10962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
10963: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );