DBA Data[Home] [Help]

APPS.PAY_UCI_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 := pay_uci_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: pay_uci_bus.g_user_column_instance_id := p_user_column_instance_id;
147: pay_uci_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 189: hr_utility.set_location('Entering:'|| l_proc, 10);

185: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
186: --
187: Begin
188: --
189: hr_utility.set_location('Entering:'|| l_proc, 10);
190: --
191: -- Only proceed with the validation if a row exists for the current
192: -- record in the HR Schema.
193: --

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

238: ,p_base_table => pay_uci_shd.g_tab_nam
239: );
240: end if;
241: --
242: hr_utility.set_location(' Leaving:'|| l_proc, 20);
243: --
244: End chk_non_updateable_args;
245: --
246: -- ----------------------------------------------------------------------------

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

515: l_exists varchar2(1);
516: l_proc varchar2(100) := g_package || 'chk_legislation_code';
517: begin
518: --
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520:
521: open csr_legislation_code;
522: fetch csr_legislation_code into l_exists ;
523:

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

527: fnd_message.raise_error;
528: end if;
529: close csr_legislation_code;
530:
531: hr_utility.set_location(' Leaving:'|| l_proc, 20);
532: --
533: exception
534: when app_exception.application_exception then
535: if hr_multi_message.exception_add

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

596: l_proc varchar2(100) := g_package || 'chk_user_row_id';
597: --
598: begin
599:
600: hr_utility.set_location('Entering:'|| l_proc, 10);
601: --
602: -- USER_ROW_ID is mandatory.
603: --
604: hr_api.mandatory_arg_error

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

633: fnd_message.set_token('PARENT' , 'User Row');
634: fnd_message.raise_error;
635: end if;
636:
637: hr_utility.set_location(' Leaving:'|| l_proc, 20);
638:
639: exception
640: when app_exception.application_exception then
641: if hr_multi_message.exception_add

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

695:
696: l_proc varchar2(100) := g_package || 'chk_user_column_id';
697: begin
698:
699: hr_utility.set_location('Entering:'|| l_proc, 10);
700: --
701: -- USER_COLUMN_ID is mandatory.
702: --
703: hr_api.mandatory_arg_error

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

731: fnd_message.set_token('PARENT' , 'User Column');
732: fnd_message.raise_error;
733: end if;
734:
735: hr_utility.set_location(' Leaving:'|| l_proc, 20);
736:
737: exception
738: when app_exception.application_exception then
739: if hr_multi_message.exception_add

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

816: l_exists varchar2(1);
817: --
818: begin
819:
820: hr_utility.set_location('Entering:'|| l_proc, 10);
821:
822: if hr_multi_message.no_exclusive_error
823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'

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

837:
838: close csr_row_column_id;
839:
840: end if;
841: hr_utility.set_location(' Leaving:'|| l_proc, 20);
842:
843: exception
844:
845: when app_exception.application_exception then

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

937: --
938:
939: Begin
940:
941: hr_utility.set_location(' Entering:'||l_proc, 10);
942: --
943:
944: if hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'

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

1051: fnd_message.raise_error;
1052: end if;
1053: end if;
1054: end if;
1055: hr_utility.set_location(' Leaving:'||l_proc, 50);
1056:
1057: Exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add

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

1088: --
1089: l_proc varchar2(72) := g_package||'insert_validate';
1090: --
1091: Begin
1092: hr_utility.set_location('Entering:'||l_proc, 5);
1093: --
1094: -- Call all supporting business operations
1095: --
1096: --

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

1167: ,p_object_version_number => p_rec.object_version_number
1168: ,p_effective_date => p_effective_date
1169: );
1170: END IF;
1171: hr_utility.set_location(' Leaving:'||l_proc, 10);
1172: End insert_validate;
1173: --
1174: -- ----------------------------------------------------------------------------
1175: -- |---------------------------< update_validate >----------------------------|

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

1184: --
1185: l_proc varchar2(72) := g_package||'update_validate';
1186: --
1187: Begin
1188: hr_utility.set_location('Entering:'||l_proc, 5);
1189: --
1190: -- Call all supporting business operations
1191: --
1192: --

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

1242: ,p_effective_date => p_effective_date
1243: );
1244: END IF;
1245: --
1246: hr_utility.set_location(' Leaving:'||l_proc, 10);
1247: End update_validate;
1248: --
1249: -- ----------------------------------------------------------------------------
1250: -- |---------------------------< delete_validate >----------------------------|

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

1259: --
1260: l_proc varchar2(72) := g_package||'delete_validate';
1261: --
1262: Begin
1263: hr_utility.set_location('Entering:'||l_proc, 5);
1264: --
1265: --
1266: chk_startup_action(false
1267: ,pay_uci_shd.g_old_rec.business_group_id

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

1288: ,p_validation_end_date => p_validation_end_date
1289: ,p_user_column_instance_id => p_rec.user_column_instance_id
1290: );
1291: --
1292: hr_utility.set_location(' Leaving:'||l_proc, 10);
1293: End delete_validate;
1294: --
1295: end pay_uci_bus;