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.OKC_PHL_PVT dependencies on OKC_DEBUG

Line 457: okc_debug.Set_Indentation('OKC_PHL_PVT');

453: WHERE CLE_ID=p_cle_id AND ID<>p_id
454: AND Greatest( p_from, Nvl(value_from,0)) <= Least( p_to, Nvl(value_to,l_MAX_NUM) );
455: BEGIN
456: IF (l_debug = 'Y') THEN
457: okc_debug.Set_Indentation('OKC_PHL_PVT');
458: okc_debug.log('500: Entered validate_values_from_to', 2);
459: END IF;
460:
461: -- initialize return status

Line 458: okc_debug.log('500: Entered validate_values_from_to', 2);

454: AND Greatest( p_from, Nvl(value_from,0)) <= Least( p_to, Nvl(value_to,l_MAX_NUM) );
455: BEGIN
456: IF (l_debug = 'Y') THEN
457: okc_debug.Set_Indentation('OKC_PHL_PVT');
458: okc_debug.log('500: Entered validate_values_from_to', 2);
459: END IF;
460:
461: -- initialize return status
462: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 488: okc_debug.log('600: Leaving validate_values_from_to', 2);

484: x_return_status := OKC_API.G_RET_STS_ERROR;
485: End If;
486:
487: IF (l_debug = 'Y') THEN
488: okc_debug.log('600: Leaving validate_values_from_to', 2);
489: okc_debug.Reset_Indentation;
490: END IF;
491: EXCEPTION
492: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 489: okc_debug.Reset_Indentation;

485: End If;
486:
487: IF (l_debug = 'Y') THEN
488: okc_debug.log('600: Leaving validate_values_from_to', 2);
489: okc_debug.Reset_Indentation;
490: END IF;
491: EXCEPTION
492: WHEN G_EXCEPTION_HALT_VALIDATION THEN
493: null;

Line 2738: okc_debug.Set_Indentation('OKC_PHL_PVT');

2734:
2735: BEGIN
2736:
2737: IF (l_debug = 'Y') THEN
2738: okc_debug.Set_Indentation('OKC_PHL_PVT');
2739: okc_debug.log('10700: Entered create_version', 2);
2740: END IF;
2741:
2742: INSERT INTO okc_ph_line_breaks_h

Line 2739: okc_debug.log('10700: Entered create_version', 2);

2735: BEGIN
2736:
2737: IF (l_debug = 'Y') THEN
2738: okc_debug.Set_Indentation('OKC_PHL_PVT');
2739: okc_debug.log('10700: Entered create_version', 2);
2740: END IF;
2741:
2742: INSERT INTO okc_ph_line_breaks_h
2743: (

Line 2802: okc_debug.log('10800: Leaving create_version', 2);

2798: WHERE dnz_chr_id = p_chr_id --price hold sub-line
2799: );
2800:
2801: IF (l_debug = 'Y') THEN
2802: okc_debug.log('10800: Leaving create_version', 2);
2803: okc_debug.Reset_Indentation;
2804: END IF;
2805:
2806: RETURN l_return_status;

Line 2803: okc_debug.Reset_Indentation;

2799: );
2800:
2801: IF (l_debug = 'Y') THEN
2802: okc_debug.log('10800: Leaving create_version', 2);
2803: okc_debug.Reset_Indentation;
2804: END IF;
2805:
2806: RETURN l_return_status;
2807:

Line 2813: okc_debug.log('10900: Exiting create_version:OTHERS Exception', 2);

2809: -- other appropriate handlers
2810: WHEN OTHERS THEN
2811:
2812: IF (l_debug = 'Y') THEN
2813: okc_debug.log('10900: Exiting create_version:OTHERS Exception', 2);
2814: okc_debug.Reset_Indentation;
2815: END IF;
2816:
2817: -- store SQL error message on message stack

Line 2814: okc_debug.Reset_Indentation;

2810: WHEN OTHERS THEN
2811:
2812: IF (l_debug = 'Y') THEN
2813: okc_debug.log('10900: Exiting create_version:OTHERS Exception', 2);
2814: okc_debug.Reset_Indentation;
2815: END IF;
2816:
2817: -- store SQL error message on message stack
2818: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

Line 2842: okc_debug.Set_Indentation('OKC_PHL_PVT');

2838:
2839: BEGIN
2840:
2841: IF (l_debug = 'Y') THEN
2842: okc_debug.Set_Indentation('OKC_PHL_PVT');
2843: okc_debug.log('11000: Entered restore_version', 2);
2844: END IF;
2845:
2846: INSERT INTO okc_ph_line_breaks

Line 2843: okc_debug.log('11000: Entered restore_version', 2);

2839: BEGIN
2840:
2841: IF (l_debug = 'Y') THEN
2842: okc_debug.Set_Indentation('OKC_PHL_PVT');
2843: okc_debug.log('11000: Entered restore_version', 2);
2844: END IF;
2845:
2846: INSERT INTO okc_ph_line_breaks
2847: (

Line 2907: okc_debug.log('11100: Leaving restore_version', 2);

2903: )
2904: AND major_version = p_major_version;
2905:
2906: IF (l_debug = 'Y') THEN
2907: okc_debug.log('11100: Leaving restore_version', 2);
2908: okc_debug.Reset_Indentation;
2909: END IF;
2910:
2911: RETURN l_return_status;

Line 2908: okc_debug.Reset_Indentation;

2904: AND major_version = p_major_version;
2905:
2906: IF (l_debug = 'Y') THEN
2907: okc_debug.log('11100: Leaving restore_version', 2);
2908: okc_debug.Reset_Indentation;
2909: END IF;
2910:
2911: RETURN l_return_status;
2912:

Line 2918: okc_debug.log('11200: Exiting restore_version:OTHERS Exception', 2);

2914: -- other appropriate handlers
2915: WHEN OTHERS THEN
2916:
2917: IF (l_debug = 'Y') THEN
2918: okc_debug.log('11200: Exiting restore_version:OTHERS Exception', 2);
2919: okc_debug.Reset_Indentation;
2920: END IF;
2921:
2922: -- store SQL error message on message stack

Line 2919: okc_debug.Reset_Indentation;

2915: WHEN OTHERS THEN
2916:
2917: IF (l_debug = 'Y') THEN
2918: okc_debug.log('11200: Exiting restore_version:OTHERS Exception', 2);
2919: okc_debug.Reset_Indentation;
2920: END IF;
2921:
2922: -- store SQL error message on message stack
2923: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,