DBA Data[Home] [Help]

APPS.PAY_FLOW_REQUESTS_PKG dependencies on FND_FILE

Line 346: then fnd_file.put_line(FND_FILE.LOG,'Requested Id does not exist');

342: CLOSE get_flow_req_details;
343: --
344: exception
345: when no_data_found
346: then fnd_file.put_line(FND_FILE.LOG,'Requested Id does not exist');
347: raise;
348: END;
349:
350: hr_utility.set_location(l_proc, 10);

Line 361: fnd_file.put_line(FND_FILE.LOG,'Specified process flow not defined');

357: where process_req_seq_id = p_request_id;
358: --
359: exception
360: when no_data_found then
361: fnd_file.put_line(FND_FILE.LOG,'Specified process flow not defined');
362: raise;
363: END;
364:
365: hr_utility.set_location(l_proc, 20);

Line 379: fnd_file.put_line(FND_FILE.LOG,'No wrapper package found');

375: where set_id = l_set_id.set_id;
376: --
377: exception
378: when no_data_found then
379: fnd_file.put_line(FND_FILE.LOG,'No wrapper package found');
380: raise;
381: END;
382:
383: hr_utility.set_location(l_proc, 30);

Line 394: fnd_file.put_line(FND_FILE.LOG,'No group id specified');

390: where set_id = l_set_id.set_id;
391: --
392: exception
393: when no_data_found then
394: fnd_file.put_line(FND_FILE.LOG,'No group id specified');
395: raise;
396: END;
397:
398: hr_utility.set_location(l_proc, 40);

Line 424: fnd_file.put_line(FND_FILE.LOG,'Invalid data submitted for processing');

420: BEGIN
421: --
422: execute immediate l_sql_stmt using OUT l_request_id;
423: if l_request_id = -1 then
424: fnd_file.put_line(FND_FILE.LOG,'Invalid data submitted for processing');
425: raise no_data_found;
426: end if;
427: exception
428: when others

Line 429: then fnd_file.put_line(FND_FILE.LOG,'Couldnt invoke the wrapper package succesfully');

425: raise no_data_found;
426: end if;
427: exception
428: when others
429: then fnd_file.put_line(FND_FILE.LOG,'Couldnt invoke the wrapper package succesfully');
430: raise;
431: END;
432:
433: fnd_file.put_line(FND_FILE.LOG, l_request_id||' => ' ||l_sql_stmt);

Line 433: fnd_file.put_line(FND_FILE.LOG, l_request_id||' => ' ||l_sql_stmt);

429: then fnd_file.put_line(FND_FILE.LOG,'Couldnt invoke the wrapper package succesfully');
430: raise;
431: END;
432:
433: fnd_file.put_line(FND_FILE.LOG, l_request_id||' => ' ||l_sql_stmt);
434:
435: hr_utility.set_location(l_proc, 60);
436:
437: -- Get the assignment action id to be passed to insert_child_request

Line 498: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||

494: end if;
495: exception
496: when no_data_found
497: then
498: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||
499: l_request_id ||' has errored out');
500: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');
501: raise ;
502: when value_error

Line 500: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');

496: when no_data_found
497: then
498: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||
499: l_request_id ||' has errored out');
500: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');
501: raise ;
502: when value_error
503: then
504: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||

Line 504: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||

500: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');
501: raise ;
502: when value_error
503: then
504: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||
505: l_request_id ||' has been cancelled');
506: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');
507: raise;
508: END;

Line 506: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');

502: when value_error
503: then
504: fnd_file.put_line(FND_FILE.LOG,'One of the child process with id'||
505: l_request_id ||' has been cancelled');
506: fnd_file.put_line(FND_FILE.LOG,'Aborting the flow !!');
507: raise;
508: END;
509:
510: END LOOP;

Line 517: then fnd_file.put_line(FND_FILE.LOG,'Process could not complete due to above reason. Aborting.....');

513: hr_utility.set_location('Leaving: '||l_proc, 90);
514: --
515: exception
516: when others
517: then fnd_file.put_line(FND_FILE.LOG,'Process could not complete due to above reason. Aborting.....');
518: raise PROGRAM_ERROR;
519: --
520: END invoke_request;
521:

Line 942: then fnd_file.put_line(FND_FILE.LOG,'Request creation for the child process failed');

938: hr_utility.set_location('Leaving: '||l_proc, 30);
939:
940: exception
941: when others
942: then fnd_file.put_line(FND_FILE.LOG,'Request creation for the child process failed');
943: raise;
944: --
945: END INSERT_CHILD_REQUEST;
946: