1527:
1528: IF (p_logic_type = 'TRANSFORMATION') THEN
1529:
1530: gcs_lex_map_api_pkg.apply_map(p_api_version => 1.0,
1531: p_init_msg_list => FND_API.G_FALSE,
1532: p_commit => FND_API.G_TRUE,
1533: p_validation_level => NULL,
1534: x_return_status => p_return_status,
1535: x_msg_count => l_msg_count,
1528: IF (p_logic_type = 'TRANSFORMATION') THEN
1529:
1530: gcs_lex_map_api_pkg.apply_map(p_api_version => 1.0,
1531: p_init_msg_list => FND_API.G_FALSE,
1532: p_commit => FND_API.G_TRUE,
1533: p_validation_level => NULL,
1534: x_return_status => p_return_status,
1535: x_msg_count => l_msg_count,
1536: x_msg_data => l_msg_data,
1542:
1543: ELSIF (p_logic_type = 'VALIDATION') THEN
1544:
1545: gcs_lex_map_api_pkg.apply_validation(p_api_version => 1.0,
1546: p_init_msg_list => FND_API.G_FALSE,
1547: p_commit => FND_API.G_TRUE,
1548: p_validation_level => NULL,
1549: x_return_status => p_return_status,
1550: x_msg_count => l_msg_count,
1543: ELSIF (p_logic_type = 'VALIDATION') THEN
1544:
1545: gcs_lex_map_api_pkg.apply_validation(p_api_version => 1.0,
1546: p_init_msg_list => FND_API.G_FALSE,
1547: p_commit => FND_API.G_TRUE,
1548: p_validation_level => NULL,
1549: x_return_status => p_return_status,
1550: x_msg_count => l_msg_count,
1551: x_msg_data => l_msg_data,
1571: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1572: g_api || '.EXECUTE_AUTONOMOUS',
1573: SQLERRM);
1574: END IF;
1575: p_return_status := FND_API.G_RET_STS_ERROR;
1576: END;
1577:
1578: -- End of Private Procedures
1579:
1640: p_set_id => l_datasub_info.transform_rule_set_id,
1641: p_load_id => l_datasub_info.load_id,
1642: p_return_status => l_return_status);
1643:
1644: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1645: p_result := 'COMPLETE:T';
1646: ELSE
1647: p_result := 'COMPLETE:F';
1648: UPDATE gcs_data_sub_dtls
1721: p_set_id => l_datasub_info.validation_rule_set_id,
1722: p_load_id => l_datasub_info.load_id,
1723: p_return_status => l_return_status);
1724:
1725: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1726: p_result := 'COMPLETE:T';
1727: ELSE
1728: p_result := 'COMPLETE:F';
1729: UPDATE gcs_data_sub_dtls