APPS.HR_JOB_POS dependencies on HR_UTILITY

Line 29: Uses : hr_utility

25:
26: Description : Contains the definition of job and position procedures
27: as declared in the hr_job_pos package header
28:
29: Uses : hr_utility
30:
31: Change List
32: -----------
33:

Line 73: hr_utility.set_location('hr_job_pos.hr_jp_predelete',1);

69: --
70: if p_business_group_id = p_organization_id then
71: begin
72: -- Do Any rows Exist in PER_JOBS.
73: hr_utility.set_location('hr_job_pos.hr_jp_predelete',1);
74: select '1'
75: into l_test_func
76: from sys.dual
77: where exists ( select 1

Line 82: hr_utility.set_message(801,'HR_6131_ORG_JOBS_EXIST');

78: from PER_JOBS_V x
79: where x.business_group_id = p_business_group_id);
80: --
81: if SQL%ROWCOUNT >0 THEN
82: hr_utility.set_message(801,'HR_6131_ORG_JOBS_EXIST');
83: hr_utility.raise_error;
84: end if;
85: exception
86: when NO_DATA_FOUND THEN

Line 83: hr_utility.raise_error;

79: where x.business_group_id = p_business_group_id);
80: --
81: if SQL%ROWCOUNT >0 THEN
82: hr_utility.set_message(801,'HR_6131_ORG_JOBS_EXIST');
83: hr_utility.raise_error;
84: end if;
85: exception
86: when NO_DATA_FOUND THEN
87: null;

Line 96: hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);

92: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
93: --
94: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
95: --
96: hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);
97: select '1'
98: into l_test_func
99: from sys.dual
100: where exists ( select 1

Line 105: hr_utility.set_message(801,'HR_6557_ORG_POSITIONS_EXIST');

101: from HR_ALL_POSITIONS_F x
102: where x.organization_id = p_organization_id);
103: --
104: if SQL%ROWCOUNT >0 THEN
105: hr_utility.set_message(801,'HR_6557_ORG_POSITIONS_EXIST');
106: hr_utility.raise_error;
107: end if;
108: exception
109: when NO_DATA_FOUND THEN

Line 106: hr_utility.raise_error;

102: where x.organization_id = p_organization_id);
103: --
104: if SQL%ROWCOUNT >0 THEN
105: hr_utility.set_message(801,'HR_6557_ORG_POSITIONS_EXIST');
106: hr_utility.raise_error;
107: end if;
108: exception
109: when NO_DATA_FOUND THEN
110: null;

Line 137: hr_utility.set_location('hr_job_pos.hr_pos_bg_chk',1);

133: begin
134: -- Doing check on HR_ALL_POSITIONS_F.
135: --
136: -- Changed 02-Oct-99 SCNair (per_positions to HR_ALL_POSITIONS_F) Date tracked position requirement
137: hr_utility.set_location('hr_job_pos.hr_pos_bg_chk',1);
138: select '1'
139: into l_test_func
140: from sys.dual
141: where exists ( select 1

Line 146: hr_utility.set_message(801,'HR_6726_BG_POS_EXIST');

142: from HR_ALL_POSITIONS_F x
143: where x.ORGANIZATION_ID = p_organization_id);
144: --
145: if SQL%ROWCOUNT >0 THEN
146: hr_utility.set_message(801,'HR_6726_BG_POS_EXIST');
147: hr_utility.raise_error;
148: end if;
149: exception
150: when NO_DATA_FOUND THEN

Line 147: hr_utility.raise_error;

143: where x.ORGANIZATION_ID = p_organization_id);
144: --
145: if SQL%ROWCOUNT >0 THEN
146: hr_utility.set_message(801,'HR_6726_BG_POS_EXIST');
147: hr_utility.raise_error;
148: end if;
149: exception
150: when NO_DATA_FOUND THEN
151: null;