DBA Data[Home] [Help]

APPS.PQH_OPS_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pqh_ops_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

Line 149: hr_utility.set_location(' Leaving:'|| l_proc, 40);

145: close csr_leg_code;
146: pqh_ops_bus.g_wrkplc_vldtn_op_id := p_wrkplc_vldtn_op_id;
147: pqh_ops_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

Line 206: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALVER_ID');

202: -- EDIT_HERE: Add checks to ensure non-updateable args have
203: -- not been updated.
204: --
205: If P_Rec.WRKPLC_VLDTN_VER_ID <> pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id Then
206: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALVER_ID');
207: fnd_message.raise_error;
208: End If;
209:
210: End chk_non_updateable_args;

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

224: l_Employment_type Pqh_De_Wrkplc_Vldtns.Employment_Type%TYPE;
225: l_Remuneration_Regulation Pqh_De_Wrkplc_Vldtns.Remuneration_Regulation%TYPE;
226: Begin
227:
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: Open Ops;
230: Fetch Ops into l_Employment_Type, l_Remuneration_regulation;
231: If OPS%NOTFOUND Then
232: Close Ops;

Line 233: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');

229: Open Ops;
230: Fetch Ops into l_Employment_Type, l_Remuneration_regulation;
231: If OPS%NOTFOUND Then
232: Close Ops;
233: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');
234: hr_utility.raise_error;
235: Else
236: If Not(l_Employment_Type = 'WC' and l_Remuneration_Regulation = 'CP') Then
237: Close Ops;

Line 234: hr_utility.raise_error;

230: Fetch Ops into l_Employment_Type, l_Remuneration_regulation;
231: If OPS%NOTFOUND Then
232: Close Ops;
233: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');
234: hr_utility.raise_error;
235: Else
236: If Not(l_Employment_Type = 'WC' and l_Remuneration_Regulation = 'CP') Then
237: Close Ops;
238: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');

Line 238: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');

234: hr_utility.raise_error;
235: Else
236: If Not(l_Employment_Type = 'WC' and l_Remuneration_Regulation = 'CP') Then
237: Close Ops;
238: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');
239: hr_utility.raise_error;
240: End If;
241: End If;
242: Exception

Line 239: hr_utility.raise_error;

235: Else
236: If Not(l_Employment_Type = 'WC' and l_Remuneration_Regulation = 'CP') Then
237: Close Ops;
238: hr_utility.set_message(8302, 'PQH_DE_OPS_VALDTN_DEFINITION');
239: hr_utility.raise_error;
240: End If;
241: End If;
242: Exception
243: when app_exception.application_exception then

Line 246: hr_utility.set_location(' Leaving:'||l_proc,60);

242: Exception
243: when app_exception.application_exception then
244: if hr_multi_message.exception_add
245: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID') then
246: hr_utility.set_location(' Leaving:'||l_proc,60);
247: raise;
248: end if;
249: hr_utility.set_location(' Leaving:'||l_proc,70);
250: End Chk_ops_Req;

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

245: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID') then
246: hr_utility.set_location(' Leaving:'||l_proc,60);
247: raise;
248: end if;
249: hr_utility.set_location(' Leaving:'||l_proc,70);
250: End Chk_ops_Req;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |---------------------------< insert_validate >----------------------------|

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

259: --
260: l_proc varchar2(72) := g_package||'insert_validate';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Call all supporting business operations
266: --
267: hr_api.validate_bus_grp_id

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

272: -- After validating the set of important attributes,
273: -- if Multiple Message detection is enabled and at least
274: -- one error has been found then abort further validation.
275: --
276: hr_utility.set_location('Entering:'||l_proc, 10);
277:
278: Chk_Ops_Req
279: (p_effective_date
280: ,p_rec);

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

283: --
284: -- Validate Dependent Attributes
285: --
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End insert_validate;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------< update_validate >----------------------------|

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

297: --
298: l_proc varchar2(72) := g_package||'update_validate';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call all supporting business operations
304: --
305: hr_api.validate_bus_grp_id

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

320: ,p_rec => p_rec
321: );
322: --
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End update_validate;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------< delete_validate >----------------------------|

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

333: --
334: l_proc varchar2(72) := g_package||'delete_validate';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- Call all supporting business operations
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- Call all supporting business operations
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 10);
342: End delete_validate;
343: --
344: end pqh_ops_bus;