DBA Data[Home] [Help]

APPS.AME_AGL_BUS dependencies on HR_UTILITY

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

49: from ame_approval_groups
50: where approval_group_id = p_approval_group_id
51: and sysdate >= start_date and sysdate < end_date;
52: Begin
53: hr_utility.set_location('Entering:'||l_proc,10);
54: hr_api.mandatory_arg_error(p_api_name => l_proc
55: ,p_argument => 'APPROVAL_GROUP_ID'
56: ,p_argument_value => p_approval_group_id
57: );

Line 65: hr_utility.set_location(' Leaving:'||l_proc,30);

61: if l_count = 0 then
62: fnd_message.set_name('PER','AME_400557_INVALID_APG_ID');
63: fnd_message.raise_error;
64: end if;
65: hr_utility.set_location(' Leaving:'||l_proc,30);
66: exception
67: when app_exception.application_exception then
68: if hr_multi_message.exception_add
69: (p_associated_column1 =>

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

68: if hr_multi_message.exception_add
69: (p_associated_column1 =>
70: 'AME_APPROVAL_GROUPS_TL.APPROVAL_GROUP_ID'
71: ) then
72: hr_utility.set_location(' Leaving:'||l_proc, 40);
73: raise;
74: end if;
75: hr_utility.set_location( ' Leaving:'||l_proc,50 );
76: End chk_approval_group_id;

Line 75: hr_utility.set_location( ' Leaving:'||l_proc,50 );

71: ) then
72: hr_utility.set_location(' Leaving:'||l_proc, 40);
73: raise;
74: end if;
75: hr_utility.set_location( ' Leaving:'||l_proc,50 );
76: End chk_approval_group_id;
77:
78:
79: -- ----------------------------------------------------------------------------

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

105: ) IS
106: --
107: l_proc varchar2(72) := g_package || 'chk_user_approval_group_name';
108: Begin
109: hr_utility.set_location('Entering:'||l_proc,10);
110: hr_api.mandatory_arg_error(p_api_name => l_proc
111: ,p_argument => 'USER_APPROVAL_GROUP_NAME'
112: ,p_argument_value => p_user_approval_group_name
113: );

Line 114: hr_utility.set_location(' Leaving:'||l_proc,30);

110: hr_api.mandatory_arg_error(p_api_name => l_proc
111: ,p_argument => 'USER_APPROVAL_GROUP_NAME'
112: ,p_argument_value => p_user_approval_group_name
113: );
114: hr_utility.set_location(' Leaving:'||l_proc,30);
115: exception
116: when app_exception.application_exception then
117: if hr_multi_message.exception_add
118: (p_associated_column1 =>

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

117: if hr_multi_message.exception_add
118: (p_associated_column1 =>
119: 'AME_APPROVAL_GROUPS_TL.USER_APPROVAL_GROUP_NAME'
120: ) then
121: hr_utility.set_location(' Leaving:'||l_proc, 40);
122: raise;
123: end if;
124: hr_utility.set_location( ' Leaving:'||l_proc,50 );
125: End chk_user_approval_group_name;

Line 124: hr_utility.set_location( ' Leaving:'||l_proc,50 );

120: ) then
121: hr_utility.set_location(' Leaving:'||l_proc, 40);
122: raise;
123: end if;
124: hr_utility.set_location( ' Leaving:'||l_proc,50 );
125: End chk_user_approval_group_name;
126:
127:
128: -- ----------------------------------------------------------------------------

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

154: ) IS
155: --
156: l_proc varchar2(72) := g_package || 'chk_description';
157: Begin
158: hr_utility.set_location('Entering:'||l_proc,10);
159: hr_api.mandatory_arg_error(p_api_name => l_proc
160: ,p_argument => 'DESCRIPTION'
161: ,p_argument_value => p_description
162: );

Line 163: hr_utility.set_location(' Leaving:'||l_proc,30);

159: hr_api.mandatory_arg_error(p_api_name => l_proc
160: ,p_argument => 'DESCRIPTION'
161: ,p_argument_value => p_description
162: );
163: hr_utility.set_location(' Leaving:'||l_proc,30);
164: exception
165: when app_exception.application_exception then
166: if hr_multi_message.exception_add
167: (p_associated_column1 =>

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

166: if hr_multi_message.exception_add
167: (p_associated_column1 =>
168: 'AME_APPROVAL_GROUPS_TL.DESCRIPTION'
169: ) then
170: hr_utility.set_location(' Leaving:'||l_proc, 40);
171: raise;
172: end if;
173: hr_utility.set_location( ' Leaving:'||l_proc,50 );
174: End chk_description;

Line 173: hr_utility.set_location( ' Leaving:'||l_proc,50 );

169: ) then
170: hr_utility.set_location(' Leaving:'||l_proc, 40);
171: raise;
172: end if;
173: hr_utility.set_location( ' Leaving:'||l_proc,50 );
174: End chk_description;
175:
176: --
177: -- ----------------------------------------------------------------------------

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

236: --
237: l_proc varchar2(72) := g_package||'insert_validate';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: -- Call all supporting business operations
243: --
244: --

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

259: (p_user_approval_group_name => p_rec.user_approval_group_name
260: );
261: chk_description (p_description => p_rec.description);
262:
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End insert_validate;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |---------------------------< update_validate >----------------------------|

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

272: --
273: l_proc varchar2(72) := g_package||'update_validate';
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: -- Call all supporting business operations
279: --
280: --

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

295: (p_rec => p_rec
296: );
297: --
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: End update_validate;
301: --
302: -- ----------------------------------------------------------------------------
303: -- |---------------------------< delete_validate >----------------------------|

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

308: --
309: l_proc varchar2(72) := g_package||'delete_validate';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- Call all supporting business operations
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- Call all supporting business operations
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End delete_validate;
318: --
319: end ame_agl_bus;