DBA Data[Home] [Help]

APPS.PQH_BRE_BUS dependencies on HR_UTILITY

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

48: l_proc varchar2(72) := g_package||'set_security_group_id';
49: --
50: begin
51: --
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Ensure that all the mandatory parameter are not null
55: --
56: hr_api.mandatory_arg_error

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

121: );
122: end if;
123: end if;
124: --
125: hr_utility.set_location(' Leaving:'|| l_proc, 20);
126: --
127: end set_security_group_id;
128: --
129: -- ---------------------------------------------------------------------------

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

157: l_proc varchar2(72) := g_package||'return_legislation_code';
158: --
159: Begin
160: --
161: hr_utility.set_location('Entering:'|| l_proc, 10);
162: --
163: -- Ensure that all the mandatory parameter are not null
164: --
165: hr_api.mandatory_arg_error

Line 179: hr_utility.set_location(l_proc, 20);

175: -- call to this function. Just return the value in the global
176: -- variable.
177: --
178: l_legislation_code := pqh_bre_bus.g_legislation_code;
179: hr_utility.set_location(l_proc, 20);
180: else
181: --
182: -- The ID is different to the last call to this function
183: -- or this is the first call to this function.

Line 196: hr_utility.set_location(l_proc,30);

192: close csr_leg_code;
193: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
194: fnd_message.raise_error;
195: end if;
196: hr_utility.set_location(l_proc,30);
197: --
198: -- Set the global variables so the values are
199: -- available for the next call to this function.
200: --

Line 205: hr_utility.set_location(' Leaving:'|| l_proc, 40);

201: close csr_leg_code;
202: pqh_bre_bus.g_reallocation_id := p_reallocation_id;
203: pqh_bre_bus.g_legislation_code := l_legislation_code;
204: end if;
205: hr_utility.set_location(' Leaving:'|| l_proc, 40);
206: return l_legislation_code;
207: end return_legislation_code;
208: --
209: -- ----------------------------------------------------------------------------

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

294: l_api_updating boolean;
295: --
296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: l_api_updating := pqh_bre_shd.api_updating
301: (p_reallocation_id => p_reallocation_id,
302: p_object_version_number => p_object_version_number);

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

322: end if;
323: --
324: end if;
325: --
326: hr_utility.set_location('Leaving:'||l_proc, 10);
327: --
328: End chk_reallocation_id;
329: --
330: -- ----------------------------------------------------------------------------

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

372: from pqh_bdgt_pool_realloctions a
373: where a.reallocation_id = p_txn_detail_id;
374: Begin
375: --
376: hr_utility.set_location('Entering:'||l_proc,5);
377: --
378: IF p_transaction_type IN ('D', 'R') THEN
379: IF p_pool_id IS NOT NULL THEN
380: l_api_updating := pqh_bre_shd.api_updating

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

441: end if;
442: END IF;
443: --
444: END IF;
445: hr_utility.set_location('Leaving:'||l_proc,10);
446: --
447: End chk_pool_id;
448: --
449: -- ----------------------------------------------------------------------------

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

458: l_proc varchar2(72) := g_package||'chk_period_amount';
459: l_api_updating boolean;
460: --
461: BEGIN
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: l_api_updating := pqh_bre_shd.api_updating
464: (p_reallocation_id => p_reallocation_id,
465: p_object_version_number => p_object_version_number);
466: --

Line 475: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_RES_NEG');

471: --
472: -- check if reserved_amt is greater than 0.
473: --
474: If p_reserved_amt < 0 then
475: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_RES_NEG');
476: hr_utility.raise_error;
477: End if;
478: If p_reallocation_amt < 0 THEN
479: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_REA_NEG');

Line 476: hr_utility.raise_error;

472: -- check if reserved_amt is greater than 0.
473: --
474: If p_reserved_amt < 0 then
475: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_RES_NEG');
476: hr_utility.raise_error;
477: End if;
478: If p_reallocation_amt < 0 THEN
479: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_REA_NEG');
480: hr_utility.raise_error;

Line 479: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_REA_NEG');

475: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_RES_NEG');
476: hr_utility.raise_error;
477: End if;
478: If p_reallocation_amt < 0 THEN
479: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_REA_NEG');
480: hr_utility.raise_error;
481: End if;
482:
483: END IF;

Line 480: hr_utility.raise_error;

476: hr_utility.raise_error;
477: End if;
478: If p_reallocation_amt < 0 THEN
479: hr_utility.set_message(8302,'PQH_BGT_REALLOC_DONOR_REA_NEG');
480: hr_utility.raise_error;
481: End if;
482:
483: END IF;
484: --

Line 487: hr_utility.set_message(8302,'PQH_BGT_DNR_PRD_AMOUNT');

483: END IF;
484: --
485: IF p_transaction_type = 'DD' THEN
486: IF NVL(p_reallocation_amt,0) <= 0 AND NVL(p_reserved_amt,0) <= 0 THEN
487: hr_utility.set_message(8302,'PQH_BGT_DNR_PRD_AMOUNT');
488: hr_utility.raise_error;
489: END IF;
490: END IF;
491: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 488: hr_utility.raise_error;

484: --
485: IF p_transaction_type = 'DD' THEN
486: IF NVL(p_reallocation_amt,0) <= 0 AND NVL(p_reserved_amt,0) <= 0 THEN
487: hr_utility.set_message(8302,'PQH_BGT_DNR_PRD_AMOUNT');
488: hr_utility.raise_error;
489: END IF;
490: END IF;
491: hr_utility.set_location('Leaving:'||l_proc, 10);
492: End chk_period_amount;

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

487: hr_utility.set_message(8302,'PQH_BGT_DNR_PRD_AMOUNT');
488: hr_utility.raise_error;
489: END IF;
490: END IF;
491: hr_utility.set_location('Leaving:'||l_proc, 10);
492: End chk_period_amount;
493: -- ----------------------------------------------------------------------------
494: -- |---------------------------< insert_validate >----------------------------|
495: -- ----------------------------------------------------------------------------

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

500: --
501: l_proc varchar2(72) := g_package||'insert_validate';
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- As this table does not have a mandatory business_group_id
507: -- column, ensure client_info is populated by calling a suitable
508: -- pqh_bre_bus.set_security_group_id procedure

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

534: --
535: -- Validate Dependent Attributes
536: --
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: End insert_validate;
540: --
541: -- ----------------------------------------------------------------------------
542: -- |---------------------------< update_validate >----------------------------|

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

548: --
549: l_proc varchar2(72) := g_package||'update_validate';
550: --
551: Begin
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --
554: -- Call all supporting business operations
555: --
556: --

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

584: ,p_rec => p_rec
585: );
586: --
587: --
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: End update_validate;
590: --
591: -- ----------------------------------------------------------------------------
592: -- |---------------------------< delete_validate >----------------------------|

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

597: --
598: l_proc varchar2(72) := g_package||'delete_validate';
599: --
600: Begin
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: -- Call all supporting business operations
604: --
605: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: -- Call all supporting business operations
604: --
605: hr_utility.set_location(' Leaving:'||l_proc, 10);
606: End delete_validate;
607: --
608: end pqh_bre_bus;