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 754: hr_utility.set_location('Entering:'||l_proc, 5);

750: l_classification_id number;
751: --
752: begin
753:
754: hr_utility.set_location('Entering:'||l_proc, 5);
755: --
756: open csr_classifications_exist;
757: fetch csr_classifications_exist into l_classification_id;
758: if csr_classifications_exist%found then

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

762: else
763: close csr_classifications_exist;
764: end if;
765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 10);
767: --
768: end chk_bal_class_exists;
769: --
770: -- ---------------------------------------------------------------------------

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

819: l_balance_initialization_flag varchar2(30);
820: --
821: begin
822:
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825:
826: l_legislation_code := nvl(p_legislation_code
827: ,hr_api.return_legislation_code

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

836: else
837: close csr_initial_feed_exist;
838: end if;
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);
841: --
842: end chk_initial_feed_exists;
843: --
844: -- ---------------------------------------------------------------------------

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

884: l_ipv_uom varchar2(30);
885: --
886: begin
887:
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: --
890: open csr_bal_uom;
891: fetch csr_bal_uom into l_bal_uom;
892: close csr_bal_uom;

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

899: fnd_message.set_name('PAY','HR_6553_BAL_WRONG_UOM');
900: fnd_message.raise_error;
901: end if;
902: --
903: hr_utility.set_location(' Leaving:'||l_proc, 10);
904: --
905: end chk_uom;
906: -- ---------------------------------------------------------------------------
907: -- |--------------------------< chk_currency_match >--------------------------|

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

950: l_uom varchar2(30);
951: --
952: begin
953:
954: hr_utility.set_location('Entering:'||l_proc, 5);
955: --
956: open csr_balance_uom;
957: fetch csr_balance_uom into l_uom;
958: if csr_balance_uom%found then

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

971: else
972: close csr_balance_uom;
973: end if;
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 10);
976:
977: end chk_currency_match;
978: --
979: -- ---------------------------------------------------------------------------

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

1008: l_exists number;
1009: --
1010: begin
1011:
1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS
1015: (p_effective_date => p_effective_date
1016: ,p_lookup_type => 'ADD_SUBTRACT'

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

1035: fnd_message.set_name('PAY','PAY_33242_BIFEED_INV_SCALE');
1036: fnd_message.raise_error;
1037: end if;
1038: --
1039: hr_utility.set_location(' Leaving:'||l_proc, 10);
1040:
1041: end chk_scale_value;
1042: --
1043: -- ---------------------------------------------------------------------------

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

1081: l_exists number;
1082: --
1083: begin
1084:
1085: hr_utility.set_location('Entering:'||l_proc, 5);
1086: --
1087: open csr_bal_feed_unique;
1088: fetch csr_bal_feed_unique into l_exists;
1089: if csr_bal_feed_unique%found then

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

1093: else
1094: close csr_bal_feed_unique;
1095: end if;
1096: --
1097: hr_utility.set_location(' Leaving:'||l_proc, 10);
1098:
1099: end chk_bal_feed_unique;
1100: --
1101: --

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

1135: l_exists number;
1136: --
1137: begin
1138:
1139: hr_utility.set_location('Entering:'||l_proc, 5);
1140: --
1141: open csr_feed_ipv_value;
1142: fetch csr_feed_ipv_value into l_exists;
1143:

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

1149: else
1150: close csr_feed_ipv_value;
1151: end if;
1152: --
1153: hr_utility.set_location(' Leaving:'||l_proc, 10);
1154:
1155: end chk_feed_ipv_life;
1156: --
1157: -- ---------------------------------------------------------------------------

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

1183: l_proc varchar2(72) := g_package||'chk_dtupd_allowed';
1184: --
1185: begin
1186:
1187: hr_utility.set_location('Entering:'||l_proc, 5);
1188: --
1189:
1190: --
1191: hr_api.mandatory_arg_error

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

1207: fnd_message.raise_error;
1208:
1209: end if;
1210: --
1211: hr_utility.set_location(' Leaving:'||l_proc, 10);
1212:
1213: end chk_dtupd_allowed;
1214: --
1215: -- ---------------------------------------------------------------------------

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

1241: l_proc varchar2(72) := g_package||'chk_dtdel_allowed';
1242: --
1243: begin
1244:
1245: hr_utility.set_location('Entering:'||l_proc, 5);
1246: --
1247:
1248: --
1249: hr_api.mandatory_arg_error

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

1266: fnd_message.raise_error;
1267:
1268: end if;
1269: --
1270: hr_utility.set_location(' Leaving:'||l_proc, 10);
1271:
1272: end chk_dtdel_allowed;
1273: --
1274: -- ----------------------------------------------------------------------------

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

1287: l_proc varchar2(72) := g_package||'insert_validate';
1288: l_validation_end_date date;
1289: --
1290: Begin
1291: hr_utility.set_location('Entering:'||l_proc, 5);
1292:
1293: -- Clearing the Global variable since the record may have been changed.
1294: --
1295: g_balance_init_flag := NULL;

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

1430: ,p_input_value_id => p_rec.input_value_id
1431: ,p_effective_date => p_effective_date
1432: );
1433: --
1434: hr_utility.set_location(' Leaving:'||l_proc, 10);
1435:
1436: End insert_validate;
1437: --
1438: -- ----------------------------------------------------------------------------

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

1449: --
1450: l_proc varchar2(72) := g_package||'update_validate';
1451: --
1452: Begin
1453: hr_utility.set_location('Entering:'||l_proc, 5);
1454: --
1455:
1456: -- Clearing the Global variable since the record may have been changed.
1457: --

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

1526: ,p_validation_end_date => p_validation_end_date
1527: );
1528: --
1529: --
1530: hr_utility.set_location(' Leaving:'||l_proc, 10);
1531:
1532: End update_validate;
1533: --
1534: -- ----------------------------------------------------------------------------

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

1546: l_proc varchar2(72) := g_package||'delete_validate';
1547: l_validation_end_date date;
1548: --
1549: Begin
1550: hr_utility.set_location('Entering:'||l_proc, 5);
1551: --
1552:
1553: -- Clearing the Global variable since the record may have been changed.
1554: --

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

1620: ,p_validation_end_date => p_validation_end_date
1621: ,p_balance_feed_id => p_rec.balance_feed_id
1622: );
1623: --
1624: hr_utility.set_location(' Leaving:'||l_proc, 10);
1625:
1626: End delete_validate;
1627: --
1628: --

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

1653: l_proc varchar2(72) := g_package||'get_balance_init_flag';
1654: --
1655: Begin
1656: --
1657: hr_utility.set_location('Entering:'|| l_proc, 10);
1658: --
1659: if g_balance_init_flag is null then
1660:
1661: open csr_balance_init_flag;

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

1671:
1672: end if;
1673:
1674: --
1675: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1676: return g_balance_init_flag;
1677: --
1678: End get_balance_init_flag;
1679: --