DBA Data[Home] [Help]

APPS.PAY_VOID_UI_PKG dependencies on HR_UTILITY

Line 95: hr_utility.set_location('Entering: '||l_proc, 5);

91: l_proc varchar2(72) := 'PAY_VOID_UI_PKG.GET_PROCESS_NAME';
92: --
93: begin
94:
95: hr_utility.set_location('Entering: '||l_proc, 5);
96:
97: -- Get all the requests which have been spawned for that process_request_id
98: for process_flow_rec in csr_process_flow
99: LOOP

Line 126: hr_utility.set_location(l_proc, 10);

122: end if;
123:
124: end LOOP;
125:
126: hr_utility.set_location(l_proc, 10);
127:
128: -- Get the set name
129: open csr_set_name(l_set_id);
130: fetch csr_set_name into l_set_name;

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

131: close csr_set_name;
132:
133: return l_set_name;
134:
135: hr_utility.set_location('Leaving: '||l_proc, 20);
136:
137: END get_process_name;
138:
139:

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

166: l_proc varchar2(72) := 'PAY_VOID_UI_PKG.RETRIEVE_ASG_STATUS' ;
167: --
168: begin
169:
170: hr_utility.set_location('Entering '||l_proc, 10);
171:
172: open get_initialization_proc(p_process_flow_id);
173: fetch get_initialization_proc into l_initialization_procedure;
174: close get_initialization_proc;

Line 186: hr_utility.set_location(l_proc, 20);

182: l_sql_stmt := l_sql_stmt || ':1';
183: l_sql_stmt := l_sql_stmt || ');';
184: l_sql_stmt := l_sql_stmt || ' end;';
185:
186: hr_utility.set_location(l_proc, 20);
187:
188: begin
189: execute immediate l_sql_stmt using OUT l_asg_valid;
190: if (l_asg_valid = 1) then

Line 196: then hr_utility.trace('Error raised while executing initialization procedure');

192: else return 0;
193: end if;
194: exception
195: when others
196: then hr_utility.trace('Error raised while executing initialization procedure');
197: raise;
198: end;
199:
200: else

Line 204: hr_utility.set_location('Leaving '||l_proc, 30);

200: else
201: return 1;
202: end if;
203:
204: hr_utility.set_location('Leaving '||l_proc, 30);
205:
206: end retrieve_asg_status;
207:
208: END PAY_VOID_UI_PKG;