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_PBF_BUS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

151: close csr_leg_code;
152: pay_pbf_bus.g_balance_feed_id := p_balance_feed_id;
153: pay_pbf_bus.g_legislation_code := l_legislation_code;
154: end if;
155: hr_utility.set_location(' Leaving:'|| l_proc, 40);
156: return l_legislation_code;
157: end return_legislation_code;
158: --
159: -- ----------------------------------------------------------------------------

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

192: l_argument varchar2(30);
193: --
194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc, 5);
197:
198: -- Only proceed with the validation if a row exists for the current
199: -- record in the HR Schema.
200: --

Line 212: hr_utility.set_location('Entering:'||l_proc, 6);

208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: hr_utility.set_location('Entering:'||l_proc, 6);
213:
214: if nvl(p_rec.business_group_id, hr_api.g_number) <>
215: nvl(pay_pbf_shd.g_old_rec.business_group_id, hr_api.g_number) then
216: l_argument := 'business_group_id';

Line 220: hr_utility.set_location('Entering:'||l_proc, 7);

216: l_argument := 'business_group_id';
217: raise hr_api.argument_changed;
218: end if;
219:
220: hr_utility.set_location('Entering:'||l_proc, 7);
221: if nvl(p_rec.input_value_id, hr_api.g_number) <>
222: nvl(pay_pbf_shd.g_old_rec.input_value_id, hr_api.g_number) then
223: l_argument := 'input_value_id';
224: raise hr_api.argument_changed;

Line 227: hr_utility.set_location('Entering:'||l_proc, 8);

223: l_argument := 'input_value_id';
224: raise hr_api.argument_changed;
225: end if;
226:
227: hr_utility.set_location('Entering:'||l_proc, 8);
228: if nvl(p_rec.balance_type_id, hr_api.g_number) <>
229: nvl(pay_pbf_shd.g_old_rec.balance_type_id, hr_api.g_number) then
230: l_argument := 'balance_type_id';
231: raise hr_api.argument_changed;

Line 234: hr_utility.set_location('Entering:'||l_proc, 9);

230: l_argument := 'balance_type_id';
231: raise hr_api.argument_changed;
232: end if;
233:
234: hr_utility.set_location('Entering:'||l_proc, 9);
235: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
236: nvl(pay_pbf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
237: l_argument := 'legislation_code';
238: raise hr_api.argument_changed;

Line 241: hr_utility.set_location('Entering:'||l_proc, 9);

237: l_argument := 'legislation_code';
238: raise hr_api.argument_changed;
239: end if;
240:
241: hr_utility.set_location('Entering:'||l_proc, 9);
242: if nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) <>
243: nvl(pay_pbf_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) then
244: l_argument := 'legislation_subgroup';
245: raise hr_api.argument_changed;

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

244: l_argument := 'legislation_subgroup';
245: raise hr_api.argument_changed;
246: end if;
247:
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249:
250: Exception
251: When hr_api.argument_changed Then
252: -- A non updatetable attribute has been changed therefore we

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

506: -- ( p_effective_date between date_from
507: -- and nvl(date_to, hr_api.g_eot) ) );
508: --
509: Begin
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512:
513: --
514: hr_api.mandatory_arg_error

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

536: End If;
537: Close c_chk_bg_id;
538: End If;
539: --
540: hr_utility.set_location('Leaving:'||l_proc, 10);
541: End;
542: --
543: -- ----------------------------------------------------------------------------
544: -- |------------------------< chk_legislation_code >--------------------------|

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

561: from fnd_territories
562: where territory_code = p_legislation_code;
563: --
564: Begin
565: hr_utility.set_location('Entering:'||l_proc, 5);
566: --
567: If p_legislation_code is not null then
568:
569: Open c_chk_leg_code;

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

580: Close c_chk_leg_code;
581:
582: End If;
583: --
584: hr_utility.set_location('Leaving:'||l_proc, 10);
585: End;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |------------------------< chk_input_value_id >----------------------------|

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

617: from pay_balance_feeds_f pbf
618: where pbf.input_value_id = p_input_value_id;
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623:
624: l_legislation_code := nvl(p_legislation_code
625: ,hr_api.return_legislation_code

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

658:
659: end if;
660:
661: --
662: hr_utility.set_location('Leaving:'||l_proc, 10);
663: End;
664: --
665: -- ----------------------------------------------------------------------------
666: -- |------------------------< chk_balance_type_id >-------------------------|

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

691: = nvl(p_business_group_id, hr_api.g_number);
692:
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697:
698: l_legislation_code := nvl(p_legislation_code
699: ,hr_api.return_legislation_code

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

711: --
712: End If;
713: Close csr_bal_type_id;
714: --
715: hr_utility.set_location('Leaving:'||l_proc, 10);
716: End;
717: --
718: -- ----------------------------------------------------------------------------
719: -- |-----------------< chk_bal_class_exists >---------------------------------|

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

760: l_classification_id number;
761: --
762: begin
763:
764: hr_utility.set_location('Entering:'||l_proc, 5);
765: --
766: l_allow_adjust_feed := False;
767: if hr_startup_data_api_support.return_startup_mode
768: IN ('STARTUP') then -- {startupMode

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

784: else
785: close csr_classifications_exist;
786: end if;
787: --
788: hr_utility.set_location(' Leaving:'||l_proc, 10);
789: --
790: end chk_bal_class_exists;
791: --
792: -- ---------------------------------------------------------------------------

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

841: l_balance_initialization_flag varchar2(30);
842: --
843: begin
844:
845: hr_utility.set_location('Entering:'||l_proc, 5);
846: --
847:
848: l_legislation_code := nvl(p_legislation_code
849: ,hr_api.return_legislation_code

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

858: else
859: close csr_initial_feed_exist;
860: end if;
861: --
862: hr_utility.set_location(' Leaving:'||l_proc, 10);
863: --
864: end chk_initial_feed_exists;
865: --
866: -- ---------------------------------------------------------------------------

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

906: l_ipv_uom varchar2(30);
907: --
908: begin
909:
910: hr_utility.set_location('Entering:'||l_proc, 5);
911: --
912: open csr_bal_uom;
913: fetch csr_bal_uom into l_bal_uom;
914: close csr_bal_uom;

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

921: fnd_message.set_name('PAY','HR_6553_BAL_WRONG_UOM');
922: fnd_message.raise_error;
923: end if;
924: --
925: hr_utility.set_location(' Leaving:'||l_proc, 10);
926: --
927: end chk_uom;
928: -- ---------------------------------------------------------------------------
929: -- |--------------------------< chk_currency_match >--------------------------|

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

972: l_uom varchar2(30);
973: --
974: begin
975:
976: hr_utility.set_location('Entering:'||l_proc, 5);
977: --
978: open csr_balance_uom;
979: fetch csr_balance_uom into l_uom;
980: if csr_balance_uom%found then

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

993: else
994: close csr_balance_uom;
995: end if;
996: --
997: hr_utility.set_location(' Leaving:'||l_proc, 10);
998:
999: end chk_currency_match;
1000: --
1001: -- ---------------------------------------------------------------------------

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

1030: l_exists number;
1031: --
1032: begin
1033:
1034: hr_utility.set_location('Entering:'||l_proc, 5);
1035: --
1036: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS
1037: (p_effective_date => p_effective_date
1038: ,p_lookup_type => 'ADD_SUBTRACT'

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

1057: fnd_message.set_name('PAY','PAY_33242_BIFEED_INV_SCALE');
1058: fnd_message.raise_error;
1059: end if;
1060: --
1061: hr_utility.set_location(' Leaving:'||l_proc, 10);
1062:
1063: end chk_scale_value;
1064: --
1065: -- ---------------------------------------------------------------------------

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

1103: l_exists number;
1104: --
1105: begin
1106:
1107: hr_utility.set_location('Entering:'||l_proc, 5);
1108: --
1109: open csr_bal_feed_unique;
1110: fetch csr_bal_feed_unique into l_exists;
1111: if csr_bal_feed_unique%found then

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

1115: else
1116: close csr_bal_feed_unique;
1117: end if;
1118: --
1119: hr_utility.set_location(' Leaving:'||l_proc, 10);
1120:
1121: end chk_bal_feed_unique;
1122: --
1123: --

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

1157: l_exists number;
1158: --
1159: begin
1160:
1161: hr_utility.set_location('Entering:'||l_proc, 5);
1162: --
1163: open csr_feed_ipv_value;
1164: fetch csr_feed_ipv_value into l_exists;
1165:

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

1171: else
1172: close csr_feed_ipv_value;
1173: end if;
1174: --
1175: hr_utility.set_location(' Leaving:'||l_proc, 10);
1176:
1177: end chk_feed_ipv_life;
1178: --
1179: -- ---------------------------------------------------------------------------

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

1205: l_proc varchar2(72) := g_package||'chk_dtupd_allowed';
1206: --
1207: begin
1208:
1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211:
1212: --
1213: hr_api.mandatory_arg_error

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

1229: fnd_message.raise_error;
1230:
1231: end if;
1232: --
1233: hr_utility.set_location(' Leaving:'||l_proc, 10);
1234:
1235: end chk_dtupd_allowed;
1236: --
1237: -- ---------------------------------------------------------------------------

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

1263: l_proc varchar2(72) := g_package||'chk_dtdel_allowed';
1264: --
1265: begin
1266:
1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: --
1269:
1270: --
1271: hr_api.mandatory_arg_error

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

1288: fnd_message.raise_error;
1289:
1290: end if;
1291: --
1292: hr_utility.set_location(' Leaving:'||l_proc, 10);
1293:
1294: end chk_dtdel_allowed;
1295: --
1296: -- ----------------------------------------------------------------------------

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

1309: l_proc varchar2(72) := g_package||'insert_validate';
1310: l_validation_end_date date;
1311: --
1312: Begin
1313: hr_utility.set_location('Entering:'||l_proc, 5);
1314:
1315: -- Clearing the Global variable since the record may have been changed.
1316: --
1317: g_balance_init_flag := NULL;

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

1468: ,p_input_value_id => p_rec.input_value_id
1469: ,p_effective_date => p_effective_date
1470: );
1471: --
1472: hr_utility.set_location(' Leaving:'||l_proc, 10);
1473:
1474: End insert_validate;
1475: --
1476: -- ----------------------------------------------------------------------------

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

1487: --
1488: l_proc varchar2(72) := g_package||'update_validate';
1489: --
1490: Begin
1491: hr_utility.set_location('Entering:'||l_proc, 5);
1492: --
1493:
1494: -- Clearing the Global variable since the record may have been changed.
1495: --

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

1565: ,p_validation_end_date => p_validation_end_date
1566: );
1567: --
1568: --
1569: hr_utility.set_location(' Leaving:'||l_proc, 10);
1570:
1571: End update_validate;
1572: --
1573: -- ----------------------------------------------------------------------------

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

1585: l_proc varchar2(72) := g_package||'delete_validate';
1586: l_validation_end_date date;
1587: --
1588: Begin
1589: hr_utility.set_location('Entering:'||l_proc, 5);
1590: --
1591:
1592: -- Clearing the Global variable since the record may have been changed.
1593: --

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

1663: ,p_validation_end_date => p_validation_end_date
1664: ,p_balance_feed_id => p_rec.balance_feed_id
1665: );
1666: --
1667: hr_utility.set_location(' Leaving:'||l_proc, 10);
1668:
1669: End delete_validate;
1670: --
1671: --

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

1696: l_proc varchar2(72) := g_package||'get_balance_init_flag';
1697: --
1698: Begin
1699: --
1700: hr_utility.set_location('Entering:'|| l_proc, 10);
1701: --
1702: if g_balance_init_flag is null then
1703:
1704: open csr_balance_init_flag;

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

1714:
1715: end if;
1716:
1717: --
1718: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1719: return g_balance_init_flag;
1720: --
1721: End get_balance_init_flag;
1722: --

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

1744: l_is_pay_value boolean;
1745: --
1746: Begin
1747: --
1748: hr_utility.set_location('Entering:'|| l_proc, 10);
1749: --
1750:
1751: open csr_is_pay_value;
1752: fetch csr_is_pay_value into l_exists;

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

1760: close csr_is_pay_value;
1761:
1762:
1763: --
1764: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1765: return l_is_pay_value;
1766: --
1767: End is_pay_value;
1768: end pay_pbf_bus;