eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_CREATE_REQUESTSET dependencies on BIS_COLLECTION_UTILITIES

Line 3441: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ', can not moniter the status!' );

3437: l_req_id := p_req_id;
3438: -- make it runnable under sql-plus, as the current req-id will be
3439: -- set to -1.
3440: if l_req_id = -1 THEN
3441: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ', can not moniter the status!' );
3442: return TRUE;
3443: end if;
3444:
3445: l_call_status := FND_CONCURRENT.get_request_status(l_req_id , null, null,

Line 3452: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' not exists' );

3448: RAISE_APPLICATION_ERROR (-20000,'Error happened in request: ' || l_req_id);
3449: end if;
3450:
3451: if (l_req_phase is null ) THEN
3452: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' not exists' );
3453: return FALSE;
3454: elsif (l_req_phase='COMPLETE' ) THEN
3455: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' is completed!' );
3456: IF (l_status = 'Error' OR l_dev_status = 'ERROR') THEN

Line 3455: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' is completed!' );

3451: if (l_req_phase is null ) THEN
3452: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' not exists' );
3453: return FALSE;
3454: elsif (l_req_phase='COMPLETE' ) THEN
3455: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' is completed!' );
3456: IF (l_status = 'Error' OR l_dev_status = 'ERROR') THEN
3457: RAISE_APPLICATION_ERROR (-20000,'Error happened in request: ' || l_req_id);
3458: ELSIF (l_status = 'Terminated' OR l_dev_status = 'TERMINATED') THEN
3459: l_call_status := fnd_concurrent.set_completion_status('TERMINATED' ,NULL);

Line 3468: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' is running!' );

3464: ELSE
3465: return FALSE;
3466: END IF;
3467: else
3468: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' is running!' );
3469: return TRUE;
3470: end if;
3471: end;
3472:

Line 3488: BIS_COLLECTION_UTILITIES.put_line( pReqCode || ' is flagged to submit alert!');

3484: OPEN C_ALERT_FLAG(pReqCode);
3485: fetch C_ALERT_FLAG into l_flag;
3486: CLOSE C_ALERT_FLAG;
3487: IF( NVL(l_flag, 'N') = 'Y' ) THEN
3488: BIS_COLLECTION_UTILITIES.put_line( pReqCode || ' is flagged to submit alert!');
3489: RETURN TRUE;
3490: ELSE
3491: BIS_COLLECTION_UTILITIES.put_line( pReqCode || ' is not flagged to submit alert!');
3492: RETURN FALSE;

Line 3491: BIS_COLLECTION_UTILITIES.put_line( pReqCode || ' is not flagged to submit alert!');

3487: IF( NVL(l_flag, 'N') = 'Y' ) THEN
3488: BIS_COLLECTION_UTILITIES.put_line( pReqCode || ' is flagged to submit alert!');
3489: RETURN TRUE;
3490: ELSE
3491: BIS_COLLECTION_UTILITIES.put_line( pReqCode || ' is not flagged to submit alert!');
3492: RETURN FALSE;
3493: END IF;
3494: END;
3495:

Line 3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');

3520: begin
3521: commit;
3522: LOOP
3523: dbms_lock.sleep(10);
3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');
3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);
3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);
3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );
3528: --EXIT WHEN NOT ( is_req_alive(p_request_id) );

Line 3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);

3521: commit;
3522: LOOP
3523: dbms_lock.sleep(10);
3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');
3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);
3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);
3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );
3528: --EXIT WHEN NOT ( is_req_alive(p_request_id) );
3529: END LOOP;

Line 3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);

3522: LOOP
3523: dbms_lock.sleep(10);
3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');
3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);
3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);
3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );
3528: --EXIT WHEN NOT ( is_req_alive(p_request_id) );
3529: END LOOP;
3530:

Line 3570: BIS_COLLECTION_UTILITIES.put_line('The following dashboards/reports in this request set are not implemented.');

3566: l_program_status boolean :=true;
3567:
3568: begin
3569: l_counter:=0;
3570: BIS_COLLECTION_UTILITIES.put_line('The following dashboards/reports in this request set are not implemented.');
3571: BIS_COLLECTION_UTILITIES.put_line('Data can not be loaded properly for unimplemented dashboards/reports.');
3572: BIS_COLLECTION_UTILITIES.put_line('Please go to RSG UI to remove them by updating this request set.');
3573: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the dashboards/reports list------');
3574: for l_obj_rec in c_unimpl_obj_in_set loop

Line 3571: BIS_COLLECTION_UTILITIES.put_line('Data can not be loaded properly for unimplemented dashboards/reports.');

