APPS.WSH_DSNO dependencies on WSH_UTIL_CORE

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

109:
110: -- bug 1677940: let caller know the status
111: x_return_status := l_return_status;
112:
113: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) OR NOT(l_call_status) THEN
114: -- Print Error Messages
115: FOR i IN 1..l_msg_count LOOP
116: fnd_msg_pub.get(
117: p_msg_index => i,

Line 182: wsh_util_core.enable_concurrent_log_print;

178: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
179: END IF;
180: --
181: Submit_Trip_Stop(p_trip_stop_id, l_completion_status);
182: wsh_util_core.enable_concurrent_log_print;
183: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status, '');
184: IF l_completion_status = 'NORMAL' THEN
185: errbuf := 'DSNO submission is completed successfully';
186: retcode := '0';

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

230: l_trip_stop_id NUMBER;
231:
232: cursor c_dsno_deliveries(c_trip_stop_id number ) is
233: SELECT
234: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
235: FROM WSH_TRIP_STOPS WTS,
236: WSH_TRIPS WTP,
237: WSH_TRIP_STOPS WTS2,
238: WSH_DELIVERY_LEGS WDL,

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

511: FROM WSH_DSNO_DELIVERIES_V
512: WHERE PICK_UP_STOP_ID = p_trip_stop_id;
513:
514: IF(l_delivery_count = 0) THEN
515: wsh_util_core.println('No Eligible Delivery for the DSNO');
516: wsh_util_core.println('Terminating program');
517: RETURN;
518: */
519: END IF;

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

512: WHERE PICK_UP_STOP_ID = p_trip_stop_id;
513:
514: IF(l_delivery_count = 0) THEN
515: wsh_util_core.println('No Eligible Delivery for the DSNO');
516: wsh_util_core.println('Terminating program');
517: RETURN;
518: */
519: END IF;
520:

Line 532: IF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

528: --
529: ec_document_send(p_trip_stop_id, l_submit_ret_sts);
530:
531: -- bug 1677940: set completion status of DSNO submit
532: IF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
533: x_completion_status := 'NORMAL';
534: ELSIF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
535: x_completion_status := 'ERROR';
536: ELSE

Line 534: ELSIF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

530:
531: -- bug 1677940: set completion status of DSNO submit
532: IF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
533: x_completion_status := 'NORMAL';
534: ELSIF l_submit_ret_sts = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
535: x_completion_status := 'ERROR';
536: ELSE
537: x_completion_status := 'WARNING';
538: END IF;

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

545: END IF;
546: --
547: EXCEPTION
548: WHEN OTHERS THEN
549: wsh_util_core.default_handler('WSH_DSNO.Submit');
550: x_completion_status := 'ERROR';
551:
552: --
553: -- Debug Statements