DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on DPP_EXECUTION_DETAILS

Line 626: UPDATE DPP_EXECUTION_DETAILS

622: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);
623:
624: END IF; --IF l_profile_option_value = 'Y' OR l_profile_option_value IS NULL THEN
625:
626: UPDATE DPP_EXECUTION_DETAILS
627: SET execution_end_date = sysdate
628: ,execution_status = DECODE(l_return_status,'S','SUCCESS','WARNING')
629: ,last_update_date = sysdate
630: ,last_updated_by = l_cust_hdr_rec.Last_Updated_By

Line 640: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');

636: WHERE execution_detail_id = l_cust_hdr_rec.Execution_Detail_ID;
637: -- Debug Message
638:
639: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);
640: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');
641:
642: ELSE
643: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
644: FND_MESSAGE.set_token('ID', 'Line Details');