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_OPTION_VALUES_PKG dependencies on FND_DEBUG_OPTION_VALUES

Line 1: package body FND_DEBUG_OPTION_VALUES_PKG as

1: package body FND_DEBUG_OPTION_VALUES_PKG as
2: -- $Header: AFOAMDVB.pls 120.1 2005/07/02 03:02:55 appldev noship $
3:
4: procedure LOAD_ROW (
5: X_DEBUG_OPTION_NAME in VARCHAR2,

Line 18: FND_DEBUG_OPTION_VALUES_PKG.LOAD_ROW (

14:
15:
16: ) is
17: begin
18: FND_DEBUG_OPTION_VALUES_PKG.LOAD_ROW (
19: X_DEBUG_OPTION_NAME => X_DEBUG_OPTION_NAME,
20: X_DEBUG_OPTION_VALUE => X_DEBUG_OPTION_VALUE,
21: X_TRACE_FILE_ROUTINE => X_TRACE_FILE_ROUTINE,
22: X_TRACE_FILE_NODE =>X_TRACE_FILE_NODE,

Line 73: FND_DEBUG_OPTION_VALUES_PKG.UPDATE_ROW (

69: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
70: db_ludate, X_CUSTOM_MODE)) then
71:
72:
73: FND_DEBUG_OPTION_VALUES_PKG.UPDATE_ROW (
74: X_DEBUG_OPTION_NAME => X_DEBUG_OPTION_NAME,
75: X_DEBUG_OPTION_VALUE => X_DEBUG_OPTION_VALUE,
76: X_TRACE_FILE_ROUTINE => X_TRACE_FILE_ROUTINE,
77: X_TRACE_FILE_NODE =>X_TRACE_FILE_NODE,

Line 92: FND_DEBUG_OPTION_VALUES_PKG.INSERT_ROW (

88: end if;
89: exception
90: when NO_DATA_FOUND then
91:
92: FND_DEBUG_OPTION_VALUES_PKG.INSERT_ROW (
93: X_ROWID => row_id,
94: X_DEBUG_OPTION_NAME => X_DEBUG_OPTION_NAME,
95: X_DEBUG_OPTION_VALUE => X_DEBUG_OPTION_VALUE,
96: X_TRACE_FILE_ROUTINE => X_TRACE_FILE_ROUTINE,

Line 126: cursor C is select ROWID from FND_DEBUG_OPTION_VALUES

122: X_LAST_UPDATE_DATE in DATE,
123: X_LAST_UPDATED_BY in NUMBER,
124: X_LAST_UPDATE_LOGIN in NUMBER
125: ) is
126: cursor C is select ROWID from FND_DEBUG_OPTION_VALUES
127: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
128: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE
129: ;
130: begin

Line 134: insert into FND_DEBUG_OPTION_VALUES (

130: begin
131:
132:
133:
134: insert into FND_DEBUG_OPTION_VALUES (
135: TRACE_FILE_ROUTINE,
136: TRACE_FILE_NODE,
137: DEBUG_OPTION_NAME,
138: DEBUG_OPTION_VALUE,

Line 162: insert into FND_DEBUG_OPTION_VALUES_TL (

158: X_LAST_UPDATED_BY,
159: X_LAST_UPDATE_LOGIN
160: );
161:
162: insert into FND_DEBUG_OPTION_VALUES_TL (
163: DEBUG_OPTION_NAME,
164: DEBUG_OPTION_VALUE,
165: DESCRIPTION,
166: CREATION_DATE,

Line 188: from FND_DEBUG_OPTION_VALUES_TL T

184: from FND_LANGUAGES L
185: where L.INSTALLED_FLAG in ('I', 'B')
186: and not exists
187: (select NULL
188: from FND_DEBUG_OPTION_VALUES_TL T
189: where T.DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
190: and T.DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE
191: and T.LANGUAGE = L.LANGUAGE_CODE);
192:

Line 219: from FND_DEBUG_OPTION_VALUES

215: TRACE_FILE_NODE,
216: ENABLE_ROUTINE,
217: DISABLE_ROUTINE,
218: IS_FILE_TOKEN
219: from FND_DEBUG_OPTION_VALUES
220: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
221: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE
222: for update of DEBUG_OPTION_NAME nowait;
223: recinfo c%rowtype;

Line 228: from FND_DEBUG_OPTION_VALUES_TL

224:
225: cursor c1 is select
226: DESCRIPTION,
227: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
228: from FND_DEBUG_OPTION_VALUES_TL
229: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
230: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE
231: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
232: for update of DEBUG_OPTION_NAME nowait;

Line 287: update FND_DEBUG_OPTION_VALUES set

283: X_LAST_UPDATED_BY in NUMBER,
284: X_LAST_UPDATE_LOGIN in NUMBER
285: ) is
286: begin
287: update FND_DEBUG_OPTION_VALUES set
288: TRACE_FILE_ROUTINE = X_TRACE_FILE_ROUTINE,
289: TRACE_FILE_NODE = X_TRACE_FILE_NODE,
290: ENABLE_ROUTINE = X_ENABLE_ROUTINE,
291: DISABLE_ROUTINE = X_DISABLE_ROUTINE,

Line 303: update FND_DEBUG_OPTION_VALUES_TL set

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: update FND_DEBUG_OPTION_VALUES_TL set
304: DESCRIPTION = X_DESCRIPTION,
305: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
306: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
307: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 323: delete from FND_DEBUG_OPTION_VALUES_TL

319: X_DEBUG_OPTION_NAME in VARCHAR2,
320: X_DEBUG_OPTION_VALUE in VARCHAR2
321: ) is
322: begin
323: delete from FND_DEBUG_OPTION_VALUES_TL
324: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
325: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE;
326:
327: if (sql%notfound) then

Line 331: delete from FND_DEBUG_OPTION_VALUES

327: if (sql%notfound) then
328: raise no_data_found;
329: end if;
330:
331: delete from FND_DEBUG_OPTION_VALUES
332: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
333: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE;
334:
335: if (sql%notfound) then

Line 343: delete from FND_DEBUG_OPTION_VALUES_TL T

339:
340: procedure ADD_LANGUAGE
341: is
342: begin
343: delete from FND_DEBUG_OPTION_VALUES_TL T
344: where not exists
345: (select NULL
346: from FND_DEBUG_OPTION_VALUES B
347: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME

Line 346: from FND_DEBUG_OPTION_VALUES B

342: begin
343: delete from FND_DEBUG_OPTION_VALUES_TL T
344: where not exists
345: (select NULL
346: from FND_DEBUG_OPTION_VALUES B
347: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
348: and B.DEBUG_OPTION_VALUE = T.DEBUG_OPTION_VALUE
349: );
350:

Line 351: update FND_DEBUG_OPTION_VALUES_TL T set (

347: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
348: and B.DEBUG_OPTION_VALUE = T.DEBUG_OPTION_VALUE
349: );
350:
351: update FND_DEBUG_OPTION_VALUES_TL T set (
352: DESCRIPTION
353: ) = (select
354: B.DESCRIPTION
355: from FND_DEBUG_OPTION_VALUES_TL B

Line 355: from FND_DEBUG_OPTION_VALUES_TL B

351: update FND_DEBUG_OPTION_VALUES_TL T set (
352: DESCRIPTION
353: ) = (select
354: B.DESCRIPTION
355: from FND_DEBUG_OPTION_VALUES_TL B
356: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
357: and B.DEBUG_OPTION_VALUE = T.DEBUG_OPTION_VALUE
358: and B.LANGUAGE = T.SOURCE_LANG)
359: where (

Line 367: from FND_DEBUG_OPTION_VALUES_TL SUBB, FND_DEBUG_OPTION_VALUES_TL SUBT

363: ) in (select
364: SUBT.DEBUG_OPTION_NAME,
365: SUBT.DEBUG_OPTION_VALUE,
366: SUBT.LANGUAGE
367: from FND_DEBUG_OPTION_VALUES_TL SUBB, FND_DEBUG_OPTION_VALUES_TL SUBT
368: where SUBB.DEBUG_OPTION_NAME = SUBT.DEBUG_OPTION_NAME
369: and SUBB.DEBUG_OPTION_VALUE = SUBT.DEBUG_OPTION_VALUE
370: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
371: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 374: insert into FND_DEBUG_OPTION_VALUES_TL (

370: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
371: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
372: ));
373:
374: insert into FND_DEBUG_OPTION_VALUES_TL (
375: DEBUG_OPTION_NAME,
376: DEBUG_OPTION_VALUE,
377: DESCRIPTION,
378: CREATION_DATE,

Line 396: from FND_DEBUG_OPTION_VALUES_TL B, FND_LANGUAGES L

392: B.LAST_UPDATED_BY,
393: B.LAST_UPDATE_LOGIN,
394: L.LANGUAGE_CODE,
395: B.SOURCE_LANG
396: from FND_DEBUG_OPTION_VALUES_TL B, FND_LANGUAGES L
397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL

Line 401: from FND_DEBUG_OPTION_VALUES_TL T

397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL
401: from FND_DEBUG_OPTION_VALUES_TL T
402: where T.DEBUG_OPTION_NAME = B.DEBUG_OPTION_NAME
403: and T.DEBUG_OPTION_VALUE = B.DEBUG_OPTION_VALUE
404: and T.LANGUAGE = L.LANGUAGE_CODE);
405: end ADD_LANGUAGE;

Line 421: FND_DEBUG_OPTION_VALUES_PKG.translate_row(

417: X_OWNER in VARCHAR2,
418: X_DESCRIPTION in VARCHAR2) is
419: begin
420:
421: FND_DEBUG_OPTION_VALUES_PKG.translate_row(
422: X_DEBUG_OPTION_NAME => X_DEBUG_OPTION_NAME,
423: X_DEBUG_OPTION_VALUE => X_DEBUG_OPTION_VALUE,
424: X_OWNER=>X_OWNER,
425: X_DESCRIPTION=>X_DESCRIPTION,

Line 461: update fnd_debug_option_values_tl set

457:
458: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
459: db_ludate, X_CUSTOM_MODE)) then
460:
461: update fnd_debug_option_values_tl set
462: DESCRIPTION=nvl(X_DESCRIPTION,DESCRIPTION),
463: SOURCE_LANG=userenv('LANG'),
464: last_update_date = f_ludate,
465: last_updated_by = f_luby,

Line 480: end FND_DEBUG_OPTION_VALUES_PKG;

476:
477: end TRANSLATE_ROW;
478:
479:
480: end FND_DEBUG_OPTION_VALUES_PKG;