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_PUR_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'user_row_id'
48: ,p_argument_value => p_user_row_id
49: );

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 109: hr_api.mandatory_arg_error

105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'user_row_id'
112: ,p_argument_value => p_user_row_id
113: );

Line 115: if ( nvl(pay_pur_bus.g_user_row_id, hr_api.g_number)

111: ,p_argument => 'user_row_id'
112: ,p_argument_value => p_user_row_id
113: );
114: --
115: if ( nvl(pay_pur_bus.g_user_row_id, hr_api.g_number)
116: = p_user_row_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 246: hr_api.mandatory_arg_error

242:
243: --
244: -- USER_TABLE_ID is mandatory.
245: --
246: hr_api.mandatory_arg_error
247: (p_api_name => l_proc
248: ,p_argument => 'USER_TABLE_ID'
249: ,p_argument_value => p_user_table_id
250: );

Line 299: hr_api.mandatory_arg_error

295:
296: --
297: -- USER_TABLE_ID is mandatory.
298: --
299: hr_api.mandatory_arg_error
300: (p_api_name => l_proc
301: ,p_argument => 'USER_TABLE_ID'
302: ,p_argument_value => p_user_table_id
303: );

Line 375: hr_api.mandatory_arg_error

371: hr_utility.set_location('Entering:'|| l_proc, 10);
372: --
373: -- USER_TABLE_ID is mandatory.
374: --
375: hr_api.mandatory_arg_error
376: (p_api_name => l_proc
377: ,p_argument => 'USER_TABLE_ID'
378: ,p_argument_value => p_user_table_id
379: );

Line 570: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id )))

566: or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
567: or ( p_business_group_id is not null and
568: usr.legislation_code is null and usr.business_group_id is null )
569: or ( p_business_group_id is not null and
570: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id )))
571: and ( p_legislation_code is null
572: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
573: or ( p_legislation_code is not null and
574: usr.legislation_code is null and usr.business_group_id is null)

Line 576: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id )))

572: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
573: or ( p_legislation_code is not null and
574: usr.legislation_code is null and usr.business_group_id is null)
575: or ( p_legislation_code is not null and
576: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id )))
577: and ( usr.effective_start_date <= p_validation_end_date and
578: usr.effective_end_date >= p_validation_start_date );
579:
580:

Line 604: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>

600: (p_user_row_id => p_user_row_id
601: ,p_effective_date => p_effective_date
602: ,p_object_version_number => p_object_version_number
603: ) or
604: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
605: pay_pur_shd.g_old_rec.row_low_range_or_name
606: ) then
607: --
608: -- The name is mandatory.

Line 610: hr_api.mandatory_arg_error

606: ) then
607: --
608: -- The name is mandatory.
609: --
610: hr_api.mandatory_arg_error
611: (p_api_name => l_proc
612: ,p_argument => 'ROW_LOW_RANGE_OR_NAME'
613: ,p_argument_value => p_row_low_range_or_name
614: );

Line 758: nvl(p_row_high_range, hr_api.g_varchar2) <>

754: (p_user_row_id => p_user_row_id
755: ,p_effective_date => p_effective_date
756: ,p_object_version_number => p_object_version_number
757: ) or
758: nvl(p_row_high_range, hr_api.g_varchar2) <>
759: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2)
760: ) then
761: --
762: -- Ignore all validations for ROW_HIGH_RANGE for Exact Match User Tables.

Line 759: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2)

755: ,p_effective_date => p_effective_date
756: ,p_object_version_number => p_object_version_number
757: ) or
758: nvl(p_row_high_range, hr_api.g_varchar2) <>
759: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2)
760: ) then
761: --
762: -- Ignore all validations for ROW_HIGH_RANGE for Exact Match User Tables.
763: --

Line 772: hr_api.mandatory_arg_error

768: if l_range_or_match = 'R' then
769:
770: -- row_high_range is mandatory
771:
772: hr_api.mandatory_arg_error
773: (p_api_name => l_proc
774: ,p_argument => 'ROW_HIGH_RANGE'
775: ,p_argument_value => p_row_high_range
776: );

Line 871: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))

867: or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
868: or ( p_business_group_id is not null and
869: usr.legislation_code is null and usr.business_group_id is null )
870: or ( p_business_group_id is not null and
871: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))
872: and ( p_legislation_code is null
873: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
874: or ( p_legislation_code is not null and
875: usr.legislation_code is null and usr.business_group_id is null)

Line 877: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id) ))

873: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
874: or ( p_legislation_code is not null and
875: usr.legislation_code is null and usr.business_group_id is null)
876: or ( p_legislation_code is not null and
877: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id) ))
878: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
879: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
880: or (fnd_number.canonical_to_number(p_row_high_range) between
881: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))

Line 914: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>

910: (p_user_row_id => p_user_row_id
911: ,p_effective_date => p_effective_date
912: ,p_object_version_number => p_object_version_number
913: ) or (
914: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
915: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or
916: nvl(p_row_high_range, hr_api.g_varchar2) <>
917: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
918: ) then

Line 915: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or

911: ,p_effective_date => p_effective_date
912: ,p_object_version_number => p_object_version_number
913: ) or (
914: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
915: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or
916: nvl(p_row_high_range, hr_api.g_varchar2) <>
917: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
918: ) then
919:

Line 916: nvl(p_row_high_range, hr_api.g_varchar2) <>

912: ,p_object_version_number => p_object_version_number
913: ) or (
914: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
915: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or
916: nvl(p_row_high_range, hr_api.g_varchar2) <>
917: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
918: ) then
919:
920: if p_disable_range_overlap_check is null then

Line 917: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))

913: ) or (
914: nvl(p_row_low_range_or_name, hr_api.g_varchar2) <>
915: nvl(pay_pur_shd.g_old_rec.row_low_range_or_name, hr_api.g_varchar2) or
916: nvl(p_row_high_range, hr_api.g_varchar2) <>
917: nvl(pay_pur_shd.g_old_rec.row_high_range, hr_api.g_varchar2))
918: ) then
919:
920: if p_disable_range_overlap_check is null then
921: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');

Line 1111: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))

1107: or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
1108: or ( p_business_group_id is not null and
1109: usr.legislation_code is null and usr.business_group_id is null )
1110: or ( p_business_group_id is not null and
1111: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))
1112: and ( p_legislation_code is null
1113: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
1114: or ( p_legislation_code is not null and
1115: usr.legislation_code is null and usr.business_group_id is null)

Line 1117: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))

1113: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
1114: or ( p_legislation_code is not null and
1115: usr.legislation_code is null and usr.business_group_id is null)
1116: or ( p_legislation_code is not null and
1117: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
1118: and ( usr.effective_start_date <= p_validation_end_date and
1119: usr.effective_end_date >= p_validation_start_date );
1120:
1121: cursor csr_row_overlap is

Line 1132: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))

1128: or ( p_business_group_id is not null and p_business_group_id = usr.business_group_id )
1129: or ( p_business_group_id is not null and
1130: usr.legislation_code is null and usr.business_group_id is null )
1131: or ( p_business_group_id is not null and
1132: usr.legislation_code = hr_api.return_legislation_code(p_business_group_id ) ))
1133: and ( p_legislation_code is null
1134: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
1135: or ( p_legislation_code is not null and
1136: usr.legislation_code is null and usr.business_group_id is null)

Line 1138: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))

1134: or ( p_legislation_code is not null and p_legislation_code = usr.legislation_code )
1135: or ( p_legislation_code is not null and
1136: usr.legislation_code is null and usr.business_group_id is null)
1137: or ( p_legislation_code is not null and
1138: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
1139: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
1140: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1141: or (fnd_number.canonical_to_number(p_row_high_range) between
1142: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))

Line 1183: if p_datetrack_mode = hr_api.g_delete then

1179: fnd_message.set_token('ARGUMENT','DISABLE_RANGE_OVERLAP_CHECK');
1180: fnd_message.raise_error;
1181: end if;
1182:
1183: if p_datetrack_mode = hr_api.g_delete then
1184:
1185: open csr_delete_mode;
1186: fetch csr_delete_mode into l_exists;
1187: if csr_delete_mode%found then

Line 1194: elsif p_datetrack_mode = hr_api.g_zap then

1190: fnd_message.raise_error;
1191: end if;
1192: close csr_delete_mode;
1193:
1194: elsif p_datetrack_mode = hr_api.g_zap then
1195:
1196: open csr_zap_mode;
1197: fetch csr_zap_mode into l_exists ;
1198: if csr_zap_mode%found then

Line 1206: elsif p_datetrack_mode in (hr_api.g_future_change,hr_api.g_delete_next_change) then

1202: fnd_message.raise_error ;
1203: end if ;
1204: close csr_zap_mode;
1205:
1206: elsif p_datetrack_mode in (hr_api.g_future_change,hr_api.g_delete_next_change) then
1207:
1208:
1209: l_result := fnd_installation.get_app_info ( 'GHR',
1210: l_prod_status,

Line 1337: if nvl(p_rec.user_table_id, hr_api.g_number) <>

1333: fnd_message.raise_error;
1334: END IF;
1335: --
1336: --
1337: if nvl(p_rec.user_table_id, hr_api.g_number) <>
1338: pay_pur_shd.g_old_rec.user_table_id then
1339: hr_api.argument_changed_error
1340: (p_api_name => l_proc
1341: ,p_argument => 'USER_TABLE_ID'

Line 1339: hr_api.argument_changed_error

1335: --
1336: --
1337: if nvl(p_rec.user_table_id, hr_api.g_number) <>
1338: pay_pur_shd.g_old_rec.user_table_id then
1339: hr_api.argument_changed_error
1340: (p_api_name => l_proc
1341: ,p_argument => 'USER_TABLE_ID'
1342: ,p_base_table => pay_pur_shd.g_tab_nam
1343: );

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

1342: ,p_base_table => pay_pur_shd.g_tab_nam
1343: );
1344: end if;
1345: --
1346: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1347: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then
1348: hr_api.argument_changed_error
1349: (p_api_name => l_proc
1350: ,p_argument => 'BUSINESS_GROUP_ID'

Line 1347: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then

1343: );
1344: end if;
1345: --
1346: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1347: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then
1348: hr_api.argument_changed_error
1349: (p_api_name => l_proc
1350: ,p_argument => 'BUSINESS_GROUP_ID'
1351: ,p_base_table => pay_pur_shd.g_tab_nam

Line 1348: hr_api.argument_changed_error

1344: end if;
1345: --
1346: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1347: nvl(pay_pur_shd.g_old_rec.business_group_id, hr_api.g_number) then
1348: hr_api.argument_changed_error
1349: (p_api_name => l_proc
1350: ,p_argument => 'BUSINESS_GROUP_ID'
1351: ,p_base_table => pay_pur_shd.g_tab_nam
1352: );

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

1351: ,p_base_table => pay_pur_shd.g_tab_nam
1352: );
1353: end if;
1354: --
1355: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
1356: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
1357: hr_api.argument_changed_error
1358: (p_api_name => l_proc
1359: ,p_argument => 'LEGISLATION_CODE'

Line 1356: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

1352: );
1353: end if;
1354: --
1355: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
1356: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
1357: hr_api.argument_changed_error
1358: (p_api_name => l_proc
1359: ,p_argument => 'LEGISLATION_CODE'
1360: ,p_base_table => pay_pur_shd.g_tab_nam

Line 1357: hr_api.argument_changed_error

1353: end if;
1354: --
1355: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
1356: nvl(pay_pur_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
1357: hr_api.argument_changed_error
1358: (p_api_name => l_proc
1359: ,p_argument => 'LEGISLATION_CODE'
1360: ,p_base_table => pay_pur_shd.g_tab_nam
1361: );

Line 1409: hr_api.mandatory_arg_error

1405: Begin
1406: --
1407: -- Ensure that the p_datetrack_mode argument is not null
1408: --
1409: hr_api.mandatory_arg_error
1410: (p_api_name => l_proc
1411: ,p_argument => 'datetrack_mode'
1412: ,p_argument_value => p_datetrack_mode
1413: );

Line 1419: hr_api.mandatory_arg_error

1415: -- Mode will be valid, as this is checked at the start of the upd.
1416: --
1417: -- Ensure the arguments are not null
1418: --
1419: hr_api.mandatory_arg_error
1420: (p_api_name => l_proc
1421: ,p_argument => 'validation_start_date'
1422: ,p_argument_value => p_validation_start_date
1423: );

Line 1425: hr_api.mandatory_arg_error

1421: ,p_argument => 'validation_start_date'
1422: ,p_argument_value => p_validation_start_date
1423: );
1424: --
1425: hr_api.mandatory_arg_error
1426: (p_api_name => l_proc
1427: ,p_argument => 'validation_end_date'
1428: ,p_argument_value => p_validation_end_date
1429: );

Line 1493: hr_api.mandatory_arg_error

1489: Begin
1490: --
1491: -- Ensure that the p_datetrack_mode argument is not null
1492: --
1493: hr_api.mandatory_arg_error
1494: (p_api_name => l_proc
1495: ,p_argument => 'datetrack_mode'
1496: ,p_argument_value => p_datetrack_mode
1497: );

Line 1502: If (p_datetrack_mode = hr_api.g_delete or

1498: --
1499: -- Only perform the validation if the datetrack mode is either
1500: -- DELETE or ZAP
1501: --
1502: If (p_datetrack_mode = hr_api.g_delete or
1503: p_datetrack_mode = hr_api.g_zap) then
1504: --
1505: --
1506: -- Ensure the arguments are not null

Line 1503: p_datetrack_mode = hr_api.g_zap) then

1499: -- Only perform the validation if the datetrack mode is either
1500: -- DELETE or ZAP
1501: --
1502: If (p_datetrack_mode = hr_api.g_delete or
1503: p_datetrack_mode = hr_api.g_zap) then
1504: --
1505: --
1506: -- Ensure the arguments are not null
1507: --

Line 1508: hr_api.mandatory_arg_error

1504: --
1505: --
1506: -- Ensure the arguments are not null
1507: --
1508: hr_api.mandatory_arg_error
1509: (p_api_name => l_proc
1510: ,p_argument => 'validation_start_date'
1511: ,p_argument_value => p_validation_start_date
1512: );

Line 1514: hr_api.mandatory_arg_error

1510: ,p_argument => 'validation_start_date'
1511: ,p_argument_value => p_validation_start_date
1512: );
1513: --
1514: hr_api.mandatory_arg_error
1515: (p_api_name => l_proc
1516: ,p_argument => 'validation_end_date'
1517: ,p_argument_value => p_validation_end_date
1518: );

Line 1520: hr_api.mandatory_arg_error

1516: ,p_argument => 'validation_end_date'
1517: ,p_argument_value => p_validation_end_date
1518: );
1519: --
1520: hr_api.mandatory_arg_error
1521: (p_api_name => l_proc
1522: ,p_argument => 'user_row_id'
1523: ,p_argument_value => p_user_row_id
1524: );

Line 1627: hr_api.validate_bus_grp_id

1623: NOT IN ('GENERIC','STARTUP') THEN
1624: --
1625: -- Validate Important Attributes
1626: --
1627: hr_api.validate_bus_grp_id
1628: (p_business_group_id => p_rec.business_group_id
1629: ,p_associated_column1 => pay_pur_shd.g_tab_nam
1630: || '.BUSINESS_GROUP_ID');
1631: --

Line 1744: hr_api.validate_bus_grp_id

1740: NOT IN ('GENERIC','STARTUP') THEN
1741: --
1742: -- Validate Important Attributes
1743: --
1744: hr_api.validate_bus_grp_id
1745: (p_business_group_id => p_rec.business_group_id
1746: ,p_associated_column1 => pay_pur_shd.g_tab_nam
1747: || '.BUSINESS_GROUP_ID');
1748: --