6297: WIDTH = p_width,
6298: HEIGHT = p_height,
6299: MIME_TYPE = p_mime_type,
6300: LAST_UPDATE_DATE = SYSDATE,
6301: LAST_UPDATED_BY = fnd_global.user_id,
6302: LAST_UPDATE_LOGIN = fnd_global.login_id,
6303: FILE_BODY = EMPTY_BLOB()
6304: WHERE IMAGE_ID = p_image_id;
6305: EXCEPTION
6298: HEIGHT = p_height,
6299: MIME_TYPE = p_mime_type,
6300: LAST_UPDATE_DATE = SYSDATE,
6301: LAST_UPDATED_BY = fnd_global.user_id,
6302: LAST_UPDATE_LOGIN = fnd_global.login_id,
6303: FILE_BODY = EMPTY_BLOB()
6304: WHERE IMAGE_ID = p_image_id;
6305: EXCEPTION
6306: WHEN OTHERS THEN
6316: ,X_SOURCE_CODE => p_tab_id
6317: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6318: ,X_IMAGE_ID => p_image_id
6319: ,X_CREATION_DATE => SYSDATE
6320: ,X_CREATED_BY => fnd_global.user_id
6321: ,X_LAST_UPDATE_DATE => SYSDATE
6322: ,X_LAST_UPDATED_BY => fnd_global.user_id
6323: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6324: );
6318: ,X_IMAGE_ID => p_image_id
6319: ,X_CREATION_DATE => SYSDATE
6320: ,X_CREATED_BY => fnd_global.user_id
6321: ,X_LAST_UPDATE_DATE => SYSDATE
6322: ,X_LAST_UPDATED_BY => fnd_global.user_id
6323: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6324: );
6325:
6326: ELSE
6319: ,X_CREATION_DATE => SYSDATE
6320: ,X_CREATED_BY => fnd_global.user_id
6321: ,X_LAST_UPDATE_DATE => SYSDATE
6322: ,X_LAST_UPDATED_BY => fnd_global.user_id
6323: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6324: );
6325:
6326: ELSE
6327: --image not owned by this NLS session, need to create a new image and update the image map
6339: ,X_DESCRIPTION => p_description
6340: ,X_WIDTH => p_width
6341: ,X_HEIGHT => p_height
6342: ,X_MIME_TYPE => p_mime_type
6343: ,X_CREATED_BY => fnd_global.user_id
6344: ,X_LAST_UPDATED_BY => fnd_global.user_id
6345: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6346: );
6347:
6340: ,X_WIDTH => p_width
6341: ,X_HEIGHT => p_height
6342: ,X_MIME_TYPE => p_mime_type
6343: ,X_CREATED_BY => fnd_global.user_id
6344: ,X_LAST_UPDATED_BY => fnd_global.user_id
6345: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6346: );
6347:
6348: EXCEPTION
6341: ,X_HEIGHT => p_height
6342: ,X_MIME_TYPE => p_mime_type
6343: ,X_CREATED_BY => fnd_global.user_id
6344: ,X_LAST_UPDATED_BY => fnd_global.user_id
6345: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6346: );
6347:
6348: EXCEPTION
6349: WHEN OTHERS THEN
6359: ,X_SOURCE_CODE => p_tab_id
6360: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6361: ,X_IMAGE_ID => p_image_id
6362: ,X_CREATION_DATE => SYSDATE
6363: ,X_CREATED_BY => fnd_global.user_id
6364: ,X_LAST_UPDATE_DATE => SYSDATE
6365: ,X_LAST_UPDATED_BY => fnd_global.user_id
6366: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6367: );
6361: ,X_IMAGE_ID => p_image_id
6362: ,X_CREATION_DATE => SYSDATE
6363: ,X_CREATED_BY => fnd_global.user_id
6364: ,X_LAST_UPDATE_DATE => SYSDATE
6365: ,X_LAST_UPDATED_BY => fnd_global.user_id
6366: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6367: );
6368: END IF;
6369: ELSE
6362: ,X_CREATION_DATE => SYSDATE
6363: ,X_CREATED_BY => fnd_global.user_id
6364: ,X_LAST_UPDATE_DATE => SYSDATE
6365: ,X_LAST_UPDATED_BY => fnd_global.user_id
6366: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6367: );
6368: END IF;
6369: ELSE
6370: --create a new image for this Simulation Tree Objective
6427: ,X_DESCRIPTION => p_description
6428: ,X_WIDTH => p_width
6429: ,X_HEIGHT => p_height
6430: ,X_MIME_TYPE => p_mime_type
6431: ,X_CREATED_BY => fnd_global.user_id
6432: ,X_LAST_UPDATED_BY => fnd_global.user_id
6433: ,X_LAST_UPDATE_LOGIN=> fnd_global.login_id
6434: );
6435:
6428: ,X_WIDTH => p_width
6429: ,X_HEIGHT => p_height
6430: ,X_MIME_TYPE => p_mime_type
6431: ,X_CREATED_BY => fnd_global.user_id
6432: ,X_LAST_UPDATED_BY => fnd_global.user_id
6433: ,X_LAST_UPDATE_LOGIN=> fnd_global.login_id
6434: );
6435:
6436: EXCEPTION
6429: ,X_HEIGHT => p_height
6430: ,X_MIME_TYPE => p_mime_type
6431: ,X_CREATED_BY => fnd_global.user_id
6432: ,X_LAST_UPDATED_BY => fnd_global.user_id
6433: ,X_LAST_UPDATE_LOGIN=> fnd_global.login_id
6434: );
6435:
6436: EXCEPTION
6437: WHEN OTHERS THEN
6447: ,X_SOURCE_CODE => p_obj_id
6448: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6449: ,X_IMAGE_ID => l_next_image_id
6450: ,X_CREATION_DATE => SYSDATE
6451: ,X_CREATED_BY => fnd_global.user_id
6452: ,X_LAST_UPDATE_DATE => SYSDATE
6453: ,X_LAST_UPDATED_BY => fnd_global.user_id
6454: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6455: );
6449: ,X_IMAGE_ID => l_next_image_id
6450: ,X_CREATION_DATE => SYSDATE
6451: ,X_CREATED_BY => fnd_global.user_id
6452: ,X_LAST_UPDATE_DATE => SYSDATE
6453: ,X_LAST_UPDATED_BY => fnd_global.user_id
6454: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6455: );
6456: EXCEPTION
6457: WHEN others THEN
6450: ,X_CREATION_DATE => SYSDATE
6451: ,X_CREATED_BY => fnd_global.user_id
6452: ,X_LAST_UPDATE_DATE => SYSDATE
6453: ,X_LAST_UPDATED_BY => fnd_global.user_id
6454: ,X_LAST_UPDATE_LOGIN => fnd_global.login_id
6455: );
6456: EXCEPTION
6457: WHEN others THEN
6458: ROLLBACK TO CreateScorecardlogo;