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.IBE_UTIL dependencies on IBE_UTIL

Line 1: PACKAGE BODY IBE_UTIL AS

1: PACKAGE BODY IBE_UTIL AS
2: /* $$Header: IBEUTILB.pls 120.0 2005/05/30 02:39:04 appldev noship $$ */
3: /*----------------------------------------------------------------------------*
4: | PUBLIC PROCEDURES |
5: | debug - Display text message if in debug mode |

Line 42: | call ibe_util.enable_debug_new before and call |

38: | ocsStmt.append(IBEUtil.getDisableDebugString() + "END;"); <= Turn off |
39: | debugging |
40: | |
41: | b) If calling pl/sql api from within PL/SQL itself |
42: | call ibe_util.enable_debug_new before and call |
43: | ibe_util.disable_debug_new afterwards |
44: | |
45: | 2. Within your PL/SQL api's call IBE_UTIL.debug to print the messages |
46: | NO NEED TO CALL enable_Debug or disable_debug from within pl/sql api |

Line 43: | ibe_util.disable_debug_new afterwards |

39: | debugging |
40: | |
41: | b) If calling pl/sql api from within PL/SQL itself |
42: | call ibe_util.enable_debug_new before and call |
43: | ibe_util.disable_debug_new afterwards |
44: | |
45: | 2. Within your PL/SQL api's call IBE_UTIL.debug to print the messages |
46: | NO NEED TO CALL enable_Debug or disable_debug from within pl/sql api |
47: | |

Line 45: | 2. Within your PL/SQL api's call IBE_UTIL.debug to print the messages |

41: | b) If calling pl/sql api from within PL/SQL itself |
42: | call ibe_util.enable_debug_new before and call |
43: | ibe_util.disable_debug_new afterwards |
44: | |
45: | 2. Within your PL/SQL api's call IBE_UTIL.debug to print the messages |
46: | NO NEED TO CALL enable_Debug or disable_debug from within pl/sql api |
47: | |
48: | |
49: | REQUIRES |

Line 123: Changed to not call fnd_profile everytime but to check IBE_UTIL.DEBUGON global variable

119: pragma exception_init(buffer_overflow, -20000);
120: begin
121:
122: /**
123: Changed to not call fnd_profile everytime but to check IBE_UTIL.DEBUGON global variable
124: - achalana 07/29
125: **/
126: -- If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
127: If IBE_UTIL.G_DEBUGON = FND_API.G_TRUE Then

Line 127: If IBE_UTIL.G_DEBUGON = FND_API.G_TRUE Then

123: Changed to not call fnd_profile everytime but to check IBE_UTIL.DEBUGON global variable
124: - achalana 07/29
125: **/
126: -- If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
127: If IBE_UTIL.G_DEBUGON = FND_API.G_TRUE Then
128: -- utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||'IBE IBE_UTIL:Using New Debugging');
129: enable_debug_pvt();
130: x_rest := p_line;
131: loop

Line 128: -- utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||'IBE IBE_UTIL:Using New Debugging');

124: - achalana 07/29
125: **/
126: -- If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
127: If IBE_UTIL.G_DEBUGON = FND_API.G_TRUE Then
128: -- utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||'IBE IBE_UTIL:Using New Debugging');
129: enable_debug_pvt();
130: x_rest := p_line;
131: loop
132: if (x_rest is null) then

Line 143: Elsif IBE_UTIL.G_DEBUGON = FND_API.G_FALSE Then

139: x_rest := substr(x_rest,256);
140: end if;
141: end loop;
142:
143: Elsif IBE_UTIL.G_DEBUGON = FND_API.G_FALSE Then
144: disable_debug_pvt();
145: Elsif IBE_UTIL.G_DEBUGON IS NULL Then
146: /**
147: wrote this section of code for backward compatibility, so that code that was not changed

Line 145: Elsif IBE_UTIL.G_DEBUGON IS NULL Then

141: end loop;
142:
143: Elsif IBE_UTIL.G_DEBUGON = FND_API.G_FALSE Then
144: disable_debug_pvt();
145: Elsif IBE_UTIL.G_DEBUGON IS NULL Then
146: /**
147: wrote this section of code for backward compatibility, so that code that was not changed
148: for new debugging should work
149: **/

Line 193: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;

189: fnd_profile again, and set G_DEBUGON to true
190: **/
191:
192: If p_check_profile = 'N' Then
193: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
194: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is N');
195: Else
196: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
197: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;

Line 194: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is N');

190: **/
191:
192: If p_check_profile = 'N' Then
193: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
194: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is N');
195: Else
196: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
197: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
198: Else

Line 197: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;

193: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
194: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is N');
195: Else
196: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
197: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
198: Else
199: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
200: End If;
201:

Line 199: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;

195: Else
196: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
197: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
198: Else
199: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
200: End If;
201:
202: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
203: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is not passed');

Line 202: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

198: Else
199: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
200: End If;
201:
202: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
203: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is not passed');
204: END IF;
205: End If;
206: end;

Line 203: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is not passed');

199: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
200: End If;
201:
202: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
203: IBE_UTIL.debug('IBE_UTIL.enable_debug_new p_check_profile is not passed');
204: END IF;
205: End If;
206: end;
207:

Line 242: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;

238: /* New procedure 07/29 - achalana */
239: procedure disable_debug_new is
240: begin
241: disable_debug_pvt();
242: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
243: end;
244:
245: /* New procedure 07/29 - achalana */
246: procedure reset_debug is

Line 249: IBE_UTIL.G_DEBUGON := NULL;

245: /* New procedure 07/29 - achalana */
246: procedure reset_debug is
247: begin
248: disable_debug_pvt();
249: IBE_UTIL.G_DEBUGON := NULL;
250: end;
251:
252: procedure disable_debug_pvt is
253: begin

Line 350: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

346: F.DOMAIN_NAME ='CRM_DOMAIN' AND
347: A.PERMISSION_NAME = l_permission;
348:
349: BEGIN
350: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
351: ibe_util.debug(l_api_name||'input user name ='|| p_user_name);
352: ibe_util.debug(l_api_name||'input permission ='|| p_permission);
353: END IF;
354:

Line 351: ibe_util.debug(l_api_name||'input user name ='|| p_user_name);

347: A.PERMISSION_NAME = l_permission;
348:
349: BEGIN
350: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
351: ibe_util.debug(l_api_name||'input user name ='|| p_user_name);
352: ibe_util.debug(l_api_name||'input permission ='|| p_permission);
353: END IF;
354:
355: OPEN c_get_permission(p_user_name,p_permission);

Line 352: ibe_util.debug(l_api_name||'input permission ='|| p_permission);

348:
349: BEGIN
350: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
351: ibe_util.debug(l_api_name||'input user name ='|| p_user_name);
352: ibe_util.debug(l_api_name||'input permission ='|| p_permission);
353: END IF;
354:
355: OPEN c_get_permission(p_user_name,p_permission);
356: FETCH c_get_permission INTO l_temp_var;

Line 361: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

357: IF (c_get_permission%FOUND) THEN
358: l_hasPermission:=true;
359: END IF;
360:
361: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
362: ibe_util.debug(l_api_name||'l_temp_var ='|| l_temp_var);
363: END IF;
364:
365: return l_hasPermission;

Line 362: ibe_util.debug(l_api_name||'l_temp_var ='|| l_temp_var);

358: l_hasPermission:=true;
359: END IF;
360:
361: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
362: ibe_util.debug(l_api_name||'l_temp_var ='|| l_temp_var);
363: END IF;
364:
365: return l_hasPermission;
366:

Line 416: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

412: ) RETURN VARCHAR2
413: IS
414: l_phone_number_out VARCHAR2(86);
415: BEGIN
416: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
417: IBE_UTIL.debug('Begin format_phone,input cc,ac,phnum,phext '||p_country_code||','||p_area_code||','||p_phone_number||','||p_phone_ext);
418: END IF;
419:
420: IF p_country_code IS NOT NULL AND p_country_code <> FND_API.G_MISS_CHAR THEN

Line 417: IBE_UTIL.debug('Begin format_phone,input cc,ac,phnum,phext '||p_country_code||','||p_area_code||','||p_phone_number||','||p_phone_ext);

413: IS
414: l_phone_number_out VARCHAR2(86);
415: BEGIN
416: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
417: IBE_UTIL.debug('Begin format_phone,input cc,ac,phnum,phext '||p_country_code||','||p_area_code||','||p_phone_number||','||p_phone_ext);
418: END IF;
419:
420: IF p_country_code IS NOT NULL AND p_country_code <> FND_API.G_MISS_CHAR THEN
421: l_phone_number_out := p_country_code||'-';

Line 433: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

429: IF p_phone_ext IS NOT NULL AND p_phone_ext <> FND_API.G_MISS_CHAR THEN
430: l_phone_number_out := l_phone_number_out || 'x' || p_phone_ext;
431: END IF;
432:
433: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
434: IBE_UTIL.debug('Exit format_phone, output phone number '||l_phone_number_out);
435: END IF;
436: RETURN l_phone_number_out;
437: END format_phone;

Line 434: IBE_UTIL.debug('Exit format_phone, output phone number '||l_phone_number_out);

430: l_phone_number_out := l_phone_number_out || 'x' || p_phone_ext;
431: END IF;
432:
433: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
434: IBE_UTIL.debug('Exit format_phone, output phone number '||l_phone_number_out);
435: END IF;
436: RETURN l_phone_number_out;
437: END format_phone;
438:

Line 448: IF IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN

444: IS
445:
446: BEGIN
447:
448: IF IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN
449: IBE_UTIL.debug('START: insert_into_temp_table');
450: END IF;
451:
452: IF p_Type = 'CHAR' THEN

Line 449: IBE_UTIL.debug('START: insert_into_temp_table');

445:
446: BEGIN
447:
448: IF IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN
449: IBE_UTIL.debug('START: insert_into_temp_table');
450: END IF;
451:
452: IF p_Type = 'CHAR' THEN
453: INSERT into IBE_TEMP_TABLE (KEY, CHAR_VAL) VALUES (p_keyString,p_inString);

Line 466: IF IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN

462: END IF;
463:
464: EXCEPTION
465: WHEN OTHERS then
466: IF IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN
467: IBE_UTIL.debug('Exception.....'||sqlerrm);
468: END IF;
469: Raise;
470:

Line 467: IBE_UTIL.debug('Exception.....'||sqlerrm);

463:
464: EXCEPTION
465: WHEN OTHERS then
466: IF IBE_UTIL.G_DEBUGON = FND_API.G_TRUE THEN
467: IBE_UTIL.debug('Exception.....'||sqlerrm);
468: END IF;
469: Raise;
470:
471: END insert_into_temp_table;

Line 473: END IBE_UTIL;

469: Raise;
470:
471: END insert_into_temp_table;
472:
473: END IBE_UTIL;