DBA Data[Home] [Help]

APPS.HZ_DSS_GROUPS_PUB dependencies on STANDARD

Line 178: -- standard start of API savepoint

174: rank number;
175: temp number;
176: BEGIN
177:
178: -- standard start of API savepoint
179: SAVEPOINT create_group;
180:
181: -- initialize message list if p_init_msg_list is set to TRUE.
182: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 295: -- standard call to get message count and if count is 1, get message info.

291: x_bes_enable_flag => nvl(p_dss_group.bes_enable_flag,'Y'),
292: x_object_version_number => 1);
293:
294:
295: -- standard call to get message count and if count is 1, get message info.
296: FND_MSG_PUB.Count_And_Get(
297: p_encoded => FND_API.G_FALSE,
298: p_count => x_msg_count,
299: p_data => x_msg_data);

Line 379: -- standard start of API savepoint

375:
376: -- initialize API return status to success.
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: -- standard start of API savepoint
380: SAVEPOINT update_group;
381:
382: --Non updateable to null
383: IF ( p_dss_group.dss_group_code IS NULL OR

Line 570: -- standard call to get message count and if count is 1, get message info.

566: x_bes_enable_flag => p_dss_group.bes_enable_flag,
567: x_object_version_number => x_object_version_number
568: );
569:
570: -- standard call to get message count and if count is 1, get message info.
571: FND_MSG_PUB.Count_And_Get(
572: p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data);

Line 644: -- standard start of API savepoint

640: row_id varchar2(64);
641: l_dup_count NUMBER := 0;
642: BEGIN
643:
644: -- standard start of API savepoint
645: SAVEPOINT create_secured_module ;
646:
647: -- initialize message list if p_init_msg_list is set to TRUE.
648: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 731: -- standard call to get message count and if count is 1, get message info.

727: x_owner_table_id2 => p_dss_secured_module.created_by_module ,
728: x_object_version_number => 1 );
729:
730:
731: -- standard call to get message count and if count is 1, get message info.
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_msg_count,
735: p_data => x_msg_data);

Line 810: -- standard start of API savepoint

806:
807: -- initialize API return status to success.
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: -- standard start of API savepoint
811: SAVEPOINT update_secured_module ;
812:
813: -- check whether record has been updated by another user. If not, lock it.
814: BEGIN

Line 893: -- standard call to get message count and if count is 1, get message info.

889: x_owner_table_id1 => 'HZ_CREATED_BY_MODULES',
890: x_owner_table_id2 => p_dss_secured_module.created_by_module ,
891: x_object_version_number => x_object_version_number);
892:
893: -- standard call to get message count and if count is 1, get message info.
894: FND_MSG_PUB.Count_And_Get(
895: p_encoded => FND_API.G_FALSE,
896: p_count => x_msg_count,
897: p_data => x_msg_data);

Line 966: -- standard start of API savepoint

962: l_dss_secured_module HZ_DSS_GROUPS_PUB.dss_secured_module_type;
963:
964: BEGIN
965:
966: -- standard start of API savepoint
967: SAVEPOINT create_secured_criterion ;
968:
969: -- initialize message list if p_init_msg_list is set to TRUE.
970: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1043: -- standard call to get message count and if count is 1, get message info.

1039:
1040: END IF;
1041:
1042:
1043: -- standard call to get message count and if count is 1, get message info.
1044: FND_MSG_PUB.Count_And_Get(
1045: p_encoded => FND_API.G_FALSE,
1046: p_count => x_msg_count,
1047: p_data => x_msg_data);

Line 1122: -- standard start of API savepoint

1118:
1119: -- initialize API return status to success.
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121:
1122: -- standard start of API savepoint
1123: SAVEPOINT update_secured_criterion ;
1124:
1125: -- check whether record has been updated by another user. If not, lock it.
1126: BEGIN

Line 1203: -- standard call to get message count and if count is 1, get message info.

1199:
1200: x_object_version_number := nvl(l_object_version_number, 1) + 1;
1201:
1202: END IF;
1203: -- standard call to get message count and if count is 1, get message info.
1204: FND_MSG_PUB.Count_And_Get(
1205: p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);

Line 1277: -- standard start of API savepoint

1273: row_id varchar2(64);
1274: l_dup_count NUMBER := 0;
1275: BEGIN
1276:
1277: -- standard start of API savepoint
1278: SAVEPOINT create_secured_classification ;
1279:
1280: -- initialize message list if p_init_msg_list is set to TRUE.
1281: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1381: -- standard call to get message count and if count is 1, get message info.

1377: x_owner_table_id2 => p_dss_secured_class.class_code,
1378: x_object_version_number => 1);
1379:
1380:
1381: -- standard call to get message count and if count is 1, get message info.
1382: FND_MSG_PUB.Count_And_Get(
1383: p_encoded => FND_API.G_FALSE,
1384: p_count => x_msg_count,
1385: p_data => x_msg_data);

Line 1464: -- standard start of API savepoint

1460:
1461: -- initialize API return status to success.
1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463:
1464: -- standard start of API savepoint
1465: SAVEPOINT update_secured_classification ;
1466:
1467: -- check whether record has been updated by another user. If not, lock it.
1468:

Line 1547: -- standard call to get message count and if count is 1, get message info.

1543: x_owner_table_id2 => p_dss_secured_class.class_code,
1544: x_object_version_number => x_object_version_number
1545: );
1546:
1547: -- standard call to get message count and if count is 1, get message info.
1548: FND_MSG_PUB.Count_And_Get(
1549: p_encoded => FND_API.G_FALSE,
1550: p_count => x_msg_count,
1551: p_data => x_msg_data);

Line 1623: -- standard start of API savepoint

1619: l_rel_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
1620:
1621: BEGIN
1622:
1623: -- standard start of API savepoint
1624: SAVEPOINT create_secured_rel_type ;
1625:
1626: -- initialize message list if p_init_msg_list is set to TRUE.
1627: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1713: -- standard call to get message count and if count is 1, get message info.

1709: x_owner_table_id1 => p_dss_secured_rel_type.relationship_type_id,
1710: x_object_version_number => 1);
1711:
1712:
1713: -- standard call to get message count and if count is 1, get message info.
1714: FND_MSG_PUB.Count_And_Get(
1715: p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data);

Line 1793: -- standard start of API savepoint

1789:
1790: -- initialize API return status to success.
1791: x_return_status := FND_API.G_RET_STS_SUCCESS;
1792:
1793: -- standard start of API savepoint
1794: SAVEPOINT update_secured_rel_type ;
1795:
1796: -- check whether record has been updated by another user. If not, lock it.
1797:

Line 1867: -- standard call to get message count and if count is 1, get message info.

1863: x_owner_table_id1 => p_dss_secured_rel_type.relationship_type_id,
1864: x_object_version_number => x_object_version_number);
1865:
1866:
1867: -- standard call to get message count and if count is 1, get message info.
1868: FND_MSG_PUB.Count_And_Get(
1869: p_encoded => FND_API.G_FALSE,
1870: p_count => x_msg_count,
1871: p_data => x_msg_data);

Line 1938: -- standard start of API savepoint

1934: IS
1935: row_id varchar2(64);
1936: BEGIN
1937:
1938: -- standard start of API savepoint
1939: SAVEPOINT create_assignment ;
1940:
1941: -- initialize message list if p_init_msg_list is set to TRUE.
1942: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1993: -- standard call to get message count and if count is 1, get message info.

1989: x_object_version_number => 1
1990: );
1991:
1992:
1993: -- standard call to get message count and if count is 1, get message info.
1994: FND_MSG_PUB.Count_And_Get(
1995: p_encoded => FND_API.G_FALSE,
1996: p_count => x_msg_count,
1997: p_data => x_msg_data);

Line 2058: -- standard start of API savepoint

2054: IS
2055: row_id varchar2(64);
2056: BEGIN
2057:
2058: -- standard start of API savepoint
2059: SAVEPOINT delete_assignment ;
2060:
2061: -- initialize message list if p_init_msg_list is set to TRUE.
2062: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2084: -- standard call to get message count and if count is 1, get message info.

2080: x_assignment_id => p_assignment_id
2081: );
2082:
2083:
2084: -- standard call to get message count and if count is 1, get message info.
2085: FND_MSG_PUB.Count_And_Get(
2086: p_encoded => FND_API.G_FALSE,
2087: p_count => x_msg_count,
2088: p_data => x_msg_data);

Line 2160: -- standard start of API savepoint

2156: l_dss_ois_name varchar2(30);
2157: l_dup_ois_cnt number;
2158: BEGIN
2159:
2160: -- standard start of API savepoint
2161: SAVEPOINT create_secured_entity ;
2162:
2163: -- initialize message list if p_init_msg_list is set to TRUE.
2164: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2320: -- standard call to get message count and if count is 1, get message info.

2316:
2317: --Bug#2620405 Instance set ID is not getting returned
2318: x_dss_instance_set_id := l_dss_instance_set_id;
2319:
2320: -- standard call to get message count and if count is 1, get message info.
2321: FND_MSG_PUB.Count_And_Get(
2322: p_encoded => FND_API.G_FALSE,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data);

Line 2400: -- standard start of API savepoint

2396:
2397: -- initialize API return status to success.
2398: x_return_status := FND_API.G_RET_STS_SUCCESS;
2399:
2400: -- standard start of API savepoint
2401: SAVEPOINT update_secured_entity ;
2402:
2403: -- check whether record has been updated by another user. If not, lock it.
2404: BEGIN

Line 2482: -- standard call to get message count and if count is 1, get message info.

2478: x_dss_instance_set_id => l_dss_instance_set_id ,
2479: x_object_version_number => x_object_version_number
2480: ) ;
2481:
2482: -- standard call to get message count and if count is 1, get message info.
2483: FND_MSG_PUB.Count_And_Get(
2484: p_encoded => FND_API.G_FALSE,
2485: p_count => x_msg_count,
2486: p_data => x_msg_data);