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_API

Line 46: hr_api.mandatory_arg_error

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
47: (p_api_name => l_proc
48: ,p_argument => 'balance_feed_id'
49: ,p_argument_value => p_balance_feed_id
50: );

Line 72: hr_api.set_security_group_id

68: close csr_sec_grp;
69: --
70: -- Set the security_group_id in CLIENT_INFO
71: --
72: hr_api.set_security_group_id
73: (p_security_group_id => l_security_group_id
74: );
75:
76: -- Set the sessions legislation context in HR_SESSION_DATA

Line 78: hr_api.set_legislation_context(l_legislation_code);

74: );
75:
76: -- Set the sessions legislation context in HR_SESSION_DATA
77: --
78: hr_api.set_legislation_context(l_legislation_code);
79:
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 115: hr_api.mandatory_arg_error

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
116: (p_api_name => l_proc
117: ,p_argument => 'balance_feed_id'
118: ,p_argument_value => p_balance_feed_id
119: );

Line 121: if ( nvl(pay_pbf_bus.g_balance_feed_id, hr_api.g_number)

117: ,p_argument => 'balance_feed_id'
118: ,p_argument_value => p_balance_feed_id
119: );
120: --
121: if ( nvl(pay_pbf_bus.g_balance_feed_id, hr_api.g_number)
122: = p_balance_feed_id) then
123: --
124: -- The legislation code has already been found with a previous
125: -- call to this function. Just return the value in the global

Line 214: if nvl(p_rec.business_group_id, hr_api.g_number) <>

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';
217: raise hr_api.argument_changed;
218: end if;

Line 215: nvl(pay_pbf_shd.g_old_rec.business_group_id, hr_api.g_number) then

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';
217: raise hr_api.argument_changed;
218: end if;
219:

Line 217: raise hr_api.argument_changed;

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';
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) <>

Line 221: if nvl(p_rec.input_value_id, hr_api.g_number) <>

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;
225: end if;

Line 222: nvl(pay_pbf_shd.g_old_rec.input_value_id, hr_api.g_number) then

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;
225: end if;
226:

Line 224: raise hr_api.argument_changed;

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;
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) <>

Line 228: if nvl(p_rec.balance_type_id, hr_api.g_number) <>

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;
232: end if;

Line 229: nvl(pay_pbf_shd.g_old_rec.balance_type_id, hr_api.g_number) then

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;
232: end if;
233:

Line 231: raise hr_api.argument_changed;

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;
232: end if;
233:
234: hr_utility.set_location('Entering:'||l_proc, 9);
235: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

Line 235: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

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;
239: end if;

Line 236: nvl(pay_pbf_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

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;
239: end if;
240:

Line 238: raise hr_api.argument_changed;

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;
239: end if;
240:
241: hr_utility.set_location('Entering:'||l_proc, 9);
242: if nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) <>

Line 242: if nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) <>

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;
246: end if;

Line 243: nvl(pay_pbf_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) then

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;
246: end if;
247:

Line 245: raise hr_api.argument_changed;

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;
246: end if;
247:
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249:

Line 251: When hr_api.argument_changed Then

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
253: -- must report this error
254: hr_api.argument_changed_error
255: (p_api_name => l_proc

Line 254: hr_api.argument_changed_error

250: Exception
251: When hr_api.argument_changed Then
252: -- A non updatetable attribute has been changed therefore we
253: -- must report this error
254: hr_api.argument_changed_error
255: (p_api_name => l_proc
256: ,p_argument => l_argument
257: );
258:

Line 303: hr_api.mandatory_arg_error

299: Begin
300: --
301: -- Ensure that the p_datetrack_mode argument is not null
302: --
303: hr_api.mandatory_arg_error
304: (p_api_name => l_proc
305: ,p_argument => 'datetrack_mode'
306: ,p_argument_value => p_datetrack_mode
307: );

Line 313: hr_api.mandatory_arg_error

309: -- Mode will be valid, as this is checked at the start of the upd.
310: --
311: -- Ensure the arguments are not null
312: --
313: hr_api.mandatory_arg_error
314: (p_api_name => l_proc
315: ,p_argument => 'validation_start_date'
316: ,p_argument_value => p_validation_start_date
317: );

Line 319: hr_api.mandatory_arg_error

315: ,p_argument => 'validation_start_date'
316: ,p_argument_value => p_validation_start_date
317: );
318: --
319: hr_api.mandatory_arg_error
320: (p_api_name => l_proc
321: ,p_argument => 'validation_end_date'
322: ,p_argument_value => p_validation_end_date
323: );

Line 387: hr_api.mandatory_arg_error

383: Begin
384: --
385: -- Ensure that the p_datetrack_mode argument is not null
386: --
387: hr_api.mandatory_arg_error
388: (p_api_name => l_proc
389: ,p_argument => 'datetrack_mode'
390: ,p_argument_value => p_datetrack_mode
391: );

Line 396: If (p_datetrack_mode = hr_api.g_delete or

392: --
393: -- Only perform the validation if the datetrack mode is either
394: -- DELETE or ZAP
395: --
396: If (p_datetrack_mode = hr_api.g_delete or
397: p_datetrack_mode = hr_api.g_zap) then
398: --
399: --
400: -- Ensure the arguments are not null

Line 397: p_datetrack_mode = hr_api.g_zap) then

393: -- Only perform the validation if the datetrack mode is either
394: -- DELETE or ZAP
395: --
396: If (p_datetrack_mode = hr_api.g_delete or
397: p_datetrack_mode = hr_api.g_zap) then
398: --
399: --
400: -- Ensure the arguments are not null
401: --

Line 402: hr_api.mandatory_arg_error

398: --
399: --
400: -- Ensure the arguments are not null
401: --
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc
404: ,p_argument => 'validation_start_date'
405: ,p_argument_value => p_validation_start_date
406: );

Line 408: hr_api.mandatory_arg_error

404: ,p_argument => 'validation_start_date'
405: ,p_argument_value => p_validation_start_date
406: );
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc
410: ,p_argument => 'validation_end_date'
411: ,p_argument_value => p_validation_end_date
412: );

Line 414: hr_api.mandatory_arg_error

410: ,p_argument => 'validation_end_date'
411: ,p_argument_value => p_validation_end_date
412: );
413: --
414: hr_api.mandatory_arg_error
415: (p_api_name => l_proc
416: ,p_argument => 'balance_feed_id'
417: ,p_argument_value => p_balance_feed_id
418: );

Line 507: -- and nvl(date_to, hr_api.g_eot) ) );

503: from hr_organization_units
504: where business_group_id = p_business_group_id;
505: -- and ( l_balance_init_flag = 1 or
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: --

Line 514: hr_api.mandatory_arg_error

510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512:
513: --
514: hr_api.mandatory_arg_error
515: (p_api_name => l_proc
516: ,p_argument => 'input_value_id'
517: ,p_argument_value => p_input_value_id
518: );

Line 610: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))

606: cursor csr_ipv_id is
607: select '1'
608: from pay_input_values_f
609: where input_value_id = p_input_value_id
610: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
611: = nvl(l_legislation_code, hr_api.g_varchar2)
612: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
613: = nvl(p_business_group_id, hr_api.g_number);
614:

Line 611: = nvl(l_legislation_code, hr_api.g_varchar2)

607: select '1'
608: from pay_input_values_f
609: where input_value_id = p_input_value_id
610: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
611: = nvl(l_legislation_code, hr_api.g_varchar2)
612: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
613: = nvl(p_business_group_id, hr_api.g_number);
614:
615: cursor csr_ipv_multiple_feeds is

Line 612: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))

608: from pay_input_values_f
609: where input_value_id = p_input_value_id
610: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
611: = nvl(l_legislation_code, hr_api.g_varchar2)
612: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
613: = nvl(p_business_group_id, hr_api.g_number);
614:
615: cursor csr_ipv_multiple_feeds is
616: select null

Line 613: = nvl(p_business_group_id, hr_api.g_number);

609: where input_value_id = p_input_value_id
610: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
611: = nvl(l_legislation_code, hr_api.g_varchar2)
612: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
613: = nvl(p_business_group_id, hr_api.g_number);
614:
615: cursor csr_ipv_multiple_feeds is
616: select null
617: from pay_balance_feeds_f pbf

Line 625: ,hr_api.return_legislation_code

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
626: (p_business_group_id));
627:
628: Open csr_ipv_id;
629: Fetch csr_ipv_id into l_exists;

Line 688: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))

684: cursor csr_bal_type_id is
685: select '1'
686: from pay_balance_types
687: where balance_type_id = p_balance_type_id
688: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
689: = nvl(l_legislation_code, hr_api.g_varchar2)
690: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
691: = nvl(p_business_group_id, hr_api.g_number);
692:

Line 689: = nvl(l_legislation_code, hr_api.g_varchar2)

685: select '1'
686: from pay_balance_types
687: where balance_type_id = p_balance_type_id
688: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
689: = nvl(l_legislation_code, hr_api.g_varchar2)
690: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
691: = nvl(p_business_group_id, hr_api.g_number);
692:
693: --

Line 690: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))

686: from pay_balance_types
687: where balance_type_id = p_balance_type_id
688: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
689: = nvl(l_legislation_code, hr_api.g_varchar2)
690: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
691: = nvl(p_business_group_id, hr_api.g_number);
692:
693: --
694: Begin

Line 691: = nvl(p_business_group_id, hr_api.g_number);

687: where balance_type_id = p_balance_type_id
688: and nvl(legislation_code, nvl(l_legislation_code, hr_api.g_varchar2))
689: = nvl(l_legislation_code, hr_api.g_varchar2)
690: and nvl(business_group_id, nvl(p_business_group_id, hr_api.g_number))
691: = nvl(p_business_group_id, hr_api.g_number);
692:
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);

Line 699: ,hr_api.return_legislation_code

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
700: (p_business_group_id));
701:
702: Open csr_bal_type_id;
703: Fetch csr_bal_type_id into l_exists;

Line 849: ,hr_api.return_legislation_code

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
850: (p_business_group_id));
851:
852: open csr_initial_feed_exist;
853: fetch csr_initial_feed_exist into l_balance_initialization_flag;

Line 1036: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS

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'
1039: ,p_lookup_code => p_scale
1040: )

Line 1047: hr_api.mandatory_arg_error

1043: fnd_message.raise_error;
1044: end if;
1045:
1046: --
1047: hr_api.mandatory_arg_error
1048: (p_api_name => l_proc
1049: ,p_argument => 'input_value_id'
1050: ,p_argument_value => p_input_value_id
1051: );

Line 1213: hr_api.mandatory_arg_error

1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211:
1212: --
1213: hr_api.mandatory_arg_error
1214: (p_api_name => l_proc
1215: ,p_argument => 'input_value_id'
1216: ,p_argument_value => p_input_value_id
1217: );

Line 1224: p_datetrack_mode <> hr_api.g_correction then

1220: -- Date effective update must not be allowed for the initial balance feed.
1221: --
1222:
1223: if get_balance_init_flag (p_input_value_id => p_input_value_id) and
1224: p_datetrack_mode <> hr_api.g_correction then
1225:
1226: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1227: fnd_message.set_token('ACTION', 'UPDATE');
1228: fnd_message.set_token('MODE', p_datetrack_mode);

Line 1271: hr_api.mandatory_arg_error

1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: --
1269:
1270: --
1271: hr_api.mandatory_arg_error
1272: (p_api_name => l_proc
1273: ,p_argument => 'input_value_id'
1274: ,p_argument_value => p_input_value_id
1275: );

Line 1283: and p_datetrack_mode <> hr_api.g_zap then

1279: -- Date effective delete must not be allowed for the initial balance feed.
1280: --
1281:
1282: if get_balance_init_flag( p_input_value_id => p_input_value_id)
1283: and p_datetrack_mode <> hr_api.g_zap then
1284:
1285: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1286: fnd_message.set_token('ACTION', 'DELETE');
1287: fnd_message.set_token('MODE', p_datetrack_mode);

Line 1333: hr_api.validate_bus_grp_id

1329: NOT IN ('GENERIC','STARTUP') THEN
1330: --
1331: -- Validate Important Attributes
1332: --
1333: hr_api.validate_bus_grp_id
1334: (p_business_group_id => p_rec.business_group_id
1335: ,p_associated_column1 => pay_pbf_shd.g_tab_nam
1336: || '.BUSINESS_GROUP_ID');
1337: --

Line 1453: -- hr_api.g_eot.

1449: -- When called from STARTUP Mode ignore this validation. Bug #8721639
1450: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
1451:
1452: -- When initial balance feed is being created, the effective end date must be
1453: -- hr_api.g_eot.
1454:
1455: if get_balance_init_flag (p_input_value_id => p_rec.input_value_id)
1456: and l_validation_end_date <> hr_api.g_eot then
1457: fnd_message.set_name('PAY','PAY_33243_BIFEED_INV_EDATE');

Line 1456: and l_validation_end_date <> hr_api.g_eot then

1452: -- When initial balance feed is being created, the effective end date must be
1453: -- hr_api.g_eot.
1454:
1455: if get_balance_init_flag (p_input_value_id => p_rec.input_value_id)
1456: and l_validation_end_date <> hr_api.g_eot then
1457: fnd_message.set_name('PAY','PAY_33243_BIFEED_INV_EDATE');
1458: fnd_message.raise_error;
1459: end if;
1460:

Line 1520: hr_api.validate_bus_grp_id

1516: NOT IN ('GENERIC','STARTUP') THEN
1517: --
1518: -- Validate Important Attributes
1519: --
1520: hr_api.validate_bus_grp_id
1521: (p_business_group_id => p_rec.business_group_id
1522: ,p_associated_column1 => pay_pbf_shd.g_tab_nam
1523: || '.BUSINESS_GROUP_ID');
1524: --

Line 1631: p_validation_end_date = hr_api.g_eot)) then

1627: -- value may be date effectively deleted in the future or there are future
1628: -- future balance feeds.
1629: if (p_datetrack_mode = 'FUTURE_CHANGE' or
1630: (p_datetrack_mode = 'DELETE_NEXT_CHANGE' and
1631: p_validation_end_date = hr_api.g_eot)) then
1632: l_validation_end_date := hr_balance_feeds.bal_feed_end_date
1633: (p_rec.balance_feed_id,
1634: p_rec.balance_type_id,
1635: p_rec.input_value_id,