DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on DPP_EXECUTION_DETAILS

Line 619: UPDATE DPP_EXECUTION_DETAILS

615: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');
616: DPP_UTILITY_PVT.debug_message('Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);
617: END IF;
618:
619: UPDATE DPP_EXECUTION_DETAILS
620: SET execution_end_date = sysdate
621: ,execution_status = DECODE(l_return_status,'S','SUCCESS','WARNING')
622: ,last_update_date = sysdate
623: ,last_updated_by = l_cust_hdr_rec.Last_Updated_By

Line 633: DPP_UTILITY_PVT.debug_message(l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');

629: WHERE execution_detail_id = l_cust_hdr_rec.Execution_Detail_ID;
630: -- Debug Message
631: IF g_debug THEN
632: DPP_UTILITY_PVT.debug_message(l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);
633: DPP_UTILITY_PVT.debug_message(l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');
634: END IF;
635: ELSE
636: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
637: FND_MESSAGE.set_token('ID', 'Line Details');