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);
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);
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);
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);
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
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);
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
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
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'||
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;
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;
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:
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: