APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on FND_CONCURRENT

Line 99: FND_CONCURRENT.get_request_status(

95: FOR l_child_program_id IN l_child_program_id_tbl.FIRST..l_child_program_id_tbl.LAST
96: LOOP
97:
98: call_status :=
99: FND_CONCURRENT.get_request_status(
100: l_child_program_id_tbl(l_child_program_id), '', '',
101: l_phase, l_status, l_dev_phase,
102: l_dev_status, l_message);
103:

Line 111: FND_CONCURRENT.get_request_status(

107: WHILE l_dev_phase <> 'COMPLETE'
108: LOOP
109:
110: call_status :=
111: FND_CONCURRENT.get_request_status(
112: l_child_program_id_tbl(l_child_program_id), '', '',
113: l_phase, l_status, l_dev_phase,
114: l_dev_status, l_message);
115:

Line 299: fnd_concurrent.get_request_status(

295:
296: WHILE l_completed_batch_count <= x_batch_total LOOP
297: IF l_primary_request_stack(primary_ptr) IS NOT NULL THEN
298: l_call_status :=
299: fnd_concurrent.get_request_status(
300: request_id => l_primary_request_stack(primary_ptr)
301: , phase => l_dummy
302: , status => l_dummy
303: , dev_phase => l_dev_phase

Line 362: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

358: WHEN NO_DATA_FOUND THEN
359: debugmsg('SCA : Conc_Dispatch : no rows for process ' || x_transaction_source);
360: WHEN conc_fail THEN
361: debugmsg('SCA : Conc_Dispatch : Exception conc_fail');
362: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
363: RAISE;
364: WHEN OTHERS THEN
365: debugmsg('SCA : Conc_Dispatch : Unexpected Exception');
366: RAISE;

Line 897: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

893: EXCEPTION
894: WHEN no_trx THEN
895: debugmsg('Get Sales Credits : No input transactions found for Rules Engine Processing');
896: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
897: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
898: cn_message_pkg.end_batch(l_process_audit_id);
899: WHEN no_rule_ex THEN
900: debugmsg('Get Sales Credits : No Credit Rules found for Rules Engine Processing');
901: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');

Line 902: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

898: cn_message_pkg.end_batch(l_process_audit_id);
899: WHEN no_rule_ex THEN
900: debugmsg('Get Sales Credits : No Credit Rules found for Rules Engine Processing');
901: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
902: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
903: cn_message_pkg.end_batch(l_process_audit_id);
904: WHEN index_ex THEN
905: debugmsg('Get Sales Credits : Error occured while creating indexes dynamically');
906: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');

Line 907: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

903: cn_message_pkg.end_batch(l_process_audit_id);
904: WHEN index_ex THEN
905: debugmsg('Get Sales Credits : Error occured while creating indexes dynamically');
906: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
907: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
908: cn_message_pkg.end_batch(l_process_audit_id);
909: WHEN OTHERS THEN
910: debugmsg('Get Sales Credits : Unexpected exception');
911: debugmsg('Get Sales Credits : Oracle Error: ' || SQLERRM);

Line 913: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');

909: WHEN OTHERS THEN
910: debugmsg('Get Sales Credits : Unexpected exception');
911: debugmsg('Get Sales Credits : Oracle Error: ' || SQLERRM);
912: debugmsg('Get Sales Credits : Rules Engine Processing ended with errors');
913: conc_status := fnd_concurrent.set_completion_status(status => 'ERROR', MESSAGE => '');
914: cn_message_pkg.end_batch(l_process_audit_id);
915: END get_sales_credits;
916:
917: --