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_PROFILE dependencies on OE_DEBUG_PUB

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

238: l_id_passed VARCHAR2(1) := 'N';
239: p_entity_id NUMBER;
240:
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: IF l_debug_level > 0 THEN

Line 247: oe_debug_pub.add('ENTERING OE_PROFILE.VALUE');

243: --
244: BEGIN
245:
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add('ENTERING OE_PROFILE.VALUE');
248: oe_debug_pub.add('header_id: ' || p_header_id);
249: oe_debug_pub.add('line_id: ' || p_line_id);
250: oe_debug_pub.add('profile option: '|| p_profile_option_name);
251: END IF;

Line 248: oe_debug_pub.add('header_id: ' || p_header_id);

244: BEGIN
245:
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add('ENTERING OE_PROFILE.VALUE');
248: oe_debug_pub.add('header_id: ' || p_header_id);
249: oe_debug_pub.add('line_id: ' || p_line_id);
250: oe_debug_pub.add('profile option: '|| p_profile_option_name);
251: END IF;
252: IF OE_GLOBALS.G_FLOW_RESTARTED AND (l_debug_level > 0) THEN

Line 249: oe_debug_pub.add('line_id: ' || p_line_id);

245:
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add('ENTERING OE_PROFILE.VALUE');
248: oe_debug_pub.add('header_id: ' || p_header_id);
249: oe_debug_pub.add('line_id: ' || p_line_id);
250: oe_debug_pub.add('profile option: '|| p_profile_option_name);
251: END IF;
252: IF OE_GLOBALS.G_FLOW_RESTARTED AND (l_debug_level > 0) THEN
253: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to TRUE');

Line 250: oe_debug_pub.add('profile option: '|| p_profile_option_name);

246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add('ENTERING OE_PROFILE.VALUE');
248: oe_debug_pub.add('header_id: ' || p_header_id);
249: oe_debug_pub.add('line_id: ' || p_line_id);
250: oe_debug_pub.add('profile option: '|| p_profile_option_name);
251: END IF;
252: IF OE_GLOBALS.G_FLOW_RESTARTED AND (l_debug_level > 0) THEN
253: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to TRUE');
254: ELSE

Line 253: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to TRUE');

249: oe_debug_pub.add('line_id: ' || p_line_id);
250: oe_debug_pub.add('profile option: '|| p_profile_option_name);
251: END IF;
252: IF OE_GLOBALS.G_FLOW_RESTARTED AND (l_debug_level > 0) THEN
253: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to TRUE');
254: ELSE
255: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to FALSE');
256: END IF;
257:

Line 255: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to FALSE');

251: END IF;
252: IF OE_GLOBALS.G_FLOW_RESTARTED AND (l_debug_level > 0) THEN
253: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to TRUE');
254: ELSE
255: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to FALSE');
256: END IF;
257:
258: IF OE_GLOBALS.G_USE_CREATED_BY_CONTEXT AND (l_debug_level > 0) THEN
259: oe_debug_pub.add('USE CREATED_BY GLOBAL set to TRUE');

Line 259: oe_debug_pub.add('USE CREATED_BY GLOBAL set to TRUE');

255: oe_debug_pub.add('FLOW_RESTARTED GLOBAL set to FALSE');
256: END IF;
257:
258: IF OE_GLOBALS.G_USE_CREATED_BY_CONTEXT AND (l_debug_level > 0) THEN
259: oe_debug_pub.add('USE CREATED_BY GLOBAL set to TRUE');
260: ELSE
261: oe_debug_pub.add('USE CREATED_BY GLOBAL set to FALSE');
262: END IF;
263:

Line 261: oe_debug_pub.add('USE CREATED_BY GLOBAL set to FALSE');

257:
258: IF OE_GLOBALS.G_USE_CREATED_BY_CONTEXT AND (l_debug_level > 0) THEN
259: oe_debug_pub.add('USE CREATED_BY GLOBAL set to TRUE');
260: ELSE
261: oe_debug_pub.add('USE CREATED_BY GLOBAL set to FALSE');
262: END IF;
263:
264:
265:

Line 299: oe_debug_pub.add('context not found in cache');

295: --triplet was not found in the cache
296: --retrieve triplet values
297:
298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add('context not found in cache');
300: END IF;
301:
302:
303: BEGIN

Line 305: oe_debug_pub.add('getting user and org from base tables');

301:
302:
303: BEGIN
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add('getting user and org from base tables');
306: END IF;
307: IF l_wf_entity = OE_GLOBALS.G_WFI_HDR THEN
308:
309: SELECT created_by, org_id

Line 325: oe_debug_pub.add('IN NO_DATA_FOUND when retrieving user and org');

321: END IF;
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: IF l_debug_level > 0 THEN
325: oe_debug_pub.add('IN NO_DATA_FOUND when retrieving user and org');
326: END IF;
327: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
328: THEN
329: OE_MSG_PUB.Add_Exc_Msg

Line 337: oe_debug_pub.add('IN OTHERS when retrieving user and org' || SQLERRM);

333: END IF;
334: Null;
335: WHEN OTHERS THEN
336: IF l_debug_level > 0 THEN
337: oe_debug_pub.add('IN OTHERS when retrieving user and org' || SQLERRM);
338: END IF;
339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
340: THEN
341: OE_MSG_PUB.Add_Exc_Msg

Line 362: oe_debug_pub.add('before caching the retrieved context');

358: );
359:
360:
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add('before caching the retrieved context');
363: END IF;
364: --Store retrieved triplet values in cache
365: PUT_CACHED_CONTEXT( p_entity => l_wf_entity,
366: p_entity_id => p_entity_id,

Line 372: oe_debug_pub.add('after caching the retrieved context');

368: p_user_id => l_cached_user_id,
369: p_responsibility_id => l_cached_resp_id,
370: p_org_id => l_cached_org_id);
371: IF l_debug_level > 0 THEN
372: oe_debug_pub.add('after caching the retrieved context');
373: END IF;
374:
375: END IF;
376: -- end of l_get_cache_triplet_result <> 'S'

Line 379: oe_debug_pub.add('before attempting to get the cached profile option value');

375: END IF;
376: -- end of l_get_cache_triplet_result <> 'S'
377: -- at this point we should have the context triplet
378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add('before attempting to get the cached profile option value');
380: END IF;
381: GET_CACHED_PROFILE_FOR_CONTEXT( p_profile_option_name => p_profile_option_name,
382: p_application_id => l_cached_resp_appl_id,
383: p_user_id => l_cached_user_id,

Line 389: oe_debug_pub.add('after attempting to get the cached profile option value');

385: p_org_id => l_cached_org_id,
386: x_profile_option_value => l_profile_option_value,
387: x_result => l_get_cache_profile_result);
388: IF l_debug_level > 0 THEN
389: oe_debug_pub.add('after attempting to get the cached profile option value');
390: END IF;
391:
392: IF l_get_cache_profile_result <> 'S' THEN
393: -- profile option value was not found in cache.

Line 396: oe_debug_pub.add('profile value was not found in the cache...calling FND_PROFILE.value_specific');

392: IF l_get_cache_profile_result <> 'S' THEN
393: -- profile option value was not found in cache.
394: -- call FND_PROFILE.Value_Specific to retrieve context-based profile option value
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add('profile value was not found in the cache...calling FND_PROFILE.value_specific');
397: END IF;
398: l_profile_option_value := FND_PROFILE.Value_Specific(p_profile_option_name, l_cached_user_id,
399: l_cached_resp_id, l_cached_resp_appl_id,
400: l_cached_org_id);

Line 403: oe_debug_pub.add('profile option value from value_specific: ' || l_profile_option_value);

399: l_cached_resp_id, l_cached_resp_appl_id,
400: l_cached_org_id);
401:
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add('profile option value from value_specific: ' || l_profile_option_value);
404: END IF;
405:
406: IF l_profile_option_value IS NULL THEN
407: --make original call to FND_PROFILE.Value

Line 409: oe_debug_pub.add('got NULL...calling FND_PROFILE.value');

405:
406: IF l_profile_option_value IS NULL THEN
407: --make original call to FND_PROFILE.Value
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('got NULL...calling FND_PROFILE.value');
410: END IF;
411: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
412:
413: IF l_debug_level > 0 THEN

Line 414: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

410: END IF;
411: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
412:
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
415: END IF;
416:
417: ELSE
418: -- FND_PROFILE.Value_Specfic returned a value, so cache it for later use

Line 420: oe_debug_pub.add('before caching the retrieved profile option value');

416:
417: ELSE
418: -- FND_PROFILE.Value_Specfic returned a value, so cache it for later use
419: IF l_debug_level > 0 THEN
420: oe_debug_pub.add('before caching the retrieved profile option value');
421: END IF;
422: PUT_CACHED_PROFILE_FOR_CONTEXT( p_profile_option_name => p_profile_option_name,
423: p_application_id => l_cached_resp_appl_id,
424: p_user_id => l_cached_user_id,

Line 430: oe_debug_pub.add('after caching the retrieved profile option value');

426: p_org_id => l_cached_org_id,
427: p_profile_option_value => l_profile_option_value);
428:
429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add('after caching the retrieved profile option value');
431: END IF;
432: END IF;
433: --end of l_profile_option_value IS NULL
434: END IF;

Line 439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');

435: -- end of l_get_cache_profile_result <> 'S'
436: ELSE
437: -- no id was passed so call should use session context so use FND_PROFILE.value
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');
440: END IF;
441: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

Line 443: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

439: oe_debug_pub.add('no id was passed, calling FND_PROFILE.value');
440: END IF;
441: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
444: END IF;
445: END IF;
446: -- end of l_id_passed = 'Y'
447: ELSE

Line 450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');

446: -- end of l_id_passed = 'Y'
447: ELSE
448: --neither flag was set so call should use session context so use FND_PROFILE.value
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');
451: END IF;
452: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

Line 454: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);

450: oe_debug_pub.add('neither global was set, calling FND_PROFILE.value');
451: END IF;
452: l_profile_option_value := FND_PROFILE.Value(p_profile_option_name);
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('profile option value from value: ' || l_profile_option_value);
455: END IF;
456: END IF;
457: -- end of OE_GLOBALS.G_FLOW_RESTARTED OR
458: -- OE_GLOBALS.G_USE_CREATED_BY_CONTEXT

Line 461: oe_debug_pub.add('profile option value being returned: ' || l_profile_option_value);

457: -- end of OE_GLOBALS.G_FLOW_RESTARTED OR
458: -- OE_GLOBALS.G_USE_CREATED_BY_CONTEXT
459: -- at this point we should have the profile option value
460: IF l_debug_level > 0 THEN
461: oe_debug_pub.add('profile option value being returned: ' || l_profile_option_value);
462: oe_debug_pub.add('EXITING OE_PROFILE.VALUE');
463: END IF;
464: Return l_profile_option_value;
465:

Line 462: oe_debug_pub.add('EXITING OE_PROFILE.VALUE');

458: -- OE_GLOBALS.G_USE_CREATED_BY_CONTEXT
459: -- at this point we should have the profile option value
460: IF l_debug_level > 0 THEN
461: oe_debug_pub.add('profile option value being returned: ' || l_profile_option_value);
462: oe_debug_pub.add('EXITING OE_PROFILE.VALUE');
463: END IF;
464: Return l_profile_option_value;
465:
466: EXCEPTION

Line 469: oe_debug_pub.add('IN OTHERS IN OE_PROFILE.VALUE:' || SQLERRM);

465:
466: EXCEPTION
467: WHEN OTHERS THEN
468: IF l_debug_level > 0 THEN
469: oe_debug_pub.add('IN OTHERS IN OE_PROFILE.VALUE:' || SQLERRM);
470: END IF;
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: OE_MSG_PUB.Add_Exc_Msg

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

488: x_org_id OUT NOCOPY NUMBER,
489: x_result OUT NOCOPY VARCHAR2)
490: IS
491: --
492: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
493: --
494: BEGIN
495:
496: IF l_debug_level > 0 THEN

Line 497: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_CONTEXT');

493: --
494: BEGIN
495:
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_CONTEXT');
498: oe_debug_pub.add('entity: ' || p_entity);
499: oe_debug_pub.add('entity_id: ' || p_entity_id);
500: END IF;
501:

Line 498: oe_debug_pub.add('entity: ' || p_entity);

494: BEGIN
495:
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_CONTEXT');
498: oe_debug_pub.add('entity: ' || p_entity);
499: oe_debug_pub.add('entity_id: ' || p_entity_id);
500: END IF;
501:
502:

Line 499: oe_debug_pub.add('entity_id: ' || p_entity_id);

495:
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_CONTEXT');
498: oe_debug_pub.add('entity: ' || p_entity);
499: oe_debug_pub.add('entity_id: ' || p_entity_id);
500: END IF;
501:
502:
503: IF (p_entity = OE_GLOBALS.G_WFI_HDR) THEN

Line 506: oe_debug_pub.add('Context was found in cache');

502:
503: IF (p_entity = OE_GLOBALS.G_WFI_HDR) THEN
504: IF Header_Context_Tbl.EXISTS(p_entity_id) THEN
505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add('Context was found in cache');
507: END IF;
508: --triplet values have already been cached for this line_id
509: x_application_id := Header_Context_Tbl(p_entity_id).resp_appl_id;
510: x_user_id := Header_Context_Tbl(p_entity_id).user_id;

Line 517: oe_debug_pub.add('Context was NOT found in cache');

513: x_result := 'S';
514:
515: ELSE
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add('Context was NOT found in cache');
518: END IF;
519: --triplet values have not been cached for this line_id
520: x_application_id := null;
521: x_user_id := null;

Line 530: oe_debug_pub.add('Context was found in cache');

526: --end of Header_Context_Tbl.EXISTS(p_entity_id)
527: ELSIF (p_entity = OE_GLOBALS.G_WFI_LIN) THEN
528: IF Line_Context_Tbl.EXISTS(p_entity_id) THEN
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add('Context was found in cache');
531: END IF;
532: --triplet values have already been cached for this line_id
533: x_application_id := Line_Context_Tbl(p_entity_id).resp_appl_id;
534: x_user_id := Line_Context_Tbl(p_entity_id).user_id;

Line 541: oe_debug_pub.add('Context was NOT found in cache');

537: x_result := 'S';
538:
539: ELSE
540: IF l_debug_level > 0 THEN
541: oe_debug_pub.add('Context was NOT found in cache');
542: END IF;
543: --triplet values have not been cached for this line_id
544: x_application_id := null;
545: x_user_id := null;

Line 555: oe_debug_pub.add('application from cache: ' || x_application_id);

551: END IF;
552: --end of p_entity = OE_GLOBALS.G_WFI_HDR
553:
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add('application from cache: ' || x_application_id);
556: oe_debug_pub.add('user from cache: ' || x_user_id);
557: oe_debug_pub.add('responsibility from cache: ' || x_responsibility_id);
558: oe_debug_pub.add('org from cache: ' || x_org_id);
559: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_CONTEXT');

Line 556: oe_debug_pub.add('user from cache: ' || x_user_id);

552: --end of p_entity = OE_GLOBALS.G_WFI_HDR
553:
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add('application from cache: ' || x_application_id);
556: oe_debug_pub.add('user from cache: ' || x_user_id);
557: oe_debug_pub.add('responsibility from cache: ' || x_responsibility_id);
558: oe_debug_pub.add('org from cache: ' || x_org_id);
559: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_CONTEXT');
560: END IF;

Line 557: oe_debug_pub.add('responsibility from cache: ' || x_responsibility_id);

553:
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add('application from cache: ' || x_application_id);
556: oe_debug_pub.add('user from cache: ' || x_user_id);
557: oe_debug_pub.add('responsibility from cache: ' || x_responsibility_id);
558: oe_debug_pub.add('org from cache: ' || x_org_id);
559: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_CONTEXT');
560: END IF;
561:

Line 558: oe_debug_pub.add('org from cache: ' || x_org_id);

554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add('application from cache: ' || x_application_id);
556: oe_debug_pub.add('user from cache: ' || x_user_id);
557: oe_debug_pub.add('responsibility from cache: ' || x_responsibility_id);
558: oe_debug_pub.add('org from cache: ' || x_org_id);
559: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_CONTEXT');
560: END IF;
561:
562:

Line 559: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_CONTEXT');

555: oe_debug_pub.add('application from cache: ' || x_application_id);
556: oe_debug_pub.add('user from cache: ' || x_user_id);
557: oe_debug_pub.add('responsibility from cache: ' || x_responsibility_id);
558: oe_debug_pub.add('org from cache: ' || x_org_id);
559: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_CONTEXT');
560: END IF;
561:
562:
563: EXCEPTION

Line 566: oe_debug_pub.add('OTHERS IN OE_PROFILE.GET_CACHED_CONTEXT: ' || SQLERRM);

562:
563: EXCEPTION
564: WHEN OTHERS THEN
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add('OTHERS IN OE_PROFILE.GET_CACHED_CONTEXT: ' || SQLERRM);
567: END IF;
568: x_result := 'E';
569: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
570: THEN

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

587: l_new_line_position number;
588: l_new_header_position number;
589:
590: --
591: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
592: --
593: BEGIN
594:
595: IF l_debug_level > 0 THEN

Line 596: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_CONTEXT');

592: --
593: BEGIN
594:
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_CONTEXT');
597: oe_debug_pub.add('entity: ' || p_entity);
598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);

Line 597: oe_debug_pub.add('entity: ' || p_entity);

593: BEGIN
594:
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_CONTEXT');
597: oe_debug_pub.add('entity: ' || p_entity);
598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);
601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);

Line 598: oe_debug_pub.add('entity_id: ' || p_entity_id);

594:
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_CONTEXT');
597: oe_debug_pub.add('entity: ' || p_entity);
598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);
601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
602: oe_debug_pub.add('org: ' || p_org_id);

Line 599: oe_debug_pub.add('application: '|| p_application_id);

595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_CONTEXT');
597: oe_debug_pub.add('entity: ' || p_entity);
598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);
601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
602: oe_debug_pub.add('org: ' || p_org_id);
603: END IF;

Line 600: oe_debug_pub.add('user: ' || p_user_id);

596: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_CONTEXT');
597: oe_debug_pub.add('entity: ' || p_entity);
598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);
601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
602: oe_debug_pub.add('org: ' || p_org_id);
603: END IF;
604:

Line 601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);

597: oe_debug_pub.add('entity: ' || p_entity);
598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);
601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
602: oe_debug_pub.add('org: ' || p_org_id);
603: END IF;
604:
605:

Line 602: oe_debug_pub.add('org: ' || p_org_id);

598: oe_debug_pub.add('entity_id: ' || p_entity_id);
599: oe_debug_pub.add('application: '|| p_application_id);
600: oe_debug_pub.add('user: ' || p_user_id);
601: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
602: oe_debug_pub.add('org: ' || p_org_id);
603: END IF;
604:
605:
606:

Line 609: oe_debug_pub.add('the cache is currently holding ' || Header_Context_Tbl.count || ' records.');

605:
606:
607: IF (p_entity = OE_GLOBALS.G_WFI_HDR) THEN
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add('the cache is currently holding ' || Header_Context_Tbl.count || ' records.');
610: END IF;
611:
612: -- triplet values need to be cached for this header_id
613: --first check to see if there is space in the cache

Line 616: oe_debug_pub.add('there is space in the cache');

612: -- triplet values need to be cached for this header_id
613: --first check to see if there is space in the cache
614: IF Header_Context_Tbl.count < MAX_CONTEXT_CACHE_SIZE THEN
615: IF l_debug_level > 0 THEN
616: oe_debug_pub.add('there is space in the cache');
617: END IF;
618: --there is space in the cache so simply add the data
619: -- set new position
620: l_new_header_position := Header_Context_Tbl.count + 1;

Line 630: oe_debug_pub.add('added new record at position: ' || Header_Context_Tbl(p_entity_id).position);

626: Header_Context_Tbl(p_entity_id).org_id := p_org_id;
627:
628:
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add('added new record at position: ' || Header_Context_Tbl(p_entity_id).position);
631: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' records in the cache after adding the new record');
632: END IF;
633:
634: ELSE

Line 631: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' records in the cache after adding the new record');

627:
628:
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add('added new record at position: ' || Header_Context_Tbl(p_entity_id).position);
631: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' records in the cache after adding the new record');
632: END IF;
633:
634: ELSE
635: --the cache is full, so a record needs to be removed

Line 637: oe_debug_pub.add('cache is full. removing a record...');

633:
634: ELSE
635: --the cache is full, so a record needs to be removed
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add('cache is full. removing a record...');
638: END IF;
639: I := Header_Context_Tbl.First;
640: While I is NOT NULL
641: LOOP

Line 643: oe_debug_pub.add('position: ' || Header_Context_Tbl(I).position || ' I: ' || I);

639: I := Header_Context_Tbl.First;
640: While I is NOT NULL
641: LOOP
642: IF l_debug_level > 0 THEN
643: oe_debug_pub.add('position: ' || Header_Context_Tbl(I).position || ' I: ' || I);
644: END IF;
645: IF Header_Context_Tbl(I).position = 1 THEN
646: --if the record is in position 1, remove it
647: Header_Context_Tbl.Delete(I);

Line 649: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);

645: IF Header_Context_Tbl(I).position = 1 THEN
646: --if the record is in position 1, remove it
647: Header_Context_Tbl.Delete(I);
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);
650: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' header records in the cache');
651: END IF;
652: ELSE
653: --record position needs to be shifted down

Line 650: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' header records in the cache');

646: --if the record is in position 1, remove it
647: Header_Context_Tbl.Delete(I);
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);
650: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' header records in the cache');
651: END IF;
652: ELSE
653: --record position needs to be shifted down
654: Header_Context_Tbl(I).position := Header_Context_Tbl(I).position - 1;

Line 670: oe_debug_pub.add('added new record at position: ' || Header_Context_Tbl(p_entity_id).position);

666: Header_Context_Tbl(p_entity_id).resp_id := p_responsibility_id;
667: Header_Context_Tbl(p_entity_id).org_id := p_org_id;
668:
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('added new record at position: ' || Header_Context_Tbl(p_entity_id).position);
671: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' records in the cache after adding the new record');
672: END IF;
673:
674: END IF;

Line 671: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' records in the cache after adding the new record');

667: Header_Context_Tbl(p_entity_id).org_id := p_org_id;
668:
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('added new record at position: ' || Header_Context_Tbl(p_entity_id).position);
671: oe_debug_pub.add('now there are ' || Header_Context_Tbl.count || ' records in the cache after adding the new record');
672: END IF;
673:
674: END IF;
675: -- end of Header_Context_Tbl.count < MAX_CONTEXT_CACHE_SIZE

Line 680: oe_debug_pub.add('the cache is currently holding ' || Line_Context_Tbl.count || ' records.');

676:
677:
678: ELSIF (p_entity = OE_GLOBALS.G_WFI_LIN) THEN
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add('the cache is currently holding ' || Line_Context_Tbl.count || ' records.');
681: END IF;
682:
683: -- triplet values need to be cached for this line_id
684: --first check to see if there is space in the cache

