DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on FND_CONCURRENT

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

513: debug(' l_err_status:'||l_err_status);
514: debug(' l_err_count :'||l_err_count);
515: debug(' l_err_data :'||l_err_data);
516:
517: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substrb(l_err_data,1,240));
518:
519: RETURN;
520:
521: WHEN OTHERS THEN

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

521: WHEN OTHERS THEN
522: rollback;
523: debug('EXCEPTION OTHERS IN Start_accrual_load: '||substr(SQLERRM,1,180));
524:
525: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substrb(SQLERRM,1,240));
526:
527: RETURN;
528:
529: END Start_accrual_load;

Line 655: FROM FND_CONCURRENT_REQUESTS FCR

651:
652: /* check for incompatibility. If there is another load running for the same OU,error out this one */
653:
654: SELECT FCR.argument1 into l_req_arg
655: FROM FND_CONCURRENT_REQUESTS FCR
656: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
657: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
658: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
659:

Line 663: FROM FND_CONCURRENT_REQUESTS FCR

659:
660: debug(' l_req_arg:'||l_req_arg);
661:
662: SELECT count(*) into l_req_running
663: FROM FND_CONCURRENT_REQUESTS FCR
664: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
665: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
666: AND FCR.phase_code = 'R'
667: AND FCR.argument1 = l_req_arg;

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

960: );
961: debug('x_msg_count:'||x_msg_count);
962: debug('x_msg_data :'||SUBSTRB(x_msg_data,1,1000));
963:
964: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||' in accrual_load - statement:'||l_stmt_num);
965:
966:
967: WHEN FND_API.g_exc_unexpected_error THEN
968: ROLLBACK;

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

976: );
977: debug('x_msg_count:'||x_msg_count);
978: debug('x_msg_data :'||SUBSTRB(x_msg_data,1,1000));
979:
980: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||'accrual_load - statement:'||l_stmt_num);
981:
982: WHEN stop_here THEN
983:
984: ROLLBACK;

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

989: ( p_count => x_msg_count
990: , p_data => x_msg_data
991: );
992:
993: l_conc_request := fnd_concurrent.set_completion_status('WARNING','STOP HERE in accrual_load at statement '||l_stmt_num);
994:
995:
996: WHEN OTHERS THEN
997:

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

1008: ( p_count => x_msg_count
1009: , p_data => x_msg_data
1010: );
1011:
1012: l_conc_request := fnd_concurrent.set_completion_status('ERROR',
1013: 'EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,140)||' at statement '||l_stmt_num);
1014:
1015: END accrual_load;
1016: