DBA Data[Home] [Help]

APPS.PAY_PRG_PROCESS_EVENTS dependencies on FND_API

Line 120: IF NOT FND_API.Compatible_API_Call (

116: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
117: end if;
118:
119: -- Standard call to check for call compatibility
120: IF NOT FND_API.Compatible_API_Call (
121: l_api_version,
122: 1.0,
123: l_api_name,
124: G_PKG_NAME ) THEN

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: l_api_version,
122: 1.0,
123: l_api_name,
124: G_PKG_NAME ) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: x_retcode := FND_API.G_RET_STS_SUCCESS;
129:

Line 128: x_retcode := FND_API.G_RET_STS_SUCCESS;

124: G_PKG_NAME ) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: x_retcode := FND_API.G_RET_STS_SUCCESS;
129:
130: l_product :='PAY';
131:
132: l_stmt_num :=10;

Line 203: x_retcode := FND_API.G_RET_STS_SUCCESS;

199: else
200:
201: l_sub_reqtab := fnd_concurrent.get_sub_requests(fnd_global.conc_request_id);
202:
203: x_retcode := FND_API.G_RET_STS_SUCCESS;
204:
205: for i IN 1..l_sub_reqtab.COUNT()
206: loop
207:

Line 209: X_retcode := FND_API.g_ret_sts_unexp_error;

205: for i IN 1..l_sub_reqtab.COUNT()
206: loop
207:
208: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
209: X_retcode := FND_API.g_ret_sts_unexp_error;
210: end if;
211:
212: end loop;
213:

Line 215: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then

211:
212: end loop;
213:
214: /* Display process completion message */
215: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
216: fnd_file.put_line(FND_FILE.LOG,'***** Process completed successfully *****');
217: end if;
218:
219: end if;

Line 227: X_retcode := FND_API.g_ret_sts_unexp_error;

223: End if;
224:
225: EXCEPTION
226: WHEN submit_conc_failed THEN
227: X_retcode := FND_API.g_ret_sts_unexp_error;
228: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
229: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
230:
231: WHEN fnd_api.g_exc_unexpected_error THEN

Line 231: WHEN fnd_api.g_exc_unexpected_error THEN

227: X_retcode := FND_API.g_ret_sts_unexp_error;
228: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
229: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
230:
231: WHEN fnd_api.g_exc_unexpected_error THEN
232: X_retcode := FND_API.g_ret_sts_unexp_error;
233:
234:
235: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';

Line 232: X_retcode := FND_API.g_ret_sts_unexp_error;

228: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
229: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
230:
231: WHEN fnd_api.g_exc_unexpected_error THEN
232: X_retcode := FND_API.g_ret_sts_unexp_error;
233:
234:
235: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
236: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

Line 238: WHEN fnd_api.g_exc_error THEN

234:
235: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
236: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
237:
238: WHEN fnd_api.g_exc_error THEN
239: X_retcode := FND_API.g_ret_sts_error;
240:
241: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
242: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

Line 239: X_retcode := FND_API.g_ret_sts_error;

235: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
236: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
237:
238: WHEN fnd_api.g_exc_error THEN
239: X_retcode := FND_API.g_ret_sts_error;
240:
241: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
242: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
243:

Line 245: X_retcode := FND_API.g_ret_sts_unexp_error;

241: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
242: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
243:
244: WHEN OTHERS THEN
245: X_retcode := FND_API.g_ret_sts_unexp_error;
246: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
247: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
248:
249: END Purge_process_events_PAY_MGR;

Line 358: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then

354: If lv_debug_enabled then
355: fnd_file.put_line(fnd_file.log,'After calling Purge Process Events' );
356: End if;
357:
358: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
359: raise purge_events_exception;
360: end if;
361:
362: l_rows_processed := X_batch_size;

Line 401: WHEN fnd_api.g_exc_unexpected_error THEN

397: ROLLBACK;
398: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
399: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
400:
401: WHEN fnd_api.g_exc_unexpected_error THEN
402: ROLLBACK;
403: X_retcode := FND_API.g_ret_sts_unexp_error;
404: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
405: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

Line 403: X_retcode := FND_API.g_ret_sts_unexp_error;

399: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
400:
401: WHEN fnd_api.g_exc_unexpected_error THEN
402: ROLLBACK;
403: X_retcode := FND_API.g_ret_sts_unexp_error;
404: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
405: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
406:
407: WHEN fnd_api.g_exc_error THEN

Line 407: WHEN fnd_api.g_exc_error THEN

403: X_retcode := FND_API.g_ret_sts_unexp_error;
404: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
405: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
406:
407: WHEN fnd_api.g_exc_error THEN
408: ROLLBACK;
409: X_retcode := FND_API.g_ret_sts_error;
410: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
411: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

Line 409: X_retcode := FND_API.g_ret_sts_error;

405: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
406:
407: WHEN fnd_api.g_exc_error THEN
408: ROLLBACK;
409: X_retcode := FND_API.g_ret_sts_error;
410: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
411: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
412:
413: WHEN OTHERS THEN

Line 415: X_retcode := FND_API.g_ret_sts_unexp_error;

411: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
412:
413: WHEN OTHERS THEN
414: ROLLBACK;
415: X_retcode := FND_API.g_ret_sts_unexp_error;
416: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
417: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
418:
419: END Purge_process_events_PAY_WKR;