508: l_lane_commodity_tbl.DELETE;
509: l_lane_service_tbl.DELETE;
510: x_status := 2;
511: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
512: p_tokens => STRINGARRAY('REGION_NAME'),
513: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
514: l_postal_code_to));
515:
516: RETURN;
509: l_lane_service_tbl.DELETE;
510: x_status := 2;
511: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
512: p_tokens => STRINGARRAY('REGION_NAME'),
513: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
514: l_postal_code_to));
515:
516: RETURN;
517: END;
529: l_lane_commodity_tbl.DELETE;
530: l_lane_service_tbl.DELETE;
531: x_status := 2;
532: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
533: p_tokens => STRINGARRAY('REGION_NAME'),
534: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
535: l_postal_code_to));
536:
537:
530: l_lane_service_tbl.DELETE;
531: x_status := 2;
532: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
533: p_tokens => STRINGARRAY('REGION_NAME'),
534: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
535: l_postal_code_to));
536:
537:
538: RETURN;
551: l_lane_commodity_tbl.DELETE;
552: l_lane_service_tbl.DELETE;
553: x_status := 2;
554: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
555: p_tokens => STRINGARRAY('REGION_NAME'),
556: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
557: l_postal_code_to));
558: RETURN;
559: END;
552: l_lane_service_tbl.DELETE;
553: x_status := 2;
554: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
555: p_tokens => STRINGARRAY('REGION_NAME'),
556: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
557: l_postal_code_to));
558: RETURN;
559: END;
560:
571: l_lane_commodity_tbl.DELETE;
572: l_lane_service_tbl.DELETE;
573: x_status := 2;
574: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
575: p_tokens => STRINGARRAY('REGION_NAME'),
576: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
577: l_postal_code_to));
578: RETURN;
579: END IF;
572: l_lane_service_tbl.DELETE;
573: x_status := 2;
574: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
575: p_tokens => STRINGARRAY('REGION_NAME'),
576: p_values => STRINGARRAY(l_postal_code_from || ' ' ||
577: l_postal_code_to));
578: RETURN;
579: END IF;
580: