7517: IF l_line_rec.ship_set_id is not null THEN
7518: BEGIN
7519: SELECT SET_NAME
7520: INTO l_ship_set_name
7521: FROM OE_SETS
7522: WHERE set_id = l_line_rec.ship_set_id;
7523: EXCEPTION
7524: WHEN NO_DATA_FOUND THEN
7525: l_ship_set_name := null;
7529: IF l_line_rec.arrival_set_id is not null THEN
7530: BEGIN
7531: SELECT SET_NAME
7532: INTO l_arrival_set_name
7533: FROM OE_SETS
7534: WHERE set_id = l_line_rec.arrival_set_id;
7535: EXCEPTION
7536: WHEN NO_DATA_FOUND THEN
7537: l_arrival_set_name := null;
7627: IF l_line_rec.ship_set_id is not null THEN
7628: BEGIN
7629: SELECT SET_NAME
7630: INTO l_ship_set_name
7631: FROM OE_SETS
7632: WHERE set_id = l_line_rec.ship_set_id;
7633: EXCEPTION
7634: WHEN NO_DATA_FOUND THEN
7635: l_ship_set_name := null;
7639: IF l_line_rec.arrival_set_id is not null THEN
7640: BEGIN
7641: SELECT SET_NAME
7642: INTO l_arrival_set_name
7643: FROM OE_SETS
7644: WHERE set_id = l_line_rec.arrival_set_id;
7645: EXCEPTION
7646: WHEN NO_DATA_FOUND THEN
7647: l_arrival_set_name := null;