APPS.WF_TEMP_LOB dependencies on FND_LOG

Line 55: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

51: buf varchar2(200);
52: amt binary_integer := 200;
53: len integer;
54: begin
55: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
56: wf_log_pkg.string(wf_log_pkg.level_procedure,
57: 'wf.plsql.WF_TEMP_LOB.ShowLOB.Begin',
58: 'Count: '||to_char(p_lob_tab.COUNT));
59: end if;

Line 64: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

60:
61: for i in 1..p_lob_tab.COUNT loop
62: len := dbms_lob.getlength(p_lob_tab(i).temp_lob);
63:
64: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
65: wf_log_pkg.string(wf_log_pkg.level_statement,
66: 'wf.plsql.WF_TEMP_LOB.ShowLOB.allocate',
67: 'p_lob_tab('||to_char(i)||').temp_lob length:'||to_char(len));
68: end if;

Line 71: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

67: 'p_lob_tab('||to_char(i)||').temp_lob length:'||to_char(len));
68: end if;
69:
70: if (p_lob_tab(i).free) then
71: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
72: wf_log_pkg.string(wf_log_pkg.level_statement,
73: 'wf.plsql.WF_TEMP_LOB.ShowLOB.free',
74: 'p_lob_tab('||to_char(i)||').temp_lob is free.');
75: end if;

Line 77: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

73: 'wf.plsql.WF_TEMP_LOB.ShowLOB.free',
74: 'p_lob_tab('||to_char(i)||').temp_lob is free.');
75: end if;
76: else
77: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
78: wf_log_pkg.string(wf_log_pkg.level_statement,
79: 'wf.plsql.WF_TEMP_LOB.ShowLOB.used',
80: 'p_lob_tab('||to_char(i)||').temp_lob is in use.');
81: end if;

Line 84: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

80: 'p_lob_tab('||to_char(i)||').temp_lob is in use.');
81: end if;
82:
83: if (len = 0) then
84: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
85: wf_log_pkg.string(wf_log_pkg.level_statement,
86: 'wf.plsql.WF_TEMP_LOB.ShowLOB.empty',
87: 'lob content: empty');
88: end if;

Line 91: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

87: 'lob content: empty');
88: end if;
89: else
90: dbms_lob.read(p_lob_tab(i).temp_lob,amt,1,buf);
91: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
92: wf_log_pkg.string(wf_log_pkg.level_statement,
93: 'wf.plsql.WF_TEMP_LOB.ShowLOB.content',
94: 'lob content: '||buf);
95: end if;