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.OE_INLINE_FLEX dependencies on OE_DEBUG_PUB

Line 65: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

61: segment number;
62: prior_segment number;
63:
64: --
65: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
66: --
67: begin
68:
69: IF l_debug_level > 0 THEN

Line 70: oe_debug_pub.add( 'INSIDE SETUP_FLEXFIELD' ) ;

66: --
67: begin
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'INSIDE SETUP_FLEXFIELD' ) ;
71: END IF;
72: flex_start := flex_segments + 1;
73: segment := 0;
74: prior_segment := 0;

Line 77: oe_debug_pub.add( 'FLEX_CODE:'||FLEX_CODE ) ;

73: segment := 0;
74: prior_segment := 0;
75:
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'FLEX_CODE:'||FLEX_CODE ) ;
78: END IF;
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'STRUCTURE_ID:'||TO_CHAR ( STRUCTURE_ID ) ) ;
81: END IF;

Line 80: oe_debug_pub.add( 'STRUCTURE_ID:'||TO_CHAR ( STRUCTURE_ID ) ) ;

76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'FLEX_CODE:'||FLEX_CODE ) ;
78: END IF;
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'STRUCTURE_ID:'||TO_CHAR ( STRUCTURE_ID ) ) ;
81: END IF;
82:
83: for location in sel_flex_structure( 222, flex_code, structure_id)
84: loop

Line 87: oe_debug_pub.add( 'LOCATION.NAME='||LOCATION.NAME ) ;

83: for location in sel_flex_structure( 222, flex_code, structure_id)
84: loop
85:
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'LOCATION.NAME='||LOCATION.NAME ) ;
88: END IF;
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'LOCATION.NUM='||TO_CHAR ( LOCATION.NUM ) ) ;
91: END IF;

Line 90: oe_debug_pub.add( 'LOCATION.NUM='||TO_CHAR ( LOCATION.NUM ) ) ;

86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'LOCATION.NAME='||LOCATION.NAME ) ;
88: END IF;
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'LOCATION.NUM='||TO_CHAR ( LOCATION.NUM ) ) ;
91: END IF;
92: /*------------------------------------------------------------------+
93: | The Flex Preprocessor assumes that the Line Number Matches the |
94: | Column Number in Key Flexfield Definition |

Line 101: oe_debug_pub.add( 'LOCATION.NAME : '||LOCATION.NAME ) ;

97: | 2 2 LOCATION_SEGMENT_ID_2 |
98: | So we need to check that this assumption is true |
99: +------------------------------------------------------------------*/
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'LOCATION.NAME : '||LOCATION.NAME ) ;
102: END IF;
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'LOCATION.NUM : '||LOCATION.NUM ) ;
105: END IF;

Line 104: oe_debug_pub.add( 'LOCATION.NUM : '||LOCATION.NUM ) ;

100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'LOCATION.NAME : '||LOCATION.NAME ) ;
102: END IF;
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'LOCATION.NUM : '||LOCATION.NUM ) ;
105: END IF;
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add( 'LOCATION.COLUMN_NAME : '||LOCATION.COLUMN_NAME ) ;
108: END IF;

Line 107: oe_debug_pub.add( 'LOCATION.COLUMN_NAME : '||LOCATION.COLUMN_NAME ) ;

103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'LOCATION.NUM : '||LOCATION.NUM ) ;
105: END IF;
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add( 'LOCATION.COLUMN_NAME : '||LOCATION.COLUMN_NAME ) ;
108: END IF;
109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add( 'LOCATION.QUALIFIER : '||LOCATION.QUALIFIER ) ;
111: END IF;

Line 110: oe_debug_pub.add( 'LOCATION.QUALIFIER : '||LOCATION.QUALIFIER ) ;

106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add( 'LOCATION.COLUMN_NAME : '||LOCATION.COLUMN_NAME ) ;
108: END IF;
109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add( 'LOCATION.QUALIFIER : '||LOCATION.QUALIFIER ) ;
111: END IF;
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'LOCATION.PROMPT : '||LOCATION.PROMPT ) ;
114: END IF;

Line 113: oe_debug_pub.add( 'LOCATION.PROMPT : '||LOCATION.PROMPT ) ;

109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add( 'LOCATION.QUALIFIER : '||LOCATION.QUALIFIER ) ;
111: END IF;
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'LOCATION.PROMPT : '||LOCATION.PROMPT ) ;
114: END IF;
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'LOCATION.POS : '||LOCATION.POS ) ;
117: END IF;

Line 116: oe_debug_pub.add( 'LOCATION.POS : '||LOCATION.POS ) ;

112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'LOCATION.PROMPT : '||LOCATION.PROMPT ) ;
114: END IF;
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'LOCATION.POS : '||LOCATION.POS ) ;
117: END IF;
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( 'LOCATION.COLUMN_NUM :'||LOCATION.COLUMN_NUM ) ;
120: END IF;

Line 119: oe_debug_pub.add( 'LOCATION.COLUMN_NUM :'||LOCATION.COLUMN_NUM ) ;

115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'LOCATION.POS : '||LOCATION.POS ) ;
117: END IF;
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( 'LOCATION.COLUMN_NUM :'||LOCATION.COLUMN_NUM ) ;
120: END IF;
121:
122: if location.column_name like 'LOCATION_ID_SEGMENT_%' and
123: location.column_name <> location.column_num then

Line 125: oe_debug_pub.add( 'THE LINE NUMBER: '||TO_CHAR ( LOCATION.NUM ) ||' AND COLUMN SEGMENT NUMBER FOR '||LOCATION.COLUMN_NAME ||' MUST BE EQUAL.' ) ;

121:
122: if location.column_name like 'LOCATION_ID_SEGMENT_%' and
123: location.column_name <> location.column_num then
124: IF l_debug_level > 0 THEN
125: oe_debug_pub.add( 'THE LINE NUMBER: '||TO_CHAR ( LOCATION.NUM ) ||' AND COLUMN SEGMENT NUMBER FOR '||LOCATION.COLUMN_NAME ||' MUST BE EQUAL.' ) ;
126: END IF;
127: fnd_message.set_name('AR','GENERIC_MESSAGE');
128: fnd_message.set_token('GENERIC_TEXT','The Line Number '
129: ||to_char(location.num)

Line 152: oe_debug_pub.add( 'LOCATION_QUALIFIER='||LOCATION.QUALIFIER ) ;

148: flex_prompt( flex_segments ) := location.prompt;
149: flex_separator := location.separator;
150: prior_segment := location.num;
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( 'LOCATION_QUALIFIER='||LOCATION.QUALIFIER ) ;
153: END IF;
154: else
155:
156: /*------------------------------------------------------------------+

Line 174: oe_debug_pub.add( 'START POS='||TO_CHAR ( FLEX_START ) ) ;

170: flex_short_name := flex_code;
171: flex_id := structure_id;
172:
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'START POS='||TO_CHAR ( FLEX_START ) ) ;
175: END IF;
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'END POS='||TO_CHAR ( FLEX_END ) ) ;
178: END IF;

Line 177: oe_debug_pub.add( 'END POS='||TO_CHAR ( FLEX_END ) ) ;

173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'START POS='||TO_CHAR ( FLEX_START ) ) ;
175: END IF;
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'END POS='||TO_CHAR ( FLEX_END ) ) ;
178: END IF;
179:
180:
181: end setup_flexfield;

Line 189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

185: i in number ) return varchar2 is
186: str varchar2(1000);
187:
188: --
189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190: --
191: begin
192:
193: /*----------------------------------------------------------------------+

Line 251: oe_debug_pub.add( 'WHEN NO DATA FOUND TOKEN_EXPAN' ) ;

247:
248: exception
249: when no_data_found then
250: IF l_debug_level > 0 THEN
251: oe_debug_pub.add( 'WHEN NO DATA FOUND TOKEN_EXPAN' ) ;
252: END IF;
253:
254: when others then
255: IF l_debug_level > 0 THEN

Line 256: oe_debug_pub.add( 'WHEN OTHERS IN TOKEN_EXPAND' ) ;

252: END IF;
253:
254: when others then
255: IF l_debug_level > 0 THEN
256: oe_debug_pub.add( 'WHEN OTHERS IN TOKEN_EXPAND' ) ;
257: END IF;
258:
259: end token_expand;
260:

Line 264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

260:
261:
262: function delimit( word in varchar2 ) return varchar2 is
263: --
264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
265: --
266: begin
267: return( ' ' || word || ' ' );
268: end delimit;

Line 273: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

269:
270:
271: procedure add_to_list( list in out NOCOPY /* file.sql.39 change */ varchar2, value in varchar2 ) is
272: --
273: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
274: --
275: begin
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( '>> ADD_TO_LIST ( ' || LIST || ' , ' || VALUE || ' ) ' ) ;

Line 277: oe_debug_pub.add( '>> ADD_TO_LIST ( ' || LIST || ' , ' || VALUE || ' ) ' ) ;

273: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
274: --
275: begin
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( '>> ADD_TO_LIST ( ' || LIST || ' , ' || VALUE || ' ) ' ) ;
278: END IF;
279:
280: /* skip, the instr only searches for a character string(value) in list */
281: if instr( list, value ) <> 0

Line 290: oe_debug_pub.add( '<< ADD_TO_LIST ( ' || LIST || ' , ' || VALUE || ' ) ' ) ;

286: list := list || value;
287: end if;
288:
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add( '<< ADD_TO_LIST ( ' || LIST || ' , ' || VALUE || ' ) ' ) ;
291: END IF;
292: end add_to_list;
293:
294:

Line 309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

305: startpos number;
306: endpos number;
307:
308: --
309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
310: --
311: begin
312:
313: IF l_debug_level > 0 THEN

Line 314: oe_debug_pub.add( 'INSIDE QUALIFIER_LIST' ) ;

310: --
311: begin
312:
313: IF l_debug_level > 0 THEN
314: oe_debug_pub.add( 'INSIDE QUALIFIER_LIST' ) ;
315: END IF;
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add( 'QUALIFIERS='||QUALIFIERS ) ;
318: END IF;

Line 317: oe_debug_pub.add( 'QUALIFIERS='||QUALIFIERS ) ;

313: IF l_debug_level > 0 THEN
314: oe_debug_pub.add( 'INSIDE QUALIFIER_LIST' ) ;
315: END IF;
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add( 'QUALIFIERS='||QUALIFIERS ) ;
318: END IF;
319:
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add( '>> QUALIFIER_LIST ( ' || ' , ' || QUALIFIERS || ' ) ' ) ;

Line 321: oe_debug_pub.add( '>> QUALIFIER_LIST ( ' || ' , ' || QUALIFIERS || ' ) ' ) ;

317: oe_debug_pub.add( 'QUALIFIERS='||QUALIFIERS ) ;
318: END IF;
319:
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add( '>> QUALIFIER_LIST ( ' || ' , ' || QUALIFIERS || ' ) ' ) ;
322: END IF;
323:
324: quals := qualifiers;
325: list := null;

Line 330: oe_debug_pub.add( 'IF ALLREV' ) ;

326:
327:
328: if quals = 'ALLREV' then
329: IF l_debug_level > 0 THEN
330: oe_debug_pub.add( 'IF ALLREV' ) ;
331: END IF;
332: startpos := flex_end - flex_start;
333: endpos := 0;
334: step:=-1;

Line 336: oe_debug_pub.add( 'STARTPOS='||TO_CHAR ( STARTPOS ) ) ;

