APPS.FTE_LTL_LOADER dependencies on WSH_REGIONS_PKG

Line 3636: WSH_REGIONS_PKG.UPDATE_ZONE(p_insert_type => 'INSERT',

3632: IF (l_zones_temp.zone_name(l_counter) <> l_previous_name) THEN
3633: --+
3634: -- Anytime that the ZONE NAME changes we have to create a new ZONE
3635: --+
3636: WSH_REGIONS_PKG.UPDATE_ZONE(p_insert_type => 'INSERT',
3637: p_zone_id => '',
3638: p_zone_name => l_zone_name,
3639: p_zone_level => 11,
3640: p_zone_type => 11,

Line 3664: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Zone ID is NULL after WSH_REGIONS_PKG.Update_Zone ');

3660:
3661: IF (l_zone_id IS NULL) THEN
3662: x_status := 2;
3663: x_error_msg := 'Zone ID is NULL';
3664: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Zone ID is NULL after WSH_REGIONS_PKG.Update_Zone ');
3665: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zone_name',l_zone_name);
3666: FTE_UTIL_PKG.Exit_Debug(l_module_name);
3667: RETURN;
3668: END IF;

Line 3719: WSH_REGIONS_PKG.UPDATE_ZONE_REGION(p_insert_type => 'INSERT',

3715: END;
3716:
3717: END IF;
3718:
3719: WSH_REGIONS_PKG.UPDATE_ZONE_REGION(p_insert_type => 'INSERT',
3720: p_zone_region_id => null,
3721: p_zone_id => l_zone_id,
3722: p_region_id => null,
3723: p_country => '',