[Home] [Help]
28: l_proc varchar2(72) := g_package||'set_translation_globals';
29: --
30: BEGIN
31: --
32: hr_utility.set_location('Entering:'||l_proc,5);
33: --
34: g_business_group_id := p_business_group_id;
35: --
36: hr_utility.set_location('Leaving:'||l_proc,10);
32: hr_utility.set_location('Entering:'||l_proc,5);
33: --
34: g_business_group_id := p_business_group_id;
35: --
36: hr_utility.set_location('Leaving:'||l_proc,10);
37: --
38: END set_translation_globals;
39: --
40: -- ----------------------------------------------------------------------------
67:
68:
69: begin
70: --
71: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
72: --
73: open CSR_UNIQUE;
74: fetch CSR_UNIQUE
75: into V_UNIQUE;
82: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
83: fnd_message.raise_error;
84: end if;
85: --
86: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
87: --
88: end CHECK_UNIQUE_NAME;
89: --
90: -- ----------------------------------------------------------------------------
110: l_business_group_id ota_booking_status_types.business_group_id%TYPE;
111: --
112: Begin
113: --
114: hr_utility.set_location('Entering:'||l_proc,5);
115: --
116: open csr_bstbsg ;
117: --
118: fetch csr_bstbsg into l_business_group_id;
125: ,p_language => p_rec.language
126: ,p_name => p_rec.name );
127:
128: --
129: hr_utility.set_location('Leaving:'||l_proc,10);
130: --
131: End check_unique_name;
132: --
133: --
169:
170: --
171: BEGIN
172: --
173: hr_utility.set_location('Entering:'||l_proc,5);
174: --
175:
176: check_unique_name
177: ( p_booking_status_type_id => p_booking_status_type_id
179: , p_language => p_language
180: , p_name => p_name
181: );
182: --
183: hr_utility.set_location('Leaving:'||l_proc,10);
184: --
185: END Validate_translation;
186: --
187: -- ---------------------------------------------------------------------------
210: l_legislation_code varchar2(150);
211: --
212: begin
213: --
214: hr_utility.set_location('Entering:'|| l_proc, 10);
215: --
216: -- Ensure that all the mandatory parameter are not null
217: --
218: hr_api.mandatory_arg_error
251: --
252: hr_api.set_legislation_context(l_legislation_code);
253: end if;
254: --
255: hr_utility.set_location(' Leaving:'|| l_proc, 20);
256: --
257: end set_security_group_id;
258: --
259: -- ---------------------------------------------------------------------------
284: l_proc varchar2(72) := g_package||'return_legislation_code';
285: --
286: Begin
287: --
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Ensure that all the mandatory parameter are not null
291: --
292: hr_api.mandatory_arg_error
305: -- call to this function. Just return the value in the global
306: -- variable.
307: --
308: l_legislation_code := ota_bsl_bus.g_legislation_code;
309: hr_utility.set_location(l_proc, 20);
310: else
311: --
312: -- The ID is different to the last call to this function
313: -- or this is the first call to this function.
322: close csr_leg_code;
323: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
324: fnd_message.raise_error;
325: end if;
326: hr_utility.set_location(l_proc,30);
327: --
328: -- Set the global variables so the values are
329: -- available for the next call to this function.
330: --
332: ota_bsl_bus.g_booking_status_type_id := p_booking_status_type_id;
333: ota_bsl_bus.g_language := p_language;
334: ota_bsl_bus.g_legislation_code := l_legislation_code;
335: end if;
336: hr_utility.set_location(' Leaving:'|| l_proc, 40);
337: return l_legislation_code;
338: end return_legislation_code;
339: --
340: -- ----------------------------------------------------------------------------
400: --
401: l_proc varchar2(72) := g_package||'insert_validate';
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Call all supporting business operations
407: --
408: --
412: -- Validate Dependent Attributes
413: check_unique_name(p_rec,p_booking_status_type_id);
414: --
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: End insert_validate;
418: --
419: -- ----------------------------------------------------------------------------
420: -- |---------------------------< update_validate >----------------------------|
426: --
427: l_proc varchar2(72) := g_package||'update_validate';
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Call all supporting business operations
433: --
434: ota_bsl_bus.set_security_group_id(p_rec.booking_status_type_id) ;
441: ,p_rec => p_rec
442: );
443: --
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);
446: End update_validate;
447: --
448: -- ----------------------------------------------------------------------------
449: -- |---------------------------< delete_validate >----------------------------|
454: --
455: l_proc varchar2(72) := g_package||'delete_validate';
456: --
457: Begin
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: -- Call all supporting business operations
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: -- Call all supporting business operations
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: End delete_validate;
464: --
465: --
466: end ota_bsl_bus;