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 827: ,hr_api.return_legislation_code

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
828: (p_business_group_id));
829:
830: open csr_initial_feed_exist;
831: fetch csr_initial_feed_exist into l_balance_initialization_flag;

Line 1014: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS

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'
1017: ,p_lookup_code => p_scale
1018: )

Line 1025: hr_api.mandatory_arg_error

1021: fnd_message.raise_error;
1022: end if;
1023:
1024: --
1025: hr_api.mandatory_arg_error
1026: (p_api_name => l_proc
1027: ,p_argument => 'input_value_id'
1028: ,p_argument_value => p_input_value_id
1029: );

Line 1191: hr_api.mandatory_arg_error

1187: hr_utility.set_location('Entering:'||l_proc, 5);
1188: --
1189:
1190: --
1191: hr_api.mandatory_arg_error
1192: (p_api_name => l_proc
1193: ,p_argument => 'input_value_id'
1194: ,p_argument_value => p_input_value_id
1195: );

Line 1202: p_datetrack_mode <> hr_api.g_correction then

1198: -- Date effective update must not be allowed for the initial balance feed.
1199: --
1200:
1201: if get_balance_init_flag (p_input_value_id => p_input_value_id) and
1202: p_datetrack_mode <> hr_api.g_correction then
1203:
1204: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1205: fnd_message.set_token('ACTION', 'UPDATE');
1206: fnd_message.set_token('MODE', p_datetrack_mode);

Line 1249: hr_api.mandatory_arg_error

1245: hr_utility.set_location('Entering:'||l_proc, 5);
1246: --
1247:
1248: --
1249: hr_api.mandatory_arg_error
1250: (p_api_name => l_proc
1251: ,p_argument => 'input_value_id'
1252: ,p_argument_value => p_input_value_id
1253: );

Line 1261: and p_datetrack_mode <> hr_api.g_zap then

1257: -- Date effective delete must not be allowed for the initial balance feed.
1258: --
1259:
1260: if get_balance_init_flag( p_input_value_id => p_input_value_id)
1261: and p_datetrack_mode <> hr_api.g_zap then
1262:
1263: fnd_message.set_name('PAY','PAY_33244_BIFEED_INV_ACTION');
1264: fnd_message.set_token('ACTION', 'DELETE');
1265: fnd_message.set_token('MODE', p_datetrack_mode);

Line 1311: hr_api.validate_bus_grp_id

1307: NOT IN ('GENERIC','STARTUP') THEN
1308: --
1309: -- Validate Important Attributes
1310: --
1311: hr_api.validate_bus_grp_id
1312: (p_business_group_id => p_rec.business_group_id
1313: ,p_associated_column1 => pay_pbf_shd.g_tab_nam
1314: || '.BUSINESS_GROUP_ID');
1315: --

Line 1417: -- hr_api.g_eot.

1413:
1414: end if;
1415:
1416: -- When initial balance feed is being created, the effective end date must be
1417: -- hr_api.g_eot.
1418:
1419: if get_balance_init_flag (p_input_value_id => p_rec.input_value_id)
1420: and l_validation_end_date <> hr_api.g_eot then
1421: fnd_message.set_name('PAY','PAY_33243_BIFEED_INV_EDATE');

Line 1420: and l_validation_end_date <> hr_api.g_eot then

1416: -- When initial balance feed is being created, the effective end date must be
1417: -- hr_api.g_eot.
1418:
1419: if get_balance_init_flag (p_input_value_id => p_rec.input_value_id)
1420: and l_validation_end_date <> hr_api.g_eot then
1421: fnd_message.set_name('PAY','PAY_33243_BIFEED_INV_EDATE');
1422: fnd_message.raise_error;
1423: end if;
1424:

Line 1482: hr_api.validate_bus_grp_id

1478: NOT IN ('GENERIC','STARTUP') THEN
1479: --
1480: -- Validate Important Attributes
1481: --
1482: hr_api.validate_bus_grp_id
1483: (p_business_group_id => p_rec.business_group_id
1484: ,p_associated_column1 => pay_pbf_shd.g_tab_nam
1485: || '.BUSINESS_GROUP_ID');
1486: --

Line 1589: p_validation_end_date = hr_api.g_eot)) then

1585: -- value may be date effectively deleted in the future or there are future
1586: -- future balance feeds.
1587: if (p_datetrack_mode = 'FUTURE_CHANGE' or
1588: (p_datetrack_mode = 'DELETE_NEXT_CHANGE' and
1589: p_validation_end_date = hr_api.g_eot)) then
1590: l_validation_end_date := hr_balance_feeds.bal_feed_end_date
1591: (p_rec.balance_feed_id,
1592: p_rec.balance_type_id,
1593: p_rec.input_value_id,