Line 687: oe_debug_pub.add('there is space in the cache.');

683: -- triplet values need to be cached for this line_id
684: --first check to see if there is space in the cache
685: IF Line_Context_Tbl.count < MAX_CONTEXT_CACHE_SIZE THEN
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add('there is space in the cache.');
688: END IF;
689: --there is space in the cache so simply add the data
690: -- set new position
691: l_new_line_position := Line_Context_Tbl.count + 1;

Line 699: oe_debug_pub.add('added new record at position: ' || Line_Context_Tbl(p_entity_id).position);

695: Line_Context_Tbl(p_entity_id).resp_id := p_responsibility_id;
696: Line_Context_Tbl(p_entity_id).org_id := p_org_id;
697:
698: IF l_debug_level > 0 THEN
699: oe_debug_pub.add('added new record at position: ' || Line_Context_Tbl(p_entity_id).position);
700: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' records in the cache after adding the new record');
701: END IF;
702:
703:

Line 700: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' records in the cache after adding the new record');

696: Line_Context_Tbl(p_entity_id).org_id := p_org_id;
697:
698: IF l_debug_level > 0 THEN
699: oe_debug_pub.add('added new record at position: ' || Line_Context_Tbl(p_entity_id).position);
700: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' records in the cache after adding the new record');
701: END IF;
702:
703:
704: ELSE

Line 706: oe_debug_pub.add('cache is full. removing a record...');

702:
703:
704: ELSE
705: IF l_debug_level > 0 THEN
706: oe_debug_pub.add('cache is full. removing a record...');
707: END IF;
708: --the cache is full, so a record needs to be removed
709: I := Line_Context_Tbl.First;
710: While I is NOT NULL

Line 713: oe_debug_pub.add('position: ' || Line_Context_Tbl(I).position || ' I: ' || I);

709: I := Line_Context_Tbl.First;
710: While I is NOT NULL
711: LOOP
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add('position: ' || Line_Context_Tbl(I).position || ' I: ' || I);
714: END IF;
715: IF Line_Context_Tbl(I).position = 1 THEN
716: --if the record is in position 1, remove it
717: Line_Context_Tbl.Delete(I);

Line 719: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);

715: IF Line_Context_Tbl(I).position = 1 THEN
716: --if the record is in position 1, remove it
717: Line_Context_Tbl.Delete(I);
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);
720: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' line records in the cache');
721: END IF;
722: ELSE
723: --record position needs to be shifted down

Line 720: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' line records in the cache');

716: --if the record is in position 1, remove it
717: Line_Context_Tbl.Delete(I);
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);
720: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' line records in the cache');
721: END IF;
722: ELSE
723: --record position needs to be shifted down
724: Line_Context_Tbl(I).position := Line_Context_Tbl(I).position - 1;

Line 739: oe_debug_pub.add('added new record at position: ' || Line_Context_Tbl(p_entity_id).position);

735: Line_Context_Tbl(p_entity_id).resp_id := p_responsibility_id;
736: Line_Context_Tbl(p_entity_id).org_id := p_org_id;
737:
738: IF l_debug_level > 0 THEN
739: oe_debug_pub.add('added new record at position: ' || Line_Context_Tbl(p_entity_id).position);
740: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' records in the cache after adding the new record');
741: END IF;
742:
743:

Line 740: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' records in the cache after adding the new record');

736: Line_Context_Tbl(p_entity_id).org_id := p_org_id;
737:
738: IF l_debug_level > 0 THEN
739: oe_debug_pub.add('added new record at position: ' || Line_Context_Tbl(p_entity_id).position);
740: oe_debug_pub.add('now there are ' || Line_Context_Tbl.count || ' records in the cache after adding the new record');
741: END IF;
742:
743:
744: END IF;

Line 754: oe_debug_pub.add('OTHERS IN OE_PROFILE.PUT_CACHED_CONTEXT: ' || SQLERRM);

750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: IF l_debug_level > 0 THEN
754: oe_debug_pub.add('OTHERS IN OE_PROFILE.PUT_CACHED_CONTEXT: ' || SQLERRM);
755: END IF;
756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: OE_MSG_PUB.Add_Exc_Msg

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

775:
776: l_concat_segment VARCHAR2(100);
777:
778: --
779: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
780: --
781:
782: BEGIN
783:

Line 785: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');

781:
782: BEGIN
783:
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');
786: oe_debug_pub.add('profile: ' || p_profile_option_name);
787: oe_debug_pub.add('application: '|| p_application_id);
788: oe_debug_pub.add('user: ' || p_user_id);
789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);

Line 786: oe_debug_pub.add('profile: ' || p_profile_option_name);

782: BEGIN
783:
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');
786: oe_debug_pub.add('profile: ' || p_profile_option_name);
787: oe_debug_pub.add('application: '|| p_application_id);
788: oe_debug_pub.add('user: ' || p_user_id);
789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
790: oe_debug_pub.add('org: ' || p_org_id);

Line 787: oe_debug_pub.add('application: '|| p_application_id);

783:
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');
786: oe_debug_pub.add('profile: ' || p_profile_option_name);
787: oe_debug_pub.add('application: '|| p_application_id);
788: oe_debug_pub.add('user: ' || p_user_id);
789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
790: oe_debug_pub.add('org: ' || p_org_id);
791: END IF;

Line 788: oe_debug_pub.add('user: ' || p_user_id);

784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');
786: oe_debug_pub.add('profile: ' || p_profile_option_name);
787: oe_debug_pub.add('application: '|| p_application_id);
788: oe_debug_pub.add('user: ' || p_user_id);
789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
790: oe_debug_pub.add('org: ' || p_org_id);
791: END IF;
792:

Line 789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);

785: oe_debug_pub.add('ENTERING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');
786: oe_debug_pub.add('profile: ' || p_profile_option_name);
787: oe_debug_pub.add('application: '|| p_application_id);
788: oe_debug_pub.add('user: ' || p_user_id);
789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
790: oe_debug_pub.add('org: ' || p_org_id);
791: END IF;
792:
793:

Line 790: oe_debug_pub.add('org: ' || p_org_id);

786: oe_debug_pub.add('profile: ' || p_profile_option_name);
787: oe_debug_pub.add('application: '|| p_application_id);
788: oe_debug_pub.add('user: ' || p_user_id);
789: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
790: oe_debug_pub.add('org: ' || p_org_id);
791: END IF;
792:
793:
794: l_concat_segment := 'u'||p_user_id||'r'||p_responsibility_id||'a'||p_application_id ||'o'||

Line 799: oe_debug_pub.add('index already exists in profile cache.');

795: p_org_id|| 'p' || p_profile_option_name;
796:
797: IF Prf_Tbl.EXISTS(l_concat_segment) THEN
798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add('index already exists in profile cache.');
800: END IF;
801:
802: x_profile_option_value := Prf_Tbl(l_concat_segment).prf_value;
803: x_result := 'S';

Line 809: oe_debug_pub.add('index does not exist in profile cache.');

805: ELSE
806: x_profile_option_value := null;
807: x_result := 'F';
808: IF l_debug_level > 0 THEN
809: oe_debug_pub.add('index does not exist in profile cache.');
810: END IF;
811: Return;
812: END IF;
813: -- end of Prf_Tbl.EXISTS(l_concat_segment)

Line 816: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');

812: END IF;
813: -- end of Prf_Tbl.EXISTS(l_concat_segment)
814:
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('EXITING OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT');
817: END IF;
818:
819: EXCEPTION
820: WHEN OTHERS THEN

Line 824: oe_debug_pub.add('OTHERS IN OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT: ' || SQLERRM);

820: WHEN OTHERS THEN
821: x_profile_option_value := null;
822: x_result := 'E';
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add('OTHERS IN OE_PROFILE.GET_CACHED_PROFILE_FOR_CONTEXT: ' || SQLERRM);
825: END IF;
826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
827: THEN
828: OE_MSG_PUB.Add_Exc_Msg

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

844: I Varchar2(100);
845: l_new_prf_position number;
846: l_concat_segment VARCHAR2(100);
847: --
848: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
849: --
850: BEGIN
851:
852: IF l_debug_level > 0 THEN

Line 853: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');

849: --
850: BEGIN
851:
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');
854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);
855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);

Line 854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);

850: BEGIN
851:
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');
854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);
855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);

Line 855: oe_debug_pub.add('profile: ' || p_profile_option_name);

851:
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');
854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);
855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
859: oe_debug_pub.add('org: ' || p_org_id);

Line 856: oe_debug_pub.add('application: '|| p_application_id);

852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');
854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);
855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
859: oe_debug_pub.add('org: ' || p_org_id);
860: oe_debug_pub.add('profile value:' || p_profile_option_value);

Line 857: oe_debug_pub.add('user: ' || p_user_id);

853: oe_debug_pub.add('ENTERING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');
854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);
855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
859: oe_debug_pub.add('org: ' || p_org_id);
860: oe_debug_pub.add('profile value:' || p_profile_option_value);
861: END IF;

Line 858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);

854: oe_debug_pub.add('Records currently stored in profile cache: ' || Prf_Tbl.count);
855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
859: oe_debug_pub.add('org: ' || p_org_id);
860: oe_debug_pub.add('profile value:' || p_profile_option_value);
861: END IF;
862:

Line 859: oe_debug_pub.add('org: ' || p_org_id);

