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_TENDER_WF dependencies on WSH_DEBUG_SV

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

474: --}
475:
476:
477: -- Debug paramteres
478: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
479: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_WF'|| '.' || 'INITIALIZE_TENDER_REQUEST';
480:
481: l_userId NUMBER;
482: l_respId NUMBER;

Line 488: --wsh_debug_sv.push(l_api_name);

484:
485:
486: BEGIN
487:
488: --wsh_debug_sv.push(l_api_name);
489: --
490: -- RUN mode - normal process execution
491: --
492: IF (funcmode = 'RUN') THEN

Line 496: WSH_DEBUG_SV.push(l_module_name);

492: IF (funcmode = 'RUN') THEN
493: -- These values should be retrived from database
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.push(l_module_name);
497: END IF;
498:
499:
500: -- Initialize all the attributes to send notification to carrier

Line 504: WSH_DEBUG_SV.logmsg(l_module_name,'Getting Trip id, tender id, shipper name ',WSH_DEBUG_SV.C_PROC_LEVEL);

500: -- Initialize all the attributes to send notification to carrier
501: -- based on the tender id
502: -- Get the tender id first
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'Getting Trip id, tender id, shipper name ',WSH_DEBUG_SV.C_PROC_LEVEL);
505: END IF;
506:
507:
508: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');

Line 521: WSH_DEBUG_SV.logmsg(l_module_name,'Item key' || itemkey,WSH_DEBUG_SV.C_PROC_LEVEL);

517: END IF;
518:
519:
520: IF l_debug_on THEN
521: WSH_DEBUG_SV.logmsg(l_module_name,'Item key' || itemkey,WSH_DEBUG_SV.C_PROC_LEVEL);
522: END IF;
523:
524: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
525:

Line 531: WSH_DEBUG_SV.logmsg(l_module_name,'After getting trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

527: l_trip_id := l_tender_id;
528:
529:
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'After getting trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
532: END IF;
533:
534: l_shipper_name := wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
535:

Line 537: WSH_DEBUG_SV.logmsg(l_module_name,'After Getting Trip id, tender id, shipper name ' ||

533:
534: l_shipper_name := wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
535:
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.logmsg(l_module_name,'After Getting Trip id, tender id, shipper name ' ||
538: l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);
539: END IF;
540:
541: --{

Line 538: l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);

534: l_shipper_name := wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
535:
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.logmsg(l_module_name,'After Getting Trip id, tender id, shipper name ' ||
538: l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);
539: END IF;
540:
541: --{
542: -- **************************** Rel 12

Line 569: WSH_DEBUG_SV.logmsg(l_module_name,'Gettting shipper cuttoff time in MIN ' || l_shipper_cutoff_time,

565: -- Calculate Shipper Cutoff time
566: l_shipper_cutoff_time := FTE_MLS_UTIL.FTE_UOM_CONV(l_shipper_wait_time, l_wait_time_uom,'MIN');
567:
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'Gettting shipper cuttoff time in MIN ' || l_shipper_cutoff_time,
570: WSH_DEBUG_SV.C_PROC_LEVEL);
571: END IF;
572:
573:

Line 570: WSH_DEBUG_SV.C_PROC_LEVEL);

566: l_shipper_cutoff_time := FTE_MLS_UTIL.FTE_UOM_CONV(l_shipper_wait_time, l_wait_time_uom,'MIN');
567:
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'Gettting shipper cuttoff time in MIN ' || l_shipper_cutoff_time,
570: WSH_DEBUG_SV.C_PROC_LEVEL);
571: END IF;
572:
573:
574: IF (l_shipper_cutoff_time = -9999)

Line 577: WSH_DEBUG_SV.logmsg(l_module_name,'orig wait time:'||l_shipper_wait_time ||

573:
574: IF (l_shipper_cutoff_time = -9999)
575: THEN
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'orig wait time:'||l_shipper_wait_time ||
578: l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
579: WSH_DEBUG_SV.logmsg(l_module_name,'conv wait time:'||l_shipper_cutoff_time ||
580: 'MIN',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;

Line 578: l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);

574: IF (l_shipper_cutoff_time = -9999)
575: THEN
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'orig wait time:'||l_shipper_wait_time ||
578: l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
579: WSH_DEBUG_SV.logmsg(l_module_name,'conv wait time:'||l_shipper_cutoff_time ||
580: 'MIN',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;
582:

Line 579: WSH_DEBUG_SV.logmsg(l_module_name,'conv wait time:'||l_shipper_cutoff_time ||

575: THEN
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'orig wait time:'||l_shipper_wait_time ||
578: l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
579: WSH_DEBUG_SV.logmsg(l_module_name,'conv wait time:'||l_shipper_cutoff_time ||
580: 'MIN',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;
582:
583: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');

Line 580: 'MIN',WSH_DEBUG_SV.C_PROC_LEVEL);

576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'orig wait time:'||l_shipper_wait_time ||
578: l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
579: WSH_DEBUG_SV.logmsg(l_module_name,'conv wait time:'||l_shipper_cutoff_time ||
580: 'MIN',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;
582:
583: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
584: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_shipper_wait_time);

Line 601: WSH_DEBUG_SV.logmsg(l_module_name,

597: l_shipper_cutoff_time_days := FTE_MLS_UTIL.FTE_UOM_CONV(l_shipper_wait_time,
598: l_wait_time_uom,'DAY');
599:
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.logmsg(l_module_name,
602: 'Gettting shipper cuttoff time in days ' || l_shipper_cutoff_time_days,
603: WSH_DEBUG_SV.C_PROC_LEVEL);
604: END IF;
605:

Line 603: WSH_DEBUG_SV.C_PROC_LEVEL);

599:
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.logmsg(l_module_name,
602: 'Gettting shipper cuttoff time in days ' || l_shipper_cutoff_time_days,
603: WSH_DEBUG_SV.C_PROC_LEVEL);
604: END IF;
605:
606:
607: -- **************************** Rel 12

Line 625: WSH_DEBUG_SV.logmsg(l_module_name,'Setting tender id',WSH_DEBUG_SV.C_PROC_LEVEL);

621: wf_engine.SetItemOwner(itemtype,itemkey,l_shipper_name);
622:
623:
624: IF l_debug_on THEN
625: WSH_DEBUG_SV.logmsg(l_module_name,'Setting tender id',WSH_DEBUG_SV.C_PROC_LEVEL);
626: END IF;
627:
628: wf_engine.SetItemAttrText(itemtype => itemtype,
629: itemkey => itemkey,

Line 706: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ');

702:
703:
704: -- Notification and Auto accept info
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ');
707: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
708: WSH_DEBUG_SV.C_PROC_LEVEL);
709: END IF;
710:

Line 707: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,

703:
704: -- Notification and Auto accept info
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ');
707: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
708: WSH_DEBUG_SV.C_PROC_LEVEL);
709: END IF;
710:
711:

Line 708: WSH_DEBUG_SV.C_PROC_LEVEL);

704: -- Notification and Auto accept info
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ');
707: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
708: WSH_DEBUG_SV.C_PROC_LEVEL);
709: END IF;
710:
711:
712: FOR get_notif_type_rec IN get_notif_type_c(l_trip_id)

Line 716: WSH_DEBUG_SV.logmsg(l_module_name,' Getting notif and auto accept ',

712: FOR get_notif_type_rec IN get_notif_type_c(l_trip_id)
713: LOOP
714: --{
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,' Getting notif and auto accept ',
717: WSH_DEBUG_SV.C_PROC_LEVEL);
718: END IF;
719:
720: l_notif_type := get_notif_type_rec.notif_type;

Line 717: WSH_DEBUG_SV.C_PROC_LEVEL);

713: LOOP
714: --{
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,' Getting notif and auto accept ',
717: WSH_DEBUG_SV.C_PROC_LEVEL);
718: END IF;
719:
720: l_notif_type := get_notif_type_rec.notif_type;
721: l_auto_accept := get_notif_type_rec.auto_accept_flag;

Line 733: WSH_DEBUG_SV.logmsg(l_module_name,' Notif Type ' || l_notif_type,

729: CLOSE get_notif_type_c;
730: END IF;
731:
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.logmsg(l_module_name,' Notif Type ' || l_notif_type,
734: WSH_DEBUG_SV.C_PROC_LEVEL);
735: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
736: WSH_DEBUG_SV.C_PROC_LEVEL);
737: END IF;

Line 734: WSH_DEBUG_SV.C_PROC_LEVEL);

730: END IF;
731:
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.logmsg(l_module_name,' Notif Type ' || l_notif_type,
734: WSH_DEBUG_SV.C_PROC_LEVEL);
735: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
736: WSH_DEBUG_SV.C_PROC_LEVEL);
737: END IF;
738:

Line 735: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,

731:
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.logmsg(l_module_name,' Notif Type ' || l_notif_type,
734: WSH_DEBUG_SV.C_PROC_LEVEL);
735: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
736: WSH_DEBUG_SV.C_PROC_LEVEL);
737: END IF;
738:
739:

Line 736: WSH_DEBUG_SV.C_PROC_LEVEL);

732: IF l_debug_on THEN
733: WSH_DEBUG_SV.logmsg(l_module_name,' Notif Type ' || l_notif_type,
734: WSH_DEBUG_SV.C_PROC_LEVEL);
735: WSH_DEBUG_SV.logmsg(l_module_name,' Auto Accept ' || l_auto_accept,
736: WSH_DEBUG_SV.C_PROC_LEVEL);
737: END IF;
738:
739:
740: IF (l_notif_type IS NULL)

Line 859: l_debug_on BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

855: x_msg_data OUT NOCOPY VARCHAR2) IS
856:
857: l_api_name VARCHAR2(30) := 'UPDATE_CARRIER_RESPONSE';
858: l_api_version CONSTANT NUMBER := 1.0;
859: l_debug_on BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
860: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CARRIER_RESPONSE';
861:
862:
863: l_action_out_rec FTE_ACTION_OUT_REC;

Line 880: WSH_DEBUG_SV.start_debugger

876:
877: BEGIN
878:
879: wsh_debug_interface.g_Debug := TRUE;
880: WSH_DEBUG_SV.start_debugger
881: (x_file_name => l_file_name,
882: x_return_status => l_return_status,
883: x_msg_count => l_msg_count,
884: x_msg_data => l_msg_data);

Line 896: wsh_debug_sv.push(l_module_name);

892: FND_MSG_PUB.initialize;
893: END IF;
894: --
895: IF l_debug_on THEN
896: wsh_debug_sv.push(l_module_name);
897: END IF;
898:
899: --
900: -- Initialize API return status to success

Line 905: WSH_DEBUG_SV.log(l_module_name,' Parameters ********* ');

901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
902: x_msg_count := 0;
903: x_msg_data := 0;
904:
905: WSH_DEBUG_SV.log(l_module_name,' ************ Parameters ********************* ');
906: WSH_DEBUG_SV.log(l_module_name,' p_tender_status ',p_tender_status);
907:
908: IF p_tender_status = FTE_TENDER_PVT.S_ACCEPTED THEN
909: l_tender_process := 'TENDER_ACCEPT_PROCESS';

Line 906: WSH_DEBUG_SV.log(l_module_name,' p_tender_status ',p_tender_status);

902: x_msg_count := 0;
903: x_msg_data := 0;
904:
905: WSH_DEBUG_SV.log(l_module_name,' ************ Parameters ********************* ');
906: WSH_DEBUG_SV.log(l_module_name,' p_tender_status ',p_tender_status);
907:
908: IF p_tender_status = FTE_TENDER_PVT.S_ACCEPTED THEN
909: l_tender_process := 'TENDER_ACCEPT_PROCESS';
910: ELSIF p_tender_status = FTE_TENDER_PVT.S_REJECTED THEN

Line 914: WSH_DEBUG_SV.log(l_module_name,' l_tender_process ',l_tender_process);

910: ELSIF p_tender_status = FTE_TENDER_PVT.S_REJECTED THEN
911: l_tender_process := 'TENDER_REJECT_PROCESS';
912: END IF;
913:
914: WSH_DEBUG_SV.log(l_module_name,' l_tender_process ',l_tender_process);
915:
916: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
917: p_tender_id, -- TripId
918: null, -- Trip Name

Line 971: WSH_DEBUG_SV.pop(l_module_name);

967: --
968:
969:
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.pop(l_module_name);
972: END IF;
973:
974:
975: EXCEPTION

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

1069: l_responseSource VARCHAR2(30);
1070:
1071: l_api_name VARCHAR2(30) := 'RAISE_TENDER_ACCEPT';
1072: l_api_version CONSTANT NUMBER := 1.0;
1073: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1074: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'RAISE_TENDER_ACCEPT';
1075:
1076:
1077: BEGIN

Line 1083: WSH_DEBUG_SV.push(l_module_name);

1079: IF (funcmode = 'RUN') THEN
1080:
1081:
1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.push(l_module_name);
1084: END IF;
1085:
1086: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');
1087:

Line 1089: WSH_DEBUG_SV.logmsg(l_module_name,' Response source ' || l_responseSource,

1085:
1086: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');
1087:
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,' Response source ' || l_responseSource,
1090: WSH_DEBUG_SV.C_PROC_LEVEL);
1091: END IF;
1092:
1093:

Line 1090: WSH_DEBUG_SV.C_PROC_LEVEL);

1086: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');
1087:
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,' Response source ' || l_responseSource,
1090: WSH_DEBUG_SV.C_PROC_LEVEL);
1091: END IF;
1092:
1093:
1094: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR

Line 1162: WSH_DEBUG_SV.pop(l_module_name);

1158: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
1159: END IF;
1160:
1161: IF l_debug_on THEN
1162: WSH_DEBUG_SV.pop(l_module_name);
1163: END IF;
1164:
1165:
1166: -- Now raise the event

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

1503: resultout out NOCOPY varchar2) IS
1504:
1505: l_api_name CONSTANT VARCHAR2(30) := 'FINALIZE_TENDER_REQUEST';
1506: l_api_version CONSTANT NUMBER := 1.0;
1507: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1508: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1509:
1510: l_trip_id NUMBER;
1511: l_tender_id NUMBER;

Line 1538: WSH_DEBUG_SV.push(l_api_name);

1534:
1535:
1536:
1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.push(l_api_name);
1539:
1540: END IF;
1541:
1542:

Line 1546: WSH_DEBUG_SV.logmsg(l_api_name,l_tender_action,WSH_DEBUG_SV.C_PROC_LEVEL);

1542:
1543: l_tender_action := wf_engine.getItemAttrText(itemtype, itemkey, 'TENDER_ACTION');
1544:
1545: IF l_debug_on THEN
1546: WSH_DEBUG_SV.logmsg(l_api_name,l_tender_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;
1548:
1549:
1550: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

Line 1636: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||

1632: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1633: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1634:
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
1637: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);
1638: END IF;
1639:
1640:

Line 1637: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);

1633: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1634:
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
1637: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);
1638: END IF;
1639:
1640:
1641: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN

Line 1649: WSH_DEBUG_SV.pop(l_api_name);

1645: END IF;
1646:
1647:
1648: IF l_debug_on THEN
1649: WSH_DEBUG_SV.pop(l_api_name);
1650: END IF;
1651:
1652: resultout := 'COMPLETE:Y';
1653: return;

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

1988: l_action_out_rec FTE_ACTION_OUT_REC;
1989: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
1990: l_tender_attr_rec FTE_TENDER_ATTR_REC;
1991:
1992: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1993: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1994:
1995: l_userId NUMBER;
1996: l_respId NUMBER;

Line 2002: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');

1998:
1999:
2000: BEGIN
2001:
2002: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');
2003:
2004: --
2005: -- RUN mode - normal process execution
2006: --

Line 2015: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2011: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2012: l_trip_id := l_tender_id;
2013:
2014: IF l_debug_on THEN
2015: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2016: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Id' || l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2017: END IF;
2018:
2019:

Line 2016: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Id' || l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2012: l_trip_id := l_tender_id;
2013:
2014: IF l_debug_on THEN
2015: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2016: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Id' || l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2017: END IF;
2018:
2019:
2020: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 2039: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||

2035: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
2036: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
2037:
2038: IF l_debug_on THEN
2039: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
2040: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);
2041: END IF;
2042:
2043:

Line 2040: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);

2036: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
2037:
2038: IF l_debug_on THEN
2039: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
2040: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);
2041: END IF;
2042:
2043:
2044: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN

Line 2074: WSH_DEBUG_SV.logmsg(l_module_name,' Before Calling FTE_MLS_WRAPPER.TRIP_ACTION ' || l_trip_id,

2070: null,null,null,null,null,null,
2071: null,null);
2072:
2073: IF l_debug_on THEN
2074: WSH_DEBUG_SV.logmsg(l_module_name,' Before Calling FTE_MLS_WRAPPER.TRIP_ACTION ' || l_trip_id,
2075: WSH_DEBUG_SV.C_PROC_LEVEL);
2076: END IF;
2077:
2078:

Line 2075: WSH_DEBUG_SV.C_PROC_LEVEL);

2071: null,null);
2072:
2073: IF l_debug_on THEN
2074: WSH_DEBUG_SV.logmsg(l_module_name,' Before Calling FTE_MLS_WRAPPER.TRIP_ACTION ' || l_trip_id,
2075: WSH_DEBUG_SV.C_PROC_LEVEL);
2076: END IF;
2077:
2078:
2079: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,

Line 2097: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after

2093: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
2094: END IF;
2095:
2096: IF l_debug_on THEN
2097: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
2098: FTE_MLS_WRAPPER.TRIP_ACTION ' ||
2099: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2100: END IF;
2101:

Line 2099: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

2095:
2096: IF l_debug_on THEN
2097: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
2098: FTE_MLS_WRAPPER.TRIP_ACTION ' ||
2099: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2100: END IF;
2101:
2102:
2103: resultout := 'COMPLETE:Y';

Line 2106: wsh_debug_sv.pop(l_api_name);

2102:
2103: resultout := 'COMPLETE:Y';
2104:
2105: IF l_debug_on THEN
2106: wsh_debug_sv.pop(l_api_name);
2107: END IF;
2108: --wsh_debug_sv.pop(l_api_name);
2109:
2110: return;

Line 2108: --wsh_debug_sv.pop(l_api_name);

2104:
2105: IF l_debug_on THEN
2106: wsh_debug_sv.pop(l_api_name);
2107: END IF;
2108: --wsh_debug_sv.pop(l_api_name);
2109:
2110: return;
2111:
2112: END IF; --- func mode

Line 2120: --wsh_debug_sv.pop(l_api_name);

2116: -- CANCEL mode
2117: --
2118: IF (funcmode = 'CANCEL') THEN
2119: resultout := 'COMPLETE:';
2120: --wsh_debug_sv.pop(l_api_name);
2121:
2122: return;
2123: END IF;
2124:

Line 2127: --wsh_debug_sv.pop(l_api_name);

2123: END IF;
2124:
2125: IF (funcmode = 'TIMEOUT') THEN
2126: resultout := 'COMPLETE:';
2127: --wsh_debug_sv.pop(l_api_name);
2128: return;
2129: END IF;
2130:
2131:

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

2173: l_action_out_rec FTE_ACTION_OUT_REC;
2174: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
2175: l_tender_attr_rec FTE_TENDER_ATTR_REC;
2176:
2177: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2178: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2179:
2180:
2181: BEGIN

Line 2184: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');

2180:
2181: BEGIN
2182:
2183:
2184: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');
2185:
2186: --
2187: -- RUN mode - normal process execution
2188: --

Line 2254: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after

2250:
2251:
2252:
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
2255: FTE_MLS_WRAPPER.TRIP_ACTION ' ||
2256: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2257: END IF;
2258:

Line 2256: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

2252:
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
2255: FTE_MLS_WRAPPER.TRIP_ACTION ' ||
2256: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2257: END IF;
2258:
2259:
2260: wsh_util_core.api_post_call(

Line 2275: --wsh_debug_sv.pop(l_api_name);

2271: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
2272: END IF;
2273:
2274: resultout := 'COMPLETE:Y';
2275: --wsh_debug_sv.pop(l_api_name);
2276: return;
2277:
2278: END IF; --- func mode
2279:

Line 2286: --wsh_debug_sv.pop(l_api_name);

2282: -- CANCEL mode
2283: --
2284: IF (funcmode = 'CANCEL') THEN
2285: resultout := 'COMPLETE:';
2286: --wsh_debug_sv.pop(l_api_name);
2287:
2288: return;
2289: END IF;
2290:

Line 2293: --wsh_debug_sv.pop(l_api_name);

2289: END IF;
2290:
2291: IF (funcmode = 'TIMEOUT') THEN
2292: resultout := 'COMPLETE:';
2293: --wsh_debug_sv.pop(l_api_name);
2294: return;
2295: END IF;
2296:
2297:

Line 2327: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');

2323:
2324: BEGIN
2325:
2326:
2327: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');
2328:
2329: --
2330: -- RUN mode - normal process execution
2331: --

Line 2354: --wsh_debug_sv.pop(l_api_name);

2350: -- CANCEL mode
2351: --
2352: IF (funcmode = 'CANCEL') THEN
2353: resultout := 'COMPLETE:';
2354: --wsh_debug_sv.pop(l_api_name);
2355:
2356: return;
2357: END IF;
2358:

Line 2361: --wsh_debug_sv.pop(l_api_name);

2357: END IF;
2358:
2359: IF (funcmode = 'TIMEOUT') THEN
2360: resultout := 'COMPLETE:';
2361: --wsh_debug_sv.pop(l_api_name);
2362: return;
2363: END IF;
2364:
2365:

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

2395: --{
2396:
2397: l_api_name CONSTANT VARCHAR2(30) := 'GET_TENDER_INFO';
2398: l_api_version CONSTANT NUMBER := 1.0;
2399: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2400: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'GET_TENDER_INFO';
2401:
2402: l_wait_time NUMBER;
2403: l_wait_time_uom VARCHAR(10);

Line 2435: wsh_debug_sv.push(l_module_name);

2431: FND_MSG_PUB.initialize;
2432: END IF;
2433: --
2434: IF l_debug_on THEN
2435: wsh_debug_sv.push(l_module_name);
2436: END IF;
2437:
2438: --
2439: -- Initialize API return status to success

Line 2494: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!TenderedDate:'||x_tendered_date,WSH_DEBUG_SV.C_PROC_LEVEL);

2490: --l_respond_by_text := x_tendered_date + l_wait_time_days/(60*24);
2491:
2492: IF l_debug_on
2493: THEN
2494: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!TenderedDate:'||x_tendered_date,WSH_DEBUG_SV.C_PROC_LEVEL);
2495: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!WaitTime:'||l_wait_time||l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2496: --WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!ResponseByText:'||l_respond_by_text,WSH_DEBUG_SV.C_PROC_LEVEL);
2497: END IF;
2498:

Line 2495: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!WaitTime:'||l_wait_time||l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);

2491:
2492: IF l_debug_on
2493: THEN
2494: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!TenderedDate:'||x_tendered_date,WSH_DEBUG_SV.C_PROC_LEVEL);
2495: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!WaitTime:'||l_wait_time||l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2496: --WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!ResponseByText:'||l_respond_by_text,WSH_DEBUG_SV.C_PROC_LEVEL);
2497: END IF;
2498:
2499: l_temp_value := trunc(to_number(x_response_by-SYSDATE),2);

Line 2496: --WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!ResponseByText:'||l_respond_by_text,WSH_DEBUG_SV.C_PROC_LEVEL);

2492: IF l_debug_on
2493: THEN
2494: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!TenderedDate:'||x_tendered_date,WSH_DEBUG_SV.C_PROC_LEVEL);
2495: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!WaitTime:'||l_wait_time||l_wait_time_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2496: --WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!ResponseByText:'||l_respond_by_text,WSH_DEBUG_SV.C_PROC_LEVEL);
2497: END IF;
2498:
2499: l_temp_value := trunc(to_number(x_response_by-SYSDATE),2);
2500:

Line 2526: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!Remainingtime:'||x_remaining_time,WSH_DEBUG_SV.C_PROC_LEVEL);

2522: || 'h:' || l_rem_min || 'm';
2523:
2524: IF l_debug_on
2525: THEN
2526: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!Remainingtime:'||x_remaining_time,WSH_DEBUG_SV.C_PROC_LEVEL);
2527: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!SYSDATE:'||SYSDATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2528: END IF;
2529:
2530: --

Line 2527: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!SYSDATE:'||SYSDATE,WSH_DEBUG_SV.C_PROC_LEVEL);

2523:
2524: IF l_debug_on
2525: THEN
2526: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!Remainingtime:'||x_remaining_time,WSH_DEBUG_SV.C_PROC_LEVEL);
2527: WSH_DEBUG_SV.logmsg(l_module_name,'Nhi!SYSDATE:'||SYSDATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2528: END IF;
2529:
2530: --
2531: --

Line 2544: WSH_DEBUG_SV.pop(l_module_name);

2540: );
2541: --
2542: --
2543: IF l_debug_on THEN
2544: WSH_DEBUG_SV.pop(l_module_name);
2545: END IF;
2546:
2547: --}
2548: EXCEPTION

Line 2606: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');

2602:
2603: BEGIN
2604:
2605:
2606: --wsh_debug_sv.push(l_api_name,'>>FTE: Enterning Procedure');
2607:
2608: --
2609: -- RUN mode - normal process execution
2610: --

Line 2636: --wsh_debug_sv.pop(l_api_name);

2632: -- CANCEL mode
2633: --
2634: IF (funcmode = 'CANCEL') THEN
2635: resultout := 'COMPLETE:';
2636: --wsh_debug_sv.pop(l_api_name);
2637:
2638: return;
2639: END IF;
2640:

Line 2643: --wsh_debug_sv.pop(l_api_name);

2639: END IF;
2640:
2641: IF (funcmode = 'TIMEOUT') THEN
2642: resultout := 'COMPLETE:';
2643: --wsh_debug_sv.pop(l_api_name);
2644: return;
2645: END IF;
2646: --}
2647:

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

2673: l_api_version CONSTANT NUMBER := 1.0;
2674:
2675: l_trip_id NUMBER;
2676:
2677: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2678: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2679:
2680: l_tender_status VARCHAR2(30);
2681: l_rank_id NUMBER;

Line 2715: WSH_DEBUG_SV.logmsg(l_module_name,' TEnder status ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);

2711: l_rank_version := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_VERSION');
2712:
2713: IF l_debug_on
2714: THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,' TEnder status ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2716: END IF;
2717:
2718:
2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR

Line 2787: --wsh_debug_sv.pop(l_api_name);

2783: -- CANCEL mode
2784: --
2785: IF (funcmode = 'CANCEL') THEN
2786: resultout := 'COMPLETE:';
2787: --wsh_debug_sv.pop(l_api_name);
2788:
2789: return;
2790: END IF;
2791:

Line 2794: --wsh_debug_sv.pop(l_api_name);

2790: END IF;
2791:
2792: IF (funcmode = 'TIMEOUT') THEN
2793: resultout := 'COMPLETE:';
2794: --wsh_debug_sv.pop(l_api_name);
2795: return;
2796: END IF;
2797: --}
2798:

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

2826: l_api_version CONSTANT NUMBER := 1.0;
2827:
2828: l_trip_id NUMBER;
2829:
2830: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2831: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2832:
2833:
2834: BEGIN

Line 2859: --wsh_debug_sv.pop(l_api_name);

2855: END IF;
2856:
2857: IF (funcmode = 'TIMEOUT') THEN
2858: resultout := 'COMPLETE:';
2859: --wsh_debug_sv.pop(l_api_name);
2860: return;
2861: END IF;
2862: --}
2863:

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

2887: l_api_version CONSTANT NUMBER := 1.0;
2888:
2889: l_trip_id NUMBER;
2890:
2891: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2892: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2893:
2894: p_FTE_SS_ATTR_REC FTE_SS_ATTR_REC;
2895:

Line 3038: --wsh_debug_sv.pop(l_api_name);

3034: END IF;
3035:
3036: IF (funcmode = 'TIMEOUT') THEN
3037: resultout := 'COMPLETE:';
3038: --wsh_debug_sv.pop(l_api_name);
3039: return;
3040: END IF;
3041: --}
3042:

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

3067: l_api_version CONSTANT NUMBER := 1.0;
3068:
3069: l_trip_id NUMBER;
3070:
3071: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3072: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3073:
3074: l_is_exhausted VARCHAR2(10);
3075:

Line 3092: WSH_DEBUG_SV.push(l_module_name);

3088: --
3089: IF (funcmode = 'RUN') THEN
3090: --
3091: IF l_debug_on THEN
3092: WSH_DEBUG_SV.push(l_module_name);
3093: END IF;
3094:
3095:
3096: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3104: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

3100: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3101:
3102: IF l_debug_on
3103: THEN
3104: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
3105: END IF;
3106:
3107:
3108: FTE_CARRIER_RANK_LIST_PVT.IS_RANK_LIST_EXHAUSTED(

Line 3119: WSH_DEBUG_SV.logmsg(l_module_name,' After calling IS_RANK_LIST_EXHAUSTED ' ||

3115:
3116:
3117: IF l_debug_on
3118: THEN
3119: WSH_DEBUG_SV.logmsg(l_module_name,' After calling IS_RANK_LIST_EXHAUSTED ' ||
3120: l_is_exhausted,
3121: WSH_DEBUG_SV.C_PROC_LEVEL);
3122: END IF;
3123:

Line 3121: WSH_DEBUG_SV.C_PROC_LEVEL);

3117: IF l_debug_on
3118: THEN
3119: WSH_DEBUG_SV.logmsg(l_module_name,' After calling IS_RANK_LIST_EXHAUSTED ' ||
3120: l_is_exhausted,
3121: WSH_DEBUG_SV.C_PROC_LEVEL);
3122: END IF;
3123:
3124: IF ( (l_return_status = 'E')
3125: OR (l_return_status = 'U') )

Line 3135: WSH_DEBUG_SV.logmsg(l_module_name,' Returning back value ',

3131: END IF;
3132:
3133: IF l_debug_on
3134: THEN
3135: WSH_DEBUG_SV.logmsg(l_module_name,' Returning back value ',
3136: WSH_DEBUG_SV.C_PROC_LEVEL);
3137: END IF;
3138:
3139:

Line 3136: WSH_DEBUG_SV.C_PROC_LEVEL);

3132:
3133: IF l_debug_on
3134: THEN
3135: WSH_DEBUG_SV.logmsg(l_module_name,' Returning back value ',
3136: WSH_DEBUG_SV.C_PROC_LEVEL);
3137: END IF;
3138:
3139:
3140: IF (l_is_exhausted = 'T')

Line 3152: WSH_DEBUG_SV.pop(l_module_name);

3148:
3149: END IF; --- func mode
3150:
3151: IF l_debug_on THEN
3152: WSH_DEBUG_SV.pop(l_module_name);
3153: END IF;
3154:
3155:
3156: --

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

3195: l_api_version CONSTANT NUMBER := 1.0;
3196:
3197: l_trip_id NUMBER;
3198:
3199: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3200: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3201:
3202: l_priceRequestId NUMBER;
3203:

Line 3262: --wsh_debug_sv.pop(l_api_name);

3258: END IF;
3259:
3260: IF (funcmode = 'TIMEOUT') THEN
3261: resultout := 'COMPLETE:';
3262: --wsh_debug_sv.pop(l_api_name);
3263: return;
3264: END IF;
3265: --}
3266:

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

3291: l_api_version CONSTANT NUMBER := 1.0;
3292:
3293: l_trip_id NUMBER;
3294:
3295: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3296: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3297:
3298:
3299: l_return_status VARCHAR2(1);

Line 3386: --wsh_debug_sv.pop(l_api_name);

3382: END IF;
3383:
3384: IF (funcmode = 'TIMEOUT') THEN
3385: resultout := 'COMPLETE:';
3386: --wsh_debug_sv.pop(l_api_name);
3387: return;
3388: END IF;
3389: --}
3390:

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

3416: l_api_version CONSTANT NUMBER := 1.0;
3417:
3418: l_trip_id NUMBER;
3419:
3420: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3421: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3422:
3423:
3424: l_userId NUMBER;

Line 3440: WSH_DEBUG_SV.push(l_module_name);

3436: resultout := 'COMPLETE:Y';
3437: ELSIF (funcmode = 'SET_CTX') THEN
3438:
3439: IF l_debug_on THEN
3440: WSH_DEBUG_SV.push(l_module_name);
3441: END IF;
3442:
3443: l_userId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'USER_ID');
3444: l_respAppId := wf_engine.GetItemAttrNumber(itemtype,itemKey, 'RESP_APPL_ID');

Line 3448: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||

3444: l_respAppId := wf_engine.GetItemAttrNumber(itemtype,itemKey, 'RESP_APPL_ID');
3445: l_respId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'RESPONSIBILITY_ID');
3446:
3447: IF l_debug_on THEN
3448: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
3449: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);
3450: END IF;
3451:
3452:

Line 3449: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);

3445: l_respId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'RESPONSIBILITY_ID');
3446:
3447: IF l_debug_on THEN
3448: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
3449: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);
3450: END IF;
3451:
3452:
3453: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN

Line 3463: WSH_DEBUG_SV.pop(l_module_name);

3459: resultout := 'COMPLETE';
3460:
3461:
3462: IF l_debug_on THEN
3463: WSH_DEBUG_SV.pop(l_module_name);
3464: END IF;
3465:
3466: END IF; --- func mode
3467:

Line 3480: --wsh_debug_sv.pop(l_api_name);

3476: END IF;
3477:
3478: IF (funcmode = 'TIMEOUT') THEN
3479: resultout := 'COMPLETE:';
3480: --wsh_debug_sv.pop(l_api_name);
3481: return;
3482: END IF;
3483: --}
3484:

Line 3495: WSH_DEBUG_SV.pop(l_module_name);

3491: actid,
3492: funcmode,
3493: itemtype);
3494: IF l_debug_on THEN
3495: WSH_DEBUG_SV.pop(l_module_name);
3496: END IF;
3497:
3498: RAISE;
3499: