DBA Data[Home] [Help]

APPS.PA_BGT_BASELINE_PKG dependencies on FND_API

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158: --Initialize the error stack
159: PA_DEBUG.set_err_stack('Insert BGT Balances');
160:
161: --Initialize the return status to success
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: IF P_DEBUG_MODE = 'Y' THEN
165: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Entering Insert BGT Balances');
166: END IF;

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

506: IF c_deldraftbal%ISOPEN THEN
507: close c_delbal;
508: END IF;
509:
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: x_error_message_code := (SQLCODE||' '||SQLERRM);
512: PA_DEBUG.Reset_Err_Stack; --Bug 5064900
513: RAISE;
514: END INSERT_BGT_BALANCES;

Line 1115: x_return_status := FND_API.G_RET_STS_SUCCESS;

1111: --Initialize the error stack
1112: PA_DEBUG.set_err_stack('Insert VIERBTC Txns');
1113:
1114: --Initialize the return status to success
1115: x_return_status := FND_API.G_RET_STS_SUCCESS;
1116:
1117: IF P_DEBUG_MODE = 'Y' THEN
1118: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Entering VI ER BTC Project = '|| p_project_id||' SOB = '|| p_sob_id || ' Intg = '||p_bdgt_intg_flag);
1119: END IF;

Line 1318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1314: IF c_VIERBTC_txns%ISOPEN THEN
1315: close c_VIERBTC_txns;
1316: END IF;
1317:
1318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1319: x_error_message_code := (SQLCODE||' '||SQLERRM);
1320: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
1321: RAISE;
1322: END INSERT_VI_ER_BTC_TXNS;

Line 1435: x_return_status := FND_API.G_RET_STS_SUCCESS;

1431: --Initialize the error stack
1432: PA_DEBUG.set_err_stack('Insert Commitment Txns');
1433:
1434: --Initialize the return status to success
1435: x_return_status := FND_API.G_RET_STS_SUCCESS;
1436:
1437: IF P_DEBUG_MODE = 'Y' THEN
1438: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Entering Insert Commitment Txns');
1439: END IF;

Line 2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2059: IF c_bc_comm%ISOPEN THEN
2060: close c_bc_comm;
2061: END IF;
2062:
2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2064: x_error_message_code := (SQLCODE||' '||SQLERRM);
2065: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2066: RAISE;
2067: END INSERT_COMMITMENT_TXNS;

Line 2085: x_return_status := FND_API.G_RET_STS_SUCCESS;

2081:
2082: fnd_msg_pub.initialize;
2083:
2084: --Initialize the return status to success
2085: x_return_status := FND_API.G_RET_STS_SUCCESS;
2086:
2087: IF P_DEBUG_MODE = 'Y' THEN
2088: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Passed parameters = ' || p_project_id || ':' || p_budget_version_id || ':' || p_bdgt_ctrl_type || ':' || p_calling_mode || ':' || p_bdgt_intg_flag);
2089: END IF;

Line 2316: raise FND_API.G_EXC_ERROR;

2312: IF P_DEBUG_MODE = 'Y' THEN
2313: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'FCHK in Reserve Mode returned failure');
2314: END IF;
2315:
2316: raise FND_API.G_EXC_ERROR;
2317:
2318: elsif (l_return_status = 'T') then
2319:
2320: -- PA_DEBUG.set_err_stack('M:Funds Check process in reserve mode returned fatal error');

Line 2325: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2321: IF P_DEBUG_MODE = 'Y' THEN
2322: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'FCHK in Reserve Mode returned fatal error');
2323: END IF;
2324:
2325: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2326:
2327: end if;
2328: IF P_DEBUG_MODE = 'Y' THEN
2329: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'End of FCHK, l_return_status = ' || l_return_status);

Line 2338: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2334: IF P_DEBUG_MODE = 'Y' THEN
2335: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'FCHK in Reserve Mode not called');
2336: END IF;
2337: -- PA_DEBUG.set_err_stack('M:Funds Check process in reserve mode returned failure');
2338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2339:
2340: END IF;
2341:
2342:

Line 2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2378: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2379: ,p_procedure_name => 'MAINTAIN_BAL_FCHK' --Bug 5064900
2380: ,p_error_text => PA_DEBUG.G_Err_Stack );
2381:
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2383: x_error_message_code := 'PA_BC_CANNOT_ACQUIRE_LOCK';
2384:
2385: if c_bal_lock%isopen then
2386: close c_bal_lock;

Line 2392: WHEN FND_API.G_EXC_ERROR THEN

2388: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2389: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2390: raise;
2391:
2392: WHEN FND_API.G_EXC_ERROR THEN
2393: --rollback; this exception raised when FC fails
2394: commit; -- commit required to commit failure status_code
2395:
2396: IF P_DEBUG_MODE = 'Y' THEN

Line 2409: x_return_status := FND_API.G_RET_STS_ERROR;

2405: --we should not add error message to error stack.
2406: /*FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2407: ,p_procedure_name => PA_DEBUG.G_Err_Stack ); */
2408:
2409: x_return_status := FND_API.G_RET_STS_ERROR;
2410:
2411: if (p_bdgt_ctrl_type = 'GL') then
2412: x_error_message_code := 'PA_BC_BASELINE_FCHK_FAILED';
2413: elsif (p_bdgt_ctrl_type = 'CC') then

Line 2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2420:
2421: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2422: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2423:
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2425: If nvl(l_return_status,'P') = 'T' then
2426: commit; -- FC exception
2427: Else
2428: rollback; -- this package exception

Line 2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2439: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2440: ,p_procedure_name => 'MAINTAIN_BAL_FCHK' -- Bug 5064900
2441: ,p_error_text => PA_DEBUG.G_Err_Stack );
2442:
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: x_error_message_code := (SQLCODE||' '||SQLERRM);
2445:
2446: IF P_DEBUG_MODE = 'Y' THEN
2447: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || SQLERRM);

Line 2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2463: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2464: ,p_procedure_name => 'MAINTAIN_BAL_FCHK' -- Bug 5064900
2465: ,p_error_text => PA_DEBUG.G_Err_Stack );
2466:
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2468: x_error_message_code := (SQLCODE||' '||SQLERRM);
2469:
2470: if c_bal_lock%isopen then
2471: close c_bal_lock;