DBA Data[Home] [Help]

APPS.ZPB_LOG dependencies on FND_MESSAGE

Line 23: FND_MESSAGE.SET_NAME ('ZPB', MESSAGE);

19: l_tok_4_val varchar2(1000);
20: l_tok_5_val varchar2(1000);
21:
22: begin
23: FND_MESSAGE.SET_NAME ('ZPB', MESSAGE);
24: if (TOKEN_1_NAME is not null) then
25: l_tok_1_val:= substr(TOKEN_1_VALUE,1,1000);
26: FND_MESSAGE.SET_TOKEN(TOKEN_1_NAME, l_tok_1_val);
27: else

Line 26: FND_MESSAGE.SET_TOKEN(TOKEN_1_NAME, l_tok_1_val);

22: begin
23: FND_MESSAGE.SET_NAME ('ZPB', MESSAGE);
24: if (TOKEN_1_NAME is not null) then
25: l_tok_1_val:= substr(TOKEN_1_VALUE,1,1000);
26: FND_MESSAGE.SET_TOKEN(TOKEN_1_NAME, l_tok_1_val);
27: else
28: return;
29: end if;
30: if (TOKEN_2_NAME is not null) then

Line 32: FND_MESSAGE.SET_TOKEN(TOKEN_2_NAME, l_tok_2_val);

28: return;
29: end if;
30: if (TOKEN_2_NAME is not null) then
31: l_tok_2_val:= substr(TOKEN_2_VALUE,1,1000);
32: FND_MESSAGE.SET_TOKEN(TOKEN_2_NAME, l_tok_2_val);
33: else
34: return;
35: end if;
36: if (TOKEN_3_NAME is not null) then

Line 38: FND_MESSAGE.SET_TOKEN(TOKEN_3_NAME, l_tok_3_val);

34: return;
35: end if;
36: if (TOKEN_3_NAME is not null) then
37: l_tok_3_val:= substr(TOKEN_3_VALUE,1,1000);
38: FND_MESSAGE.SET_TOKEN(TOKEN_3_NAME, l_tok_3_val);
39: else
40: return;
41: end if;
42: if (TOKEN_4_NAME is not null) then

Line 44: FND_MESSAGE.SET_TOKEN(TOKEN_4_NAME, l_tok_4_val);

40: return;
41: end if;
42: if (TOKEN_4_NAME is not null) then
43: l_tok_4_val:= substr(TOKEN_4_VALUE,1,1000);
44: FND_MESSAGE.SET_TOKEN(TOKEN_4_NAME, l_tok_4_val);
45: else
46: return;
47: end if;
48: if (TOKEN_5_NAME is not null) then

Line 50: FND_MESSAGE.SET_TOKEN(TOKEN_5_NAME, l_tok_5_val);

46: return;
47: end if;
48: if (TOKEN_5_NAME is not null) then
49: l_tok_5_val:= substr(TOKEN_5_VALUE,1,1000);
50: FND_MESSAGE.SET_TOKEN(TOKEN_5_NAME, l_tok_5_val);
51: else
52: return;
53: end if;
54: end BUILD_MESSAGE;

Line 149: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

145: begin
146: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL or
147: not p_pop_message) then
148:
149: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
150: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_module);
151: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure);
152: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',substr(SQLERRM, 1, 1000));
153:

Line 150: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_module);

146: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL or
147: not p_pop_message) then
148:
149: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
150: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_module);
151: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure);
152: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',substr(SQLERRM, 1, 1000));
153:
154: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL and

Line 151: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure);

147: not p_pop_message) then
148:
149: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
150: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_module);
151: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure);
152: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',substr(SQLERRM, 1, 1000));
153:
154: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL and
155: fnd_global.conc_request_id = -1) then

Line 152: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',substr(SQLERRM, 1, 1000));

148:
149: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
150: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_module);
151: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure);
152: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',substr(SQLERRM, 1, 1000));
153:
154: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL and
155: fnd_global.conc_request_id = -1) then
156: FND_LOG.MESSAGE (FND_LOG.LEVEL_EXCEPTION,

Line 221: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table

217: --
218: -- IN:
219: -- MODULE - The calling package and procedure. Example:
220: -- "zpb_aw_write_back.submit_writeback_request"
221: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table
222: -- TOKEN_# - Any tokens required in the message. Tokens go as a
223: -- a name/value. Omit if not applicable
224: -- POP_MESSAGE - True if the message will not be used again. False means
225: -- you must explicitly clear the message.

Line 264: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

260: FND_LOG.MESSAGE (FND_LOG.LEVEL_ERROR,
261: 'zpb.plsql.'||MODULE,
262: POP_MESSAGE);
263: else
264: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
265: if (POP_MESSAGE) then
266: FND_MESSAGE.CLEAR;
267: end if;
268: end if;

Line 266: FND_MESSAGE.CLEAR;

262: POP_MESSAGE);
263: else
264: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
265: if (POP_MESSAGE) then
266: FND_MESSAGE.CLEAR;
267: end if;
268: end if;
269: end if;
270: end WRITE_ERROR;

Line 312: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table

308: --
309: -- IN:
310: -- MODULE - The calling package and procedure. Example:
311: -- "zpb_aw_write_back.submit_writeback_request"
312: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table
313: -- TOKEN_# - Any tokens required in the message. Tokens go as a
314: -- a name/value. Omit if not applicable
315: -- POP_MESSAGE - True if the message will not be used again. False means
316: -- you must explicitly clear the message.

Line 356: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

352: FND_LOG.MESSAGE (FND_LOG.LEVEL_EVENT,
353: 'zpb.plsql.'||MODULE,
354: POP_MESSAGE);
355: else
356: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
357: if (POP_MESSAGE) then
358: FND_MESSAGE.CLEAR;
359: end if;
360: end if;

Line 358: FND_MESSAGE.CLEAR;

354: POP_MESSAGE);
355: else
356: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
357: if (POP_MESSAGE) then
358: FND_MESSAGE.CLEAR;
359: end if;
360: end if;
361: end if;
362: end WRITE_EVENT_TR;

Line 403: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table

399: --
400: -- IN:
401: -- MODULE - The calling package and procedure. Example:
402: -- "zpb_aw_write_back.submit_writeback_request"
403: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table
404: -- TOKEN_# - Any tokens required in the message. Tokens go as a
405: -- a name/value. Omit if not applicable
406: -- POP_MESSAGE - True if the message will not be used again. False means
407: -- you must explicitly clear the message.

Line 446: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

442: FND_LOG.MESSAGE (FND_LOG.LEVEL_EXCEPTION,
443: 'zpb.plsql.'||MODULE,
444: POP_MESSAGE);
445: else
446: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
447: if (POP_MESSAGE) then
448: FND_MESSAGE.CLEAR;
449: end if;
450: end if;

Line 448: FND_MESSAGE.CLEAR;

444: POP_MESSAGE);
445: else
446: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
447: if (POP_MESSAGE) then
448: FND_MESSAGE.CLEAR;
449: end if;
450: end if;
451: end if;
452: end WRITE_EXCEPTION;

Line 495: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table

491: --
492: -- IN:
493: -- MODULE - The calling package and procedure. Example:
494: -- "zpb_aw_write_back.submit_writeback_request"
495: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table
496: -- TOKEN_# - Any tokens required in the message. Tokens go as a
497: -- a name/value. Omit if not applicable
498: -- POP_MESSAGE - True if the message will not be used again. False means
499: -- you must explicitly clear the message.

Line 538: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

534: FND_LOG.MESSAGE (FND_LOG.LEVEL_UNEXPECTED,
535: 'zpb.plsql.'||MODULE,
536: POP_MESSAGE);
537: else
538: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
539: if (POP_MESSAGE) then
540: FND_MESSAGE.CLEAR;
541: end if;
542: end if;

Line 540: FND_MESSAGE.CLEAR;

536: POP_MESSAGE);
537: else
538: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
539: if (POP_MESSAGE) then
540: FND_MESSAGE.CLEAR;
541: end if;
542: end if;
543: end if;
544: end WRITE_UNEXPECTED;

Line 568: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table

564: --
565: -- Procedure to log informational translated messages to the concurrent log.
566: --
567: -- IN:
568: -- MESSAGE_NAME - The Message name defined in FND_MESSAGES table
569: -- TOKEN_# - Any tokens required in the message. Tokens go as a
570: -- a name/value. Omit if not applicable
571: -- POP_MESSAGE - True if the message will not be used again. False means
572: -- you must explicitly clear the message.

Line 602: FND_FILE.PUT_LINE (FND_FILE.LOG, to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') ||' ' || FND_MESSAGE.GET);

598: TOKEN_4_VALUE,
599: TOKEN_5_NAME,
600: TOKEN_5_VALUE);
601:
602: FND_FILE.PUT_LINE (FND_FILE.LOG, to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') ||' ' || FND_MESSAGE.GET);
603: if (POP_MESSAGE) then
604: FND_MESSAGE.CLEAR;
605: end if;
606:

Line 604: FND_MESSAGE.CLEAR;

600: TOKEN_5_VALUE);
601:
602: FND_FILE.PUT_LINE (FND_FILE.LOG, to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') ||' ' || FND_MESSAGE.GET);
603: if (POP_MESSAGE) then
604: FND_MESSAGE.CLEAR;
605: end if;
606:
607:
608: end WRITE_TO_CONCMGR_LOG_TR;