DBA Data[Home] [Help]

APPS.PER_CAREER_PATHS_PKG_1 dependencies on HR_UTILITY

Line 14: hr_utility.set_location('per_career_paths_pkg_1.stb_del_val',1);

10: where career_path_id = p_cpath_id;
11: --
12: begin
13: --
14: hr_utility.set_location('per_career_paths_pkg_1.stb_del_val',1);
15: --
16: open c1;
17: --
18: fetch c1 into l_exists;

Line 21: hr_utility.set_message(800, 'PER_7840_DEF_CAR_PATH_DELETE');

17: --
18: fetch c1 into l_exists;
19: --
20: IF c1%found THEN
21: hr_utility.set_message(800, 'PER_7840_DEF_CAR_PATH_DELETE');
22: close c1;
23: hr_utility.raise_error;
24: END IF;
25: --

Line 23: hr_utility.raise_error;

19: --
20: IF c1%found THEN
21: hr_utility.set_message(800, 'PER_7840_DEF_CAR_PATH_DELETE');
22: close c1;
23: hr_utility.raise_error;
24: END IF;
25: --
26: close c1;
27: --

Line 46: hr_utility.set_location('per_career_paths_pkg_1.unique_chk',1);

42: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));
43: --
44: begin
45: --
46: hr_utility.set_location('per_career_paths_pkg_1.unique_chk',1);
47: --
48: open c2;
49: --
50: fetch c2 into l_exists2;

Line 53: hr_utility.set_message(800, 'PER_7841_DEF_CAR_PATH_EXISTS');

49: --
50: fetch c2 into l_exists2;
51: --
52: IF c2%found THEN
53: hr_utility.set_message(800, 'PER_7841_DEF_CAR_PATH_EXISTS');
54: close c2;
55: hr_utility.raise_error;
56: END IF;
57: --

Line 55: hr_utility.raise_error;

51: --
52: IF c2%found THEN
53: hr_utility.set_message(800, 'PER_7841_DEF_CAR_PATH_EXISTS');
54: close c2;
55: hr_utility.raise_error;
56: END IF;
57: --
58: close c2;
59: --

Line 71: hr_utility.set_location('per_career_paths_pkg_1.get_id',1);

67: from sys.dual;
68: --
69: begin
70: --
71: hr_utility.set_location('per_career_paths_pkg_1.get_id',1);
72: --
73: open c3;
74: --
75: fetch c3 into p_cpath_id;