APPS.SSP_SMP_RATE_UPLD dependencies on HR_UTILITY

Line 36: hr_utility.trace_on(null,'REQID');

32: then
33:
34: if (p_debug = 'Y')
35: then
36: hr_utility.trace_on(null,'REQID');
37: hr_utility.set_location('Entered '||g_package,1);
38: end if;
39:
40: hr_utility.set_location('Entered '||g_package,1);

Line 37: hr_utility.set_location('Entered '||g_package,1);

33:
34: if (p_debug = 'Y')
35: then
36: hr_utility.trace_on(null,'REQID');
37: hr_utility.set_location('Entered '||g_package,1);
38: end if;
39:
40: hr_utility.set_location('Entered '||g_package,1);
41:

Line 40: hr_utility.set_location('Entered '||g_package,1);

36: hr_utility.trace_on(null,'REQID');
37: hr_utility.set_location('Entered '||g_package,1);
38: end if;
39:
40: hr_utility.set_location('Entered '||g_package,1);
41:
42: /* When Patching is in progress goto sleep mode until patching is complete. */
43: loop
44: hr_utility.set_location(g_package||'Inside while loop',10);

Line 44: hr_utility.set_location(g_package||'Inside while loop',10);

40: hr_utility.set_location('Entered '||g_package,1);
41:
42: /* When Patching is in progress goto sleep mode until patching is complete. */
43: loop
44: hr_utility.set_location(g_package||'Inside while loop',10);
45: if ad_zd.get_edition('PATCH') is not null then
46: -- an online patch is in progress, goto sleep
47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);
48: dbms_lock.sleep(10);

Line 47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);

43: loop
44: hr_utility.set_location(g_package||'Inside while loop',10);
45: if ad_zd.get_edition('PATCH') is not null then
46: -- an online patch is in progress, goto sleep
47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);
48: dbms_lock.sleep(10);
49: end if;
50: exit when ad_zd.get_edition('PATCH') is null;
51: end loop;