[Home] [Help]
31: l_proc varchar2(72) := g_package||'set_translation_globals';
32: --
33: BEGIN
34: --
35: hr_utility.set_location('Entering:'||l_proc,5);
36: --
37: g_business_group_id := p_business_group_id;
38: g_parent_event_id := p_parent_event_id;
39:
37: g_business_group_id := p_business_group_id;
38: g_parent_event_id := p_parent_event_id;
39:
40: --
41: hr_utility.set_location('Leaving:'||l_proc,10);
42: --
43: END set_translation_globals;
44: --
45: -- ----------------------------------------------------------------------------
80:
81: --
82: BEGIN
83: --
84: hr_utility.set_location('Entering:'||l_proc,5);
85: --
86:
87: check_title_is_unique
88: ( p_event_id => p_event_id
91: , p_title => p_title
92: , p_parent_event_id => Nvl(p_parent_event_id,g_parent_event_id)
93: );
94: --
95: hr_utility.set_location('Leaving:'||l_proc,10);
96: --
97: END Validate_translation;
98: --
99:
123: and ENT.LANGUAGE = P_LANGUAGE ;
124: --
125: begin
126: --
127: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
128: --
129: -- Check arguments
130: --
131: HR_API.MANDATORY_ARG_ERROR (
144: into L_DUMMY;
145: W_TITLE_IS_UNIQUE := C1%notfound;
146: close C1;
147: --
148: HR_UTILITY.SET_LOCATION (W_PROC, 10);
149: return W_TITLE_IS_UNIQUE;
150: --
151: end UNIQUE_EVENT_TITLE;
152: --
171: := G_PACKAGE || 'CHECK_TITLE_IS_UNIQUE';
172: --
173: begin
174: --
175: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
176: --
177: -- Do not perform the uniqueness check unless inserting, or updating
178: -- with a value different from the current value (and not just changing
179: -- case)
194: end if;
195: --
196: -- end if;
197: --
198: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
199: --
200: end CHECK_TITLE_IS_UNIQUE;
201: --
202: -- ----------------------------------------------------------------------------
224: l_parent_event_id ota_events.parent_event_id%TYPE;
225: --
226: Begin
227: --
228: hr_utility.set_location('Entering:'||l_proc,5);
229: --
230: open csr_event;
231: --
232: fetch csr_event into l_parent_event_id,l_business_group_id;
240: ,p_language => p_rec.language
241: ,p_title => p_rec.title );
242:
243: --
244: hr_utility.set_location('Leaving:'||l_proc,10);
245: --
246: End check_title;
247: --
248: --
274: l_legislation_code varchar2(150);
275: --
276: begin
277: --
278: hr_utility.set_location('Entering:'|| l_proc, 10);
279: --
280: -- Ensure that all the mandatory parameter are not null
281: --
282: hr_api.mandatory_arg_error
315: --
316: hr_api.set_legislation_context(l_legislation_code);
317: end if;
318: --
319: hr_utility.set_location(' Leaving:'|| l_proc, 20);
320: --
321: end set_security_group_id;
322: --
323: -- ---------------------------------------------------------------------------
349: l_proc varchar2(72) := g_package||'return_legislation_code';
350: --
351: Begin
352: --
353: hr_utility.set_location('Entering:'|| l_proc, 10);
354: --
355: -- Ensure that all the mandatory parameter are not null
356: --
357: hr_api.mandatory_arg_error
370: -- call to this function. Just return the value in the global
371: -- variable.
372: --
373: l_legislation_code := ota_ent_bus.g_legislation_code;
374: hr_utility.set_location(l_proc, 20);
375: else
376: --
377: -- The ID is different to the last call to this function
378: -- or this is the first call to this function.
387: close csr_leg_code;
388: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
389: fnd_message.raise_error;
390: end if;
391: hr_utility.set_location(l_proc,30);
392: --
393: -- Set the global variables so the values are
394: -- available for the next call to this function.
395: --
397: ota_ent_bus.g_event_id := p_event_id;
398: ota_ent_bus.g_language := p_language;
399: ota_ent_bus.g_legislation_code := l_legislation_code;
400: end if;
401: hr_utility.set_location(' Leaving:'|| l_proc, 40);
402: return l_legislation_code;
403: end return_legislation_code;
404: --
405: -- ----------------------------------------------------------------------------
465: --
466: l_proc varchar2(72) := g_package||'insert_validate';
467: --
468: Begin
469: hr_utility.set_location('Entering:'||l_proc, 5);
470: --
471: -- Call all supporting business operations
472: --
473: --
479: P_EVENT_ID => Nvl(p_rec.event_id,p_event_id)
480: );
481: --
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 10);
484: End insert_validate;
485: --
486: -- ----------------------------------------------------------------------------
487: -- |---------------------------< update_validate >----------------------------|
493: --
494: l_proc varchar2(72) := g_package||'update_validate';
495: --
496: Begin
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: -- Call all supporting business operations
500: --
501: --
508: ,p_rec => p_rec
509: );
510: --
511: --
512: hr_utility.set_location(' Leaving:'||l_proc, 10);
513: End update_validate;
514: --
515: -- ----------------------------------------------------------------------------
516: -- |---------------------------< delete_validate >----------------------------|
521: --
522: l_proc varchar2(72) := g_package||'delete_validate';
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: -- Call all supporting business operations
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: -- Call all supporting business operations
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
530: End delete_validate;
531: --
532:
533: --