29: --
30: -- check mandatory parameters have been set
31: --
32: hr_utility.set_location(' Step:'|| l_proc, 20);
33: hr_api.mandatory_arg_error
34: (p_api_name => l_proc
35: ,p_argument => 'p_tp_measurement_type_id'
36: ,p_argument_value => p_tp_measurement_type_id
37: );
36: ,p_argument_value => p_tp_measurement_type_id
37: );
38: --
39: hr_utility.set_location(' Step:'|| l_proc, 30);
40: hr_api.mandatory_arg_error
41: (p_api_name => l_proc
42: ,p_argument => 'p_business_group_id'
43: ,p_argument_value => p_business_group_id
44: );
85: --
86: -- check mandatory parameters have been set
87: --
88: hr_utility.set_location(' Step:'|| l_proc, 20);
89: hr_api.mandatory_arg_error
90: (p_api_name => l_proc
91: ,p_argument => 'p_training_plan_id'
92: ,p_argument_value => p_training_plan_id
93: );
92: ,p_argument_value => p_training_plan_id
93: );
94: --
95: hr_utility.set_location(' Step:'|| l_proc, 30);
96: hr_api.mandatory_arg_error
97: (p_api_name => l_proc
98: ,p_argument => 'p_business_group_id'
99: ,p_argument_value => p_business_group_id
100: );
136: -- check mandatory parameters have been set
137: --
138: --
139: hr_utility.set_location(' Step:'|| l_proc, 30);
140: hr_api.mandatory_arg_error
141: (p_api_name => l_proc
142: ,p_argument => 'p_business_group_id'
143: ,p_argument_value => p_business_group_id
144: );
189: -- check mandatory parameters have been set
190: --
191: --
192: hr_utility.set_location(' Step:'|| l_proc, 30);
193: hr_api.mandatory_arg_error
194: (p_api_name => l_proc
195: ,p_argument => 'p_business_group_id'
196: ,p_argument_value => p_business_group_id
197: );
197: );
198: --
199: --
200: hr_utility.set_location(' Step:'|| l_proc, 40);
201: hr_api.mandatory_arg_error
202: (p_api_name => l_proc
203: ,p_argument => 'p_tp_measurement_type_id'
204: ,p_argument_value => p_tp_measurement_type_id
205: );
276: -- check mandatory parameters have been set
277: --
278: --
279: hr_utility.set_location(' Step:'|| l_proc, 30);
280: hr_api.mandatory_arg_error
281: (p_api_name => l_proc
282: ,p_argument => 'p_training_plan_id'
283: ,p_argument_value => p_training_plan_id
284: );
283: ,p_argument_value => p_training_plan_id
284: );
285: --
286: hr_utility.set_location(' Step:'|| l_proc, 40);
287: hr_api.mandatory_arg_error
288: (p_api_name => l_proc
289: ,p_argument => 'p_business_group_id'
290: ,p_argument_value => p_business_group_id
291: );
359: -- check mandatory parameters have been set. Currency code can
360: -- be null, so it is not mandatory.
361: --
362: hr_utility.set_location(' Step:'|| l_proc, 30);
363: hr_api.mandatory_arg_error
364: (p_api_name => l_proc
365: ,p_argument => 'p_business_group_id'
366: ,p_argument_value => p_business_group_id
367: );
366: ,p_argument_value => p_business_group_id
367: );
368: --
369: hr_utility.set_location(' Step:'|| l_proc, 40);
370: hr_api.mandatory_arg_error
371: (p_api_name => l_proc
372: ,p_argument => 'p_amount'
373: ,p_argument_value => p_amount
374: );
373: ,p_argument_value => p_amount
374: );
375: --
376: hr_utility.set_location(' Step:'|| l_proc, 40);
377: hr_api.mandatory_arg_error
378: (p_api_name => l_proc
379: ,p_argument => 'p_tp_measurement_type_id'
380: ,p_argument_value => p_tp_measurement_type_id
381: );
387: --
388: -- If this is a changing update, or a new insert, test
389: --
390: if ((l_api_updating and
391: nvl(ota_tpc_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
392: nvl(p_currency_code, hr_api.g_varchar2)
393: or
394: nvl(ota_tpc_shd.g_old_rec.amount, hr_api.g_number) <>
395: nvl(p_amount, hr_api.g_number))
388: -- If this is a changing update, or a new insert, test
389: --
390: if ((l_api_updating and
391: nvl(ota_tpc_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
392: nvl(p_currency_code, hr_api.g_varchar2)
393: or
394: nvl(ota_tpc_shd.g_old_rec.amount, hr_api.g_number) <>
395: nvl(p_amount, hr_api.g_number))
396: or (NOT l_api_updating))
390: if ((l_api_updating and
391: nvl(ota_tpc_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
392: nvl(p_currency_code, hr_api.g_varchar2)
393: or
394: nvl(ota_tpc_shd.g_old_rec.amount, hr_api.g_number) <>
395: nvl(p_amount, hr_api.g_number))
396: or (NOT l_api_updating))
397: then
398: hr_utility.set_location(' Step:'|| l_proc, 50);
391: nvl(ota_tpc_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
392: nvl(p_currency_code, hr_api.g_varchar2)
393: or
394: nvl(ota_tpc_shd.g_old_rec.amount, hr_api.g_number) <>
395: nvl(p_amount, hr_api.g_number))
396: or (NOT l_api_updating))
397: then
398: hr_utility.set_location(' Step:'|| l_proc, 50);
399: if p_currency_code is not null then
474: -- check mandatory parameters have been set
475: --
476: --
477: hr_utility.set_location(' Step:'|| l_proc, 30);
478: hr_api.mandatory_arg_error
479: (p_api_name => l_proc
480: ,p_argument => 'p_tp_measurement_type_id'
481: ,p_argument_value => p_tp_measurement_type_id
482: );
482: );
483: --
484: --
485: hr_utility.set_location(' Step:'|| l_proc, 40);
486: hr_api.mandatory_arg_error
487: (p_api_name => l_proc
488: ,p_argument => 'p_training_plan_id'
489: ,p_argument_value => p_training_plan_id
490: );