APPS.WSH_DSNO dependencies on WSH_UTIL_CORE

Line 133: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) OR NOT(l_call_status) THEN

129:
130: -- bug 1677940: let caller know the status
131: x_return_status := l_return_status;
132:
133: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) OR NOT(l_call_status) THEN
134: -- Print Error Messages
135: FOR i IN 1..l_msg_count LOOP
136: fnd_msg_pub.get(
137: p_msg_index => i,

Line 202: wsh_util_core.enable_concurrent_log_print;

198: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
199: END IF;
200: --
201: Submit_Trip_Stop(p_trip_stop_id, l_completion_status);
202: wsh_util_core.enable_concurrent_log_print;
203: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status, '');
204: IF l_completion_status = 'NORMAL' THEN
205: errbuf := 'DSNO submission is completed successfully';
206: retcode := '0';

Line 254: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists

250: l_trip_stop_id NUMBER;
251:
252: cursor c_dsno_deliveries(c_trip_stop_id number ) is
253: SELECT
254: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
255: FROM WSH_TRIP_STOPS WTS,
256: WSH_TRIPS WTP,
257: WSH_TRIP_STOPS WTS2,
258: WSH_DELIVERY_LEGS WDL,

Line 535: wsh_util_core.println('No Eligible Delivery for the DSNO');

531: FROM WSH_DSNO_DELIVERIES_V
532: WHERE PICK_UP_STOP_ID = p_trip_stop_id;
533:
534: IF(l_delivery_count = 0) THEN
535: wsh_util_core.println('No Eligible Delivery for the DSNO');
536: wsh_util_core.println('Terminating program');
537: RETURN;
538: */
539: END IF;

Line 536: wsh_util_core.println('Terminating program');

532: WHERE PICK_UP_STOP_ID = p_trip_stop_id;
533:
534: IF(l_delivery_count = 0) THEN
535: wsh_util_core.println('No Eligible Delivery for the DSNO');
536: wsh_util_core.println('Terminating program');
537: RETURN;
538: */
539: END IF;
540:

Line 552: IF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

548: --
549: ec_document_send(p_trip_stop_id, l_submit_ret_sts);
550:
551: -- bug 1677940: set completion status of DSNO submit
552: IF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
553: x_completion_status := 'NORMAL';
554: ELSIF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
555: x_completion_status := 'ERROR';
556: ELSE

Line 554: ELSIF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

550:
551: -- bug 1677940: set completion status of DSNO submit
552: IF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
553: x_completion_status := 'NORMAL';
554: ELSIF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
555: x_completion_status := 'ERROR';
556: ELSE
557: x_completion_status := 'WARNING';
558: END IF;

Line 569: wsh_util_core.default_handler('WSH_DSNO.Submit');

565: END IF;
566: --
567: EXCEPTION
568: WHEN OTHERS THEN
569: wsh_util_core.default_handler('WSH_DSNO.Submit');
570: x_completion_status := 'ERROR';
571:
572: --
573: -- Debug Statements