[Home] [Help]
538: WHEN already_running THEN
539: FND_FILE.PUT_LINE(FND_FILE.LOG, x_out_msg);
540: x_return_status := fnd_api.G_RET_STS_ERROR;
541:
542: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_module||' failed to complete.');
543:
544: Print_MessageStack;
545:
546: WHEN program_exception THEN
557: IF l_errorLog THEN
558: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
559: END IF;
560:
561: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_module||' failed to complete.');
562:
563: DECLARE
564: l_cnt NUMBER;
565: l_data VARCHAR2(2000);
594: END IF;
595:
596: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Match_RevenueCOGS:'||substrb(SQLERRM,1,250) );
597:
598: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_module||' failed to complete.');
599:
600: Print_MessageStack;
601:
602: END Match_RevenueCOGS;
5564: -- free temporary memory
5565:
5566: dbms_lob.freetemporary(l_xml_doc);
5567:
5568: l_success := fnd_concurrent.set_completion_status('NORMAL', 'Request Completed Successfully');
5569:
5570: -- Write the module name to fnd log file
5571:
5572: debug('errcode = '||errcode);
5594: x_return_status => l_return_status
5595: );
5596:
5597: l_msg_data := substrb(SQLERRM,1,240);
5598: l_success := fnd_concurrent.set_completion_status('ERROR', l_msg_data);
5599:
5600: when others then
5601: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
5602: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
5620: x_return_status => l_return_status
5621: );
5622:
5623: l_msg_data := substrb(SQLERRM,1,240);
5624: l_success := fnd_concurrent.set_completion_status('ERROR', l_msg_data);
5625:
5626: end Generate_DefCOGSXml;
5627:
5628:
7306: ,l_rowid_tab;
7307: CLOSE c_activity;
7308: FOR i IN l_req_id_tab.FIRST .. l_req_id_tab.LAST LOOP
7309: debug(' Status verification for the request '||l_req_id_tab(i));
7310: l_res := FND_CONCURRENT.GET_REQUEST_STATUS
7311: (request_id => l_req_id_tab(i)
7312: ,phase => l_phase
7313: ,status => l_status
7314: ,dev_phase => l_dev_phase
7356: , x_out_msg OUT NOCOPY VARCHAR2)
7357: IS
7358: /* CURSOR cu_program_id IS
7359: SELECT concurrent_program_id
7360: FROM fnd_concurrent_programs
7361: WHERE application_id = p_app_id
7362: AND concurrent_program_name = p_prg_name;
7363:
7364: CURSOR cu_exec(p_prg_id IN NUMBER) IS
7362: AND concurrent_program_name = p_prg_name;
7363:
7364: CURSOR cu_exec(p_prg_id IN NUMBER) IS
7365: SELECT NULL
7366: FROM fnd_concurrent_requests FCR
7367: WHERE FCR.program_application_id = 702
7368: AND FCR.concurrent_program_id = p_prg_id
7369: AND (FCR.argument3 = TO_CHAR(p_ledger_id) OR
7370: -- User submits a request for ledger A and CP for all ledger is running
7375:
7376: -- User submits CP for all ledgers and CP for ledger A is running
7377: CURSOR cu_exec_all(p_prg_id IN NUMBER) IS
7378: SELECT NULL
7379: FROM fnd_concurrent_requests FCR
7380: WHERE FCR.program_application_id = 702
7381: AND FCR.concurrent_program_id = p_prg_id
7382: AND FCR.phase_code = 'R'
7383: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID
7384: AND ROWNUM = 1; */
7385:
7386: CURSOR cu_exec IS
7387: SELECT FCP.user_concurrent_program_name
7388: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP
7389: WHERE FCR.program_application_id = p_app_id
7390: AND FCP.application_id = p_app_id
7391: AND (FCR.argument3 = TO_CHAR(p_ledger_id) OR
7392: -- User submits a request for ledger A and CP for all ledger is running
7397: AND FCP.concurrent_program_name IN ('CSTRCMCR1','CSTRCMCR','CSTRCMCR3');
7398:
7399: CURSOR cu_exec_all IS
7400: SELECT FCP.user_concurrent_program_name
7401: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP
7402: WHERE FCR.program_application_id = p_app_id
7403: AND FCP.application_id = p_app_id
7404: AND FCR.phase_code = 'R'
7405: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID