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.PAY_BLT_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pay_blt_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: pay_blt_bus.g_balance_type_id := p_balance_type_id;
154: pay_blt_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.balance_type_id is not null) and (
198: nvl(pay_blt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

290: ,p_attribute20_value => p_rec.attribute20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_df;
296: --
297: --
298: -- ----------------------------------------------------------------------------

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

308: l_proc varchar2(72) := g_package||'chk_assignment_remuneration_fg';
309:
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314:
315: if p_assignment_remuneration_flag = 'Y' then
316: pay_balance_types_pkg.chk_balance_type

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

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

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

365: ( hr_startup_data_api_support.g_startup_mode IN ('STARTUP') ))
366: and currency_flag = 'Y';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: If (p_balance_uom <> 'M' and p_currency_code is not null) then
372: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');
373: fnd_message.raise_error;

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

401: end if;
402:
403: end if;
404: --
405: hr_utility.set_location('Leaving:'||l_proc, 10);
406: End;
407: --
408: -- ----------------------------------------------------------------------------
409: -- |--------------------------< chk_balance_name >----------------------------|

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

435: and uet.creator_type = 'B'
436: and dfb.balance_type_id = p_balance_type_id;
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: pay_balance_types_pkg.chk_balance_type
442: (null,
443: p_business_group_id,

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

445: p_balance_name,
446: null,
447: null);
448: --
449: hr_utility.set_location('Entering:'||l_proc, 10);
450: --
451: if( p_balance_name <> nvl(pay_blt_shd.g_old_rec.balance_name,p_balance_name)) then
452: --
453: -- Check db items exist for this balance

Line 459: hr_utility.set_location('Entering:'||l_proc, 15);

455: open chk_db_items;
456: fetch chk_db_items into l_dbi_exists;
457: close chk_db_items;
458: --
459: hr_utility.set_location('Entering:'||l_proc, 15);
460: --
461: if l_dbi_exists is null then
462: -- if database item does not exist
463: p_balance_name_warning := 1;

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

480: --
481: end if;
482: end if;
483: --
484: hr_utility.set_location('Leaving:'||l_proc, 20);
485: End;
486: --
487: --
488: -- ----------------------------------------------------------------------------

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

524: nvl(hl.end_date_active,p_effective_date);
525:
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
531: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
532: fnd_message.raise_error;

Line 539: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);

535: ,p_object_version_number => p_object_version_number)) and
536: nvl(p_balance_uom,hr_api.g_varchar2) <>
537: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
538: --
539: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
540: --
541: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);
542: Fetch c_chk_balance_uom_class into l_class_exists;
543: If c_chk_balance_uom_class%notfound Then

Line 555: hr_utility.set_location('Entering:'||l_proc, 15);

551: Close c_chk_balance_uom_class;
552: --
553: else
554: --
555: hr_utility.set_location('Entering:'||l_proc, 15);
556: --
557: Open c_chk_balance_uom;
558: Fetch c_chk_balance_uom into l_exists;
559: If c_chk_balance_uom%notfound Then

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

566: End If;
567: Close c_chk_balance_uom;
568: End If;
569: --
570: hr_utility.set_location('Leaving:'||l_proc, 20);
571: End;
572: --
573: -- ----------------------------------------------------------------------------
574: -- |--------------------------< chk_reporting_name >----------------------------|

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

583: l_proc varchar2(72) := g_package||'chk_reporting_name';
584: l_exists varchar2(1);
585: --
586: Begin
587: hr_utility.set_location('Entering:'||l_proc, 5);
588: --
589: pay_balance_types_pkg.chk_balance_type
590: (null,
591: p_business_group_id,

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

593: null,
594: p_reporting_name,
595: null);
596: --
597: hr_utility.set_location('Leaving:'||l_proc, 10);
598: End;
599: --
600: --
601: -- ----------------------------------------------------------------------------

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

623: and p_effective_date between effective_start_date
624: and effective_end_date;
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: if (p_balance_category_id is null and
630: pay_balance_types_pkg.chk_balance_category_rule(
631: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))) then

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

