DBA Data[Home] [Help]

APPS.HRBISORGPARAMS dependencies on FND_FILE

Line 24: fnd_file.put_line(fnd_file.log,

20: begin
21: COMMIT;
22: exception
23: when others then
24: fnd_file.put_line(fnd_file.log,
25: 'HrBisOrgParams - Failed on Commit statement in CommitCount procedure: ');
26: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
27: end;
28:

Line 26: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);

22: exception
23: when others then
24: fnd_file.put_line(fnd_file.log,
25: 'HrBisOrgParams - Failed on Commit statement in CommitCount procedure: ');
26: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
27: end;
28:
29:
30: END IF;

Line 379: fnd_file.put_line(fnd_file.log,

375: , p_organization_process );
376:
377: exception
378: when others then
379: fnd_file.put_line(fnd_file.log,
380: '----------------------------------------------------------- ');
381: fnd_file.put_line(fnd_file.log,
382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');
383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);

Line 381: fnd_file.put_line(fnd_file.log,

377: exception
378: when others then
379: fnd_file.put_line(fnd_file.log,
380: '----------------------------------------------------------- ');
381: fnd_file.put_line(fnd_file.log,
382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');
383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);
385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '

Line 383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);

379: fnd_file.put_line(fnd_file.log,
380: '----------------------------------------------------------- ');
381: fnd_file.put_line(fnd_file.log,
382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');
383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);
385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '
386: || p_organization_structure_id);
387: fnd_file.put_line(fnd_file.log,'organization_id = '

Line 384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);

380: '----------------------------------------------------------- ');
381: fnd_file.put_line(fnd_file.log,
382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');
383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);
385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '
386: || p_organization_structure_id);
387: fnd_file.put_line(fnd_file.log,'organization_id = '
388: || p_organization_id);

Line 385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '

381: fnd_file.put_line(fnd_file.log,
382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');
383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);
385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '
386: || p_organization_structure_id);
387: fnd_file.put_line(fnd_file.log,'organization_id = '
388: || p_organization_id);
389: fnd_file.put_line(fnd_file.log,'organization_process = '

Line 387: fnd_file.put_line(fnd_file.log,'organization_id = '

383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);
385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '
386: || p_organization_structure_id);
387: fnd_file.put_line(fnd_file.log,'organization_id = '
388: || p_organization_id);
389: fnd_file.put_line(fnd_file.log,'organization_process = '
390: || p_organization_process);
391: fnd_file.put_line(fnd_file.log,

Line 389: fnd_file.put_line(fnd_file.log,'organization_process = '

385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '
386: || p_organization_structure_id);
387: fnd_file.put_line(fnd_file.log,'organization_id = '
388: || p_organization_id);
389: fnd_file.put_line(fnd_file.log,'organization_process = '
390: || p_organization_process);
391: fnd_file.put_line(fnd_file.log,
392: '----------------------------------------------------------- ');
393: end;

Line 391: fnd_file.put_line(fnd_file.log,

387: fnd_file.put_line(fnd_file.log,'organization_id = '
388: || p_organization_id);
389: fnd_file.put_line(fnd_file.log,'organization_process = '
390: || p_organization_process);
391: fnd_file.put_line(fnd_file.log,
392: '----------------------------------------------------------- ');
393: end;
394:
395: --

Line 453: fnd_file.put_line(fnd_file.log,

449: , r_child.organization_id_group
450: , r_child.organization_id_child );
451: exception
452: when others then
453: fnd_file.put_line(fnd_file.log,
454: '----------------------------------------------------------- ');
455: fnd_file.put_line(fnd_file.log,
456: 'HrBisOrgParams - Failed on insert into hri_org_param_list table: ');
457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);

Line 455: fnd_file.put_line(fnd_file.log,

451: exception
452: when others then
453: fnd_file.put_line(fnd_file.log,
454: '----------------------------------------------------------- ');
455: fnd_file.put_line(fnd_file.log,
456: 'HrBisOrgParams - Failed on insert into hri_org_param_list table: ');
457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
458: fnd_file.put_line(fnd_file.log,'org_param_id = ' || l_org_param_id);
459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||

Line 457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);

453: fnd_file.put_line(fnd_file.log,
454: '----------------------------------------------------------- ');
455: fnd_file.put_line(fnd_file.log,
456: 'HrBisOrgParams - Failed on insert into hri_org_param_list table: ');
457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
458: fnd_file.put_line(fnd_file.log,'org_param_id = ' || l_org_param_id);
459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||
460: r_child.organization_id_group);
461: fnd_file.put_line(fnd_file.log,'organization_id_child = ' ||

Line 458: fnd_file.put_line(fnd_file.log,'org_param_id = ' || l_org_param_id);

454: '----------------------------------------------------------- ');
455: fnd_file.put_line(fnd_file.log,
456: 'HrBisOrgParams - Failed on insert into hri_org_param_list table: ');
457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
458: fnd_file.put_line(fnd_file.log,'org_param_id = ' || l_org_param_id);
459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||
460: r_child.organization_id_group);
461: fnd_file.put_line(fnd_file.log,'organization_id_child = ' ||
462: r_child.organization_id_child);

Line 459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||

455: fnd_file.put_line(fnd_file.log,
456: 'HrBisOrgParams - Failed on insert into hri_org_param_list table: ');
457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
458: fnd_file.put_line(fnd_file.log,'org_param_id = ' || l_org_param_id);
459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||
460: r_child.organization_id_group);
461: fnd_file.put_line(fnd_file.log,'organization_id_child = ' ||
462: r_child.organization_id_child);
463: fnd_file.put_line(fnd_file.log,

Line 461: fnd_file.put_line(fnd_file.log,'organization_id_child = ' ||

457: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
458: fnd_file.put_line(fnd_file.log,'org_param_id = ' || l_org_param_id);
459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||
460: r_child.organization_id_group);
461: fnd_file.put_line(fnd_file.log,'organization_id_child = ' ||
462: r_child.organization_id_child);
463: fnd_file.put_line(fnd_file.log,
464: '----------------------------------------------------------- ');
465:

Line 463: fnd_file.put_line(fnd_file.log,

459: fnd_file.put_line(fnd_file.log,'organization_id_group = ' ||
460: r_child.organization_id_group);
461: fnd_file.put_line(fnd_file.log,'organization_id_child = ' ||
462: r_child.organization_id_child);
463: fnd_file.put_line(fnd_file.log,
464: '----------------------------------------------------------- ');
465:
466: end;
467:

Line 791: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);

787: delete from hri_org_param_list;
788: --
789: delete from hri_org_params;
790: --
791: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
792: --
793: end LoadAllHierarchies;
794:
795: ----------------------------------------------------------------------------------------------