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 WSH_DEBUG_SV

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

28: l_parameter_list wf_parameter_list_t;
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:

Line 40: WSH_DEBUG_SV.push(l_module_name);

36:
37:
38: SAVEPOINT RAISE_TENDER_REQUEST_PUB;
39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: END IF;
42:
43: IF FND_API.to_Boolean( p_init_msg_list )
44: THEN

Line 97: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:22 ',WSH_DEBUG_SV.C_PROC_LEVEL);

93: p_value=> p_url,
94: p_parameterlist=>l_parameter_list);
95:
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:22 ',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99: -- event key should be based on some other value
100:
101: wf_event.raise(

Line 108: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:23 ',WSH_DEBUG_SV.C_PROC_LEVEL);

104: p_parameters => l_parameter_list
105: );
106:
107: IF l_debug_on THEN
108: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:23 ',WSH_DEBUG_SV.C_PROC_LEVEL);
109: END IF;
110:
111: l_parameter_list.DELETE;
112:

Line 116: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:24 ',WSH_DEBUG_SV.C_PROC_LEVEL);

112:
113: -- Standard call to get message count and if count is 1,get message info.
114: --
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:24 ',WSH_DEBUG_SV.C_PROC_LEVEL);
117: END IF;
118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count,

Line 130: WSH_DEBUG_SV.pop(l_module_name);

126: --
127: --
128:
129: IF l_debug_on THEN
130: WSH_DEBUG_SV.pop(l_module_name);
131: END IF;
132:
133: --}
134: EXCEPTION

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

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

Line 871: WSH_DEBUG_SV.push(l_module_name);

867:
868: BEGIN
869: --{
870: IF l_debug_on THEN
871: WSH_DEBUG_SV.push(l_module_name);
872: END IF;
873: l_trip_seg_status := upper(p_trip_seg_status);
874: l_tender_action := upper(p_tender_action);
875: l_return_value := FALSE;

Line 981: WSH_DEBUG_SV.pop(l_module_name);

977: --return TRUE;
978: END IF;
979: END IF;
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.pop(l_module_name);
982: END IF;
983:
984: RETURN l_return_value;
985:

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

1101: select trip_id, name,load_tender_status
1102: from wsh_trips
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

Line 1122: wsh_debug_sv.push(l_module_name);

1118: FND_MSG_PUB.initialize;
1119: END IF;
1120: --
1121: IF l_debug_on THEN
1122: wsh_debug_sv.push(l_module_name);
1123: END IF;
1124: --
1125: -- Initialize API return status to success
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1140: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:26 ',WSH_DEBUG_SV.C_PROC_LEVEL);

1136: p_encoded => FND_API.G_FALSE
1137: );
1138: END IF;
1139: IF l_debug_on THEN
1140: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:26 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1141: END IF;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1144: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

1140: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:26 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1141: END IF;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1145: END IF;
1146:
1147: FOR get_trip_rec IN get_trip_cur(p_trip_id)
1148: LOOP

Line 1159: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:27 ',WSH_DEBUG_SV.C_PROC_LEVEL);

1155: -- END OF get trip segment info
1156: --
1157: --
1158: IF l_debug_on THEN
1159: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:27 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1160: END IF;
1161:
1162: IF get_trip_cur%ISOPEN THEN
1163: CLOSE get_trip_cur;

Line 1168: WSH_DEBUG_SV.logmsg(l_module_name,' Current Tender Status ' || l_trip_status,

1164: END IF;
1165: --
1166:
1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name,' Current Tender Status ' || l_trip_status,
1169: WSH_DEBUG_SV.C_PROC_LEVEL);
1170: WSH_DEBUG_SV.logmsg(l_module_name,' REquested tener action ' || p_tender_action,
1171: WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;

Line 1169: WSH_DEBUG_SV.C_PROC_LEVEL);

1165: --
1166:
1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name,' Current Tender Status ' || l_trip_status,
1169: WSH_DEBUG_SV.C_PROC_LEVEL);
1170: WSH_DEBUG_SV.logmsg(l_module_name,' REquested tener action ' || p_tender_action,
1171: WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173: -- check if trip id is null

Line 1170: WSH_DEBUG_SV.logmsg(l_module_name,' REquested tener action ' || p_tender_action,

1166:
1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name,' Current Tender Status ' || l_trip_status,
1169: WSH_DEBUG_SV.C_PROC_LEVEL);
1170: WSH_DEBUG_SV.logmsg(l_module_name,' REquested tener action ' || p_tender_action,
1171: WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173: -- check if trip id is null
1174: -- If trip id is null then was unable to find trip based on

Line 1171: WSH_DEBUG_SV.C_PROC_LEVEL);

1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name,' Current Tender Status ' || l_trip_status,
1169: WSH_DEBUG_SV.C_PROC_LEVEL);
1170: WSH_DEBUG_SV.logmsg(l_module_name,' REquested tener action ' || p_tender_action,
1171: WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173: -- check if trip id is null
1174: -- If trip id is null then was unable to find trip based on
1175: -- tender id

Line 1178: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:28 ',WSH_DEBUG_SV.C_PROC_LEVEL);

1174: -- If trip id is null then was unable to find trip based on
1175: -- tender id
1176: IF l_trip_id IS NULL THEN
1177: IF l_debug_on THEN
1178: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:28 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1179: END IF;
1180:
1181: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TENDER_ID');
1182: --FND_MESSAGE.SET_TOKEN('TENDER_ID',p_trip_id);

Line 1186: wsh_debug_sv.pop(l_api_name);

1182: --FND_MESSAGE.SET_TOKEN('TENDER_ID',p_trip_id);
1183: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1184:
1185: IF l_debug_on THEN
1186: wsh_debug_sv.pop(l_api_name);
1187: END IF;
1188:
1189: RAISE FND_API.G_EXC_ERROR;
1190:

Line 1198: WSH_DEBUG_SV.logmsg(l_module_name,'NOT CAN_PERFORM_THIS_ACTION', WSH_DEBUG_SV.C_PROC_LEVEL);

1194: -- If trip id is null then was unable to find trip based on
1195: -- tender id
1196: IF NOT CAN_PERFORM_THIS_ACTION(l_trip_status,p_tender_action) THEN
1197: IF l_debug_on THEN
1198: WSH_DEBUG_SV.logmsg(l_module_name,'NOT CAN_PERFORM_THIS_ACTION', WSH_DEBUG_SV.C_PROC_LEVEL);
1199: END IF;
1200:
1201:
1202: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TENDER_STATUS');

Line 1218: WSH_DEBUG_SV.logmsg(l_module_name,'after CAN_PERFORM_THIS_ACTION', WSH_DEBUG_SV.C_PROC_LEVEL);

1214:
1215: END IF;
1216:
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.logmsg(l_module_name,'after CAN_PERFORM_THIS_ACTION', WSH_DEBUG_SV.C_PROC_LEVEL);
1219: END IF;
1220:
1221: -- Standard call to get message count and if count is 1,get message info.
1222: --

Line 1232: WSH_DEBUG_SV.pop(l_module_name);

1228: p_encoded => FND_API.G_FALSE
1229: );
1230:
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.pop(l_module_name);
1233: END IF;
1234:
1235: --
1236: --

Line 1242: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:29 ',WSH_DEBUG_SV.C_PROC_LEVEL);

1238:
1239: EXCEPTION
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:29 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: END IF;
1244: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1245: x_return_status := FND_API.G_RET_STS_ERROR ;
1246: FND_MSG_PUB.Count_And_Get

Line 1253: WSH_DEBUG_SV.pop(l_module_name);

1249: p_data => x_msg_data,
1250: p_encoded => FND_API.G_FALSE
1251: );
1252: IF l_debug_on THEN
1253: WSH_DEBUG_SV.pop(l_module_name);
1254: END IF;
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1257: IF l_debug_on THEN

Line 1258: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:30 ',WSH_DEBUG_SV.C_PROC_LEVEL);

1254: END IF;
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:30 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1261: FND_MSG_PUB.Count_And_Get
1262: (

Line 1268: WSH_DEBUG_SV.pop(l_module_name);

1264: p_data => x_msg_data,
1265: p_encoded => FND_API.G_FALSE
1266: );
1267: IF l_debug_on THEN
1268: WSH_DEBUG_SV.pop(l_module_name);
1269: END IF;
1270: WHEN OTHERS THEN
1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:31 ',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1272: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:31 ',WSH_DEBUG_SV.C_PROC_LEVEL);

1268: WSH_DEBUG_SV.pop(l_module_name);
1269: END IF;
1270: WHEN OTHERS THEN
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;

Line 1284: WSH_DEBUG_SV.pop(l_module_name);

1280: p_data => x_msg_data,
1281: p_encoded => FND_API.G_FALSE
1282: );
1283: IF l_debug_on THEN
1284: WSH_DEBUG_SV.pop(l_module_name);
1285: END IF;
1286:
1287: END VALIDATE_TENDER_REQUEST;
1288:

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

1870: where trip_id = c_trip_id
1871: and load_tender_number = c_tender_number
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;

Line 1896: wsh_debug_sv.push(l_module_name);

1892: --
1893: x_return_status := FND_API.G_RET_STS_SUCCESS;
1894:
1895: IF l_debug_on THEN
1896: wsh_debug_sv.push(l_module_name);
1897: END IF;
1898: --
1899: -- Initialize message list if p_init_msg_list is set to TRUE.
1900: --

Line 1923: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP ID => ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

1919: l_stop_id := P_new_segment_stop_rec.STOP_ID;
1920:
1921:
1922: IF l_debug_on THEN
1923: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP ID => ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1924: WSH_DEBUG_SV.logmsg(l_module_name,'STOP ID => ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1925: WSH_DEBUG_SV.logmsg(l_module_name,'TENDER STATUS => ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1926: END IF;
1927:

Line 1924: WSH_DEBUG_SV.logmsg(l_module_name,'STOP ID => ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);

1920:
1921:
1922: IF l_debug_on THEN
1923: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP ID => ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1924: WSH_DEBUG_SV.logmsg(l_module_name,'STOP ID => ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1925: WSH_DEBUG_SV.logmsg(l_module_name,'TENDER STATUS => ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1926: END IF;
1927:
1928: IF (l_trip_id IS NULL)

Line 1925: WSH_DEBUG_SV.logmsg(l_module_name,'TENDER STATUS => ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);

1921:
1922: IF l_debug_on THEN
1923: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP ID => ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1924: WSH_DEBUG_SV.logmsg(l_module_name,'STOP ID => ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1925: WSH_DEBUG_SV.logmsg(l_module_name,'TENDER STATUS => ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1926: END IF;
1927:
1928: IF (l_trip_id IS NULL)
1929: THEN

Line 1946: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP NOT TENDERED OR 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',
1947: WSH_DEBUG_SV.C_PROC_LEVEL);
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950:

Line 1947: WSH_DEBUG_SV.C_PROC_LEVEL);

1943: THEN
1944: IF l_debug_on THEN
1945:
1946: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP NOT TENDERED OR ACCEPTED',
1947: WSH_DEBUG_SV.C_PROC_LEVEL);
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950:
1951: RETURN;

Line 1948: WSH_DEBUG_SV.pop(l_module_name);

1944: IF l_debug_on THEN
1945:
1946: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP NOT TENDERED OR ACCEPTED',
1947: WSH_DEBUG_SV.C_PROC_LEVEL);
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950:
1951: RETURN;
1952: END IF;

Line 1973: WSH_DEBUG_SV.logmsg(l_module_name,' Stop at internal location return back (10+ Fix )',WSH_DEBUG_SV.C_PROC_LEVEL);

1969: -- checks so just return back
1970: IF (p_new_segment_stop_rec.PHYSICAL_STOP_ID IS NOT NULL) THEN
1971: IF l_debug_on THEN
1972:
1973: WSH_DEBUG_SV.logmsg(l_module_name,' Stop at internal location return back (10+ Fix )',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: WSH_DEBUG_SV.pop(l_module_name);
1975: END IF;
1976: RETURN;
1977: END IF;

Line 1974: WSH_DEBUG_SV.pop(l_module_name);

1970: IF (p_new_segment_stop_rec.PHYSICAL_STOP_ID IS NOT NULL) THEN
1971: IF l_debug_on THEN
1972:
1973: WSH_DEBUG_SV.logmsg(l_module_name,' Stop at internal location return back (10+ Fix )',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: WSH_DEBUG_SV.pop(l_module_name);
1975: END IF;
1976: RETURN;
1977: END IF;
1978:

Line 2025: WSH_DEBUG_SV.logmsg(l_module_name,'No snapshot of the stop. take the snapshot',WSH_DEBUG_SV.C_PROC_LEVEL);

2021: -- and go back
2022: IF (NOT l_found) THEN
2023: -- take snap shot
2024: IF l_debug_on THEN
2025: WSH_DEBUG_SV.logmsg(l_module_name,'No snapshot of the stop. take the snapshot',WSH_DEBUG_SV.C_PROC_LEVEL);
2026: END IF;
2027:
2028: TAKE_TENDER_SNAPSHOT(
2029: p_init_msg_list => FND_API.G_FALSE,

Line 2061: WSH_DEBUG_SV.pop(l_module_name);

2057: END IF;
2058:
2059:
2060: IF l_debug_on THEN
2061: WSH_DEBUG_SV.pop(l_module_name);
2062: END IF;
2063:
2064: RETURN;
2065: END IF;

Line 2079: WSH_DEBUG_SV.logmsg(l_module_name,'No org id. So no delivery. ' ||

2075: -- send an warning message to shipper
2076: IF (l_org_id IS NULL)
2077: THEN
2078: IF l_debug_on THEN
2079: WSH_DEBUG_SV.logmsg(l_module_name,'No org id. So no delivery. ' ||
2080: 'Cancel the tender notification. Warn Shipper',
2081: WSH_DEBUG_SV.C_PROC_LEVEL);
2082: END IF;
2083:

Line 2081: WSH_DEBUG_SV.C_PROC_LEVEL);

2077: THEN
2078: IF l_debug_on THEN
2079: WSH_DEBUG_SV.logmsg(l_module_name,'No org id. So no delivery. ' ||
2080: 'Cancel the tender notification. Warn Shipper',
2081: WSH_DEBUG_SV.C_PROC_LEVEL);
2082: END IF;
2083:
2084: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP
2085: ( p_api_version_number => 1.0,

Line 2151: WSH_DEBUG_SV.pop(l_module_name);

2147: );
2148:
2149:
2150: IF l_debug_on THEN
2151: WSH_DEBUG_SV.pop(l_module_name);
2152: END IF;
2153: RETURN;
2154:
2155: END IF;

Line 2166: WSH_DEBUG_SV.logmsg(l_module_name,'Weights/volume at stop and snap shot are null. No need to check anything. Just return back',WSH_DEBUG_SV.C_PROC_LEVEL);

2162: AND p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM
2163: AND p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)
2164: THEN
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.logmsg(l_module_name,'Weights/volume at stop and snap shot are null. No need to check anything. Just return back',WSH_DEBUG_SV.C_PROC_LEVEL);
2167: WSH_DEBUG_SV.pop(l_module_name);
2168: END IF;
2169:
2170: RETURN;

Line 2167: WSH_DEBUG_SV.pop(l_module_name);

2163: AND p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)
2164: THEN
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.logmsg(l_module_name,'Weights/volume at stop and snap shot are null. No need to check anything. Just return back',WSH_DEBUG_SV.C_PROC_LEVEL);
2167: WSH_DEBUG_SV.pop(l_module_name);
2168: END IF;
2169:
2170: RETURN;
2171: END IF;

Line 2174: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id to get site info ' || l_org_id,

2170: RETURN;
2171: END IF;
2172:
2173: IF l_debug_on THEN
2174: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id to get site info ' || l_org_id,
2175: WSH_DEBUG_SV.C_PROC_LEVEL);
2176: END IF;
2177:
2178:

Line 2175: WSH_DEBUG_SV.C_PROC_LEVEL);

2171: END IF;
2172:
2173: IF l_debug_on THEN
2174: WSH_DEBUG_SV.logmsg(l_module_name,' Organization Id to get site info ' || l_org_id,
2175: WSH_DEBUG_SV.C_PROC_LEVEL);
2176: END IF;
2177:
2178:
2179: WSH_CREATE_CARRIERS_PKG.Get_Site_Trans_Details(

Line 2196: WSH_DEBUG_SV.pop(l_module_name);

2192: p_data => x_msg_data,
2193: p_encoded => FND_API.G_FALSE
2194: );
2195: IF l_debug_on THEN
2196: WSH_DEBUG_SV.pop(l_module_name);
2197: END IF;
2198: RETURN;
2199: ELSIF (x_return_status = 'U') THEN
2200: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_THRESHOLD_INFO');

Line 2211: WSH_DEBUG_SV.logmsg(l_module_name,'No Threshold value specified for this carrier.',WSH_DEBUG_SV.C_PROC_LEVEL);

2207: AND l_site_trans_rec.VOLUME_THRESHOLD_LOWER = NULL
2208: AND l_site_trans_rec.VOLUME_THRESHOLD_UPPER = NULL)
2209: THEN
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.logmsg(l_module_name,'No Threshold value specified for this carrier.',WSH_DEBUG_SV.C_PROC_LEVEL);
2212: END IF;
2213:
2214: -- do we update the snapshot of this stop and just return back
2215:

Line 2220: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Lower' ||

2216: RETURN;
2217: END IF;
2218:
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Lower' ||
2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||

Line 2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);

2217: END IF;
2218:
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Lower' ||
2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||

2218:
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Lower' ||
2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||

Line 2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);

2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Lower' ||
2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||
2227: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||

2220: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Lower' ||
2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||
2227: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2228: END IF;

Line 2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);

2221: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||
2227: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2228: END IF;
2229:

Line 2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||

2222: WSH_DEBUG_SV.logmsg(l_module_name,' Weight Threshold Upper' ||
2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||
2227: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2228: END IF;
2229:
2230:

Line 2227: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);

2223: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2224: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Lower' ||
2225: l_site_trans_rec.WEIGHT_THRESHOLD_LOWER,WSH_DEBUG_SV.C_PROC_LEVEL);
2226: WSH_DEBUG_SV.logmsg(l_module_name,' Volume Threshold Upper' ||
2227: l_site_trans_rec.WEIGHT_THRESHOLD_UPPER,WSH_DEBUG_SV.C_PROC_LEVEL);
2228: END IF;
2229:
2230:
2231: -- Snap shot found so now check the values

Line 2248: WSH_DEBUG_SV.logmsg(l_module_name,'Stop weight uom is null. Convert stop weight to snap weight',WSH_DEBUG_SV.C_PROC_LEVEL);

2244:
2245: -- Snap stop weight uom is not null
2246: -- convert stop weight and compare
2247: IF l_debug_on THEN
2248: WSH_DEBUG_SV.logmsg(l_module_name,'Stop weight uom is null. Convert stop weight to snap weight',WSH_DEBUG_SV.C_PROC_LEVEL);
2249: END IF;
2250:
2251: l_stop_weight_uom := FND_API.G_MISS_CHAR; --l_snap_weight_uom;
2252:

Line 2283: WSH_DEBUG_SV.logmsg(l_module_name,'Stop volume uom is null. Convert stop volume to snap volume',WSH_DEBUG_SV.C_PROC_LEVEL);

2279: THEN
2280: -- Snap stop volume uom is not null
2281: -- convert stop volume and compare
2282: IF l_debug_on THEN
2283: WSH_DEBUG_SV.logmsg(l_module_name,'Stop volume uom is null. Convert stop volume to snap volume',WSH_DEBUG_SV.C_PROC_LEVEL);
2284: END IF;
2285:
2286: l_stop_volume_uom := FND_API.G_MISS_CHAR; --l_snap_volume_uom;
2287:

Line 2317: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is not G_MISS_NUMM ',WSH_DEBUG_SV.C_PROC_LEVEL);

2313: IF ((p_new_segment_stop_rec.departure_gross_weight <> FND_API.G_MISS_NUM)
2314: AND (l_snap_tot_weight IS NULL))
2315: THEN
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is not G_MISS_NUMM ',WSH_DEBUG_SV.C_PROC_LEVEL);
2318: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total weight is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2319: END IF;
2320:
2321: l_send_update := TRUE;

Line 2318: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total weight is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);

2314: AND (l_snap_tot_weight IS NULL))
2315: THEN
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is not G_MISS_NUMM ',WSH_DEBUG_SV.C_PROC_LEVEL);
2318: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total weight is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2319: END IF;
2320:
2321: l_send_update := TRUE;
2322:

Line 2327: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is G_MISS_NUM',WSH_DEBUG_SV.C_PROC_LEVEL);

2323: ELSIF ((p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM)
2324: AND (l_snap_tot_weight IS NOT NULL))
2325: THEN
2326: IF l_debug_on THEN
2327: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is G_MISS_NUM',WSH_DEBUG_SV.C_PROC_LEVEL);
2328: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total weight is not null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2329: END IF;
2330: l_send_update := TRUE;
2331:

Line 2328: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total weight is not null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);

2324: AND (l_snap_tot_weight IS NOT NULL))
2325: THEN
2326: IF l_debug_on THEN
2327: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is G_MISS_NUM',WSH_DEBUG_SV.C_PROC_LEVEL);
2328: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total weight is not null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2329: END IF;
2330: l_send_update := TRUE;
2331:
2332: END IF;

Line 2339: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is not G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);

2335: IF ((p_new_segment_stop_rec.departure_volume <> FND_API.G_MISS_NUM)
2336: AND (l_snap_tot_volume IS NULL))
2337: THEN
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is not G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);
2340: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2341: END IF;
2342: l_send_update := TRUE;
2343:

Line 2340: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);

2336: AND (l_snap_tot_volume IS NULL))
2337: THEN
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is not G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);
2340: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2341: END IF;
2342: l_send_update := TRUE;
2343:
2344: ELSIF ((p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)

Line 2348: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);

2344: ELSIF ((p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)
2345: AND (l_snap_tot_volume IS NOT NULL))
2346: THEN
2347: IF l_debug_on THEN
2348: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);
2349: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is not null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2350: END IF;
2351: l_send_update := TRUE;
2352: END IF;

Line 2349: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is not null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);

2345: AND (l_snap_tot_volume IS NOT NULL))
2346: THEN
2347: IF l_debug_on THEN
2348: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);
2349: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is not null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2350: END IF;
2351: l_send_update := TRUE;
2352: END IF;
2353:

Line 2365: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of WEIGHT_THRESHOLD_LOWER ',WSH_DEBUG_SV.C_PROC_LEVEL);

2361: IF ( (ABS(l_snap_tot_weight - (l_snap_tot_weight*l_site_trans_rec.WEIGHT_THRESHOLD_LOWER*0.01)))
2362: > p_new_segment_stop_rec.departure_gross_weight)
2363: THEN
2364: IF l_debug_on THEN
2365: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of WEIGHT_THRESHOLD_LOWER ',WSH_DEBUG_SV.C_PROC_LEVEL);
2366: END IF;
2367: l_send_update := TRUE;
2368:
2369: END IF;

Line 2379: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of WEIGHT_THRESHOLD_UPPER ',WSH_DEBUG_SV.C_PROC_LEVEL);

2375: IF ( (ABS(l_snap_tot_weight + (l_snap_tot_weight*l_site_trans_rec.WEIGHT_THRESHOLD_UPPER*0.01)))
2376: < p_new_segment_stop_rec.departure_gross_weight)
2377: THEN
2378: IF l_debug_on THEN
2379: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of WEIGHT_THRESHOLD_UPPER ',WSH_DEBUG_SV.C_PROC_LEVEL);
2380: END IF;
2381: l_send_update := TRUE;
2382: END IF;
2383: END IF;

Line 2399: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of VOLUME_THRESHOLD_LOWER ',WSH_DEBUG_SV.C_PROC_LEVEL);

2395: IF ( (ABS(l_snap_tot_volume - (l_snap_tot_volume*l_site_trans_rec.VOLUME_THRESHOLD_LOWER*0.01)))
2396: > p_new_segment_stop_rec.departure_volume)
2397: THEN
2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of VOLUME_THRESHOLD_LOWER ',WSH_DEBUG_SV.C_PROC_LEVEL);
2400: END IF;
2401:
2402: l_send_update := TRUE;
2403: END IF;

Line 2413: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of VOLUME_THRESHOLD_UPPER ',WSH_DEBUG_SV.C_PROC_LEVEL);

2409: IF ( (ABS(l_snap_tot_volume + (l_snap_tot_volume*l_site_trans_rec.VOLUME_THRESHOLD_UPPER*0.01)))
2410: < p_new_segment_stop_rec.departure_volume)
2411: THEN
2412: IF l_debug_on THEN
2413: WSH_DEBUG_SV.logmsg(l_module_name,' Send Message Because of VOLUME_THRESHOLD_UPPER ',WSH_DEBUG_SV.C_PROC_LEVEL);
2414: END IF;
2415:
2416: l_send_update := TRUE;
2417: END IF;

Line 2425: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Number ' || l_tender_number,WSH_DEBUG_SV.C_PROC_LEVEL);

2421: END IF;
2422:
2423: -- update the snapshot with current information
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Number ' || l_tender_number,WSH_DEBUG_SV.C_PROC_LEVEL);
2426: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2427: WSH_DEBUG_SV.logmsg(l_module_name,' Trip stop id ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2428:
2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2426: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2422:
2423: -- update the snapshot with current information
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Number ' || l_tender_number,WSH_DEBUG_SV.C_PROC_LEVEL);
2426: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2427: WSH_DEBUG_SV.logmsg(l_module_name,' Trip stop id ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2428:
2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);
2430:

Line 2427: WSH_DEBUG_SV.logmsg(l_module_name,' Trip stop id ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2423: -- update the snapshot with current information
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Number ' || l_tender_number,WSH_DEBUG_SV.C_PROC_LEVEL);
2426: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2427: WSH_DEBUG_SV.logmsg(l_module_name,' Trip stop id ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2428:
2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);
2430:
2431: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight ' || p_new_segment_stop_rec.departure_gross_weight,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);

2425: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Number ' || l_tender_number,WSH_DEBUG_SV.C_PROC_LEVEL);
2426: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2427: WSH_DEBUG_SV.logmsg(l_module_name,' Trip stop id ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2428:
2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);
2430:
2431: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight ' || p_new_segment_stop_rec.departure_gross_weight,WSH_DEBUG_SV.C_PROC_LEVEL);
2432:
2433: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight Uom ' || l_stop_weight_uom,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2431: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight ' || p_new_segment_stop_rec.departure_gross_weight,WSH_DEBUG_SV.C_PROC_LEVEL);

2427: WSH_DEBUG_SV.logmsg(l_module_name,' Trip stop id ' || l_stop_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2428:
2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);
2430:
2431: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight ' || p_new_segment_stop_rec.departure_gross_weight,WSH_DEBUG_SV.C_PROC_LEVEL);
2432:
2433: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight Uom ' || l_stop_weight_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2434:
2435: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume ' || p_new_segment_stop_rec.departure_volume,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2433: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight Uom ' || l_stop_weight_uom,WSH_DEBUG_SV.C_PROC_LEVEL);

2429: WSH_DEBUG_SV.logmsg(l_module_name,'Update Snapshot with stop info ',WSH_DEBUG_SV.C_PROC_LEVEL);
2430:
2431: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight ' || p_new_segment_stop_rec.departure_gross_weight,WSH_DEBUG_SV.C_PROC_LEVEL);
2432:
2433: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight Uom ' || l_stop_weight_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2434:
2435: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume ' || p_new_segment_stop_rec.departure_volume,WSH_DEBUG_SV.C_PROC_LEVEL);
2436:
2437: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume code ' || l_stop_volume_uom,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2435: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume ' || p_new_segment_stop_rec.departure_volume,WSH_DEBUG_SV.C_PROC_LEVEL);

2431: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight ' || p_new_segment_stop_rec.departure_gross_weight,WSH_DEBUG_SV.C_PROC_LEVEL);
2432:
2433: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight Uom ' || l_stop_weight_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2434:
2435: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume ' || p_new_segment_stop_rec.departure_volume,WSH_DEBUG_SV.C_PROC_LEVEL);
2436:
2437: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume code ' || l_stop_volume_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2438:
2439: WSH_DEBUG_SV.logmsg(l_module_name,'Carrier Contact Id ' || l_carrier_contact_id,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2437: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume code ' || l_stop_volume_uom,WSH_DEBUG_SV.C_PROC_LEVEL);

2433: WSH_DEBUG_SV.logmsg(l_module_name,'New Weight Uom ' || l_stop_weight_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2434:
2435: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume ' || p_new_segment_stop_rec.departure_volume,WSH_DEBUG_SV.C_PROC_LEVEL);
2436:
2437: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume code ' || l_stop_volume_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2438:
2439: WSH_DEBUG_SV.logmsg(l_module_name,'Carrier Contact Id ' || l_carrier_contact_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2440:
2441: END IF;

Line 2439: WSH_DEBUG_SV.logmsg(l_module_name,'Carrier Contact Id ' || l_carrier_contact_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2435: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume ' || p_new_segment_stop_rec.departure_volume,WSH_DEBUG_SV.C_PROC_LEVEL);
2436:
2437: WSH_DEBUG_SV.logmsg(l_module_name,'New Volume code ' || l_stop_volume_uom,WSH_DEBUG_SV.C_PROC_LEVEL);
2438:
2439: WSH_DEBUG_SV.logmsg(l_module_name,'Carrier Contact Id ' || l_carrier_contact_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2440:
2441: END IF;
2442:
2443: TAKE_TENDER_SNAPSHOT(

Line 2469: WSH_DEBUG_SV.pop(l_module_name);

2465: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2466: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2467: THEN
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.pop(l_module_name);
2470: END IF;
2471: RETURN;
2472: END IF;
2473:

Line 2480: WSH_DEBUG_SV.logmsg(l_module_name,' New Session value' || l_session_value ,WSH_DEBUG_SV.C_PROC_LEVEL);

2476: l_is_session_found := FALSE;
2477:
2478: l_session_value := userenv('SESSIONID');
2479: IF l_debug_on THEN
2480: WSH_DEBUG_SV.logmsg(l_module_name,' New Session value' || l_session_value ,WSH_DEBUG_SV.C_PROC_LEVEL);
2481: END IF;
2482:
2483: FOR get_snapshot_session_rec IN
2484: get_snapshot_session_cur(l_trip_id,l_tender_number,

Line 2522: WSH_DEBUG_SV.pop(l_module_name);

2518: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2519: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2520: THEN
2521: IF l_debug_on THEN
2522: WSH_DEBUG_SV.pop(l_module_name);
2523: END IF;
2524: RETURN;
2525: END IF;
2526:

Line 2528: WSH_DEBUG_SV.logmsg(l_module_name,'Send Notification ',WSH_DEBUG_SV.C_PROC_LEVEL);

2524: RETURN;
2525: END IF;
2526:
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'Send Notification ',WSH_DEBUG_SV.C_PROC_LEVEL);
2529: WSH_DEBUG_SV.logmsg(l_module_name,' l_trip_id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2530: END IF;
2531:
2532: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP

Line 2529: WSH_DEBUG_SV.logmsg(l_module_name,' l_trip_id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

2525: END IF;
2526:
2527: IF l_debug_on THEN
2528: WSH_DEBUG_SV.logmsg(l_module_name,'Send Notification ',WSH_DEBUG_SV.C_PROC_LEVEL);
2529: WSH_DEBUG_SV.logmsg(l_module_name,' l_trip_id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2530: END IF;
2531:
2532: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP
2533: ( p_api_version_number => 1.0,

Line 2552: WSH_DEBUG_SV.logmsg(l_module_name,' x_return_status after

2548: p_msg_data =>l_msg_data);
2549:
2550:
2551: IF l_debug_on THEN
2552: WSH_DEBUG_SV.logmsg(l_module_name,' x_return_status after
2553: CREATE_UPDATE_TRIP ' || x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2554: WSH_DEBUG_SV.logmsg(l_module_name,' x_msg_data
2555: CREATE_UPDATE_TRIP ' || x_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
2556:

Line 2553: CREATE_UPDATE_TRIP ' || x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

2549:
2550:
2551: IF l_debug_on THEN
2552: WSH_DEBUG_SV.logmsg(l_module_name,' x_return_status after
2553: CREATE_UPDATE_TRIP ' || x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2554: WSH_DEBUG_SV.logmsg(l_module_name,' x_msg_data
2555: CREATE_UPDATE_TRIP ' || x_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
2556:
2557: END IF;

Line 2554: WSH_DEBUG_SV.logmsg(l_module_name,' x_msg_data

2550:
2551: IF l_debug_on THEN
2552: WSH_DEBUG_SV.logmsg(l_module_name,' x_return_status after
2553: CREATE_UPDATE_TRIP ' || x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2554: WSH_DEBUG_SV.logmsg(l_module_name,' x_msg_data
2555: CREATE_UPDATE_TRIP ' || x_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
2556:
2557: END IF;
2558:

Line 2555: CREATE_UPDATE_TRIP ' || x_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);

2551: IF l_debug_on THEN
2552: WSH_DEBUG_SV.logmsg(l_module_name,' x_return_status after
2553: CREATE_UPDATE_TRIP ' || x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2554: WSH_DEBUG_SV.logmsg(l_module_name,' x_msg_data
2555: CREATE_UPDATE_TRIP ' || x_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
2556:
2557: END IF;
2558:
2559: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

Line 2563: WSH_DEBUG_SV.pop(l_module_name);

2559: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2560: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2561: THEN
2562: IF l_debug_on THEN
2563: WSH_DEBUG_SV.pop(l_module_name);
2564: END IF;
2565: RETURN;
2566: END IF;
2567:

Line 2571: WSH_DEBUG_SV.logmsg(l_module_name,'Carrier is notified ',WSH_DEBUG_SV.C_PROC_LEVEL);

2567:
2568:
2569: ELSE
2570: IF l_debug_on THEN
2571: WSH_DEBUG_SV.logmsg(l_module_name,'Carrier is notified ',WSH_DEBUG_SV.C_PROC_LEVEL);
2572: END IF;
2573:
2574: END IF;
2575:

Line 2590: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);

2586: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2587: END IF;
2588:
2589: IF l_debug_on THEN
2590: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2591: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2592: END IF;
2593:
2594:

Line 2591: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);

2587: END IF;
2588:
2589: IF l_debug_on THEN
2590: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2591: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2592: END IF;
2593:
2594:
2595: IF l_debug_on THEN

Line 2596: WSH_DEBUG_SV.pop(l_module_name);

2592: END IF;
2593:
2594:
2595: IF l_debug_on THEN
2596: WSH_DEBUG_SV.pop(l_module_name);
2597: END IF;
2598:
2599: -- Standard call to get message count and if count is 1,get message info.
2600: --

Line 2623: WSH_DEBUG_SV.pop(l_module_name);

2619: p_data => x_msg_data,
2620: p_encoded => FND_API.G_FALSE
2621: );
2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.pop(l_module_name);
2624: END IF;
2625:
2626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2627: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;

Line 2636: WSH_DEBUG_SV.pop(l_module_name);

2632: p_data => x_msg_data,
2633: p_encoded => FND_API.G_FALSE
2634: );
2635: IF l_debug_on THEN
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');

Line 2649: WSH_DEBUG_SV.pop(l_module_name);

2645: p_data => x_msg_data,
2646: p_encoded => FND_API.G_FALSE
2647: );
2648: IF l_debug_on THEN
2649: WSH_DEBUG_SV.pop(l_module_name);
2650: END IF;
2651: --}
2652:
2653: END CHECK_THRESHOLD_FOR_STOP;

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

2717: x_hz_party_display_name VARCHAR2(100);
2718:
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)

Line 2750: WSH_DEBUG_SV.logmsg(l_module_name,

2746: x_msg_count := 0;
2747: x_msg_data := 0;
2748:
2749: IF l_debug_on THEN
2750: WSH_DEBUG_SV.logmsg(l_module_name,
2751: ' Get HZ_PARTY Role Name ',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.logmsg(l_module_name,
2753: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2754: END IF;

Line 2751: ' Get HZ_PARTY Role Name ',WSH_DEBUG_SV.C_PROC_LEVEL);

2747: x_msg_data := 0;
2748:
2749: IF l_debug_on THEN
2750: WSH_DEBUG_SV.logmsg(l_module_name,
2751: ' Get HZ_PARTY Role Name ',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.logmsg(l_module_name,
2753: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2754: END IF;
2755:

Line 2752: WSH_DEBUG_SV.logmsg(l_module_name,

2748:
2749: IF l_debug_on THEN
2750: WSH_DEBUG_SV.logmsg(l_module_name,
2751: ' Get HZ_PARTY Role Name ',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.logmsg(l_module_name,
2753: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2754: END IF;
2755:
2756: WF_DIRECTORY.GETROLEINFO (

Line 2753: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);

2749: IF l_debug_on THEN
2750: WSH_DEBUG_SV.logmsg(l_module_name,
2751: ' Get HZ_PARTY Role Name ',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.logmsg(l_module_name,
2753: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2754: END IF;
2755:
2756: WF_DIRECTORY.GETROLEINFO (
2757: role => p_contact_name,

Line 2765: WSH_DEBUG_SV.logmsg(l_module_name,

2761: language => l_lang,
2762: territory => l_ter);
2763:
2764: IF l_debug_on THEN
2765: WSH_DEBUG_SV.logmsg(l_module_name,
2766: ' HZ_PARTY Role Name ' || hz_party_display_name,
2767: WSH_DEBUG_SV.C_PROC_LEVEL);
2768: END IF;
2769:

Line 2767: WSH_DEBUG_SV.C_PROC_LEVEL);

2763:
2764: IF l_debug_on THEN
2765: WSH_DEBUG_SV.logmsg(l_module_name,
2766: ' HZ_PARTY Role Name ' || hz_party_display_name,
2767: WSH_DEBUG_SV.C_PROC_LEVEL);
2768: END IF;
2769:
2770:
2771: l_contact_id := to_number(substr(p_contact_name,instr(p_contact_name,':')+1));

Line 2776: WSH_DEBUG_SV.logmsg(l_module_name,

2772: l_role_name := 'FTE_TENDER_' || l_contact_id;
2773: x_role_name := l_role_name;
2774:
2775: IF l_debug_on THEN
2776: WSH_DEBUG_SV.logmsg(l_module_name,
2777: ' Role Name ' || l_role_name,WSH_DEBUG_SV.C_PROC_LEVEL);
2778: WSH_DEBUG_SV.logmsg(l_module_name,
2779: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;

Line 2777: ' Role Name ' || l_role_name,WSH_DEBUG_SV.C_PROC_LEVEL);

2773: x_role_name := l_role_name;
2774:
2775: IF l_debug_on THEN
2776: WSH_DEBUG_SV.logmsg(l_module_name,
2777: ' Role Name ' || l_role_name,WSH_DEBUG_SV.C_PROC_LEVEL);
2778: WSH_DEBUG_SV.logmsg(l_module_name,
2779: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;
2781:

Line 2778: WSH_DEBUG_SV.logmsg(l_module_name,

2774:
2775: IF l_debug_on THEN
2776: WSH_DEBUG_SV.logmsg(l_module_name,
2777: ' Role Name ' || l_role_name,WSH_DEBUG_SV.C_PROC_LEVEL);
2778: WSH_DEBUG_SV.logmsg(l_module_name,
2779: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;
2781:
2782:

Line 2779: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);

2775: IF l_debug_on THEN
2776: WSH_DEBUG_SV.logmsg(l_module_name,
2777: ' Role Name ' || l_role_name,WSH_DEBUG_SV.C_PROC_LEVEL);
2778: WSH_DEBUG_SV.logmsg(l_module_name,
2779: ' Calling WF_DIRECTORY.GETROLEINFO ',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;
2781:
2782:
2783: WF_DIRECTORY.GETROLEINFO (

Line 2794: WSH_DEBUG_SV.logmsg(l_module_name,

2790: language => l_lang,
2791: territory => l_ter);
2792:
2793: IF l_debug_on THEN
2794: WSH_DEBUG_SV.logmsg(l_module_name,
2795: ' Role Display Name ' || l_display_name,WSH_DEBUG_SV.C_PROC_LEVEL);
2796: END IF;
2797:
2798:

Line 2795: ' Role Display Name ' || l_display_name,WSH_DEBUG_SV.C_PROC_LEVEL);

2791: territory => l_ter);
2792:
2793: IF l_debug_on THEN
2794: WSH_DEBUG_SV.logmsg(l_module_name,
2795: ' Role Display Name ' || l_display_name,WSH_DEBUG_SV.C_PROC_LEVEL);
2796: END IF;
2797:
2798:
2799: -- get all users associated with this party

Line 2813: WSH_DEBUG_SV.logmsg(l_module_name,

2809: LOOP
2810: --{
2811: l_user_list.EXTEND;
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,
2814: ' Adding user name to list ' || user_party_rec.user_name,
2815: WSH_DEBUG_SV.C_PROC_LEVEL);
2816: END IF;
2817: l_user_list(idx) := user_party_rec.user_name;

Line 2815: WSH_DEBUG_SV.C_PROC_LEVEL);

2811: l_user_list.EXTEND;
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,
2814: ' Adding user name to list ' || user_party_rec.user_name,
2815: WSH_DEBUG_SV.C_PROC_LEVEL);
2816: END IF;
2817: l_user_list(idx) := user_party_rec.user_name;
2818: l_user_name := l_user_name || user_party_rec.user_name || ',';
2819: idx := idx+1;

Line 2826: WSH_DEBUG_SV.logmsg(l_module_name,

2822:
2823:
2824: l_user_name := substr(l_user_name,1,length(l_user_name)-1);
2825: IF l_debug_on THEN
2826: WSH_DEBUG_SV.logmsg(l_module_name,
2827: ' User List ' || l_user_name,
2828: WSH_DEBUG_SV.C_PROC_LEVEL);
2829: END IF;
2830:

Line 2828: WSH_DEBUG_SV.C_PROC_LEVEL);

2824: l_user_name := substr(l_user_name,1,length(l_user_name)-1);
2825: IF l_debug_on THEN
2826: WSH_DEBUG_SV.logmsg(l_module_name,
2827: ' User List ' || l_user_name,
2828: WSH_DEBUG_SV.C_PROC_LEVEL);
2829: END IF;
2830:
2831: IF (l_display_name IS NULL)
2832: THEN

Line 2835: WSH_DEBUG_SV.logmsg(l_module_name,

2831: IF (l_display_name IS NULL)
2832: THEN
2833:
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,
2836: ' Role Does not exists Role name is ' || hz_party_display_name,
2837: WSH_DEBUG_SV.C_PROC_LEVEL);
2838: END IF;
2839: WF_DIRECTORY.CreateAdHocRole(

Line 2837: WSH_DEBUG_SV.C_PROC_LEVEL);

2833:
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,
2836: ' Role Does not exists Role name is ' || hz_party_display_name,
2837: WSH_DEBUG_SV.C_PROC_LEVEL);
2838: END IF;
2839: WF_DIRECTORY.CreateAdHocRole(
2840: role_name => l_role_name,
2841: role_display_name => hz_party_display_name,

Line 2847: WSH_DEBUG_SV.logmsg(l_module_name,

2843: email_address => l_email_address,
2844: expiration_date => null);
2845: ELSE
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,
2848: ' Role Exists So add users ',
2849: WSH_DEBUG_SV.C_PROC_LEVEL);
2850: END IF;
2851:

Line 2849: WSH_DEBUG_SV.C_PROC_LEVEL);

2845: ELSE
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,
2848: ' Role Exists So add users ',
2849: WSH_DEBUG_SV.C_PROC_LEVEL);
2850: END IF;
2851:
2852: IF l_user_list.count > 0
2853: THEN

Line 2860: WSH_DEBUG_SV.logmsg(l_module_name,

2856: WHILE idx IS NOT NULL
2857: LOOP
2858: l_user_name := l_user_list(idx);
2859: IF l_debug_on THEN
2860: WSH_DEBUG_SV.logmsg(l_module_name,
2861: ' Cheking User ' || l_user_name,
2862: WSH_DEBUG_SV.C_PROC_LEVEL);
2863: END IF;
2864: l_user_exists := WF_DIRECTORY.IsPerformer(

Line 2862: WSH_DEBUG_SV.C_PROC_LEVEL);

2858: l_user_name := l_user_list(idx);
2859: IF l_debug_on THEN
2860: WSH_DEBUG_SV.logmsg(l_module_name,
2861: ' Cheking User ' || l_user_name,
2862: WSH_DEBUG_SV.C_PROC_LEVEL);
2863: END IF;
2864: l_user_exists := WF_DIRECTORY.IsPerformer(
2865: l_user_name, l_role_name);
2866: if (l_user_exists) THEN

Line 2868: WSH_DEBUG_SV.logmsg(l_module_name,

2864: l_user_exists := WF_DIRECTORY.IsPerformer(
2865: l_user_name, l_role_name);
2866: if (l_user_exists) THEN
2867: IF l_debug_on THEN
2868: WSH_DEBUG_SV.logmsg(l_module_name,
2869: ' User Exists do not create ',
2870: WSH_DEBUG_SV.C_PROC_LEVEL);
2871: END IF;
2872: ELSE

Line 2870: WSH_DEBUG_SV.C_PROC_LEVEL);

2866: if (l_user_exists) THEN
2867: IF l_debug_on THEN
2868: WSH_DEBUG_SV.logmsg(l_module_name,
2869: ' User Exists do not create ',
2870: WSH_DEBUG_SV.C_PROC_LEVEL);
2871: END IF;
2872: ELSE
2873:
2874: IF l_debug_on THEN

Line 2875: WSH_DEBUG_SV.logmsg(l_module_name,

2871: END IF;
2872: ELSE
2873:
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.logmsg(l_module_name,
2876: ' User does not Exists create ',
2877: WSH_DEBUG_SV.C_PROC_LEVEL);
2878: END IF;
2879: WF_DIRECTORY.AddUsersToAdHocRole(

Line 2877: WSH_DEBUG_SV.C_PROC_LEVEL);

2873:
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.logmsg(l_module_name,
2876: ' User does not Exists create ',
2877: WSH_DEBUG_SV.C_PROC_LEVEL);
2878: END IF;
2879: WF_DIRECTORY.AddUsersToAdHocRole(
2880: role_name => l_role_name,
2881: role_users => l_user_name);

Line 2910: WSH_DEBUG_SV.logmsg(l_module_name,

2906: display_name => x_hz_party_display_name);
2907: END IF;
2908:
2909: IF l_debug_on THEN
2910: WSH_DEBUG_SV.logmsg(l_module_name,
2911: ' Display Name of '||l_role_name||' has been updated',
2912: WSH_DEBUG_SV.C_PROC_LEVEL);
2913: END IF;
2914: -----------------------------------------------------------------------------------

Line 2912: WSH_DEBUG_SV.C_PROC_LEVEL);

2908:
2909: IF l_debug_on THEN
2910: WSH_DEBUG_SV.logmsg(l_module_name,
2911: ' Display Name of '||l_role_name||' has been updated',
2912: WSH_DEBUG_SV.C_PROC_LEVEL);
2913: END IF;
2914: -----------------------------------------------------------------------------------
2915: */
2916:

Line 2941: WSH_DEBUG_SV.pop(l_module_name);

2937: p_data => x_msg_data,
2938: p_encoded => FND_API.G_FALSE
2939: );
2940: IF l_debug_on THEN
2941: WSH_DEBUG_SV.pop(l_module_name);
2942: END IF;
2943:
2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2945: ROLLBACK TO HANDLE_WF_ROLES_PUB;

Line 2954: WSH_DEBUG_SV.pop(l_module_name);

2950: p_data => x_msg_data,
2951: p_encoded => FND_API.G_FALSE
2952: );
2953: IF l_debug_on THEN
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');

Line 2967: WSH_DEBUG_SV.pop(l_module_name);

2963: p_data => x_msg_data,
2964: p_encoded => FND_API.G_FALSE
2965: );
2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.pop(l_module_name);
2968: END IF;
2969: --}
2970:
2971: END HANDLE_WF_ROLES;

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

3247: l_ddummy_exception_id NUMBER;
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

Line 3260: WSH_DEBUG_SV.push(l_module_name);

3256:
3257: SAVEPOINT LOG_CARRIER_ARR_EXC_PUB;
3258: l_arrival_time := fnd_profile.value('FTE_CARRIER_ARR_WINDOW');
3259: IF l_debug_on THEN
3260: WSH_DEBUG_SV.push(l_module_name);
3261: END IF;
3262:
3263: if (p_carrier_est_departure_date is not null ) then
3264: if ( (ABS(p_planned_departure_date - p_carrier_est_departure_date)* 24) > l_arrival_time) then

Line 3333: WSH_DEBUG_SV.logmsg(l_module_name,' Inside 4 '||l_dreturn_status,

3329: p_trip_id => p_tender_id
3330: );
3331:
3332: IF l_debug_on THEN
3333: WSH_DEBUG_SV.logmsg(l_module_name,' Inside 4 '||l_dreturn_status,
3334: WSH_DEBUG_SV.C_PROC_LEVEL);
3335: END IF ;
3336: --handling Errors
3337: FND_MSG_PUB.Count_And_Get

Line 3334: WSH_DEBUG_SV.C_PROC_LEVEL);

3330: );
3331:
3332: IF l_debug_on THEN
3333: WSH_DEBUG_SV.logmsg(l_module_name,' Inside 4 '||l_dreturn_status,
3334: WSH_DEBUG_SV.C_PROC_LEVEL);
3335: END IF ;
3336: --handling Errors
3337: FND_MSG_PUB.Count_And_Get
3338: (

Line 3363: WSH_DEBUG_SV.pop(l_module_name);

3359: END IF ;
3360:
3361:
3362: IF l_debug_on THEN
3363: WSH_DEBUG_SV.pop(l_module_name);
3364: END IF;
3365:
3366:
3367: EXCEPTION

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

3417: l_planned_departure_date date;
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;

Line 3460: WSH_DEBUG_SV.push(l_module_name);

3456: l_carrier_est_arrival_date,l_last_stop_location_id;
3457: CLOSE c_last_stop_of_trip;
3458:
3459: IF l_debug_on THEN
3460: WSH_DEBUG_SV.push(l_module_name);
3461: END IF;
3462:
3463: LOG_CARRIER_ARR_EXC(
3464: p_tender_id =>p_tender_id,

Line 3479: WSH_DEBUG_SV.pop(l_module_name);

3475: );
3476:
3477:
3478: IF l_debug_on THEN
3479: WSH_DEBUG_SV.pop(l_module_name);
3480: END IF;
3481:
3482:
3483: EXCEPTION

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

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

Line 3558: WSH_DEBUG_SV.push(l_module_name);

3554:
3555: SAVEPOINT COMPLETE_CANCEL_TENDER_PUB;
3556:
3557: IF l_debug_on THEN
3558: WSH_DEBUG_SV.push(l_module_name);
3559: END IF;
3560:
3561: UPDATE wsh_trip_stops
3562: SET CARRIER_EST_DEPARTURE_DATE = null

Line 3640: WSH_DEBUG_SV.pop(l_module_name);

3636: END IF;
3637:
3638:
3639: IF l_debug_on THEN
3640: WSH_DEBUG_SV.pop(l_module_name);
3641: END IF;
3642:
3643:
3644: EXCEPTION

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

3697: l_parameter_list wf_parameter_list_t;
3698:
3699: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_TENDER_EVENT';
3700: l_api_version CONSTANT NUMBER := 1.0;
3701: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3702: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3703:
3704:
3705: l_return_status VARCHAR2(32767);

Line 3721: WSH_DEBUG_SV.push(l_module_name);

3717:
3718:
3719: SAVEPOINT RAISE_TENDER_EVENT_PUB;
3720: IF l_debug_on THEN
3721: WSH_DEBUG_SV.push(l_module_name);
3722: END IF;
3723:
3724: IF FND_API.to_Boolean( p_init_msg_list )
3725: THEN

Line 3779: WSH_DEBUG_SV.logmsg(l_module_name,' TRIP Id ' || p_trip_info.trip_id,

3775: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3776: END IF;
3777:
3778: IF l_debug_on THEN
3779: WSH_DEBUG_SV.logmsg(l_module_name,' TRIP Id ' || p_trip_info.trip_id,
3780: WSH_DEBUG_SV.C_PROC_LEVEL);
3781: END IF;
3782:
3783:

Line 3780: WSH_DEBUG_SV.C_PROC_LEVEL);

3776: END IF;
3777:
3778: IF l_debug_on THEN
3779: WSH_DEBUG_SV.logmsg(l_module_name,' TRIP Id ' || p_trip_info.trip_id,
3780: WSH_DEBUG_SV.C_PROC_LEVEL);
3781: END IF;
3782:
3783:
3784:

Line 3832: WSH_DEBUG_SV.logmsg(l_module_name,' Before raising oracle.apps.fte.lt.tenderrequest ',

3828:
3829:
3830:
3831: IF l_debug_on THEN
3832: WSH_DEBUG_SV.logmsg(l_module_name,' Before raising oracle.apps.fte.lt.tenderrequest ',
3833: WSH_DEBUG_SV.C_PROC_LEVEL);
3834: WSH_DEBUG_SV.logmsg(l_module_name,' Event Key ' || p_trip_info.wf_item_key,
3835: WSH_DEBUG_SV.C_PROC_LEVEL);
3836: END IF;

Line 3833: WSH_DEBUG_SV.C_PROC_LEVEL);

3829:
3830:
3831: IF l_debug_on THEN
3832: WSH_DEBUG_SV.logmsg(l_module_name,' Before raising oracle.apps.fte.lt.tenderrequest ',
3833: WSH_DEBUG_SV.C_PROC_LEVEL);
3834: WSH_DEBUG_SV.logmsg(l_module_name,' Event Key ' || p_trip_info.wf_item_key,
3835: WSH_DEBUG_SV.C_PROC_LEVEL);
3836: END IF;
3837:

Line 3834: WSH_DEBUG_SV.logmsg(l_module_name,' Event Key ' || p_trip_info.wf_item_key,

3830:
3831: IF l_debug_on THEN
3832: WSH_DEBUG_SV.logmsg(l_module_name,' Before raising oracle.apps.fte.lt.tenderrequest ',
3833: WSH_DEBUG_SV.C_PROC_LEVEL);
3834: WSH_DEBUG_SV.logmsg(l_module_name,' Event Key ' || p_trip_info.wf_item_key,
3835: WSH_DEBUG_SV.C_PROC_LEVEL);
3836: END IF;
3837:
3838:

Line 3835: WSH_DEBUG_SV.C_PROC_LEVEL);

3831: IF l_debug_on THEN
3832: WSH_DEBUG_SV.logmsg(l_module_name,' Before raising oracle.apps.fte.lt.tenderrequest ',
3833: WSH_DEBUG_SV.C_PROC_LEVEL);
3834: WSH_DEBUG_SV.logmsg(l_module_name,' Event Key ' || p_trip_info.wf_item_key,
3835: WSH_DEBUG_SV.C_PROC_LEVEL);
3836: END IF;
3837:
3838:
3839: wf_event.raise(

Line 3863: WSH_DEBUG_SV.pop(l_module_name);

3859: --
3860: --
3861:
3862: IF l_debug_on THEN
3863: WSH_DEBUG_SV.pop(l_module_name);
3864: END IF;
3865:
3866: --}
3867: EXCEPTION

Line 3879: WSH_DEBUG_SV.pop(l_module_name);

3875: p_data => x_msg_data,
3876: p_encoded => FND_API.G_FALSE
3877: );
3878: IF l_debug_on THEN
3879: WSH_DEBUG_SV.pop(l_module_name);
3880: END IF;
3881:
3882:
3883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3893: WSH_DEBUG_SV.pop(l_module_name);

3889: p_data => x_msg_data,
3890: p_encoded => FND_API.G_FALSE
3891: );
3892: IF l_debug_on THEN
3893: WSH_DEBUG_SV.pop(l_module_name);
3894: END IF;
3895:
3896:
3897: WHEN OTHERS THEN

Line 3908: WSH_DEBUG_SV.pop(l_module_name);

3904: p_data => x_msg_data,
3905: p_encoded => FND_API.G_FALSE
3906: );
3907: IF l_debug_on THEN
3908: WSH_DEBUG_SV.pop(l_module_name);
3909: END IF;
3910:
3911:
3912: --}

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

3954: x_msg_data OUT NOCOPY VARCHAR2) IS
3955:
3956: l_api_name VARCHAR2(30) := 'UPDATE_CARRIER_RESPONSE';
3957: l_api_version CONSTANT NUMBER := 1.0;
3958: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3959: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CARRIER_RESPONSE';
3960:
3961: l_trip_id NUMBER;
3962: l_trip_name VARCHAR2(30000);

Line 3992: wsh_debug_sv.push(l_module_name);

3988: FND_MSG_PUB.initialize;
3989: END IF;
3990: --
3991: IF l_debug_on THEN
3992: wsh_debug_sv.push(l_module_name);
3993: END IF;
3994:
3995: --
3996: -- Initialize API return status to success

Line 4036: WSH_DEBUG_SV.logmsg(l_module_name,' Abt to call CHECK CARRIER ARRIVAL TIME PROCEDURE ',

4032:
4033: --Added for Rel 12 Shravisa
4034: -- Check carrier arrival time.
4035: IF l_debug_on THEN
4036: WSH_DEBUG_SV.logmsg(l_module_name,' Abt to call CHECK CARRIER ARRIVAL TIME PROCEDURE ',
4037: WSH_DEBUG_SV.C_PROC_LEVEL);
4038: END IF ;
4039:
4040:

Line 4037: WSH_DEBUG_SV.C_PROC_LEVEL);

4033: --Added for Rel 12 Shravisa
4034: -- Check carrier arrival time.
4035: IF l_debug_on THEN
4036: WSH_DEBUG_SV.logmsg(l_module_name,' Abt to call CHECK CARRIER ARRIVAL TIME PROCEDURE ',
4037: WSH_DEBUG_SV.C_PROC_LEVEL);
4038: END IF ;
4039:
4040:
4041: CHECK_CARRIER_ARRIVAL_TIME(

Line 4049: WSH_DEBUG_SV.logmsg(l_module_name,' Exited out of CHECK CARRIER ARRIVAL TIME PROCEDURE '||x_return_status ,

4045: x_msg_data => x_msg_data
4046: );
4047:
4048: IF l_debug_on THEN
4049: WSH_DEBUG_SV.logmsg(l_module_name,' Exited out of CHECK CARRIER ARRIVAL TIME PROCEDURE '||x_return_status ,
4050: WSH_DEBUG_SV.C_PROC_LEVEL);
4051: END IF ;
4052:
4053: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);

Line 4050: WSH_DEBUG_SV.C_PROC_LEVEL);

4046: );
4047:
4048: IF l_debug_on THEN
4049: WSH_DEBUG_SV.logmsg(l_module_name,' Exited out of CHECK CARRIER ARRIVAL TIME PROCEDURE '||x_return_status ,
4050: WSH_DEBUG_SV.C_PROC_LEVEL);
4051: END IF ;
4052:
4053: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
4054:

Line 4086: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||

4082:
4083:
4084: IF l_debug_on
4085: THEN
4086: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||
4087: l_return_status,
4088: WSH_DEBUG_SV.C_PROC_LEVEL);
4089: END IF;
4090:

Line 4088: WSH_DEBUG_SV.C_PROC_LEVEL);

4084: IF l_debug_on
4085: THEN
4086: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||
4087: l_return_status,
4088: WSH_DEBUG_SV.C_PROC_LEVEL);
4089: END IF;
4090:
4091: wsh_util_core.api_post_call(
4092: p_return_status =>l_return_status,

Line 4135: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||

4131:
4132:
4133: IF l_debug_on
4134: THEN
4135: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||
4136: l_return_status,
4137: WSH_DEBUG_SV.C_PROC_LEVEL);
4138: END IF;
4139:

Line 4137: WSH_DEBUG_SV.C_PROC_LEVEL);

4133: IF l_debug_on
4134: THEN
4135: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||
4136: l_return_status,
4137: WSH_DEBUG_SV.C_PROC_LEVEL);
4138: END IF;
4139:
4140: wsh_util_core.api_post_call(
4141: p_return_status =>l_return_status,

Line 4192: WSH_DEBUG_SV.pop(l_module_name);

4188:
4189:
4190:
4191: IF l_debug_on THEN
4192: WSH_DEBUG_SV.pop(l_module_name);
4193: END IF;
4194:
4195: EXCEPTION
4196:

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

4247: l_parameter_list wf_parameter_list_t;
4248:
4249: l_api_name CONSTANT VARCHAR2(30) := 'RELEASE_TENDER_BLOCK';
4250: l_api_version CONSTANT NUMBER := 1.0;
4251: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4252: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
4253:
4254:
4255: l_return_status VARCHAR2(32767);

Line 4271: WSH_DEBUG_SV.push(l_module_name);

4267:
4268:
4269: SAVEPOINT RELEASE_TENDER_BLOCK_PUB;
4270: IF l_debug_on THEN
4271: WSH_DEBUG_SV.push(l_module_name);
4272: END IF;
4273:
4274: IF FND_API.to_Boolean( p_init_msg_list )
4275: THEN

Line 4368: WSH_DEBUG_SV.pop(l_module_name);

4364: --
4365: --
4366:
4367: IF l_debug_on THEN
4368: WSH_DEBUG_SV.pop(l_module_name);
4369: END IF;
4370:
4371: --}
4372: EXCEPTION

Line 4384: WSH_DEBUG_SV.pop(l_module_name);

4380: p_data => x_msg_data,
4381: p_encoded => FND_API.G_FALSE
4382: );
4383: IF l_debug_on THEN
4384: WSH_DEBUG_SV.pop(l_module_name);
4385: END IF;
4386:
4387:
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4398: WSH_DEBUG_SV.pop(l_module_name);

4394: p_data => x_msg_data,
4395: p_encoded => FND_API.G_FALSE
4396: );
4397: IF l_debug_on THEN
4398: WSH_DEBUG_SV.pop(l_module_name);
4399: END IF;
4400:
4401:
4402: WHEN OTHERS THEN

Line 4413: WSH_DEBUG_SV.pop(l_module_name);

4409: p_data => x_msg_data,
4410: p_encoded => FND_API.G_FALSE
4411: );
4412: IF l_debug_on THEN
4413: WSH_DEBUG_SV.pop(l_module_name);
4414: END IF;
4415:
4416:
4417: --}

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

4437: l_parameter_list wf_parameter_list_t;
4438:
4439: l_api_name CONSTANT VARCHAR2(30) := 'HANDLE_TENDER_RESPONSE';
4440: l_api_version CONSTANT NUMBER := 1.0;
4441: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4442: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
4443:
4444:
4445: l_return_status VARCHAR2(32767);

Line 4461: WSH_DEBUG_SV.push(l_module_name);

4457:
4458:
4459: SAVEPOINT HANDLE_TENDER_RESPONSE_PUB;
4460: IF l_debug_on THEN
4461: WSH_DEBUG_SV.push(l_module_name);
4462: END IF;
4463:
4464: IF FND_API.to_Boolean( p_init_msg_list )
4465: THEN

Line 4487: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling CREATE_UPDATE_TRIP ' ||

4483:
4484:
4485: IF l_debug_on
4486: THEN
4487: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling CREATE_UPDATE_TRIP ' ||
4488: l_return_status,
4489: WSH_DEBUG_SV.C_PROC_LEVEL);
4490: END IF;
4491:

Line 4489: WSH_DEBUG_SV.C_PROC_LEVEL);

4485: IF l_debug_on
4486: THEN
4487: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling CREATE_UPDATE_TRIP ' ||
4488: l_return_status,
4489: WSH_DEBUG_SV.C_PROC_LEVEL);
4490: END IF;
4491:
4492: wsh_util_core.api_post_call(
4493: p_return_status =>l_return_status,

Line 4547: WSH_DEBUG_SV.logmsg(l_module_name,' Setting load tender status ' ||

4543: p_value => p_trip_info.tender_status,
4544: p_parameterlist => l_parameter_list);
4545:
4546: IF l_debug_on THEN
4547: WSH_DEBUG_SV.logmsg(l_module_name,' Setting load tender status ' ||
4548: p_trip_info.tender_status,
4549: WSH_DEBUG_SV.C_PROC_LEVEL);
4550: END IF;
4551:

Line 4549: WSH_DEBUG_SV.C_PROC_LEVEL);

4545:
4546: IF l_debug_on THEN
4547: WSH_DEBUG_SV.logmsg(l_module_name,' Setting load tender status ' ||
4548: p_trip_info.tender_status,
4549: WSH_DEBUG_SV.C_PROC_LEVEL);
4550: END IF;
4551:
4552:
4553: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',

Line 4628: WSH_DEBUG_SV.pop(l_module_name);

4624: --
4625: --
4626:
4627: IF l_debug_on THEN
4628: WSH_DEBUG_SV.pop(l_module_name);
4629: END IF;
4630:
4631: --}
4632: EXCEPTION

Line 4644: WSH_DEBUG_SV.pop(l_module_name);

4640: p_data => x_msg_data,
4641: p_encoded => FND_API.G_FALSE
4642: );
4643: IF l_debug_on THEN
4644: WSH_DEBUG_SV.pop(l_module_name);
4645: END IF;
4646:
4647:
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4658: WSH_DEBUG_SV.pop(l_module_name);

4654: p_data => x_msg_data,
4655: p_encoded => FND_API.G_FALSE
4656: );
4657: IF l_debug_on THEN
4658: WSH_DEBUG_SV.pop(l_module_name);
4659: END IF;
4660:
4661:
4662: WHEN OTHERS THEN

Line 4673: WSH_DEBUG_SV.pop(l_module_name);

4669: p_data => x_msg_data,
4670: p_encoded => FND_API.G_FALSE
4671: );
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.pop(l_module_name);
4674: END IF;
4675:
4676:
4677: --}

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

4692: l_parameter_list wf_parameter_list_t;
4693:
4694: l_api_name CONSTANT VARCHAR2(30) := 'HANDLE_CANCEL_TENDER';
4695: l_api_version CONSTANT NUMBER := 1.0;
4696: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4697: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
4698:
4699:
4700: l_return_status VARCHAR2(32767);

Line 4727: WSH_DEBUG_SV.push(l_module_name);

4723:
4724:
4725: SAVEPOINT HANDLE_CANCEL_TENDER_PUB;
4726: IF l_debug_on THEN
4727: WSH_DEBUG_SV.push(l_module_name);
4728: END IF;
4729:
4730: IF FND_API.to_Boolean( p_init_msg_list )
4731: THEN

Line 4776: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||

4772:
4773:
4774: IF l_debug_on
4775: THEN
4776: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||
4777: l_return_status,
4778: WSH_DEBUG_SV.C_PROC_LEVEL);
4779: END IF;
4780:

Line 4778: WSH_DEBUG_SV.C_PROC_LEVEL);

4774: IF l_debug_on
4775: THEN
4776: WSH_DEBUG_SV.logmsg(l_module_name,' Return Status aftere calling WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP ' ||
4777: l_return_status,
4778: WSH_DEBUG_SV.C_PROC_LEVEL);
4779: END IF;
4780:
4781: wsh_util_core.api_post_call(
4782: p_return_status =>l_return_status,

Line 4834: WSH_DEBUG_SV.logmsg(l_module_name,' Setting load tender status ' ||

4830: p_value => p_trip_info.tender_status,
4831: p_parameterlist => l_parameter_list);
4832:
4833: IF l_debug_on THEN
4834: WSH_DEBUG_SV.logmsg(l_module_name,' Setting load tender status ' ||
4835: p_trip_info.tender_status,
4836: WSH_DEBUG_SV.C_PROC_LEVEL);
4837: END IF;
4838:

Line 4836: WSH_DEBUG_SV.C_PROC_LEVEL);

4832:
4833: IF l_debug_on THEN
4834: WSH_DEBUG_SV.logmsg(l_module_name,' Setting load tender status ' ||
4835: p_trip_info.tender_status,
4836: WSH_DEBUG_SV.C_PROC_LEVEL);
4837: END IF;
4838:
4839:
4840: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',

Line 4910: WSH_DEBUG_SV.pop(l_module_name);

4906: --
4907: --
4908:
4909: IF l_debug_on THEN
4910: WSH_DEBUG_SV.pop(l_module_name);
4911: END IF;
4912:
4913: --}
4914: EXCEPTION

Line 4926: WSH_DEBUG_SV.pop(l_module_name);

4922: p_data => x_msg_data,
4923: p_encoded => FND_API.G_FALSE
4924: );
4925: IF l_debug_on THEN
4926: WSH_DEBUG_SV.pop(l_module_name);
4927: END IF;
4928:
4929:
4930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4940: WSH_DEBUG_SV.pop(l_module_name);

4936: p_data => x_msg_data,
4937: p_encoded => FND_API.G_FALSE
4938: );
4939: IF l_debug_on THEN
4940: WSH_DEBUG_SV.pop(l_module_name);
4941: END IF;
4942:
4943:
4944: WHEN OTHERS THEN

Line 4955: WSH_DEBUG_SV.pop(l_module_name);

4951: p_data => x_msg_data,
4952: p_encoded => FND_API.G_FALSE
4953: );
4954: IF l_debug_on THEN
4955: WSH_DEBUG_SV.pop(l_module_name);
4956: END IF;
4957:
4958:
4959: --}

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

4981:
4982: l_api_name CONSTANT VARCHAR2(30) := 'HANDLE_UPDATE_TENDER';
4983: l_api_version CONSTANT NUMBER := 1.0;
4984:
4985: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4986: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
4987: l_item_key VARCHAR2(240);
4988:
4989: BEGIN

Line 5004: WSH_DEBUG_SV.logmsg(l_module_name,' Sending update tender notification. ',

5000: x_msg_data := 0;
5001:
5002:
5003: IF l_debug_on THEN
5004: WSH_DEBUG_SV.logmsg(l_module_name,' Sending update tender notification. ',
5005: WSH_DEBUG_SV.C_PROC_LEVEL);
5006: END IF;
5007:
5008: l_item_key := p_trip_info.WF_ITEM_KEY;

Line 5005: WSH_DEBUG_SV.C_PROC_LEVEL);

5001:
5002:
5003: IF l_debug_on THEN
5004: WSH_DEBUG_SV.logmsg(l_module_name,' Sending update tender notification. ',
5005: WSH_DEBUG_SV.C_PROC_LEVEL);
5006: END IF;
5007:
5008: l_item_key := p_trip_info.WF_ITEM_KEY;
5009: