51: SYSDATE,
52: p_message_name,
53: nvl(l_message_parameters, NULL),
54: p_error_type,
55: FND_GLOBAL.USER_ID,
56: SYSDATE,
57: FND_GLOBAL.USER_ID,
58: SYSDATE,
59: FND_GLOBAL.LOGIN_ID);
53: nvl(l_message_parameters, NULL),
54: p_error_type,
55: FND_GLOBAL.USER_ID,
56: SYSDATE,
57: FND_GLOBAL.USER_ID,
58: SYSDATE,
59: FND_GLOBAL.LOGIN_ID);
60: END IF;
61:
55: FND_GLOBAL.USER_ID,
56: SYSDATE,
57: FND_GLOBAL.USER_ID,
58: SYSDATE,
59: FND_GLOBAL.LOGIN_ID);
60: END IF;
61:
62: EXCEPTION
63: WHEN OTHERS THEN
294: begin
295:
296: UPDATE xdp_error_count SET
297: error_count = p_error_count,
298: last_updated_by = FND_GLOBAL.USER_ID,
299: last_update_date = sysdate,
300: last_update_login = FND_GLOBAL.USER_ID
301: WHERE
302: object_type = p_object_type and object_key = p_object_key;
296: UPDATE xdp_error_count SET
297: error_count = p_error_count,
298: last_updated_by = FND_GLOBAL.USER_ID,
299: last_update_date = sysdate,
300: last_update_login = FND_GLOBAL.USER_ID
301: WHERE
302: object_type = p_object_type and object_key = p_object_key;
303:
304: if (sql%notfound) then
315: ) VALUES (
316: p_object_type,
317: p_object_key,
318: p_error_count,
319: FND_GLOBAL.USER_ID,
320: sysdate,
321: FND_GLOBAL.USER_ID,
322: sysdate,
323: FND_GLOBAL.LOGIN_ID);
317: p_object_key,
318: p_error_count,
319: FND_GLOBAL.USER_ID,
320: sysdate,
321: FND_GLOBAL.USER_ID,
322: sysdate,
323: FND_GLOBAL.LOGIN_ID);
324: end if;
325:
319: FND_GLOBAL.USER_ID,
320: sysdate,
321: FND_GLOBAL.USER_ID,
322: sysdate,
323: FND_GLOBAL.LOGIN_ID);
324: end if;
325:
326: END UPDATE_ERROR_COUNT;
327: