1: PACKAGE BODY WSH_ITM_CUSTOM_PROCESS AS
2: /* $Header: WSHITPPB.pls 120.3 2011/01/14 20:35:12 rvarghes ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ITM_CUSTOM_PROCESS';
5:
1: PACKAGE BODY WSH_ITM_CUSTOM_PROCESS AS
2: /* $Header: WSHITPPB.pls 120.3 2011/01/14 20:35:12 rvarghes ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ITM_CUSTOM_PROCESS';
5:
6: /*===========================================================================+
7: | PROCEDURE |
8: | PRE_PROCESS_REQUEST |
124: --
125: BEGIN
126:
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add('Entering WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_ONT_REQUEST....' , 4 ) ;
129: END IF;
130:
131:
132: IF l_debug_level > 0 THEN
129: END IF;
130:
131:
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add('Exiting WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_ONT_REQUEST....',4);
134: END IF;
135:
136: Exception
137: WHEN NO_DATA_FOUND THEN
163: --
164: BEGIN
165:
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add('Entering WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_ONT_REQUEST....' , 4 ) ;
168: END IF;
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add('Exiting WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_ONT_REQUEST....',4);
167: oe_debug_pub.add('Entering WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_ONT_REQUEST....' , 4 ) ;
168: END IF;
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add('Exiting WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_ONT_REQUEST....',4);
172: END IF;
173:
174: Exception
175: WHEN NO_DATA_FOUND THEN
327: --
328:
329: END GET_TOP_MODEL_SQL;
330:
331: END WSH_ITM_CUSTOM_PROCESS;