DBA Data[Home] [Help]

APPS.AME_ACA_BUS dependencies on HR_UTILITY

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

43: l_proc varchar2(72) := g_package || 'CHK_FND_APPLICATION_ID';
44: l_key varchar2(1);
45: --
46: Begin
47: hr_utility.set_location('Entering:'||l_proc,10);
48: hr_api.mandatory_arg_error(p_api_name => l_proc
49: ,p_argument => 'FND_APPLICATION_ID'
50: ,p_argument_value => p_fnd_application_id
51: );

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

57: fnd_message.raise_error;
58: else
59: close csr_fnd_application_id;
60: end if;
61: hr_utility.set_location(' Leaving:'||l_proc,30);
62: exception
63: when app_exception.application_exception then
64: if hr_multi_message.exception_add
65: (p_associated_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID'

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

63: when app_exception.application_exception then
64: if hr_multi_message.exception_add
65: (p_associated_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID'
66: ) then
67: hr_utility.set_location(' Leaving:'||l_proc, 40);
68: raise;
69: end if;
70: hr_utility.set_location(' Leaving:'||l_proc,50);
71: End chk_fnd_application_id;

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

66: ) then
67: hr_utility.set_location(' Leaving:'||l_proc, 40);
68: raise;
69: end if;
70: hr_utility.set_location(' Leaving:'||l_proc,50);
71: End chk_fnd_application_id;
72: --
73: -- ----------------------------------------------------------------------------
74: -- |------------------------< CHK_APPLICATION_NAME >--------------------------|

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

112: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_NAME';
113: l_key varchar2(1);
114: --
115: Begin
116: hr_utility.set_location('Entering:'||l_proc,10);
117: hr_api.mandatory_arg_error(p_api_name => l_proc
118: ,p_argument => 'APPLICATION_NAME'
119: ,p_argument_value => p_application_name
120: );

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

125: fnd_message.set_name('AME', 'AME_400748_TTY_NAME_IN_USE');
126: fnd_message.raise_error;
127: end if;
128: close csr_application_name;
129: hr_utility.set_location(' Leaving:'||l_proc,30);
130: exception
131: when app_exception.application_exception then
132: if hr_multi_message.exception_add
133: (p_associated_column1 => 'AME_CALLING_APPS.APPLICATION_NAME'

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

131: when app_exception.application_exception then
132: if hr_multi_message.exception_add
133: (p_associated_column1 => 'AME_CALLING_APPS.APPLICATION_NAME'
134: ) then
135: hr_utility.set_location(' Leaving:'||l_proc, 40);
136: raise;
137: end if;
138: hr_utility.set_location(' Leaving:'||l_proc,50);
139: End chk_application_name;

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

134: ) then
135: hr_utility.set_location(' Leaving:'||l_proc, 40);
136: raise;
137: end if;
138: hr_utility.set_location(' Leaving:'||l_proc,50);
139: End chk_application_name;
140: --
141: -- ----------------------------------------------------------------------------
142: -- |----------------------< CHK_FND_APP_ID_TX_TYPE_ID >-----------------------|

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

183: l_proc varchar2(72) := g_package || 'CHK_FND_APP_ID_TX_TYPE_ID';
184: l_key varchar2(1);
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc,10);
188: if hr_multi_message.no_all_inclusive_error
189: (p_check_column1 => 'AME_CALLING_APPS.FND_APPLICATION_ID') then
190: open csr_fnd_app_tx_type;
191: fetch csr_fnd_app_tx_type into l_key;

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

195: fnd_message.raise_error;
196: end if;
197: close csr_fnd_app_tx_type;
198: end if;
199: hr_utility.set_location(' Leaving:'||l_proc,30);
200: exception
201: when app_exception.application_exception then
202: if hr_multi_message.exception_add
203: (p_associated_column1 => 'AME_CALLING_APPS.FND_APP_TX_TYP_ID'

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

201: when app_exception.application_exception then
202: if hr_multi_message.exception_add
203: (p_associated_column1 => 'AME_CALLING_APPS.FND_APP_TX_TYP_ID'
204: ) then
205: hr_utility.set_location(' Leaving:'||l_proc, 40);
206: raise;
207: end if;
208: hr_utility.set_location(' Leaving:'||l_proc,50);
209: End chk_fnd_app_id_tx_type_id;

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

204: ) then
205: hr_utility.set_location(' Leaving:'||l_proc, 40);
206: raise;
207: end if;
208: hr_utility.set_location(' Leaving:'||l_proc,50);
209: End chk_fnd_app_id_tx_type_id;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |------------------------< chk_is_tty_id_null >--------------------------|

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

235: -- ----------------------------------------------------------------------------
236: procedure chk_is_tty_id_null(p_transaction_type_id in varchar2) is
237: l_proc varchar2(72) := g_package || 'CHK_IS_TTY_ID_NULL';
238: begin
239: hr_utility.set_location('Entering:'||l_proc,10);
240: if p_transaction_type_id is null then
241: fnd_message.set_name('PER', 'AME_400780_NULL_TTY_ID');
242: fnd_message.raise_error;
243: end if;

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

285: l_proc varchar2(72) := g_package || 'CHK_DELETE';
286: l_key number;
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc,10);
290: open csr_isSeeded;
291: fetch csr_isSeeded into l_key;
292: if(csr_isSeeded%notfound) then
293: close csr_isSeeded;

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

295: fnd_message.raise_error;
296: else
297: close csr_isSeeded;
298: end if;
299: hr_utility.set_location(' Leaving:'||l_proc,30);
300: exception
301: when app_exception.application_exception then
302: if hr_multi_message.exception_add
303: (p_associated_column1 => 'AME_CALLING_APPS.DELETE'

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

301: when app_exception.application_exception then
302: if hr_multi_message.exception_add
303: (p_associated_column1 => 'AME_CALLING_APPS.DELETE'
304: ) then
305: hr_utility.set_location(' Leaving:'||l_proc, 40);
306: raise;
307: end if;
308: hr_utility.set_location(' Leaving:'||l_proc,50);
309: End chk_delete;

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

304: ) then
305: hr_utility.set_location(' Leaving:'||l_proc, 40);
306: raise;
307: end if;
308: hr_utility.set_location(' Leaving:'||l_proc,50);
309: End chk_delete;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |-----------------------< chk_non_updateable_args >------------------------|

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

582: --
583: l_proc varchar2(72) := g_package||'insert_validate';
584: --
585: Begin
586: hr_utility.set_location('Entering:'||l_proc, 5);
587: --
588: -- Validate Dependent Attributes
589: --
590: chk_is_tty_id_null

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

602: (p_fnd_application_id => p_rec.fnd_application_id
603: ,p_transaction_type_id => p_rec.transaction_type_id
604: );
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 10);
607: End insert_validate;
608: --
609: -- ----------------------------------------------------------------------------
610: -- |---------------------------< update_validate >----------------------------|

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

619: --
620: l_proc varchar2(72) := g_package||'update_validate';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: --
625: -- Validate Dependent Attributes
626: --
627: -- Call the datetrack update integrity operation

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

645: ,p_effective_date => p_effective_date
646: );
647: end if;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End update_validate;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< delete_validate >----------------------------|

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

662: --
663: l_proc varchar2(72) := g_package||'delete_validate';
664: --
665: Begin
666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --
668: -- Call all supporting business operations
669: --
670: dt_delete_validate

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

678: (p_application_id => p_rec.application_id
679: ,p_effective_date => p_effective_date
680: );
681: --
682: hr_utility.set_location(' Leaving:'||l_proc, 10);
683: End delete_validate;
684: --
685: end ame_aca_bus;