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.FTE_COMP_CONSTRAINT_UTIL dependencies on WSH_DEBUG_SV

Line 206: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;
203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;
204: --#REG-ZON
205:
206: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
207: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'get_object_name';
208:
209: BEGIN
210:

Line 213: wsh_debug_sv.push (l_module_name);

209: BEGIN
210:
211: --
212: IF l_debug_on THEN
213: wsh_debug_sv.push (l_module_name);
214: END IF;
215: --
216: -- object1_type values : ORG CUS FAC CAR MOD ITM SUP
217: -- object2_type values : FAC CAR MOD ITM VHT CUS

Line 271: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_fac_comp rowcount '|| c_get_fac_comp%ROWCOUNT);

267: l_facility_code, l_description;
268: EXIT WHEN c_get_fac_comp%NOTFOUND;
269: --
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_fac_comp rowcount '|| c_get_fac_comp%ROWCOUNT);
272: END IF;
273: --
274: IF c_get_fac_comp%ROWCOUNT > 1 THEN
275: l_shared_fac := TRUE;

Line 370: WSH_DEBUG_SV.logmsg(l_module_name,'Object Type '|| p_object_type);

366: --#REG-ZON(E)
367:
368: --
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.logmsg(l_module_name,'Object Type '|| p_object_type);
371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);
372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);

Line 371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);

367:
368: --
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.logmsg(l_module_name,'Object Type '|| p_object_type);
371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);
372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);

Line 372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);

368: --
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.logmsg(l_module_name,'Object Type '|| p_object_type);
371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);
372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);

Line 373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);

369: IF l_debug_on THEN
370: WSH_DEBUG_SV.logmsg(l_module_name,'Object Type '|| p_object_type);
371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);
372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);
377: WSH_DEBUG_SV.pop(l_module_name);

Line 374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);

370: WSH_DEBUG_SV.logmsg(l_module_name,'Object Type '|| p_object_type);
371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);
372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;

Line 375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);

371: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Num '|| p_object_value_num);
372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;
379: --

Line 376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);

372: WSH_DEBUG_SV.logmsg(l_module_name,'Object Value Char '|| p_object_value_char);
373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;
379: --
380:

Line 377: WSH_DEBUG_SV.pop(l_module_name);

373: WSH_DEBUG_SV.logmsg(l_module_name,'Object parent id '|| p_object_parent_id);
374: WSH_DEBUG_SV.logmsg(l_module_name,'Object name '|| l_result);
375: WSH_DEBUG_SV.logmsg(l_module_name,'Company type '|| x_fac_company_type);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Company name '|| x_fac_company_name);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;
379: --
380:
381: RETURN l_result;

Line 398: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

394: --#REG-ZON
395:
396: --
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: --
402: RETURN g_unexp_char;

Line 399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

395:
396: --
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: --
402: RETURN g_unexp_char;
403:

Line 476: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

472: and wl.location_source_code='HZ'
473: and hp.status='A'
474: and wl.source_location_id=p_locid;
475:
476: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
477: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'get_facility_display';
478:
479: l_company_id NUMBER;
480: l_prev_company_id NUMBER;

Line 493: wsh_debug_sv.push(l_module_name);

489:
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
491:
492: IF l_debug_on THEN
493: wsh_debug_sv.push(l_module_name);
494: END IF;
495:
496: IF p_source_location_code ='HR' THEN
497: FOR cur IN c_hr_details (p_source_location_id) LOOP

Line 527: wsh_debug_sv.log(l_module_name, 'p_source_location_id ', p_source_location_id);

523: x_fac_company_type:=l_fac_company_type;
524: x_fac_company_name:=l_fac_company_name;
525:
526: IF l_debug_on THEN
527: wsh_debug_sv.log(l_module_name, 'p_source_location_id ', p_source_location_id);
528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);
529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);
530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);
531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);

Line 528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);

524: x_fac_company_name:=l_fac_company_name;
525:
526: IF l_debug_on THEN
527: wsh_debug_sv.log(l_module_name, 'p_source_location_id ', p_source_location_id);
528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);
529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);
530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);
531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);
532: WSH_DEBUG_SV.pop(l_module_name);

Line 529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);

525:
526: IF l_debug_on THEN
527: wsh_debug_sv.log(l_module_name, 'p_source_location_id ', p_source_location_id);
528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);
529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);
530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);
531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;

Line 530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);

526: IF l_debug_on THEN
527: wsh_debug_sv.log(l_module_name, 'p_source_location_id ', p_source_location_id);
528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);
529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);
530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);
531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534:

Line 531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);

527: wsh_debug_sv.log(l_module_name, 'p_source_location_id ', p_source_location_id);
528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);
529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);
530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);
531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534:
535: FND_MSG_PUB.Count_And_Get (

Line 532: WSH_DEBUG_SV.pop(l_module_name);

528: wsh_debug_sv.log(l_module_name, 'p_source_location_code ', p_source_location_code);
529: wsh_debug_sv.log(l_module_name, 'x_fac_sites ', x_fac_sites);
530: wsh_debug_sv.log(l_module_name, 'x_fac_company_name ', x_fac_company_name);
531: wsh_debug_sv.log(l_module_name, 'x_fac_company_type ', x_fac_company_type);
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534:
535: FND_MSG_PUB.Count_And_Get (
536: p_count => x_msg_count,

Line 551: WSH_DEBUG_SV.log(l_module_name,'Error : Invalid Location Source Code : ', p_source_location_code);

547: p_encoded => FND_API.G_FALSE);
548:
549: --
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name,'Error : Invalid Location Source Code : ', p_source_location_code);
552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
553: END IF;
554: WHEN OTHERS THEN
555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

548:
549: --
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name,'Error : Invalid Location Source Code : ', p_source_location_code);
552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
553: END IF;
554: WHEN OTHERS THEN
555: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
556:

Line 564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

560: p_encoded => FND_API.G_FALSE);
561:
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
566: END IF;
567: --
568: END get_facility_display;

Line 565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

561:
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
566: END IF;
567: --
568: END get_facility_display;
569: