1547: IF l_material_rec.source_org_id IS NOT NULL THEN
1548: BEGIN
1549: SELECT organization_code ||'-'||organization_name
1550: INTO l_material_rec.trading_partner
1551: FROM org_organization_definitions
1552: WHERE organization_id = l_material_rec.source_org_id;
1553: EXCEPTION
1554: WHEN no_data_found THEN
1555: IF l_debug = 1 THEN
1673: IF l_material_rec.source_org_id IS NOT NULL THEN
1674: BEGIN
1675: SELECT organization_code ||'-'||organization_name
1676: INTO l_material_rec.trading_partner
1677: FROM org_organization_definitions
1678: WHERE organization_id = l_material_rec.source_org_id;
1679: EXCEPTION
1680: WHEN no_data_found THEN
1681: IF l_debug = 1 THEN