859:
860: BEGIN
861: SELECT count(*)
862: INTO l_cnt_of_loc_info_gt
863: FROM ZX_PTNR_LOCATION_INFO_GT;
864: EXCEPTION WHEN OTHERS THEN
865: l_cnt_of_loc_info_gt := 0;
866: END;
867:
5266: 'l_cnt_of_line_extns_gt = '||l_cnt_of_line_extns_gt);
5267: BEGIN
5268: SELECT count(*)
5269: INTO l_cnt_of_loc_info_gt
5270: FROM ZX_PTNR_LOCATION_INFO_GT;
5271: EXCEPTION WHEN OTHERS THEN
5272: l_cnt_of_loc_info_gt := 0;
5273: END;
5274: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,