DBA Data[Home] [Help]

APPS.FTE_MLS_TEST_NT dependencies on WSH_DEBUG_SV

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

54: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
55: l_action_out_rec FTE_ACTION_OUT_REC;
56: l_trip_action_param FTE_TRIP_ACTION_PARAM_REC;
57:
58: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
59: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'ASSIGN_SERVICE_TENDER';
60:
61: BEGIN
62:

Line 73: wsh_debug_sv.push(l_module_name);

69: FND_MSG_PUB.initialize;
70: END IF;
71: --
72: IF l_debug_on THEN
73: wsh_debug_sv.push(l_module_name);
74: END IF;
75: --
76: --
77: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 91: WSH_DEBUG_SV.logmsg(l_module_name, 'TripId:LegId:DeliveryId:'

87: l_delivery_id := p_ss_attr_rec.delivery_id;
88: l_list_action := p_list_action;
89:
90: IF l_debug_on THEN
91: WSH_DEBUG_SV.logmsg(l_module_name, 'TripId:LegId:DeliveryId:'
92: ||l_trip_id||':'||l_delivery_leg_id||':'||l_delivery_id);
93: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:List Action:'
94: ||p_service_action||':'||p_list_action);
95: END IF;

Line 93: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:List Action:'

89:
90: IF l_debug_on THEN
91: WSH_DEBUG_SV.logmsg(l_module_name, 'TripId:LegId:DeliveryId:'
92: ||l_trip_id||':'||l_delivery_leg_id||':'||l_delivery_id);
93: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:List Action:'
94: ||p_service_action||':'||p_list_action);
95: END IF;
96:
97: -- Step 1: Check if old service exists on trip

Line 104: WSH_DEBUG_SV.logmsg(l_module_name, 'Deleting Main Records for:'||l_trip_id);

100: IF ( p_service_action = 'UPDATE' AND l_trip_id IS NOT NULL
101: AND l_delivery_leg_id IS NULL ) THEN
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name, 'Deleting Main Records for:'||l_trip_id);
105: END IF;
106:
107: FTE_TRIP_RATING_GRP.DELETE_MAIN_RECORDS(
108: p_trip_id => l_trip_id,

Line 124: WSH_DEBUG_SV.logmsg(l_module_name, 'List Action:'||p_list_action);

120: -- Get the first record in the service table.
121: -- If LaneId is null, change l_list_action = 'SET_CURRENT'.
122:
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name, 'List Action:'||p_list_action);
125: WSH_DEBUG_SV.logmsg(l_module_name, ' Service List Size:'||p_ss_rate_sort_tab.count);
126: END IF;
127:
128: IF ( l_list_action = 'APPEND' ) THEN

Line 125: WSH_DEBUG_SV.logmsg(l_module_name, ' Service List Size:'||p_ss_rate_sort_tab.count);

121: -- If LaneId is null, change l_list_action = 'SET_CURRENT'.
122:
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name, 'List Action:'||p_list_action);
125: WSH_DEBUG_SV.logmsg(l_module_name, ' Service List Size:'||p_ss_rate_sort_tab.count);
126: END IF;
127:
128: IF ( l_list_action = 'APPEND' ) THEN
129: l_ss_rate_sort_rec := p_ss_rate_sort_tab(1);

Line 132: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Rank Id:'||l_ss_rate_sort_rec.rank_id);

128: IF ( l_list_action = 'APPEND' ) THEN
129: l_ss_rate_sort_rec := p_ss_rate_sort_tab(1);
130:
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Rank Id:'||l_ss_rate_sort_rec.rank_id);
133: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Lane Id:'||l_ss_rate_sort_rec.lane_id);
134: END IF;
135:
136: IF (l_ss_rate_sort_rec.rank_id IS NOT NULL AND l_ss_rate_sort_rec.lane_id IS NULL) THEN

Line 133: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Lane Id:'||l_ss_rate_sort_rec.lane_id);

129: l_ss_rate_sort_rec := p_ss_rate_sort_tab(1);
130:
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Rank Id:'||l_ss_rate_sort_rec.rank_id);
133: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Lane Id:'||l_ss_rate_sort_rec.lane_id);
134: END IF;
135:
136: IF (l_ss_rate_sort_rec.rank_id IS NOT NULL AND l_ss_rate_sort_rec.lane_id IS NULL) THEN
137: -- l_ss_rate_sort_rec.schedule_id IS NULL AND

Line 142: WSH_DEBUG_SV.logmsg(l_module_name, 'Only rank id populated:'||l_rank_id);

138: l_rank_id := l_ss_rate_sort_rec.rank_id;
139: l_list_action := 'SET_CURRENT';
140:
141: IF l_debug_on THEN
142: WSH_DEBUG_SV.logmsg(l_module_name, 'Only rank id populated:'||l_rank_id);
143: END IF;
144: END IF;
145: END IF;
146:

Line 148: WSH_DEBUG_SV.logmsg(l_module_name, ' New List Action:'||l_list_action);

144: END IF;
145: END IF;
146:
147: IF l_debug_on THEN
148: WSH_DEBUG_SV.logmsg(l_module_name, ' New List Action:'||l_list_action);
149: END IF;
150:
151:
152: -- Step 3: Create, Append or SetCurrent Ranked List depending on list action_code

Line 195: WSH_DEBUG_SV.logmsg(l_module_name, 'New Rank Id:'||l_rank_id);

191:
192: END IF;
193:
194: IF l_debug_on THEN
195: WSH_DEBUG_SV.logmsg(l_module_name, 'New Rank Id:'||l_rank_id);
196: END IF;
197:
198: -- Step 4: Update Trip
199: -- If delivery_id is null, this call is coming from TripWB. Update Trip with

Line 263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Move FC TEMP Request Id:'||p_request_id);

259: -- Step 5: Move FC Rates
260: -- If delivery_id is null, this call is coming from TripWB.
261:
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Move FC TEMP Request Id:'||p_request_id);
264: WSH_DEBUG_SV.logmsg(l_module_name,' If Delivery Id is NULL, from TWB:'||l_delivery_id);
265: END IF;
266:
267: IF ( p_request_id IS NOT NULL ) THEN

Line 264: WSH_DEBUG_SV.logmsg(l_module_name,' If Delivery Id is NULL, from TWB:'||l_delivery_id);

260: -- If delivery_id is null, this call is coming from TripWB.
261:
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Move FC TEMP Request Id:'||p_request_id);
264: WSH_DEBUG_SV.logmsg(l_module_name,' If Delivery Id is NULL, from TWB:'||l_delivery_id);
265: END IF;
266:
267: IF ( p_request_id IS NOT NULL ) THEN
268:

Line 302: WSH_DEBUG_SV.logmsg(l_module_name,'Pre Raising Tender Event CarrierContactId:'

298:
299: END IF;
300:
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'Pre Raising Tender Event CarrierContactId:'
303: ||p_tender_attr_rec.car_contact_id);
304: END IF;
305:
306: -- Step 6: Raise Tender event

Line 311: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Tender Event CarrierContactId:'

307: IF ( p_tender_attr_rec IS NOT NULL AND
308: p_tender_attr_rec.car_contact_id IS NOT NULL) THEN
309:
310: IF l_debug_on THEN
311: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Tender Event CarrierContactId:'
312: ||p_tender_attr_rec.car_contact_id);
313: END IF;
314:
315: -- Create Trip Actions Tab

Line 340: WSH_DEBUG_SV.POP(l_module_name);

336: END IF;
337:
338:
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.POP(l_module_name);
341: END IF;
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN

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

387: IS
388: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
389: l_ss_rate_sort_rec2 FTE_SS_RATE_SORT_REC;
390: l_ss_rate_sort_rec3 FTE_SS_RATE_SORT_REC;
391: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
392: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'SEARCH_SERVICES';
393:
394: BEGIN
395:

Line 407: wsh_debug_sv.push(l_module_name);

403: FND_MSG_PUB.initialize;
404: --END IF;
405: --
406: IF l_debug_on THEN
407: wsh_debug_sv.push(l_module_name);
408: END IF;
409: --
410: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
411: x_msg_count := 0;