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