APPS.BEN_PLAN_DESIGN_DELETE_API dependencies on HR_UTILITY

Line 25: hr_utility.set_location('Entering: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);

21: p_validate boolean := false;
22: l_encoded_message varchar2(2000);
23: l_proc varchar2(72) := g_package||'call_delete_api';
24: begin
25: hr_utility.set_location('Entering: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);
26: -- set the validate mode
27: if(p_process_validate = 1) then
28: p_validate:=true;
29: end if ;

Line 2346: hr_utility.set_location('Leaving: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);

2342: ,p_effective_date => p_effective_date
2343: ,p_datetrack_mode => p_datetrack_mode
2344: );
2345: end if;
2346: hr_utility.set_location('Leaving: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);
2347: exception
2348: when OTHERS THEN
2349: hr_utility.set_location('Delete failed for: '|| p_table_alias || ' primary key: '||p_pk_id ,30);
2350: --NOTIFY

Line 2349: hr_utility.set_location('Delete failed for: '|| p_table_alias || ' primary key: '||p_pk_id ,30);

2345: end if;
2346: hr_utility.set_location('Leaving: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);
2347: exception
2348: when OTHERS THEN
2349: hr_utility.set_location('Delete failed for: '|| p_table_alias || ' primary key: '||p_pk_id ,30);
2350: --NOTIFY
2351: p_delete_failed := 'Y';
2352: l_encoded_message := fnd_message.get;
2353: if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then

Line 2395: hr_utility.set_location('Entering: '||l_proc,10);

2391: l_proc varchar2(72) := g_package||'call_delete_apis';
2392: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2393:
2394: begin
2395: hr_utility.set_location('Entering: '||l_proc,10);
2396: open c_copy_entity_txn;
2397: fetch c_copy_entity_txn into l_effective_date;
2398: close c_copy_entity_txn;
2399:

Line 2426: hr_utility.set_location('Leaving: '||l_proc,20);

2422: , p_delete_failed => p_delete_failed
2423: );
2424:
2425: end loop;
2426: hr_utility.set_location('Leaving: '||l_proc,20);
2427: end call_delete_apis;
2428:
2429:
2430: procedure call_delete_apis_for_hierarchy

Line 2463: hr_utility.set_location('Entering: '||l_proc,10);

2459: l_proc varchar2(72) := g_package||'call_delete_apis_for_hierarchy';
2460: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2461: l_parent_entity_name ben_copy_entity_results.information5%type;
2462: begin
2463: hr_utility.set_location('Entering: '||l_proc,10);
2464: open c_copy_entity_txn;
2465: fetch c_copy_entity_txn into l_effective_date;
2466: close c_copy_entity_txn;
2467: open c_parent_entity_name;

Line 2498: hr_utility.set_location('Leaving: '||l_proc,20);

2494: , p_delete_failed => p_delete_failed
2495: );
2496:
2497: end loop;
2498: hr_utility.set_location('Leaving: '||l_proc,20);
2499: end call_delete_apis_for_hierarchy;
2500:
2501: end ben_plan_design_delete_api;
2502: