DBA Data[Home] [Help]

APPS.HZ_DSS_SETUP_PUB dependencies on HZ_DSS_VALIDATE_PKG

Line 74: IF HZ_DSS_VALIDATE_PKG.exist_fnd_object_id(p_dss_entity_profile.object_id)= 'N'

70: END IF;
71:
72: IF p_dss_entity_profile.object_id IS NOT NULL
73: THEN
74: IF HZ_DSS_VALIDATE_PKG.exist_fnd_object_id(p_dss_entity_profile.object_id)= 'N'
75: THEN
76: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OBJ_ID_INVALID');
77: FND_MSG_PUB.ADD;
78: RAISE FND_API.G_EXC_ERROR;

Line 84: IF HZ_DSS_VALIDATE_PKG.exist_fnd_instance_set_id(p_dss_entity_profile.instance_set_id) = 'N'

80: END IF;
81:
82: IF p_dss_entity_profile.instance_set_id IS NOT NULL
83: THEN
84: IF HZ_DSS_VALIDATE_PKG.exist_fnd_instance_set_id(p_dss_entity_profile.instance_set_id) = 'N'
85: THEN
86: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INS_SET_ID_INVALID');
87: FND_MSG_PUB.ADD;
88: RAISE FND_API.G_EXC_ERROR;

Line 94: IF HZ_DSS_VALIDATE_PKG.exist_entity_id(p_dss_entity_profile.parent_entity_id) = 'N'

90: END IF;
91:
92: IF p_dss_entity_profile.parent_entity_id IS NOT NULL
93: THEN
94: IF HZ_DSS_VALIDATE_PKG.exist_entity_id(p_dss_entity_profile.parent_entity_id) = 'N'
95: THEN
96: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_PAR_ENT_ID_INVALID');
97: FND_MSG_PUB.ADD;
98: RAISE FND_API.G_EXC_ERROR;

Line 104: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

100: END IF;
101:
102: -- STATUS VALIDATION
103: IF p_dss_entity_profile.status is not null then
104: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
105: p_dss_entity_profile.status, 'REGISTRY_STATUS')= 'N'
106: THEN
107: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
108: FND_MSG_PUB.ADD;

Line 122: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_entity_profile.

118: FND_MSG_PUB.ADD;
119: RAISE FND_API.G_EXC_ERROR;
120: ELSE
121:
122: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_entity_profile.
123: group_assignment_level, 'HZ_DSS_GROUP_ASSIGN_LEVELS') = 'N'
124: THEN
125: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_ASS_LEVEL_INVALID');
126: FND_MSG_PUB.ADD;

Line 266: IF HZ_DSS_VALIDATE_PKG.exist_entity_id(

262:
263: -- Bug: 2620112 VALIDATION parent Entity ID is valid
264: IF p_dss_entity_profile.parent_entity_id IS NOT NULL
265: THEN
266: IF HZ_DSS_VALIDATE_PKG.exist_entity_id(
267: p_dss_entity_profile.parent_entity_id) = 'N'
268: THEN
269: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_PAR_ENT_ID_INVALID');
270: FND_MSG_PUB.ADD;

Line 284: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

280: RAISE FND_API.G_EXC_ERROR;
281: end if;
282:
283: if p_dss_entity_profile.group_assignment_level is not null then
284: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
285: p_dss_entity_profile.group_assignment_level,
286: 'HZ_DSS_GROUP_ASSIGN_LEVELS') = 'N'
287: THEN
288: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_ASS_LEVEL_INVALID');

Line 318: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

314: END IF;
315:
316: -- STATUS VALIDATION only if not null
317: IF p_dss_entity_profile.status is not null then
318: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
319: p_dss_entity_profile.status, 'REGISTRY_STATUS')= 'N'
320: THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
322: FND_MSG_PUB.ADD;

Line 455: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_scheme_function.

451: FND_MSG_PUB.ADD;
452: RAISE FND_API.G_EXC_ERROR;
453: ELSE
454:
455: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_scheme_function.
456: security_scheme_code,'HZ_SECURITY_SCHEMES')= 'N' THEN
457: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SEC_SCH_CODE_INVALID');
458: FND_MSG_PUB.ADD;
459: RAISE FND_API.G_EXC_ERROR;

Line 472: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_scheme_function.

468: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'data_operation_code' );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: ELSE
472: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_scheme_function.
473: data_operation_code, 'HZ_DATA_OPERATIONS')= 'N' THEN
474: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DAT_OP_CODE_INVALID');
475: FND_MSG_PUB.ADD;
476: RAISE FND_API.G_EXC_ERROR;

Line 488: IF HZ_DSS_VALIDATE_PKG.exist_function_id(p_dss_scheme_function.

484: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'function_id' );
485: FND_MSG_PUB.ADD;
486: RAISE FND_API.G_EXC_ERROR;
487: ELSE
488: IF HZ_DSS_VALIDATE_PKG.exist_function_id(p_dss_scheme_function.
489: function_id)= 'N' THEN
490: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_FUN_ID_INVALID');
491: FND_MSG_PUB.ADD;
492: RAISE FND_API.G_EXC_ERROR;

Line 498: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_scheme_function.status,

494: END IF;
495:
496: -- STATUS VALIDATION
497: IF p_dss_scheme_function.status is not null then
498: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_scheme_function.status,
499: 'REGISTRY_STATUS')= 'N' THEN
500: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_ERROR;

Line 631: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(

627:
628:
629: -- STATUS VALIDATION
630: IF p_dss_scheme_function.status is not null then
631: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
632: p_dss_scheme_function.status, 'REGISTRY_STATUS')= 'N'
633: THEN
634: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
635: FND_MSG_PUB.ADD;