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_PVT dependencies on FTE_TENDER_PVT

Line 1: PACKAGE BODY FTE_TENDER_PVT AS

1: PACKAGE BODY FTE_TENDER_PVT AS
2: /* $Header: FTETEPVB.pls 120.7.12000000.2 2007/07/03 09:55:42 ueshanka ship $ */
3:
4: G_TENDER_NOTIFIED CONSTANT VARCHAR2(10) := 'NOTIFIED';
5: G_TENDER_APPROVED CONSTANT VARCHAR2(10) := 'APPROVED';

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TENDER_PVT';

5: G_TENDER_APPROVED CONSTANT VARCHAR2(10) := 'APPROVED';
6: G_TENDER_REJECTED CONSTANT VARCHAR2(10) := 'REJECTED';
7: G_TENDER_ABORT CONSTANT VARCHAR2(10) := 'eng_force';
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TENDER_PVT';
10:
11:
12: PROCEDURE RAISE_TENDER_REQUEST(
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 33: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'RAISE_TENDER_REQUEST';

29:
30: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_TENDER_REQUEST';
31: l_api_version CONSTANT NUMBER := 1.0;
32: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
33: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'RAISE_TENDER_REQUEST';
34:
35: BEGIN
36:
37:

Line 156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');

152: p_encoded => FND_API.G_FALSE
153: );
154: WHEN OTHERS THEN
155: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count,

Line 296: p_value => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,

292: p_value=> p_contact_perf,
293: p_parameterlist=>l_parameter_list);
294:
295: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
296: p_value => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,
297: p_parameterlist => l_parameter_list);
298:
299: wf_event.raise(
300: p_event_name => 'oracle.apps.fte.lt.tendercancel',

Line 345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');

341: p_encoded => FND_API.G_FALSE
342: );
343: WHEN OTHERS THEN
344: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,

Line 441: p_value => FTE_TENDER_PVT.S_ACCEPTED,

437: p_value=> p_contact_perf,
438: p_parameterlist=>l_parameter_list);
439:
440: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
441: p_value => FTE_TENDER_PVT.S_ACCEPTED,
442: p_parameterlist => l_parameter_list);
443:
444: --Rel 12 Changes for Freight Class
445: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');

Line 495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');

491: p_encoded => FND_API.G_FALSE
492: );
493: WHEN OTHERS THEN
494: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => x_msg_count,

Line 676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');

672: p_encoded => FND_API.G_FALSE
673: );
674: WHEN OTHERS THEN
675: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get
679: (
680: p_count => x_msg_count,

Line 766: p_value => FTE_TENDER_PVT.S_REJECTED,

762: p_value=> p_contact_perf,
763: p_parameterlist=>l_parameter_list);
764:
765: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
766: p_value => FTE_TENDER_PVT.S_REJECTED,
767: p_parameterlist => l_parameter_list);
768:
769: --Rel 12 Changes for Freight Class
770: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');

Line 818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');

814: p_encoded => FND_API.G_FALSE
815: );
816: WHEN OTHERS THEN
817: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,

Line 864: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || 'CAN_PERFORM_THIS_ACTION';

860:
861: l_trip_seg_status VARCHAR2(30);
862: l_tender_action VARCHAR2(30);
863: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
864: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || 'CAN_PERFORM_THIS_ACTION';
865:
866: l_return_value BOOLEAN;
867:
868: BEGIN

Line 877: IF ( (l_tender_action <> FTE_TENDER_PVT.S_TENDERED)

873: l_trip_seg_status := upper(p_trip_seg_status);
874: l_tender_action := upper(p_tender_action);
875: l_return_value := FALSE;
876:
877: IF ( (l_tender_action <> FTE_TENDER_PVT.S_TENDERED)
878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)
879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

Line 878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)

874: l_tender_action := upper(p_tender_action);
875: l_return_value := FALSE;
876:
877: IF ( (l_tender_action <> FTE_TENDER_PVT.S_TENDERED)
878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)
879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)

Line 879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)

875: l_return_value := FALSE;
876:
877: IF ( (l_tender_action <> FTE_TENDER_PVT.S_TENDERED)
878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)
879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)
883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)

Line 880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)

876:
877: IF ( (l_tender_action <> FTE_TENDER_PVT.S_TENDERED)
878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)
879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)
883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)
884: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED))

Line 881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

877: IF ( (l_tender_action <> FTE_TENDER_PVT.S_TENDERED)
878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)
879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)
883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)
884: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED))
885: THEN

Line 882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)

878: AND (l_tender_action <> FTE_TENDER_PVT.S_RETENDERED)
879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)
883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)
884: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED))
885: THEN
886: l_return_value := FALSE;

Line 883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)

879: AND (l_tender_action <> FTE_TENDER_PVT.S_ACCEPTED)
880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)
883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)
884: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED))
885: THEN
886: l_return_value := FALSE;
887: --return FALSE;

Line 884: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED))

880: AND (l_tender_action <> FTE_TENDER_PVT.S_AUTO_ACCEPTED)
881: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
882: AND (l_tender_action <> FTE_TENDER_PVT.S_REJECTED)
883: AND (l_tender_action <> FTE_TENDER_PVT.S_NORESPONSE)
884: AND (l_tender_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED))
885: THEN
886: l_return_value := FALSE;
887: --return FALSE;
888: END IF;

Line 894: AND (l_tender_action <> FTE_TENDER_PVT.S_TENDERED))

890: IF (l_trip_seg_status IS NULL)
891: THEN
892:
893: IF ((l_tender_action IS NOT NULL)
894: AND (l_tender_action <> FTE_TENDER_PVT.S_TENDERED))
895: THEN
896: l_return_value := FALSE;
897: --return FALSE;
898: ELSE

Line 902: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_TENDERED)

898: ELSE
899: l_return_value := TRUE;
900: --return TRUE;
901: END IF;
902: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_TENDERED)
903: OR (l_trip_seg_status = FTE_TENDER_PVT.S_RETENDERED))
904: THEN
905: IF ((l_tender_action IS NULL )
906: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)

Line 903: OR (l_trip_seg_status = FTE_TENDER_PVT.S_RETENDERED))

899: l_return_value := TRUE;
900: --return TRUE;
901: END IF;
902: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_TENDERED)
903: OR (l_trip_seg_status = FTE_TENDER_PVT.S_RETENDERED))
904: THEN
905: IF ((l_tender_action IS NULL )
906: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
907: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED))

Line 906: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)

902: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_TENDERED)
903: OR (l_trip_seg_status = FTE_TENDER_PVT.S_RETENDERED))
904: THEN
905: IF ((l_tender_action IS NULL )
906: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
907: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED))
908: THEN
909: l_return_value := FALSE;
910: --return FALSE;

Line 907: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED))

903: OR (l_trip_seg_status = FTE_TENDER_PVT.S_RETENDERED))
904: THEN
905: IF ((l_tender_action IS NULL )
906: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
907: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED))
908: THEN
909: l_return_value := FALSE;
910: --return FALSE;
911: ELSE

Line 916: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_ACCEPTED)

912: l_return_value := TRUE;
913: --return TRUE;
914: END IF;
915:
916: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_ACCEPTED)
917: OR (l_trip_seg_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
918: THEN
919: IF ((l_tender_action IS NULL )
920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)

Line 917: OR (l_trip_seg_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED))

913: --return TRUE;
914: END IF;
915:
916: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_ACCEPTED)
917: OR (l_trip_seg_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
918: THEN
919: IF ((l_tender_action IS NULL )
920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)

Line 920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)

916: ELSIF ( (l_trip_seg_status = FTE_TENDER_PVT.S_ACCEPTED)
917: OR (l_trip_seg_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
918: THEN
919: IF ((l_tender_action IS NULL )
920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
922: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
923: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
924: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))

Line 921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)

917: OR (l_trip_seg_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
918: THEN
919: IF ((l_tender_action IS NULL )
920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
922: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
923: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
924: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
925: THEN

Line 922: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)

918: THEN
919: IF ((l_tender_action IS NULL )
920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
922: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
923: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
924: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
925: THEN
926: l_return_value := FALSE;

Line 923: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

919: IF ((l_tender_action IS NULL )
920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
922: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
923: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
924: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
925: THEN
926: l_return_value := FALSE;
927: --return FALSE;

Line 924: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))

920: OR (l_tender_action = FTE_TENDER_PVT.S_TENDERED)
921: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
922: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
923: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
924: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
925: THEN
926: l_return_value := FALSE;
927: --return FALSE;
928: ELSE

Line 932: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_REJECTED)

928: ELSE
929: l_return_value := TRUE;
930: --return TRUE;
931: END IF;
932: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_REJECTED)
933: THEN
934: IF ((l_tender_action IS NULL )
935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

Line 935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)

931: END IF;
932: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_REJECTED)
933: THEN
934: IF ((l_tender_action IS NULL )
935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

Line 936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

932: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_REJECTED)
933: THEN
934: IF ((l_tender_action IS NULL )
935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
940: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))

Line 937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)

933: THEN
934: IF ((l_tender_action IS NULL )
935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
940: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
941: THEN

Line 938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)

934: IF ((l_tender_action IS NULL )
935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
940: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
941: THEN
942: l_return_value := FALSE;

Line 939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

935: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
940: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
941: THEN
942: l_return_value := FALSE;
943: --return FALSE;

Line 940: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))

936: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
937: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
938: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
939: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
940: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
941: THEN
942: l_return_value := FALSE;
943: --return FALSE;
944: ELSE

Line 948: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

944: ELSE
945: l_return_value := TRUE;
946: --return TRUE;
947: END IF;
948: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
949: THEN
950: IF ( (l_tender_action IS NULL)
951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

Line 951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

947: END IF;
948: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
949: THEN
950: IF ( (l_tender_action IS NULL)
951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
953: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
954: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
955: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED))

Line 952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

948: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
949: THEN
950: IF ( (l_tender_action IS NULL)
951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
953: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
954: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
955: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
956: THEN

Line 953: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)

949: THEN
950: IF ( (l_tender_action IS NULL)
951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
953: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
954: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
955: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
956: THEN
957: l_return_value := FALSE;

Line 954: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)

950: IF ( (l_tender_action IS NULL)
951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
953: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
954: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
955: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
956: THEN
957: l_return_value := FALSE;
958: --return FALSE;

Line 955: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED))

951: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
952: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
953: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
954: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
955: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED))
956: THEN
957: l_return_value := FALSE;
958: --return FALSE;
959: ELSE

Line 963: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_NORESPONSE)

959: ELSE
960: l_return_value := TRUE;
961: --return TRUE;
962: END IF;
963: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_NORESPONSE)
964: THEN
965: IF ( (l_tender_action IS NULL)
966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

Line 966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)

962: END IF;
963: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_NORESPONSE)
964: THEN
965: IF ( (l_tender_action IS NULL)
966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)

Line 967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)

963: ELSIF (l_trip_seg_status = FTE_TENDER_PVT.S_NORESPONSE)
964: THEN
965: IF ( (l_tender_action IS NULL)
966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
971: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))

Line 968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)

964: THEN
965: IF ( (l_tender_action IS NULL)
966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
971: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
972: THEN

Line 969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)

965: IF ( (l_tender_action IS NULL)
966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
971: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
972: THEN
973: l_return_value := FALSE;

Line 970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)

966: OR (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED)
967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
971: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
972: THEN
973: l_return_value := FALSE;
974: --return FALSE;

Line 971: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))

967: OR (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED)
968: OR (l_tender_action = FTE_TENDER_PVT.S_RETENDERED)
969: OR (l_tender_action = FTE_TENDER_PVT.S_REJECTED)
970: OR (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED)
971: OR (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE))
972: THEN
973: l_return_value := FALSE;
974: --return FALSE;
975: ELSE

Line 1003: IF (NOT FTE_TENDER_PVT.CAN_PERFORM_THIS_ACTION(p_trip_seg_status,

999: RETURN VARCHAR2
1000: IS
1001: BEGIN
1002:
1003: IF (NOT FTE_TENDER_PVT.CAN_PERFORM_THIS_ACTION(p_trip_seg_status,
1004: p_tender_action))
1005: THEN
1006: RETURN 'N';
1007: ELSE

Line 1107: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || l_api_name;

1103: where trip_id = c_trip_id;
1104:
1105: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1106:
1107: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || l_api_name;
1108:
1109: BEGIN
1110: --{
1111:

Line 1275: wsh_util_core.default_handler('FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST');

1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:31 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1273: END IF;
1274: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1275: wsh_util_core.default_handler('FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST');
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: FND_MSG_PUB.Count_And_Get
1278: (
1279: p_count => x_msg_count,

Line 1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');

1393: p_encoded => FND_API.G_FALSE
1394: );
1395: WHEN OTHERS THEN
1396: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');
1398: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1399: FND_MSG_PUB.Count_And_Get
1400: (
1401: p_count => x_msg_count,

Line 1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

1575: p_encoded => FND_API.G_FALSE
1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get
1582: (
1583: p_count => x_msg_count,

Line 1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

1752: p_encoded => FND_API.G_FALSE
1753: );
1754: WHEN OTHERS THEN
1755: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1758: FND_MSG_PUB.Count_And_Get
1759: (
1760: p_count => x_msg_count,

Line 1876: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || 'CHECK_THRESHOLD_FOR_STOP';

1872: and session_value = c_session_value;
1873:
1874: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1875:
1876: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || 'CHECK_THRESHOLD_FOR_STOP';
1877:
1878: l_number_of_warnings NUMBER;
1879: l_number_of_errors NUMBER;
1880: l_return_status VARCHAR2(32767);

Line 1940: OR (l_tender_status <> FTE_TENDER_PVT.S_TENDERED)

1936: -- If status is not tendered or accepted then
1937: -- just return back
1938: IF ((l_tender_status IS NULL)
1939: OR (l_tender_status = FND_API.G_MISS_CHAR)
1940: OR (l_tender_status <> FTE_TENDER_PVT.S_TENDERED)
1941: AND (l_tender_status <> FTE_TENDER_PVT.S_ACCEPTED)
1942: AND (l_tender_status <> FTE_TENDER_PVT.S_AUTO_ACCEPTED))
1943: THEN
1944: IF l_debug_on THEN

Line 1941: AND (l_tender_status <> FTE_TENDER_PVT.S_ACCEPTED)

1937: -- just return back
1938: IF ((l_tender_status IS NULL)
1939: OR (l_tender_status = FND_API.G_MISS_CHAR)
1940: OR (l_tender_status <> FTE_TENDER_PVT.S_TENDERED)
1941: AND (l_tender_status <> FTE_TENDER_PVT.S_ACCEPTED)
1942: AND (l_tender_status <> FTE_TENDER_PVT.S_AUTO_ACCEPTED))
1943: THEN
1944: IF l_debug_on THEN
1945:

Line 1942: AND (l_tender_status <> FTE_TENDER_PVT.S_AUTO_ACCEPTED))

1938: IF ((l_tender_status IS NULL)
1939: OR (l_tender_status = FND_API.G_MISS_CHAR)
1940: OR (l_tender_status <> FTE_TENDER_PVT.S_TENDERED)
1941: AND (l_tender_status <> FTE_TENDER_PVT.S_ACCEPTED)
1942: AND (l_tender_status <> FTE_TENDER_PVT.S_AUTO_ACCEPTED))
1943: THEN
1944: IF l_debug_on THEN
1945:
1946: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP NOT TENDERED OR ACCEPTED',

Line 2088: p_action => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,

2084: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP
2085: ( p_api_version_number => 1.0,
2086: p_init_msg_list => FND_API.G_FALSE,
2087: p_action_code => 'UPDATE',
2088: p_action => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,
2089: p_rec_TRIP_ID => l_trip_id,
2090: x_return_status => l_return_status,
2091: x_msg_count => l_msg_count,
2092: x_msg_data => l_msg_data,

Line 2536: p_action => FTE_TENDER_PVT.S_SHIPPER_UPDATED,

2532: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP
2533: ( p_api_version_number => 1.0,
2534: p_init_msg_list => FND_API.G_FALSE,
2535: p_action_code => 'UPDATE',
2536: p_action => FTE_TENDER_PVT.S_SHIPPER_UPDATED,
2537: p_rec_TRIP_ID => l_trip_id,
2538: x_return_status => l_return_status,
2539: x_msg_count => l_msg_count,
2540: x_msg_data => l_msg_data,

Line 2640: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP');

2636: WSH_DEBUG_SV.pop(l_module_name);
2637: END IF;
2638: WHEN OTHERS THEN
2639: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2640: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP');
2641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2642: FND_MSG_PUB.Count_And_Get
2643: (
2644: p_count => x_msg_count,

Line 2723: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || 'HANDLE_WF_ROLES';

2719:
2720:
2721: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2722:
2723: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT' || '.' || 'HANDLE_WF_ROLES';
2724:
2725: CURSOR user_party_cur (carrier_contact_id NUMBER)
2726: IS
2727: SELECT user_name

Line 2958: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_WF_ROLES');

2954: WSH_DEBUG_SV.pop(l_module_name);
2955: END IF;
2956: WHEN OTHERS THEN
2957: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2958: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_WF_ROLES');
2959: x_return_status := FND_API.G_RET_STS_ERROR;
2960: FND_MSG_PUB.Count_And_Get
2961: (
2962: p_count => x_msg_count,

Line 3064: IF (p_action = FTE_TENDER_PVT.S_TENDERED OR

3060: -- As per PackJ to show notifications for carrier user, in worklist
3061: -- Call HANDLE_WF_ROLE procedure. Get the role_name and assign that
3062: -- as the performer p_contact_perf.
3063:
3064: IF (p_action = FTE_TENDER_PVT.S_TENDERED OR
3065: p_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
3066: p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
3067: THEN
3068:

Line 3065: p_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR

3061: -- Call HANDLE_WF_ROLE procedure. Get the role_name and assign that
3062: -- as the performer p_contact_perf.
3063:
3064: IF (p_action = FTE_TENDER_PVT.S_TENDERED OR
3065: p_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
3066: p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
3067: THEN
3068:
3069: HANDLE_WF_ROLES(

Line 3066: p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED)

3062: -- as the performer p_contact_perf.
3063:
3064: IF (p_action = FTE_TENDER_PVT.S_TENDERED OR
3065: p_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
3066: p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
3067: THEN
3068:
3069: HANDLE_WF_ROLES(
3070: p_init_msg_list => FND_API.G_FALSE,

Line 3095: IF (p_action = FTE_TENDER_PVT.S_TENDERED) THEN

3091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3092: END IF;
3093: END IF;
3094:
3095: IF (p_action = FTE_TENDER_PVT.S_TENDERED) THEN
3096:
3097: RAISE_TENDER_REQUEST(
3098: p_init_msg_list => p_init_msg_list,
3099: x_return_status => x_return_status,

Line 3112: ELSIF (p_action = FTE_TENDER_PVT.S_ACCEPTED) THEN

3108: p_autoaccept => p_autoaccept,
3109: --p_contact_perf => p_contact_perf,
3110: p_contact_perf => l_role_name,
3111: p_url => p_url);
3112: ELSIF (p_action = FTE_TENDER_PVT.S_ACCEPTED) THEN
3113: -- For accept / reject we do not have to send
3114: -- role name. Because it is not changed.
3115: RAISE_TENDER_ACCEPT(
3116: p_init_msg_list => p_init_msg_list,

Line 3127: ELSIF (p_action = FTE_TENDER_PVT.S_REJECTED) THEN

3123: p_carrier_name => p_carrier_name,
3124: p_contact_name => p_contact_name,
3125: p_contact_perf => p_contact_perf);
3126: --p_contact_perf => l_role_name);
3127: ELSIF (p_action = FTE_TENDER_PVT.S_REJECTED) THEN
3128: RAISE_TENDER_REJECT(
3129: p_init_msg_list => p_init_msg_list,
3130: x_return_status => x_return_status,
3131: x_msg_count => x_msg_count,

Line 3140: ELSIF (p_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED) THEN

3136: p_carrier_name => p_carrier_name,
3137: p_contact_name => p_contact_name,
3138: p_contact_perf => p_contact_perf);
3139: --p_contact_perf => l_role_name);
3140: ELSIF (p_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED) THEN
3141: RAISE_TENDER_CANCEL(
3142: p_init_msg_list => p_init_msg_list,
3143: x_return_status => x_return_status,
3144: x_msg_count => x_msg_count,

Line 3153: ELSIF (p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED) THEN

3149: p_carrier_name => p_carrier_name,
3150: p_contact_name => p_contact_name,
3151: --p_contact_perf => p_contact_perf);
3152: p_contact_perf => l_role_name);
3153: ELSIF (p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED) THEN
3154: RAISE_TENDER_UPDATE(
3155: p_init_msg_list => p_init_msg_list,
3156: x_return_status => x_return_status,
3157: x_msg_count => x_msg_count,

Line 3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');

3196: p_encoded => FND_API.G_FALSE
3197: );
3198: WHEN OTHERS THEN
3199: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: FND_MSG_PUB.Count_And_Get
3203: (
3204: p_count => x_msg_count,

Line 3252: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'CHECK_CARRIER_ARRIVAL_TIME';

3248: l_dreturn_status VARCHAR2(1);
3249: l_dmsg varchar2(2000);
3250:
3251: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3252: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'CHECK_CARRIER_ARRIVAL_TIME';
3253:
3254:
3255: BEGIN
3256:

Line 3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');

3385: p_encoded => FND_API.G_FALSE
3386: );
3387: WHEN OTHERS THEN
3388: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');
3390: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3391: FND_MSG_PUB.Count_And_Get
3392: (
3393: p_count => x_msg_count,

Line 3422: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'CHECK_CARRIER_ARRIVAL_TIME';

3418: l_carrier_est_departure_date date;
3419: l_last_stop_location_id Number;
3420:
3421: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3422: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'CHECK_CARRIER_ARRIVAL_TIME';
3423:
3424: l_return_status VARCHAR2(32767);
3425: l_msg_count NUMBER;
3426: l_msg_data VARCHAR2(32767);

Line 3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');

3501: p_encoded => FND_API.G_FALSE
3502: );
3503: WHEN OTHERS THEN
3504: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');
3506: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3507: FND_MSG_PUB.Count_And_Get
3508: (
3509: p_count => x_msg_count,

Line 3542: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'COMPLETE_CANCEL_TENDER';

3538: l_number_of_warnings NUMBER;
3539: l_number_of_errors NUMBER;
3540:
3541: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3542: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || 'FTE_TENDER_PVT'|| '.' || 'COMPLETE_CANCEL_TENDER';
3543:
3544: cursor check_exception_on_trip(p_tender_id Number) is
3545: select exception_id, status from
3546: wsh_exceptions we, wsh_trips wt where we.trip_id = wt.trip_id and

Line 3668: wsh_util_core.default_handler('FTE_TENDER_PVT.COMPLETE_CANCEL_TENDER');

3664: );
3665:
3666: WHEN OTHERS THEN
3667: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3668: wsh_util_core.default_handler('FTE_TENDER_PVT.COMPLETE_CANCEL_TENDER');
3669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3670: FND_MSG_PUB.Count_And_Get
3671: (
3672: p_count => x_msg_count,

Line 3899: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');

3895:
3896:
3897: WHEN OTHERS THEN
3898: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3899: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3900: x_return_status := FND_API.G_RET_STS_ERROR;
3901: FND_MSG_PUB.Count_And_Get
3902: (
3903: p_count => x_msg_count,

Line 4062: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_ACCEPTED;

4058: p_trip_info.wf_process_name := p_carrier_response_rec.wf_process_name;
4059: p_trip_info.carrier_Response := p_carrier_response_rec.remarks;
4060: p_trip_info.operator := p_carrier_response_Rec.operator;
4061: p_trip_info.vehicle_number := p_carrier_response_rec.VEHICLE_NUMBER;
4062: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_ACCEPTED;
4063: p_trip_info.carrier_reference_number := p_carrier_response_rec.carrier_ref_number;
4064:
4065: p_trip_info_tab(1) :=p_trip_info;
4066: p_trip_in_rec.caller :='FTE_MLS_WRAPPER';

Line 4111: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_REJECTED;

4107: p_trip_info.TRIP_ID := p_carrier_response_rec.trip_id;
4108: p_trip_info.wf_name := p_carrier_response_rec.WF_NAME;
4109: p_trip_info.wf_process_name := p_carrier_response_rec.wf_process_name;
4110: p_trip_info.carrier_Response := p_carrier_response_rec.remarks;
4111: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_REJECTED;
4112:
4113:
4114: p_trip_info_tab(1) :=p_trip_info;
4115: p_trip_in_rec.caller :='FTE_MLS_WRAPPER';

Line 4218: wsh_util_core.default_handler('FTE_TENDER_PVT.UPDATE_CARRIER_RESPONSE');

4214: );
4215:
4216: WHEN OTHERS THEN
4217: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4218: wsh_util_core.default_handler('FTE_TENDER_PVT.UPDATE_CARRIER_RESPONSE');
4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get
4221: (
4222: p_count => x_msg_count,

Line 4327: IF (p_trip_info.tender_status = FTE_TENDER_PVT.S_ACCEPTED) THEN

4323:
4324:
4325: IF (l_result_code = G_TENDER_NOTIFIED) THEN
4326:
4327: IF (p_trip_info.tender_status = FTE_TENDER_PVT.S_ACCEPTED) THEN
4328: wf_engine.CompleteActivity(
4329: itemtype => 'FTETEREQ',
4330: itemkey => p_trip_info.wf_item_key,
4331: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',

Line 4333: ELSIF (p_trip_info.tender_status = FTE_TENDER_PVT.S_REJECTED) THEN

4329: itemtype => 'FTETEREQ',
4330: itemkey => p_trip_info.wf_item_key,
4331: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',
4332: result => G_TENDER_APPROVED);
4333: ELSIF (p_trip_info.tender_status = FTE_TENDER_PVT.S_REJECTED) THEN
4334: wf_engine.CompleteActivity(
4335: itemtype => 'FTETEREQ',
4336: itemkey => p_trip_info.wf_item_key,
4337: activity => 'TENDER_REQUEST_PROCESS:TENDER_REQUEST_NTF',

Line 4404: wsh_util_core.default_handler('FTE_TENDER_PVT.RELEASE_TENDER_BLOCK');

4400:
4401:
4402: WHEN OTHERS THEN
4403: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4404: wsh_util_core.default_handler('FTE_TENDER_PVT.RELEASE_TENDER_BLOCK');
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406: FND_MSG_PUB.Count_And_Get
4407: (
4408: p_count => x_msg_count,

Line 4512: IF (p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_CP OR

4508:
4509:
4510: -- If source is S_SOURCE_CP or S_SOURCE_XML we have to release the block
4511: -- So call Release block API
4512: IF (p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_CP OR
4513: p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_XML)
4514: THEN
4515:
4516: RELEASE_TENDER_BLOCK(

Line 4513: p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_XML)

4509:
4510: -- If source is S_SOURCE_CP or S_SOURCE_XML we have to release the block
4511: -- So call Release block API
4512: IF (p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_CP OR
4513: p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_XML)
4514: THEN
4515:
4516: RELEASE_TENDER_BLOCK(
4517: p_init_msg_list => FND_API.G_FALSE,

Line 4596: IF (p_trip_info.tender_status = FTE_TENDER_PVT.S_ACCEPTED) THEN

4592: p_trip_info.wf_item_key,'RESP_APPL_ID'),
4593: p_parameterlist=>l_parameter_list);
4594:
4595:
4596: IF (p_trip_info.tender_status = FTE_TENDER_PVT.S_ACCEPTED) THEN
4597: wf_event.raise(
4598: p_event_name => 'oracle.apps.fte.lt.tenderaccept',
4599: p_event_key => p_trip_info.wf_item_key,
4600: p_parameters => l_parameter_list

Line 4603: ELSIF (p_trip_info.tender_status = FTE_TENDER_PVT.S_REJECTED) THEN

4599: p_event_key => p_trip_info.wf_item_key,
4600: p_parameters => l_parameter_list
4601: );
4602:
4603: ELSIF (p_trip_info.tender_status = FTE_TENDER_PVT.S_REJECTED) THEN
4604: wf_event.raise(
4605: p_event_name => 'oracle.apps.fte.lt.tenderreject',
4606: p_event_key => p_trip_info.wf_item_key,
4607: p_parameters => l_parameter_list);

Line 4664: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE');

4660:
4661:
4662: WHEN OTHERS THEN
4663: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4664: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE');
4665: x_return_status := FND_API.G_RET_STS_ERROR;
4666: FND_MSG_PUB.Count_And_Get
4667: (
4668: p_count => x_msg_count,

Line 4751: p_wsh_trip_info.load_tender_status := FTE_TENDER_PVT.S_SHIPPER_CANCELLED;

4747: p_wsh_trip_info.wf_process_name := p_trip_info.wf_process_name;
4748: p_wsh_trip_info.carrier_Response := NULL;
4749: p_wsh_trip_info.operator := NULL;
4750: p_wsh_trip_info.vehicle_number := NULL;
4751: p_wsh_trip_info.load_tender_status := FTE_TENDER_PVT.S_SHIPPER_CANCELLED;
4752: p_wsh_trip_info.carrier_reference_number := NULL;
4753:
4754:
4755: p_trip_info_tab(1) :=p_wsh_trip_info;

Line 4946: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_CANCEL_TENDER');

4942:
4943:
4944: WHEN OTHERS THEN
4945: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4946: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_CANCEL_TENDER');
4947: x_return_status := FND_API.G_RET_STS_ERROR;
4948: FND_MSG_PUB.Count_And_Get
4949: (
4950: p_count => x_msg_count,

Line 5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');

5147: p_encoded => FND_API.G_FALSE
5148: );
5149: WHEN OTHERS THEN
5150: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');
5152: x_return_status := FND_API.G_RET_STS_ERROR;
5153: FND_MSG_PUB.Count_And_Get
5154: (
5155: p_count => x_msg_count,

Line 5167: END FTE_TENDER_PVT;

5163:
5164:
5165: --}
5166:
5167: END FTE_TENDER_PVT;