eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_DEBUG_SV

Line 28: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

24: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
25: --
26: IF l_debug_on IS NULL
27: THEN
28: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
29: END IF;
30: --
31: IF l_debug_on THEN
32: WSH_DEBUG_SV.push(l_module_name);

Line 32: WSH_DEBUG_SV.push(l_module_name);

28: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
29: END IF;
30: --
31: IF l_debug_on THEN
32: WSH_DEBUG_SV.push(l_module_name);
33: --
34: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
35: END IF;
36: --

Line 34: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);

30: --
31: IF l_debug_on THEN
32: WSH_DEBUG_SV.push(l_module_name);
33: --
34: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
35: END IF;
36: --
37: select count(*) into l_count
38: from wsh_delivery_details

Line 49: WSH_DEBUG_SV.pop(l_module_name,'RETURN-TRUE');

45: --
46: -- Debug Statements
47: --
48: IF l_debug_on THEN
49: WSH_DEBUG_SV.pop(l_module_name,'RETURN-TRUE');
50: END IF;
51: --
52: return TRUE;
53: else

Line 55: WSH_DEBUG_SV.pop(l_module_name,'RETURN-TRUE');

51: --
52: return TRUE;
53: else
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.pop(l_module_name,'RETURN-TRUE');
56: END IF;
57: return FALSE;
58: end if;
59: END part_of_ship_set;

Line 117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

113: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
114: --
115: IF l_debug_on IS NULL
116: THEN
117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
118: END IF;
119: --
120: IF l_debug_on THEN
121: WSH_DEBUG_SV.push(l_module_name);

Line 121: WSH_DEBUG_SV.push(l_module_name);

117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
118: END IF;
119: --
120: IF l_debug_on THEN
121: WSH_DEBUG_SV.push(l_module_name);
122: --
123: WSH_DEBUG_SV.log(l_module_name,'P_SALES_ORDER_ID',P_SALES_ORDER_ID);
124: END IF;
125: --

Line 123: WSH_DEBUG_SV.log(l_module_name,'P_SALES_ORDER_ID',P_SALES_ORDER_ID);

119: --
120: IF l_debug_on THEN
121: WSH_DEBUG_SV.push(l_module_name);
122: --
123: WSH_DEBUG_SV.log(l_module_name,'P_SALES_ORDER_ID',P_SALES_ORDER_ID);
124: END IF;
125: --
126: open c_reservations ( p_sales_order_id );
127: loop

Line 133: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATIONS FOR SALES_ORDER_ID ' || TO_CHAR ( P_SALES_ORDER_ID ) );

129: --
130: -- Debug Statements
131: --
132: IF l_debug_on THEN
133: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATIONS FOR SALES_ORDER_ID ' || TO_CHAR ( P_SALES_ORDER_ID ) );
134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );
135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );

Line 134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );

130: -- Debug Statements
131: --
132: IF l_debug_on THEN
133: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATIONS FOR SALES_ORDER_ID ' || TO_CHAR ( P_SALES_ORDER_ID ) );
134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );
135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );

Line 135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );

131: --
132: IF l_debug_on THEN
133: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATIONS FOR SALES_ORDER_ID ' || TO_CHAR ( P_SALES_ORDER_ID ) );
134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );
135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );

Line 136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );

132: IF l_debug_on THEN
133: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATIONS FOR SALES_ORDER_ID ' || TO_CHAR ( P_SALES_ORDER_ID ) );
134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );
135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );

Line 137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );

133: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVATIONS FOR SALES_ORDER_ID ' || TO_CHAR ( P_SALES_ORDER_ID ) );
134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );
135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );

Line 138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );

134: WSH_DEBUG_SV.logmsg(l_module_name, '================================================' );
135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );

Line 139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );

135: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERV_ID : ' || TO_CHAR ( L_RESERVATIONS.RESERV_ID ) );
136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );

Line 140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );

136: WSH_DEBUG_SV.logmsg(l_module_name, 'SHIP_READY : ' || L_RESERVATIONS.SHIP_READY );
137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );

Line 141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );

137: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_HEADER_ID ) );
138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );

Line 142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );

138: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_LINE_ID : ' || TO_CHAR ( L_RESERVATIONS.DS_LINE_ID ) );
139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );

Line 143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );

139: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_DELIVERY: ' || TO_CHAR ( L_RESERVATIONS.DS_DELIVERY ) );
140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );

Line 144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );

140: WSH_DEBUG_SV.logmsg(l_module_name, 'LINE : ' || L_RESERVATIONS.LINE );
141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );

Line 145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );

141: WSH_DEBUG_SV.logmsg(l_module_name, 'ITEM_ID : ' || TO_CHAR ( L_RESERVATIONS.ITEM_ID ) );
142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );

Line 146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );

142: WSH_DEBUG_SV.logmsg(l_module_name, 'RES_QTY : ' || TO_CHAR ( L_RESERVATIONS.RES_QTY ) );
143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );

Line 147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );

143: WSH_DEBUG_SV.logmsg(l_module_name, 'DET_QTY : ' || TO_CHAR ( L_RESERVATIONS.DET_QTY ) );
144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );
151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );

Line 148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );

144: WSH_DEBUG_SV.logmsg(l_module_name, 'REQUIRD_D : ' || L_RESERVATIONS.REQUIRD_D );
145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );
151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );
152: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET : ' || TO_CHAR ( L_RESERVATIONS.AUTODET ) );

Line 149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );

145: WSH_DEBUG_SV.logmsg(l_module_name, 'DS_TYPE : ' || TO_CHAR ( L_RESERVATIONS.DS_TYPE ) );
146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );
151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );
152: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET : ' || TO_CHAR ( L_RESERVATIONS.AUTODET ) );
153: END IF;

Line 150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );

146: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID : ' || TO_CHAR ( L_RESERVATIONS.ORG_ID ) );
147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );
151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );
152: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET : ' || TO_CHAR ( L_RESERVATIONS.AUTODET ) );
153: END IF;
154:

Line 151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );

147: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBINV : ' || L_RESERVATIONS.SUBINV );
148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );
151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );
152: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET : ' || TO_CHAR ( L_RESERVATIONS.AUTODET ) );
153: END IF;
154:
155: EXIT WHEN c_reservations%NOTFOUND;

Line 152: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET : ' || TO_CHAR ( L_RESERVATIONS.AUTODET ) );

148: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_HEADER_ID : ' || TO_CHAR ( L_RESERVATIONS.SS_HEADER_ID ) );
149: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE_DET- ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE_DET ) );
150: WSH_DEBUG_SV.logmsg(l_module_name, 'SS_SOURCE_LINE : ' || TO_CHAR ( L_RESERVATIONS.SS_SOURCE_LINE ) );
151: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET_GRP_ID : ' || TO_CHAR ( L_RESERVATIONS.AUTODET_GRP_ID ) );
152: WSH_DEBUG_SV.logmsg(l_module_name, 'AUTODET : ' || TO_CHAR ( L_RESERVATIONS.AUTODET ) );
153: END IF;
154:
155: EXIT WHEN c_reservations%NOTFOUND;
156: end loop ;

Line 161: WSH_DEBUG_SV.pop(l_module_name);

157: --
158: -- Debug Statements
159: --
160: IF l_debug_on THEN
161: WSH_DEBUG_SV.pop(l_module_name);
162: END IF;
163: --
164: end print_reservations ;
165:

Line 223: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

219: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
220: --
221: IF l_debug_on IS NULL
222: THEN
223: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
224: END IF;
225: --
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.push(l_module_name);

Line 227: WSH_DEBUG_SV.push(l_module_name);

223: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
224: END IF;
225: --
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.push(l_module_name);
228: --
229: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
230: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
231: END IF;

Line 229: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

225: --
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.push(l_module_name);
228: --
229: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
230: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
231: END IF;
232: --
233: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

Line 230: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);

226: IF l_debug_on THEN
227: WSH_DEBUG_SV.push(l_module_name);
228: --
229: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
230: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
231: END IF;
232: --
233: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 259: WSH_DEBUG_SV.pop(l_module_name);

255: --
256: -- Debug Statements
257: --
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.pop(l_module_name);
260: END IF;
261: --
262: EXCEPTION
263: when NOT_ASSIGNED_TO_DEL_ERROR then

Line 271: WSH_DEBUG_SV.logmsg(l_module_name,'NOT_ASSIGNED_TO_DEL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

267: --
268: -- Debug Statements
269: --
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.logmsg(l_module_name,'NOT_ASSIGNED_TO_DEL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NOT_ASSIGNED_TO_DEL_ERROR');
273: END IF;
274: --
275: when others then

Line 272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NOT_ASSIGNED_TO_DEL_ERROR');

268: -- Debug Statements
269: --
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.logmsg(l_module_name,'NOT_ASSIGNED_TO_DEL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NOT_ASSIGNED_TO_DEL_ERROR');
273: END IF;
274: --
275: when others then
276: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 285: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

281: --
282: -- Debug Statements
283: --
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
286: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
287: END IF;
288: --
289: END Get_Line_Total_Shp_Qty;

Line 286: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

282: -- Debug Statements
283: --
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
286: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
287: END IF;
288: --
289: END Get_Line_Total_Shp_Qty;
290:

Line 537: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

533: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
534: --
535: IF l_debug_on IS NULL
536: THEN
537: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
538: END IF;
539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.push(l_module_name);

Line 541: WSH_DEBUG_SV.push(l_module_name);

537: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
538: END IF;
539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.push(l_module_name);
542: --
543: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);
544: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);
545: END IF;

Line 543: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);

539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.push(l_module_name);
542: --
543: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);
544: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);
545: END IF;
546: --
547: SAVEPOINT before_backorder;

Line 544: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);

540: IF l_debug_on THEN
541: WSH_DEBUG_SV.push(l_module_name);
542: --
543: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);
544: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);
545: END IF;
546: --
547: SAVEPOINT before_backorder;
548:

Line 567: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

563: --
564: -- Debug Statements
565: --
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
568: END IF;
569: --
570: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
571: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 578: WSH_DEBUG_SV.logmsg(l_module_name,'Back Order Consolidation Flag is set as '||l_global_param_rec.consolidate_bo_lines, WSH_DEBUG_SV.C_PROC_LEVEL);

574: RAISE backorder_error;
575: END IF;
576:
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'Back Order Consolidation Flag is set as '||l_global_param_rec.consolidate_bo_lines, WSH_DEBUG_SV.C_PROC_LEVEL);
579: END IF;
580:
581: IF (l_global_param_rec.consolidate_bo_lines = 'Y' AND p_line_ids.COUNT > 1 ) THEN
582: --{

Line 598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);

594: --
595: -- Debug Statements
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
599: END IF;
600: --
601: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
602: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(

Line 634: WSH_DEBUG_SV.logmsg(l_module_name,'Total No. of delivery details '||p_detail_ids.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);

630: l_bo_qty2s(i) := l_cons_dd_rec_tab(i).bo_qty2;
631: -- end of 3121616
632: END LOOP; --}
633: IF l_debug_on THEN
634: WSH_DEBUG_SV.logmsg(l_module_name,'Total No. of delivery details '||p_detail_ids.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
635: WSH_DEBUG_SV.logmsg(l_module_name,'No. of delivery details after Consolidation '||l_detail_ids.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
636: END IF;
637: END IF; --}, l_global_param_rec.consolidate_bo_lines flag
638: --

Line 635: WSH_DEBUG_SV.logmsg(l_module_name,'No. of delivery details after Consolidation '||l_detail_ids.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);

631: -- end of 3121616
632: END LOOP; --}
633: IF l_debug_on THEN
634: WSH_DEBUG_SV.logmsg(l_module_name,'Total No. of delivery details '||p_detail_ids.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
635: WSH_DEBUG_SV.logmsg(l_module_name,'No. of delivery details after Consolidation '||l_detail_ids.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
636: END IF;
637: END IF; --}, l_global_param_rec.consolidate_bo_lines flag
638: --
639:

Line 670: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id: '||l_delivery_id||' ,l_planned_flag: '||l_planned_flag);

666: --
667: -- Debug Statements
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id: '||l_delivery_id||' ,l_planned_flag: '||l_planned_flag);
671: WSH_DEBUG_SV.logmsg(l_module_name, 'IN BACKORDER ' || I );
672: END IF;
673: --
674:

Line 671: WSH_DEBUG_SV.logmsg(l_module_name, 'IN BACKORDER ' || I );

667: -- Debug Statements
668: --
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name, 'l_delivery_id: '||l_delivery_id||' ,l_planned_flag: '||l_planned_flag);
671: WSH_DEBUG_SV.logmsg(l_module_name, 'IN BACKORDER ' || I );
672: END IF;
673: --
674:
675: -- bug 1672188: check there is a quantity (normal or overpicked) to backorder.

Line 686: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING IF ' || l_bo_qtys ( I ) || ' < ' || l_req_qtys ( I ) );

682: --
683: -- Debug Statements
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name, 'CHECKING IF ' || l_bo_qtys ( I ) || ' < ' || l_req_qtys ( I ) );
687: END IF;
688: --
689: IF (l_bo_qtys(i) > 0)
690: AND (l_bo_qtys(i) < l_req_qtys(i)) THEN

Line 700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

696: --
697: -- Debug Statements
698: --
699: IF l_debug_on THEN
700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
701: END IF;
702: --
703: wsh_delivery_details_actions.split_delivery_details(
704: p_from_detail_id => l_detail_ids(i),

Line 711: WSH_DEBUG_SV.log(l_module_name,'SPLIT_DELIVERY_DETAILS l_return_status',l_return_status);

707: x_return_status => l_return_status ,
708: p_req_quantity2 => l_bo_qty2);
709:
710: IF l_debug_on THEN
711: WSH_DEBUG_SV.log(l_module_name,'SPLIT_DELIVERY_DETAILS l_return_status',l_return_status);
712: END IF;
713:
714: /* Bug 2308509 */
715: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 779: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_divisible_flag', l_item_info.lot_divisible_flag);

775: l_item_info.lot_control_code := NULL;
776: END IF;
777:
778: IF l_debug_on THEN
779: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_divisible_flag', l_item_info.lot_divisible_flag);
780: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_control_code', l_item_info.lot_control_code);
781: wsh_debug_sv.LOG(l_module_name, 'l_detail_rec.released_status', l_detail_rec.released_status);
782: END IF;
783: -- check for overpicking

Line 780: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_control_code', l_item_info.lot_control_code);

776: END IF;
777:
778: IF l_debug_on THEN
779: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_divisible_flag', l_item_info.lot_divisible_flag);
780: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_control_code', l_item_info.lot_control_code);
781: wsh_debug_sv.LOG(l_module_name, 'l_detail_rec.released_status', l_detail_rec.released_status);
782: END IF;
783: -- check for overpicking
784: IF (l_overpick_qtys(i) > 0) THEN --Bug 2026099: Removed other conditions

Line 781: wsh_debug_sv.LOG(l_module_name, 'l_detail_rec.released_status', l_detail_rec.released_status);

777:
778: IF l_debug_on THEN
779: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_divisible_flag', l_item_info.lot_divisible_flag);
780: wsh_debug_sv.LOG(l_module_name, 'l_item_info.lot_control_code', l_item_info.lot_control_code);
781: wsh_debug_sv.LOG(l_module_name, 'l_detail_rec.released_status', l_detail_rec.released_status);
782: END IF;
783: -- check for overpicking
784: IF (l_overpick_qtys(i) > 0) THEN --Bug 2026099: Removed other conditions
785: -- if we are backordering overpicked quantity,

Line 839: WSH_DEBUG_SV.logmsg(l_module_name, ' NEW DD TO UNASSIGN -' || L_BO_DETAIL_ID || ' TO L_UNASSIGN_DDS' );

835: --
836: -- Debug Statements
837: --
838: IF l_debug_on THEN
839: WSH_DEBUG_SV.logmsg(l_module_name, ' NEW DD TO UNASSIGN -' || L_BO_DETAIL_ID || ' TO L_UNASSIGN_DDS' );
840: END IF;
841: --
842: l_unassign_dd_flag := 'Y'; --deferred to the end.
843: l_unassign_dds(l_unassign_dds.count + 1 ) := l_bo_detail_id ;

Line 881: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

877: p_organization_id => l_detail_rec.organization_id,
878: p_inventory_item_id => l_detail_rec.inventory_item_id,
879: x_return_status => l_return_status);
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
882: END IF;
883:
884: /* Bug 2308509 */
885: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 902: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVED FLAG = ' || L_RESERVED_FLAG );

898: --
899: -- Debug Statements
900: --
901: IF l_debug_on THEN
902: WSH_DEBUG_SV.logmsg(l_module_name, 'RESERVED FLAG = ' || L_RESERVED_FLAG );
903: END IF;
904: --
905: -- wsh_util_core.println('BO Mode = ' || p_bo_mode );
906: -- HW BUG#:2005977

Line 917: WSH_DEBUG_SV.logmsg(l_module_name, 'UNRESERVE ' );

913: --
914: -- Debug Statements
915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.logmsg(l_module_name, 'UNRESERVE ' );
918: END IF;
919: --
920:
921: -- HW BUG#:2005977. Need to branch

Line 924: WSH_DEBUG_SV.log(l_module_name,'OverPick Qty ',l_overpick_qtys(i));

920:
921: -- HW BUG#:2005977. Need to branch
922: -- HW OPMCONV. Removed branching
923: IF l_debug_on THEN
924: WSH_DEBUG_SV.log(l_module_name,'OverPick Qty ',l_overpick_qtys(i));
925: END IF;
926:
927:
928:

Line 948: WSH_DEBUG_SV.LOG(l_module_name, 'item is lot indivisible: l_bo_mode', l_bo_mode);

944: l_qty := l_bo_qtys(i) + NVL(l_overpick_qtys(i), 0);
945: l_qty2 := l_bo_qty2s(i) + NVL(p_overpick_qtys2(i), 0);
946:
947: IF l_debug_on THEN
948: WSH_DEBUG_SV.LOG(l_module_name, 'item is lot indivisible: l_bo_mode', l_bo_mode);
949: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty', l_qty);
950: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty2', l_qty2);
951: END IF;
952: --Bug 5525314,If the item is lot indivisible and backorder Qty =0,

Line 949: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty', l_qty);

945: l_qty2 := l_bo_qty2s(i) + NVL(p_overpick_qtys2(i), 0);
946:
947: IF l_debug_on THEN
948: WSH_DEBUG_SV.LOG(l_module_name, 'item is lot indivisible: l_bo_mode', l_bo_mode);
949: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty', l_qty);
950: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty2', l_qty2);
951: END IF;
952: --Bug 5525314,If the item is lot indivisible and backorder Qty =0,
953: --then over pick Qty should not be unreserved

Line 950: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty2', l_qty2);

946:
947: IF l_debug_on THEN
948: WSH_DEBUG_SV.LOG(l_module_name, 'item is lot indivisible: l_bo_mode', l_bo_mode);
949: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty', l_qty);
950: WSH_DEBUG_SV.LOG(l_module_name, 'l_qty2', l_qty2);
951: END IF;
952: --Bug 5525314,If the item is lot indivisible and backorder Qty =0,
953: --then over pick Qty should not be unreserved
954: IF ((l_bo_qtys(i) > 0 AND l_detail_rec.requested_quantity >0)

Line 966: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

962: p_override_retain_ato_rsv => 'Y',
963: x_return_status => l_return_status );
964:
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
967: END IF;
968:
969: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
970: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR OVERPICK QTY',WSH_DEBUG_SV.C_PROC_LEVEL);

987: -- Bug 2824748: Call unreserve_delivery_detail with p_override_retain_ato_rsv 'Y' so that the
988: -- reservations for unused overpick qty are always removed
989: IF (l_overpick_qtys(i) > 0) THEN
990: IF l_debug_on THEN
991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR OVERPICK QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
992: END IF;
993: --
994: -- HW OPMCONV - Added Qty2
995:

Line 1015: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1011: x_return_status => l_return_status );
1012: END IF;
1013:
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1016: END IF;
1017: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1018: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1019: fnd_message.set_name('WSH', 'WSH_BO_UNRESERVE_ERROR');

Line 1032: WSH_DEBUG_SV.log(l_module_name,'BackOrder Qty ',l_bo_qtys(i));

1028:
1029: END IF; -- l_overpick_qtys(i) > 0
1030:
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.log(l_module_name,'BackOrder Qty ',l_bo_qtys(i));
1033: END IF;
1034:
1035: -- Bug 2824748: Call unreserve_delivery_detail with p_override_retain_ato_rsv 'N' so that the
1036: -- reservations for backorder qty are removed depending on the ATO profile option

Line 1039: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR BO QTY',WSH_DEBUG_SV.C_PROC_LEVEL);

1035: -- Bug 2824748: Call unreserve_delivery_detail with p_override_retain_ato_rsv 'N' so that the
1036: -- reservations for backorder qty are removed depending on the ATO profile option
1037: IF (l_bo_qtys(i) > 0) THEN
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR BO QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
1040: END IF;
1041: wsh_delivery_details_actions.unreserve_delivery_detail(
1042: p_delivery_Detail_id => l_detail_ids(i),
1043: p_unreserve_mode => p_bo_mode ,

Line 1050: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1046: p_override_retain_ato_rsv => 'N',
1047: x_return_status => l_return_status );
1048:
1049: IF l_debug_on THEN
1050: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1051: END IF;
1052: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1053: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1054: fnd_message.set_name('WSH', 'WSH_BO_UNRESERVE_ERROR');

Line 1076: WSH_DEBUG_SV.logmsg(l_module_name, 'NOT RESERVED ' );

1072: --
1073: -- Debug Statements
1074: --
1075: IF l_debug_on THEN
1076: WSH_DEBUG_SV.logmsg(l_module_name, 'NOT RESERVED ' );
1077: END IF;
1078: --
1079: END IF; -- l_reserved_flag = Y'
1080:

Line 1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);

1088: --
1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1093: END IF;
1094: --
1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1096: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1104: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1100: x_inv_controls_rec => l_inv_controls_rec,
1101: x_return_status => l_return_status);
1102:
1103: IF l_debug_on THEN
1104: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1105: END IF;
1106: /* Bug 2308509 */
1107: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1108: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

1116: --
1117: -- Debug Statements
1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1121: END IF;
1122: --
1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1124: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1131: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1127: p_transaction_temp_id => l_detail_rec.transaction_temp_id,
1128: x_return_status => l_return_status);
1129: /* Bug 2308509 */
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1132: END IF;
1133: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1134: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1135: wsh_util_core.add_message(l_return_status,l_module_name);

Line 1155: WSH_DEBUG_SV.logmsg(l_module_name, 'BACKORDER ...' );

1151: --
1152: -- Debug Statements
1153: --
1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.logmsg(l_module_name, 'BACKORDER ...' );
1156: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1157: -- 2807093
1158: WSH_DEBUG_SV.log(l_module_name,'Released Status: ', l_detail_rec.released_status);
1159: END IF;

Line 1156: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

1152: -- Debug Statements
1153: --
1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.logmsg(l_module_name, 'BACKORDER ...' );
1156: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1157: -- 2807093
1158: WSH_DEBUG_SV.log(l_module_name,'Released Status: ', l_detail_rec.released_status);
1159: END IF;
1160: -- bug 1733849: clear TRACKING_NUMBER when not shipped

Line 1158: WSH_DEBUG_SV.log(l_module_name,'Released Status: ', l_detail_rec.released_status);

1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.logmsg(l_module_name, 'BACKORDER ...' );
1156: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1157: -- 2807093
1158: WSH_DEBUG_SV.log(l_module_name,'Released Status: ', l_detail_rec.released_status);
1159: END IF;
1160: -- bug 1733849: clear TRACKING_NUMBER when not shipped
1161: -- HW BUG#:1885927 Need to clear lot_number,sublot_number,locator_id,
1162: -- preferred_grade and subinventory if the line is backordered

Line 1227: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

1223: p_organization_id => l_detail_rec.organization_id,
1224: x_return_status => l_wf_rs ) ;
1225: --Error Handling to be done in WSH_WF_STD.Raise_Event itself
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1228: WSH_DEBUG_SV.log(l_module_name,'Delivery Detail Id is ', l_detail_rec.delivery_detail_id );
1229: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1230: END IF;
1231: --Even if raising of event fails the flow continues.

Line 1228: WSH_DEBUG_SV.log(l_module_name,'Delivery Detail Id is ', l_detail_rec.delivery_detail_id );

1224: x_return_status => l_wf_rs ) ;
1225: --Error Handling to be done in WSH_WF_STD.Raise_Event itself
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1228: WSH_DEBUG_SV.log(l_module_name,'Delivery Detail Id is ', l_detail_rec.delivery_detail_id );
1229: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1230: END IF;
1231: --Even if raising of event fails the flow continues.
1232: --IF (l_wf_rs <>WSH_UTIL_CORE.G_RET_STS_SUCCESS ) then

Line 1229: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);

1225: --Error Handling to be done in WSH_WF_STD.Raise_Event itself
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1228: WSH_DEBUG_SV.log(l_module_name,'Delivery Detail Id is ', l_detail_rec.delivery_detail_id );
1229: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1230: END IF;
1231: --Even if raising of event fails the flow continues.
1232: --IF (l_wf_rs <>WSH_UTIL_CORE.G_RET_STS_SUCCESS ) then
1233: --No Action

Line 1242: WSH_DEBUG_SV.logmsg(l_module_name,'Adding the Consolidated BO Qty to the Requested Qty of the BO delivery detail ',WSH_DEBUG_SV.C_PROC_LEVEL);

1238:
1239: -- Consolidation of BO Delivery Details project
1240: IF (l_global_param_rec.consolidate_bo_lines = 'Y' AND p_line_ids.COUNT > 1) THEN
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'Adding the Consolidated BO Qty to the Requested Qty of the BO delivery detail ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail id: '||l_detail_rec.delivery_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail req qty: '||l_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity '||l_remain_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1246: -- HW OPM BUG#:3121616 added qty2s

Line 1243: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail id: '||l_detail_rec.delivery_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1239: -- Consolidation of BO Delivery Details project
1240: IF (l_global_param_rec.consolidate_bo_lines = 'Y' AND p_line_ids.COUNT > 1) THEN
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'Adding the Consolidated BO Qty to the Requested Qty of the BO delivery detail ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail id: '||l_detail_rec.delivery_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail req qty: '||l_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity '||l_remain_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1246: -- HW OPM BUG#:3121616 added qty2s
1247: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1244: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail req qty: '||l_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);

1240: IF (l_global_param_rec.consolidate_bo_lines = 'Y' AND p_line_ids.COUNT > 1) THEN
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'Adding the Consolidated BO Qty to the Requested Qty of the BO delivery detail ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail id: '||l_detail_rec.delivery_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail req qty: '||l_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity '||l_remain_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1246: -- HW OPM BUG#:3121616 added qty2s
1247: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;

Line 1245: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity '||l_remain_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);

1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'Adding the Consolidated BO Qty to the Requested Qty of the BO delivery detail ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail id: '||l_detail_rec.delivery_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail req qty: '||l_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity '||l_remain_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1246: -- HW OPM BUG#:3121616 added qty2s
1247: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;
1249: -- HW OPM BUG#:3121616 added requested_quantity2

Line 1247: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);

1243: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail id: '||l_detail_rec.delivery_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1244: WSH_DEBUG_SV.logmsg(l_module_name,'..delivery detail req qty: '||l_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1245: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity '||l_remain_bo_qtys(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1246: -- HW OPM BUG#:3121616 added qty2s
1247: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;
1249: -- HW OPM BUG#:3121616 added requested_quantity2
1250: UPDATE WSH_DELIVERY_DETAILS
1251: SET requested_quantity = requested_quantity + l_remain_bo_qtys(i),

Line 1280: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_detail_rec.delivery_detail_id);

1276: -- Update of wsh_delivery_details where requested_quantity/released_status
1277: -- are changed, call DBI API after the update.
1278: -- This API will also check for DBI Installed or not
1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_detail_rec.delivery_detail_id);
1281: END IF;
1282: l_detail_tab(1) := l_detail_rec.delivery_detail_id;
1283: WSH_INTEGRATION.DBI_Update_Detail_Log
1284: (p_delivery_detail_id_tab => l_detail_tab,

Line 1289: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);

1285: p_dml_type => 'UPDATE',
1286: x_return_status => l_dbi_rs);
1287:
1288: IF l_debug_on THEN
1289: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
1290: END IF;
1291: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1292: x_return_status := l_dbi_rs;
1293: -- just pass this return status to caller API, raise as above

Line 1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

1300:
1301: -- J: W/V Changes
1302: IF l_bo_qtys(i) > 0 Then -- Bug 3547300
1303: IF l_debug_on THEN
1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1305: END IF;
1306: --
1307: WSH_WV_UTILS.Detail_Weight_Volume(
1308: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1316: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1312: x_net_weight => l_split_weight,
1313: x_volume => l_split_volume,
1314: x_return_status => l_return_status);
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1317: END IF;
1318: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1319: wsh_util_core.add_message(l_return_status,l_module_name);
1320: x_return_status := l_return_status;

Line 1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);

1343: --{
1344: l_unassign_dds_tmp(1) := l_bo_detail_id;
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: END IF;
1349:
1350: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1351: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont

Line 1362: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER UNASSIGN AND UNPACK EMPTY CONTAINER '|| L_RETURN_STATUS );

1358: --
1359: -- Debug Statements
1360: --
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER UNASSIGN AND UNPACK EMPTY CONTAINER '|| L_RETURN_STATUS );
1363: END IF;
1364:
1365: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1366: --{

Line 1396: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);

1392: --
1393: -- Debug Statements
1394: --
1395: IF l_debug_on THEN
1396: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
1397: END IF;
1398: --
1399: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
1400: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,

Line 1443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);

1439: --
1440: -- Debug Statements
1441: --
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1444: END IF;
1445: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1446: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
1447: p_ids_tobe_unassigned => l_unassign_dds ,

Line 1456: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER UNASSIGN AND UNPACK EMPTY CONTAINER '|| L_RETURN_STATUS );

1452: --
1453: -- Debug Statements
1454: --
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER UNASSIGN AND UNPACK EMPTY CONTAINER '|| L_RETURN_STATUS );
1457: END IF;
1458: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1459: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1460: l_num_warn := l_num_warn + 1;

Line 1472: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.DELETE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1468: --
1469: -- Debug Statements
1470: --
1471: IF l_debug_on THEN
1472: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.DELETE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1473: END IF;
1474: --
1475: WSH_INTERFACE.Delete_Details(
1476: p_details_id => l_delete_dds,

Line 1484: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER DELETING DETAIL '|| L_RETURN_STATUS );

1480: -- Debug Statements
1481: --
1482:
1483: IF l_debug_on THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER DELETING DETAIL '|| L_RETURN_STATUS );
1485: END IF;
1486: --
1487: /* Bug 2308509 */
1488: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 1505: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);

1501: --
1502: -- Debug Statements
1503: --
1504: IF l_debug_on THEN
1505: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.CHECK_SHIP_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
1506: END IF;
1507: --
1508: wsh_delivery_validations.check_ship_set( l_delivery_id, l_valid_flag, l_return_status);
1509: /* Bug 2308509 */

Line 1523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1519:
1520: --
1521: -- K LPN CONV. rv
1522: IF l_debug_on THEN
1523: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1524: END IF;
1525: --
1526: --
1527: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 1540: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1536: );
1537: --
1538: --
1539: IF l_debug_on THEN
1540: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1541: END IF;
1542: --
1543: --
1544: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 1580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1576: --
1577: -- Debug Statements
1578: --
1579: IF l_debug_on THEN
1580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1581: END IF;
1582: --
1583: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1596: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

