572: --(3.1)Waiting for the 'Expenditure Detail Report Generation' completed
573: --get its status
574: IF ln_expenditure_detail_req_id<>0
575: THEN
576: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_expenditure_detail_req_id
577: ,interval => ln_waiting_interval
578: ,phase => lv_fsg_req_phase
579: ,status => lv_fsg_req_status
580: ,dev_phase => lv_dev_phase
621: --(4.1)Waiting for the 'Report Item Data Convert program' completed
622: --get its status
623: IF ln_reqid_convert<>0
624: THEN
625: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert
626: ,interval => ln_waiting_interval
627: ,phase => lv_convert_req_phase
628: ,status => lv_convert_req_status
629: ,dev_phase => lv_dev_phase
657: ELSIF lv_convert_req_status_code='E'
658: THEN
659: lv_error_flag:='E';
660: END IF; --lv_fsg_req_status_code='C'
661: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert
662: ELSE
663: lv_error_flag:='E';
664: END IF; --ln_reqid_convert<>0
665:
671: ELSIF lv_fsg_req_status_code='E'
672: THEN
673: lv_error_flag:='E';
674: END IF; --lv_fsg_req_status_code='C'
675: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => ln_expenditure_detail_req_id
676: ELSE
677: lv_error_flag:='E';
678: END IF; --ln_expenditure_detail_req_id<>0
679:
678: END IF; --ln_expenditure_detail_req_id<>0
679:
680: IF lv_error_flag='W'
681: THEN
682: lb_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'WARNING'
683: ,message => ''
684: );
685: ELSIF lv_error_flag='E'
686: THEN
683: ,message => ''
684: );
685: ELSIF lv_error_flag='E'
686: THEN
687: lb_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'ERROR'
688: ,message => ''
689: );
690: END IF;
691: