DBA Data[Home] [Help]

APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on FND_API

Line 30: l_return_status := FND_API.G_RET_STS_SUCCESS;

26: --===================================================================================
27:
28: begin
29:
30: l_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32:
33:
34: insert into PA_BUDGETARY_CONTROLS ( BUDGETARY_CONTROLS_ID

Line 79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

75: EXCEPTION
76: WHEN OTHERS THEN
77: x_msg_count := 1;
78: x_msg_data := SUBSTR(SQLERRM, 1, 240);
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80:
81: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
82: , p_procedure_name => 'insert_rows');
83:

Line 306: l_return_status := FND_API.G_RET_STS_SUCCESS;

302:
303:
304: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.CREATE_BC_LEVELS');
305:
306: l_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: --PLSQL Message stack is initialized
309:
310: FND_MSG_PUB.initialize;

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

508: EXCEPTION
509: WHEN OTHERS THEN
510: x_msg_count := 1;
511: x_msg_data := SUBSTR(SQLERRM, 1, 240);
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513:
514: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
515: , p_procedure_name => 'CREATE_BC_LEVELS');
516:

Line 601: l_return_status := FND_API.G_RET_STS_SUCCESS;

597: --====================================================================================
598:
599: begin
600:
601: l_return_status := FND_API.G_RET_STS_SUCCESS;
602: l_calling_mode := x_calling_mode;
603:
604: -- Setting debug variables
605: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE');

Line 695: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

691: PA_FCK_UTIL.debug_msg('PA_BC_Log: Executed BUD_CTRL_CREATE');
692:
693: CLOSE c_bud_ctrl_params;
694:
695: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
696: RAISE CREATE_BC_REC_ERROR;
697: end if;
698:
699: --Output Parameters are set before passing the values back

Line 708: x_return_status := FND_API.G_RET_STS_ERROR;

704:
705: EXCEPTION
706: WHEN CREATE_BC_REC_ERROR then
707: PA_UTILS.add_message('PA', 'PA_BC_REC_FAIL');
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: x_msg_count := 1;
710: x_msg_data := 'PA_BC_REC_FAIL';
711:
712:

Line 716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

712:
713: WHEN OTHERS THEN
714: x_msg_count := 1;
715: x_msg_data := SUBSTR(SQLERRM, 1, 240);
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717:
718: PA_FCK_UTIL.debug_msg('PA_BC_Log:8' || SQLERRM);
719:
720: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

Line 749: l_return_status := FND_API.G_RET_STS_SUCCESS;

745: begin
746:
747: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUDG_CTRL_RESET');
748:
749: l_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: --PLSQL Message stack is initialized
752:
753: FND_MSG_PUB.initialize;

Line 803: if l_return_status = FND_API.G_RET_STS_SUCCESS then

799: ,l_return_status
800: ,l_msg_count
801: ,l_msg_data );
802:
803: if l_return_status = FND_API.G_RET_STS_SUCCESS then
804: PA_FCK_UTIL.debug_msg('PA_BC_Log: BC Levels recreated');
805: -- Budgetary Control levels successfully created. Commit can be issued
806: commit;
807: PA_DEBUG.g_err_stage := 'PA_BC_Log: Budgetary Control levels successfully created';

Line 816: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

812: rollback;
813: end if;
814:
815:
816: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
817: RAISE RESET_BC_ERROR;
818: end if;
819:
820: --Output Parameters are set before passing the values back

Line 829: x_return_status := FND_API.G_RET_STS_ERROR;

825:
826: EXCEPTION
827: WHEN RESET_BC_ERROR then
828: PA_UTILS.add_message('PA', 'PA_BC_RESET_ERROR');
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: x_msg_count := 1;
831: x_msg_data := 'PA_BC_RESET_ERROR';
832:
833:

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: WHEN OTHERS THEN
835: rollback;
836: x_msg_count := 1;
837: x_msg_data := SUBSTR(SQLERRM, 1, 240);
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839:
840: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
841: , p_procedure_name => 'BUD_CTRL_CREATE');
842:

Line 957: RAISE FND_API.G_EXC_ERROR;

953:
954: FND_MESSAGE.SET_NAME('PA','PA_BC_NULL_ARGS_PASSED');
955: APP_EXCEPTION.RAISE_EXCEPTION;
956: fnd_msg_pub.add;
957: RAISE FND_API.G_EXC_ERROR;
958:
959: /*
960: PA_UTILS.add_message ( p_app_short_name => 'PA'
961: ,p_msg_name => 'PA_BC_NULL_ARGS_PASSED');

Line 1053: RAISE FND_API.G_EXC_ERROR;

1049: */
1050: FND_MESSAGE.SET_NAME('PA','PA_BC_NULL_ARGS_PASSED');
1051: APP_EXCEPTION.RAISE_EXCEPTION;
1052: fnd_msg_pub.add;
1053: RAISE FND_API.G_EXC_ERROR;
1054:
1055: -- APP_EXCEPTION.RAISE_EXCEPTION;
1056:
1057: WHEN OTHERS THEN