APPS.PA_ALLOC_RUN dependencies on FND_API

Line 10045: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10041: ( p_run_id => l_run_id
10042: ,x_return_status => l_return_status
10043: ,x_msg_data => l_msg_data
10044: ,x_msg_count => l_msg_count);
10045: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10046: IF P_DEBUG_MODE = 'Y' THEN
10047: pa_debug.G_err_stage := 'delte cint sources errored out' ;
10048: pa_debug.write_file('Delete_alloc_run: ' || 'LOG',pa_debug.G_err_stage);
10049: END IF;

Line 10050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10046: IF P_DEBUG_MODE = 'Y' THEN
10047: pa_debug.G_err_stage := 'delte cint sources errored out' ;
10048: pa_debug.write_file('Delete_alloc_run: ' || 'LOG',pa_debug.G_err_stage);
10049: END IF;
10050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10051: END IF;
10052: END IF;
10053: -- lock_rule(p_rule_id, l_run_id) ;
10054: -- Delete Transactions from pa_alloc_txn_details

Line 10355: x_return_status := FND_API.G_RET_STS_SUCCESS;

10351: completion_status BOOLEAN;
10352: l_module_name VARCHAR2(100);
10353: BEGIN
10354: x_msg_count := 0;
10355: x_return_status := FND_API.G_RET_STS_SUCCESS;
10356: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10357: l_module_name := 'release_capint_txns';
10358: pa_debug.set_curr_function( p_function => 'release_capint_txns',
10359: p_debug_mode => l_debug_mode );

Line 10378: x_return_status := FND_API.G_RET_STS_ERROR;

10374: pa_debug.write_file('LOG',pa_debug.g_err_stage);
10375: END IF;
10376: --If failed insert errors into alloc_exceptions table and raise error
10377: IF x_msg_data is NOT NULL then
10378: x_return_status := FND_API.G_RET_STS_ERROR;
10379: alloc_errors( -1, p_run_id, 'R', 'E',x_msg_data, FALSE );
10380: Else
10381: x_return_status := 'S';
10382: End if ;

Line 10409: x_return_status := FND_API.G_RET_STS_SUCCESS;

10405: /* bug fix:3123539 Setting these values as success
10406: the concurrent process should error out only for the unexpected errors
10407: */
10408: x_msg_count := 0;
10409: x_return_status := FND_API.G_RET_STS_SUCCESS;
10410: x_msg_data := Null;
10411: IF l_debug_mode = 'Y' THEN
10412: pa_debug.g_err_stage:= 'Leaving release_capint_txns return status ['||x_return_status||']';
10413: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 10418: x_return_status := FND_API.G_RET_STS_ERROR;

10414: END IF;
10415: pa_debug.reset_curr_function;
10416: EXCEPTION
10417: WHEN OTHERS THEN
10418: x_return_status := FND_API.G_RET_STS_ERROR;
10419: x_msg_count := FND_MSG_PUB.count_msg;
10420: IF l_debug_mode = 'Y' THEN
10421: x_msg_data:=sqlerrm;
10422: pa_debug.write_file('cap_int run: ' || 'LOG', x_msg_data);

Line 10467: x_return_status := FND_API.G_RET_STS_SUCCESS;

10463: FROM pa_alloc_txn_details
10464: WHERE run_id=p_run_id;
10465: BEGIN
10466: x_msg_count := 0;
10467: x_return_status := FND_API.G_RET_STS_SUCCESS;
10468: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10469: l_module_name := 'delete_cint_source_dets';
10470: pa_debug.set_curr_function( p_function => l_module_name,
10471: p_debug_mode => l_debug_mode );

Line 10494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10490: END IF;
10491: pa_debug.reset_curr_function;
10492: EXCEPTION
10493: WHEN others THEN
10494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10495: x_msg_count := 1;
10496: x_msg_data := SQLERRM;
10497: FND_MSG_PUB.add_exc_msg
10498: ( p_pkg_name => 'pa_alloc_run'