APPS.WSH_RLM_INTERFACE dependencies on WSH_RLM_INTERFACE

Line 1: PACKAGE BODY WSH_RLM_INTERFACE as

1: PACKAGE BODY WSH_RLM_INTERFACE as
2: /* $Header: WSHRLMIB.pls 120.2.12000000.2 2007/04/09 10:15:31 sunilku ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RLM_INTERFACE';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RLM_INTERFACE';

1: PACKAGE BODY WSH_RLM_INTERFACE as
2: /* $Header: WSHRLMIB.pls 120.2.12000000.2 2007/04/09 10:15:31 sunilku ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RLM_INTERFACE';
6:
7: g_col_tab RLM_CORE_SV.t_dynamic_tab;
8:
9: PROCEDURE BuildQuery(

Line 31: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.BuildQuery');

27: v_request_date_str VARCHAR2(30);
28: v_schedule_date_str VARCHAR2(30);
29: BEGIN
30: --
31: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.BuildQuery');
32: --
33: -- Starting where-clause
34:
35: v_where_clause :=

Line 950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');

946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));
950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');
951: --
952: EXCEPTION
953: --
954: WHEN OTHERS THEN

Line 1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');

1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1059: --
1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1061: rlm_core_sv.dlog('Blanket Number = ' || p_blanket_number);
1062: --
1063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1064: l_total_qty_in_transit := 0;

Line 1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');

1258: --
1259: END IF; /* source code = 'OE' */
1260: --
1261: rlm_core_sv.dlog('intransit qty = '|| x_in_transit_qty);
1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');
1263: --
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',x_in_transit_qty);
1266: WSH_DEBUG_SV.pop(l_module_name);

Line 1296: wsh_util_core.default_handler('WSH_RLM_INTERFACE.Get_In_Transit_Qty');

1292: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_CUST_SITE');
1293: END IF;
1294: --
1295: WHEN others THEN
1296: wsh_util_core.default_handler('WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1297: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1298:
1299: --
1300: -- Debug Statements

Line 1310: END WSH_RLM_INTERFACE;

1306: --
1307: END Get_In_Transit_Qty;
1308:
1309:
1310: END WSH_RLM_INTERFACE;