3567:
3568: begin
3569: l_counter:=0;
3570: BIS_COLLECTION_UTILITIES.put_line('The following dashboards/reports in this request set are not implemented.');
3571: BIS_COLLECTION_UTILITIES.put_line('Data can not be loaded properly for unimplemented dashboards/reports.');
3572: BIS_COLLECTION_UTILITIES.put_line('Please go to RSG UI to remove them by updating this request set.');
3573: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the dashboards/reports list------');
3574: for l_obj_rec in c_unimpl_obj_in_set loop
3575: l_counter:=l_counter+1;

Line 3572: BIS_COLLECTION_UTILITIES.put_line('Please go to RSG UI to remove them by updating this request set.');

3568: begin
3569: l_counter:=0;
3570: BIS_COLLECTION_UTILITIES.put_line('The following dashboards/reports in this request set are not implemented.');
3571: BIS_COLLECTION_UTILITIES.put_line('Data can not be loaded properly for unimplemented dashboards/reports.');
3572: BIS_COLLECTION_UTILITIES.put_line('Please go to RSG UI to remove them by updating this request set.');
3573: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the dashboards/reports list------');
3574: for l_obj_rec in c_unimpl_obj_in_set loop
3575: l_counter:=l_counter+1;
3576: BIS_COLLECTION_UTILITIES.put_line(l_obj_rec.object_type||' '||l_obj_rec.user_object_name);

Line 3573: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the dashboards/reports list------');

3569: l_counter:=0;
3570: BIS_COLLECTION_UTILITIES.put_line('The following dashboards/reports in this request set are not implemented.');
3571: BIS_COLLECTION_UTILITIES.put_line('Data can not be loaded properly for unimplemented dashboards/reports.');
3572: BIS_COLLECTION_UTILITIES.put_line('Please go to RSG UI to remove them by updating this request set.');
3573: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the dashboards/reports list------');
3574: for l_obj_rec in c_unimpl_obj_in_set loop
3575: l_counter:=l_counter+1;
3576: BIS_COLLECTION_UTILITIES.put_line(l_obj_rec.object_type||' '||l_obj_rec.user_object_name);
3577: end loop;

Line 3576: BIS_COLLECTION_UTILITIES.put_line(l_obj_rec.object_type||' '||l_obj_rec.user_object_name);

3572: BIS_COLLECTION_UTILITIES.put_line('Please go to RSG UI to remove them by updating this request set.');
3573: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the dashboards/reports list------');
3574: for l_obj_rec in c_unimpl_obj_in_set loop
3575: l_counter:=l_counter+1;
3576: BIS_COLLECTION_UTILITIES.put_line(l_obj_rec.object_type||' '||l_obj_rec.user_object_name);
3577: end loop;
3578: BIS_COLLECTION_UTILITIES.put_line('-----------End of the dashboards/reoprts list------');
3579:
3580: if l_counter>0 then

Line 3578: BIS_COLLECTION_UTILITIES.put_line('-----------End of the dashboards/reoprts list------');

3574: for l_obj_rec in c_unimpl_obj_in_set loop
3575: l_counter:=l_counter+1;
3576: BIS_COLLECTION_UTILITIES.put_line(l_obj_rec.object_type||' '||l_obj_rec.user_object_name);
3577: end loop;
3578: BIS_COLLECTION_UTILITIES.put_line('-----------End of the dashboards/reoprts list------');
3579:
3580: if l_counter>0 then
3581: BIS_COLLECTION_UTILITIES.put_line('For your information only. Following is a list of request sets that contain unimplemented dashboards/reports. ');
3582: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the request set list------');

Line 3581: BIS_COLLECTION_UTILITIES.put_line('For your information only. Following is a list of request sets that contain unimplemented dashboards/reports. ');

3577: end loop;
3578: BIS_COLLECTION_UTILITIES.put_line('-----------End of the dashboards/reoprts list------');
3579:
3580: if l_counter>0 then
3581: BIS_COLLECTION_UTILITIES.put_line('For your information only. Following is a list of request sets that contain unimplemented dashboards/reports. ');
3582: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the request set list------');
3583: for l_set_rec in c_set_with_unimpl_obj loop
3584: BIS_COLLECTION_UTILITIES.put_line(l_set_rec.user_request_set_name);
3585: end loop;

Line 3582: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the request set list------');

3578: BIS_COLLECTION_UTILITIES.put_line('-----------End of the dashboards/reoprts list------');
3579:
3580: if l_counter>0 then
3581: BIS_COLLECTION_UTILITIES.put_line('For your information only. Following is a list of request sets that contain unimplemented dashboards/reports. ');
3582: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the request set list------');
3583: for l_set_rec in c_set_with_unimpl_obj loop
3584: BIS_COLLECTION_UTILITIES.put_line(l_set_rec.user_request_set_name);
3585: end loop;
3586: BIS_COLLECTION_UTILITIES.put_line('-----------End of the request set list------');

Line 3584: BIS_COLLECTION_UTILITIES.put_line(l_set_rec.user_request_set_name);

3580: if l_counter>0 then
3581: BIS_COLLECTION_UTILITIES.put_line('For your information only. Following is a list of request sets that contain unimplemented dashboards/reports. ');
3582: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the request set list------');
3583: for l_set_rec in c_set_with_unimpl_obj loop
3584: BIS_COLLECTION_UTILITIES.put_line(l_set_rec.user_request_set_name);
3585: end loop;
3586: BIS_COLLECTION_UTILITIES.put_line('-----------End of the request set list------');
3587: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3588: end if;

Line 3586: BIS_COLLECTION_UTILITIES.put_line('-----------End of the request set list------');

3582: BIS_COLLECTION_UTILITIES.put_line('-----------Start of the request set list------');
3583: for l_set_rec in c_set_with_unimpl_obj loop
3584: BIS_COLLECTION_UTILITIES.put_line(l_set_rec.user_request_set_name);
3585: end loop;
3586: BIS_COLLECTION_UTILITIES.put_line('-----------End of the request set list------');
3587: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3588: end if;
3589: end;
3590:

Line 3648: BIS_COLLECTION_UTILITIES.put_line('Checking if Empty MV Log Truncation is running ...');

3644: l_req_set_appl_id number;
3645: l_req_set_id number;
3646:
3647: begin
3648: BIS_COLLECTION_UTILITIES.put_line('Checking if Empty MV Log Truncation is running ...');
3649: FOR mv_log_truncate_running_rec IN mv_log_truncate_running LOOP
3650: EXIT WHEN mv_log_truncate_running%NOTFOUND;
3651: BIS_COLLECTION_UTILITIES.put_line(' - Req. Id:'||mv_log_truncate_running_rec.REQUEST||' Phase:'|| mv_log_truncate_running_rec.Phase || ' Started:' ||mv_log_truncate_running_rec.s_Date);
3652: RAISE_APPLICATION_ERROR (-20000,'Empty MV Log Truncation Program Running');

Line 3651: BIS_COLLECTION_UTILITIES.put_line(' - Req. Id:'||mv_log_truncate_running_rec.REQUEST||' Phase:'|| mv_log_truncate_running_rec.Phase || ' Started:' ||mv_log_truncate_running_rec.s_Date);

3647: begin
3648: BIS_COLLECTION_UTILITIES.put_line('Checking if Empty MV Log Truncation is running ...');
3649: FOR mv_log_truncate_running_rec IN mv_log_truncate_running LOOP
3650: EXIT WHEN mv_log_truncate_running%NOTFOUND;
3651: BIS_COLLECTION_UTILITIES.put_line(' - Req. Id:'||mv_log_truncate_running_rec.REQUEST||' Phase:'|| mv_log_truncate_running_rec.Phase || ' Started:' ||mv_log_truncate_running_rec.s_Date);
3652: RAISE_APPLICATION_ERROR (-20000,'Empty MV Log Truncation Program Running');
3653: RETURN;
3654: END LOOP;
3655: IF (Not BIS_COLLECTION_UTILITIES.setup('preparation_conc')) THEN

Line 3655: IF (Not BIS_COLLECTION_UTILITIES.setup('preparation_conc')) THEN

3651: BIS_COLLECTION_UTILITIES.put_line(' - Req. Id:'||mv_log_truncate_running_rec.REQUEST||' Phase:'|| mv_log_truncate_running_rec.Phase || ' Started:' ||mv_log_truncate_running_rec.s_Date);
3652: RAISE_APPLICATION_ERROR (-20000,'Empty MV Log Truncation Program Running');
3653: RETURN;
3654: END LOOP;
3655: IF (Not BIS_COLLECTION_UTILITIES.setup('preparation_conc')) THEN
3656: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
3657: return;
3658: END IF;
3659: fnd_profile.put ('CONC_SINGLE_THREAD','N');

Line 3676: BIS_COLLECTION_UTILITIES.put_line('Exception while adding record for RS Run in BIS_RS_RUN_HISTORY_TABLE or updating terminated request set. ignorable exception ' || sqlerrm);

3672: p_request_set_appl_id => l_req_set_appl_id,
3673: p_request_name => p_request_set_code,
3674: p_root_req_id =>FND_GLOBAL.CONC_PRIORITY_REQUEST);
3675: EXCEPTION WHEN OTHERS THEN
3676: BIS_COLLECTION_UTILITIES.put_line('Exception while adding record for RS Run in BIS_RS_RUN_HISTORY_TABLE or updating terminated request set. ignorable exception ' || sqlerrm);
3677: errbuf := sqlerrm;
3678: retcode := sqlcode;
3679: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3680: END;

Line 3682: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

3678: retcode := sqlcode;
3679: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3680: END;
3681: ELSE
3682: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3683: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
3684: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
3685: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3686: END IF;

Line 3683: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');

3679: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3680: END;
3681: ELSE
3682: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3683: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
3684: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
3685: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3686: END IF;
3687:

Line 3684: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');

3680: END;
3681: ELSE
3682: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3683: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
3684: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
3685: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3686: END IF;
3687:
3688: BEGIN

Line 3685: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

3681: ELSE
3682: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3683: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
3684: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
3685: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3686: END IF;
3687:
3688: BEGIN
3689: BIS_COLLECTION_UTILITIES.put_line('********************************************************');

Line 3689: BIS_COLLECTION_UTILITIES.put_line('********************************************************');

3685: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3686: END IF;
3687:
3688: BEGIN
3689: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3690: BIS_COLLECTION_UTILITIES.put_line('kicking off RSG seed data validation program');
3691: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3692: APPLICATION=> 'BIS',
3693: PROGRAM=>'BIS_BIA_RSG_VALIDATION',

Line 3690: BIS_COLLECTION_UTILITIES.put_line('kicking off RSG seed data validation program');

3686: END IF;
3687:
3688: BEGIN
3689: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3690: BIS_COLLECTION_UTILITIES.put_line('kicking off RSG seed data validation program');
3691: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3692: APPLICATION=> 'BIS',
3693: PROGRAM=>'BIS_BIA_RSG_VALIDATION',
3694: DESCRIPTION=>NULL,

Line 3700: BIS_COLLECTION_UTILITIES.put_line('request id for RSG seed data validation program: '||l_request_id);

3696: SUB_REQUEST=>FALSE,
3697: ARGUMENT1=>p_request_set_code,
3698: ARGUMENT2=>'BIS');
3699:
3700: BIS_COLLECTION_UTILITIES.put_line('request id for RSG seed data validation program: '||l_request_id);
3701: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3702:
3703: /**
3704: ------added for enhancement 3999465. But commented for 4422645

Line 3701: BIS_COLLECTION_UTILITIES.put_line('********************************************************');

3697: ARGUMENT1=>p_request_set_code,
3698: ARGUMENT2=>'BIS');
3699:
3700: BIS_COLLECTION_UTILITIES.put_line('request id for RSG seed data validation program: '||l_request_id);
3701: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3702:
3703: /**
3704: ------added for enhancement 3999465. But commented for 4422645
3705: ------ THis call can be removed if in the future we have UI

Line 3707: BIS_COLLECTION_UTILITIES.put_line('Set implementation flag for reports directly included in this request set');

3703: /**
3704: ------added for enhancement 3999465. But commented for 4422645
3705: ------ THis call can be removed if in the future we have UI
3706: ------for the user to set impl flag for reports
3707: BIS_COLLECTION_UTILITIES.put_line('Set implementation flag for reports directly included in this request set');
3708: BIS_IMPL_OPT_PKG.set_implflag_reports_in_set(p_request_set_code,l_req_set_appl_id);
3709: **/
3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');

Line 3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');

3707: BIS_COLLECTION_UTILITIES.put_line('Set implementation flag for reports directly included in this request set');
3708: BIS_IMPL_OPT_PKG.set_implflag_reports_in_set(p_request_set_code,l_req_set_appl_id);
3709: **/
3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);

Line 3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');

3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:
3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3721: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3722:
3723: ---Added for bug 4532066
3724: check_unimpl_objects_is_sets(p_request_set_code);

Line 3721: BIS_COLLECTION_UTILITIES.put_line('********************************************************');

3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:
3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3721: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3722:
3723: ---Added for bug 4532066
3724: check_unimpl_objects_is_sets(p_request_set_code);
3725:

Line 3749: BIS_COLLECTION_UTILITIES.put_line('Submitted request for MV log management program' || l_request_id);

3745: DESCRIPTION=>NULL,
3746: START_TIME=>NULL ,
3747: SUB_REQUEST=>FALSE,
3748: ARGUMENT1=>p_request_set_code);
3749: BIS_COLLECTION_UTILITIES.put_line('Submitted request for MV log management program' || l_request_id);
3750: waitForRequest(l_request_id);
3751: end if;
3752: end if;
3753:

Line 3755: BIS_COLLECTION_UTILITIES.put_line('Exception happens in preparation program, ' || sqlerrm);

3751: end if;
3752: end if;
3753:
3754: EXCEPTION WHEN OTHERS THEN
3755: BIS_COLLECTION_UTILITIES.put_line('Exception happens in preparation program, ' || sqlerrm);
3756: errbuf := sqlerrm;
3757: retcode := sqlcode;
3758: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3759: END;

Line 3777: IF (Not BIS_COLLECTION_UTILITIES.setup('finalization_conc')) THEN

3773: l_rows integer:=0;
3774: l_program_status boolean :=true;
3775: l_program_message varchar2(200);
3776: begin
3777: IF (Not BIS_COLLECTION_UTILITIES.setup('finalization_conc')) THEN
3778: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
3779: return;
3780: END IF;
3781:

Line 3783: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);

3779: return;
3780: END IF;
3781:
3782: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
3783: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
3784: fnd_profile.put ('CONC_SINGLE_THREAD','N');
3785:
3786: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3787: 'BIS',

Line 3792: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BIS_MV_DUMMY_REFRESH ' || l_request_id);

3788: 'BIS_MV_DUMMY_REFRESH',
3789: NULL,
3790: NULL,
3791: FALSE);
3792: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BIS_MV_DUMMY_REFRESH ' || l_request_id);
3793:
3794: --changed for enh 3473874
3795: BIS_COLLECTION_UTILITIES.put_line('Wait for MV consider refresh program to complete ');
3796: waitForRequest(l_request_id);

Line 3795: BIS_COLLECTION_UTILITIES.put_line('Wait for MV consider refresh program to complete ');

3791: FALSE);
3792: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BIS_MV_DUMMY_REFRESH ' || l_request_id);
3793:
3794: --changed for enh 3473874
3795: BIS_COLLECTION_UTILITIES.put_line('Wait for MV consider refresh program to complete ');
3796: waitForRequest(l_request_id);
3797:
3798: ---Add the following API call for refreshing data for custom KPIs
3799: bsc_loader_wrapper(p_request_set_code);

Line 3811: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BIS_LAST_REFRESH_DATE_CONC ' || l_request_id);

3807: NULL,
3808: NULL,
3809: FALSE,
3810: l_root_request_id);
3811: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BIS_LAST_REFRESH_DATE_CONC ' || l_request_id);
3812: waitForRequest(l_request_id);
3813:
3814: EXCEPTION WHEN OTHERS THEN
3815: BIS_COLLECTION_UTILITIES.put_line('Exception happens in finalization program, ' || sqlerrm);

Line 3815: BIS_COLLECTION_UTILITIES.put_line('Exception happens in finalization program, ' || sqlerrm);

3811: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BIS_LAST_REFRESH_DATE_CONC ' || l_request_id);
3812: waitForRequest(l_request_id);
3813:
3814: EXCEPTION WHEN OTHERS THEN
3815: BIS_COLLECTION_UTILITIES.put_line('Exception happens in finalization program, ' || sqlerrm);
3816: errbuf := sqlerrm;
3817: retcode := sqlcode;
3818:
3819: end finalization_conc;

Line 3991: BIS_COLLECTION_UTILITIES.put_line('***********************************');

3987: l_hist_coll_on := is_history_collect_on(p_request_set_code, 191);
3988:
3989: l_kpi_list:=null;
3990: l_kpi_name_list :=null;
3991: BIS_COLLECTION_UTILITIES.put_line('***********************************');
3992: For l_page_object_rec in c_page_objects loop
3993: for l_custom_kpi_rec in c_custom_kpi_in_page(l_page_object_rec.object_name,l_page_object_rec.object_type) loop
3994: if l_custom_kpi_rec.kpi is not null and kpi_in_list(l_kpi_list,l_custom_kpi_rec.kpi)='N' then
3995: l_kpi_list:=l_kpi_list||l_custom_kpi_rec.kpi||',';

Line 4008: BIS_COLLECTION_UTILITIES.put_line('l_kpi_list:'||l_kpi_list);

4004: /* if l_kpi_name_list is not null then
4005: l_kpi_name_list:=rtrim(l_kpi_name_list,',');
4006: end if;*/
4007:
4008: BIS_COLLECTION_UTILITIES.put_line('l_kpi_list:'||l_kpi_list);
4009: BIS_COLLECTION_UTILITIES.put_line('loader_exist:'||loader_exist);
4010:
4011: -----turning off sequential execution before spawning sub-program
4012: -- fnd_profile.put ('CONC_SINGLE_THREAD','N');

Line 4009: BIS_COLLECTION_UTILITIES.put_line('loader_exist:'||loader_exist);

4005: l_kpi_name_list:=rtrim(l_kpi_name_list,',');
4006: end if;*/
4007:
4008: BIS_COLLECTION_UTILITIES.put_line('l_kpi_list:'||l_kpi_list);
4009: BIS_COLLECTION_UTILITIES.put_line('loader_exist:'||loader_exist);
4010:
4011: -----turning off sequential execution before spawning sub-program
4012: -- fnd_profile.put ('CONC_SINGLE_THREAD','N');
4013:

Line 4016: BIS_COLLECTION_UTILITIES.put_line('Initial loading mode. calling loader program to delete data from indicators');

4012: -- fnd_profile.put ('CONC_SINGLE_THREAD','N');
4013:
4014: if l_kpi_list is not null and loader_exist='Y' then
4015: if loading_mode(p_request_set_code)='INIT' and force_full_refresh(p_request_set_code)='Y' then
4016: BIS_COLLECTION_UTILITIES.put_line('Initial loading mode. calling loader program to delete data from indicators');
4017:
4018: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4019: 'BSC',
4020: 'BSC_DELETE_DATA_IND',

Line 4027: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BSC_DELETE_INDICATORS_DATA ' || l_request_id);

4023: FALSE,
4024: l_kpi_list,
4025: 'Y');---'Y' means keep input tables data
4026:
4027: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BSC_DELETE_INDICATORS_DATA ' || l_request_id);
4028: waitForRequest(l_request_id);
4029: -- Enh#4418520-aguwalan
4030: IF (l_hist_coll_on) THEN
4031: BIS_COLL_RS_HISTORY.insert_program_object_data(x_request_id => l_request_id,

Line 4039: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load custom dimensions');

4035: x_refresh_type => loading_mode(p_request_set_code),
4036: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4037: END IF;
4038: end if;
4039: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load custom dimensions');
4040: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4041: 'BSC',
4042: 'BSC_REFRESH_DIM_IND',
4043: NULL,

Line 4048: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BSC_LOAD_INDICATORS_DIMS ' || l_request_id);

4044: NULL,
4045: FALSE,
4046: l_kpi_list,
4047: 'N');
4048: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BSC_LOAD_INDICATORS_DIMS ' || l_request_id);
4049: waitForRequest(l_request_id);
4050: -- Enh#4418520-aguwalan
4051: IF (l_hist_coll_on) THEN
4052: BIS_COLL_RS_HISTORY.insert_program_object_data( x_request_id => l_request_id,

Line 4059: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load data for indicators');

4055: x_object_type => 'BSC_CUSTOM_KPI',
4056: x_refresh_type => loading_mode(p_request_set_code),
4057: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4058: END IF;
4059: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load data for indicators');
4060: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4061: 'BSC',
4062: 'BSC_REFRESH_SUMMARY_IND',
4063: NULL,

Line 4069: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BSC_LOAD_INDICATORS_DATA ' || l_request_id);

4065: FALSE,
4066: l_kpi_list,
4067: 'N');
4068:
4069: BIS_COLLECTION_UTILITIES.put_line('Submitted request for BSC_LOAD_INDICATORS_DATA ' || l_request_id);
4070: waitForRequest(l_request_id);
4071: -- Enh#4418520-aguwalan
4072: IF (l_hist_coll_on) THEN
4073: BIS_COLL_RS_HISTORY.insert_program_object_data( x_request_id => l_request_id,

Line 4081: BIS_COLLECTION_UTILITIES.put_line('********************************************');

4077: x_refresh_type => loading_mode(p_request_set_code),
4078: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4079: END IF;
4080: end if;
4081: BIS_COLLECTION_UTILITIES.put_line('********************************************');
4082:
4083: exception
4084: when others then
4085: raise;

Line 4207: IF (Not BIS_COLLECTION_UTILITIES.setup('seed_data_validation')) THEN

4203: l_program_status boolean :=true;
4204:
4205: begin
4206:
4207: IF (Not BIS_COLLECTION_UTILITIES.setup('seed_data_validation')) THEN
4208: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
4209: return;
4210: END IF;
4211:

Line 4251: BIS_COLLECTION_UTILITIES.put_line_out(l_report_comment);

4247: l_sql_stmt:='select distinct object_type,object_owner,object_name from BIS_BIA_RSG_SEED_VALIDATION
4248: order by object_type,object_owner,object_name';
4249: open cv for l_sql_stmt;
4250:
4251: BIS_COLLECTION_UTILITIES.put_line_out(l_report_comment);
4252: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4253: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4254: BIS_COLLECTION_UTILITIES.put_line_out(l_report_title);
4255: BIS_COLLECTION_UTILITIES.put_line_out(l_obj_type_prompt||' '||l_obj_owner_prompt||' '||l_obj_name_prompt);

Line 4252: BIS_COLLECTION_UTILITIES.put_line_out(' ');

4248: order by object_type,object_owner,object_name';
4249: open cv for l_sql_stmt;
4250:
4251: BIS_COLLECTION_UTILITIES.put_line_out(l_report_comment);
4252: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4253: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4254: BIS_COLLECTION_UTILITIES.put_line_out(l_report_title);
4255: BIS_COLLECTION_UTILITIES.put_line_out(l_obj_type_prompt||' '||l_obj_owner_prompt||' '||l_obj_name_prompt);
4256:

Line 4253: BIS_COLLECTION_UTILITIES.put_line_out(' ');

4249: open cv for l_sql_stmt;
4250:
4251: BIS_COLLECTION_UTILITIES.put_line_out(l_report_comment);
4252: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4253: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4254: BIS_COLLECTION_UTILITIES.put_line_out(l_report_title);
4255: BIS_COLLECTION_UTILITIES.put_line_out(l_obj_type_prompt||' '||l_obj_owner_prompt||' '||l_obj_name_prompt);
4256:
4257:

Line 4254: BIS_COLLECTION_UTILITIES.put_line_out(l_report_title);

4250:
4251: BIS_COLLECTION_UTILITIES.put_line_out(l_report_comment);
4252: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4253: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4254: BIS_COLLECTION_UTILITIES.put_line_out(l_report_title);
4255: BIS_COLLECTION_UTILITIES.put_line_out(l_obj_type_prompt||' '||l_obj_owner_prompt||' '||l_obj_name_prompt);
4256:
4257:
4258:

Line 4255: BIS_COLLECTION_UTILITIES.put_line_out(l_obj_type_prompt||' '||l_obj_owner_prompt||' '||l_obj_name_prompt);

4251: BIS_COLLECTION_UTILITIES.put_line_out(l_report_comment);
4252: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4253: BIS_COLLECTION_UTILITIES.put_line_out(' ');
4254: BIS_COLLECTION_UTILITIES.put_line_out(l_report_title);
4255: BIS_COLLECTION_UTILITIES.put_line_out(l_obj_type_prompt||' '||l_obj_owner_prompt||' '||l_obj_name_prompt);
4256:
4257:
4258:
4259: loop

Line 4283: BIS_COLLECTION_UTILITIES.put_line_out(l_invalid_obj_type||' '||l_invalid_obj_owner||' '||l_invalid_obj_name);

4279: end if;
4280:
4281:
4282:
4283: BIS_COLLECTION_UTILITIES.put_line_out(l_invalid_obj_type||' '||l_invalid_obj_owner||' '||l_invalid_obj_name);
4284: end loop;
4285: close cv;
4286: BIS_COLLECTION_UTILITIES.put_line(l_report_end);
4287:

Line 4286: BIS_COLLECTION_UTILITIES.put_line(l_report_end);

4282:
4283: BIS_COLLECTION_UTILITIES.put_line_out(l_invalid_obj_type||' '||l_invalid_obj_owner||' '||l_invalid_obj_name);
4284: end loop;
4285: close cv;
4286: BIS_COLLECTION_UTILITIES.put_line(l_report_end);
4287:
4288: exception
4289: when others then
4290: BIS_COLLECTION_UTILITIES.put_line('Exception happens in ' || 'bis_create_requestset.seed_data_validation, ' || sqlerrm);

Line 4290: BIS_COLLECTION_UTILITIES.put_line('Exception happens in ' || 'bis_create_requestset.seed_data_validation, ' || sqlerrm);

4286: BIS_COLLECTION_UTILITIES.put_line(l_report_end);
4287:
4288: exception
4289: when others then
4290: BIS_COLLECTION_UTILITIES.put_line('Exception happens in ' || 'bis_create_requestset.seed_data_validation, ' || sqlerrm);
4291: errbuf := sqlerrm;
4292: retcode := '2';
4293: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
4294: end;

Line 4414: BIS_COLLECTION_UTILITIES.put_line('Exception happens in add_link_history_stage ' || sqlerrm);

4410: style=>null,
4411: printer=>null);
4412: commit;
4413: EXCEPTION WHEN OTHERS THEN
4414: BIS_COLLECTION_UTILITIES.put_line('Exception happens in add_link_history_stage ' || sqlerrm);
4415: raise;
4416:
4417: END add_link_history_stage;
4418:

