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.HZ_DSS_GROUPS_PUB dependencies on HZ_DSS_VALIDATE_PKG

Line 55: IF HZ_DSS_VALIDATE_PKG.return_no_of_dss_groups > 0

51: result NUMBER ;
52: BEGIN
53: OPEN c0;
54: FETCH c0 INTO result ;
55: IF HZ_DSS_VALIDATE_PKG.return_no_of_dss_groups > 0
56: THEN
57: result := result -1 ;
58: END IF;
59: CLOSE c0;

Line 211: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.dss_group_code) = 'Y'

207:
208:
209: -- VALIDATION
210: -- PASSED IN GROUP CODE SHOULD BE UNIQUE
211: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.dss_group_code) = 'Y'
212: THEN
213: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_EXISTS_ALREADY');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;

Line 224: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.order_before_group_code) = 'N'

220:
221: IF p_dss_group.order_before_group_code IS NOT NULL AND
222: p_dss_group.order_before_group_code <> FND_API.G_MISS_CHAR
223: THEN
224: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.order_before_group_code) = 'N'
225: THEN
226: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ORD_BEF_GR_CODE_INVALID');
227: FND_MSG_PUB.ADD;
228: RAISE FND_API.G_EXC_ERROR;

Line 234: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_vl (p_dss_group.dss_group_name) = 'Y'

230: END IF;
231:
232:
233: -- PASSED IN GROUP NAME SHOULD BE UNIQUE IN AN MLS LANGUAGE
234: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_vl (p_dss_group.dss_group_name) = 'Y'
235: THEN
236: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_NAME_EXISTS_ALREADY');
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;

Line 245: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

241:
242: -- STATUS VALIDATION
243:
244: IF p_dss_group.status is not null then
245: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
246: p_dss_group.status, 'REGISTRY_STATUS')= 'N' THEN
247: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
248: FND_MSG_PUB.ADD;
249: RAISE FND_API.G_EXC_ERROR;

Line 274: IF HZ_DSS_VALIDATE_PKG.return_no_of_dss_groups > 0

270: -- SINCE WE WANT TO INSERT LAST, WE NEED TO INCREMENT MAX RANK BY 1.
271: -- THE ONLY EXCEPTION TO THIS RULE, IS WHEN WE HAVE NO ROWS AND
272: -- WE WANT TO ADD A NEW ROW.
273: ELSE
274: IF HZ_DSS_VALIDATE_PKG.return_no_of_dss_groups > 0
275: THEN
276: rank := return_max_rank + 1 ;
277: ELSE
278: rank := return_max_rank ;

Line 437: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.dss_group_code) = 'N' THEN

433: -- VALIDATION
434: -- PASSED IN GROUP CODE SHOULD BE VALID
435: -- already validated when getting object_version_number.
436: /*
437: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.dss_group_code) = 'N' THEN
438: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
439: FND_MSG_PUB.ADD;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;

Line 450: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (

446:
447: IF p_dss_group.order_before_group_code IS NOT NULL AND
448: p_dss_group.order_before_group_code <> FND_API.G_MISS_CHAR
449: THEN
450: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (
451: p_dss_group.order_before_group_code) = 'N'
452: THEN
453: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ORD_BEF_GR_CODE_INVALID');
454: FND_MSG_PUB.ADD;

Line 461: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_vl (

457: END IF;
458:
459: -- PASSED IN GROUP NAME SHOULD BE UNIQUE IN AN MLS LANGUAGE
460: IF p_dss_group.dss_group_name IS NOT NULL THEN
461: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_vl (
462: p_dss_group.dss_group_name, p_dss_group.dss_group_code) = 'Y'
463: THEN
464: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_NAME_EXISTS_ALREADY');
465: FND_MSG_PUB.ADD;

Line 473: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

469:
470: -- STATUS VALIDATION
471:
472: IF p_dss_group.status IS NOT NULL THEN
473: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
474: p_dss_group.status,
475: 'REGISTRY_STATUS')= 'N'
476: THEN
477: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

Line 674: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (

670: END IF;
671:
672:
673: -- DSG validation
674: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (
675: p_dss_secured_module.dss_group_code) = 'N'
676: THEN
677: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
678: FND_MSG_PUB.ADD;

Line 684: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

680: END IF;
681:
682: -- status validation
683: IF p_dss_secured_module.status is not null then
684: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
685: p_dss_secured_module.status, 'REGISTRY_STATUS')= 'N' THEN
686: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
687: FND_MSG_PUB.ADD;
688: RAISE FND_API.G_EXC_ERROR;

Line 693: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups_gl(

689: END IF;
690: END IF;
691:
692: ---created_by_module validation
693: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups_gl(
694: p_dss_secured_module.created_by_module, 'HZ_CREATED_BY_MODULES') ='N'
695: THEN
696: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CREATED_MODULE_INVALID');
697: FND_MSG_PUB.ADD;

Line 861: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

857: END IF;
858:
859: -- status validation
860: IF p_dss_secured_module.status is not null then
861: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
862: p_dss_secured_module.status, 'REGISTRY_STATUS')= 'N' THEN
863: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
864: FND_MSG_PUB.ADD;
865: RAISE FND_API.G_EXC_ERROR;

Line 872: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

868:
869: /*
870: ---created_by_module validation
871: IF p_dss_secured_module.created_by_module is not null then
872: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
873: p_dss_secured_module.created_by_module, 'HZ_CREATED_BY_MODULES') ='N'
874: THEN
875: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CREATED_MODULE_INVALID');
876: FND_MSG_PUB.ADD;

Line 1010: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (

1006: END IF;
1007:
1008: -- VALIDATION
1009: -- PASSED IN GROUP CODE SHOULD BE VALID
1010: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (
1011: p_dss_secured_criterion.dss_group_code) = 'N'
1012: THEN
1013: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1014: FND_MSG_PUB.ADD;

Line 1020: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

1016: END IF;
1017:
1018: -- STATUS VALIDATION
1019: IF p_dss_secured_criterion.status is not null then
1020: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
1021: p_dss_secured_criterion.status, 'REGISTRY_STATUS')= 'N' THEN
1022: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1023: FND_MSG_PUB.ADD;
1024: RAISE FND_API.G_EXC_ERROR;

Line 1179: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

1175:
1176: -- STATUS VALIDATION
1177:
1178: IF p_dss_secured_criterion.status is not null then
1179: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
1180: p_dss_secured_criterion.status, 'REGISTRY_STATUS')= 'N'
1181: THEN
1182: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1183: FND_MSG_PUB.ADD;

Line 1316: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_class.dss_group_code) = 'N'

1312:
1313: -- VALIDATION
1314:
1315: -- PASSED IN GROUP CODE SHOULD BE VALID
1316: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_class.dss_group_code) = 'N'
1317: THEN
1318: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;

Line 1324: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_class_categories (p_dss_secured_class.class_category) = 'N'

1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: -- PASSED IN CLASS CATEGORY SHOULD BE VALID
1324: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_class_categories (p_dss_secured_class.class_category) = 'N'
1325: THEN
1326: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CL_CATEGORY_INVALID');
1327: FND_MSG_PUB.ADD;
1328: RAISE FND_API.G_EXC_ERROR;

Line 1332: IF HZ_DSS_VALIDATE_PKG.exist_in_fnd_lookups(p_dss_secured_class.class_code,p_dss_secured_class.class_category ) = 'N'

1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330:
1331: -- PASSED IN CLASS CODE SHOULD BE VALID
1332: IF HZ_DSS_VALIDATE_PKG.exist_in_fnd_lookups(p_dss_secured_class.class_code,p_dss_secured_class.class_category ) = 'N'
1333: THEN
1334: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CL_CODE_INVALID');
1335: FND_MSG_PUB.ADD;
1336: RAISE FND_API.G_EXC_ERROR;

Line 1342: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_class.status,

1338:
1339:
1340: -- STATUS VALIDATION
1341: IF p_dss_secured_class.status is not null then
1342: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_class.status,
1343: 'REGISTRY_STATUS')= 'N' THEN
1344: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1345: FND_MSG_PUB.ADD;
1346: RAISE FND_API.G_EXC_ERROR;

Line 1528: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_class.status,

1524:
1525:
1526: -- STATUS VALIDATION
1527: IF p_dss_secured_class.status is not null then
1528: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_class.status,
1529: 'REGISTRY_STATUS')= 'N' THEN
1530: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;

Line 1654: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_rel_type.dss_group_code) = 'N'

1650:
1651:
1652:
1653: -- PASSED IN GROUP CODE SHOULD BE VALID
1654: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_rel_type.dss_group_code) = 'N'
1655: THEN
1656: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1657: FND_MSG_PUB.ADD;
1658: RAISE FND_API.G_EXC_ERROR;

Line 1662: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_relationship_types (p_dss_secured_rel_type.relationship_type_id) = 'N'

1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:
1661: -- PASSED IN RELATIONSHIP_TYPE_ID SHOULD BE VALID
1662: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_relationship_types (p_dss_secured_rel_type.relationship_type_id) = 'N'
1663: THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_REL_TYPE_ID_INVALID');
1665: FND_MSG_PUB.ADD;
1666: RAISE FND_API.G_EXC_ERROR;

Line 1672: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_rel_type.status,

1668:
1669:
1670: -- STATUS VALIDATION
1671: IF p_dss_secured_rel_type.status is not null then
1672: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_rel_type.status,
1673: 'REGISTRY_STATUS')= 'N' THEN
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;

Line 1848: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_rel_type.status,

1844:
1845: -- STATUS VALIDATION
1846:
1847: IF p_dss_secured_rel_type.status is not null then
1848: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_rel_type.status,
1849: 'REGISTRY_STATUS')= 'N' THEN
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.G_EXC_ERROR;

Line 1951: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_assignment.dss_group_code) = 'N'

1947: x_return_status := FND_API.G_RET_STS_SUCCESS;
1948:
1949: -- VALIDATION
1950: -- PASSED IN GROUP CODE SHOULD BE VALID
1951: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_assignment.dss_group_code) = 'N'
1952: THEN
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1954: FND_MSG_PUB.ADD;
1955: RAISE FND_API.G_EXC_ERROR;

Line 1959: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_dss_assignment.owner_table_name) = 'N'

1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:
1958: -- OWNER TABLE NAME VALIDATION
1959: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_dss_assignment.owner_table_name) = 'N'
1960: THEN
1961: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OWN_TABLE_NAME_INVALID');
1962: FND_MSG_PUB.ADD;
1963: RAISE FND_API.G_EXC_ERROR;

Line 1968: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_assignment.status, 'REGISTRY_STATUS')= 'N'

1964: END IF;
1965:
1966: -- STATUS VALIDATION
1967:
1968: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_assignment.status, 'REGISTRY_STATUS')= 'N'
1969: THEN
1970: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1971: FND_MSG_PUB.ADD;
1972: RAISE FND_API.G_EXC_ERROR;

Line 2071: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_assignments(p_assignment_id) = 'N'

2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068:
2069: -- VALIDATION
2070: -- PASSED IN ASSIGNMENT ID SHOULD BE VALID
2071: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_assignments(p_assignment_id) = 'N'
2072: THEN
2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ASS_ID_INVALID');
2074: FND_MSG_PUB.ADD;
2075: RAISE FND_API.G_EXC_ERROR;

Line 2191: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_entity.dss_group_code) = 'N'

2187:
2188:
2189: -- VALIDATION
2190: -- PASSED IN GROUP CODE SHOULD BE VALID
2191: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_entity.dss_group_code) = 'N'
2192: THEN
2193: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
2194: FND_MSG_PUB.ADD;
2195: RAISE FND_API.G_EXC_ERROR;

Line 2199: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_dss_secured_entity.entity_id ) = 'N'

2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;
2197:
2198: -- ENTITY ID VALIDATION
2199: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_dss_secured_entity.entity_id ) = 'N'
2200: THEN
2201: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ENT_ID_INVALID');
2202: FND_MSG_PUB.ADD;
2203: RAISE FND_API.G_EXC_ERROR;

Line 2208: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_entity.status,

2204: END IF;
2205:
2206: -- STATUS VALIDATION
2207: IF p_dss_secured_entity.status is not null then
2208: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_entity.status,
2209: 'REGISTRY_STATUS')= 'N' THEN
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;

Line 2248: IF HZ_DSS_VALIDATE_PKG.is_an_obj_id_in_dss_entities(p_dss_secured_entity.entity_id) = 'Y'

2244:
2245: -- If there is an object id (non null) corresponding to the given entity id
2246: -- in HZ_DSS_ENTITIIES, grab it
2247:
2248: IF HZ_DSS_VALIDATE_PKG.is_an_obj_id_in_dss_entities(p_dss_secured_entity.entity_id) = 'Y'
2249: THEN
2250: l_object_id := HZ_DSS_VALIDATE_PKG.get_object_id_entities
2251: (p_dss_secured_entity.entity_id);
2252: -- Else get the object instance set id that corresponds to the entity id, go to fnd grants and get the

Line 2250: l_object_id := HZ_DSS_VALIDATE_PKG.get_object_id_entities

2246: -- in HZ_DSS_ENTITIIES, grab it
2247:
2248: IF HZ_DSS_VALIDATE_PKG.is_an_obj_id_in_dss_entities(p_dss_secured_entity.entity_id) = 'Y'
2249: THEN
2250: l_object_id := HZ_DSS_VALIDATE_PKG.get_object_id_entities
2251: (p_dss_secured_entity.entity_id);
2252: -- Else get the object instance set id that corresponds to the entity id, go to fnd grants and get the
2253: -- object id
2254: ELSE

Line 2255: l_instance_set_id := HZ_DSS_VALIDATE_PKG.get_instance_set_id_entities

2251: (p_dss_secured_entity.entity_id);
2252: -- Else get the object instance set id that corresponds to the entity id, go to fnd grants and get the
2253: -- object id
2254: ELSE
2255: l_instance_set_id := HZ_DSS_VALIDATE_PKG.get_instance_set_id_entities
2256: (p_dss_secured_entity.entity_id);
2257: l_object_id := HZ_DSS_VALIDATE_PKG.get_object_id_fnd_ins_sets
2258: (l_instance_set_id);
2259: END IF;

Line 2257: l_object_id := HZ_DSS_VALIDATE_PKG.get_object_id_fnd_ins_sets

2253: -- object id
2254: ELSE
2255: l_instance_set_id := HZ_DSS_VALIDATE_PKG.get_instance_set_id_entities
2256: (p_dss_secured_entity.entity_id);
2257: l_object_id := HZ_DSS_VALIDATE_PKG.get_object_id_fnd_ins_sets
2258: (l_instance_set_id);
2259: END IF;
2260:
2261:

Line 2435: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups (

2431:
2432: -- STATUS VALIDATION
2433:
2434: IF p_dss_secured_entity.status IS NOT NULL THEN
2435: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups (
2436: p_dss_secured_entity.status,
2437: 'REGISTRY_STATUS')= 'N'
2438: THEN
2439: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');