1592: --{
1593: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1594: --{
1595: IF l_debug_on THEN
1596: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1597: END IF;
1598:
1599: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1600: x_return_status => l_return_status);

Line 1603: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1599: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1600: x_return_status => l_return_status);
1601:
1602: IF l_debug_on THEN
1603: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1604: END IF;
1605:
1606: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1607: x_return_status := l_return_status;

Line 1624: WSH_DEBUG_SV.pop(l_module_name);

1620: --
1621: -- Debug Statements
1622: --
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.pop(l_module_name);
1625: END IF;
1626: --
1627: EXCEPTION
1628:

Line 1638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1634: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1635: THEN
1636: --{
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1639: END IF;
1640:
1641: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1642: (

Line 1650: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1646: );
1647: --
1648: --
1649: IF l_debug_on THEN
1650: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1651: END IF;
1652: --
1653: --
1654: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1664: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1660: --
1661: -- K LPN CONV. rv
1662: --
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
1666: END IF;
1667: --
1668:

Line 1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');

1661: -- K LPN CONV. rv
1662: --
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.logmsg(l_module_name,'E_RETURN_EXCP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
1666: END IF;
1667: --
1668:
1669:

Line 1680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

1676: --Bugfix 4070732 {
1677: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1678: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1679: IF l_debug_on THEN
1680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1681: END IF;
1682:
1683: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1684: x_return_status => l_return_status);

Line 1688: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1684: x_return_status => l_return_status);
1685:
1686:
1687: IF l_debug_on THEN
1688: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1689: END IF;
1690:
1691: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1692: x_return_status := l_return_status;

Line 1698: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1694: END IF;
1695: END IF;
1696: --}
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_ERROR');
1700: END IF;
1701: --
1702: RETURN;

Line 1699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_ERROR');

1695: END IF;
1696: --}
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_ERROR');
1700: END IF;
1701: --
1702: RETURN;
1703:

Line 1724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

1720: --Bugfix 4070732 {
1721: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1722: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1723: IF l_debug_on THEN
1724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1725: END IF;
1726:
1727: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1728: x_return_status => l_return_status);

Line 1732: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1728: x_return_status => l_return_status);
1729:
1730:
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1733: END IF;
1734:
1735: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1736: x_return_status := l_return_status;

Line 1747: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1743: --
1744: -- Debug Statements
1745: --
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
1749: END IF;
1750: --
1751: WHEN no_backorder_full THEN

Line 1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');

1744: -- Debug Statements
1745: --
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
1749: END IF;
1750: --
1751: WHEN no_backorder_full THEN
1752: fnd_message.set_name('WSH','WSH_BKALL_NOT_ALLOW');

Line 1761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

1757: --Bugfix 4070732 {
1758: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1759: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1760: IF l_debug_on THEN
1761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1762: END IF;
1763:
1764: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1765: x_return_status => l_return_status);

Line 1769: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1765: x_return_status => l_return_status);
1766:
1767:
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1770: END IF;
1771:
1772: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1773: x_return_status := l_return_status;

Line 1784: WSH_DEBUG_SV.logmsg(l_module_name,'NO_BACKORDER_FULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1780: --
1781: -- Debug Statements
1782: --
1783: IF l_debug_on THEN
1784: WSH_DEBUG_SV.logmsg(l_module_name,'NO_BACKORDER_FULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_BACKORDER_FULL');
1786: END IF;
1787: --
1788: WHEN new_det_wt_vol_failed THEN

Line 1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_BACKORDER_FULL');

1781: -- Debug Statements
1782: --
1783: IF l_debug_on THEN
1784: WSH_DEBUG_SV.logmsg(l_module_name,'NO_BACKORDER_FULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_BACKORDER_FULL');
1786: END IF;
1787: --
1788: WHEN new_det_wt_vol_failed THEN
1789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1801: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1797: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1798: THEN
1799: --{
1800: IF l_debug_on THEN
1801: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1802: END IF;
1803:
1804: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1805: (

Line 1813: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);

1809: );
1810: --
1811: --
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1814: END IF;
1815: --
1816: --
1817: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1830: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

1826: --Bugfix 4070732 {
1827: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1828: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1829: IF l_debug_on THEN
1830: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1831: END IF;
1832:
1833: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1834: x_return_status => l_return_status);

Line 1838: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1834: x_return_status => l_return_status);
1835:
1836:
1837: IF l_debug_on THEN
1838: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1839: END IF;
1840:
1841: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1842: x_return_status := l_return_status;

Line 1852: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1848: --
1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NEW_DET_WT_VOL_FAILED');
1854: END IF;
1855: --
1856: WHEN OTHERS THEN

Line 1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NEW_DET_WT_VOL_FAILED');

1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NEW_DET_WT_VOL_FAILED');
1854: END IF;
1855: --
1856: WHEN OTHERS THEN
1857: WSH_UTIL_CORE.Default_Handler('WSH_SHIP_CONFIRM_ACTIONS2.Backorder',l_module_name);

Line 1864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

1860: --Bugfix 4070732 {
1861: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1862: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1863: IF l_debug_on THEN
1864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1865: END IF;
1866:
1867: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1868: x_return_status => l_return_status);

Line 1872: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1868: x_return_status => l_return_status);
1869:
1870:
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1873: END IF;
1874: END IF;
1875: END IF;
1876: --}

Line 1880: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1876: --}
1877: --
1878: -- Debug Statements
1879: IF l_debug_on THEN
1880: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1882: END IF;
1883:
1884: RETURN ;

Line 1881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1877: --
1878: -- Debug Statements
1879: IF l_debug_on THEN
1880: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1882: END IF;
1883:
1884: RETURN ;
1885:

Line 1921: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1917: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1918: --
1919: IF l_debug_on IS NULL
1920: THEN
1921: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1922: END IF;
1923: --
1924: IF l_debug_on THEN
1925: WSH_DEBUG_SV.push(l_module_name);

Line 1925: WSH_DEBUG_SV.push(l_module_name);

1921: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1922: END IF;
1923: --
1924: IF l_debug_on THEN
1925: WSH_DEBUG_SV.push(l_module_name);
1926: --
1927: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1928: END IF;
1929: --

Line 1927: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);

1923: --
1924: IF l_debug_on THEN
1925: WSH_DEBUG_SV.push(l_module_name);
1926: --
1927: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1928: END IF;
1929: --
1930: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1931:

Line 1942: WSH_DEBUG_SV.log(l_module_name,'x_exception_exist',x_exception_exist);

1938: END IF;
1939: CLOSE c_exception;
1940:
1941: IF l_debug_on THEN
1942: WSH_DEBUG_SV.log(l_module_name,'x_exception_exist',x_exception_exist);
1943: WSH_DEBUG_SV.log(l_module_name,'x_severity_present',x_severity_present);
1944: END IF;
1945:
1946:

Line 1943: WSH_DEBUG_SV.log(l_module_name,'x_severity_present',x_severity_present);

1939: CLOSE c_exception;
1940:
1941: IF l_debug_on THEN
1942: WSH_DEBUG_SV.log(l_module_name,'x_exception_exist',x_exception_exist);
1943: WSH_DEBUG_SV.log(l_module_name,'x_severity_present',x_severity_present);
1944: END IF;
1945:
1946:
1947: --

Line 1951: WSH_DEBUG_SV.pop(l_module_name);

1947: --
1948: -- Debug Statements
1949: --
1950: IF l_debug_on THEN
1951: WSH_DEBUG_SV.pop(l_module_name);
1952: END IF;
1953: --
1954: EXCEPTION
1955: WHEN others THEN

Line 1960: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1957: WSH_UTIL_CORE.default_handler('WSH_SHIP_CONFIRM_ACTIONS2.check_exception',l_module_name);
1958:
1959: IF l_debug_on THEN
1960: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1961: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1962: END IF;
1963: --
1964: END check_exception;

Line 1961: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1957: WSH_UTIL_CORE.default_handler('WSH_SHIP_CONFIRM_ACTIONS2.check_exception',l_module_name);
1958:
1959: IF l_debug_on THEN
1960: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1961: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1962: END IF;
1963: --
1964: END check_exception;
1965:

Line 2004: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2000: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2001: --
2002: IF l_debug_on IS NULL
2003: THEN
2004: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2005: END IF;
2006: --
2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.push(l_module_name);

Line 2008: WSH_DEBUG_SV.push(l_module_name);

2004: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2005: END IF;
2006: --
2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.push(l_module_name);
2009: --
2010: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);
2011: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);
2012: END IF;

Line 2010: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);

2006: --
2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.push(l_module_name);
2009: --
2010: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);
2011: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);
2012: END IF;
2013: --
2014:

Line 2011: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);

2007: IF l_debug_on THEN
2008: WSH_DEBUG_SV.push(l_module_name);
2009: --
2010: WSH_DEBUG_SV.log(l_module_name,'P_BO_MODE',P_BO_MODE);
2011: WSH_DEBUG_SV.log(l_module_name,'P_BO_SOURCE',P_BO_SOURCE);
2012: END IF;
2013: --
2014:
2015: --

Line 2019: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BackOrder',WSH_DEBUG_SV.C_PROC_LEVEL);

2015: --
2016: -- Debug Statements
2017: --
2018: IF l_debug_on THEN
2019: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BackOrder',WSH_DEBUG_SV.C_PROC_LEVEL);
2020: WSH_DEBUG_SV.logmsg(l_module_name,'......with p_line_ids as NULL', WSH_DEBUG_SV.C_PROC_LEVEL);
2021: END IF;
2022: --
2023: Backorder(

Line 2020: WSH_DEBUG_SV.logmsg(l_module_name,'......with p_line_ids as NULL', WSH_DEBUG_SV.C_PROC_LEVEL);

2016: -- Debug Statements
2017: --
2018: IF l_debug_on THEN
2019: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BackOrder',WSH_DEBUG_SV.C_PROC_LEVEL);
2020: WSH_DEBUG_SV.logmsg(l_module_name,'......with p_line_ids as NULL', WSH_DEBUG_SV.C_PROC_LEVEL);
2021: END IF;
2022: --
2023: Backorder(
2024: p_detail_ids => p_detail_ids,

Line 2038: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status '|| x_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);

2034: x_cons_flags => l_cons_flags,
2035: x_return_status => x_return_status );
2036:
2037: IF l_debug_on THEN
2038: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status '|| x_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2039: WSH_DEBUG_SV.pop(l_module_name);
2040: END IF;
2041:
2042: END BackOrder;

Line 2039: WSH_DEBUG_SV.pop(l_module_name);

2035: x_return_status => x_return_status );
2036:
2037: IF l_debug_on THEN
2038: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status '|| x_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2039: WSH_DEBUG_SV.pop(l_module_name);
2040: END IF;
2041:
2042: END BackOrder;
2043: