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.FND_DEBUG_OPTIONS_PKG dependencies on FND_DEBUG_OPTIONS

Line 1: package body FND_DEBUG_OPTIONS_PKG as

1: package body FND_DEBUG_OPTIONS_PKG as
2: -- $Header: AFOAMDOB.pls 120.1 2005/07/02 03:02:36 appldev noship $
3:
4:
5:

Line 18: FND_DEBUG_OPTIONS_PKG.LOAD_ROW (

14:
15:
16: ) is
17: begin
18: FND_DEBUG_OPTIONS_PKG.LOAD_ROW (
19: X_DEBUG_OPTION_NAME => X_DEBUG_OPTION_NAME,
20: X_ENABLED_FLAG => X_ENABLED_FLAG,
21: X_TYPE => X_TYPE,
22: X_SEPARATOR=> X_SEPARATOR,

Line 69: FND_DEBUG_OPTIONS_PKG.UPDATE_ROW (

65: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
66: db_ludate, X_CUSTOM_MODE)) then
67:
68:
69: FND_DEBUG_OPTIONS_PKG.UPDATE_ROW (
70: X_DEBUG_OPTION_NAME =>X_DEBUG_OPTION_NAME,
71: X_ENABLED_FLAG => X_ENABLED_FLAG,
72: X_TYPE => X_TYPE,
73: X_SEPARATOR => X_SEPARATOR,

Line 86: FND_DEBUG_OPTIONS_PKG.INSERT_ROW (

82: end if;
83: exception
84: when NO_DATA_FOUND then
85:
86: FND_DEBUG_OPTIONS_PKG.INSERT_ROW (
87: X_ROWID => row_id,
88: X_DEBUG_OPTION_NAME =>X_DEBUG_OPTION_NAME,
89: X_ENABLED_FLAG => X_ENABLED_FLAG,
90: X_TYPE => X_TYPE,

Line 116: cursor C is select ROWID from FND_DEBUG_OPTIONS

112: X_LAST_UPDATE_DATE in DATE,
113: X_LAST_UPDATED_BY in NUMBER,
114: X_LAST_UPDATE_LOGIN in NUMBER
115: ) is
116: cursor C is select ROWID from FND_DEBUG_OPTIONS
117: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
118: ;
119: begin
120:

Line 123: insert into FND_DEBUG_OPTIONS (

119: begin
120:
121:
122:
123: insert into FND_DEBUG_OPTIONS (
124: DEBUG_OPTION_NAME,
125: ENABLED_FLAG,
126: TYPE,
127: SEPARATOR,

Line 147: insert into FND_DEBUG_OPTIONS_TL (

143: X_LAST_UPDATED_BY,
144: X_LAST_UPDATE_LOGIN
145: );
146:
147: insert into FND_DEBUG_OPTIONS_TL (
148: DEBUG_OPTION_NAME,
149: DESCRIPTION,
150: CREATION_DATE,
151: CREATED_BY,

Line 171: from FND_DEBUG_OPTIONS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from FND_DEBUG_OPTIONS_TL T
172: where T.DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
173: and T.LANGUAGE = L.LANGUAGE_CODE);
174:
175: open c;

Line 197: update FND_DEBUG_OPTIONS set

193: X_LAST_UPDATED_BY in NUMBER,
194: X_LAST_UPDATE_LOGIN in NUMBER
195: ) is
196: begin
197: update FND_DEBUG_OPTIONS set
198: ENABLED_FLAG = X_ENABLED_FLAG,
199: TYPE = X_TYPE,
200: SEPARATOR = X_SEPARATOR,
201: TRACE_FILE_TOKEN = X_TRACE_FILE_TOKEN,

Line 211: update FND_DEBUG_OPTIONS_TL set

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: update FND_DEBUG_OPTIONS_TL set
212: DESCRIPTION = X_DESCRIPTION,
213: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 229: delete from FND_DEBUG_OPTIONS_TL T

225:
226: procedure ADD_LANGUAGE
227: is
228: begin
229: delete from FND_DEBUG_OPTIONS_TL T
230: where not exists
231: (select NULL
232: from FND_DEBUG_OPTIONS B
233: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME

Line 232: from FND_DEBUG_OPTIONS B

228: begin
229: delete from FND_DEBUG_OPTIONS_TL T
230: where not exists
231: (select NULL
232: from FND_DEBUG_OPTIONS B
233: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
234: );
235:
236: update FND_DEBUG_OPTIONS_TL T set (

Line 236: update FND_DEBUG_OPTIONS_TL T set (

232: from FND_DEBUG_OPTIONS B
233: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
234: );
235:
236: update FND_DEBUG_OPTIONS_TL T set (
237: DESCRIPTION
238: ) = (select
239: B.DESCRIPTION
240: from FND_DEBUG_OPTIONS_TL B

Line 240: from FND_DEBUG_OPTIONS_TL B

236: update FND_DEBUG_OPTIONS_TL T set (
237: DESCRIPTION
238: ) = (select
239: B.DESCRIPTION
240: from FND_DEBUG_OPTIONS_TL B
241: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
242: and B.LANGUAGE = T.SOURCE_LANG)
243: where (
244: T.DEBUG_OPTION_NAME,

Line 249: from FND_DEBUG_OPTIONS_TL SUBB, FND_DEBUG_OPTIONS_TL SUBT

245: T.LANGUAGE
246: ) in (select
247: SUBT.DEBUG_OPTION_NAME,
248: SUBT.LANGUAGE
249: from FND_DEBUG_OPTIONS_TL SUBB, FND_DEBUG_OPTIONS_TL SUBT
250: where SUBB.DEBUG_OPTION_NAME = SUBT.DEBUG_OPTION_NAME
251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
253: ));

Line 255: insert into FND_DEBUG_OPTIONS_TL (

251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
253: ));
254:
255: insert into FND_DEBUG_OPTIONS_TL (
256: DEBUG_OPTION_NAME,
257: DESCRIPTION,
258: CREATION_DATE,
259: CREATED_BY,

Line 275: from FND_DEBUG_OPTIONS_TL B, FND_LANGUAGES L

271: B.LAST_UPDATED_BY,
272: B.LAST_UPDATE_LOGIN,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from FND_DEBUG_OPTIONS_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL

Line 280: from FND_DEBUG_OPTIONS_TL T

276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from FND_DEBUG_OPTIONS_TL T
281: where T.DEBUG_OPTION_NAME = B.DEBUG_OPTION_NAME
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end ADD_LANGUAGE;
284:

Line 290: delete from FND_DEBUG_OPTIONS_TL

286: procedure DELETE_ROW (
287: X_DEBUG_OPTION_NAME in VARCHAR2
288: ) is
289: begin
290: delete from FND_DEBUG_OPTIONS_TL
291: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME;
292:
293: if (sql%notfound) then
294: raise no_data_found;

Line 297: delete from FND_DEBUG_OPTIONS

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: delete from FND_DEBUG_OPTIONS
298: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME;
299:
300: if (sql%notfound) then
301: raise no_data_found;

Line 319: from FND_DEBUG_OPTIONS

315: ENABLED_FLAG,
316: TYPE,
317: SEPARATOR,
318: TRACE_FILE_TOKEN
319: from FND_DEBUG_OPTIONS
320: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
321: for update of DEBUG_OPTION_NAME nowait;
322: recinfo c%rowtype;
323:

Line 327: from FND_DEBUG_OPTIONS_TL

323:
324: cursor c1 is select
325: DESCRIPTION,
326: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
327: from FND_DEBUG_OPTIONS_TL
328: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
329: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
330: for update of DEBUG_OPTION_NAME nowait;
331: begin

Line 378: FND_DEBUG_OPTIONS_PKG.translate_row(

374: X_OWNER in VARCHAR2,
375: X_DESCRIPTION in VARCHAR2) is
376: begin
377:
378: FND_DEBUG_OPTIONS_PKG.translate_row(
379: X_DEBUG_OPTION_NAME => X_DEBUG_OPTION_NAME,
380: X_OWNER=>X_OWNER,
381: X_DESCRIPTION=>X_DESCRIPTION,
382: x_custom_mode => '',

Line 416: update fnd_debug_options_tl set

412:
413: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
414: db_ludate, X_CUSTOM_MODE)) then
415:
416: update fnd_debug_options_tl set
417: DESCRIPTION=nvl(X_DESCRIPTION,DESCRIPTION),
418: SOURCE_LANG=userenv('LANG'),
419: last_update_date = f_ludate,
420: last_updated_by = f_luby,

Line 433: end FND_DEBUG_OPTIONS_PKG;

429:
430: end TRANSLATE_ROW;
431:
432:
433: end FND_DEBUG_OPTIONS_PKG;