DBA Data[Home] [Help]

APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on HZ_LOC_ASSIGNMENTS

Line 385: FROM HZ_LOC_ASSIGNMENTS

381: SELECT 'Y'
382: INTO l_loc_assg_exists
383: FROM DUAL
384: WHERE EXISTS ( SELECT 1
385: FROM HZ_LOC_ASSIGNMENTS
386: WHERE LOCATION_ID = p_location_id);
387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: NULL;

Line 429: -- Below code will execute only if there is no record in hz_loc_assignments table

425: X_ADDR_WARN_MSG => x_addr_warn_msg,
426: X_ADDR_VAL_STATUS => x_addr_val_status,
427: X_STATUS => x_return_status);
428: ELSE
429: -- Below code will execute only if there is no record in hz_loc_assignments table
430: -- process_gnr will process the GNR and return success even if there is an error
431: -- in the validation.
432: l_message_count := fnd_msg_pub.count_msg();
433: HZ_GNR_PUB.process_gnr (