1172: -- call generic retrieval
1173:
1174:
1175:
1176: HXC_INTEGRATION_LAYER_V1_GRP.execute_retrieval_process (
1177: p_process => 'Maintenance Retrieval Process'
1178: , p_transaction_code => p_transaction_code
1179: , p_start_date => to_date(p_start_date,'DD-MM-YYYY')
1180: , p_end_date => to_date(p_end_date,'DD-MM-YYYY')
1187:
1188:
1189: -- process results of generic retrieval
1190:
1191: g_msg := 'After HXC_INTEGRATION_LAYER_V1_GRP.execute_retrieval_process ';
1192: fnd_file.put_line(FND_FILE.LOG, g_msg);
1193: -- dbms_output.put_line(g_msg);
1194:
1195: g_msg := 'Start Processing of Building Blocks start now ';
1535: end if;
1536:
1537: -- set overall transaction status
1538:
1539: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
1540:
1541: -- tell the generic retrieval to update the transactions statuses
1542:
1543: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status
1539: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
1540:
1541: -- tell the generic retrieval to update the transactions statuses
1542:
1543: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status
1544: (p_process => 'Maintenance Retrieval Process'
1545: ,p_status => 'SUCCESS'
1546: ,p_exception_description => 'Building Block Processed Successfully'
1547: ,p_rollback => FALSE);
1561:
1562: when others then
1563:
1564:
1565: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
1566:
1567: -- tell the generic retrieval to update the transactions statuses
1568:
1569: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status
1565: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
1566:
1567: -- tell the generic retrieval to update the transactions statuses
1568:
1569: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status
1570: (p_process => 'Maintenance Retrieval Process'
1571: ,p_status => 'ERRORS'
1572: ,p_exception_description => SUBSTR(SQLERRM,1,200)
1573: ,p_rollback => FALSE);
1728:
1729: begin
1730:
1731: ---- get time information
1732: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(
1733: p_building_blocks => l_blocks,
1734: p_app_attributes => l_attributes,
1735: p_messages => l_messages);
1736:
1740: ,p_time_attributes => l_attributes
1741: ,p_messages => l_messages );
1742:
1743: --- set time information
1744: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(
1745: p_building_blocks => l_blocks,
1746: p_app_attributes => l_attributes,
1747: p_messages => l_messages);
1748: