eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BPL_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 := pqh_bpl_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: pqh_bpl_bus.g_pool_id := p_pool_id;
147: pqh_bpl_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 237: hr_utility.set_location('Entering:'||l_proc, 5);

233: l_api_updating boolean;
234: --
235: Begin
236: --
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: l_api_updating := pqh_bpl_shd.api_updating
240: (p_pool_id => p_pool_id,
241: p_object_version_number => p_object_version_number);

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

261: end if;
262: --
263: end if;
264: --
265: hr_utility.set_location('Leaving:'||l_proc, 10);
266: --
267: End chk_pool_id;
268: --
269: --

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

310: where bvr.budget_version_id = p_budget_version_id);
311: --
312: Begin
313: --
314: hr_utility.set_location('Entering:'||l_proc,5);
315: --
316: l_api_updating := pqh_bpl_shd.api_updating
317: (p_pool_id => p_pool_id,
318: p_object_version_number => p_object_version_number);

Line 354: hr_utility.set_message(8302,'PQH_NOT_A_POSITION_BUDGET');

350: If l_budgeted_entity_cd <> 'POSITION' then
351: --
352: -- raise error as budgeted entity is not a position
353: --
354: hr_utility.set_message(8302,'PQH_NOT_A_POSITION_BUDGET');
355: hr_utility.raise_error;
356: --
357: End if;
358: --

Line 355: hr_utility.raise_error;

351: --
352: -- raise error as budgeted entity is not a position
353: --
354: hr_utility.set_message(8302,'PQH_NOT_A_POSITION_BUDGET');
355: hr_utility.raise_error;
356: --
357: End if;
358: --
359: kgowripe */

Line 367: hr_utility.set_message(8302,'PQH_OPEN_BUDGET');

363: If l_budgeted_entity_cd = 'OPEN' then
364: --
365: -- raise error as budgeted entity is OPEN
366: --
367: hr_utility.set_message(8302,'PQH_OPEN_BUDGET');
368: hr_utility.raise_error;
369: --
370: End if;
371: --

Line 368: hr_utility.raise_error;

364: --
365: -- raise error as budgeted entity is OPEN
366: --
367: hr_utility.set_message(8302,'PQH_OPEN_BUDGET');
368: hr_utility.raise_error;
369: --
370: End if;
371: --
372: end if;

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

370: End if;
371: --
372: end if;
373: --
374: hr_utility.set_location('Leaving:'||l_proc,10);
375: --
376: End chk_budget_version_id;
377: --
378: -- ----------------------------------------------------------------------------

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

431: bgt.budget_unit2_id = p_budget_unit_id or
432: bgt.budget_unit3_id = p_budget_unit_id );
433: Begin
434: --
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: l_api_updating := pqh_bpl_shd.api_updating
438: (p_pool_id => p_pool_id,
439: p_object_version_number => p_object_version_number);

Line 455: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_UOM');

451: --
452: If c1%notfound then
453: --
454: Close c1;
455: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_UOM');
456: hr_utility.raise_error;
457: --
458: End if;
459: --

Line 456: hr_utility.raise_error;

452: If c1%notfound then
453: --
454: Close c1;
455: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_UOM');
456: hr_utility.raise_error;
457: --
458: End if;
459: --
460: Close c1;

Line 472: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_UNIT');

468: --
469: -- Raise error if the budget unit cd does not exist for the budget
470: --
471: Close c2;
472: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_UNIT');
473: hr_utility.raise_error;
474: --
475: End if;
476: --

Line 473: hr_utility.raise_error;

469: -- Raise error if the budget unit cd does not exist for the budget
470: --
471: Close c2;
472: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_UNIT');
473: hr_utility.raise_error;
474: --
475: End if;
476: --
477: Close c2;

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

477: Close c2;
478: --
479: end if;
480: --
481: hr_utility.set_location('Leaving:'||l_proc,10);
482: --
483: end chk_budget_unit_id;
484: --
485: -- ADDITIONAL CHECKS

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

504: from pqh_bdgt_pool_realloctions a
505: Where a.pool_id = p_pool_id;
506: Begin
507: --
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: l_api_updating := pqh_bpl_shd.api_updating
511: (p_pool_id => p_pool_id,
512: p_object_version_number => p_object_version_number);

Line 521: hr_utility.set_message(8302,'PQH_TRNX_EXIST_IN_FOLDER');

517: Open csr_folder_trnxs;
518: Fetch csr_folder_trnxs into l_dummy;
519: if csr_folder_trnxs%found then
520: Close csr_folder_trnxs;
521: hr_utility.set_message(8302,'PQH_TRNX_EXIST_IN_FOLDER');
522: hr_utility.raise_error;
523: End if;
524: Close csr_folder_trnxs;
525: else

Line 522: hr_utility.raise_error;

518: Fetch csr_folder_trnxs into l_dummy;
519: if csr_folder_trnxs%found then
520: Close csr_folder_trnxs;
521: hr_utility.set_message(8302,'PQH_TRNX_EXIST_IN_FOLDER');
522: hr_utility.raise_error;
523: End if;
524: Close csr_folder_trnxs;
525: else
526: Open csr_trnx_dtls;

Line 530: hr_utility.set_message(8302,'PQH_DTLS_EXIST_FOR_TRNX');

526: Open csr_trnx_dtls;
527: Fetch csr_trnx_dtls into l_dummy;
528: if csr_trnx_dtls%found then
529: Close csr_trnx_dtls;
530: hr_utility.set_message(8302,'PQH_DTLS_EXIST_FOR_TRNX');
531: hr_utility.raise_error;
532: End if;
533: Close csr_trnx_dtls;
534: end if;

Line 531: hr_utility.raise_error;

527: Fetch csr_trnx_dtls into l_dummy;
528: if csr_trnx_dtls%found then
529: Close csr_trnx_dtls;
530: hr_utility.set_message(8302,'PQH_DTLS_EXIST_FOR_TRNX');
531: hr_utility.raise_error;
532: End if;
533: Close csr_trnx_dtls;
534: end if;
535: --

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

534: end if;
535: --
536: end if;
537: --
538: hr_utility.set_location('Leaving:'||l_proc, 10);
539: --
540: End chk_upd_allowed;
541: --
542: -- Check if folder_name is unique in pqh_budget_pools_table

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

568: AND (p_pool_id IS NULL or a.pool_id <> p_pool_id);
569: --
570: Begin
571: --
572: hr_utility.set_location('Entering:'||l_proc, 5);
573: --
574: l_api_updating := pqh_bpl_shd.api_updating
575: (p_pool_id => p_pool_id,
576: p_object_version_number => p_object_version_number);

Line 585: hr_utility.set_message(8302,'PQH_FOLDER_NAME_IS_NULL');

581: or not l_api_updating) then
582:
583: If p_name IS NULL then
584: If p_parent_pool_id IS NULL Then
585: hr_utility.set_message(8302,'PQH_FOLDER_NAME_IS_NULL');
586: Else
587: hr_utility.set_message(8302,'PQH_TRNX_NAME_IS_NULL');
588: End If;
589: hr_utility.raise_error;

Line 587: hr_utility.set_message(8302,'PQH_TRNX_NAME_IS_NULL');

583: If p_name IS NULL then
584: If p_parent_pool_id IS NULL Then
585: hr_utility.set_message(8302,'PQH_FOLDER_NAME_IS_NULL');
586: Else
587: hr_utility.set_message(8302,'PQH_TRNX_NAME_IS_NULL');
588: End If;
589: hr_utility.raise_error;
590: End if;
591: --

Line 589: hr_utility.raise_error;

585: hr_utility.set_message(8302,'PQH_FOLDER_NAME_IS_NULL');
586: Else
587: hr_utility.set_message(8302,'PQH_TRNX_NAME_IS_NULL');
588: End If;
589: hr_utility.raise_error;
590: End if;
591: --
592: --
593: If p_parent_pool_id IS NULL Then

Line 598: hr_utility.set_message(8302,'PQH_FOLDER_NAME_MUST_BE_UNIQUE');

594: Open csr_folder_name;
595: Fetch csr_folder_name into l_dummy;
596: if csr_folder_name%found then
597: Close csr_folder_name;
598: hr_utility.set_message(8302,'PQH_FOLDER_NAME_MUST_BE_UNIQUE');
599: hr_utility.raise_error;
600: End if;
601: Close csr_folder_name;
602: ELSE

Line 599: hr_utility.raise_error;

595: Fetch csr_folder_name into l_dummy;
596: if csr_folder_name%found then
597: Close csr_folder_name;
598: hr_utility.set_message(8302,'PQH_FOLDER_NAME_MUST_BE_UNIQUE');
599: hr_utility.raise_error;
600: End if;
601: Close csr_folder_name;
602: ELSE
603: Open csr_trnx_name;

Line 607: hr_utility.set_message(8302,'PQH_TRNX_NAME_MUST_BE_UNIQUE');

603: Open csr_trnx_name;
604: Fetch csr_trnx_name into l_dummy;
605: if csr_trnx_name%found then
606: Close csr_trnx_name;
607: hr_utility.set_message(8302,'PQH_TRNX_NAME_MUST_BE_UNIQUE');
608: hr_utility.raise_error;
609: End if;
610: Close csr_trnx_name;
611: End If;

Line 608: hr_utility.raise_error;

604: Fetch csr_trnx_name into l_dummy;
605: if csr_trnx_name%found then
606: Close csr_trnx_name;
607: hr_utility.set_message(8302,'PQH_TRNX_NAME_MUST_BE_UNIQUE');
608: hr_utility.raise_error;
609: End if;
610: Close csr_trnx_name;
611: End If;
612: --

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

611: End If;
612: --
613: end if;
614: --
615: hr_utility.set_location('Leaving:'||l_proc, 10);
616: --
617: End chk_pool_name;
618: /* No longer required as there cane be any number of folders created from a budget
619: --

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

637: AND (p_pool_id IS NULL or a.pool_id <> p_pool_id);
638: --
639: Begin
640: --
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: l_api_updating := pqh_bpl_shd.api_updating
644: (p_pool_id => p_pool_id,
645: p_object_version_number => p_object_version_number);

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

667: --
668: --
669: end if;
670: --
671: hr_utility.set_location('Leaving:'||l_proc, 10);
672: --
673: End chk_budget_pool_unique;
674:
675: */

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

681: WHERE transaction_category_id = p_transaction_category_id;
682: l_exist Varchar2(10);
683: l_proc varchar2(72) := g_package||'chk_tnx_category_id';
684: BEGIN
685: hr_utility.set_location('Entering:'||l_proc, 5);
686: OPEN csr_tnx_catg_id;
687: FETCH csr_tnx_catg_id INTO l_exist;
688: IF csr_tnx_catg_id%NOTFOUND THEN
689: CLOSE csr_tnx_catg_id;

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

690: fnd_message.set_name(8302,'PQH_INVALID_TNX_CATG');
691: fnd_message.raise_error;
692: END IF;
693: CLOSE csr_tnx_catg_id;
694: hr_utility.set_location('Leaving:'||l_proc, 10);
695: END chk_tnx_category_id;
696: -- ----------------------------------------------------------------------------
697: -- |---------------------------< insert_validate >----------------------------|
698: -- ----------------------------------------------------------------------------

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

703: --
704: l_proc varchar2(72) := g_package||'insert_validate';
705: --
706: Begin
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- Call all supporting business operations
710: --
711: hr_api.validate_bus_grp_id

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

749: --
750: -- Validate Dependent Attributes
751: --
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 10);
754: End insert_validate;
755: --
756: -- ----------------------------------------------------------------------------
757: -- |---------------------------< update_validate >----------------------------|

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

763: --
764: l_proc varchar2(72) := g_package||'update_validate';
765: --
766: Begin
767: hr_utility.set_location('Entering:'||l_proc, 5);
768: --
769: -- Call all supporting business operations
770: --
771: hr_api.validate_bus_grp_id

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

820: ,p_rec => p_rec
821: );
822: --
823: --
824: hr_utility.set_location(' Leaving:'||l_proc, 10);
825: End update_validate;
826: --
827: -- ----------------------------------------------------------------------------
828: -- |---------------------------< delete_validate >----------------------------|

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

833: --
834: l_proc varchar2(72) := g_package||'delete_validate';
835: --
836: Begin
837: hr_utility.set_location('Entering:'||l_proc, 5);
838: --
839: -- Call all supporting business operations
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

837: hr_utility.set_location('Entering:'||l_proc, 5);
838: --
839: -- Call all supporting business operations
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 10);
842: End delete_validate;
843: --
844: end pqh_bpl_bus;