332: startpos := flex_end - flex_start;
333: endpos := 0;
334: step:=-1;
335: IF l_debug_level > 0 THEN
336: oe_debug_pub.add( 'STARTPOS='||TO_CHAR ( STARTPOS ) ) ;
337: END IF;
338: end if;
339:
340: i := startpos;

Line 344: oe_debug_pub.add( 'INSIDE LOOP' ) ;

340: i := startpos;
341: for k in 0 .. flex_end - flex_start
342: loop
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'INSIDE LOOP' ) ;
345: END IF;
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'FLEX_START='||TO_CHAR ( FLEX_START ) ) ;
348: END IF;

Line 347: oe_debug_pub.add( 'FLEX_START='||TO_CHAR ( FLEX_START ) ) ;

343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'INSIDE LOOP' ) ;
345: END IF;
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'FLEX_START='||TO_CHAR ( FLEX_START ) ) ;
348: END IF;
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'I='||TO_CHAR ( I ) ) ;
351: END IF;

Line 350: oe_debug_pub.add( 'I='||TO_CHAR ( I ) ) ;

346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'FLEX_START='||TO_CHAR ( FLEX_START ) ) ;
348: END IF;
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'I='||TO_CHAR ( I ) ) ;
351: END IF;
352: segment := flex_start + i;
353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add( 'SEGMENT='||TO_CHAR ( SEGMENT ) ) ;

Line 354: oe_debug_pub.add( 'SEGMENT='||TO_CHAR ( SEGMENT ) ) ;

350: oe_debug_pub.add( 'I='||TO_CHAR ( I ) ) ;
351: END IF;
352: segment := flex_start + i;
353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add( 'SEGMENT='||TO_CHAR ( SEGMENT ) ) ;
355: END IF;
356: IF l_debug_level > 0 THEN
357: oe_debug_pub.add( 'I=' || I || ' ' || LIST || ' --- ' || SEGMENT ) ;
358: END IF;

Line 357: oe_debug_pub.add( 'I=' || I || ' ' || LIST || ' --- ' || SEGMENT ) ;

353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add( 'SEGMENT='||TO_CHAR ( SEGMENT ) ) ;
355: END IF;
356: IF l_debug_level > 0 THEN
357: oe_debug_pub.add( 'I=' || I || ' ' || LIST || ' --- ' || SEGMENT ) ;
358: END IF;
359:
360: if list is not null then
361: list := list || delimit( segment );

Line 366: oe_debug_pub.add( 'LIST='||LIST ) ;

362: else
363: list := delimit( segment ) ;
364: end if;
365: IF l_debug_level > 0 THEN
366: oe_debug_pub.add( 'LIST='||LIST ) ;
367: END IF;
368:
369: i := i + step;
370: end loop;

Line 373: oe_debug_pub.add( '<< QUALIFIER_LIST: ' || LIST ) ;

369: i := i + step;
370: end loop;
371:
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( '<< QUALIFIER_LIST: ' || LIST ) ;
374: END IF;
375: return( list );
376:
377: end qualifier_list;

Line 392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

388: segment number;
389: l_segments varchar2(1000);
390: l_segment varchar2(1000);
391: --
392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
393: --
394: begin
395:
396: IF l_debug_level > 0 THEN

Line 397: oe_debug_pub.add( 'INSIDE EXPAND' ) ;

393: --
394: begin
395:
396: IF l_debug_level > 0 THEN
397: oe_debug_pub.add( 'INSIDE EXPAND' ) ;
398: END IF;
399: initialize;
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'AFTER INITIALIZE ' ) ;

Line 401: oe_debug_pub.add( 'AFTER INITIALIZE ' ) ;

397: oe_debug_pub.add( 'INSIDE EXPAND' ) ;
398: END IF;
399: initialize;
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'AFTER INITIALIZE ' ) ;
402: END IF;
403:
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( '>> EXPAND ( ' || ' , ' || QUALIFIERS || ' , ' || SEPARATOR || ' , ' || WORD || ' ) ' ) ;

Line 405: oe_debug_pub.add( '>> EXPAND ( ' || ' , ' || QUALIFIERS || ' , ' || SEPARATOR || ' , ' || WORD || ' ) ' ) ;

401: oe_debug_pub.add( 'AFTER INITIALIZE ' ) ;
402: END IF;
403:
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( '>> EXPAND ( ' || ' , ' || QUALIFIERS || ' , ' || SEPARATOR || ' , ' || WORD || ' ) ' ) ;
406: END IF;
407:
408: segment := flex_start;
409:

Line 419: oe_debug_pub.add( 'SEGMENTS='||SEGMENTS ) ;

415:
416: segments := qualifier_list(qualifiers );
417:
418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add( 'SEGMENTS='||SEGMENTS ) ;
420: END IF;
421: str := null;
422:
423: /*-------------------------------------------------------------------------+

Line 432: oe_debug_pub.add( '<< LOOP** DUMMY TRUE: ' ) ;

428: arp_standard */
429: begin
430:
431: if arp_standard.get_next_word( l_segments, l_segment ) then
432: oe_debug_pub.add( '<< LOOP** DUMMY TRUE: ' ) ;
433: else
434: oe_debug_pub.add( '<< LOOP** DUMMY FALSE: ' ) ;
435: end if;
436: exception

Line 434: oe_debug_pub.add( '<< LOOP** DUMMY FALSE: ' ) ;

430:
431: if arp_standard.get_next_word( l_segments, l_segment ) then
432: oe_debug_pub.add( '<< LOOP** DUMMY TRUE: ' ) ;
433: else
434: oe_debug_pub.add( '<< LOOP** DUMMY FALSE: ' ) ;
435: end if;
436: exception
437: when others then
438: oe_debug_pub.add( '<< LOOP** DUMMY OTHERS : '||sqlerrm ) ;

Line 438: oe_debug_pub.add( '<< LOOP** DUMMY OTHERS : '||sqlerrm ) ;

434: oe_debug_pub.add( '<< LOOP** DUMMY FALSE: ' ) ;
435: end if;
436: exception
437: when others then
438: oe_debug_pub.add( '<< LOOP** DUMMY OTHERS : '||sqlerrm ) ;
439: end;
440:
441:
442: while arp_standard.get_next_word( segments, segment )

Line 454: oe_debug_pub.add( '<< EXPAND: ' || STR ) ;

450: end loop;
451:
452:
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add( '<< EXPAND: ' || STR ) ;
455: END IF;
456: structure := str;
457:
458: EXCEPTION

Line 461: oe_debug_pub.add( 'WHEN OTHERS EXPAND' ) ;

457:
458: EXCEPTION
459: When others then
460: IF l_debug_level > 0 THEN
461: oe_debug_pub.add( 'WHEN OTHERS EXPAND' ) ;
462: END IF;
463:
464: end expand;
465:

Line 470: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

466:
467: function active_segments return number is
468: segments number;
469: --
470: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
471: --
472: begin
473:
474: segments := flex_end - flex_start + 1;

Line 491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

487:
488: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
489:
490: --
491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
492: --
493: begin -- Initialisation Section
494:
495: flex_segments := 0; -- Count of number of active segment records.

Line 508: oe_debug_pub.add( 'STRUCUTRE_ID='||TO_CHAR ( L_LOCATION_STRUCTURE_ID ) ) ;

504: l_location_structure_id := l_AR_Sys_Param_Rec.location_structure_id;
505: END IF;
506:
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'STRUCUTRE_ID='||TO_CHAR ( L_LOCATION_STRUCTURE_ID ) ) ;
509: END IF;
510: setup_flexfield(
511: 'RLOC',
512: l_location_structure_id