eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_EKANBAN_LOGGER dependencies on FND_API

Line 36: x_returnStatus := fnd_api.g_ret_sts_success;

32: p_procName IN VARCHAR2,
33: p_params IN param_tbl_t,
34: x_returnStatus out NOCOPY VARCHAR2) is
35: begin
36: x_returnStatus := fnd_api.g_ret_sts_success;
37: g_indentLevel := least(g_indentLevel + 1, g_maxIndentLevel);
38:
39: g_moduleTbl(nvl(g_moduleTbl.last, 0) + 1) := 'FLM.EKANBAN.PLSQL.' || p_procName;
40:

Line 44: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

40:
41: write(p_msg => '[begin ' || p_procName || ']',
42: p_logLevel => p_logLevel,
43: x_returnStatus => x_returnStatus);
44: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
45: raise fnd_api.g_exc_unexpected_error;
46: end if;
47: for i in 1..p_params.count loop
48: write(p_msg => ' ' || p_params(i).paramName || ': ' || p_params(i).paramValue,

Line 45: raise fnd_api.g_exc_unexpected_error;

41: write(p_msg => '[begin ' || p_procName || ']',
42: p_logLevel => p_logLevel,
43: x_returnStatus => x_returnStatus);
44: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
45: raise fnd_api.g_exc_unexpected_error;
46: end if;
47: for i in 1..p_params.count loop
48: write(p_msg => ' ' || p_params(i).paramName || ': ' || p_params(i).paramValue,
49: p_logLevel => p_logLevel,

Line 51: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

47: for i in 1..p_params.count loop
48: write(p_msg => ' ' || p_params(i).paramName || ': ' || p_params(i).paramValue,
49: p_logLevel => p_logLevel,
50: x_returnStatus => x_returnStatus);
51: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
52: raise fnd_api.g_exc_unexpected_error;
53: end if;
54: end loop;
55:

Line 52: raise fnd_api.g_exc_unexpected_error;

48: write(p_msg => ' ' || p_params(i).paramName || ': ' || p_params(i).paramValue,
49: p_logLevel => p_logLevel,
50: x_returnStatus => x_returnStatus);
51: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
52: raise fnd_api.g_exc_unexpected_error;
53: end if;
54: end loop;
55:
56: exception

Line 66: l_returnStatus := fnd_api.g_ret_sts_success;

62: p_procName IN VARCHAR2,
63: x_returnStatus out NOCOPY VARCHAR2) is
64: l_returnStatus varchar2(1);
65: begin
66: l_returnStatus := fnd_api.g_ret_sts_success;
67: g_indentLevel := least(g_indentLevel + 1, g_maxIndentLevel);
68: g_moduleTbl(nvl(g_moduleTbl.last, 0) + 1) := 'FLM.EKANBAN.JAVA.' || p_procName;
69:
70: write(p_msg => '[begin ' || p_procName || ']',

Line 73: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

69:
70: write(p_msg => '[begin ' || p_procName || ']',
71: p_logLevel => p_logLevel,
72: x_returnStatus => l_returnStatus);
73: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
74: raise fnd_api.g_exc_unexpected_error;
75: end if;
76: exception
77: when others then

Line 74: raise fnd_api.g_exc_unexpected_error;

70: write(p_msg => '[begin ' || p_procName || ']',
71: p_logLevel => p_logLevel,
72: x_returnStatus => l_returnStatus);
73: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
74: raise fnd_api.g_exc_unexpected_error;
75: end if;
76: exception
77: when others then
78: null;--write() will set all return values properly

Line 87: x_returnStatus := fnd_api.g_ret_sts_success;

83: p_procReturnStatus IN VARCHAR2,
84: p_msg IN VARCHAR2,
85: x_returnStatus out NOCOPY VARCHAR2) is
86: begin
87: x_returnStatus := fnd_api.g_ret_sts_success;
88:
89: write(p_msg => '[end ' || p_procName || ']',
90: p_logLevel => p_logLevel,
91: x_returnStatus => x_returnStatus);

Line 92: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

88:
89: write(p_msg => '[end ' || p_procName || ']',
90: p_logLevel => p_logLevel,
91: x_returnStatus => x_returnStatus);
92: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
93: raise fnd_api.g_exc_unexpected_error;
94: end if;
95:
96: write(p_msg => ' return status: ' || p_procReturnStatus,

Line 93: raise fnd_api.g_exc_unexpected_error;

89: write(p_msg => '[end ' || p_procName || ']',
90: p_logLevel => p_logLevel,
91: x_returnStatus => x_returnStatus);
92: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
93: raise fnd_api.g_exc_unexpected_error;
94: end if;
95:
96: write(p_msg => ' return status: ' || p_procReturnStatus,
97: p_logLevel => p_logLevel,

Line 99: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

95:
96: write(p_msg => ' return status: ' || p_procReturnStatus,
97: p_logLevel => p_logLevel,
98: x_returnStatus => x_returnStatus);
99: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
100: raise fnd_api.g_exc_unexpected_error;
101: end if;
102:
103: write(p_msg => ' info: ' || p_msg,

Line 100: raise fnd_api.g_exc_unexpected_error;

96: write(p_msg => ' return status: ' || p_procReturnStatus,
97: p_logLevel => p_logLevel,
98: x_returnStatus => x_returnStatus);
99: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
100: raise fnd_api.g_exc_unexpected_error;
101: end if;
102:
103: write(p_msg => ' info: ' || p_msg,
104: p_logLevel => p_logLevel,

Line 106: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

102:
103: write(p_msg => ' info: ' || p_msg,
104: p_logLevel => p_logLevel,
105: x_returnStatus => x_returnStatus);
106: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
107: raise fnd_api.g_exc_unexpected_error;
108: end if;
109:
110: --this if should always be true

Line 107: raise fnd_api.g_exc_unexpected_error;

103: write(p_msg => ' info: ' || p_msg,
104: p_logLevel => p_logLevel,
105: x_returnStatus => x_returnStatus);
106: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
107: raise fnd_api.g_exc_unexpected_error;
108: end if;
109:
110: --this if should always be true
111: if(g_moduleTbl.last is not null) then

Line 130: x_returnStatus := fnd_api.g_ret_sts_success;

126: g_sessionID := -1;
127: g_indentLevel := 0;
128: g_moduleTbl.delete;
129:
130: x_returnStatus := fnd_api.g_ret_sts_success;
131: exception
132: when others then
133: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
134: fnd_msg_pub.add_exc_msg(p_pkg_name => 'flm_ekanban_logger',

Line 133: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

129:
130: x_returnStatus := fnd_api.g_ret_sts_success;
131: exception
132: when others then
133: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
134: fnd_msg_pub.add_exc_msg(p_pkg_name => 'flm_ekanban_logger',
135: p_procedure_name => 'cleanUp',
136: p_error_text => SQLERRM);
137: end cleanUp;

Line 146: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

142: l_msg VARCHAR2(2000);
143: l_module VARCHAR2(2000);
144: l_retStatus varchar2(1);
145: begin
146: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
147: if(g_sessionID < 0) then
148: init(x_returnStatus => x_returnStatus);
149: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
150: raise fnd_api.g_exc_unexpected_error;

Line 149: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

145: begin
146: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
147: if(g_sessionID < 0) then
148: init(x_returnStatus => x_returnStatus);
149: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
150: raise fnd_api.g_exc_unexpected_error;
151: end if;
152: end if;
153: l_msg := 'Session ' || g_sessionID || ': ';

Line 150: raise fnd_api.g_exc_unexpected_error;

146: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
147: if(g_sessionID < 0) then
148: init(x_returnStatus => x_returnStatus);
149: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
150: raise fnd_api.g_exc_unexpected_error;
151: end if;
152: end if;
153: l_msg := 'Session ' || g_sessionID || ': ';
154: l_msg := lpad(l_msg, g_indentLevel * g_indentOffset + length(l_msg), ' ');

Line 156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

152: end if;
153: l_msg := 'Session ' || g_sessionID || ': ';
154: l_msg := lpad(l_msg, g_indentLevel * g_indentOffset + length(l_msg), ' ');
155: l_msg := l_msg || substr(p_msg, 0, g_maxMsgLen - length(l_msg));
156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
157: if(g_moduleTbl.last is null) then
158: g_moduleTbl(1) := g_anonModule;
159: end if;
160:

Line 195: x_returnStatus := fnd_api.g_ret_sts_success;

191: module => g_moduleTbl(g_moduleTbl.last),
192: message => l_msg);
193: end if;
194:
195: x_returnStatus := fnd_api.g_ret_sts_success;
196: exception
197: when others then
198: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
199: fnd_msg_pub.add_exc_msg(p_pkg_name => 'flm_ekanban_logger',

Line 198: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

194:
195: x_returnStatus := fnd_api.g_ret_sts_success;
196: exception
197: when others then
198: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
199: fnd_msg_pub.add_exc_msg(p_pkg_name => 'flm_ekanban_logger',
200: p_procedure_name => 'write',
201: p_error_text => SQLERRM);
202: end write;

Line 206: x_returnStatus := fnd_api.g_ret_sts_success;

202: end write;
203:
204: procedure init(x_returnStatus out NOCOPY VARCHAR2) is
205: begin
206: x_returnStatus := fnd_api.g_ret_sts_success;
207: g_indentLevel := 0;
208:
209: if(g_sessionID < 0) then
210: select wip_logging_session_s.nextval