DBA Data[Home] [Help]

APPS.IBE_UTIL dependencies on FND_API

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 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 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 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 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 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 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 400: return FND_API.G_TRUE;

396: IS
397: BEGIN
398: delete from ibe_temp_table where key=p_keyString;
399: IF SQL%FOUND THEN
400: return FND_API.G_TRUE;
401: ELSE
402: return FND_API.G_FALSE;
403: END IF;
404: END delete_from_temp_table;

Line 402: return FND_API.G_FALSE;

398: delete from ibe_temp_table where key=p_keyString;
399: IF SQL%FOUND THEN
400: return FND_API.G_TRUE;
401: ELSE
402: return FND_API.G_FALSE;
403: END IF;
404: END delete_from_temp_table;
405:
406: --Concatenates phone elements to phone format of iStore

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 420: IF p_country_code IS NOT NULL AND p_country_code <> FND_API.G_MISS_CHAR THEN

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||'-';
422: END IF;
423: IF p_area_code IS NOT NULL AND p_area_code <> FND_API.G_MISS_CHAR THEN
424: l_phone_number_out := l_phone_number_out || p_area_code ||'-';

Line 423: IF p_area_code IS NOT NULL AND p_area_code <> FND_API.G_MISS_CHAR THEN

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||'-';
422: END IF;
423: IF p_area_code IS NOT NULL AND p_area_code <> FND_API.G_MISS_CHAR THEN
424: l_phone_number_out := l_phone_number_out || p_area_code ||'-';
425: END IF;
426: IF p_phone_number IS NOT NULL AND p_phone_number <> FND_API.G_MISS_CHAR THEN
427: l_phone_number_out := l_phone_number_out || p_phone_number ||' ';

Line 426: IF p_phone_number IS NOT NULL AND p_phone_number <> FND_API.G_MISS_CHAR THEN

422: END IF;
423: IF p_area_code IS NOT NULL AND p_area_code <> FND_API.G_MISS_CHAR THEN
424: l_phone_number_out := l_phone_number_out || p_area_code ||'-';
425: END IF;
426: IF p_phone_number IS NOT NULL AND p_phone_number <> FND_API.G_MISS_CHAR THEN
427: l_phone_number_out := l_phone_number_out || p_phone_number ||' ';
428: END IF;
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;

Line 429: IF p_phone_ext IS NOT NULL AND p_phone_ext <> FND_API.G_MISS_CHAR THEN

425: END IF;
426: IF p_phone_number IS NOT NULL AND p_phone_number <> FND_API.G_MISS_CHAR THEN
427: l_phone_number_out := l_phone_number_out || p_phone_number ||' ';
428: END IF;
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

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 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 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: