1492: END IF;
1493:
1494: x_completion_code := 0;
1495:
1496: FEM_SOURCE_DATA_LOADER_PKG.Validate_Obj_Def(
1497: p_api_version => G_API_VERSION,
1498: p_object_type => C_OBJECT_TYPE,
1499: p_obj_def_id => pv_obj_def_id,
1500: x_object_id => v_object_id,
1503: x_msg_data => v_msg_data,
1504: x_return_status => v_return_status);
1505:
1506: IF v_msg_count > 0 THEN
1507: FEM_SOURCE_DATA_LOADER_PKG.Get_Put_Messages (
1508: p_msg_count => v_msg_count,
1509: p_msg_data => v_msg_data);
1510: END IF;
1511:
1512: pv_table_name := v_table_name;
1513: pv_interface_table_name := v_table_name||'_T';
1514:
1515: IF v_return_status = G_RET_STS_SUCCESS THEN
1516: FEM_SOURCE_DATA_LOADER_PKG.Validate_Table(
1517: p_api_version => G_API_VERSION,
1518: p_object_type => C_OBJECT_TYPE,
1519: p_table_name => pv_table_name,
1520: p_table_classification => C_TABLE_CLASSIFICATION,
1522: x_msg_data => v_msg_data,
1523: x_return_status => v_return_status);
1524:
1525: IF v_msg_count > 0 THEN
1526: FEM_SOURCE_DATA_LOADER_PKG.Get_Put_Messages (
1527: p_msg_count => v_msg_count,
1528: p_msg_data => v_msg_data);
1529: END IF;
1530:
1530:
1531: END IF;
1532:
1533: IF v_return_status = G_RET_STS_SUCCESS THEN
1534: FEM_SOURCE_DATA_LOADER_PKG.Validate_Ledger(
1535: p_api_version => G_API_VERSION,
1536: p_object_type => C_OBJECT_TYPE,
1537: p_ledger_id => pv_ledger_id,
1538: x_ledger_dc => v_ledger_dc,
1542: x_msg_data => v_msg_data,
1543: x_return_status => v_return_status);
1544:
1545: IF v_msg_count > 0 THEN
1546: FEM_SOURCE_DATA_LOADER_PKG.Get_Put_Messages (
1547: p_msg_count => v_msg_count,
1548: p_msg_data => v_msg_data);
1549: END IF;
1550:
1550:
1551: END IF;
1552:
1553: IF v_return_status = G_RET_STS_SUCCESS THEN
1554: FEM_SOURCE_DATA_LOADER_PKG.Validate_Cal_Period(
1555: p_api_version => G_API_VERSION,
1556: p_object_type => C_OBJECT_TYPE,
1557: p_cal_period_id => pv_cal_period_id,
1558: p_ledger_id => pv_ledger_id,
1565: x_msg_data => v_msg_data,
1566: x_return_status => v_return_status);
1567:
1568: IF v_msg_count > 0 THEN
1569: FEM_SOURCE_DATA_LOADER_PKG.Get_Put_Messages (
1570: p_msg_count => v_msg_count,
1571: p_msg_data => v_msg_data);
1572: END IF;
1573: END IF;
1572: END IF;
1573: END IF;
1574:
1575: IF v_return_status = G_RET_STS_SUCCESS THEN
1576: FEM_SOURCE_DATA_LOADER_PKG.Validate_Dataset(
1577: p_api_version => G_API_VERSION,
1578: p_object_type => C_OBJECT_TYPE,
1579: p_dataset_code => pv_dataset_code,
1580: x_dataset_dc => v_dataset_dc,
1582: x_msg_data => v_msg_data,
1583: x_return_status => v_return_status);
1584:
1585: IF v_msg_count > 0 THEN
1586: FEM_SOURCE_DATA_LOADER_PKG.Get_Put_Messages (
1587: p_msg_count => v_msg_count,
1588: p_msg_data => v_msg_data);
1589: END IF;
1590: END IF;
1589: END IF;
1590: END IF;
1591:
1592: IF v_return_status = G_RET_STS_SUCCESS THEN
1593: FEM_SOURCE_DATA_LOADER_PKG.Validate_Source_System(
1594: p_api_version => G_API_VERSION,
1595: p_object_type => C_OBJECT_TYPE,
1596: p_source_system_code => pv_source_system_code,
1597: x_source_system_dc => v_source_system_dc,
1599: x_msg_data => v_msg_data,
1600: x_return_status => v_return_status);
1601:
1602: IF v_msg_count > 0 THEN
1603: FEM_SOURCE_DATA_LOADER_PKG.Get_Put_Messages (
1604: p_msg_count => v_msg_count,
1605: p_msg_data => v_msg_data);
1606: END IF;
1607: END IF;