DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_UTILITY

Line 430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);

426:
427: Return;
428:
429: End If;
430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);
431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);
432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);
433:
434: /* for l_parent_rec in c_epa_from_parent( p_pgm_id,p_ptip_id,p_plip_id,p_pl_id,p_oipl_id ) loop */

Line 431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);

427: Return;
428:
429: End If;
430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);
431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);
432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);
433:
434: /* for l_parent_rec in c_epa_from_parent( p_pgm_id,p_ptip_id,p_plip_id,p_pl_id,p_oipl_id ) loop */
435:

Line 432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);

428:
429: End If;
430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);
431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);
432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);
433:
434: /* for l_parent_rec in c_epa_from_parent( p_pgm_id,p_ptip_id,p_plip_id,p_pl_id,p_oipl_id ) loop */
435:
436: --

Line 447: hr_utility.set_location('data pulled '||l_prtn_elig_id,10);

443: Loop
444:
445: Fetch c_Parent_rec into l_prtn_elig_id;
446:
447: hr_utility.set_location('data pulled '||l_prtn_elig_id,10);
448:
449: If c_Parent_Rec%NOTFOUND Then
450: Close c_Parent_Rec;
451: Exit;

Line 894: hr_utility.set_location('end of per',10);

890: end if;
891: --
892: end loop;
893: --
894: hr_utility.set_location('end of per',10);
895: end loop;
896: ---------------------------------------------------------------
897: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------
898: ---------------------------------------------------------------

Line 899: hr_utility.set_location('end of pe',10);

895: end loop;
896: ---------------------------------------------------------------
897: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------
898: ---------------------------------------------------------------
899: hr_utility.set_location('end of pe',10);
900: end loop;
901: ---------------------------------------------------------------
902: -- END OF BEN_PRTN_ELIG_F ----------------------
903: ---------------------------------------------------------------

Line 904: hr_utility.set_location('out of routine',10);

900: end loop;
901: ---------------------------------------------------------------
902: -- END OF BEN_PRTN_ELIG_F ----------------------
903: ---------------------------------------------------------------
904: hr_utility.set_location('out of routine',10);
905: end ;
906: --
907: procedure create_dep_elpro_result
908: (

Line 5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);

5197: end if;
5198: --
5199: end loop;
5200: --
5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);
5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);
5203: for l_ecl_rec in c_ecl_drp(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);
5205: ben_pd_rate_and_cvg_module.create_drpar_results

Line 5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);

5198: --
5199: end loop;
5200: --
5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);
5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);
5203: for l_ecl_rec in c_ecl_drp(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);
5205: ben_pd_rate_and_cvg_module.create_drpar_results
5206: (

Line 5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);

5200: --
5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);
5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);
5203: for l_ecl_rec in c_ecl_drp(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);
5205: ben_pd_rate_and_cvg_module.create_drpar_results
5206: (
5207: p_validate => p_validate
5208: ,p_copy_entity_result_id => l_out_ecl_result_id

Line 7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

7501: l_mapping_column_name1,
7502: l_mapping_column_name2,
7503: p_copy_entity_txn_id);
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --

Line 7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

7502: l_mapping_column_name2,
7503: p_copy_entity_txn_id);
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7510:

Line 7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);

7503: p_copy_entity_txn_id);
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7510:
7511: l_copy_entity_result_id := null;

Line 7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);

7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7510:
7511: l_copy_entity_result_id := null;
7512: l_object_version_number := null;