DBA Data[Home] [Help]

APPS.HR_APPLICANT_DATAUPD dependencies on FND_FILE

Line 239: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed to process application '||l_failed_apl||

235: --
236: else
237: --
238: l_continue_process := FALSE;
239: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed to process application '||l_failed_apl||
240: ' (person id = '||l_failed_person_id||')');
241: raise e_LockFailure;
242: --
243: end if;

Line 277: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed to process application '||l_failed_apl||

273: hr_utility.trace('Failed to process application '||l_failed_apl||
274: ' (person id = '||l_failed_person_id||')');
275:
276: else
277: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed to process application '||l_failed_apl||
278: ' (person id = '||l_failed_person_id||')');
279: raise e_LockFailure;
280:
281: end if;

Line 283: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while processing application '||l_failed_apl||

279: raise e_LockFailure;
280:
281: end if;
282: when OTHERS then
283: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while processing application '||l_failed_apl||
284: ' (person id = '||l_failed_person_id||')');
285: raise;
286:
287: END ConvertToApplicant;

Line 401: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);

397: IF ((l_retstatus = FALSE)
398: OR (l_table_owner is null)) THEN
399: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
400: END IF;
401: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
402: fnd_file.put_line(FND_FILE.LOG, ' UpdateName : '||l_update_name);
403: fnd_file.put_line(FND_FILE.LOG, ' p_caller : '||p_caller);
404: --
405: IF p_process_ALL = 'Y' THEN

Line 402: fnd_file.put_line(FND_FILE.LOG, ' UpdateName : '||l_update_name);

398: OR (l_table_owner is null)) THEN
399: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
400: END IF;
401: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
402: fnd_file.put_line(FND_FILE.LOG, ' UpdateName : '||l_update_name);
403: fnd_file.put_line(FND_FILE.LOG, ' p_caller : '||p_caller);
404: --
405: IF p_process_ALL = 'Y' THEN
406: --

Line 403: fnd_file.put_line(FND_FILE.LOG, ' p_caller : '||p_caller);

399: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
400: END IF;
401: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
402: fnd_file.put_line(FND_FILE.LOG, ' UpdateName : '||l_update_name);
403: fnd_file.put_line(FND_FILE.LOG, ' p_caller : '||p_caller);
404: --
405: IF p_process_ALL = 'Y' THEN
406: --
407: --

Line 431: fnd_file.put_line(FND_FILE.LOG,' ** Upgrade Status row deleted successfully **');

427: where upgrade_definition_id =
428: (select upgrade_definition_id
429: from pay_upgrade_definitions
430: where short_name = l_update_name);
431: fnd_file.put_line(FND_FILE.LOG,' ** Upgrade Status row deleted successfully **');
432:
433: -- If we are called from a manual submission then we need to run the
434: -- data update even if it has run before. Therefore the LTU update
435: -- name needs to be a new previously unused value so concat the

Line 463: fnd_file.put_line(FND_FILE.LOG, '**************');

459: open csr_get_apl_rowid(p_apl_id);
460: fetch csr_get_apl_rowid into l_apl_rowid;
461: if csr_get_apl_rowid%NOTFOUND then
462: close csr_get_apl_rowid;
463: fnd_file.put_line(FND_FILE.LOG, '**************');
464: fnd_file.put_line(FND_FILE.LOG, 'Application ID: '||p_apl_id||' not found.');
465: raise e_NoDataFound;
466: else
467: close csr_get_apl_rowid;

Line 464: fnd_file.put_line(FND_FILE.LOG, 'Application ID: '||p_apl_id||' not found.');

460: fetch csr_get_apl_rowid into l_apl_rowid;
461: if csr_get_apl_rowid%NOTFOUND then
462: close csr_get_apl_rowid;
463: fnd_file.put_line(FND_FILE.LOG, '**************');
464: fnd_file.put_line(FND_FILE.LOG, 'Application ID: '||p_apl_id||' not found.');
465: raise e_NoDataFound;
466: else
467: close csr_get_apl_rowid;
468: hr_applicant_dataupd.ConvertToApplicant(l_apl_rowid, l_apl_rowid, l_rows_processed);

Line 534: fnd_file.put_line(FND_FILE.LOG, ' X_Worker_Id : '||X_Worker_Id);

530: IF ((l_retstatus = FALSE)
531: OR (l_table_owner is null)) THEN
532: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
533: END IF;
534: fnd_file.put_line(FND_FILE.LOG, ' X_Worker_Id : '||X_Worker_Id);
535: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
536: fnd_file.put_line(FND_FILE.LOG, ' updateName : '||p_updateName);
537: --
538: -- Worker processing

Line 535: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);

531: OR (l_table_owner is null)) THEN
532: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
533: END IF;
534: fnd_file.put_line(FND_FILE.LOG, ' X_Worker_Id : '||X_Worker_Id);
535: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
536: fnd_file.put_line(FND_FILE.LOG, ' updateName : '||p_updateName);
537: --
538: -- Worker processing
539: --

Line 536: fnd_file.put_line(FND_FILE.LOG, ' updateName : '||p_updateName);

532: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
533: END IF;
534: fnd_file.put_line(FND_FILE.LOG, ' X_Worker_Id : '||X_Worker_Id);
535: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
536: fnd_file.put_line(FND_FILE.LOG, ' updateName : '||p_updateName);
537: --
538: -- Worker processing
539: --
540: BEGIN