1484: IF l_material_rec.source_org_id IS NOT NULL THEN
1485: BEGIN
1486: SELECT organization_code ||'-'||organization_name
1487: INTO l_material_rec.trading_partner
1488: FROM org_organization_definitions
1489: WHERE organization_id = l_material_rec.source_org_id;
1490: EXCEPTION
1491: WHEN no_data_found THEN
1492: IF l_debug = 1 THEN
1602: IF l_material_rec.source_org_id IS NOT NULL THEN
1603: BEGIN
1604: SELECT organization_code ||'-'||organization_name
1605: INTO l_material_rec.trading_partner
1606: FROM org_organization_definitions
1607: WHERE organization_id = l_material_rec.source_org_id;
1608: EXCEPTION
1609: WHEN no_data_found THEN
1610: IF l_debug = 1 THEN