DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on HR_UTILITY

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

26: l_api_updating boolean;
27: l_valid varchar2(1);
28: --
29: Begin
30: hr_utility.set_location('Entering:'||l_proc, 5);
31: open csr_get_template_info;
32: fetch csr_get_template_info
33: into p_business_group_id;
34: close csr_get_template_info;

Line 35: hr_utility.set_location(' Leaving:'||l_proc, 15);

31: open csr_get_template_info;
32: fetch csr_get_template_info
33: into p_business_group_id;
34: close csr_get_template_info;
35: hr_utility.set_location(' Leaving:'||l_proc, 15);
36: End get_template_info;
37: -- ----------------------------------------------------------------------------
38: -- |-----------------------< chk_non_updateable_args >------------------------|
39: -- ----------------------------------------------------------------------------

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

46: l_argument varchar2(30);
47: l_api_updating boolean;
48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: l_api_updating := pay_tco_shd.api_updating
52: (p_template_core_object_id => p_rec.template_core_object_id
53: ,p_object_version_number => p_rec.object_version_number
54: );

Line 56: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

52: (p_template_core_object_id => p_rec.template_core_object_id
53: ,p_object_version_number => p_rec.object_version_number
54: );
55: if not l_api_updating then
56: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '10');
59: hr_utility.raise_error;
60: end if;

Line 57: hr_utility.set_message_token('PROCEDURE', l_proc);

53: ,p_object_version_number => p_rec.object_version_number
54: );
55: if not l_api_updating then
56: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '10');
59: hr_utility.raise_error;
60: end if;
61: --

Line 58: hr_utility.set_message_token('STEP', '10');

54: );
55: if not l_api_updating then
56: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '10');
59: hr_utility.raise_error;
60: end if;
61: --
62: hr_utility.set_location(l_proc, 15);

Line 59: hr_utility.raise_error;

55: if not l_api_updating then
56: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '10');
59: hr_utility.raise_error;
60: end if;
61: --
62: hr_utility.set_location(l_proc, 15);
63: --

Line 62: hr_utility.set_location(l_proc, 15);

58: hr_utility.set_message_token('STEP', '10');
59: hr_utility.raise_error;
60: end if;
61: --
62: hr_utility.set_location(l_proc, 15);
63: --
64: -- p_template_id
65: --
66: if nvl(p_rec.template_id, hr_api.g_number) <>

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

86: then
87: l_argument := 'p_shadow_object_id';
88: raise l_error;
89: end if;
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: exception
92: when l_error then
93: hr_utility.set_location('Leaving:'||l_proc, 25);
94: hr_api.argument_changed_error

Line 93: hr_utility.set_location('Leaving:'||l_proc, 25);

89: end if;
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: exception
92: when l_error then
93: hr_utility.set_location('Leaving:'||l_proc, 25);
94: hr_api.argument_changed_error
95: (p_api_name => l_proc
96: ,p_argument => l_argument);
97: when others then

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

94: hr_api.argument_changed_error
95: (p_api_name => l_proc
96: ,p_argument => l_argument);
97: when others then
98: hr_utility.set_location('Leaving:'||l_proc, 30);
99: raise;
100: End chk_non_updateable_args;
101: -- ----------------------------------------------------------------------------
102: -- |-------------------------< chk_effective_date >---------------------------|

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

109: l_proc varchar2(72) := g_package||'chk_effective_date';
110: l_api_updating boolean;
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: l_api_updating := pay_tco_shd.api_updating
115: (p_template_core_object_id => p_template_core_object_id
116: ,p_object_version_number => p_object_version_number
117: );

Line 131: hr_utility.set_location(' Leaving:'||l_proc, 15);

127: ,p_argument => 'p_effective_date'
128: ,p_argument_value => p_effective_date
129: );
130: end if;
131: hr_utility.set_location(' Leaving:'||l_proc, 15);
132: End chk_effective_date;
133: -- ----------------------------------------------------------------------------
134: -- |---------------------------< chk_template_id >----------------------------|
135: -- ----------------------------------------------------------------------------

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

148: l_proc varchar2(72) := g_package||'chk_template_id';
149: l_valid varchar2(1);
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: -- Check that template_id is not null.
155: --
156: hr_api.mandatory_arg_error

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

163: --
164: open csr_template_id_valid;
165: fetch csr_template_id_valid into l_valid;
166: if csr_template_id_valid%notfound then
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: close csr_template_id_valid;
169: fnd_message.set_name('PAY', 'PAY_50065_BAD_USER_TEMPLATE');
170: fnd_message.raise_error;
171: end if;

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

169: fnd_message.set_name('PAY', 'PAY_50065_BAD_USER_TEMPLATE');
170: fnd_message.raise_error;
171: end if;
172: close csr_template_id_valid;
173: hr_utility.set_location(' Leaving:'||l_proc, 15);
174: End chk_template_id;
175: -- ----------------------------------------------------------------------------
176: -- |-----------------------< chk_core_object_type >---------------------------|
177: -- ----------------------------------------------------------------------------

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

182: --
183: l_proc varchar2(72) := g_package||'chk_core_object_type';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: -- Check that the core object type is not null.
189: --
190: hr_api.mandatory_arg_error

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

200: ,p_lookup_type => 'CORE_OBJECT_TYPE'
201: ,p_lookup_code => p_core_object_type
202: )
203: then
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
206: fnd_message.set_token('LOOKUP_TYPE', 'CORE_OBJECT_TYPE');
207: fnd_message.set_token('COLUMN', 'CORE_OBJECT_TYPE');
208: fnd_message.raise_error;

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

206: fnd_message.set_token('LOOKUP_TYPE', 'CORE_OBJECT_TYPE');
207: fnd_message.set_token('COLUMN', 'CORE_OBJECT_TYPE');
208: fnd_message.raise_error;
209: end if;
210: hr_utility.set_location(' Leaving:'||l_proc, 20);
211: End chk_core_object_type;
212: -- ----------------------------------------------------------------------------
213: -- |-----------------------< chk_shadow_object_id >---------------------------|
214: -- ----------------------------------------------------------------------------

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

345: l_error exception;
346: l_table varchar2(2000);
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Check that shadow_object_id is not null.
352: --
353: hr_api.mandatory_arg_error

Line 365: hr_utility.set_location(l_proc, 10);

361: --
362: open csr_comb_exists;
363: fetch csr_comb_exists into l_exists;
364: if csr_comb_exists%found then
365: hr_utility.set_location(l_proc, 10);
366: close csr_comb_exists;
367: fnd_message.set_name('PAY', 'PAY_50126_TCO_SHAD_OBJ_EXISTS');
368: fnd_message.raise_error;
369: end if;

Line 512: hr_utility.set_location(' Leaving:'||l_proc, 15);

508: close csr_sba_belongs;
509: else
510: hr_general.assert_condition(false);
511: end if;
512: hr_utility.set_location(' Leaving:'||l_proc, 15);
513: exception
514: when l_error then
515: hr_utility.set_location(' Leaving:'||l_proc, 20);
516: fnd_message.set_name('PAY', 'PAY_50127_TCO_SHAD_NOT_FOUND');

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

511: end if;
512: hr_utility.set_location(' Leaving:'||l_proc, 15);
513: exception
514: when l_error then
515: hr_utility.set_location(' Leaving:'||l_proc, 20);
516: fnd_message.set_name('PAY', 'PAY_50127_TCO_SHAD_NOT_FOUND');
517: fnd_message.set_token('TABLE', l_table);
518: fnd_message.raise_error;
519: when others then

Line 520: hr_utility.set_location(' Leaving:'||l_proc, 25);

516: fnd_message.set_name('PAY', 'PAY_50127_TCO_SHAD_NOT_FOUND');
517: fnd_message.set_token('TABLE', l_table);
518: fnd_message.raise_error;
519: when others then
520: hr_utility.set_location(' Leaving:'||l_proc, 25);
521: raise;
522: End chk_shadow_object_id;
523: -- ----------------------------------------------------------------------------
524: -- |-------------------------< chk_core_object_id >---------------------------|

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

654: l_table varchar2(2000);
655: l_api_updating boolean;
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: l_api_updating := pay_tco_shd.api_updating
660: (p_template_core_object_id => p_template_core_object_id
661: ,p_object_version_number => p_object_version_number
662: );

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

678: --
679: open csr_comb_exists;
680: fetch csr_comb_exists into l_exists;
681: if csr_comb_exists%found then
682: hr_utility.set_location(l_proc, 10);
683: close csr_comb_exists;
684: fnd_message.set_name('PAY', 'PAY_50124_TCO_CORE_OBJ_EXISTS');
685: fnd_message.raise_error;
686: end if;

Line 822: hr_utility.set_location(' Leaving:'||l_proc, 15);

818: else
819: hr_general.assert_condition(false);
820: end if;
821: end if;
822: hr_utility.set_location(' Leaving:'||l_proc, 15);
823: exception
824: when l_error then
825: hr_utility.set_location(' Leaving:'||l_proc, 20);
826: fnd_message.set_name('PAY', 'PAY_50125_TCO_CORE_NOT_FOUND');

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

821: end if;
822: hr_utility.set_location(' Leaving:'||l_proc, 15);
823: exception
824: when l_error then
825: hr_utility.set_location(' Leaving:'||l_proc, 20);
826: fnd_message.set_name('PAY', 'PAY_50125_TCO_CORE_NOT_FOUND');
827: fnd_message.set_token('TABLE', l_table);
828: fnd_message.raise_error;
829: when others then

Line 830: hr_utility.set_location(' Leaving:'||l_proc, 25);

826: fnd_message.set_name('PAY', 'PAY_50125_TCO_CORE_NOT_FOUND');
827: fnd_message.set_token('TABLE', l_table);
828: fnd_message.raise_error;
829: when others then
830: hr_utility.set_location(' Leaving:'||l_proc, 25);
831: raise;
832: End chk_core_object_id;
833: -- ----------------------------------------------------------------------------
834: -- |---------------------------< insert_validate >----------------------------|

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

838: l_proc varchar2(72) := g_package||'insert_validate';
839: l_business_group_id number;
840: --
841: Begin
842: hr_utility.set_location('Entering:'||l_proc, 5);
843: --
844: -- Call all supporting business operations
845: --
846: chk_template_id(p_template_id => p_rec.template_id);

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

874: ,p_business_group_id => l_business_group_id
875: ,p_template_core_object_id => p_rec.template_core_object_id
876: ,p_object_version_number => p_rec.object_version_number
877: );
878: hr_utility.set_location(' Leaving:'||l_proc, 10);
879: End insert_validate;
880: --
881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< update_validate >----------------------------|

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

886: l_proc varchar2(72) := g_package||'update_validate';
887: l_business_group_id number;
888: --
889: Begin
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: -- Call all supporting business operations
893: --
894: chk_non_updateable_args(p_rec);

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

911: ,p_business_group_id => l_business_group_id
912: ,p_template_core_object_id => p_rec.template_core_object_id
913: ,p_object_version_number => p_rec.object_version_number
914: );
915: hr_utility.set_location(' Leaving:'||l_proc, 10);
916: End update_validate;
917: --
918: -- ----------------------------------------------------------------------------
919: -- |---------------------------< delete_validate >----------------------------|

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

922: --
923: l_proc varchar2(72) := g_package||'delete_validate';
924: --
925: Begin
926: hr_utility.set_location('Entering:'||l_proc, 5);
927: --
928: -- Call all supporting business operations
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

926: hr_utility.set_location('Entering:'||l_proc, 5);
927: --
928: -- Call all supporting business operations
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 10);
931: End delete_validate;
932: --
933: end pay_tco_bus;