89: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
90: --
91: IF l_debug_on IS NULL
92: THEN
93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
94: END IF;
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
94: END IF;
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
116: --
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
116: --
117:
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
116: --
117:
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
123: --
124: -- Debug Statements
125: --
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.logmsg(l_module_name, 'NULL PASSED FOR SOURCE LINE ID' );
128: END IF;
129: --
130: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
131: ELSE
143: --
144: -- Debug Statements
145: --
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.logmsg(l_module_name, 'NO CORRESPONDING DATA FOUND FOR THE LINE ID' || P_CHANGED_ATTRIBUTES.SOURCE_LINE_ID );
148: END IF;
149: --
150: x_action_allowed := 'Y';
151: END IF;
172: --
173: -- Debug Statements
174: --
175: IF l_debug_on THEN
176: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY DETAIL RELEASED_STATUS = ' || L_DELIVERY_DETAILS_REC.RELEASED_STATUS );
177: END IF;
178: --
179: --
180: -- Debug Statements
179: --
180: -- Debug Statements
181: --
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.logmsg(l_module_name, 'PARENT DELIVERY DETAIL = ' || L_DELIVERY_DETAILS_REC.PARENT_DELIVERY_DETAIL_ID );
184: END IF;
185: --
186: --
187: -- Debug Statements
186: --
187: -- Debug Statements
188: --
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY STATUS CODE = ' || L_DELIVERY_DETAILS_REC.STATUS_CODE );
191: END IF;
192: --
193: --
194: -- Debug Statements
193: --
194: -- Debug Statements
195: --
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY PLANNED FLAG = ' || L_DELIVERY_DETAILS_REC.PLANNED_FLAG );
198: END IF;
199: --
200: --
201: -- Debug Statements
200: --
201: -- Debug Statements
202: --
203: IF l_debug_on THEN
204: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE ACTION NOT ALLOWED FOR SOURCE LINE ID: ' || P_CHANGED_ATTRIBUTES.SOURCE_LINE_ID );
205: END IF;
206: --
207:
208: exit;
234: --
235: -- Debug Statements
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.logmsg(l_module_name, 'INVALID ACTION FLAG' );
239: END IF;
240: --
241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
242:
248: --
249: -- Debug Statements
250: --
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.pop(l_module_name);
253: END IF;
254: --
255: EXCEPTION
256:
264: --
265: -- Debug Statements
266: --
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
270: END IF;
271: --
272: END check_shipping_constraints;
265: -- Debug Statements
266: --
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
270: END IF;
271: --
272: END check_shipping_constraints;
273: