DBA Data[Home] [Help]

APPS.PA_AP_XFER_PKG dependencies on FND_API

Line 18: l_error_code VARCHAR2(30):= FND_API.G_RET_STS_ERROR;

14: l_line_num_tab PA_PLSQL_DATATYPES.NumTabTyp;
15: l_line_num_reversed_tab PA_PLSQL_DATATYPES.NumTabTyp;
16: l_dr_code_combination_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
17: l_return_status NUMBER := -1;
18: l_error_code VARCHAR2(30):= FND_API.G_RET_STS_ERROR;
19: l_error_stage VARCHAR2(30);
20: l_debug_mode VARCHAR2(1);
21: l_stage NUMBER ;
22: l_this_fetch PLS_INTEGER := 0;

Line 151: x_error_code := FND_API.G_RET_STS_SUCCESS;

147: PA_DEBUG.g_err_stage := TO_CHAR(l_stage) || ':No more Reversal CDLs to process. Exiting';
148: PA_DEBUG.write_file(PA_DEBUG.g_err_stage);
149:
150: x_return_status := 0;
151: x_error_code := FND_API.G_RET_STS_SUCCESS;
152: x_error_stage := l_stage;
153: EXIT;
154: END IF;
155:

Line 176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

172: PA_DEBUG.write_file(PA_DEBUG.g_err_stage);
173: pa_debug.reset_err_stack; --Added for Bug#3094341
174: CLOSE rev_cdl_cur;
175: EXCEPTION
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
177: THEN
178: l_stage := 120 ;
179: pa_debug.write_file(pa_debug.g_err_stage);
180: PA_DEBUG.g_err_stage := TO_CHAR(l_stage) ||'In UnExpected Exception';

Line 184: x_error_code := FND_API.G_RET_STS_ERROR;

180: PA_DEBUG.g_err_stage := TO_CHAR(l_stage) ||'In UnExpected Exception';
181: pa_debug.write_file(pa_debug.g_err_stage);
182:
183: x_return_status := -1;
184: x_error_code := FND_API.G_RET_STS_ERROR;
185: x_error_stage := l_stage ;
186: pa_debug.reset_err_stack;
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: WHEN OTHERS

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: x_return_status := -1;
184: x_error_code := FND_API.G_RET_STS_ERROR;
185: x_error_stage := l_stage ;
186: pa_debug.reset_err_stack;
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: WHEN OTHERS
189: THEN
190: l_stage := 130 ;
191: pa_debug.write_file(pa_debug.g_err_stage);

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: x_return_status := -1;
198: x_error_code := TO_CHAR(SQLCODE) || SQLERRM ;
199: x_error_stage := l_stage ;
200: pa_debug.reset_err_stack;
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END upd_cdl_xfer_status;
203: END pa_ap_xfer_pkg;