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

Line 51: -- The exception hr_api.check_integrity_violated,

47: -- {Start Of Comments}
48: --
49: -- Description:
50: -- This procedure is called when a constraint has been violated (i.e.
51: -- The exception hr_api.check_integrity_violated,
52: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
53: -- been raised).
54: -- The exceptions can only be raised as follows:
55: -- 1) A check constraint can only be violated during an INSERT or UPDATE

Line 52: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has

48: --
49: -- Description:
50: -- This procedure is called when a constraint has been violated (i.e.
51: -- The exception hr_api.check_integrity_violated,
52: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
53: -- been raised).
54: -- The exceptions can only be raised as follows:
55: -- 1) A check constraint can only be violated during an INSERT or UPDATE
56: -- dml operation.

Line 63: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated

59: -- 3) A child integrity constraint can only be violated during an
60: -- DELETE dml operation.
61: --
62: -- Pre Conditions:
63: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
64: -- or hr_api.child_integrity_violated has been raised with the subsequent
65: -- stripping of the constraint name from the generated error message text.
66: --
67: -- In Arguments:

Line 64: -- or hr_api.child_integrity_violated has been raised with the subsequent

60: -- DELETE dml operation.
61: --
62: -- Pre Conditions:
63: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
64: -- or hr_api.child_integrity_violated has been raised with the subsequent
65: -- stripping of the constraint name from the generated error message text.
66: --
67: -- In Arguments:
68: -- P_CONSTRAINT_NAME is in upper format and is just the constraint name

Line 397: nvl(g_old_rec.default_flag,hr_api.g_varchar2) <>

393:
394: /* Bug 1634112 only call check_single_default if default_flag='Y'*/
395: IF P_REC.DEFAULT_FLAG ='Y' THEN
396: IF (((p_rec.booking_Status_type_id is not null) and
397: nvl(g_old_rec.default_flag,hr_api.g_varchar2) <>
398: nvl(p_rec.default_flag,hr_api.g_varchar2))
399: or (p_rec.booking_status_type_id is null)) then
400: CHECK_SINGLE_DEFAULT (
401: P_BUSINESS_GROUP_ID => P_REC.BUSINESS_GROUP_ID,

Line 398: nvl(p_rec.default_flag,hr_api.g_varchar2))

394: /* Bug 1634112 only call check_single_default if default_flag='Y'*/
395: IF P_REC.DEFAULT_FLAG ='Y' THEN
396: IF (((p_rec.booking_Status_type_id is not null) and
397: nvl(g_old_rec.default_flag,hr_api.g_varchar2) <>
398: nvl(p_rec.default_flag,hr_api.g_varchar2))
399: or (p_rec.booking_status_type_id is null)) then
400: CHECK_SINGLE_DEFAULT (
401: P_BUSINESS_GROUP_ID => P_REC.BUSINESS_GROUP_ID,
402: P_TYPE => P_REC.TYPE,

Line 700: hr_api.mandatory_arg_error

696: hr_utility.set_location('Entering:'|| l_proc, 10);
697: --
698: -- Ensure that all the mandatory parameter are not null
699: --
700: hr_api.mandatory_arg_error
701: (p_api_name => l_proc
702: ,p_argument => 'booking_status_type_id'
703: ,p_argument_value => p_booking_status_type_id
704: );

Line 727: hr_api.set_security_group_id

723: close csr_sec_grp;
724: --
725: -- Set the security_group_id in CLIENT_INFO
726: --
727: hr_api.set_security_group_id
728: (p_security_group_id => l_security_group_id
729: );
730: --
731: -- Set the sessions legislation context in HR_SESSION_DATA

Line 733: hr_api.set_legislation_context(l_legislation_code);

729: );
730: --
731: -- Set the sessions legislation context in HR_SESSION_DATA
732: --
733: hr_api.set_legislation_context(l_legislation_code);
734: end if;
735: --
736: hr_utility.set_location(' Leaving:'|| l_proc, 20);
737: --

Line 769: hr_api.mandatory_arg_error

765: hr_utility.set_location('Entering:'|| l_proc, 10);
766: --
767: -- Ensure that all the mandatory parameter are not null
768: --
769: hr_api.mandatory_arg_error
770: (p_api_name => l_proc
771: ,p_argument => 'booking_status_type_id'
772: ,p_argument_value => p_booking_status_type_id
773: );

Line 775: if ( nvl(ota_bst_api.g_booking_status_type_id, hr_api.g_number)

771: ,p_argument => 'booking_status_type_id'
772: ,p_argument_value => p_booking_status_type_id
773: );
774: --
775: if ( nvl(ota_bst_api.g_booking_status_type_id, hr_api.g_number)
776: = p_booking_status_type_id) then
777: --
778: -- The legislation code has already been found with a previous
779: -- call to this function. Just return the value in the global

Line 953: When hr_api.check_integrity_violated Then

949: g_api_dml := false; -- Unset the api dml status
950: --
951: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
952: Exception
953: When hr_api.check_integrity_violated Then
954: -- A check constraint has been violated
955: g_api_dml := false; -- Unset the api dml status
956: constraint_error
957: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 957: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

953: When hr_api.check_integrity_violated Then
954: -- A check constraint has been violated
955: g_api_dml := false; -- Unset the api dml status
956: constraint_error
957: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
958: When hr_api.parent_integrity_violated Then
959: -- Parent integrity has been violated
960: g_api_dml := false; -- Unset the api dml status
961: constraint_error

Line 958: When hr_api.parent_integrity_violated Then

954: -- A check constraint has been violated
955: g_api_dml := false; -- Unset the api dml status
956: constraint_error
957: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
958: When hr_api.parent_integrity_violated Then
959: -- Parent integrity has been violated
960: g_api_dml := false; -- Unset the api dml status
961: constraint_error
962: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 962: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

958: When hr_api.parent_integrity_violated Then
959: -- Parent integrity has been violated
960: g_api_dml := false; -- Unset the api dml status
961: constraint_error
962: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
963: When hr_api.unique_integrity_violated Then
964: -- Unique integrity has been violated
965: g_api_dml := false; -- Unset the api dml status
966: constraint_error

Line 963: When hr_api.unique_integrity_violated Then

959: -- Parent integrity has been violated
960: g_api_dml := false; -- Unset the api dml status
961: constraint_error
962: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
963: When hr_api.unique_integrity_violated Then
964: -- Unique integrity has been violated
965: g_api_dml := false; -- Unset the api dml status
966: constraint_error
967: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 967: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

963: When hr_api.unique_integrity_violated Then
964: -- Unique integrity has been violated
965: g_api_dml := false; -- Unset the api dml status
966: constraint_error
967: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
968: When Others Then
969: g_api_dml := false; -- Unset the api dml status
970: Raise;
971: End insert_dml;

Line 1068: When hr_api.check_integrity_violated Then

1064: --
1065: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
1066: --
1067: Exception
1068: When hr_api.check_integrity_violated Then
1069: -- A check constraint has been violated
1070: g_api_dml := false; -- Unset the api dml status
1071: constraint_error
1072: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 1072: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

1068: When hr_api.check_integrity_violated Then
1069: -- A check constraint has been violated
1070: g_api_dml := false; -- Unset the api dml status
1071: constraint_error
1072: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
1073: When hr_api.parent_integrity_violated Then
1074: -- Parent integrity has been violated
1075: g_api_dml := false; -- Unset the api dml status
1076: constraint_error

Line 1073: When hr_api.parent_integrity_violated Then

1069: -- A check constraint has been violated
1070: g_api_dml := false; -- Unset the api dml status
1071: constraint_error
1072: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
1073: When hr_api.parent_integrity_violated Then
1074: -- Parent integrity has been violated
1075: g_api_dml := false; -- Unset the api dml status
1076: constraint_error
1077: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 1077: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

1073: When hr_api.parent_integrity_violated Then
1074: -- Parent integrity has been violated
1075: g_api_dml := false; -- Unset the api dml status
1076: constraint_error
1077: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
1078: When hr_api.unique_integrity_violated Then
1079: -- Unique integrity has been violated
1080: g_api_dml := false; -- Unset the api dml status
1081: constraint_error

Line 1078: When hr_api.unique_integrity_violated Then

1074: -- Parent integrity has been violated
1075: g_api_dml := false; -- Unset the api dml status
1076: constraint_error
1077: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
1078: When hr_api.unique_integrity_violated Then
1079: -- Unique integrity has been violated
1080: g_api_dml := false; -- Unset the api dml status
1081: constraint_error
1082: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 1082: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

1078: When hr_api.unique_integrity_violated Then
1079: -- Unique integrity has been violated
1080: g_api_dml := false; -- Unset the api dml status
1081: constraint_error
1082: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
1083: When Others Then
1084: g_api_dml := false; -- Unset the api dml status
1085: Raise;
1086: End update_dml;

Line 1145: When hr_api.child_integrity_violated then

1141: --
1142: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
1143: --
1144: Exception
1145: When hr_api.child_integrity_violated then
1146: -- Child integrity has been violated
1147: g_api_dml := false; -- Unset the api dml status
1148: constraint_error
1149: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

Line 1149: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));

1145: When hr_api.child_integrity_violated then
1146: -- Child integrity has been violated
1147: g_api_dml := false; -- Unset the api dml status
1148: constraint_error
1149: (P_CONSTRAINT_NAME => hr_api.strip_constraint_name(SQLERRM));
1150: When Others Then
1151: g_api_dml := false; -- Unset the api dml status
1152: Raise;
1153: End delete_dml;

Line 1456: -- hr_api.mandatory_arg_error

1452: HR_UTILITY.SET_LOCATION('Entering:'||W_PROC, 5);
1453: --
1454: -- Add any mandatory argument checking here:
1455: -- Example:
1456: -- hr_api.mandatory_arg_error
1457: -- (p_api_name => W_PROC,
1458: -- p_argument => 'object_version_number',
1459: -- p_argument_value => p_object_version_number);
1460: --

Line 1482: When HR_Api.Object_Locked then

1478: --
1479: -- We need to trap the ORA LOCK exception
1480: --
1481: Exception
1482: When HR_Api.Object_Locked then
1483: --
1484: -- The object is locked therefore we need to supply a meaningful
1485: -- error message.
1486: --

Line 1654: If (p_rec.business_group_id = hr_api.g_number) then

1650: -- p_rec plsql record structure
1651: -- to see if a system default is being used. If a system default
1652: -- is being used then we must set to the 'current' argument value.
1653: --
1654: If (p_rec.business_group_id = hr_api.g_number) then
1655: p_rec.business_group_id := g_old_rec.business_group_id;
1656: End If;
1657: If (p_rec.active_flag = hr_api.g_varchar2) then
1658: p_rec.active_flag := g_old_rec.active_flag;

Line 1657: If (p_rec.active_flag = hr_api.g_varchar2) then

1653: --
1654: If (p_rec.business_group_id = hr_api.g_number) then
1655: p_rec.business_group_id := g_old_rec.business_group_id;
1656: End If;
1657: If (p_rec.active_flag = hr_api.g_varchar2) then
1658: p_rec.active_flag := g_old_rec.active_flag;
1659: End If;
1660: If (p_rec.default_flag = hr_api.g_varchar2) then
1661: p_rec.default_flag := g_old_rec.default_flag;

Line 1660: If (p_rec.default_flag = hr_api.g_varchar2) then

1656: End If;
1657: If (p_rec.active_flag = hr_api.g_varchar2) then
1658: p_rec.active_flag := g_old_rec.active_flag;
1659: End If;
1660: If (p_rec.default_flag = hr_api.g_varchar2) then
1661: p_rec.default_flag := g_old_rec.default_flag;
1662: End If;
1663: If (p_rec.name = hr_api.g_varchar2) then
1664: p_rec.name := g_old_rec.name;

Line 1663: If (p_rec.name = hr_api.g_varchar2) then

1659: End If;
1660: If (p_rec.default_flag = hr_api.g_varchar2) then
1661: p_rec.default_flag := g_old_rec.default_flag;
1662: End If;
1663: If (p_rec.name = hr_api.g_varchar2) then
1664: p_rec.name := g_old_rec.name;
1665: End If;
1666: If (p_rec.type = hr_api.g_varchar2) then
1667: p_rec.type := g_old_rec.type;

Line 1666: If (p_rec.type = hr_api.g_varchar2) then

1662: End If;
1663: If (p_rec.name = hr_api.g_varchar2) then
1664: p_rec.name := g_old_rec.name;
1665: End If;
1666: If (p_rec.type = hr_api.g_varchar2) then
1667: p_rec.type := g_old_rec.type;
1668: End If;
1669: If (p_rec.comments = hr_api.g_varchar2) then
1670: p_rec.comments := g_old_rec.comments;

Line 1669: If (p_rec.comments = hr_api.g_varchar2) then

1665: End If;
1666: If (p_rec.type = hr_api.g_varchar2) then
1667: p_rec.type := g_old_rec.type;
1668: End If;
1669: If (p_rec.comments = hr_api.g_varchar2) then
1670: p_rec.comments := g_old_rec.comments;
1671: End If;
1672: If (p_rec.description = hr_api.g_varchar2) then
1673: p_rec.description := g_old_rec.description;

Line 1672: If (p_rec.description = hr_api.g_varchar2) then

1668: End If;
1669: If (p_rec.comments = hr_api.g_varchar2) then
1670: p_rec.comments := g_old_rec.comments;
1671: End If;
1672: If (p_rec.description = hr_api.g_varchar2) then
1673: p_rec.description := g_old_rec.description;
1674: End If;
1675: If (p_rec.bst_information_category = hr_api.g_varchar2) then
1676: p_rec.bst_information_category := g_old_rec.bst_information_category;

Line 1675: If (p_rec.bst_information_category = hr_api.g_varchar2) then

1671: End If;
1672: If (p_rec.description = hr_api.g_varchar2) then
1673: p_rec.description := g_old_rec.description;
1674: End If;
1675: If (p_rec.bst_information_category = hr_api.g_varchar2) then
1676: p_rec.bst_information_category := g_old_rec.bst_information_category;
1677: End If;
1678: If (p_rec.bst_information1 = hr_api.g_varchar2) then
1679: p_rec.bst_information1 := g_old_rec.bst_information1;

Line 1678: If (p_rec.bst_information1 = hr_api.g_varchar2) then

1674: End If;
1675: If (p_rec.bst_information_category = hr_api.g_varchar2) then
1676: p_rec.bst_information_category := g_old_rec.bst_information_category;
1677: End If;
1678: If (p_rec.bst_information1 = hr_api.g_varchar2) then
1679: p_rec.bst_information1 := g_old_rec.bst_information1;
1680: End If;
1681: If (p_rec.bst_information2 = hr_api.g_varchar2) then
1682: p_rec.bst_information2 := g_old_rec.bst_information2;

Line 1681: If (p_rec.bst_information2 = hr_api.g_varchar2) then

1677: End If;
1678: If (p_rec.bst_information1 = hr_api.g_varchar2) then
1679: p_rec.bst_information1 := g_old_rec.bst_information1;
1680: End If;
1681: If (p_rec.bst_information2 = hr_api.g_varchar2) then
1682: p_rec.bst_information2 := g_old_rec.bst_information2;
1683: End If;
1684: If (p_rec.bst_information3 = hr_api.g_varchar2) then
1685: p_rec.bst_information3 := g_old_rec.bst_information3;

Line 1684: If (p_rec.bst_information3 = hr_api.g_varchar2) then

1680: End If;
1681: If (p_rec.bst_information2 = hr_api.g_varchar2) then
1682: p_rec.bst_information2 := g_old_rec.bst_information2;
1683: End If;
1684: If (p_rec.bst_information3 = hr_api.g_varchar2) then
1685: p_rec.bst_information3 := g_old_rec.bst_information3;
1686: End If;
1687: If (p_rec.bst_information4 = hr_api.g_varchar2) then
1688: p_rec.bst_information4 := g_old_rec.bst_information4;

Line 1687: If (p_rec.bst_information4 = hr_api.g_varchar2) then

1683: End If;
1684: If (p_rec.bst_information3 = hr_api.g_varchar2) then
1685: p_rec.bst_information3 := g_old_rec.bst_information3;
1686: End If;
1687: If (p_rec.bst_information4 = hr_api.g_varchar2) then
1688: p_rec.bst_information4 := g_old_rec.bst_information4;
1689: End If;
1690: If (p_rec.bst_information5 = hr_api.g_varchar2) then
1691: p_rec.bst_information5 := g_old_rec.bst_information5;

Line 1690: If (p_rec.bst_information5 = hr_api.g_varchar2) then

1686: End If;
1687: If (p_rec.bst_information4 = hr_api.g_varchar2) then
1688: p_rec.bst_information4 := g_old_rec.bst_information4;
1689: End If;
1690: If (p_rec.bst_information5 = hr_api.g_varchar2) then
1691: p_rec.bst_information5 := g_old_rec.bst_information5;
1692: End If;
1693: If (p_rec.bst_information6 = hr_api.g_varchar2) then
1694: p_rec.bst_information6 := g_old_rec.bst_information6;

Line 1693: If (p_rec.bst_information6 = hr_api.g_varchar2) then

1689: End If;
1690: If (p_rec.bst_information5 = hr_api.g_varchar2) then
1691: p_rec.bst_information5 := g_old_rec.bst_information5;
1692: End If;
1693: If (p_rec.bst_information6 = hr_api.g_varchar2) then
1694: p_rec.bst_information6 := g_old_rec.bst_information6;
1695: End If;
1696: If (p_rec.bst_information7 = hr_api.g_varchar2) then
1697: p_rec.bst_information7 := g_old_rec.bst_information7;

Line 1696: If (p_rec.bst_information7 = hr_api.g_varchar2) then

1692: End If;
1693: If (p_rec.bst_information6 = hr_api.g_varchar2) then
1694: p_rec.bst_information6 := g_old_rec.bst_information6;
1695: End If;
1696: If (p_rec.bst_information7 = hr_api.g_varchar2) then
1697: p_rec.bst_information7 := g_old_rec.bst_information7;
1698: End If;
1699: If (p_rec.bst_information8 = hr_api.g_varchar2) then
1700: p_rec.bst_information8 := g_old_rec.bst_information8;

Line 1699: If (p_rec.bst_information8 = hr_api.g_varchar2) then

1695: End If;
1696: If (p_rec.bst_information7 = hr_api.g_varchar2) then
1697: p_rec.bst_information7 := g_old_rec.bst_information7;
1698: End If;
1699: If (p_rec.bst_information8 = hr_api.g_varchar2) then
1700: p_rec.bst_information8 := g_old_rec.bst_information8;
1701: End If;
1702: If (p_rec.bst_information9 = hr_api.g_varchar2) then
1703: p_rec.bst_information9 := g_old_rec.bst_information9;

Line 1702: If (p_rec.bst_information9 = hr_api.g_varchar2) then

1698: End If;
1699: If (p_rec.bst_information8 = hr_api.g_varchar2) then
1700: p_rec.bst_information8 := g_old_rec.bst_information8;
1701: End If;
1702: If (p_rec.bst_information9 = hr_api.g_varchar2) then
1703: p_rec.bst_information9 := g_old_rec.bst_information9;
1704: End If;
1705: If (p_rec.bst_information10 = hr_api.g_varchar2) then
1706: p_rec.bst_information10 := g_old_rec.bst_information10;

Line 1705: If (p_rec.bst_information10 = hr_api.g_varchar2) then

1701: End If;
1702: If (p_rec.bst_information9 = hr_api.g_varchar2) then
1703: p_rec.bst_information9 := g_old_rec.bst_information9;
1704: End If;
1705: If (p_rec.bst_information10 = hr_api.g_varchar2) then
1706: p_rec.bst_information10 := g_old_rec.bst_information10;
1707: End If;
1708: If (p_rec.bst_information11 = hr_api.g_varchar2) then
1709: p_rec.bst_information11 := g_old_rec.bst_information11;

Line 1708: If (p_rec.bst_information11 = hr_api.g_varchar2) then

1704: End If;
1705: If (p_rec.bst_information10 = hr_api.g_varchar2) then
1706: p_rec.bst_information10 := g_old_rec.bst_information10;
1707: End If;
1708: If (p_rec.bst_information11 = hr_api.g_varchar2) then
1709: p_rec.bst_information11 := g_old_rec.bst_information11;
1710: End If;
1711: If (p_rec.bst_information12 = hr_api.g_varchar2) then
1712: p_rec.bst_information12 := g_old_rec.bst_information12;

Line 1711: If (p_rec.bst_information12 = hr_api.g_varchar2) then

1707: End If;
1708: If (p_rec.bst_information11 = hr_api.g_varchar2) then
1709: p_rec.bst_information11 := g_old_rec.bst_information11;
1710: End If;
1711: If (p_rec.bst_information12 = hr_api.g_varchar2) then
1712: p_rec.bst_information12 := g_old_rec.bst_information12;
1713: End If;
1714: If (p_rec.bst_information13 = hr_api.g_varchar2) then
1715: p_rec.bst_information13 := g_old_rec.bst_information13;

Line 1714: If (p_rec.bst_information13 = hr_api.g_varchar2) then

1710: End If;
1711: If (p_rec.bst_information12 = hr_api.g_varchar2) then
1712: p_rec.bst_information12 := g_old_rec.bst_information12;
1713: End If;
1714: If (p_rec.bst_information13 = hr_api.g_varchar2) then
1715: p_rec.bst_information13 := g_old_rec.bst_information13;
1716: End If;
1717: If (p_rec.bst_information14 = hr_api.g_varchar2) then
1718: p_rec.bst_information14 := g_old_rec.bst_information14;

Line 1717: If (p_rec.bst_information14 = hr_api.g_varchar2) then

1713: End If;
1714: If (p_rec.bst_information13 = hr_api.g_varchar2) then
1715: p_rec.bst_information13 := g_old_rec.bst_information13;
1716: End If;
1717: If (p_rec.bst_information14 = hr_api.g_varchar2) then
1718: p_rec.bst_information14 := g_old_rec.bst_information14;
1719: End If;
1720: If (p_rec.bst_information15 = hr_api.g_varchar2) then
1721: p_rec.bst_information15 := g_old_rec.bst_information15;

Line 1720: If (p_rec.bst_information15 = hr_api.g_varchar2) then

1716: End If;
1717: If (p_rec.bst_information14 = hr_api.g_varchar2) then
1718: p_rec.bst_information14 := g_old_rec.bst_information14;
1719: End If;
1720: If (p_rec.bst_information15 = hr_api.g_varchar2) then
1721: p_rec.bst_information15 := g_old_rec.bst_information15;
1722: End If;
1723: If (p_rec.bst_information16 = hr_api.g_varchar2) then
1724: p_rec.bst_information16 := g_old_rec.bst_information16;

Line 1723: If (p_rec.bst_information16 = hr_api.g_varchar2) then

1719: End If;
1720: If (p_rec.bst_information15 = hr_api.g_varchar2) then
1721: p_rec.bst_information15 := g_old_rec.bst_information15;
1722: End If;
1723: If (p_rec.bst_information16 = hr_api.g_varchar2) then
1724: p_rec.bst_information16 := g_old_rec.bst_information16;
1725: End If;
1726: If (p_rec.bst_information17 = hr_api.g_varchar2) then
1727: p_rec.bst_information17 := g_old_rec.bst_information17;

Line 1726: If (p_rec.bst_information17 = hr_api.g_varchar2) then

1722: End If;
1723: If (p_rec.bst_information16 = hr_api.g_varchar2) then
1724: p_rec.bst_information16 := g_old_rec.bst_information16;
1725: End If;
1726: If (p_rec.bst_information17 = hr_api.g_varchar2) then
1727: p_rec.bst_information17 := g_old_rec.bst_information17;
1728: End If;
1729: If (p_rec.bst_information18 = hr_api.g_varchar2) then
1730: p_rec.bst_information18 := g_old_rec.bst_information18;

Line 1729: If (p_rec.bst_information18 = hr_api.g_varchar2) then

1725: End If;
1726: If (p_rec.bst_information17 = hr_api.g_varchar2) then
1727: p_rec.bst_information17 := g_old_rec.bst_information17;
1728: End If;
1729: If (p_rec.bst_information18 = hr_api.g_varchar2) then
1730: p_rec.bst_information18 := g_old_rec.bst_information18;
1731: End If;
1732: If (p_rec.bst_information19 = hr_api.g_varchar2) then
1733: p_rec.bst_information19 := g_old_rec.bst_information19;

Line 1732: If (p_rec.bst_information19 = hr_api.g_varchar2) then

1728: End If;
1729: If (p_rec.bst_information18 = hr_api.g_varchar2) then
1730: p_rec.bst_information18 := g_old_rec.bst_information18;
1731: End If;
1732: If (p_rec.bst_information19 = hr_api.g_varchar2) then
1733: p_rec.bst_information19 := g_old_rec.bst_information19;
1734: End If;
1735: If (p_rec.bst_information20 = hr_api.g_varchar2) then
1736: p_rec.bst_information20 := g_old_rec.bst_information20;

Line 1735: If (p_rec.bst_information20 = hr_api.g_varchar2) then

1731: End If;
1732: If (p_rec.bst_information19 = hr_api.g_varchar2) then
1733: p_rec.bst_information19 := g_old_rec.bst_information19;
1734: End If;
1735: If (p_rec.bst_information20 = hr_api.g_varchar2) then
1736: p_rec.bst_information20 := g_old_rec.bst_information20;
1737: End If;
1738: --
1739: -- Return the plsql record structure.

Line 1784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1780: HR_UTILITY.SET_LOCATION('Entering:'||W_PROC, 5);
1781: --
1782: -- Call all supporting business operations
1783: --
1784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1785: --
1786: VALIDITY_CHECK (
1787: P_REC => P_REC);
1788: --

Line 1835: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1831: HR_UTILITY.SET_LOCATION('Entering:'||W_PROC, 5);
1832: --
1833: -- Call all supporting business operations
1834: --
1835: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1836: --
1837: if l_default_flag_changed then
1838: VALIDITY_CHECK (
1839: P_REC => P_REC);

Line 1938: Raise HR_Api.Validate_Enabled;

1934: --
1935: -- If we are validating then raise the Validate_Enabled exception
1936: --
1937: If p_validate then
1938: Raise HR_Api.Validate_Enabled;
1939: End If;
1940: --
1941: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
1942: Exception

Line 1943: When HR_Api.Validate_Enabled Then

1939: End If;
1940: --
1941: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
1942: Exception
1943: When HR_Api.Validate_Enabled Then
1944: --
1945: -- As the Validate_Enabled exception has been raised
1946: -- we must rollback to the savepoint
1947: --

Line 2101: Raise HR_Api.Validate_Enabled;

2097: --
2098: -- If we are validating then raise the Validate_Enabled exception
2099: --
2100: If p_validate then
2101: Raise HR_Api.Validate_Enabled;
2102: End If;
2103: --
2104: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
2105: Exception

Line 2106: When HR_Api.Validate_Enabled Then

2102: End If;
2103: --
2104: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
2105: Exception
2106: When HR_Api.Validate_Enabled Then
2107: --
2108: -- As the Validate_Enabled exception has been raised
2109: -- we must rollback to the savepoint
2110: --

Line 2256: Raise HR_Api.Validate_Enabled;

2252: --
2253: -- If we are validating then raise the Validate_Enabled exception
2254: --
2255: If p_validate then
2256: Raise HR_Api.Validate_Enabled;
2257: End If;
2258: --
2259: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
2260: Exception

Line 2261: When HR_Api.Validate_Enabled Then

2257: End If;
2258: --
2259: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);
2260: Exception
2261: When HR_Api.Validate_Enabled Then
2262: --
2263: -- As the Validate_Enabled exception has been raised
2264: -- we must rollback to the savepoint
2265: --