APPS.FND_NEW_MESSAGES_PKG dependencies on FND_LOAD_UTIL

Line 254: f_luby := fnd_load_util.owner_id(x_owner);

250:
251: description varchar2(240);
252: begin
253: -- Translate owner to file_last_updated_by
254: f_luby := fnd_load_util.owner_id(x_owner);
255:
256: -- Translate char last_update_date to date
257: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
258:

Line 275: select decode(X_MESSAGE_NUMBER, fnd_load_util.null_value, null,

271: --if (X_FND_LOG_SEVERITY is NULL) then
272: --fnd_log_severity := NULL;
273: --end if;
274:
275: select decode(X_MESSAGE_NUMBER, fnd_load_util.null_value, null,
276: null, X_MESSAGE_NUMBER,
277: TO_NUMBER(X_MESSAGE_NUMBER)),
278: decode(X_TYPE, fnd_load_util.null_value, null,
279: null, X_TYPE,

Line 278: decode(X_TYPE, fnd_load_util.null_value, null,

274:
275: select decode(X_MESSAGE_NUMBER, fnd_load_util.null_value, null,
276: null, X_MESSAGE_NUMBER,
277: TO_NUMBER(X_MESSAGE_NUMBER)),
278: decode(X_TYPE, fnd_load_util.null_value, null,
279: null, X_TYPE,
280: X_TYPE),
281: decode(X_DESCRIPTION, fnd_load_util.null_value, null,
282: null, X_DESCRIPTION,

Line 281: decode(X_DESCRIPTION, fnd_load_util.null_value, null,

277: TO_NUMBER(X_MESSAGE_NUMBER)),
278: decode(X_TYPE, fnd_load_util.null_value, null,
279: null, X_TYPE,
280: X_TYPE),
281: decode(X_DESCRIPTION, fnd_load_util.null_value, null,
282: null, X_DESCRIPTION,
283: X_DESCRIPTION),
284: decode(X_MAX_LENGTH, fnd_load_util.null_value, null,
285: null, X_MAX_LENGTH,

Line 284: decode(X_MAX_LENGTH, fnd_load_util.null_value, null,

280: X_TYPE),
281: decode(X_DESCRIPTION, fnd_load_util.null_value, null,
282: null, X_DESCRIPTION,
283: X_DESCRIPTION),
284: decode(X_MAX_LENGTH, fnd_load_util.null_value, null,
285: null, X_MAX_LENGTH,
286: TO_NUMBER(X_MAX_LENGTH)),
287: decode(X_CATEGORY, fnd_load_util.null_value, null,
288: null, X_CATEGORY,

Line 287: decode(X_CATEGORY, fnd_load_util.null_value, null,

283: X_DESCRIPTION),
284: decode(X_MAX_LENGTH, fnd_load_util.null_value, null,
285: null, X_MAX_LENGTH,
286: TO_NUMBER(X_MAX_LENGTH)),
287: decode(X_CATEGORY, fnd_load_util.null_value, null,
288: null, X_CATEGORY,
289: X_CATEGORY),
290: decode(X_SEVERITY, fnd_load_util.null_value, null,
291: null, X_SEVERITY,

Line 290: decode(X_SEVERITY, fnd_load_util.null_value, null,

286: TO_NUMBER(X_MAX_LENGTH)),
287: decode(X_CATEGORY, fnd_load_util.null_value, null,
288: null, X_CATEGORY,
289: X_CATEGORY),
290: decode(X_SEVERITY, fnd_load_util.null_value, null,
291: null, X_SEVERITY,
292: X_SEVERITY),
293: decode(X_FND_LOG_SEVERITY, fnd_load_util.null_value, null,
294: null, X_FND_LOG_SEVERITY,

Line 293: decode(X_FND_LOG_SEVERITY, fnd_load_util.null_value, null,

289: X_CATEGORY),
290: decode(X_SEVERITY, fnd_load_util.null_value, null,
291: null, X_SEVERITY,
292: X_SEVERITY),
293: decode(X_FND_LOG_SEVERITY, fnd_load_util.null_value, null,
294: null, X_FND_LOG_SEVERITY,
295: TO_NUMBER(X_FND_LOG_SEVERITY))
296: into message_number,
297: msg_type,

Line 313: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

309: where application_id = app_id
310: and language_code = userenv('LANG')
311: and message_name = X_MESSAGE_NAME;
312:
313: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
314: db_ludate, X_CUSTOM_MODE)) then
315: -- bug 2747318
316: -- According to which DB (category/severity present or not present)
317: -- is being used, the correct section will execute for update.

Line 482: f_luby := fnd_load_util.owner_id(x_owner);

478:
479: sql_string varchar2(6000);
480: begin
481: -- Translate owner to file_last_updated_by
482: f_luby := fnd_load_util.owner_id(x_owner);
483:
484: -- Translate char last_update_date to date
485: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
486:

Line 499: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

495: where application_id = app_id
496: and language_code = userenv('LANG')
497: and message_name = X_MESSAGE_NAME;
498:
499: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
500: db_ludate, X_CUSTOM_MODE)) then
501: update fnd_new_messages set
502: message_text = nvl(X_MESSAGE_TEXT, message_text),
503: last_updated_by = f_luby,