DBA Data[Home] [Help]

APPS.BEN_CWB_APPROVALS dependencies on HR_UTILITY

Line 80: --hr_utility.trace_on (null, 'ORACLE');

76: and tsk.task_id= grp.cwb_wksht_grp_id;
77:
78:
79: begin
80: --hr_utility.trace_on (null, 'ORACLE');
81:
82: hr_utility.set_location('Entering '||l_package ,10);
83:
84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);

Line 82: hr_utility.set_location('Entering '||l_package ,10);

78:
79: begin
80: --hr_utility.trace_on (null, 'ORACLE');
81:
82: hr_utility.set_location('Entering '||l_package ,10);
83:
84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);
85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);
86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);

Line 84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);

80: --hr_utility.trace_on (null, 'ORACLE');
81:
82: hr_utility.set_location('Entering '||l_package ,10);
83:
84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);
85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);
86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);
87: --hr_utility.set_location('p_effective_date '||p_effective_date ,60);
88: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);

Line 85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);

81:
82: hr_utility.set_location('Entering '||l_package ,10);
83:
84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);
85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);
86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);
87: --hr_utility.set_location('p_effective_date '||p_effective_date ,60);
88: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
89:

Line 86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);

82: hr_utility.set_location('Entering '||l_package ,10);
83:
84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);
85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);
86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);
87: --hr_utility.set_location('p_effective_date '||p_effective_date ,60);
88: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
89:
90:

Line 87: --hr_utility.set_location('p_effective_date '||p_effective_date ,60);

83:
84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);
85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);
86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);
87: --hr_utility.set_location('p_effective_date '||p_effective_date ,60);
88: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
89:
90:
91: for i in getManagers loop

Line 88: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);

84: --hr_utility.set_location('p_group_per_in_ler_id '||p_group_per_in_ler_id ,20);
85: --hr_utility.set_location('p_group_pl_id '||p_group_pl_id ,30);
86: --hr_utility.set_location('p_group_oipl_id '||p_group_oipl_id ,40);
87: --hr_utility.set_location('p_effective_date '||p_effective_date ,60);
88: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
89:
90:
91: for i in getManagers loop
92:

Line 99: --hr_utility.set_location('p_group_per_in_ler_id '||l_group_per_in_ler_id ,20);

95: l_group_oipl_id := i.group_oipl_id;
96: l_access_cd:= i.access_cd;
97: l_object_version_number := i.object_version_number;
98:
99: --hr_utility.set_location('p_group_per_in_ler_id '||l_group_per_in_ler_id ,20);
100: --hr_utility.set_location('p_group_pl_id '||l_group_pl_id ,30);
101: --hr_utility.set_location('p_group_oipl_id '||l_group_oipl_id ,40);
102: --hr_utility.set_location('l_access_cd '||l_access_cd ,50);
103:

Line 100: --hr_utility.set_location('p_group_pl_id '||l_group_pl_id ,30);

96: l_access_cd:= i.access_cd;
97: l_object_version_number := i.object_version_number;
98:
99: --hr_utility.set_location('p_group_per_in_ler_id '||l_group_per_in_ler_id ,20);
100: --hr_utility.set_location('p_group_pl_id '||l_group_pl_id ,30);
101: --hr_utility.set_location('p_group_oipl_id '||l_group_oipl_id ,40);
102: --hr_utility.set_location('l_access_cd '||l_access_cd ,50);
103:
104:

Line 101: --hr_utility.set_location('p_group_oipl_id '||l_group_oipl_id ,40);

97: l_object_version_number := i.object_version_number;
98:
99: --hr_utility.set_location('p_group_per_in_ler_id '||l_group_per_in_ler_id ,20);
100: --hr_utility.set_location('p_group_pl_id '||l_group_pl_id ,30);
101: --hr_utility.set_location('p_group_oipl_id '||l_group_oipl_id ,40);
102: --hr_utility.set_location('l_access_cd '||l_access_cd ,50);
103:
104:
105: if ('NA' <> l_access_cd) then

Line 102: --hr_utility.set_location('l_access_cd '||l_access_cd ,50);

98:
99: --hr_utility.set_location('p_group_per_in_ler_id '||l_group_per_in_ler_id ,20);
100: --hr_utility.set_location('p_group_pl_id '||l_group_pl_id ,30);
101: --hr_utility.set_location('p_group_oipl_id '||l_group_oipl_id ,40);
102: --hr_utility.set_location('l_access_cd '||l_access_cd ,50);
103:
104:
105: if ('NA' <> l_access_cd) then
106:

Line 149: --hr_utility.set_location('l_task_id '||l_task_id ,60);

145: close getTaskObjVerNum;
146:
147: if(l_task_status <> 'CO') then
148:
149: --hr_utility.set_location('l_task_id '||l_task_id ,60);
150: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
151:
152: BEN_CWB_PERSON_TASKS_API.update_person_task
153: (

Line 150: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);

146:
147: if(l_task_status <> 'CO') then
148:
149: --hr_utility.set_location('l_task_id '||l_task_id ,60);
150: --hr_utility.set_location('p_login_person_id '||p_login_person_id ,70);
151:
152: BEN_CWB_PERSON_TASKS_API.update_person_task
153: (
154: p_validate => false

Line 168: hr_utility.set_location('Leaving '||l_package ,30);

164:
165: end loop;
166:
167:
168: hr_utility.set_location('Leaving '||l_package ,30);
169: --hr_utility.trace_off;
170:
171: EXCEPTION
172: when others then

Line 169: --hr_utility.trace_off;

165: end loop;
166:
167:
168: hr_utility.set_location('Leaving '||l_package ,30);
169: --hr_utility.trace_off;
170:
171: EXCEPTION
172: when others then
173: l_error:=fnd_message.get;

Line 174: hr_utility.set_location ('exception is'||l_error , 300);

170:
171: EXCEPTION
172: when others then
173: l_error:=fnd_message.get;
174: hr_utility.set_location ('exception is'||l_error , 300);
175:
176: end approve_all_managers;
177:
178: