[Home] [Help]
318: END IF;
319:
320: -- Sanity validation
321: -- Check if the link type passed is valid
322: CS_INCIDENTLINKS_UTIL.VALIDATE_LINK_TYPE (
323: P_LINK_TYPE_ID => p_link_rec.link_type_id,
324: X_RETURN_STATUS => x_return_status,
325: X_MSG_COUNT => x_msg_count,
326: X_MSG_DATA => x_msg_data );
333: -- Business validations.
334: -- Perform check for valid objects
335: -- Rule : A link instance should have a valid subject type, object type and link
336: -- type combination.
337: CS_INCIDENTLINKS_UTIL.VALIDATE_LINK_SUB_OBJ_TYPE (
338: P_SUBJECT_TYPE => p_link_rec.subject_type,
339: P_OBJECT_TYPE => p_link_rec.object_type,
340: P_LINK_TYPE_ID => p_link_rec.link_type_id,
341: X_RETURN_STATUS => x_return_status,
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375:
376: CS_INCIDENTLINKS_UTIL.VALIDATE_LINK_DETAILS (
377: P_SUBJECT_ID => p_link_rec.subject_id,
378: P_SUBJECT_TYPE => p_link_rec.subject_type,
379: P_OBJECT_ID => p_link_rec.object_id,
380: P_OBJECT_TYPE => p_link_rec.object_type,
402: -- The validation is to make sure that the responsibility creating
403: -- the link, has access to the subject and/or object if they are
404: -- service requests
405: if ( p_link_rec.subject_type = 'SR' ) then
406: cs_incidentlinks_util.validate_sr_sec_access (
407: p_incident_id => p_link_rec.subject_id,
408: x_return_status => x_return_status,
409: x_msg_count => x_msg_count,
410: x_msg_data => x_msg_data );
416: end if;
417: end if;
418:
419: if ( p_link_rec.object_type = 'SR' ) then
420: cs_incidentlinks_util.validate_sr_sec_access (
421: p_incident_id => p_link_rec.object_id,
422: x_return_status => x_return_status,
423: x_msg_count => x_msg_count,
424: x_msg_data => x_msg_data );
432: -- END OF SECURITY ACCESS CHECK FOR R11.5.10
433:
434: -- Perform check for link object uniquenes
435: -- Rule : Two linked objects cannot have more than one link pair between them.
436: CS_INCIDENTLINKS_UTIL.VALIDATE_LINK_UNIQUENESS (
437: P_SUBJECT_ID => p_link_rec.subject_id,
438: P_SUBJECT_TYPE => p_link_rec.subject_type,
439: P_OBJECT_ID => p_link_rec.object_id,
440: P_OBJECT_TYPE => p_link_rec.object_type,
462: -- Please add any new relationsihps to the original SUB_OBJ_TYPE_NAME - SUB_OBJ_NUM
463: -- 2> A business object 'A' cannot be made a 'Duplicate Of' another business
464: -- object, if 'A' already has a CAUSAL link associated to it.
465: -- MSG:
466: CS_INCIDENTLINKS_UTIL.VALIDATE_LINK_DUPLICATES (
467: P_SUBJECT_ID => p_link_rec.subject_id,
468: P_SUBJECT_TYPE => p_link_rec.subject_type,
469: P_OBJECT_ID => p_link_rec.object_id,
470: P_OBJECT_TYPE => p_link_rec.object_type,
533: -- an update. (update end dates a link and creates a new link)
534: -- Rule : Prevent creation of circular dependency regardless of link type.
535:
536: if ( p_link_rec.link_type_id in (1,2) ) then
537: CS_INCIDENTLINKS_UTIL.VALIDATE_LINK_CIRCULARS (
538: P_SUBJECT_ID => p_link_rec.subject_id,
539: P_SUBJECT_TYPE => p_link_rec.subject_type,
540: P_OBJECT_ID => p_link_rec.object_id,
541: P_OBJECT_TYPE => p_link_rec.object_type,
1424: -- when the link is updated. (as the create link is invoked each time a
1425: -- link is updated.
1426:
1427: if ( l_old_values_rec.subject_type = 'SR' ) then
1428: cs_incidentlinks_util.validate_sr_sec_access (
1429: p_incident_id => l_old_values_rec.subject_id,
1430: x_return_status => x_return_status,
1431: x_msg_count => x_msg_count,
1432: x_msg_data => x_msg_data );
1438: end if;
1439: end if;
1440:
1441: if ( l_old_values_rec.object_type = 'SR' ) then
1442: cs_incidentlinks_util.validate_sr_sec_access (
1443: p_incident_id => l_old_values_rec.object_id,
1444: x_return_status => x_return_status,
1445: x_msg_count => x_msg_count,
1446: x_msg_data => x_msg_data );
2032: -- the link, has access to the subject and/or object if they are
2033: -- service requests
2034:
2035: if ( c1rec.subject_type = 'SR' ) then
2036: cs_incidentlinks_util.validate_sr_sec_access (
2037: p_incident_id => c1rec.subject_id,
2038: x_return_status => x_return_status,
2039: x_msg_count => x_msg_count,
2040: x_msg_data => x_msg_data );
2046: end if;
2047: end if;
2048:
2049: if ( c1rec.object_type = 'SR' ) then
2050: cs_incidentlinks_util.validate_sr_sec_access (
2051: p_incident_id => c1rec.object_id,
2052: x_return_status => x_return_status,
2053: x_msg_count => x_msg_count,
2054: x_msg_data => x_msg_data );