DBA Data[Home] [Help]

APPS.PAY_PWO_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pay_pwo_shd.api_updating
47: (p_occupation_id => p_occupation_id,
48: p_object_version_number => p_object_version_number);

Line 72: hr_utility.set_location('Leaving:'||l_proc, 10);

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_occupation_id;
75: -- ----------------------------------------------------------------------------
76: -- |-----------------------------< chk_job_group >----------------------------|

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

98: v_return_value boolean;
99: --
100: BEGIN
101: --
102: hr_utility.set_location('Entering:'||l_proc, 5);
103: --
104: OPEN get_job_group_job (p_job_id, p_business_group_id);
105: FETCH get_job_group_job INTO l_exists;
106: --

Line 109: hr_utility.set_location('Returnig FALSE: '||l_proc, 10);

105: FETCH get_job_group_job INTO l_exists;
106: --
107: IF get_job_group_job%NOTFOUND THEN
108: --
109: hr_utility.set_location('Returnig FALSE: '||l_proc, 10);
110: v_return_value := FALSE;
111: --
112: --
113: ELSE

Line 114: hr_utility.set_location('Returning TRUE: '||l_proc, 15);

110: v_return_value := FALSE;
111: --
112: --
113: ELSE
114: hr_utility.set_location('Returning TRUE: '||l_proc, 15);
115: v_return_value := TRUE;
116: --
117: END IF;
118: --

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

119: CLOSE get_job_group_job;
120: --
121: RETURN v_return_value;
122: --
123: hr_utility.set_location('Leaving: '||l_proc, 20);
124: --
125: END chk_job_group;
126: -- ----------------------------------------------------------------------------
127: -- |---------------------------< insert_validate >----------------------------|

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

130: --
131: l_proc varchar2(72) := g_package||'insert_validate';
132: --
133: Begin
134: hr_utility.set_location('Entering:'||l_proc, 5);
135: --
136: -- Call all supporting business operations
137: --
138: chk_occupation_id

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

142: IF NOT chk_job_group (p_job_id => p_rec.job_id
143: ,p_business_group_id => p_rec.business_group_id)
144: THEN
145: --
146: hr_utility.set_message(801,'PAY_74036_INVALID_JOB');
147: hr_utility.raise_error;
148: --
149: ELSE
150: --

Line 147: hr_utility.raise_error;

143: ,p_business_group_id => p_rec.business_group_id)
144: THEN
145: --
146: hr_utility.set_message(801,'PAY_74036_INVALID_JOB');
147: hr_utility.raise_error;
148: --
149: ELSE
150: --
151: hr_utility.trace('Valid job group job');

Line 151: hr_utility.trace('Valid job group job');

147: hr_utility.raise_error;
148: --
149: ELSE
150: --
151: hr_utility.trace('Valid job group job');
152: --
153: END IF;
154: --
155: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 157: hr_utility.set_location(' Leaving:'||l_proc, 10);

153: END IF;
154: --
155: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End insert_validate;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |---------------------------< update_validate >----------------------------|

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

164: --
165: l_proc varchar2(72) := g_package||'update_validate';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: -- Call all supporting business operations
171: --
172: chk_occupation_id

Line 178: hr_utility.set_location(' Leaving:'||l_proc, 10);

174: p_object_version_number => p_rec.object_version_number);
175: --
176: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End update_validate;
180: --
181: -- ----------------------------------------------------------------------------
182: -- |---------------------------< delete_validate >----------------------------|

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

185: --
186: l_proc varchar2(72) := g_package||'delete_validate';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: -- Call all supporting business operations
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 193: hr_utility.set_location(' Leaving:'||l_proc, 10);

189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: -- Call all supporting business operations
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End delete_validate;
195: --
196: --
197: -- ---------------------------------------------------------------------------

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

216: l_proc varchar2(72) := g_package||'return_legislation_code';
217: --
218: begin
219: --
220: hr_utility.set_location('Entering:'|| l_proc, 10);
221: --
222: -- Ensure that all the mandatory parameter are not null
223: --
224: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 238: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

234: close csr_leg_code;
235: --
236: -- The primary key is invalid therefore we must error
237: --
238: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
239: hr_utility.raise_error;
240: --
241: end if;
242: --

Line 239: hr_utility.raise_error;

235: --
236: -- The primary key is invalid therefore we must error
237: --
238: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
239: hr_utility.raise_error;
240: --
241: end if;
242: --
243: close csr_leg_code;

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

241: end if;
242: --
243: close csr_leg_code;
244: --
245: hr_utility.set_location(' Leaving:'|| l_proc, 20);
246: --
247: return l_legislation_code;
248: --
249: end return_legislation_code;