735: --
736: --
737: if ( dummy >=1 ) then
738: fnd_message.set_name('AR','AR_CUST_ADDR_REF_EXISTS');
739: app_exception.raise_exception;
740: end if;
741: --
742:
743: end check_unique_orig_system_ref;
1316: --
1317: ELSIF ( x_address_mode = 'STANDARD' ) then
1318: null;
1319: ELSE
1320: app_exception.invalid_argument('arp_addr_pkg.Insert_Row', 'x_address_mode', x_address_mode);
1321: END IF;
1322: --
1323: --
1324: IF ( arp_standard.sysparm.address_validation = 'WARN' ) THEN
1954:
1955: ELSIF ( x_address_mode = 'STANDARD' ) THEN
1956: null;
1957: ELSE
1958: app_exception.invalid_argument('arp_addr_pkg.Insert_Row', 'x_address_mode',
1959: x_address_mode);
1960:
1961: END IF;
1962: --
3522: and addr.orig_system_reference <> p_orig_system_reference;
3523: --
3524: if ( dummy >=1 ) then
3525: fnd_message.set_name('AR','AR_CUST_ADDR_EDI_LOC_EXISTS');
3526: app_exception.raise_exception;
3527: end if;
3528: --
3529: end check_unique_edi_location;
3530: --