APPS.PQP_PROFESSIONAL_BODY_FUNCTION dependencies on HR_UTILITY

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

36: l_organization_id NUMBER(15);
37:
38: BEGIN
39:
40: hr_utility.set_location('Entering: '||l_proc, 10);
41:
42: --
43: OPEN csr_get_organization_info;
44: FETCH csr_get_organization_info INTO l_organization_id;

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

66:
67: p_organization_id := l_organization_id;
68:
69: --
70: hr_utility.set_location('Leaving: '||l_proc, 20);
71:
72: RETURN l_ret_vlu;
73: -- Added by tmehra for nocopy changes Feb'03
74:

Line 77: hr_utility.set_location('Entering excep:'||l_proc, 35);

73: -- Added by tmehra for nocopy changes Feb'03
74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: hr_utility.set_location('Entering excep:'||l_proc, 35);
78: p_error_message := SQLERRM;
79: p_organization_id := NULL;
80: raise;
81:

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

150: );
151:
152: BEGIN
153:
154: hr_utility.set_location ('Entering: '||l_proc, 10);
155: --
156: OPEN csr_get_person_id;
157: FETCH csr_get_person_id INTO l_person_id;
158:

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

168:
169: END IF; -- End if of person id check...
170: CLOSE csr_get_person_id;
171:
172: hr_utility.set_location (l_proc, 20);
173: --
174:
175: OPEN csr_get_pb_name;
176: FETCH csr_get_pb_name INTO l_pb_name;

Line 189: hr_utility.set_location (l_proc, 30);

185: p_error_message := 'There is no professional body information for this organization.';
186:
187: ELSE
188:
189: hr_utility.set_location (l_proc, 30);
190: --
191: OPEN csr_get_pb_mem_info (l_pb_name);
192: FETCH csr_get_pb_mem_info INTO p_professional_body_nm
193: ,p_membership_category;

Line 211: hr_utility.set_location (l_proc, 40);

207: --
208: -- Check any other row exists for this professional body name
209: --
210:
211: hr_utility.set_location (l_proc, 40);
212: --
213: FETCH csr_get_pb_mem_info INTO p_professional_body_nm
214: ,p_membership_category;
215: IF csr_get_pb_mem_info%FOUND THEN

Line 235: hr_utility.set_location ('Leaving: '||l_proc, 50);

231: END IF; -- End if of organization check...
232: CLOSE csr_get_pb_name;
233:
234: --
235: hr_utility.set_location ('Leaving: '||l_proc, 50);
236:
237: RETURN l_ret_vlu;
238:
239:

Line 244: hr_utility.set_location('Entering excep:'||l_proc, 65);

240: -- Added by tmehra for nocopy changes Feb'03
241:
242: EXCEPTION
243: WHEN OTHERS THEN
244: hr_utility.set_location('Entering excep:'||l_proc, 65);
245: p_professional_body_nm := NULL;
246: p_membership_category := NULL;
247: p_error_message := SQLERRM;
248: raise;

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

318: l_dummy VARCHAR2(1);
319:
320: BEGIN
321:
322: hr_utility.set_location ('Entering: '||l_proc, 10);
323: --
324: OPEN csr_get_udt_id;
325: FETCH csr_get_udt_id INTO l_user_table_id;
326:

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

335:
336:
337: ELSE
338:
339: hr_utility.set_location(l_proc, 20);
340: --
341:
342: OPEN csr_get_udt_row (l_user_table_id);
343: FETCH csr_get_udt_row INTO p_user_row_value

Line 358: hr_utility.set_location(l_proc, 30);

354: 'exist in the professional membership subscription rates table.';
355:
356: ELSE
357:
358: hr_utility.set_location(l_proc, 30);
359: --
360:
361: FETCH csr_get_udt_row INTO p_user_row_value
362: ,p_user_table_name;

Line 373: hr_utility.set_location(l_proc, 40);

369: 'not contain multiple rows.';
370:
371: ELSE
372:
373: hr_utility.set_location(l_proc, 40);
374: --
375:
376: OPEN csr_check_udt_col (l_user_table_id);
377: FETCH csr_check_udt_col INTO l_dummy;

Line 402: hr_utility.set_location ('Leaving: '||l_proc, 50);

398: END IF; -- End if of udt info check...
399: CLOSE csr_get_udt_id;
400:
401: --
402: hr_utility.set_location ('Leaving: '||l_proc, 50);
403:
404: RETURN l_ret_vlu;
405:
406: -- Added by tmehra for nocopy changes Feb'03

Line 410: hr_utility.set_location('Entering excep:'||l_proc, 65);

406: -- Added by tmehra for nocopy changes Feb'03
407:
408: EXCEPTION
409: WHEN OTHERS THEN
410: hr_utility.set_location('Entering excep:'||l_proc, 65);
411: p_user_table_name := NULL;
412: p_user_row_value := NULL;
413: p_error_message := SQLERRM;
414: raise;