635: ,p_argument_value => p_balance_category_id
636: );
637: end if;
638: --
639: hr_utility.set_location('Entering:'||l_proc, 10);
640: --
641: Open c_chk_balance_category;
642: Fetch c_chk_balance_category into l_exists;
643: If c_chk_balance_category%notfound Then

Line 653: hr_utility.set_location('Leaving:'||l_proc, 15);

649: --
650: End If;
651: Close c_chk_balance_category;
652: --
653: hr_utility.set_location('Leaving:'||l_proc, 15);
654: End;
655: --
656: --
657: -- ----------------------------------------------------------------------------

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

685: or business_group_id is null
686: and legislation_code is null) ;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: Open c_chk_base_balance;
692: Fetch c_chk_base_balance into l_exists;
693: If c_chk_base_balance%notfound Then

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

699: --
700: End If;
701: Close c_chk_base_balance;
702: --
703: hr_utility.set_location('Leaving:'||l_proc, 10);
704: End;
705: --
706: --
707: -- ----------------------------------------------------------------------------

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

726: and uom = p_balance_uom
727: and p_effective_date between effective_start_date and effective_end_date;
728: --
729: Begin
730: hr_utility.set_location('Entering:'||l_proc, 5);
731: --
732: Open c_chk_input_value;
733: Fetch c_chk_input_value into l_exists;
734: If c_chk_input_value%notfound Then

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

741: End If;
742: Close c_chk_input_value;
743: --
744: --
745: hr_utility.set_location('Entering:'||l_proc, 10);
746: --
747: --
748: -- INPUT_VALUE_ID can be updated only if its value is null and there is
749: -- no balance feed exist except initial feed or there is no balance

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

763: --
764: End if;
765:
766:
767: hr_utility.set_location('Leaving:'||l_proc, 10);
768: End;
769: --
770: --
771: -- ----------------------------------------------------------------------------

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

823: and pbf.effective_end_date;
824:
825:
826: BEGIN
827: hr_utility.set_location('Entering:'||l_proc, 5);
828: --
829: open feed_exists;
830: fetch feed_exists into l_exists;
831: if feed_exists%notfound then

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

830: fetch feed_exists into l_exists;
831: if feed_exists%notfound then
832: close feed_exists;
833: --
834: hr_utility.set_location('Entering:'||l_proc, 10);
835: --
836: hr_balances.ins_balance_feed
837: (p_option => 'INS_PRIMARY_BALANCE_FEED'
838: ,p_input_value_id => p_input_value_id

Line 856: hr_utility.set_location('Leaving:'||l_proc, 15);

852: else
853: close feed_exists;
854: end if;
855: --
856: hr_utility.set_location('Leaving:'||l_proc, 15);
857: --
858: END Insert_primary_balance_feed;
859: --
860: -- ----------------------------------------------------------------------------

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

879: from fnd_territories
880: where territory_code = p_legislation_code;
881: --
882: Begin
883: hr_utility.set_location('Entering:'||l_proc, 5);
884: --
885: If p_legislation_code is not null then
886:
887: Open c_chk_leg_code;

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

898: Close c_chk_leg_code;
899:
900: End If;
901: --
902: hr_utility.set_location('Leaving:'||l_proc, 10);
903: End;
904:
905: --
906: -- ----------------------------------------------------------------------------

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

953: fnd_message.set_token('STEP ', '5');
954: fnd_message.raise_error;
955: END IF;
956: --
957: hr_utility.set_location('Entering:'||l_proc, 10);
958: --
959: -- Ensure that the following attributes are not updated.
960: --
961: If nvl(p_rec.business_group_id,hr_api.g_number) <>

Line 969: hr_utility.set_location('Entering:'||l_proc, 15);

965: raise l_error;
966: --
967: End if;
968: --
969: hr_utility.set_location('Entering:'||l_proc, 15);
970: --
971: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
972: nvl(pay_blt_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
973: --

Line 979: hr_utility.set_location('Entering:'||l_proc, 20);

975: raise l_error;
976: --
977: End if;
978: --
979: hr_utility.set_location('Entering:'||l_proc, 20);
980: --
981: If nvl(p_rec.balance_type_id,hr_api.g_number) <>
982: nvl(pay_blt_shd.g_old_rec.balance_type_id,hr_api.g_number) then
983: --

Line 989: hr_utility.set_location('Entering:'||l_proc, 25);

985: raise l_error;
986: --
987: End if;
988: --
989: hr_utility.set_location('Entering:'||l_proc, 25);
990: -- balance category can be updated only if it is null
991: --
992: If(pay_blt_shd.g_old_rec.balance_category_id is not null and
993: nvl(p_rec.balance_category_id,hr_api.g_number) <>

Line 1001: hr_utility.set_location('Entering:'||l_proc, 30);

997: raise l_error;
998: --
999: End if;
1000: --
1001: hr_utility.set_location('Entering:'||l_proc, 30);
1002: -- jurisdiction_level can not be updated
1003: --
1004: If nvl(p_rec.jurisdiction_level,hr_api.g_number) <>
1005: nvl(pay_blt_shd.g_old_rec.jurisdiction_level,hr_api.g_number) then

Line 1012: hr_utility.set_location('Entering:'||l_proc, 35);

1008: raise l_error;
1009: --
1010: End if;
1011: --
1012: hr_utility.set_location('Entering:'||l_proc, 35);
1013: -- Tax_Type can not be updated
1014: --
1015: If nvl(p_rec.tax_type,hr_api.g_varchar2) <>
1016: nvl(pay_blt_shd.g_old_rec.tax_type,hr_api.g_varchar2) then

Line 1024: hr_utility.set_location('Entering:'||l_proc, 45);

1020: --
1021: End if;
1022: --
1023: --
1024: hr_utility.set_location('Entering:'||l_proc, 45);
1025: --
1026: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
1027: nvl(pay_blt_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
1028: --

Line 1034: hr_utility.set_location('Leaving :'||l_proc, 50);

1030: raise l_error;
1031: --
1032: End if;
1033: --
1034: hr_utility.set_location('Leaving :'||l_proc, 50);
1035: EXCEPTION
1036: WHEN l_error THEN
1037: hr_api.argument_changed_error
1038: (p_api_name => l_proc

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

1096: l_proc varchar2(72) := g_package||'insert_validate';
1097: l_balance_name_warning number;
1098: --
1099: Begin
1100: hr_utility.set_location('Entering:'||l_proc, 5);
1101: --
1102: -- Call all supporting business operations
1103: --
1104: --

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

1207: end if;
1208:
1209: pay_blt_bus.chk_df(p_rec);
1210: --
1211: hr_utility.set_location(' Leaving:'||l_proc, 10);
1212: End insert_validate;
1213: --
1214: -- ----------------------------------------------------------------------------
1215: -- |---------------------------< update_validate >----------------------------|

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

1225: l_balance_name_warning number;
1226:
1227: --
1228: Begin
1229: hr_utility.set_location('Entering:'||l_proc, 5);
1230: --
1231: -- Call all supporting business operations
1232: --
1233: --

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

1342:
1343: --
1344: pay_blt_bus.chk_df(p_rec);
1345: --
1346: hr_utility.set_location(' Leaving:'||l_proc, 10);
1347: End update_validate;
1348: --
1349: -- ----------------------------------------------------------------------------
1350: -- |---------------------------< delete_validate >----------------------------|

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

1355: --
1356: l_proc varchar2(72) := g_package||'delete_validate';
1357: --
1358: Begin
1359: hr_utility.set_location('Entering:'||l_proc, 5);
1360: --
1361: --
1362: chk_startup_action(false
1363: ,pay_blt_shd.g_old_rec.business_group_id

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

1377: END IF;
1378: --
1379: -- Call all supporting business operations
1380: --
1381: hr_utility.set_location(' Leaving:'||l_proc, 10);
1382: End delete_validate;
1383: --
1384: end pay_blt_bus;