Line 4457: BIS_COLLECTION_UTILITIES.put_line('Checking the status of all the program of the Request Set :: RequestId#'||l_root_request_id);

4453: l_type VARCHAR2(10);
4454: l_program_status BOOLEAN;
4455: BEGIN
4456: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
4457: BIS_COLLECTION_UTILITIES.put_line('Checking the status of all the program of the Request Set :: RequestId#'||l_root_request_id);
4458: OPEN c_get_all_prog_status;
4459: FETCH c_get_all_prog_status INTO l_request_id, l_name, l_type;
4460: CLOSE c_get_all_prog_status;
4461: IF (l_type = 'PROG') THEN

Line 4462: BIS_COLLECTION_UTILITIES.put_line('Program - '||l_name || ', Request Id # '||l_request_id ||' completed with status=Error');

4458: OPEN c_get_all_prog_status;
4459: FETCH c_get_all_prog_status INTO l_request_id, l_name, l_type;
4460: CLOSE c_get_all_prog_status;
4461: IF (l_type = 'PROG') THEN
4462: BIS_COLLECTION_UTILITIES.put_line('Program - '||l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4463: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program (BIS Request Set Status Check Program) to Error.');
4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4465: ELSIF (l_type = 'STAGE') THEN
4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');

Line 4463: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program (BIS Request Set Status Check Program) to Error.');

4459: FETCH c_get_all_prog_status INTO l_request_id, l_name, l_type;
4460: CLOSE c_get_all_prog_status;
4461: IF (l_type = 'PROG') THEN
4462: BIS_COLLECTION_UTILITIES.put_line('Program - '||l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4463: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program (BIS Request Set Status Check Program) to Error.');
4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4465: ELSIF (l_type = 'STAGE') THEN
4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');

Line 4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');

4462: BIS_COLLECTION_UTILITIES.put_line('Program - '||l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4463: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program (BIS Request Set Status Check Program) to Error.');
4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4465: ELSIF (l_type = 'STAGE') THEN
4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');
4468: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4469: ELSE
4470: BIS_COLLECTION_UTILITIES.put_line('All the programs in the request set completed Successfully.');

Line 4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');

4463: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program (BIS Request Set Status Check Program) to Error.');
4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4465: ELSIF (l_type = 'STAGE') THEN
4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');
4468: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4469: ELSE
4470: BIS_COLLECTION_UTILITIES.put_line('All the programs in the request set completed Successfully.');
4471: END IF;

Line 4470: BIS_COLLECTION_UTILITIES.put_line('All the programs in the request set completed Successfully.');

4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');
4468: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4469: ELSE
4470: BIS_COLLECTION_UTILITIES.put_line('All the programs in the request set completed Successfully.');
4471: END IF;
4472: EXCEPTION
4473: WHEN OTHERS THEN
4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);

Line 4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);

4470: BIS_COLLECTION_UTILITIES.put_line('All the programs in the request set completed Successfully.');
4471: END IF;
4472: EXCEPTION
4473: WHEN OTHERS THEN
4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);
4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');
4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');
4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');

Line 4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');

4472: EXCEPTION
4473: WHEN OTHERS THEN
4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);
4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');
4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');
4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');
4479: BIS_COLLECTION_UTILITIES.put_line('program might have completed with error.');
4480: END;

Line 4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');

4473: WHEN OTHERS THEN
4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);
4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');
4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');
4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');
4479: BIS_COLLECTION_UTILITIES.put_line('program might have completed with error.');
4480: END;
4481:

Line 4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');

4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);
4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');
4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');
4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');
4479: BIS_COLLECTION_UTILITIES.put_line('program might have completed with error.');
4480: END;
4481:
4482: /*

Line 4479: BIS_COLLECTION_UTILITIES.put_line('program might have completed with error.');

4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');
4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');
4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');
4479: BIS_COLLECTION_UTILITIES.put_line('program might have completed with error.');
4480: END;
4481:
4482: /*
4483: * API to return the value of the request set option='HISTORY_COLLECT' :: Enh#4418520-aguwalan