855: oe_debug_pub.add('profile: ' || p_profile_option_name);
856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
859: oe_debug_pub.add('org: ' || p_org_id);
860: oe_debug_pub.add('profile value:' || p_profile_option_value);
861: END IF;
862:
863:

Line 860: oe_debug_pub.add('profile value:' || p_profile_option_value);

856: oe_debug_pub.add('application: '|| p_application_id);
857: oe_debug_pub.add('user: ' || p_user_id);
858: oe_debug_pub.add('responsibility: ' || p_responsibility_id);
859: oe_debug_pub.add('org: ' || p_org_id);
860: oe_debug_pub.add('profile value:' || p_profile_option_value);
861: END IF;
862:
863:
864: l_concat_segment := 'u'||p_user_id||'r'||p_responsibility_id||'a'||p_application_id ||'o'||

Line 872: oe_debug_pub.add('space is available in the cache so adding the record at position: ' || (Prf_Tbl.count + 1));

868: -- see if there is space in the cache
869: IF Prf_Tbl.count < MAX_PROFILE_CACHE_SIZE THEN
870:
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add('space is available in the cache so adding the record at position: ' || (Prf_Tbl.count + 1));
873: END IF;
874: --there is space in the cache so simply add the data
875: --get new position
876: l_new_prf_position := Prf_Tbl.count + 1;

Line 882: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' records in the cache after adding the new record');

878: Prf_Tbl(l_concat_segment).prf_value := p_profile_option_value;
879:
880:
881: IF l_debug_level > 0 THEN
882: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' records in the cache after adding the new record');
883: END IF;
884:
885:
886: ELSE

Line 888: oe_debug_pub.add('cache is full so remove a record');

884:
885:
886: ELSE
887: IF l_debug_level > 0 THEN
888: oe_debug_pub.add('cache is full so remove a record');
889: END IF;
890:
891: -- the cache is full, so a record needs to be removed
892: I := Prf_Tbl.First;

Line 896: oe_debug_pub.add('position: ' || Prf_Tbl(I).position || ' I: ' || I);

892: I := Prf_Tbl.First;
893: While I is NOT NULL
894: LOOP
895: IF l_debug_level > 0 THEN
896: oe_debug_pub.add('position: ' || Prf_Tbl(I).position || ' I: ' || I);
897: END IF;
898: IF Prf_Tbl(I).position = 1 THEN
899: -- if the record is in position 1, remove it
900: Prf_Tbl.Delete(I);

Line 902: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);

898: IF Prf_Tbl(I).position = 1 THEN
899: -- if the record is in position 1, remove it
900: Prf_Tbl.Delete(I);
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);
903: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' profile records in the cache');
904: END IF;
905: ELSE
906: --record position needs to be shifted down

Line 903: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' profile records in the cache');

899: -- if the record is in position 1, remove it
900: Prf_Tbl.Delete(I);
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('deleted the record at position 1 with index: ' || I);
903: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' profile records in the cache');
904: END IF;
905: ELSE
906: --record position needs to be shifted down
907: Prf_Tbl(I).position := Prf_Tbl(I).position - 1;

Line 919: oe_debug_pub.add('added the new record at position: ' || Prf_Tbl(l_concat_segment).position);

915: -- now add new record to cache
916: Prf_Tbl(l_concat_segment).prf_value := p_profile_option_value;
917:
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('added the new record at position: ' || Prf_Tbl(l_concat_segment).position);
920: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' records in the cache after adding the new record');
921: END IF;
922:
923: END IF; -- end of Prf_Tbl.count < MAX_PROFILE_CACHE_SIZE

Line 920: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' records in the cache after adding the new record');

916: Prf_Tbl(l_concat_segment).prf_value := p_profile_option_value;
917:
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('added the new record at position: ' || Prf_Tbl(l_concat_segment).position);
920: oe_debug_pub.add('now there are ' || Prf_Tbl.count || ' records in the cache after adding the new record');
921: END IF;
922:
923: END IF; -- end of Prf_Tbl.count < MAX_PROFILE_CACHE_SIZE
924:

Line 926: oe_debug_pub.add('EXITING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');

922:
923: END IF; -- end of Prf_Tbl.count < MAX_PROFILE_CACHE_SIZE
924:
925: IF l_debug_level > 0 THEN
926: oe_debug_pub.add('EXITING OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT');
927: END IF;
928:
929: EXCEPTION
930: WHEN OTHERS THEN

Line 932: oe_debug_pub.add('OTHERS IN OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT: ' || SQLERRM);

928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: IF l_debug_level > 0 THEN
932: oe_debug_pub.add('OTHERS IN OE_PROFILE.PUT_CACHED_PROFILE_FOR_CONTEXT: ' || SQLERRM);
933: END IF;
934: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: OE_MSG_PUB.Add_Exc_Msg