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.PQP_EXR_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

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

Line 73: hr_api.set_security_group_id

69: close csr_sec_grp;
70: --
71: -- Set the security_group_id in CLIENT_INFO
72: --
73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 271: IF nvl(p_rec.business_group_id, hr_api.g_number) <>

267: fnd_message.set_token('STEP ', '5');
268: fnd_message.raise_error;
269: END IF;
270:
271: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
272: nvl (pqp_exr_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
273: l_argument := 'business_group_id';
274: RAISE l_error;
275: END IF;

Line 272: nvl (pqp_exr_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

268: fnd_message.raise_error;
269: END IF;
270:
271: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
272: nvl (pqp_exr_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
273: l_argument := 'business_group_id';
274: RAISE l_error;
275: END IF;
276:

Line 277: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

273: l_argument := 'business_group_id';
274: RAISE l_error;
275: END IF;
276:
277: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
278: nvl (pqp_exr_shd.g_old_rec.legislation_code, hr_api.g_varchar2) THEN
279: l_argument := 'legislation_code';
280: RAISE l_error;
281: END IF;

Line 278: nvl (pqp_exr_shd.g_old_rec.legislation_code, hr_api.g_varchar2) THEN

274: RAISE l_error;
275: END IF;
276:
277: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
278: nvl (pqp_exr_shd.g_old_rec.legislation_code, hr_api.g_varchar2) THEN
279: l_argument := 'legislation_code';
280: RAISE l_error;
281: END IF;
282:

Line 285: hr_api.argument_changed_error

281: END IF;
282:
283: EXCEPTION
284: WHEN l_error THEN
285: hr_api.argument_changed_error
286: (p_api_name => l_proc
287: ,p_argument => l_argument);
288: WHEN OTHERS THEN
289: RAISE;

Line 389: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>

385: ,p_object_version_number => p_object_version_number);
386:
387: --
388:
389: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
390: nvl(p_currency_code, hr_api.g_varchar2))) or
391: (NOT l_api_updating)) THEN
392:
393: --

Line 390: nvl(p_currency_code, hr_api.g_varchar2))) or

386:
387: --
388:
389: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.currency_code, hr_api.g_varchar2) <>
390: nvl(p_currency_code, hr_api.g_varchar2))) or
391: (NOT l_api_updating)) THEN
392:
393: --
394: -- Get currency code information

Line 498: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_type_id, hr_api.g_number) <>

494: ,p_object_version_number => p_object_version_number);
495:
496: --
497:
498: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_type_id, hr_api.g_number) <>
499: nvl(p_balance_type_id, hr_api.g_number))) or
500: (NOT l_api_updating)) THEN
501:
502: --

Line 499: nvl(p_balance_type_id, hr_api.g_number))) or

495:
496: --
497:
498: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_type_id, hr_api.g_number) <>
499: nvl(p_balance_type_id, hr_api.g_number))) or
500: (NOT l_api_updating)) THEN
501:
502: --
503: -- Check whether the balance type id exists within the BG or Leg Code

Line 605: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_dimension_id, hr_api.g_number) <>

601: ,p_object_version_number => p_object_version_number);
602:
603: --
604:
605: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_dimension_id, hr_api.g_number) <>
606: nvl(p_balance_dimension_id, hr_api.g_number))) or
607: (NOT l_api_updating)) THEN
608:
609: --

Line 606: nvl(p_balance_dimension_id, hr_api.g_number))) or

602:
603: --
604:
605: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.balance_dimension_id, hr_api.g_number) <>
606: nvl(p_balance_dimension_id, hr_api.g_number))) or
607: (NOT l_api_updating)) THEN
608:
609: --
610: -- Check whether this balance dimension id exists for this balance type id

Line 698: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_type, hr_api.g_varchar2) <>

694: ,p_object_version_number => p_object_version_number);
695:
696: --
697:
698: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_type, hr_api.g_varchar2) <>
699: nvl(p_variance_type, hr_api.g_varchar2))) or
700: (NOT l_api_updating)) THEN
701:
702: IF p_variance_type is not null THEN

Line 699: nvl(p_variance_type, hr_api.g_varchar2))) or

695:
696: --
697:
698: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_type, hr_api.g_varchar2) <>
699: nvl(p_variance_type, hr_api.g_varchar2))) or
700: (NOT l_api_updating)) THEN
701:
702: IF p_variance_type is not null THEN
703:

Line 800: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.output_format_type, hr_api.g_varchar2) <>

796: (p_exception_report_id => p_exception_report_id
797: ,p_object_version_number => p_object_version_number);
798:
799: --
800: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.output_format_type, hr_api.g_varchar2) <>
801: nvl(p_output_format_type, hr_api.g_varchar2))) or
802: (NOT l_api_updating)) THEN
803:
804: IF p_output_format_type is not null THEN

Line 801: nvl(p_output_format_type, hr_api.g_varchar2))) or

797: ,p_object_version_number => p_object_version_number);
798:
799: --
800: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.output_format_type, hr_api.g_varchar2) <>
801: nvl(p_output_format_type, hr_api.g_varchar2))) or
802: (NOT l_api_updating)) THEN
803:
804: IF p_output_format_type is not null THEN
805:

Line 823: /* IF hr_api.not_exists_in_hr_lookups

819: IF p_output_format_type='TXT' THEN
820: fnd_message.set_name('PQP','PQP_230444_BACKCOMP_SUPPORT');
821: fnd_message.raise_error;
822: END IF;
823: /* IF hr_api.not_exists_in_hr_lookups
824: (p_lookup_type => 'PQP_OUTPUT_FORMAT_TYPES'
825: ,p_lookup_code => p_output_format_type
826: ,p_effective_date => l_effective_date ) THEN
827:

Line 837: IF hr_api.not_exists_in_hrstanlookups

833: fnd_message.raise_error;
834: END IF; */ -- End if of lookup check ...
835: hr_utility.set_location(l_proc, 40);
836: /* ELSE
837: IF hr_api.not_exists_in_hrstanlookups
838: (p_lookup_type => 'PQP_OUTPUT_FORMAT_TYPES'
839: ,p_lookup_code => p_output_format_type
840: ,p_effective_date => l_effective_date ) THEN
841:

Line 924: and (nvl(pqp_exr_shd.g_old_rec.variance_value, hr_api.g_number) <> nvl(p_variance_value, hr_api.g_number)))

920:
921: --
922:
923: /* IF ((l_api_updating
924: and (nvl(pqp_exr_shd.g_old_rec.variance_value, hr_api.g_number) <> nvl(p_variance_value, hr_api.g_number)))
925: OR (NOT l_api_updating))
926: THEN */ -- commented by pjavaji
927:
928: --

Line 1026: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_type, hr_api.g_varchar2) <>

1022: (p_exception_report_id => p_exception_report_id
1023: ,p_object_version_number => p_object_version_number);
1024:
1025: --
1026: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_type, hr_api.g_varchar2) <>
1027: nvl(p_comparison_type, hr_api.g_varchar2))) or
1028: (NOT l_api_updating)) THEN
1029:
1030: IF p_comparison_type is not null THEN

Line 1027: nvl(p_comparison_type, hr_api.g_varchar2))) or

1023: ,p_object_version_number => p_object_version_number);
1024:
1025: --
1026: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_type, hr_api.g_varchar2) <>
1027: nvl(p_comparison_type, hr_api.g_varchar2))) or
1028: (NOT l_api_updating)) THEN
1029:
1030: IF p_comparison_type is not null THEN
1031:

Line 1045: IF hr_api.not_exists_in_hr_lookups

1041: --
1042: hr_utility.set_location(l_proc, 30);
1043:
1044: IF p_business_group_id is not null THEN
1045: IF hr_api.not_exists_in_hr_lookups
1046: (p_lookup_type => 'PQP_COMPARISON_TYPE'
1047: ,p_lookup_code => p_comparison_type
1048: ,p_effective_date => l_effective_date ) THEN
1049:

Line 1059: IF hr_api.not_exists_in_hrstanlookups

1055: fnd_message.raise_error;
1056: END IF; -- End if of lookup check ...
1057: hr_utility.set_location(l_proc, 40);
1058: ELSE
1059: IF hr_api.not_exists_in_hrstanlookups
1060: (p_lookup_type => 'PQP_COMPARISON_TYPE'
1061: ,p_lookup_code => p_comparison_type
1062: ,p_effective_date => l_effective_date ) THEN
1063:

Line 1161: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_operator, hr_api.g_varchar2) <>

1157: (p_exception_report_id => p_exception_report_id
1158: ,p_object_version_number => p_object_version_number);
1159:
1160: --
1161: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_operator, hr_api.g_varchar2) <>
1162: nvl(p_variance_operator, hr_api.g_varchar2))) or
1163: (NOT l_api_updating)) THEN
1164:
1165: IF p_variance_operator is not null THEN

Line 1162: nvl(p_variance_operator, hr_api.g_varchar2))) or

1158: ,p_object_version_number => p_object_version_number);
1159:
1160: --
1161: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.variance_operator, hr_api.g_varchar2) <>
1162: nvl(p_variance_operator, hr_api.g_varchar2))) or
1163: (NOT l_api_updating)) THEN
1164:
1165: IF p_variance_operator is not null THEN
1166:

Line 1180: IF hr_api.not_exists_in_hr_lookups

1176: --
1177: hr_utility.set_location(l_proc, 30);
1178:
1179: IF p_business_group_id is not null THEN
1180: IF hr_api.not_exists_in_hr_lookups
1181: (p_lookup_type => 'PQP_VARIANCE_OPERATOR_TYPES'
1182: ,p_lookup_code => p_variance_operator
1183: ,p_effective_date => l_effective_date ) THEN
1184:

Line 1194: IF hr_api.not_exists_in_hrstanlookups

1190: fnd_message.raise_error;
1191: END IF; -- End if of lookup check ...
1192: hr_utility.set_location(l_proc, 40);
1193: ELSE
1194: IF hr_api.not_exists_in_hrstanlookups
1195: (p_lookup_type => 'PQP_VARIANCE_OPERATOR_TYPES'
1196: ,p_lookup_code => p_variance_operator
1197: ,p_effective_date => l_effective_date ) THEN
1198:

Line 1277: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>

1273: (p_exception_report_id => p_exception_report_id
1274: ,p_object_version_number => p_object_version_number);
1275:
1276: --
1277: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>
1278: nvl(p_comparison_value, hr_api.g_number))) or
1279: (NOT l_api_updating)) THEN
1280:
1281:

Line 1278: nvl(p_comparison_value, hr_api.g_number))) or

1274: ,p_object_version_number => p_object_version_number);
1275:
1276: --
1277: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>
1278: nvl(p_comparison_value, hr_api.g_number))) or
1279: (NOT l_api_updating)) THEN
1280:
1281:
1282: IF nvl(p_comparison_value, hr_api.g_number) <> 1 THEN

Line 1282: IF nvl(p_comparison_value, hr_api.g_number) <> 1 THEN

1278: nvl(p_comparison_value, hr_api.g_number))) or
1279: (NOT l_api_updating)) THEN
1280:
1281:
1282: IF nvl(p_comparison_value, hr_api.g_number) <> 1 THEN
1283:
1284: -- Raise error as the input comparison value is not equal
1285: -- to one
1286:

Line 1308: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>

1304: (p_exception_report_id => p_exception_report_id
1305: ,p_object_version_number => p_object_version_number);
1306:
1307: --
1308: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>
1309: nvl(p_comparison_value, hr_api.g_number))) or
1310: (NOT l_api_updating)) THEN
1311:
1312:

Line 1309: nvl(p_comparison_value, hr_api.g_number))) or

1305: ,p_object_version_number => p_object_version_number);
1306:
1307: --
1308: IF ((l_api_updating and (nvl(pqp_exr_shd.g_old_rec.comparison_value, hr_api.g_number) <>
1309: nvl(p_comparison_value, hr_api.g_number))) or
1310: (NOT l_api_updating)) THEN
1311:
1312:
1313: IF nvl(p_comparison_value, hr_api.g_number) <> 0 THEN

Line 1313: IF nvl(p_comparison_value, hr_api.g_number) <> 0 THEN

1309: nvl(p_comparison_value, hr_api.g_number))) or
1310: (NOT l_api_updating)) THEN
1311:
1312:
1313: IF nvl(p_comparison_value, hr_api.g_number) <> 0 THEN
1314:
1315: -- Raise error as the input comparison value is not equal
1316: -- to one
1317:

Line 1402: hr_api.mandatory_arg_error

1398: --
1399:
1400: -- Check manadatory arg
1401:
1402: hr_api.mandatory_arg_error
1403: (p_api_name => l_proc
1404: ,p_argument => 'exception_report_name'
1405: ,p_argument_value => p_exception_report_name
1406: );

Line 1575: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1571: ,p_legislation_code =>p_rec.legislation_code
1572: ,p_legislation_subgroup =>NULL
1573: );
1574: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1575: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1576: END IF;
1577:
1578: --
1579: -- Check currency code

Line 1728: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1724: ,p_legislation_code =>p_rec.legislation_code
1725: ,p_legislation_subgroup=>NULL
1726: );
1727: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1728: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1729: END IF;
1730: END IF;
1731:
1732: