[Home] [Help]
122: l_count NUMBER;
123:
124:
125: --
126: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
127: --
128: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
129:
130:
145: x_msg_count := 0;
146: x_msg_data := 0;
147:
148: IF l_debug_on THEN
149: wsh_debug_sv.push(l_module_name);
150: END IF;
151:
152: --create trip stop record
153: p_stop_info.STOP_ID:=pp_STOP_ID;
231:
232: --call public API
233:
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.log(l_module_name,
236: 'FTE_MLS_WRAPPER.p_is_temp value ',p_is_temp);
237: END IF;
238:
239:
267: END IF;
268:
269:
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.log(l_module_name,
272: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP x_return_status',x_return_status);
273: END IF;
274:
275:
282: ELSE
283: l_stop_seq := pp_STOP_SEQUENCE_NUMBER;
284:
285: IF l_debug_on THEN
286: WSH_DEBUG_SV.log(l_module_name,
287: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop Seq Number ',
288: l_stop_seq);
289:
290: WSH_DEBUG_SV.log(l_module_name,
286: WSH_DEBUG_SV.log(l_module_name,
287: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop Seq Number ',
288: l_stop_seq);
289:
290: WSH_DEBUG_SV.log(l_module_name,
291: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP New Stop Seq Number ',
292: p_new_stop_sequence);
293:
294: WSH_DEBUG_SV.log(l_module_name,
290: WSH_DEBUG_SV.log(l_module_name,
291: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP New Stop Seq Number ',
292: p_new_stop_sequence);
293:
294: WSH_DEBUG_SV.log(l_module_name,
295: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop stop id ',
296: p_stop_info.stop_id);
297:
298: END IF;
323: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(p_new_stop_sequence) := l_stop_seq_rec;
324:
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.log(l_module_name,
328: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Adding to temp table');
329: END IF;
330:
331: END IF;
335: p_count => x_msg_count,
336: p_data => x_msg_data);
337:
338: IF l_debug_on THEN
339: WSH_DEBUG_SV.pop(l_module_name);
340: END IF;
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
349: p_data => x_msg_data,
350: p_encoded => FND_API.G_FALSE
351: );
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.pop(l_module_name);
354: END IF;
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
362: p_data => x_msg_data,
363: p_encoded => FND_API.G_FALSE
364: );
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.pop(l_module_name);
367: END IF;
368: WHEN OTHERS THEN
369: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
374: p_data => x_msg_data,
375: p_encoded => FND_API.G_FALSE
376: );
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.pop(l_module_name);
379: END IF;
380: END Create_Update_Stop;
381:
382:
407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
408: p_commit VARCHAR2(1);
409:
410: --
411: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
412: --
413: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'STOP_ACTION';
414:
415: l_return_status VARCHAR2(32767);
440: l_number_of_warnings := 0;
441: l_number_of_errors := 0;
442:
443: IF l_debug_on THEN
444: wsh_debug_sv.push(l_module_name);
445: END IF;
446:
447:
448: p_entity_id_tab(1):=p_stop_id;
473:
474: );
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
478: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
479: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
480: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
481:
474: );
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
478: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
479: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
480: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
481:
482: END IF;
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
478: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
479: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
480: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
481:
482: END IF;
483:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
478: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
479: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
480: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_data);
481:
482: END IF;
483:
484:
505: p_encoded => FND_API.G_FALSE
506: );
507:
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.pop(l_module_name);
510: END IF;
511:
512:
513: EXCEPTION
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE
522: );
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.pop(l_module_name);
525: END IF;
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: ROLLBACK TO STOP_ACTION_PUB;
533: p_data => x_msg_data,
534: p_encoded => FND_API.G_FALSE
535: );
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.pop(l_module_name);
538: END IF;
539: WHEN OTHERS THEN
540: ROLLBACK TO STOP_ACTION_PUB;
541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
545: p_data => x_msg_data,
546: p_encoded => FND_API.G_FALSE
547: );
548: IF l_debug_on THEN
549: WSH_DEBUG_SV.pop(l_module_name);
550: END IF;
551: END Stop_Action;
552:
553:
619: l_msg_data VARCHAR2(32767);
620:
621:
622: --
623: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
624: --
625: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_ACTION';
626:
627:
646: l_number_of_errors := 0;
647: l_number_of_warnings := 0;
648:
649: IF l_debug_on THEN
650: wsh_debug_sv.push(l_module_name);
651: END IF;
652:
653:
654: p_commit:='F';
698: );
699:
700:
701: IF l_debug_on THEN
702: WSH_DEBUG_SV.logmsg(l_module_name,
703: ' WSH_INTERFACE_GRP.DeliveryAction Return status ' || x_return_status,
704: WSH_DEBUG_SV.C_PROC_LEVEL);
705: END IF;
706:
700:
701: IF l_debug_on THEN
702: WSH_DEBUG_SV.logmsg(l_module_name,
703: ' WSH_INTERFACE_GRP.DeliveryAction Return status ' || x_return_status,
704: WSH_DEBUG_SV.C_PROC_LEVEL);
705: END IF;
706:
707: wsh_util_core.api_post_call(
708: p_return_status =>l_return_status,
710: x_num_errors =>l_number_of_errors,
711: p_msg_data =>l_msg_data);
712:
713: IF l_debug_on THEN
714: WSH_DEBUG_SV.logmsg(l_module_name,
715: 'after wsh_util_core: x_return_status ' || x_return_status || ' l_return_status '||l_return_status,
716: WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718:
712:
713: IF l_debug_on THEN
714: WSH_DEBUG_SV.logmsg(l_module_name,
715: 'after wsh_util_core: x_return_status ' || x_return_status || ' l_return_status '||l_return_status,
716: WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718:
719: x_return_status := l_return_status;
720:
755: p_encoded => FND_API.G_FALSE
756: );
757:
758: IF l_debug_on THEN
759: WSH_DEBUG_SV.pop(l_module_name);
760: END IF;
761:
762:
763: EXCEPTION
770: p_data => x_msg_data,
771: p_encoded => FND_API.G_FALSE
772: );
773: IF l_debug_on THEN
774: WSH_DEBUG_SV.pop(l_module_name);
775: END IF;
776:
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO DELIVERY_ACTION_PUB;
783: p_data => x_msg_data,
784: p_encoded => FND_API.G_FALSE
785: );
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.pop(l_module_name);
788: END IF;
789:
790: WHEN OTHERS THEN
791: ROLLBACK TO DELIVERY_ACTION_PUB;
797: p_data => x_msg_data,
798: p_encoded => FND_API.G_FALSE
799: );
800: IF l_debug_on THEN
801: WSH_DEBUG_SV.pop(l_module_name);
802: END IF;
803:
804: END Delivery_Action;
805:
1152: l_temp_action VARCHAR2(30);
1153: l_load_tender_number NUMBER;
1154: l_db_tender_status VARCHAR2(30);
1155:
1156: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1157: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';
1158:
1159: l_number_of_warnings NUMBER;
1160: l_number_of_errors NUMBER;
1190: l_number_of_warnings := 0;
1191: l_number_of_errors := 0;
1192:
1193: IF l_debug_on THEN
1194: wsh_debug_sv.push(l_module_name);
1195: END IF;
1196:
1197: IF l_debug_on
1198: THEN
1195: END IF;
1196:
1197: IF l_debug_on
1198: THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_rec_TRIP_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1200: WSH_DEBUG_SV.logmsg(l_module_name,' Carrrier Id ' || p_rec_CARRIER_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1196:
1197: IF l_debug_on
1198: THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_rec_TRIP_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1200: WSH_DEBUG_SV.logmsg(l_module_name,' Carrrier Id ' || p_rec_CARRIER_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1197: IF l_debug_on
1198: THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_rec_TRIP_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1200: WSH_DEBUG_SV.logmsg(l_module_name,' Carrrier Id ' || p_rec_CARRIER_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1198: THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_rec_TRIP_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1200: WSH_DEBUG_SV.logmsg(l_module_name,' Carrrier Id ' || p_rec_CARRIER_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1199: WSH_DEBUG_SV.logmsg(l_module_name,' Trip id ' || p_rec_TRIP_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1200: WSH_DEBUG_SV.logmsg(l_module_name,' Carrrier Id ' || p_rec_CARRIER_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1200: WSH_DEBUG_SV.logmsg(l_module_name,' Carrrier Id ' || p_rec_CARRIER_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: WSH_DEBUG_SV.logmsg(l_module_name,' CarConsAcNo '|| p_rec_CONSIGNEE_CAR_AC_NO ,WSH_DEBUG_SV.C_PROC_LEVEL);
1201: WSH_DEBUG_SV.logmsg(l_module_name,' Mode ' || p_rec_MODE_OF_TRANSPORT, WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: WSH_DEBUG_SV.logmsg(l_module_name,' CarConsAcNo '|| p_rec_CONSIGNEE_CAR_AC_NO ,WSH_DEBUG_SV.C_PROC_LEVEL);
1209: WSH_DEBUG_SV.logmsg(l_module_name,' CarRefNumber '|| p_rec_CARRIER_REF_NUMBER ,WSH_DEBUG_SV.C_PROC_LEVEL);
1202: WSH_DEBUG_SV.logmsg(l_module_name,' Lane Id ' || p_rec_lane_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: WSH_DEBUG_SV.logmsg(l_module_name,' CarConsAcNo '|| p_rec_CONSIGNEE_CAR_AC_NO ,WSH_DEBUG_SV.C_PROC_LEVEL);
1209: WSH_DEBUG_SV.logmsg(l_module_name,' CarRefNumber '|| p_rec_CARRIER_REF_NUMBER ,WSH_DEBUG_SV.C_PROC_LEVEL);
1210: END IF;
1203: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Name ' || p_rec_NAME ,WSH_DEBUG_SV.C_PROC_LEVEL);
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: WSH_DEBUG_SV.logmsg(l_module_name,' CarConsAcNo '|| p_rec_CONSIGNEE_CAR_AC_NO ,WSH_DEBUG_SV.C_PROC_LEVEL);
1209: WSH_DEBUG_SV.logmsg(l_module_name,' CarRefNumber '|| p_rec_CARRIER_REF_NUMBER ,WSH_DEBUG_SV.C_PROC_LEVEL);
1210: END IF;
1211:
1204: WSH_DEBUG_SV.logmsg(l_module_name,' Load Tener Status ' || p_rec_LOAD_TENDER_STATUS ,WSH_DEBUG_SV.C_PROC_LEVEL);
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: WSH_DEBUG_SV.logmsg(l_module_name,' CarConsAcNo '|| p_rec_CONSIGNEE_CAR_AC_NO ,WSH_DEBUG_SV.C_PROC_LEVEL);
1209: WSH_DEBUG_SV.logmsg(l_module_name,' CarRefNumber '|| p_rec_CARRIER_REF_NUMBER ,WSH_DEBUG_SV.C_PROC_LEVEL);
1210: END IF;
1211:
1212:
1205: WSH_DEBUG_SV.logmsg(l_module_name,' Ignore for Plan '|| p_rec_IGNORE_FOR_PLANNING ,WSH_DEBUG_SV.C_PROC_LEVEL);
1206: WSH_DEBUG_SV.logmsg(l_module_name,' ShipMethod '|| p_rec_SHIP_METHOD_CODE ,WSH_DEBUG_SV.C_PROC_LEVEL);
1207: WSH_DEBUG_SV.logmsg(l_module_name,' Rank Id '|| p_rec_RANK_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: WSH_DEBUG_SV.logmsg(l_module_name,' CarConsAcNo '|| p_rec_CONSIGNEE_CAR_AC_NO ,WSH_DEBUG_SV.C_PROC_LEVEL);
1209: WSH_DEBUG_SV.logmsg(l_module_name,' CarRefNumber '|| p_rec_CARRIER_REF_NUMBER ,WSH_DEBUG_SV.C_PROC_LEVEL);
1210: END IF;
1211:
1212:
1213: --populate trip record
1275: p_trip_info.routing_rule_id := p_rec_ROUTING_RULE_ID;
1276: p_trip_info.append_flag := p_rec_APPEND_FLAG;
1277:
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code ' ||
1280: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1281: WSH_DEBUG_SV.logmsg(l_module_name,' p_ship_method_code ' ||
1282: p_rec_ship_method_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1283: END IF;
1276: p_trip_info.append_flag := p_rec_APPEND_FLAG;
1277:
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code ' ||
1280: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1281: WSH_DEBUG_SV.logmsg(l_module_name,' p_ship_method_code ' ||
1282: p_rec_ship_method_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1283: END IF;
1284:
1277:
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code ' ||
1280: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1281: WSH_DEBUG_SV.logmsg(l_module_name,' p_ship_method_code ' ||
1282: p_rec_ship_method_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1283: END IF;
1284:
1285: IF (p_action_code = 'UPDATE')
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code ' ||
1280: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1281: WSH_DEBUG_SV.logmsg(l_module_name,' p_ship_method_code ' ||
1282: p_rec_ship_method_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1283: END IF;
1284:
1285: IF (p_action_code = 'UPDATE')
1286: THEN
1293: WHERE TRIP_ID = p_rec_TRIP_ID;
1294:
1295:
1296: IF l_debug_on THEN
1297: WSH_DEBUG_SV.logmsg(l_module_name,' l_db_tender_status ' ||
1298: l_db_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1299: END IF;
1300:
1301:
1294:
1295:
1296: IF l_debug_on THEN
1297: WSH_DEBUG_SV.logmsg(l_module_name,' l_db_tender_status ' ||
1298: l_db_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1299: END IF;
1300:
1301:
1302: --
1381: x_out_tab =>x_out_tab
1382: );
1383:
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
1386: WSH_INTERFACE_GRP.Create_Update_Trip ' ||
1387: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1388: END IF;
1389:
1383:
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
1386: WSH_INTERFACE_GRP.Create_Update_Trip ' ||
1387: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1388: END IF;
1389:
1390: wsh_util_core.api_post_call(
1391: p_return_status =>l_return_status,
1400: END IF;
1401: END IF;
1402:
1403: IF l_debug_on THEN
1404: WSH_DEBUG_SV.logmsg(l_module_name,' trip_name ' ||
1405: x_trip_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1406: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code => ' ||
1407: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1408: WSH_DEBUG_SV.logmsg(l_module_name,' p_action => ' ||
1401: END IF;
1402:
1403: IF l_debug_on THEN
1404: WSH_DEBUG_SV.logmsg(l_module_name,' trip_name ' ||
1405: x_trip_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1406: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code => ' ||
1407: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1408: WSH_DEBUG_SV.logmsg(l_module_name,' p_action => ' ||
1409: p_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1402:
1403: IF l_debug_on THEN
1404: WSH_DEBUG_SV.logmsg(l_module_name,' trip_name ' ||
1405: x_trip_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1406: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code => ' ||
1407: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1408: WSH_DEBUG_SV.logmsg(l_module_name,' p_action => ' ||
1409: p_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1410:
1403: IF l_debug_on THEN
1404: WSH_DEBUG_SV.logmsg(l_module_name,' trip_name ' ||
1405: x_trip_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1406: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code => ' ||
1407: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1408: WSH_DEBUG_SV.logmsg(l_module_name,' p_action => ' ||
1409: p_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1410:
1411: END IF;
1404: WSH_DEBUG_SV.logmsg(l_module_name,' trip_name ' ||
1405: x_trip_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1406: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code => ' ||
1407: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1408: WSH_DEBUG_SV.logmsg(l_module_name,' p_action => ' ||
1409: p_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1410:
1411: END IF;
1412:
1405: x_trip_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1406: WSH_DEBUG_SV.logmsg(l_module_name,' p_action_code => ' ||
1407: p_action_code,WSH_DEBUG_SV.C_PROC_LEVEL);
1408: WSH_DEBUG_SV.logmsg(l_module_name,' p_action => ' ||
1409: p_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1410:
1411: END IF;
1412:
1413:
1458: p_trip_info_rec => l_tender_attr_rec,
1459: p_action_prms => trip_action_param);
1460:
1461: IF l_debug_on THEN
1462: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
1463: Trpi_action ' || l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1464: END IF;
1465:
1466: wsh_util_core.api_post_call(
1459: p_action_prms => trip_action_param);
1460:
1461: IF l_debug_on THEN
1462: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
1463: Trpi_action ' || l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1464: END IF;
1465:
1466: wsh_util_core.api_post_call(
1467: p_return_status =>l_return_status,
1500: p_encoded => FND_API.G_FALSE
1501: );
1502:
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
1505: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
1506: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_id:' || x_trip_id);
1507: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_name:' || x_trip_name);
1508: END IF;
1501: );
1502:
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
1505: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
1506: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_id:' || x_trip_id);
1507: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_name:' || x_trip_name);
1508: END IF;
1509:
1502:
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
1505: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
1506: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_id:' || x_trip_id);
1507: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_name:' || x_trip_name);
1508: END IF;
1509:
1510: IF l_debug_on THEN
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
1505: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
1506: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_id:' || x_trip_id);
1507: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_name:' || x_trip_name);
1508: END IF;
1509:
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.pop(l_module_name);
1507: WSH_DEBUG_SV.logmsg(l_module_name,'x_t_name:' || x_trip_name);
1508: END IF;
1509:
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.pop(l_module_name);
1512: END IF;
1513:
1514: EXCEPTION
1515: WHEN FND_API.G_EXC_ERROR THEN
1522: p_encoded => FND_API.G_FALSE
1523: );
1524:
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||
1527: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name);
1529: END IF;
1530:
1523: );
1524:
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||
1527: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name);
1529: END IF;
1530:
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1524:
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||
1527: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name);
1529: END IF;
1530:
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: ROLLBACK TO CREATE_UPDATE_TRIP_PUB;
1537: p_data => x_msg_data,
1538: p_encoded => FND_API.G_FALSE
1539: );
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
1542: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1543: WSH_DEBUG_SV.pop(l_module_name);
1544: END IF;
1545:
1538: p_encoded => FND_API.G_FALSE
1539: );
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
1542: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1543: WSH_DEBUG_SV.pop(l_module_name);
1544: END IF;
1545:
1546: WHEN OTHERS THEN
1539: );
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
1542: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1543: WSH_DEBUG_SV.pop(l_module_name);
1544: END IF;
1545:
1546: WHEN OTHERS THEN
1547: IF l_debug_on THEN
1544: END IF;
1545:
1546: WHEN OTHERS THEN
1547: IF l_debug_on THEN
1548: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:13 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1549: END IF;
1550:
1551: ROLLBACK TO CREATE_UPDATE_TRIP_PUB;
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1556: p_data => x_msg_data,
1557: p_encoded => FND_API.G_FALSE
1558: );
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
1561: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name);
1563: END IF;
1564:
1557: p_encoded => FND_API.G_FALSE
1558: );
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
1561: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name);
1563: END IF;
1564:
1565: END Create_Update_Trip;
1558: );
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
1561: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name);
1563: END IF;
1564:
1565: END Create_Update_Trip;
1566: --
1586: x_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1587: p_commit VARCHAR2(1);
1588:
1589: --
1590: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1591: --
1592: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'TRIP_ACTION';
1593:
1594:
1610: x_msg_count := 0;
1611: x_msg_data := 0;
1612:
1613: IF l_debug_on THEN
1614: wsh_debug_sv.push(l_module_name);
1615: END IF;
1616:
1617: p_entity_id_tab(1):=p_trip_id;
1618: p_action_prms.action_code:=p_action_code;
1634: x_msg_data=>x_msg_data
1635: );
1636:
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.pop(l_module_name);
1639: END IF;
1640:
1641:
1642: EXCEPTION
1650: p_encoded => FND_API.G_FALSE
1651: );
1652:
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.pop(l_module_name);
1655: END IF;
1656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1657: ROLLBACK TO TRIP_ACTION_PUB;
1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1662: p_data => x_msg_data,
1663: p_encoded => FND_API.G_FALSE
1664: );
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.pop(l_module_name);
1667: END IF;
1668: WHEN OTHERS THEN
1669: ROLLBACK TO TRIP_ACTION_PUB;
1670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1674: p_data => x_msg_data,
1675: p_encoded => FND_API.G_FALSE
1676: );
1677: IF l_debug_on THEN
1678: WSH_DEBUG_SV.pop(l_module_name);
1679: END IF;
1680: END Trip_Action;
1681: --
1682: --
1698: --========================================================================
1699: FUNCTION GET_TRIP_MSG_TOKEN
1700: (p_tenderIdTab IN FTE_ID_TAB_TYPE -- Table of Trip Names
1701: ) RETURN VARCHAR2 IS
1702: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1703: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'GET_TRIP_MSG_TOKEN';
1704:
1705: l_tokenName VARCHAR2(2000);
1706: BEGIN
1704:
1705: l_tokenName VARCHAR2(2000);
1706: BEGIN
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.PUSH(l_module_name);
1709: WSH_DEBUG_SV.logmsg(l_module_name,'Setting new user-friendly message for '|| p_tenderIdTab.COUNT||' Trips');
1710: END IF;
1711: --Setting the Tender IDs for displaying the appropriate message.
1712: l_tokenName := '';
1705: l_tokenName VARCHAR2(2000);
1706: BEGIN
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.PUSH(l_module_name);
1709: WSH_DEBUG_SV.logmsg(l_module_name,'Setting new user-friendly message for '|| p_tenderIdTab.COUNT||' Trips');
1710: END IF;
1711: --Setting the Tender IDs for displaying the appropriate message.
1712: l_tokenName := '';
1713: FOR i IN p_tenderIdTab.FIRST..p_tenderIdTab.LAST LOOP
1718: l_tokenName := l_tokenName || ' , ';
1719: END IF;
1720: END LOOP;
1721: IF l_debug_on THEN
1722: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting Token as - ' || l_tokenName);
1723: WSH_DEBUG_SV.POP(l_module_name);
1724: END IF;
1725: RETURN l_tokenName;
1726: END GET_TRIP_MSG_TOKEN;
1719: END IF;
1720: END LOOP;
1721: IF l_debug_on THEN
1722: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting Token as - ' || l_tokenName);
1723: WSH_DEBUG_SV.POP(l_module_name);
1724: END IF;
1725: RETURN l_tokenName;
1726: END GET_TRIP_MSG_TOKEN;
1727:
1738: --========================================================================
1739: FUNCTION GET_TRIP_MSG_TOKEN
1740: (p_tripNamesTab IN FTE_NAME_TAB_TYPE -- Table of Trip Names
1741: ) RETURN VARCHAR2 IS
1742: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1743: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'GET_TRIP_MSG_TOKEN';
1744:
1745: l_tokenName VARCHAR2(2000);
1746: BEGIN
1744:
1745: l_tokenName VARCHAR2(2000);
1746: BEGIN
1747: IF l_debug_on THEN
1748: WSH_DEBUG_SV.PUSH(l_module_name);
1749: WSH_DEBUG_SV.logmsg(l_module_name,'Setting new user-friendly message for '|| p_tripNamesTab.COUNT||' Trips');
1750: END IF;
1751: --Setting the Tender IDs for displaying the appropriate message.
1752: l_tokenName := '';
1745: l_tokenName VARCHAR2(2000);
1746: BEGIN
1747: IF l_debug_on THEN
1748: WSH_DEBUG_SV.PUSH(l_module_name);
1749: WSH_DEBUG_SV.logmsg(l_module_name,'Setting new user-friendly message for '|| p_tripNamesTab.COUNT||' Trips');
1750: END IF;
1751: --Setting the Tender IDs for displaying the appropriate message.
1752: l_tokenName := '';
1753: FOR i IN p_tripNamesTab.FIRST..p_tripNamesTab.LAST LOOP
1758: l_tokenName := l_tokenName || ' , ';
1759: END IF;
1760: END LOOP;
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting Token as - ' || l_tokenName);
1763: WSH_DEBUG_SV.POP(l_module_name);
1764: END IF;
1765: RETURN l_tokenName;
1766: END GET_TRIP_MSG_TOKEN;
1759: END IF;
1760: END LOOP;
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name, 'Setting Token as - ' || l_tokenName);
1763: WSH_DEBUG_SV.POP(l_module_name);
1764: END IF;
1765: RETURN l_tokenName;
1766: END GET_TRIP_MSG_TOKEN;
1767:
1790: l_modeOfTransport VARCHAR2(30);
1791: l_serviceLevel VARCHAR2(30);
1792: l_carrier_name VARCHAR2(360);
1793:
1794: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1795: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'TENDER_TRIP_VALIDATIONS';
1796:
1797: CURSOR c_tripDetails(p_tripID NUMBER) IS
1798: SELECT CARRIER_ID, NAME, LANE_ID, MODE_OF_TRANSPORT, SERVICE_LEVEL, SHIPMENTS_TYPE_FLAG,
1820:
1821: BEGIN
1822:
1823: IF l_debug_on THEN
1824: WSH_DEBUG_SV.PUSH(l_module_name);
1825: WSH_DEBUG_SV.logmsg(l_module_name,' Begin Validations for trip ' || p_tripID);
1826: END IF;
1827:
1828: BEGIN
1821: BEGIN
1822:
1823: IF l_debug_on THEN
1824: WSH_DEBUG_SV.PUSH(l_module_name);
1825: WSH_DEBUG_SV.logmsg(l_module_name,' Begin Validations for trip ' || p_tripID);
1826: END IF;
1827:
1828: BEGIN
1829: --Get Carrier, TripName and LoadTender Status.
1834: x_tripType, x_tripTenderStatus;
1835: CLOSE c_tripDetails;
1836:
1837: IF (l_debug_on) THEN
1838: WSH_DEBUG_SV.logmsg(l_module_name,' Got Carrier '|| x_carrierID || ' for trip ' || x_tripName);
1839: END IF;
1840:
1841: --Checking if Carrier is present in the Trip Level
1842: IF ((x_carrierID = -99) OR
1848: FND_MESSAGE.SET_NAME('FTE','FTE_MLS_TENDER_INIT_FAIL');
1849: FND_MSG_PUB.ADD;
1850:
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier/Lane/ServiceLevel/Mode is null. Trip Cannot be tendered.');
1853: WSH_DEBUG_SV.pop(l_module_name);
1854: END IF;
1855: RETURN FALSE;
1856: END IF;
1849: FND_MSG_PUB.ADD;
1850:
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier/Lane/ServiceLevel/Mode is null. Trip Cannot be tendered.');
1853: WSH_DEBUG_SV.pop(l_module_name);
1854: END IF;
1855: RETURN FALSE;
1856: END IF;
1857:
1855: RETURN FALSE;
1856: END IF;
1857:
1858: IF (l_debug_on) THEN
1859: WSH_DEBUG_SV.logmsg(l_module_name,' Checking if Carrier is Tender Enabled');
1860: END IF;
1861:
1862: l_isCarrierTenderEnabled := 'N';
1863: l_autoTenderEnabled := 'N';
1869: CLOSE c_isCarrierTenderEnabled;
1870:
1871:
1872: IF (l_debug_on) THEN
1873: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier Tender Enabled - ' || l_isCarrierTenderEnabled);
1874: END IF;
1875:
1876: IF l_isCarrierTenderEnabled <> 'Y' THEN
1877: --Log exception into FND
1878: FND_MESSAGE.SET_NAME('FTE','FTE_CARRIER_NOT_TENDER_ENBL');
1879: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1880: FND_MSG_PUB.ADD;
1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier is not tender Enabled');
1883: WSH_DEBUG_SV.pop(l_module_name);
1884: END IF;
1885: RETURN FALSE;
1886: END IF;
1879: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1880: FND_MSG_PUB.ADD;
1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier is not tender Enabled');
1883: WSH_DEBUG_SV.pop(l_module_name);
1884: END IF;
1885: RETURN FALSE;
1886: END IF;
1887:
1885: RETURN FALSE;
1886: END IF;
1887:
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.logmsg(l_module_name,' checking autotender enabled ' || l_autoTenderEnabled);
1890: END IF;
1891:
1892: -- As part of HIDDING PROJECT we are going to set this flag to Y
1893: -- l_autoTenderEnabled = 'Y'
1897: FND_MESSAGE.SET_NAME('FTE','FTE_CARRIER_NO_AUTO_TENDER');
1898: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1899: FND_MSG_PUB.ADD;
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier is not auto tender enabled ');
1902: WSH_DEBUG_SV.pop(l_module_name);
1903: END IF;
1904: RETURN FALSE;
1905: END IF;
1898: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1899: FND_MSG_PUB.ADD;
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier is not auto tender enabled ');
1902: WSH_DEBUG_SV.pop(l_module_name);
1903: END IF;
1904: RETURN FALSE;
1905: END IF;
1906:
1910: FETCH c_numberOfDel INTO l_numberOfDeliveries;
1911: CLOSE c_numberOfDel;
1912:
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,' Number of deliveries in the Trip is - ' || l_numberOfDeliveries);
1915: END IF;
1916:
1917: --Trip cannot be tendered in case there arent any deliveries in the trip.
1918: IF l_numberOfDeliveries = 0 THEN
1920: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_CNT_TENDER_NO_DLVY');
1921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', x_tripName);
1922: FND_MSG_PUB.ADD;
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Cannot be tendered since there are no delieries on the trip ');
1925: WSH_DEBUG_SV.pop(l_module_name);
1926: END IF;
1927: RETURN FALSE;
1928: END IF;
1921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', x_tripName);
1922: FND_MSG_PUB.ADD;
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Cannot be tendered since there are no delieries on the trip ');
1925: WSH_DEBUG_SV.pop(l_module_name);
1926: END IF;
1927: RETURN FALSE;
1928: END IF;
1929:
1927: RETURN FALSE;
1928: END IF;
1929:
1930: IF (l_debug_on) THEN
1931: WSH_DEBUG_SV.logmsg(l_module_name,' Validations are all passes, Trip can now be tendered.');
1932: WSH_DEBUG_SV.pop(l_module_name);
1933: END IF;
1934:
1935: RETURN TRUE;
1928: END IF;
1929:
1930: IF (l_debug_on) THEN
1931: WSH_DEBUG_SV.logmsg(l_module_name,' Validations are all passes, Trip can now be tendered.');
1932: WSH_DEBUG_SV.pop(l_module_name);
1933: END IF;
1934:
1935: RETURN TRUE;
1936:
1936:
1937: EXCEPTION
1938: WHEN OTHERS THEN
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
1941: 'Oracle error message is '||
1942: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1943: WSH_DEBUG_SV.pop(l_module_name);
1944: END IF;
1938: WHEN OTHERS THEN
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
1941: 'Oracle error message is '||
1942: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1943: WSH_DEBUG_SV.pop(l_module_name);
1944: END IF;
1945: RETURN FALSE;
1946: END;
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
1941: 'Oracle error message is '||
1942: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1943: WSH_DEBUG_SV.pop(l_module_name);
1944: END IF;
1945: RETURN FALSE;
1946: END;
1947: END TENDER_TRIP_VALIDATIONS;
1968: x_return_status OUT NOCOPY VARCHAR2,
1969: x_msg_count OUT NOCOPY NUMBER,
1970: x_msg_data OUT NOCOPY VARCHAR2
1971: ) IS
1972: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1973: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'TENDER_TRIPS';
1974: i NUMBER := 0;
1975: l_tripType VARCHAR2(30);
1976: l_tripTenderStatus VARCHAR2(30);
2134: FND_MSG_PUB.initialize;
2135: END IF;
2136:
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.PUSH(l_module_name);
2139: WSH_DEBUG_SV.logmsg(l_module_name,'About to tender ' || p_trip_id_tab.COUNT || ' Trips');
2140: END IF;
2141:
2142: l_error_id_tab := FTE_ID_TAB_TYPE();
2135: END IF;
2136:
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.PUSH(l_module_name);
2139: WSH_DEBUG_SV.logmsg(l_module_name,'About to tender ' || p_trip_id_tab.COUNT || ' Trips');
2140: END IF;
2141:
2142: l_error_id_tab := FTE_ID_TAB_TYPE();
2143: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2148: BEGIN
2149: --Looping through the trips to tender if possible.
2150: FOR i IN p_trip_id_tab.FIRST..p_trip_id_tab.LAST LOOP
2151: IF l_debug_on THEN
2152: WSH_DEBUG_SV.logmsg(l_module_name,'About to tender Trip - ' || p_trip_id_tab(i));
2153: END IF;
2154: --Checking if trip has got deliveries present to go ahead and tender
2155: IF (TENDER_TRIP_VALIDATIONS(p_trip_id_tab(i),
2156: l_tripName,
2158: l_tripType,
2159: l_tripTenderStatus
2160: )) THEN
2161: IF l_debug_on THEN
2162: WSH_DEBUG_SV.logmsg(l_module_name,
2163: 'Validated the trip Successfuly, Querrying data for the trip ');
2164: WSH_DEBUG_SV.logmsg(l_module_name,'Type of Trip - ' || l_tripType);
2165: END IF;
2166:
2160: )) THEN
2161: IF l_debug_on THEN
2162: WSH_DEBUG_SV.logmsg(l_module_name,
2163: 'Validated the trip Successfuly, Querrying data for the trip ');
2164: WSH_DEBUG_SV.logmsg(l_module_name,'Type of Trip - ' || l_tripType);
2165: END IF;
2166:
2167: -- If trip is Inbound then get DESC order of Arrival Date
2168: IF l_tripType = 'I' THEN
2175: CLOSE c_tripStops;
2176: END IF;
2177:
2178: IF l_debug_on THEN
2179: WSH_DEBUG_SV.logmsg(l_module_name,'Querried up the InitialPickup Stop ' || l_stopLocID || ' for the trip successfully.');
2180: END IF;
2181:
2182: --Getting the Organization of Final Stop.
2183: OPEN c_getOrganization(l_stopLocID);
2183: OPEN c_getOrganization(l_stopLocID);
2184: FETCH c_getOrganization INTO l_orgID;
2185: CLOSE c_getOrganization;
2186: IF l_debug_on THEN
2187: WSH_DEBUG_SV.logmsg(l_module_name,'Querried up the Organization ' || l_orgID || ' for the Stop successfully.');
2188: END IF;
2189:
2190: --If Organization is set to the carrier Site use it, else pick all.
2191: IF l_orgID <> NULL THEN
2216: --{
2217: IF (l_carrier_contact_id IS NULL)
2218: THEN
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,' Invalid Carrier Contact information. Cannot Tender ');
2221: END IF;
2222:
2223: l_error_id_tab.EXTEND;
2224: l_error_id_tab(l_error_id_tab.COUNT) := p_trip_id_tab(i);
2227: l_number_of_errors := l_number_of_errors + 1;
2228: ELSE
2229:
2230: IF l_debug_on THEN
2231: WSH_DEBUG_SV.logmsg(l_module_name,'Querried up the data for the trip successfully, Updating the Trip');
2232: END IF;
2233:
2234: --Call new TRIP_ACTION api
2235:
2266: p_trip_info_rec => l_tender_attr_rec,
2267: p_action_prms => l_trip_action_rec);
2268:
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.logmsg(l_module_name,'Updated the Trip ' || l_return_status || ' l_msg_data = ' || l_msg_data);
2271: END IF;
2272:
2273:
2274: IF l_return_status = 'E' THEN
2272:
2273:
2274: IF l_return_status = 'E' THEN
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to update the trip. ' || l_msg_data);
2277: END IF;
2278: l_error_id_tab.EXTEND;
2279: l_error_id_tab(l_error_id_tab.COUNT) := p_trip_id_tab(i);
2280: l_error_name_tab.EXTEND;
2282: l_number_of_errors := l_number_of_errors + 1;
2283: END IF;
2284:
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2287: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2288: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2289: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2290: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2283: END IF;
2284:
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2287: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2288: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2289: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2290: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2291: END IF;
2284:
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2287: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2288: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2289: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2290: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2291: END IF;
2292: WSH_UTIL_CORE.API_POST_CALL(
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2287: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2288: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2289: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2290: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2291: END IF;
2292: WSH_UTIL_CORE.API_POST_CALL(
2293: p_return_status =>l_return_status,
2286: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2287: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2288: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2289: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2290: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2291: END IF;
2292: WSH_UTIL_CORE.API_POST_CALL(
2293: p_return_status =>l_return_status,
2294: x_num_warnings =>l_number_of_warnings,
2306: l_error_name_tab.EXTEND;
2307: l_error_name_tab(l_error_name_tab.COUNT) := l_tripName;
2308: l_number_of_errors := l_number_of_errors + 1;
2309: IF l_debug_on THEN
2310: WSH_DEBUG_SV.logmsg(l_module_name,'Validation Failed for trip - ' || p_trip_id_tab(i) || '. Did not tender.');
2311: END IF;
2312:
2313: END IF;
2314: END LOOP;
2339: THEN
2340: --{
2341:
2342: IF l_debug_on THEN
2343: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status ' || x_return_status);
2344: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count ' || x_msg_count);
2345: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data ' ||
2346: FTE_MLS_UTIL.GET_MESSAGE(x_msg_count,x_msg_data));
2347: END IF;
2340: --{
2341:
2342: IF l_debug_on THEN
2343: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status ' || x_return_status);
2344: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count ' || x_msg_count);
2345: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data ' ||
2346: FTE_MLS_UTIL.GET_MESSAGE(x_msg_count,x_msg_data));
2347: END IF;
2348:
2341:
2342: IF l_debug_on THEN
2343: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status ' || x_return_status);
2344: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count ' || x_msg_count);
2345: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data ' ||
2346: FTE_MLS_UTIL.GET_MESSAGE(x_msg_count,x_msg_data));
2347: END IF;
2348:
2349: --Suppressing the detailed msg to be shown to the user
2347: END IF;
2348:
2349: --Suppressing the detailed msg to be shown to the user
2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.logmsg(l_module_name,'Clearing off unrequired messages');
2352: END IF;
2353:
2354: FND_MSG_PUB.initialize; -- FND messages are not sent back to the UI hence clearing the stack
2355: x_msg_data := '';
2355: x_msg_data := '';
2356: x_msg_count := 0;
2357:
2358: IF (l_error_id_tab.COUNT > 0) THEN --In case any error is present.
2359: WSH_DEBUG_SV.logmsg(l_module_name,'Getting new user-friendly message for '||l_error_name_tab.COUNT||' ERROR Trips');
2360: l_tenderIds := GET_TRIP_MSG_TOKEN(l_error_id_tab);
2361: ELSIF (l_valid_ids_tab.COUNT > 0) THEN --In case Only success is present.
2362: WSH_DEBUG_SV.logmsg(l_module_name,'Getting new user-friendly message for '||l_error_name_tab.COUNT||' SUCCESS Trips');
2363: l_tenderIds := GET_TRIP_MSG_TOKEN(l_valid_ids_tab);
2358: IF (l_error_id_tab.COUNT > 0) THEN --In case any error is present.
2359: WSH_DEBUG_SV.logmsg(l_module_name,'Getting new user-friendly message for '||l_error_name_tab.COUNT||' ERROR Trips');
2360: l_tenderIds := GET_TRIP_MSG_TOKEN(l_error_id_tab);
2361: ELSIF (l_valid_ids_tab.COUNT > 0) THEN --In case Only success is present.
2362: WSH_DEBUG_SV.logmsg(l_module_name,'Getting new user-friendly message for '||l_error_name_tab.COUNT||' SUCCESS Trips');
2363: l_tenderIds := GET_TRIP_MSG_TOKEN(l_valid_ids_tab);
2364: END IF;
2365:
2366: --Setting new user friendly message for Error and Warning.
2380: p_data => x_msg_data,
2381: p_encoded => FND_API.G_FALSE);
2382:
2383: IF l_debug_on THEN
2384: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count - ' || x_msg_count);
2385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data - ' || x_msg_data);
2386: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data - ' || FTE_MLS_UTIL.GET_MESSAGE(x_msg_count,x_msg_data));
2387: END IF;
2388: --}
2381: p_encoded => FND_API.G_FALSE);
2382:
2383: IF l_debug_on THEN
2384: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count - ' || x_msg_count);
2385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data - ' || x_msg_data);
2386: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data - ' || FTE_MLS_UTIL.GET_MESSAGE(x_msg_count,x_msg_data));
2387: END IF;
2388: --}
2389: END IF;
2382:
2383: IF l_debug_on THEN
2384: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count - ' || x_msg_count);
2385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data - ' || x_msg_data);
2386: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data - ' || FTE_MLS_UTIL.GET_MESSAGE(x_msg_count,x_msg_data));
2387: END IF;
2388: --}
2389: END IF;
2390:
2388: --}
2389: END IF;
2390:
2391: IF l_debug_on THEN
2392: WSH_DEBUG_SV.pop(l_module_name);
2393: END IF;
2394:
2395: EXCEPTION
2396: WHEN FND_API.G_EXC_ERROR THEN
2402: p_data => x_msg_data,
2403: p_encoded => FND_API.G_FALSE
2404: );
2405: IF l_debug_on THEN
2406: WSH_DEBUG_SV.pop(l_module_name);
2407: END IF;
2408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2409: ROLLBACK TO TENDER_TRIPS;
2410: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2414: p_data => x_msg_data,
2415: p_encoded => FND_API.G_FALSE
2416: );
2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name);
2420: END IF;
2421: WHEN OTHERS THEN
2422: ROLLBACK TO TENDER_TRIPS;
2415: p_encoded => FND_API.G_FALSE
2416: );
2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name);
2420: END IF;
2421: WHEN OTHERS THEN
2422: ROLLBACK TO TENDER_TRIPS;
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2427: p_data => x_msg_data,
2428: p_encoded => FND_API.G_FALSE
2429: );
2430: IF l_debug_on THEN
2431: WSH_DEBUG_SV.logmsg(l_module_name,'Unlown error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2432: WSH_DEBUG_SV.pop(l_module_name);
2433: END IF;
2434: END;
2435: END TENDER_TRIPS;
2428: p_encoded => FND_API.G_FALSE
2429: );
2430: IF l_debug_on THEN
2431: WSH_DEBUG_SV.logmsg(l_module_name,'Unlown error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2432: WSH_DEBUG_SV.pop(l_module_name);
2433: END IF;
2434: END;
2435: END TENDER_TRIPS;
2436: --}
2451: x_tripLoadTenderStatus OUT NOCOPY VARCHAR2,
2452: x_carrier_contact_id OUT NOCOPY NUMBER,
2453: x_wFItemKey OUT NOCOPY VARCHAR2
2454: ) RETURN BOOLEAN IS
2455: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2456: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'CANCEL_TENDER_VALIDATIONS';
2457:
2458: CURSOR c_tripDetails (p_tripID NUMBER) IS
2459: SELECT NAME, PLANNED_FLAG, LOAD_TENDER_STATUS,
2471:
2472: BEGIN
2473:
2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.PUSH(l_module_name);
2476: WSH_DEBUG_SV.logmsg(l_module_name,' Begin Validations for trip ' || p_tripID);
2477: END IF;
2478:
2479: --Getting trip details for all the validations
2472: BEGIN
2473:
2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.PUSH(l_module_name);
2476: WSH_DEBUG_SV.logmsg(l_module_name,' Begin Validations for trip ' || p_tripID);
2477: END IF;
2478:
2479: --Getting trip details for all the validations
2480: OPEN c_tripDetails(p_tripID);
2485: -- Check for NULL Lane
2486: IF (l_laneID IS NULL) THEN
2487: --No msg as of now. Will check later --AJPRABHA
2488: IF l_debug_on THEN
2489: WSH_DEBUG_SV.logmsg(l_module_name,'Failed since LaneID is null ');
2490: WSH_DEBUG_SV.pop(l_module_name);
2491: END IF;
2492: RETURN FALSE;
2493: END IF;
2486: IF (l_laneID IS NULL) THEN
2487: --No msg as of now. Will check later --AJPRABHA
2488: IF l_debug_on THEN
2489: WSH_DEBUG_SV.logmsg(l_module_name,'Failed since LaneID is null ');
2490: WSH_DEBUG_SV.pop(l_module_name);
2491: END IF;
2492: RETURN FALSE;
2493: END IF;
2494:
2497: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_CAN_TENDER_FIRMED');
2498: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_tripName);
2499: FND_MSG_PUB.ADD;
2500: IF l_debug_on THEN
2501: WSH_DEBUG_SV.logmsg(l_module_name,'Failed since Planned Flag is ' || l_tripPlannedFlag);
2502: WSH_DEBUG_SV.pop(l_module_name);
2503: END IF;
2504: RETURN FALSE;
2505: END IF;
2498: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_tripName);
2499: FND_MSG_PUB.ADD;
2500: IF l_debug_on THEN
2501: WSH_DEBUG_SV.logmsg(l_module_name,'Failed since Planned Flag is ' || l_tripPlannedFlag);
2502: WSH_DEBUG_SV.pop(l_module_name);
2503: END IF;
2504: RETURN FALSE;
2505: END IF;
2506:
2505: END IF;
2506:
2507:
2508: IF l_debug_on THEN
2509: WSH_DEBUG_SV.logmsg(l_module_name,' Validations are all passed, Cancel tender can now be performed.');
2510: WSH_DEBUG_SV.pop(l_module_name);
2511: END IF;
2512: RETURN TRUE;
2513:
2506:
2507:
2508: IF l_debug_on THEN
2509: WSH_DEBUG_SV.logmsg(l_module_name,' Validations are all passed, Cancel tender can now be performed.');
2510: WSH_DEBUG_SV.pop(l_module_name);
2511: END IF;
2512: RETURN TRUE;
2513:
2514: EXCEPTION
2513:
2514: EXCEPTION
2515: WHEN OTHERS THEN
2516: IF l_debug_on THEN
2517: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
2518: 'Oracle error message is '||
2519: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2520: WSH_DEBUG_SV.pop(l_module_name);
2521: END IF;
2515: WHEN OTHERS THEN
2516: IF l_debug_on THEN
2517: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
2518: 'Oracle error message is '||
2519: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2520: WSH_DEBUG_SV.pop(l_module_name);
2521: END IF;
2522: RETURN FALSE;
2523: END CANCEL_TENDER_VALIDATIONS;
2516: IF l_debug_on THEN
2517: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
2518: 'Oracle error message is '||
2519: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2520: WSH_DEBUG_SV.pop(l_module_name);
2521: END IF;
2522: RETURN FALSE;
2523: END CANCEL_TENDER_VALIDATIONS;
2524:
2544: x_msg_count OUT NOCOPY NUMBER,
2545: x_msg_data OUT NOCOPY VARCHAR2
2546: ) IS
2547:
2548: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2549: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'CANCEL_TENDER_TRIPS';
2550:
2551: l_return_status VARCHAR2(1);
2552: l_error_tkn VARCHAR2(500);
2586: FND_MSG_PUB.initialize;
2587: END IF;
2588: SAVEPOINT CANCEL_TENDER_TRIPS;
2589: IF l_debug_on THEN
2590: WSH_DEBUG_SV.PUSH(l_module_name);
2591: WSH_DEBUG_SV.logmsg(l_module_name,'About to cancel tender ' || p_trip_id_tab.COUNT || ' Trips');
2592: END IF;
2593:
2594: l_error_id_tab := FTE_ID_TAB_TYPE();
2587: END IF;
2588: SAVEPOINT CANCEL_TENDER_TRIPS;
2589: IF l_debug_on THEN
2590: WSH_DEBUG_SV.PUSH(l_module_name);
2591: WSH_DEBUG_SV.logmsg(l_module_name,'About to cancel tender ' || p_trip_id_tab.COUNT || ' Trips');
2592: END IF;
2593:
2594: l_error_id_tab := FTE_ID_TAB_TYPE();
2595: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2597:
2598: BEGIN
2599: FOR i IN p_trip_id_tab.FIRST..p_trip_id_tab.LAST LOOP
2600: IF l_debug_on THEN
2601: WSH_DEBUG_SV.logmsg(l_module_name,'About to cancel tender for Trip - ' || p_trip_id_tab(i));
2602: END IF;
2603:
2604: IF (CANCEL_TENDER_VALIDATIONS(
2605: p_tripID => p_trip_id_tab(i),
2643: p_action_prms => l_trip_action_rec);
2644:
2645:
2646: IF l_debug_on THEN
2647: WSH_DEBUG_SV.logmsg(l_module_name,'Updated the Trip ' || l_return_status || ' l_msg_data = ' || l_msg_data);
2648: END IF;
2649:
2650: IF l_return_status = 'E' THEN
2651: --{
2649:
2650: IF l_return_status = 'E' THEN
2651: --{
2652: IF l_debug_on THEN
2653: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to update the trip.' || l_msg_data);
2654: END IF;
2655: l_error_id_tab.EXTEND;
2656: l_error_id_tab(l_error_id_tab.COUNT) := p_trip_id_tab(i);
2657: l_error_name_tab.EXTEND;
2660: --}
2661: ELSE
2662: --{
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Updated the trip successfully.' || l_msg_data);
2665: END IF;
2666:
2667: l_valid_ids_tab.EXTEND;
2668: l_valid_ids_tab(l_valid_ids_tab.COUNT) := p_trip_id_tab(i);
2709: --}
2710: END IF;
2711:
2712: IF l_debug_on THEN
2713: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2714: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2715: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2716: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2717: END IF;
2710: END IF;
2711:
2712: IF l_debug_on THEN
2713: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2714: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2715: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2716: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2717: END IF;
2718:
2711:
2712: IF l_debug_on THEN
2713: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2714: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2715: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2716: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2717: END IF;
2718:
2719: WSH_UTIL_CORE.API_POST_CALL(
2712: IF l_debug_on THEN
2713: WSH_DEBUG_SV.logmsg(l_module_name,'Before Post API Call');
2714: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status: ' || l_return_status);
2715: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2716: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2717: END IF;
2718:
2719: WSH_UTIL_CORE.API_POST_CALL(
2720: p_return_status =>l_return_status,
2731: l_error_name_tab.EXTEND;
2732: l_error_name_tab(l_error_name_tab.COUNT) := l_tripName;
2733: l_number_of_errors := l_number_of_errors + 1;
2734: IF l_debug_on THEN
2735: WSH_DEBUG_SV.logmsg(l_module_name,'Validation Failed for cancel tender trip - ' || p_trip_id_tab(i) || '. Did not tender.');
2736: END IF;
2737: --}
2738: END IF;
2739: END LOOP;
2738: END IF;
2739: END LOOP;
2740:
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'End of Loop');
2743: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2744: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings - ' || l_number_of_warnings);
2745: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2746: END IF;
2739: END LOOP;
2740:
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'End of Loop');
2743: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2744: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings - ' || l_number_of_warnings);
2745: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2746: END IF;
2747: x_action_out_rec := FTE_ACTION_OUT_REC(
2740:
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'End of Loop');
2743: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2744: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings - ' || l_number_of_warnings);
2745: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2746: END IF;
2747: x_action_out_rec := FTE_ACTION_OUT_REC(
2748: l_error_id_tab,l_valid_ids_tab,NULL,NULL,NULL,NULL,NULL,NULL);
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'End of Loop');
2743: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2744: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings - ' || l_number_of_warnings);
2745: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors - ' || l_number_of_errors);
2746: END IF;
2747: x_action_out_rec := FTE_ACTION_OUT_REC(
2748: l_error_id_tab,l_valid_ids_tab,NULL,NULL,NULL,NULL,NULL,NULL);
2749:
2758:
2759:
2760: --If some trips failed and some passed, return warning msg.
2761: IF ((l_error_id_tab.COUNT > 0) AND (l_error_id_tab.COUNT < p_trip_id_tab.COUNT)) THEN
2762: WSH_DEBUG_SV.logmsg(l_module_name,'Reset the return status to warn');
2763: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2764: END IF;
2765:
2766: IF l_debug_on THEN
2763: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2764: END IF;
2765:
2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: ' || x_return_status);
2768: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2769: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors: ' || l_number_of_errors);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2771: END IF;
2764: END IF;
2765:
2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: ' || x_return_status);
2768: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2769: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors: ' || l_number_of_errors);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2771: END IF;
2772:
2765:
2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: ' || x_return_status);
2768: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2769: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors: ' || l_number_of_errors);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2771: END IF;
2772:
2773: --Suppressing the detailed msg to be shown to the user
2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: ' || x_return_status);
2768: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2769: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_errors: ' || l_number_of_errors);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2771: END IF;
2772:
2773: --Suppressing the detailed msg to be shown to the user
2774: IF l_debug_on THEN
2771: END IF;
2772:
2773: --Suppressing the detailed msg to be shown to the user
2774: IF l_debug_on THEN
2775: WSH_DEBUG_SV.logmsg(l_module_name,'Clearing off unrequired messages - ' || l_msg_data);
2776: END IF;
2777: FND_MSG_PUB.initialize; -- FND messages are not sent back to the UI hence clearing the stack
2778: x_msg_data := '';
2779: x_msg_count := 0;
2801: p_data => x_msg_data,
2802: p_encoded => FND_API.G_FALSE);
2803:
2804: IF l_debug_on THEN
2805: WSH_DEBUG_SV.pop(l_module_name);
2806: END IF;
2807: EXCEPTION
2808: WHEN FND_API.G_EXC_ERROR THEN
2809: ROLLBACK TO CANCEL_TENDER_TRIPS;
2814: p_data => x_msg_data,
2815: p_encoded => FND_API.G_FALSE
2816: );
2817: IF l_debug_on THEN
2818: WSH_DEBUG_SV.pop(l_module_name);
2819: END IF;
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: ROLLBACK TO CANCEL_TENDER_TRIPS;
2822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2826: p_data => x_msg_data,
2827: p_encoded => FND_API.G_FALSE
2828: );
2829: IF l_debug_on THEN
2830: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2831: WSH_DEBUG_SV.pop(l_module_name);
2832: END IF;
2833: WHEN OTHERS THEN
2834: ROLLBACK TO CANCEL_TENDER_TRIPS;
2827: p_encoded => FND_API.G_FALSE
2828: );
2829: IF l_debug_on THEN
2830: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2831: WSH_DEBUG_SV.pop(l_module_name);
2832: END IF;
2833: WHEN OTHERS THEN
2834: ROLLBACK TO CANCEL_TENDER_TRIPS;
2835: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2839: p_data => x_msg_data,
2840: p_encoded => FND_API.G_FALSE
2841: );
2842: IF l_debug_on THEN
2843: WSH_DEBUG_SV.pop(l_module_name);
2844: END IF;
2845: END;
2846: END CANCEL_TENDER_TRIPS;
2847: --------- End of 10+ Enhancement - ajprabha
2882: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
2883: l_wsh_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2884: l_wsh_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
2885:
2886: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME ||
2888: '.' || 'TRIP_ACTION';
2889: l_result_id_tab FTE_ID_TAB_TYPE;
2890: l_valid_ids_tab FTE_ID_TAB_TYPE;
2908: x_msg_count := 0;
2909: x_msg_data := 0;
2910:
2911: IF l_debug_on THEN
2912: wsh_debug_sv.push(l_module_name);
2913: END IF;
2914:
2915: --AJPRABHA 10+
2916: IF P_ACTION_PRMS.ACTION_CODE = 'TENDER' THEN
2945: p_fte_id_tab => p_trip_id_tab,
2946: x_wsh_id_tab => l_wsh_id_tab);
2947:
2948: IF l_debug_on THEN
2949: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
2950: END IF;
2951:
2952: --Step 2: now copy action params.
2953: /** Valid Actions.
3000: l_result_id_tab,l_valid_ids_tab,null,null,null,null,null,null);
3001:
3002: -- Step 4.1 Copy wsh result id from l_wsh_out_rec to
3003: -- result id tab of x_action_out_rec
3004: WSH_DEBUG_SV.logmsg(l_module_name,'result_id_tab.count' || l_wsh_out_rec.result_id_tab.count);
3005: FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID(
3006: p_wsh_id_tab => l_wsh_out_rec.result_id_tab,
3007: x_fte_id_tab => x_action_out_rec.result_id_tab);
3008:
3008:
3009:
3010: -- Step 4.2 Copy wsh valid ids tab from l_wsh_out_rec to
3011: -- valid ids tab of x_action_out_rec
3012: WSH_DEBUG_SV.logmsg(l_module_name,'valid_ids_tab.count' || l_wsh_out_rec.valid_ids_tab.count);
3013:
3014:
3015: FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID(
3016: p_wsh_id_tab => l_wsh_out_rec.valid_ids_tab,
3028: x_fte_id_tab => x_action_out_rec.valid_ids_tab);
3029: */
3030: END IF;
3031: IF l_debug_on THEN
3032: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
3033: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3034: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3035: END IF;
3036:
3029: */
3030: END IF;
3031: IF l_debug_on THEN
3032: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
3033: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3034: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3035: END IF;
3036:
3037:
3030: END IF;
3031: IF l_debug_on THEN
3032: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
3033: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3034: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3035: END IF;
3036:
3037:
3038: FND_MSG_PUB.Count_And_Get
3043: );
3044:
3045:
3046: IF l_debug_on THEN
3047: WSH_DEBUG_SV.pop(l_module_name);
3048: END IF;
3049:
3050:
3051: EXCEPTION
3059: p_encoded => FND_API.G_FALSE
3060: );
3061:
3062: IF l_debug_on THEN
3063: WSH_DEBUG_SV.pop(l_module_name);
3064: END IF;
3065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3066: ROLLBACK TO TRIP_ACTION_PUB;
3067: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3071: p_data => x_msg_data,
3072: p_encoded => FND_API.G_FALSE
3073: );
3074: IF l_debug_on THEN
3075: WSH_DEBUG_SV.pop(l_module_name);
3076: END IF;
3077: WHEN OTHERS THEN
3078: ROLLBACK TO TRIP_ACTION_PUB;
3079: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3083: p_data => x_msg_data,
3084: p_encoded => FND_API.G_FALSE
3085: );
3086: IF l_debug_on THEN
3087: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3088: WSH_DEBUG_SV.pop(l_module_name);
3089: END IF;
3090: END Trip_Action;
3091:
3084: p_encoded => FND_API.G_FALSE
3085: );
3086: IF l_debug_on THEN
3087: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3088: WSH_DEBUG_SV.pop(l_module_name);
3089: END IF;
3090: END Trip_Action;
3091:
3092:
3131: l_number_of_warnings NUMBER;
3132: l_number_of_errors NUMBER;
3133:
3134: --
3135: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3136: --
3137: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'STOP_ACTION';
3138:
3139:
3161:
3162:
3163:
3164: IF l_debug_on THEN
3165: wsh_debug_sv.push(l_module_name);
3166: END IF;
3167:
3168: --Step 1: Copy id's to wsh id's. If there are no id's then we don't have to do
3169: -- anything. Check if shipping does this.
3174: p_fte_id_tab => p_stop_id_tab,
3175: x_wsh_id_tab => l_wsh_id_tab);
3176:
3177: IF l_debug_on THEN
3178: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
3179: END IF;
3180:
3181: --Step 2: now copy action params.
3182: /** Valid Actions.
3226: -- x_action_out_rec.selection_issue_flag := l_wsh_out_rec.selection_issue_flag;
3227:
3228:
3229: IF l_debug_on THEN
3230: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
3231: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
3232: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
3233: WSH_DEBUG_SV.logmsg(l_module_name,'data:' || l_msg_data);
3234: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_warnings ' || l_number_of_warnings);
3227:
3228:
3229: IF l_debug_on THEN
3230: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
3231: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
3232: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
3233: WSH_DEBUG_SV.logmsg(l_module_name,'data:' || l_msg_data);
3234: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_warnings ' || l_number_of_warnings);
3235: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_errors ' || l_number_of_errors);
3228:
3229: IF l_debug_on THEN
3230: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
3231: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
3232: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
3233: WSH_DEBUG_SV.logmsg(l_module_name,'data:' || l_msg_data);
3234: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_warnings ' || l_number_of_warnings);
3235: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_errors ' || l_number_of_errors);
3236: END IF;
3229: IF l_debug_on THEN
3230: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
3231: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
3232: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
3233: WSH_DEBUG_SV.logmsg(l_module_name,'data:' || l_msg_data);
3234: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_warnings ' || l_number_of_warnings);
3235: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_errors ' || l_number_of_errors);
3236: END IF;
3237:
3230: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.After calling stop action');
3231: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
3232: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
3233: WSH_DEBUG_SV.logmsg(l_module_name,'data:' || l_msg_data);
3234: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_warnings ' || l_number_of_warnings);
3235: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_errors ' || l_number_of_errors);
3236: END IF;
3237:
3238:
3231: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
3232: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
3233: WSH_DEBUG_SV.logmsg(l_module_name,'data:' || l_msg_data);
3234: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_warnings ' || l_number_of_warnings);
3235: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_errors ' || l_number_of_errors);
3236: END IF;
3237:
3238:
3239: wsh_util_core.api_post_call(
3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3255: END IF;
3256:
3257: IF l_debug_on THEN
3258: WSH_DEBUG_SV.logmsg(l_module_name,' After count and get');
3259: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3260: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3261: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
3262: END IF;
3255: END IF;
3256:
3257: IF l_debug_on THEN
3258: WSH_DEBUG_SV.logmsg(l_module_name,' After count and get');
3259: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3260: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3261: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
3262: END IF;
3263:
3256:
3257: IF l_debug_on THEN
3258: WSH_DEBUG_SV.logmsg(l_module_name,' After count and get');
3259: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3260: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3261: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
3262: END IF;
3263:
3264:
3257: IF l_debug_on THEN
3258: WSH_DEBUG_SV.logmsg(l_module_name,' After count and get');
3259: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3260: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3261: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
3262: END IF;
3263:
3264:
3265: FND_MSG_PUB.Count_And_Get
3272:
3273:
3274:
3275: IF l_debug_on THEN
3276: WSH_DEBUG_SV.pop(l_module_name);
3277: END IF;
3278:
3279:
3280: EXCEPTION
3287: p_data => x_msg_data,
3288: p_encoded => FND_API.G_FALSE
3289: );
3290: IF l_debug_on THEN
3291: WSH_DEBUG_SV.pop(l_module_name);
3292: END IF;
3293:
3294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3295: ROLLBACK TO STOP_ACTION_PUB;
3300: p_data => x_msg_data,
3301: p_encoded => FND_API.G_FALSE
3302: );
3303: IF l_debug_on THEN
3304: WSH_DEBUG_SV.pop(l_module_name);
3305: END IF;
3306: WHEN OTHERS THEN
3307: ROLLBACK TO STOP_ACTION_PUB;
3308: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3312: p_data => x_msg_data,
3313: p_encoded => FND_API.G_FALSE
3314: );
3315: IF l_debug_on THEN
3316: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3317: WSH_DEBUG_SV.pop(l_module_name);
3318: END IF;
3319:
3320: END STOP_ACTION;
3313: p_encoded => FND_API.G_FALSE
3314: );
3315: IF l_debug_on THEN
3316: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3317: WSH_DEBUG_SV.pop(l_module_name);
3318: END IF;
3319:
3320: END STOP_ACTION;
3321:
3345: x_msg_data OUT NOCOPY VARCHAR2
3346: ) IS
3347:
3348:
3349: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3350: --
3351: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'INIT_STOPS_PLS_TABLE';
3352:
3353:
3369: x_msg_count := 0;
3370: x_msg_data := 0;
3371:
3372: IF l_debug_on THEN
3373: wsh_debug_sv.push(l_module_name);
3374: END IF;
3375:
3376:
3377:
3378: FTE_MLS_WRAPPER.G_STOPS_TAB_REC.delete;
3379: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB.delete;
3380:
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_TAB_REC ' );
3383: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_SEQ_TAB ' );
3384: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3386: END IF;
3379: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB.delete;
3380:
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_TAB_REC ' );
3383: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_SEQ_TAB ' );
3384: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3386: END IF;
3387:
3380:
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_TAB_REC ' );
3383: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_SEQ_TAB ' );
3384: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3386: END IF;
3387:
3388:
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_TAB_REC ' );
3383: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_SEQ_TAB ' );
3384: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3386: END IF;
3387:
3388:
3389: FND_MSG_PUB.Count_And_Get
3394: );
3395:
3396:
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.pop(l_module_name);
3399: END IF;
3400:
3401:
3402: EXCEPTION
3409: p_data => x_msg_data,
3410: p_encoded => FND_API.G_FALSE
3411: );
3412: IF l_debug_on THEN
3413: WSH_DEBUG_SV.pop(l_module_name);
3414: END IF;
3415:
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: ROLLBACK TO INIT_STOPS_PLS_TABLE_PUB;
3422: p_data => x_msg_data,
3423: p_encoded => FND_API.G_FALSE
3424: );
3425: IF l_debug_on THEN
3426: WSH_DEBUG_SV.pop(l_module_name);
3427: END IF;
3428: WHEN OTHERS THEN
3429: ROLLBACK TO INIT_STOPS_PLS_TABLE_PUB;
3430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3434: p_data => x_msg_data,
3435: p_encoded => FND_API.G_FALSE
3436: );
3437: IF l_debug_on THEN
3438: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3439: WSH_DEBUG_SV.pop(l_module_name);
3440: END IF;
3441:
3442: END INIT_STOPS_PLS_TABLE;
3435: p_encoded => FND_API.G_FALSE
3436: );
3437: IF l_debug_on THEN
3438: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3439: WSH_DEBUG_SV.pop(l_module_name);
3440: END IF;
3441:
3442: END INIT_STOPS_PLS_TABLE;
3443:
3467: x_msg_count OUT NOCOPY NUMBER,
3468: x_msg_data OUT NOCOPY VARCHAR2)
3469: IS
3470:
3471: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3472: --
3473: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'PROCESS_STOPS';
3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3508: l_number_of_errors := 0;
3509:
3510:
3511: IF l_debug_on THEN
3512: wsh_debug_sv.push(l_module_name);
3513: END IF;
3514:
3515: -- sort stops based on old sequence
3516: -- sort values in G_STOPS_SEQ_TAB
3515: -- sort stops based on old sequence
3516: -- sort values in G_STOPS_SEQ_TAB
3517:
3518: IF l_debug_on THEN
3519: WSH_DEBUG_SV.logmsg(l_module_name,' ......................... ');
3520: WSH_DEBUG_SV.logmsg(l_module_name,' Number of Records in Glocal Stop Table ' ||
3521: G_STOPS_TAB_REC.count);
3522: WSH_DEBUG_SV.logmsg(l_module_name,' Number of Records in Global Stop Seq ' ||
3523: G_STOPS_SEQ_TAB.count);
3516: -- sort values in G_STOPS_SEQ_TAB
3517:
3518: IF l_debug_on THEN
3519: WSH_DEBUG_SV.logmsg(l_module_name,' ......................... ');
3520: WSH_DEBUG_SV.logmsg(l_module_name,' Number of Records in Glocal Stop Table ' ||
3521: G_STOPS_TAB_REC.count);
3522: WSH_DEBUG_SV.logmsg(l_module_name,' Number of Records in Global Stop Seq ' ||
3523: G_STOPS_SEQ_TAB.count);
3524:
3518: IF l_debug_on THEN
3519: WSH_DEBUG_SV.logmsg(l_module_name,' ......................... ');
3520: WSH_DEBUG_SV.logmsg(l_module_name,' Number of Records in Glocal Stop Table ' ||
3521: G_STOPS_TAB_REC.count);
3522: WSH_DEBUG_SV.logmsg(l_module_name,' Number of Records in Global Stop Seq ' ||
3523: G_STOPS_SEQ_TAB.count);
3524:
3525: END IF;
3526:
3529:
3530:
3531: IF l_debug_on THEN
3532:
3533: WSH_DEBUG_SV.logmsg(l_module_name,' Printing all stops ');
3534:
3535: IF G_STOPS_TAB_REC.count > 0
3536: THEN
3537:
3538: l_index := G_STOPS_TAB_REC.LAST;
3539: l_idx := 1;
3540: WHILE l_index IS NOT NULL
3541: LOOP
3542: WSH_DEBUG_SV.logmsg(l_module_name,' Index ' || l_index);
3543: l_index := G_STOPS_TAB_REC.PRIOR(l_index);
3544: END LOOP;
3545: END IF;
3546:
3559:
3560: l_stop_info := FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_index);
3561:
3562: IF l_debug_on THEN
3563: WSH_DEBUG_SV.logmsg(l_module_name, ' Index ' || l_index);
3564: WSH_DEBUG_SV.logmsg(l_module_name,' stop seq ' || l_stop_info.STOP_SEQUENCE_NUMBER);
3565: WSH_DEBUG_SV.logmsg(l_module_name,' stop id ' || l_stop_info.STOP_ID);
3566: END IF;
3567:
3560: l_stop_info := FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_index);
3561:
3562: IF l_debug_on THEN
3563: WSH_DEBUG_SV.logmsg(l_module_name, ' Index ' || l_index);
3564: WSH_DEBUG_SV.logmsg(l_module_name,' stop seq ' || l_stop_info.STOP_SEQUENCE_NUMBER);
3565: WSH_DEBUG_SV.logmsg(l_module_name,' stop id ' || l_stop_info.STOP_ID);
3566: END IF;
3567:
3568: /** Changes based on the wsh stop seq changes
3561:
3562: IF l_debug_on THEN
3563: WSH_DEBUG_SV.logmsg(l_module_name, ' Index ' || l_index);
3564: WSH_DEBUG_SV.logmsg(l_module_name,' stop seq ' || l_stop_info.STOP_SEQUENCE_NUMBER);
3565: WSH_DEBUG_SV.logmsg(l_module_name,' stop id ' || l_stop_info.STOP_ID);
3566: END IF;
3567:
3568: /** Changes based on the wsh stop seq changes
3569: l_stop_info.STOP_SEQUENCE_NUMBER :=
3649: );
3650:
3651:
3652: IF l_debug_on THEN
3653: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3654: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3655: END IF;
3656:
3657: IF l_debug_on THEN
3650:
3651:
3652: IF l_debug_on THEN
3653: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3654: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3655: END IF;
3656:
3657: IF l_debug_on THEN
3658: WSH_DEBUG_SV.pop(l_module_name);
3654: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3655: END IF;
3656:
3657: IF l_debug_on THEN
3658: WSH_DEBUG_SV.pop(l_module_name);
3659: END IF;
3660:
3661:
3662: EXCEPTION
3669: p_data => x_msg_data,
3670: p_encoded => FND_API.G_FALSE
3671: );
3672: IF l_debug_on THEN
3673: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3674: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3675: WSH_DEBUG_SV.pop(l_module_name);
3676: END IF;
3677:
3670: p_encoded => FND_API.G_FALSE
3671: );
3672: IF l_debug_on THEN
3673: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3674: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3675: WSH_DEBUG_SV.pop(l_module_name);
3676: END IF;
3677:
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3671: );
3672: IF l_debug_on THEN
3673: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3674: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3675: WSH_DEBUG_SV.pop(l_module_name);
3676: END IF;
3677:
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: ROLLBACK TO PROCESS_STOPS_PUB;
3684: p_data => x_msg_data,
3685: p_encoded => FND_API.G_FALSE
3686: );
3687: IF l_debug_on THEN
3688: WSH_DEBUG_SV.pop(l_module_name);
3689: END IF;
3690: WHEN OTHERS THEN
3691: ROLLBACK TO PROCESS_STOPS_PUB;
3692: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3691: ROLLBACK TO PROCESS_STOPS_PUB;
3692: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3693: x_msg_data := substr(sqlerrm,1,200);
3694: IF l_debug_on THEN
3695: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3696: WSH_DEBUG_SV.pop(l_module_name);
3697: END IF;
3698:
3699: FND_MSG_PUB.Count_And_Get
3692: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3693: x_msg_data := substr(sqlerrm,1,200);
3694: IF l_debug_on THEN
3695: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3696: WSH_DEBUG_SV.pop(l_module_name);
3697: END IF;
3698:
3699: FND_MSG_PUB.Count_And_Get
3700: (
3732: x_return_status OUT NOCOPY VARCHAR2,
3733: x_msg_count OUT NOCOPY NUMBER,
3734: x_msg_data OUT NOCOPY VARCHAR2) IS
3735:
3736: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3737: --
3738: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
3739:
3740: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3766: l_number_of_warnings := 0;
3767: l_number_of_errors := 0;
3768:
3769: IF l_debug_on THEN
3770: wsh_debug_sv.push(l_module_name);
3771: END IF;
3772:
3773:
3774: IF l_debug_on THEN
3771: END IF;
3772:
3773:
3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.logmsg(l_module_name,
3776: ' Stop Planned Departure Date ' || p_rec_attr_tab(1).planned_departure_date,
3777: WSH_DEBUG_SV.C_PROC_LEVEL);
3778: WSH_DEBUG_SV.logmsg(l_module_name,
3779: ' Stop Planned Arrival Date ' || p_rec_attr_tab(1).planned_arrival_date,
3773:
3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.logmsg(l_module_name,
3776: ' Stop Planned Departure Date ' || p_rec_attr_tab(1).planned_departure_date,
3777: WSH_DEBUG_SV.C_PROC_LEVEL);
3778: WSH_DEBUG_SV.logmsg(l_module_name,
3779: ' Stop Planned Arrival Date ' || p_rec_attr_tab(1).planned_arrival_date,
3780: WSH_DEBUG_SV.C_PROC_LEVEL);
3781: END IF;
3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.logmsg(l_module_name,
3776: ' Stop Planned Departure Date ' || p_rec_attr_tab(1).planned_departure_date,
3777: WSH_DEBUG_SV.C_PROC_LEVEL);
3778: WSH_DEBUG_SV.logmsg(l_module_name,
3779: ' Stop Planned Arrival Date ' || p_rec_attr_tab(1).planned_arrival_date,
3780: WSH_DEBUG_SV.C_PROC_LEVEL);
3781: END IF;
3782:
3776: ' Stop Planned Departure Date ' || p_rec_attr_tab(1).planned_departure_date,
3777: WSH_DEBUG_SV.C_PROC_LEVEL);
3778: WSH_DEBUG_SV.logmsg(l_module_name,
3779: ' Stop Planned Arrival Date ' || p_rec_attr_tab(1).planned_arrival_date,
3780: WSH_DEBUG_SV.C_PROC_LEVEL);
3781: END IF;
3782:
3783: WSH_INTERFACE_GRP.Create_Update_Stop(p_api_version_number=>p_api_version_number,
3784: p_init_msg_list=>FND_API.G_FALSE,
3814: p_encoded => FND_API.G_FALSE
3815: );
3816:
3817: IF l_debug_on THEN
3818: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3819: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3820: END IF;
3821:
3822: IF l_debug_on THEN
3815: );
3816:
3817: IF l_debug_on THEN
3818: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3819: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3820: END IF;
3821:
3822: IF l_debug_on THEN
3823: WSH_DEBUG_SV.pop(l_module_name);
3819: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3820: END IF;
3821:
3822: IF l_debug_on THEN
3823: WSH_DEBUG_SV.pop(l_module_name);
3824: END IF;
3825:
3826:
3827: EXCEPTION
3834: p_data => x_msg_data,
3835: p_encoded => FND_API.G_FALSE
3836: );
3837: IF l_debug_on THEN
3838: WSH_DEBUG_SV.pop(l_module_name);
3839: END IF;
3840:
3841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3842: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
3847: p_data => x_msg_data,
3848: p_encoded => FND_API.G_FALSE
3849: );
3850: IF l_debug_on THEN
3851: WSH_DEBUG_SV.pop(l_module_name);
3852: END IF;
3853: WHEN OTHERS THEN
3854: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
3855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3859: p_data => x_msg_data,
3860: p_encoded => FND_API.G_FALSE
3861: );
3862: IF l_debug_on THEN
3863: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3864: WSH_DEBUG_SV.pop(l_module_name);
3865: END IF;
3866:
3867: END CREATE_UPDATE_STOP;
3860: p_encoded => FND_API.G_FALSE
3861: );
3862: IF l_debug_on THEN
3863: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3864: WSH_DEBUG_SV.pop(l_module_name);
3865: END IF;
3866:
3867: END CREATE_UPDATE_STOP;
3868:
3875: x_msg_count OUT NOCOPY NUMBER,
3876: x_msg_data OUT NOCOPY VARCHAR2
3877: ) AS
3878:
3879: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3880: --
3881: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'REPRICE_TRIP';
3882:
3883: l_action_params FTE_TRIP_RATING_GRP.action_param_rec;
3909: l_number_of_warnings := 0;
3910: l_number_of_errors := 0;
3911:
3912: IF l_debug_on THEN
3913: wsh_debug_sv.push(l_module_name);
3914: WSH_DEBUG_SV.logmsg(l_module_name,' trip id ' || p_trip_id);
3915: END IF;
3916:
3917: l_trip_id_list(1) := p_trip_id;
3910: l_number_of_errors := 0;
3911:
3912: IF l_debug_on THEN
3913: wsh_debug_sv.push(l_module_name);
3914: WSH_DEBUG_SV.logmsg(l_module_name,' trip id ' || p_trip_id);
3915: END IF;
3916:
3917: l_trip_id_list(1) := p_trip_id;
3918: l_action_params.caller := 'FTE';
3954: p_encoded => FND_API.G_FALSE
3955: );
3956:
3957: IF l_debug_on THEN
3958: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3959: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3960: END IF;
3961:
3962: IF l_debug_on THEN
3955: );
3956:
3957: IF l_debug_on THEN
3958: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
3959: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3960: END IF;
3961:
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.pop(l_module_name);
3959: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3960: END IF;
3961:
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.pop(l_module_name);
3964: END IF;
3965:
3966:
3967: EXCEPTION
3974: p_data => x_msg_data,
3975: p_encoded => FND_API.G_FALSE
3976: );
3977: IF l_debug_on THEN
3978: WSH_DEBUG_SV.pop(l_module_name);
3979: END IF;
3980:
3981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3982: ROLLBACK TO REPRICE_TRIP_PUB;
3987: p_data => x_msg_data,
3988: p_encoded => FND_API.G_FALSE
3989: );
3990: IF l_debug_on THEN
3991: WSH_DEBUG_SV.pop(l_module_name);
3992: END IF;
3993: WHEN OTHERS THEN
3994: ROLLBACK TO REPRICE_TRIP_PUB;
3995: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3999: p_data => x_msg_data,
4000: p_encoded => FND_API.G_FALSE
4001: );
4002: IF l_debug_on THEN
4003: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
4004: WSH_DEBUG_SV.pop(l_module_name);
4005: END IF;
4006:
4007: END REPRICE_TRIP;
4000: p_encoded => FND_API.G_FALSE
4001: );
4002: IF l_debug_on THEN
4003: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
4004: WSH_DEBUG_SV.pop(l_module_name);
4005: END IF;
4006:
4007: END REPRICE_TRIP;
4008: --
4037: l_split_quantity2 NUMBER;
4038: l_caller VARCHAR(100);
4039:
4040: --
4041: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4042: --
4043: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_DETAIL_ACTION';
4044:
4045:
4061: x_msg_count := 0;
4062: x_msg_data := 0;
4063:
4064: IF l_debug_on THEN
4065: wsh_debug_sv.push(l_module_name);
4066: END IF;
4067:
4068: -- set action_prms
4069:
4074: l_caller := p_action_params.caller;
4075: END IF;
4076:
4077: IF l_debug_on THEN
4078: WSH_DEBUG_SV.logmsg(l_module_name,'CALLER:' || l_caller);
4079: END IF;
4080:
4081: l_action_prms.caller := l_caller;
4082: l_action_prms.action_code := p_action_params.action_code;
4152: l_split_quantity := l_detail_out_rec.split_quantity2;
4153:
4154:
4155: IF l_debug_on THEN
4156: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
4157: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4158: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4159: END IF;
4160:
4153:
4154:
4155: IF l_debug_on THEN
4156: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
4157: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4158: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4159: END IF;
4160:
4161:
4154:
4155: IF l_debug_on THEN
4156: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
4157: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4158: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4159: END IF;
4160:
4161:
4162: FND_MSG_PUB.Count_And_Get
4167: );
4168:
4169:
4170: IF l_debug_on THEN
4171: WSH_DEBUG_SV.pop(l_module_name);
4172: END IF;
4173:
4174: EXCEPTION
4175: WHEN FND_API.G_EXC_ERROR THEN
4182: p_encoded => FND_API.G_FALSE
4183: );
4184:
4185: IF l_debug_on THEN
4186: WSH_DEBUG_SV.pop(l_module_name);
4187: END IF;
4188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4189: ROLLBACK TO DETAIL_ACTION_PUB;
4190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4194: p_data => x_msg_data,
4195: p_encoded => FND_API.G_FALSE
4196: );
4197: IF l_debug_on THEN
4198: WSH_DEBUG_SV.pop(l_module_name);
4199: END IF;
4200: WHEN OTHERS THEN
4201: ROLLBACK TO DETAIL_ACTION_PUB;
4202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4206: p_data => x_msg_data,
4207: p_encoded => FND_API.G_FALSE
4208: );
4209: IF l_debug_on THEN
4210: WSH_DEBUG_SV.pop(l_module_name);
4211: END IF;
4212:
4213:
4214:
4238: l_detail_in_rec wsh_glbl_var_strct_grp.detailInRecType;
4239: l_detail_out_rec wsh_glbl_var_strct_grp.detailOutRecType;
4240: l_fte_detail_attr_rec FTE_DDL_ATTR_REC;
4241:
4242: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4243: --
4244: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DDL';
4245:
4246:
4262: x_msg_count := 0;
4263: x_msg_data := 0;
4264:
4265: IF l_debug_on THEN
4266: wsh_debug_sv.push(l_module_name);
4267: END IF;
4268:
4269: -- Extract detailsAttrRec from table - table should only have one row
4270: -- 188 Attributes mapped
4486:
4487: -- Handle detailsOutRec
4488:
4489: IF l_debug_on THEN
4490: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4491: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4492: END IF;
4493:
4494: FND_MSG_PUB.Count_And_Get
4487: -- Handle detailsOutRec
4488:
4489: IF l_debug_on THEN
4490: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4491: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4492: END IF;
4493:
4494: FND_MSG_PUB.Count_And_Get
4495: (
4499: );
4500:
4501:
4502: IF l_debug_on THEN
4503: WSH_DEBUG_SV.pop(l_module_name);
4504: END IF;
4505:
4506:
4507: EXCEPTION
4515: p_encoded => FND_API.G_FALSE
4516: );
4517:
4518: IF l_debug_on THEN
4519: WSH_DEBUG_SV.pop(l_module_name);
4520: END IF;
4521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4522: ROLLBACK TO DDL_CREATE_UPDATE_PUB;
4523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4527: p_data => x_msg_data,
4528: p_encoded => FND_API.G_FALSE
4529: );
4530: IF l_debug_on THEN
4531: WSH_DEBUG_SV.pop(l_module_name);
4532: END IF;
4533: WHEN OTHERS THEN
4534: ROLLBACK TO DDL_CREATE_UPDATE_PUB;
4535: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4539: p_data => x_msg_data,
4540: p_encoded => FND_API.G_FALSE
4541: );
4542: IF l_debug_on THEN
4543: WSH_DEBUG_SV.pop(l_module_name);
4544: END IF;
4545: --
4546:
4547: END Create_Update_Delivery_Detail;
4585: l_msg_data VARCHAR2(32767);
4586:
4587:
4588: --
4589: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4590: --
4591: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_ACTION';
4592:
4593:
4621:
4622:
4623:
4624: IF l_debug_on THEN
4625: wsh_debug_sv.push(l_module_name);
4626: END IF;
4627:
4628: -- set action_prms
4629: l_action_prms.caller := G_PKG_NAME;
4682: );
4683:
4684:
4685: IF l_debug_on THEN
4686: WSH_DEBUG_SV.logmsg(l_module_name,' Return Message ' || l_return_status );
4687: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_data ' || l_msg_data );
4688: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_count ' || l_msg_count );
4689: END IF;
4690:
4683:
4684:
4685: IF l_debug_on THEN
4686: WSH_DEBUG_SV.logmsg(l_module_name,' Return Message ' || l_return_status );
4687: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_data ' || l_msg_data );
4688: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_count ' || l_msg_count );
4689: END IF;
4690:
4691:
4684:
4685: IF l_debug_on THEN
4686: WSH_DEBUG_SV.logmsg(l_module_name,' Return Message ' || l_return_status );
4687: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_data ' || l_msg_data );
4688: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_count ' || l_msg_count );
4689: END IF;
4690:
4691:
4692: wsh_util_core.api_post_call(
4722: -- set selection issue flag
4723: l_selection_issue_flag := l_delivery_out_rec.selection_issue_flag;
4724:
4725: IF l_debug_on THEN
4726: WSH_DEBUG_SV.logmsg(l_module_name,'Return Count ' || x_action_out_rec.result_id_tab.count);
4727:
4728:
4729: FOR stop_info_rec IN stop_info (p_action_params.trip_id)
4730: LOOP
4728:
4729: FOR stop_info_rec IN stop_info (p_action_params.trip_id)
4730: LOOP
4731: --{
4732: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || stop_info_rec.stop_id);
4733: WSH_DEBUG_SV.logmsg(l_module_name,' Planned Arrival Date ' || stop_info_rec.planned_arrival_date);
4734: WSH_DEBUG_SV.logmsg(l_module_name,' Planned departure date ' || stop_info_rec.planned_departure_date);
4735: --}
4736: END LOOP;
4729: FOR stop_info_rec IN stop_info (p_action_params.trip_id)
4730: LOOP
4731: --{
4732: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || stop_info_rec.stop_id);
4733: WSH_DEBUG_SV.logmsg(l_module_name,' Planned Arrival Date ' || stop_info_rec.planned_arrival_date);
4734: WSH_DEBUG_SV.logmsg(l_module_name,' Planned departure date ' || stop_info_rec.planned_departure_date);
4735: --}
4736: END LOOP;
4737:
4730: LOOP
4731: --{
4732: WSH_DEBUG_SV.logmsg(l_module_name,' Stop Id ' || stop_info_rec.stop_id);
4733: WSH_DEBUG_SV.logmsg(l_module_name,' Planned Arrival Date ' || stop_info_rec.planned_arrival_date);
4734: WSH_DEBUG_SV.logmsg(l_module_name,' Planned departure date ' || stop_info_rec.planned_departure_date);
4735: --}
4736: END LOOP;
4737:
4738: END IF;
4747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4748: END IF;
4749:
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4752: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4753: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
4754: END IF;
4755:
4748: END IF;
4749:
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4752: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4753: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
4754: END IF;
4755:
4756:
4749:
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4752: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4753: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
4754: END IF;
4755:
4756:
4757: /**
4764: */
4765:
4766:
4767: IF l_debug_on THEN
4768: WSH_DEBUG_SV.pop(l_module_name);
4769: END IF;
4770:
4771:
4772: EXCEPTION
4780: p_encoded => FND_API.G_FALSE
4781: );
4782:
4783: IF l_debug_on THEN
4784: WSH_DEBUG_SV.pop(l_module_name);
4785: END IF;
4786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4787: ROLLBACK TO DELIVERY_ACTION_PUB;
4788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4792: p_data => x_msg_data,
4793: p_encoded => FND_API.G_FALSE
4794: );
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.pop(l_module_name);
4797: END IF;
4798: WHEN OTHERS THEN
4799: ROLLBACK TO DELIVERY_ACTION_PUB;
4800: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4804: p_data => x_msg_data,
4805: p_encoded => FND_API.G_FALSE
4806: );
4807: IF l_debug_on THEN
4808: WSH_DEBUG_SV.pop(l_module_name);
4809: END IF;
4810:
4811:
4812: --
4853: l_number_of_errors NUMBER;
4854: l_number_valid NUMBER;
4855:
4856: --
4857: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4858: --
4859: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_ACTION_ON_TRIP';
4860:
4861:
4880: l_number_of_errors := 0;
4881: l_number_valid := 1;
4882:
4883: IF l_debug_on THEN
4884: wsh_debug_sv.push(l_module_name);
4885: END IF;
4886:
4887: x_result_id_tab := FTE_ID_TAB_TYPE();
4888: x_valid_id_tab := FTE_ID_TAB_TYPE();
4933: -- set selection issue flag
4934: l_selection_issue_flag := l_delivery_out_rec.selection_issue_flag;
4935:
4936: IF l_debug_on THEN
4937: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
4938: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
4939: END IF;
4940:
4941: x_msg_count := x_msg_count+l_msg_count;
4934: l_selection_issue_flag := l_delivery_out_rec.selection_issue_flag;
4935:
4936: IF l_debug_on THEN
4937: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
4938: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
4939: END IF;
4940:
4941: x_msg_count := x_msg_count+l_msg_count;
4942: --x_msg_data := x_msg_data||' '||l_msg_data;
4943:
4944: END LOOP;
4945:
4946: IF l_debug_on THEN
4947: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count total:' || x_msg_count);
4948: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data total:' || x_msg_data);
4949: END IF;
4950:
4951: IF l_debug_on THEN
4944: END LOOP;
4945:
4946: IF l_debug_on THEN
4947: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count total:' || x_msg_count);
4948: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data total:' || x_msg_data);
4949: END IF;
4950:
4951: IF l_debug_on THEN
4952: WSH_DEBUG_SV.logmsg(l_module_name,'x_valid_id count:' || x_valid_id_tab.count);
4948: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data total:' || x_msg_data);
4949: END IF;
4950:
4951: IF l_debug_on THEN
4952: WSH_DEBUG_SV.logmsg(l_module_name,'x_valid_id count:' || x_valid_id_tab.count);
4953: END IF;
4954:
4955:
4956: x_action_out_rec := FTE_ACTION_OUT_REC(
4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4970: END IF;
4971:
4972: IF l_debug_on THEN
4973: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status count:' || x_return_status);
4974: END IF;
4975:
4976: IF l_debug_on THEN
4977: WSH_DEBUG_SV.pop(l_module_name);
4973: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status count:' || x_return_status);
4974: END IF;
4975:
4976: IF l_debug_on THEN
4977: WSH_DEBUG_SV.pop(l_module_name);
4978: END IF;
4979:
4980:
4981: EXCEPTION
4988: p_data => x_msg_data,
4989: p_encoded => FND_API.G_FALSE
4990: );
4991: IF l_debug_on THEN
4992: WSH_DEBUG_SV.pop(l_module_name);
4993: END IF;
4994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4995: ROLLBACK TO DELIVERY_ACTION_ON_TRIP_PUB;
4996: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5000: p_data => x_msg_data,
5001: p_encoded => FND_API.G_FALSE
5002: );
5003: IF l_debug_on THEN
5004: WSH_DEBUG_SV.pop(l_module_name);
5005: END IF;
5006: WHEN OTHERS THEN
5007: ROLLBACK TO DELIVERY_ACTION_ON_TRIP_PUB;
5008: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5012: p_data => x_msg_data,
5013: p_encoded => FND_API.G_FALSE
5014: );
5015: IF l_debug_on THEN
5016: WSH_DEBUG_SV.pop(l_module_name);
5017: END IF;
5018:
5019:
5020:
5047: l_dlvy_out_rec WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
5048: l_fte_dlvy_attr_rec FTE_DLV_ATTR_REC;
5049:
5050: --
5051: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5052: --
5053: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DLVY';
5054:
5055:
5071: x_msg_count := 0;
5072: x_msg_data := 0;
5073:
5074: IF l_debug_on THEN
5075: wsh_debug_sv.push(l_module_name);
5076: END IF;
5077:
5078: -- Extract delivery_rec_type from table - table should only have one row
5079: -- 153 Attributes mapped
5238: END LOOP;
5239: END IF;
5240:
5241: IF l_debug_on THEN
5242: WSH_DEBUG_SV.logmsg(l_module_name,'DeliveryId:' || l_dlvy_attr_rec.DELIVERY_ID);
5243: WSH_DEBUG_SV.logmsg(l_module_name,'ProrateWtFlag:' || l_dlvy_attr_rec.PRORATE_WT_FLAG);
5244: END IF;
5245:
5246:
5239: END IF;
5240:
5241: IF l_debug_on THEN
5242: WSH_DEBUG_SV.logmsg(l_module_name,'DeliveryId:' || l_dlvy_attr_rec.DELIVERY_ID);
5243: WSH_DEBUG_SV.logmsg(l_module_name,'ProrateWtFlag:' || l_dlvy_attr_rec.PRORATE_WT_FLAG);
5244: END IF;
5245:
5246:
5247: -- Create details_attr_tab_type
5271: rowid VARCHAR2(4000));
5272: */
5273:
5274: IF l_debug_on THEN
5275: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5276: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
5277: END IF;
5278:
5279: FND_MSG_PUB.Count_And_Get
5272: */
5273:
5274: IF l_debug_on THEN
5275: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5276: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
5277: END IF;
5278:
5279: FND_MSG_PUB.Count_And_Get
5280: (
5284: );
5285:
5286:
5287: IF l_debug_on THEN
5288: WSH_DEBUG_SV.pop(l_module_name);
5289: END IF;
5290:
5291:
5292: EXCEPTION
5300: p_encoded => FND_API.G_FALSE
5301: );
5302:
5303: IF l_debug_on THEN
5304: WSH_DEBUG_SV.pop(l_module_name);
5305: END IF;
5306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5307: ROLLBACK TO DELIVERY_CREATE_UPDATE_PUB;
5308: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5312: p_data => x_msg_data,
5313: p_encoded => FND_API.G_FALSE
5314: );
5315: IF l_debug_on THEN
5316: WSH_DEBUG_SV.pop(l_module_name);
5317: END IF;
5318: WHEN OTHERS THEN
5319: ROLLBACK TO DELIVERY_CREATE_UPDATE_PUB;
5320: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5324: p_data => x_msg_data,
5325: p_encoded => FND_API.G_FALSE
5326: );
5327: IF l_debug_on THEN
5328: WSH_DEBUG_SV.pop(l_module_name);
5329: END IF;
5330: --
5331: END CREATE_UPDATE_DELIVERY;
5332: --
5363: l_number_of_warnings NUMBER;
5364: l_number_of_errors NUMBER;
5365:
5366: --
5367: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5368: --
5369: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'EXCEPTION_ACTION';
5370:
5371:
5389: l_number_of_warnings := 0;
5390: l_number_of_errors := 0;
5391:
5392: IF l_debug_on THEN
5393: wsh_debug_sv.push(l_module_name);
5394: END IF;
5395:
5396: -- Iteratively loop through each rec in the tab and call WSH API
5397: x_result_id_tab := FTE_ID_TAB_TYPE();
5493: p_msg_data =>l_msg_data,
5494: p_raise_error_flag =>FALSE);
5495:
5496: IF l_debug_on THEN
5497: WSH_DEBUG_SV.logmsg(l_module_name,'entity_id:' || l_exception_action_param_rec.logging_entity_id);
5498: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
5499: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
5500: END IF;
5501:
5494: p_raise_error_flag =>FALSE);
5495:
5496: IF l_debug_on THEN
5497: WSH_DEBUG_SV.logmsg(l_module_name,'entity_id:' || l_exception_action_param_rec.logging_entity_id);
5498: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
5499: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
5500: END IF;
5501:
5502: -- set the return params
5495:
5496: IF l_debug_on THEN
5497: WSH_DEBUG_SV.logmsg(l_module_name,'entity_id:' || l_exception_action_param_rec.logging_entity_id);
5498: WSH_DEBUG_SV.logmsg(l_module_name,'l_return_status:' || l_return_status);
5499: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count:' || l_msg_count);
5500: END IF;
5501:
5502: -- set the return params
5503: x_msg_count := x_msg_count+l_msg_count;
5518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5519: END IF;
5520:
5521: IF l_debug_on THEN
5522: WSH_DEBUG_SV.logmsg(l_module_name,'x_valid_id_tab.count:' || x_valid_id_tab.count);
5523: WSH_DEBUG_SV.logmsg(l_module_name,'p_xc_action_tab.count:' || p_xc_action_tab.count);
5524: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5525: END IF;
5526:
5519: END IF;
5520:
5521: IF l_debug_on THEN
5522: WSH_DEBUG_SV.logmsg(l_module_name,'x_valid_id_tab.count:' || x_valid_id_tab.count);
5523: WSH_DEBUG_SV.logmsg(l_module_name,'p_xc_action_tab.count:' || p_xc_action_tab.count);
5524: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5525: END IF;
5526:
5527: /**
5520:
5521: IF l_debug_on THEN
5522: WSH_DEBUG_SV.logmsg(l_module_name,'x_valid_id_tab.count:' || x_valid_id_tab.count);
5523: WSH_DEBUG_SV.logmsg(l_module_name,'p_xc_action_tab.count:' || p_xc_action_tab.count);
5524: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5525: END IF;
5526:
5527: /**
5528: FND_MSG_PUB.Count_And_Get
5536: x_action_out_rec := FTE_ACTION_OUT_REC(
5537: x_result_id_tab,x_valid_id_tab,null,null,null,null,null,null);
5538:
5539: IF l_debug_on THEN
5540: WSH_DEBUG_SV.pop(l_module_name);
5541: END IF;
5542:
5543:
5544: EXCEPTION
5552: p_encoded => FND_API.G_FALSE
5553: );
5554:
5555: IF l_debug_on THEN
5556: WSH_DEBUG_SV.pop(l_module_name);
5557: END IF;
5558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5559: ROLLBACK TO EXCEPTION_ACTION_PUB;
5560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5564: p_data => x_msg_data,
5565: p_encoded => FND_API.G_FALSE
5566: );
5567: IF l_debug_on THEN
5568: WSH_DEBUG_SV.pop(l_module_name);
5569: END IF;
5570: WHEN OTHERS THEN
5571: ROLLBACK TO EXCEPTION_ACTION_PUB;
5572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5576: p_data => x_msg_data,
5577: p_encoded => FND_API.G_FALSE
5578: );
5579: IF l_debug_on THEN
5580: WSH_DEBUG_SV.pop(l_module_name);
5581: END IF;
5582: END EXCEPTION_ACTION;
5583:
5584: --
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec
5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab
5609: --
5610: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5611: --
5612: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'GROUP_DETAIL_SEARCH_DLVY';
5613:
5614:
5630: x_msg_count := 0;
5631: x_msg_data := 0;
5632:
5633: IF l_debug_on THEN
5634: wsh_debug_sv.push(l_module_name);
5635: END IF;
5636:
5637: -- Create DetailIdTab
5638: FOR i IN p_id_tab.FIRST..p_id_tab.LAST LOOP
5691: p_encoded => FND_API.G_FALSE
5692: );
5693:
5694: IF l_debug_on THEN
5695: WSH_DEBUG_SV.pop(l_module_name);
5696: END IF;
5697:
5698: EXCEPTION
5699: WHEN FND_API.G_EXC_ERROR THEN
5706: p_encoded => FND_API.G_FALSE
5707: );
5708:
5709: IF l_debug_on THEN
5710: WSH_DEBUG_SV.pop(l_module_name);
5711: END IF;
5712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5713: ROLLBACK TO GROUP_DETAIL_SEARCH_DLVY_PUB;
5714: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5718: p_data => x_msg_data,
5719: p_encoded => FND_API.G_FALSE
5720: );
5721: IF l_debug_on THEN
5722: WSH_DEBUG_SV.pop(l_module_name);
5723: END IF;
5724: WHEN OTHERS THEN
5725: ROLLBACK TO GROUP_DETAIL_SEARCH_DLVY_PUB;
5726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5730: p_data => x_msg_data,
5731: p_encoded => FND_API.G_FALSE
5732: );
5733: IF l_debug_on THEN
5734: WSH_DEBUG_SV.pop(l_module_name);
5735: END IF;
5736: END GROUP_DETAIL_SEARCH_DLVY;
5737:
5738: PROCEDURE Get_Disabled_List(
5749: i NUMBER;
5750:
5751:
5752: --
5753: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5754: --
5755: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'Get_Disabled_List';
5756:
5757:
5758: BEGIN
5759:
5760: IF l_debug_on
5761: THEN
5762: wsh_debug_sv.push(l_module_name);
5763: END IF;
5764:
5765:
5766: WSH_DATA_PROTECTION.Get_Disabled_List(
5777: );
5778:
5779: IF (l_debug_on)
5780: THEN
5781: WSH_DEBUG_SV.logmsg(l_module_name,' WSH GET DISABLED LIST :Status:'||x_return_status);
5782: WSH_DEBUG_SV.logmsg(l_module_name,' WSH GET DISABLED LIST ::message:'||x_msg_data);
5783: END IF;
5784:
5785:
5778:
5779: IF (l_debug_on)
5780: THEN
5781: WSH_DEBUG_SV.logmsg(l_module_name,' WSH GET DISABLED LIST :Status:'||x_return_status);
5782: WSH_DEBUG_SV.logmsg(l_module_name,' WSH GET DISABLED LIST ::message:'||x_msg_data);
5783: END IF;
5784:
5785:
5786:
5796: LOOP
5797:
5798: IF (l_debug_on)
5799: THEN
5800: WSH_DEBUG_SV.logmsg(l_module_name,' GET DISABLED LIST '||i||':'||l_disabled_list(i));
5801:
5802: END IF;
5803: x_disabled_list(i):=l_disabled_list(i);
5804: i:=l_disabled_list.NEXT(i);
5809:
5810: END IF;
5811:
5812: IF l_debug_on THEN
5813: WSH_DEBUG_SV.pop(l_module_name);
5814: END IF;
5815:
5816: EXCEPTION
5817:
5818: WHEN OTHERS THEN
5819:
5820: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5821: IF l_debug_on THEN
5822: WSH_DEBUG_SV.pop(l_module_name);
5823: END IF;
5824:
5825: END Get_Disabled_List;
5826: --
5873: l_trip_id NUMBER;
5874: l_trip_name VARCHAR2(100);
5875: db_mode_of_transport VARCHAR2(30);
5876:
5877: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5878:
5879: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'TRIP_ACTION';
5880:
5881: --{Trip update parameters
5910: l_number_of_errors := 0;
5911:
5912: IF l_debug_on
5913: THEN
5914: wsh_debug_sv.push(l_module_name);
5915: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
5916: END IF;
5917:
5918:
5911:
5912: IF l_debug_on
5913: THEN
5914: wsh_debug_sv.push(l_module_name);
5915: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
5916: END IF;
5917:
5918:
5919: l_tender_action := p_action_prms.action_code;
5931: p_trip_name => p_trip_info_rec.TRIP_NAME);
5932:
5933: IF l_debug_on
5934: THEN
5935: WSH_DEBUG_SV.logmsg(l_module_name, ' VALIDATE_TENDER_REQUEST return status '
5936: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
5937: END IF;
5938:
5939:
5932:
5933: IF l_debug_on
5934: THEN
5935: WSH_DEBUG_SV.logmsg(l_module_name, ' VALIDATE_TENDER_REQUEST return status '
5936: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
5937: END IF;
5938:
5939:
5940: wsh_util_core.api_post_call(
6025:
6026:
6027: IF l_debug_on
6028: THEN
6029: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP return status '
6030: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6031: END IF;
6032:
6033:
6026:
6027: IF l_debug_on
6028: THEN
6029: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP return status '
6030: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6031: END IF;
6032:
6033:
6034: wsh_util_core.api_post_call(
6048: x_return_status => l_return_status);
6049:
6050: IF l_debug_on
6051: THEN
6052: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_MBOLS_PVT.Generate_MBOL return status '
6053: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6054: END IF;
6055:
6056:
6049:
6050: IF l_debug_on
6051: THEN
6052: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_MBOLS_PVT.Generate_MBOL return status '
6053: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6054: END IF;
6055:
6056:
6057: IF ( (l_return_status = 'E') OR (l_return_status = 'U') )
6058: THEN
6059:
6060: IF l_debug_on
6061: THEN
6062: WSH_DEBUG_SV.logmsg(l_module_name,' MBOL is not generated ');
6063: END IF;
6064: FND_MESSAGE.SET_NAME('FTE','FTE_MBOL_NOT_GENERATED');
6065: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6066: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
6076: --}
6077:
6078: IF l_debug_on
6079: THEN
6080: WSH_DEBUG_SV.logmsg(l_module_name,' Call FTE_TENDER_PVT.RAISE_TENDER_EVENT ',
6081: WSH_DEBUG_SV.C_PROC_LEVEL);
6082: END IF;
6083:
6084:
6077:
6078: IF l_debug_on
6079: THEN
6080: WSH_DEBUG_SV.logmsg(l_module_name,' Call FTE_TENDER_PVT.RAISE_TENDER_EVENT ',
6081: WSH_DEBUG_SV.C_PROC_LEVEL);
6082: END IF;
6083:
6084:
6085: FTE_TENDER_PVT.RAISE_TENDER_EVENT(
6092:
6093:
6094: IF l_debug_on
6095: THEN
6096: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_TENDER_PVT.RAISE_TENDER_EVENT '
6097: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6098: END IF;
6099:
6100:
6093:
6094: IF l_debug_on
6095: THEN
6096: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_TENDER_PVT.RAISE_TENDER_EVENT '
6097: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6098: END IF;
6099:
6100:
6101: wsh_util_core.api_post_call(
6112: --{
6113:
6114: IF l_debug_on
6115: THEN
6116: WSH_DEBUG_SV.logmsg(l_module_name,' Action ' || l_tender_action,
6117: WSH_DEBUG_SV.C_PROC_LEVEL);
6118: END IF;
6119:
6120:
6113:
6114: IF l_debug_on
6115: THEN
6116: WSH_DEBUG_SV.logmsg(l_module_name,' Action ' || l_tender_action,
6117: WSH_DEBUG_SV.C_PROC_LEVEL);
6118: END IF;
6119:
6120:
6121: select wf_item_key into l_item_key from wsh_trips
6183: --{
6184:
6185: IF l_debug_on
6186: THEN
6187: WSH_DEBUG_SV.logmsg(l_module_name,' No Response call',
6188: WSH_DEBUG_SV.C_PROC_LEVEL);
6189: END IF;
6190:
6191: INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
6184:
6185: IF l_debug_on
6186: THEN
6187: WSH_DEBUG_SV.logmsg(l_module_name,' No Response call',
6188: WSH_DEBUG_SV.C_PROC_LEVEL);
6189: END IF;
6190:
6191: INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
6192:
6204: p_trip_in_rec.action_code :='UPDATE';
6205:
6206: IF l_debug_on
6207: THEN
6208: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || p_trip_info.TRIP_ID,
6209: WSH_DEBUG_SV.C_PROC_LEVEL);
6210: END IF;
6211:
6212:
6205:
6206: IF l_debug_on
6207: THEN
6208: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || p_trip_info.TRIP_ID,
6209: WSH_DEBUG_SV.C_PROC_LEVEL);
6210: END IF;
6211:
6212:
6213: WSH_INTERFACE_GRP.Create_Update_Trip
6224: );
6225:
6226: IF l_debug_on
6227: THEN
6228: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
6229: l_return_status,
6230: WSH_DEBUG_SV.C_PROC_LEVEL);
6231: END IF;
6232:
6226: IF l_debug_on
6227: THEN
6228: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
6229: l_return_status,
6230: WSH_DEBUG_SV.C_PROC_LEVEL);
6231: END IF;
6232:
6233: wsh_util_core.api_post_call(
6234: p_return_status =>l_return_status,
6240: --{
6241:
6242: IF l_debug_on
6243: THEN
6244: WSH_DEBUG_SV.logmsg(l_module_name,' Autoaccept call ',
6245: WSH_DEBUG_SV.C_PROC_LEVEL);
6246: END IF;
6247:
6248: INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
6241:
6242: IF l_debug_on
6243: THEN
6244: WSH_DEBUG_SV.logmsg(l_module_name,' Autoaccept call ',
6245: WSH_DEBUG_SV.C_PROC_LEVEL);
6246: END IF;
6247:
6248: INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
6249:
6261: p_trip_in_rec.action_code :='UPDATE';
6262:
6263: IF l_debug_on
6264: THEN
6265: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || p_trip_info.TRIP_ID,
6266: WSH_DEBUG_SV.C_PROC_LEVEL);
6267: END IF;
6268:
6269:
6262:
6263: IF l_debug_on
6264: THEN
6265: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || p_trip_info.TRIP_ID,
6266: WSH_DEBUG_SV.C_PROC_LEVEL);
6267: END IF;
6268:
6269:
6270: WSH_INTERFACE_GRP.Create_Update_Trip
6281: );
6282:
6283: IF l_debug_on
6284: THEN
6285: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
6286: l_return_status,
6287: WSH_DEBUG_SV.C_PROC_LEVEL);
6288: END IF;
6289:
6283: IF l_debug_on
6284: THEN
6285: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
6286: l_return_status,
6287: WSH_DEBUG_SV.C_PROC_LEVEL);
6288: END IF;
6289:
6290: wsh_util_core.api_post_call(
6291: p_return_status =>l_return_status,
6297: --{
6298:
6299: IF l_debug_on
6300: THEN
6301: WSH_DEBUG_SV.logmsg(l_module_name,' Action ' || l_tender_action,
6302: WSH_DEBUG_SV.C_PROC_LEVEL);
6303: END IF;
6304:
6305:
6298:
6299: IF l_debug_on
6300: THEN
6301: WSH_DEBUG_SV.logmsg(l_module_name,' Action ' || l_tender_action,
6302: WSH_DEBUG_SV.C_PROC_LEVEL);
6303: END IF;
6304:
6305:
6306: select wf_item_key into l_item_key from wsh_trips
6343: --{
6344:
6345: IF l_debug_on
6346: THEN
6347: WSH_DEBUG_SV.logmsg(l_module_name,' Action ' || l_tender_action,
6348: WSH_DEBUG_SV.C_PROC_LEVEL);
6349: END IF;
6350:
6351:
6344:
6345: IF l_debug_on
6346: THEN
6347: WSH_DEBUG_SV.logmsg(l_module_name,' Action ' || l_tender_action,
6348: WSH_DEBUG_SV.C_PROC_LEVEL);
6349: END IF;
6350:
6351:
6352: select wf_item_key into l_item_key from wsh_trips
6407: );
6408:
6409:
6410: IF l_debug_on THEN
6411: WSH_DEBUG_SV.pop(l_module_name);
6412: END IF;
6413:
6414:
6415: EXCEPTION
6423: p_encoded => FND_API.G_FALSE
6424: );
6425:
6426: IF l_debug_on THEN
6427: WSH_DEBUG_SV.pop(l_module_name);
6428: END IF;
6429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6430: ROLLBACK TO TRIP_ACTION_PUB;
6431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6435: p_data => x_msg_data,
6436: p_encoded => FND_API.G_FALSE
6437: );
6438: IF l_debug_on THEN
6439: WSH_DEBUG_SV.pop(l_module_name);
6440: END IF;
6441: WHEN OTHERS THEN
6442: ROLLBACK TO TRIP_ACTION_PUB;
6443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6447: p_data => x_msg_data,
6448: p_encoded => FND_API.G_FALSE
6449: );
6450: IF l_debug_on THEN
6451: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
6452: WSH_DEBUG_SV.pop(l_module_name);
6453: END IF;
6454: END Trip_Action;
6455: --
6448: p_encoded => FND_API.G_FALSE
6449: );
6450: IF l_debug_on THEN
6451: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
6452: WSH_DEBUG_SV.pop(l_module_name);
6453: END IF;
6454: END Trip_Action;
6455: --
6456: --***************************************************************************
6491: l_trip_id_tab FTE_ID_TAB_TYPE;
6492:
6493:
6494:
6495: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
6496:
6497: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'TRIP_ACTION';
6498:
6499:
6521: l_number_of_errors := 0;
6522:
6523: IF l_debug_on
6524: THEN
6525: wsh_debug_sv.push(l_module_name);
6526: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
6527: END IF;
6528:
6529:
6522:
6523: IF l_debug_on
6524: THEN
6525: wsh_debug_sv.push(l_module_name);
6526: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
6527: END IF;
6528:
6529:
6530: IF p_action_prms.action_code = FTE_TENDER_PVT.S_TENDERED THEN
6543: x_msg_count => l_msg_count,
6544: x_msg_data => l_msg_data);
6545:
6546: IF l_debug_on THEN
6547: WSH_DEBUG_SV.logmsg(l_module_name,' return status from TENDER_TRIPS ' || l_return_status);
6548: END IF;
6549:
6550: --}
6551: END IF;
6575: p_encoded => FND_API.G_FALSE
6576: );
6577:
6578: IF l_debug_on THEN
6579: WSH_DEBUG_SV.pop(l_module_name);
6580: END IF;
6581:
6582:
6583: EXCEPTION
6591: p_encoded => FND_API.G_FALSE
6592: );
6593:
6594: IF l_debug_on THEN
6595: WSH_DEBUG_SV.pop(l_module_name);
6596: END IF;
6597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6598: ROLLBACK TO TRIP_ACTION_PUB;
6599: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6603: p_data => x_msg_data,
6604: p_encoded => FND_API.G_FALSE
6605: );
6606: IF l_debug_on THEN
6607: WSH_DEBUG_SV.pop(l_module_name);
6608: END IF;
6609: WHEN OTHERS THEN
6610: ROLLBACK TO TRIP_ACTION_PUB;
6611: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6615: p_data => x_msg_data,
6616: p_encoded => FND_API.G_FALSE
6617: );
6618: IF l_debug_on THEN
6619: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
6620: WSH_DEBUG_SV.pop(l_module_name);
6621: END IF;
6622: END TRIP_ACTION;
6623: --========================================================================
6616: p_encoded => FND_API.G_FALSE
6617: );
6618: IF l_debug_on THEN
6619: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
6620: WSH_DEBUG_SV.pop(l_module_name);
6621: END IF;
6622: END TRIP_ACTION;
6623: --========================================================================
6624: -- PROCEDURE : UPDATE_SERVICE_TO_TRIP FTE wrapper
6669: l_number_of_errors NUMBER;
6670: l_return_status VARCHAR2(32767);
6671: l_msg_count NUMBER;
6672: l_msg_data VARCHAR2(32767);
6673: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
6674: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'UPDATE_SERVICE_ON_TRIP';
6675:
6676: BEGIN
6677:
6685: FND_MSG_PUB.initialize;
6686: --END IF;
6687: --
6688: IF l_debug_on THEN
6689: wsh_debug_sv.push(l_module_name);
6690: END IF;
6691: --
6692: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6693: l_msg_count := 0;
6696: x_msg_count := 0;
6697: --
6698:
6699: IF l_debug_on THEN
6700: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:'||p_service_action);
6701: END IF;
6702:
6703: -- Step 1. First update service on the trip
6704: CREATE_UPDATE_TRIP(
6728: x_num_errors =>l_number_of_errors,
6729: p_msg_data =>l_msg_data);
6730:
6731: IF l_debug_on THEN
6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');
6733: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6734: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6735: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6736: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6729: p_msg_data =>l_msg_data);
6730:
6731: IF l_debug_on THEN
6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');
6733: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6734: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6735: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6736: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6737: END IF;
6730:
6731: IF l_debug_on THEN
6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');
6733: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6734: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6735: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6736: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6737: END IF;
6738:
6731: IF l_debug_on THEN
6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');
6733: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6734: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6735: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6736: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6737: END IF;
6738:
6739: -- Step 2:Raise appropriate business events:
6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');
6733: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6734: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6735: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6736: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6737: END IF;
6738:
6739: -- Step 2:Raise appropriate business events:
6740: -- If service action is UPDATE,
6743: -- Else raise only a select service event
6744:
6745: /* R12 Hiding Project
6746: IF l_debug_on THEN
6747: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:'||p_service_action);
6748: END IF;
6749:
6750: IF ( p_service_action = 'UPDATE' OR p_service_action = 'REMOVE') THEN
6751:
6759: x_num_errors =>l_number_of_errors,
6760: p_msg_data =>l_msg_data);
6761:
6762: IF l_debug_on THEN
6763: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: CANCEL SERVICE');
6764: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6765: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6766: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6767: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6760: p_msg_data =>l_msg_data);
6761:
6762: IF l_debug_on THEN
6763: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: CANCEL SERVICE');
6764: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6765: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6766: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6767: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6768: END IF;
6761:
6762: IF l_debug_on THEN
6763: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: CANCEL SERVICE');
6764: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6765: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6766: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6767: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6768: END IF;
6769:
6762: IF l_debug_on THEN
6763: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: CANCEL SERVICE');
6764: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6765: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6766: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6767: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6768: END IF;
6769:
6770: END IF;
6763: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: CANCEL SERVICE');
6764: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6765: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6766: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6767: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6768: END IF;
6769:
6770: END IF;
6771:
6770: END IF;
6771:
6772: IF (p_service_action = 'ADD_NEW' OR p_service_action = 'UPDATE') THEN
6773: IF l_debug_on THEN
6774: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Trip Service Event');
6775: END IF;
6776:
6777: FTE_WORKFLOW_UTIL.TRIP_SELECT_SERVICE_INIT(
6778: p_trip_id => p_trip_id,
6784: x_num_errors =>l_number_of_errors,
6785: p_msg_data =>l_msg_data);
6786:
6787: IF l_debug_on THEN
6788: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: SELECT SERVICE');
6789: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6790: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6791: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6792: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6785: p_msg_data =>l_msg_data);
6786:
6787: IF l_debug_on THEN
6788: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: SELECT SERVICE');
6789: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6790: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6791: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6792: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6793: END IF;
6786:
6787: IF l_debug_on THEN
6788: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: SELECT SERVICE');
6789: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6790: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6791: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6792: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6793: END IF;
6794: END IF;
6787: IF l_debug_on THEN
6788: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: SELECT SERVICE');
6789: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6790: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6791: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6792: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6793: END IF;
6794: END IF;
6795: */
6788: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_WORKFLOW_UTIL: SELECT SERVICE');
6789: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6790: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6791: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6792: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
6793: END IF;
6794: END IF;
6795: */
6796: