DBA Data[Home] [Help]

APPS.PQH_FTR_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_ftr_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_ftr_bus.g_wrkplc_vldtn_jobftr_id := p_wrkplc_vldtn_jobftr_id;
147: pqh_ftr_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 224: hr_utility.set_location('Entering:'||l_proc, 5);

220: between Nvl(START_DATE_ACTIVE,Trunc(Sysdate))
221: and Nvl(END_DATE_ACTIVE,Trunc(Sysdate))
222: and ENABLED_FLAG = 'Y';
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: Open JobFtr;
227: Fetch JobFtr into l_Result;
228: If JobFtr%NOTFOUND Then

Line 230: hr_utility.set_message(8302,'PQH_DE_FTR_VALDTN');

226: Open JobFtr;
227: Fetch JobFtr into l_Result;
228: If JobFtr%NOTFOUND Then
229: Close Jobftr;
230: hr_utility.set_message(8302,'PQH_DE_FTR_VALDTN');
231: hr_utility.raise_error;
232: End If;
233: Exception
234: when app_exception.application_exception then

Line 231: hr_utility.raise_error;

227: Fetch JobFtr into l_Result;
228: If JobFtr%NOTFOUND Then
229: Close Jobftr;
230: hr_utility.set_message(8302,'PQH_DE_FTR_VALDTN');
231: hr_utility.raise_error;
232: End If;
233: Exception
234: when app_exception.application_exception then
235: if hr_multi_message.exception_add

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

234: when app_exception.application_exception then
235: if hr_multi_message.exception_add
236: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_JOBFTRS.JOB_FEATURE_CODE'
237: ) then
238: hr_utility.set_location(' Leaving:'||l_proc,60);
239: raise;
240: end if;
241: hr_utility.set_location(' Leaving:'||l_proc,70);
242: End Chk_Jobftr;

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

237: ) then
238: hr_utility.set_location(' Leaving:'||l_proc,60);
239: raise;
240: end if;
241: hr_utility.set_location(' Leaving:'||l_proc,70);
242: End Chk_Jobftr;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |---------------------------< insert_validate >----------------------------|

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

251: --
252: l_proc varchar2(72) := g_package||'insert_validate';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: -- Call all supporting business operations
258: --
259: hr_api.validate_bus_grp_id

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

270: -- Validate Dependent Attributes
271: --
272: Chk_Jobftr(p_effective_date, p_Rec.JOB_FEATURE_CODE);
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: End insert_validate;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |---------------------------< update_validate >----------------------------|

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

284: --
285: l_proc varchar2(72) := g_package||'update_validate';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call all supporting business operations
291: --
292: hr_api.validate_bus_grp_id

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

308: );
309: --
310: Chk_Jobftr(p_effective_date, p_Rec.JOB_FEATURE_CODE);
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: End update_validate;
314: --
315: -- ----------------------------------------------------------------------------
316: -- |---------------------------< delete_validate >----------------------------|

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

321: --
322: l_proc varchar2(72) := g_package||'delete_validate';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Call all supporting business operations
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Call all supporting business operations
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);
330: End delete_validate;
331: --
332: end pqh_ftr_bus;