APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on FND_CONCURRENT

Line 87: FROM fnd_concurrent_requests

83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_noof_active_busi_events: '||l_noof_active_busi_events);
84:
85: IF ( l_noof_active_busi_events > 0 ) THEN
86: SELECT count(1) INTO l_count
87: FROM fnd_concurrent_requests
88: WHERE concurrent_program_id = ( SELECT concurrent_program_id
89: FROM fnd_concurrent_programs_vl
90: WHERE concurrent_program_name = 'IEXDLMGB')
91: AND ((phase_code = 'R') OR (phase_code = 'P' AND status_code = 'C'));

Line 89: FROM fnd_concurrent_programs_vl

85: IF ( l_noof_active_busi_events > 0 ) THEN
86: SELECT count(1) INTO l_count
87: FROM fnd_concurrent_requests
88: WHERE concurrent_program_id = ( SELECT concurrent_program_id
89: FROM fnd_concurrent_programs_vl
90: WHERE concurrent_program_name = 'IEXDLMGB')
91: AND ((phase_code = 'R') OR (phase_code = 'P' AND status_code = 'C'));
92:
93: iex_debug_pub.logmessage( 'l_count :'||l_count );

Line 691: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

687: DELETE from AR_CONC_PROCESS_REQUESTS
688: where REQUEST_ID = FND_GLOBAL.conc_request_id;
689: commit;
690: if FND_GLOBAL.Conc_Request_Id is not null then
691: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
692: status => 'ERROR',
693: message => 'The process has failed. Please review log file.');
694: end if;
695:

Line 706: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

702: DELETE from AR_CONC_PROCESS_REQUESTS
703: where REQUEST_ID = FND_GLOBAL.conc_request_id;
704: commit;
705: if FND_GLOBAL.Conc_Request_Id is not null then
706: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
707: status => 'ERROR',
708: message => 'The process has failed. Please review log file.');
709: end if;
710: end delete_rows_from_uwq_summ;

Line 776: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',

772: IF is_incompatible THEN
773: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
774: fnd_file.put_line(FND_FILE.LOG,'Populate UWQ Summary is not allowed to be run when event subscriptions are enabled and IEX: Delinquencies Management concurrent program is running');
775: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
776: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
777: message => 'Other Incompatible programs are running. Please check concurrent request log for details');
778: return;
779: END IF;
780: -- Bug13987015 by bibeura

Line 799: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',

795: --Begin Bug 9079404 04-Nov-2009 barathsr
796:
797: if from_date is not null and l_truncate_table='Y' then
798: if FND_GLOBAL.Conc_Request_Id is not null then
799: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
800: message => 'Invalid set of parameters..Pl modify the set of parameters provided.');
801: end if;
802: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Invalid set of parameters..Pl modify the set of parameters provided.');
803: fnd_file.put_line(FND_FILE.LOG,'Invalid set of parameters..Pl modify the set of parameters provided.');

Line 809: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',

805: end if;
806:
807: if from_date is null and l_truncate_table='N' and g_ou_lvl_enb='N' then
808: if FND_GLOBAL.Conc_Request_Id is not null then
809: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
810: message => 'Invalid set of parameters..Pl modify the set of parameters provided.');
811: end if;
812: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Invalid set of parameters..Pl modify the set of parameters provided.');
813: fnd_file.put_line(FND_FILE.LOG,'Invalid set of parameters..Pl modify the set of parameters provided.');

Line 9470: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

9466: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9467: commit;
9468:
9469: if FND_GLOBAL.Conc_Request_Id is not null then
9470: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
9471: status => 'ERROR',
9472: message => 'The process has failed. Please review log file.');
9473: end if;
9474:

Line 9521: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

9517: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9518: commit;
9519:
9520: if FND_GLOBAL.Conc_Request_Id is not null then
9521: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
9522: status => 'ERROR',
9523: message => 'The process has failed. Please review log file.');
9524: end if;
9525:

Line 13547: from fnd_concurrent_requests

13543: MO_GLOBAL.INIT('IEX');
13544: --l_org_id:=mo_global.get_current_org_id;
13545: select org_id
13546: into l_org_id
13547: from fnd_concurrent_requests
13548: where request_id=FND_GLOBAL.CONC_REQUEST_ID;
13549:
13550: if l_org_id is null then
13551: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.