APPS.WSH_DSNO dependencies on WSH_DSNO

Line 1: PACKAGE BODY WSH_DSNO as

1: PACKAGE BODY WSH_DSNO as
2: /* $Header: WSHDSNOB.pls 120.3.12010000.2 2009/04/21 07:24:08 ueshanka ship $ */
3:
4:
5: G_RLM_INSTALL_STATUS VARCHAR2(30);

Line 11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DSNO';

7:
8: -- bug 1677940: add new parameter x_return_status
9:
10: --
11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DSNO';
12: --
13: PROCEDURE ec_document_send (
14: p_trip_stop_id IN NUMBER,
15: x_return_status OUT NOCOPY VARCHAR2) IS

Line 65: l_output_file_ext := FND_PROFILE.Value('WSH_DSNO_OUTPUT_FILE_EXT');

61: FETCH doc_num INTO l_doc_num;
62: CLOSE doc_num;
63:
64: --Following lines of code added as part of Bug 4255379
65: l_output_file_ext := FND_PROFILE.Value('WSH_DSNO_OUTPUT_FILE_EXT');
66: -- Bug 8424489 - Start
67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_CUSTOM_PUB.Dsno_Output_File_Prefix',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 531: FROM WSH_DSNO_DELIVERIES_V

527: return;
528:
529: /* SELECT COUNT(*)
530: INTO l_delivery_count
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');

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

Line 584: END WSH_DSNO;

580: END Submit_Trip_Stop;
581: -- end bug 1578251: new procedure submit_trip_stop with x_completion_status
582:
583:
584: END WSH_DSNO;