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 949: x_return_status := FND_API.G_RET_STS_SUCCESS;

945: --Initialize the error stack
946: PA_DEBUG.set_err_stack('Insert VIERBTC Txns');
947:
948: --Initialize the return status to success
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951: IF P_DEBUG_MODE = 'Y' THEN
952: 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);
953: END IF;

Line 1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1148: IF c_VIERBTC_txns%ISOPEN THEN
1149: close c_VIERBTC_txns;
1150: END IF;
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1153: x_error_message_code := (SQLCODE||' '||SQLERRM);
1154: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
1155: RAISE;
1156: END INSERT_VI_ER_BTC_TXNS;

Line 1269: x_return_status := FND_API.G_RET_STS_SUCCESS;

1265: --Initialize the error stack
1266: PA_DEBUG.set_err_stack('Insert Commitment Txns');
1267:
1268: --Initialize the return status to success
1269: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270:
1271: IF P_DEBUG_MODE = 'Y' THEN
1272: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Entering Insert Commitment Txns');
1273: END IF;

Line 1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1893: IF c_bc_comm%ISOPEN THEN
1894: close c_bc_comm;
1895: END IF;
1896:
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1898: x_error_message_code := (SQLCODE||' '||SQLERRM);
1899: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
1900: RAISE;
1901: END INSERT_COMMITMENT_TXNS;

Line 1919: x_return_status := FND_API.G_RET_STS_SUCCESS;

1915:
1916: fnd_msg_pub.initialize;
1917:
1918: --Initialize the return status to success
1919: x_return_status := FND_API.G_RET_STS_SUCCESS;
1920:
1921: IF P_DEBUG_MODE = 'Y' THEN
1922: 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);
1923: END IF;

Line 2150: raise FND_API.G_EXC_ERROR;

2146: IF P_DEBUG_MODE = 'Y' THEN
2147: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'FCHK in Reserve Mode returned failure');
2148: END IF;
2149:
2150: raise FND_API.G_EXC_ERROR;
2151:
2152: elsif (l_return_status = 'T') then
2153:
2154: -- PA_DEBUG.set_err_stack('M:Funds Check process in reserve mode returned fatal error');

Line 2159: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2155: IF P_DEBUG_MODE = 'Y' THEN
2156: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'FCHK in Reserve Mode returned fatal error');
2157: END IF;
2158:
2159: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2160:
2161: end if;
2162: IF P_DEBUG_MODE = 'Y' THEN
2163: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'End of FCHK, l_return_status = ' || l_return_status);

Line 2172: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2168: IF P_DEBUG_MODE = 'Y' THEN
2169: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'FCHK in Reserve Mode not called');
2170: END IF;
2171: -- PA_DEBUG.set_err_stack('M:Funds Check process in reserve mode returned failure');
2172: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2173:
2174: END IF;
2175:
2176:

Line 2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2212: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2213: ,p_procedure_name => 'MAINTAIN_BAL_FCHK' --Bug 5064900
2214: ,p_error_text => PA_DEBUG.G_Err_Stack );
2215:
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217: x_error_message_code := 'PA_BC_CANNOT_ACQUIRE_LOCK';
2218:
2219: if c_bal_lock%isopen then
2220: close c_bal_lock;

Line 2226: WHEN FND_API.G_EXC_ERROR THEN

2222: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2223: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2224: raise;
2225:
2226: WHEN FND_API.G_EXC_ERROR THEN
2227: --rollback; this exception raised when FC fails
2228: commit; -- commit required to commit failure status_code
2229:
2230: IF P_DEBUG_MODE = 'Y' THEN

Line 2243: x_return_status := FND_API.G_RET_STS_ERROR;

2239: --we should not add error message to error stack.
2240: /*FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2241: ,p_procedure_name => PA_DEBUG.G_Err_Stack ); */
2242:
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244:
2245: if (p_bdgt_ctrl_type = 'GL') then
2246: x_error_message_code := 'PA_BC_BASELINE_FCHK_FAILED';
2247: elsif (p_bdgt_ctrl_type = 'CC') then

Line 2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2254:
2255: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2256: PA_DEBUG.Reset_Err_Stack; -- Bug 5064900
2257:
2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2259: If nvl(l_return_status,'P') = 'T' then
2260: commit; -- FC exception
2261: Else
2262: rollback; -- this package exception

Line 2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2273: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2274: ,p_procedure_name => 'MAINTAIN_BAL_FCHK' -- Bug 5064900
2275: ,p_error_text => PA_DEBUG.G_Err_Stack );
2276:
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278: x_error_message_code := (SQLCODE||' '||SQLERRM);
2279:
2280: IF P_DEBUG_MODE = 'Y' THEN
2281: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || SQLERRM);

Line 2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2297: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BGT_BASELINE_PKG'
2298: ,p_procedure_name => 'MAINTAIN_BAL_FCHK' -- Bug 5064900
2299: ,p_error_text => PA_DEBUG.G_Err_Stack );
2300:
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2302: x_error_message_code := (SQLCODE||' '||SQLERRM);
2303:
2304: if c_bal_lock%isopen then
2305: close c_bal_lock;