288: AND gcr.child_entity_id = p_child_entity_id;
289:
290: BEGIN
291:
292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ENTITY_ADDED.begin', '<
294: END IF;
295:
296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
289:
290: BEGIN
291:
292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ENTITY_ADDED.begin', '<
295:
296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_hierarchy_id : ' || p_hierarchy_id);
292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ENTITY_ADDED.begin', '<
294: END IF;
295:
296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_hierarchy_id : ' || p_hierarchy_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_cons_relationship_id: ' || p_cons_relationship_id);
299: END IF;
300:
293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ENTITY_ADDED.begin', '<
294: END IF;
295:
296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_hierarchy_id : ' || p_hierarchy_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_cons_relationship_id: ' || p_cons_relationship_id);
299: END IF;
300:
301: SELECT gcr.parent_entity_id,
294: END IF;
295:
296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_hierarchy_id : ' || p_hierarchy_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ENTITY_ADDED', 'p_cons_relationship_id: ' || p_cons_relationship_id);
299: END IF;
300:
301: SELECT gcr.parent_entity_id,
302: gcr.child_entity_id,
449: AND fea.version_id IN (l_oper_entity_version, l_elim_entity_version);
450: END IF;
451: END IF;
452:
453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ENTITY_ADDED.end', '<
455: END IF;
456:
457: EXCEPTION
450: END IF;
451: END IF;
452:
453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ENTITY_ADDED.end', '<
456:
457: EXCEPTION
458: WHEN OTHERS THEN
455: END IF;
456:
457: EXCEPTION
458: WHEN OTHERS THEN
459: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
460: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, g_api || '.ENTITY_ADDED', SQLERRM);
461: END IF;
462: END entity_added;
463:
456:
457: EXCEPTION
458: WHEN OTHERS THEN
459: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
460: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, g_api || '.ENTITY_ADDED', SQLERRM);
461: END IF;
462: END entity_added;
463:
464: