APPS.CST_ACCRUAL_LOAD dependencies on FND_CONCURRENT

Line 528: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substrb(l_err_data,1,240));

524: debug(' l_err_status:'||l_err_status);
525: debug(' l_err_count :'||l_err_count);
526: debug(' l_err_data :'||l_err_data);
527:
528: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substrb(l_err_data,1,240));
529:
530: RETURN;
531:
532: WHEN OTHERS THEN

Line 536: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substrb(SQLERRM,1,240));

532: WHEN OTHERS THEN
533: rollback;
534: debug('EXCEPTION OTHERS IN Start_accrual_load: '||substr(SQLERRM,1,180));
535:
536: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substrb(SQLERRM,1,240));
537:
538: RETURN;
539:
540: END Start_accrual_load;

Line 639: FROM FND_CONCURRENT_REQUESTS FCR

635:
636: /* check for incompatibility. If there is another load running for the same OU,error out this one */
637: --{BUG 12625738
638: /*SELECT FCR.argument1 into l_req_arg
639: FROM FND_CONCURRENT_REQUESTS FCR
640: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
641: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
642: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
643:

Line 647: FROM FND_CONCURRENT_REQUESTS FCR

643:
644: debug(' l_req_arg:'||l_req_arg);
645:
646: SELECT count(*) into l_req_running
647: FROM FND_CONCURRENT_REQUESTS FCR
648: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
649: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
650: AND FCR.phase_code = 'R'
651: AND FCR.argument1 = l_req_arg;*/

Line 654: FROM FND_CONCURRENT_REQUESTS FCR

650: AND FCR.phase_code = 'R'
651: AND FCR.argument1 = l_req_arg;*/
652:
653: SELECT count(*) into l_req_running
654: FROM FND_CONCURRENT_REQUESTS FCR
655: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
656: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
657: AND FCR.phase_code = 'R'
658: AND FCR.org_id = p_operating_unit;

Line 940: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||' in accrual_load - statement:'||l_stmt_num);

936: );
937: debug('x_msg_count:'||x_msg_count);
938: debug('x_msg_data :'||SUBSTRB(x_msg_data,1,1000));
939:
940: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||' in accrual_load - statement:'||l_stmt_num);
941:
942:
943: WHEN FND_API.g_exc_unexpected_error THEN
944: ROLLBACK;

Line 956: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||'accrual_load - statement:'||l_stmt_num);

952: );
953: debug('x_msg_count:'||x_msg_count);
954: debug('x_msg_data :'||SUBSTRB(x_msg_data,1,1000));
955:
956: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||'accrual_load - statement:'||l_stmt_num);
957:
958: WHEN stop_here THEN
959:
960: ROLLBACK;

Line 969: l_conc_request := fnd_concurrent.set_completion_status('WARNING','STOP HERE in accrual_load at statement '||l_stmt_num);

965: ( p_count => x_msg_count
966: , p_data => x_msg_data
967: );
968:
969: l_conc_request := fnd_concurrent.set_completion_status('WARNING','STOP HERE in accrual_load at statement '||l_stmt_num);
970:
971:
972: WHEN OTHERS THEN
973:

Line 988: l_conc_request := fnd_concurrent.set_completion_status('ERROR',

984: ( p_count => x_msg_count
985: , p_data => x_msg_data
986: );
987:
988: l_conc_request := fnd_concurrent.set_completion_status('ERROR',
989: 'EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,140)||' at statement '||l_stmt_num);
990:
991: END accrual_load;
992: