[Home] [Help]
43: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
44: --
45: IF l_debug_on IS NULL
46: THEN
47: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
48: END IF;
49: --
50: IF l_debug_on THEN
51: WSH_DEBUG_SV.push(l_module_name);
47: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
48: END IF;
49: --
50: IF l_debug_on THEN
51: WSH_DEBUG_SV.push(l_module_name);
52: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
53: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
54: WSH_DEBUG_SV.log(l_module_name,'line_id',p_in_attributes.line_id);
55: WSH_DEBUG_SV.log(l_module_name,'dummy_quantity',p_inout_attributes.dummy_quantity);
48: END IF;
49: --
50: IF l_debug_on THEN
51: WSH_DEBUG_SV.push(l_module_name);
52: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
53: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
54: WSH_DEBUG_SV.log(l_module_name,'line_id',p_in_attributes.line_id);
55: WSH_DEBUG_SV.log(l_module_name,'dummy_quantity',p_inout_attributes.dummy_quantity);
56: END IF;
49: --
50: IF l_debug_on THEN
51: WSH_DEBUG_SV.push(l_module_name);
52: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
53: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
54: WSH_DEBUG_SV.log(l_module_name,'line_id',p_in_attributes.line_id);
55: WSH_DEBUG_SV.log(l_module_name,'dummy_quantity',p_inout_attributes.dummy_quantity);
56: END IF;
57:
50: IF l_debug_on THEN
51: WSH_DEBUG_SV.push(l_module_name);
52: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
53: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
54: WSH_DEBUG_SV.log(l_module_name,'line_id',p_in_attributes.line_id);
55: WSH_DEBUG_SV.log(l_module_name,'dummy_quantity',p_inout_attributes.dummy_quantity);
56: END IF;
57:
58: IF ( p_in_attributes.source_code IS NULL )
51: WSH_DEBUG_SV.push(l_module_name);
52: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
53: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
54: WSH_DEBUG_SV.log(l_module_name,'line_id',p_in_attributes.line_id);
55: WSH_DEBUG_SV.log(l_module_name,'dummy_quantity',p_inout_attributes.dummy_quantity);
56: END IF;
57:
58: IF ( p_in_attributes.source_code IS NULL )
59: THEN
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: END IF;
64:
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DETAILS_VALIDATIONS.Get_Min_Max_Tolerance_Quantity');
67: END IF;
68:
69: l_minmaxinrectype.api_version_number := NVL(p_in_attributes.api_version_number, 1.0);
70: l_minmaxinrectype.source_code := p_in_attributes.source_code;
81: x_msg_data => x_msg_data
82: );
83:
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity',x_return_status);
86: END IF;
87:
88: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
89: IF l_debug_on THEN
86: END IF;
87:
88: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
89: IF l_debug_on THEN
90: WSH_DEBUG_SV.pop(l_module_name);
91: END IF;
92: return;
93: END IF;
94:
100: p_out_attributes.min_remaining_quantity2 := l_minmaxoutrectype.min_remaining_quantity2;
101: p_out_attributes.max_remaining_quantity2 := l_minmaxoutrectype.max_remaining_quantity2;
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.log(l_module_name,'p_inout_attributes.dummy_quantity', p_inout_attributes.dummy_quantity);
105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_uom);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
101: p_out_attributes.max_remaining_quantity2 := l_minmaxoutrectype.max_remaining_quantity2;
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.log(l_module_name,'p_inout_attributes.dummy_quantity', p_inout_attributes.dummy_quantity);
105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_uom);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.log(l_module_name,'p_inout_attributes.dummy_quantity', p_inout_attributes.dummy_quantity);
105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_uom);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.log(l_module_name,'p_inout_attributes.dummy_quantity', p_inout_attributes.dummy_quantity);
105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_uom);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
104: WSH_DEBUG_SV.log(l_module_name,'p_inout_attributes.dummy_quantity', p_inout_attributes.dummy_quantity);
105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_uom);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_uom);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
114: END IF;
107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
114: END IF;
115:
108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
114: END IF;
115:
116: IF l_debug_on THEN
109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);
110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);
111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
114: END IF;
115:
116: IF l_debug_on THEN
117: WSH_DEBUG_SV.pop(l_module_name);
113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
114: END IF;
115:
116: IF l_debug_on THEN
117: WSH_DEBUG_SV.pop(l_module_name);
118: END IF;
119:
120: EXCEPTION
121: WHEN OTHERS THEN
127: ,p_encoded => FND_API.G_FALSE
128: );
129:
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
132: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
133: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
134: END IF;
135:
128: );
129:
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
132: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
133: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
134: END IF;
135:
136: END Get_Min_Max_Tolerance_Quantity;
129:
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
132: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
133: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
134: END IF;
135:
136: END Get_Min_Max_Tolerance_Quantity;
137:
179: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
180: --
181: IF l_debug_on IS NULL
182: THEN
183: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
184: END IF;
185: --
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.push(l_module_name);
183: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
184: END IF;
185: --
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.push(l_module_name);
188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
184: END IF;
185: --
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.push(l_module_name);
188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);
185: --
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.push(l_module_name);
188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);
193: WSH_DEBUG_SV.log(l_module_name,'dummy_count',p_inout_attributes.dummy_count);
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.push(l_module_name);
188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);
193: WSH_DEBUG_SV.log(l_module_name,'dummy_count',p_inout_attributes.dummy_count);
194: END IF;
187: WSH_DEBUG_SV.push(l_module_name);
188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);
193: WSH_DEBUG_SV.log(l_module_name,'dummy_count',p_inout_attributes.dummy_count);
194: END IF;
195:
188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);
193: WSH_DEBUG_SV.log(l_module_name,'dummy_count',p_inout_attributes.dummy_count);
194: END IF;
195:
196: IF ( p_in_attributes.source_code IS NULL )
189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);
190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);
191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);
192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);
193: WSH_DEBUG_SV.log(l_module_name,'dummy_count',p_inout_attributes.dummy_count);
194: END IF;
195:
196: IF ( p_in_attributes.source_code IS NULL )
197: THEN
224: and trunc(wts.actual_departure_date) between l_closing_fm_date and l_closing_to_date
225: and wdl.pick_up_stop_id = wts.stop_id;
226:
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.log(l_module_name,'l_untrxd_rec_count',l_untrxd_rec_count);
229: END IF;
230:
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
265: and wdl.pick_up_stop_id = wts.stop_id
266: and wts.stop_location_id = wnd.initial_pickup_location_id;
267:
268: IF l_debug_on THEN
269: WSH_DEBUG_SV.log(l_module_name,'l_rec_exp_count',l_rec_exp_count);
270: END IF;
271: EXCEPTION
272: WHEN NO_DATA_FOUND THEN
273: l_rec_exp_count := 0;
308: and wdl.pick_up_stop_id = wts.stop_id
309: and wts.stop_location_id = wnd.initial_pickup_location_id;
310:
311: IF l_debug_on THEN
312: WSH_DEBUG_SV.log(l_module_name,'l_rec_direct_count',l_rec_direct_count);
313: END IF;
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: l_rec_direct_count := 0;
324: p_out_attributes.untrxd_rec_count := l_untrxd_rec_count;
325: p_out_attributes.receiving_rec_count := NVL(l_rec_exp_count,0) + NVL(l_rec_direct_count,0);
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;
330:
331: EXCEPTION
332: WHEN OTHERS THEN
338: ,p_encoded => FND_API.G_FALSE
339: );
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
345: END IF;
346:
339: );
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
345: END IF;
346:
347: END Get_Untrxd_Shpg_Lines_Count;
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
345: END IF;
346:
347: END Get_Untrxd_Shpg_Lines_Count;
348:
459: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
460: --
461: IF l_debug_on IS NULL
462: THEN
463: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
464: END IF;
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.push(l_module_name);
463: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
464: END IF;
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.push(l_module_name);
468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
464: END IF;
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.push(l_module_name);
468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.push(l_module_name);
468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.push(l_module_name);
468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);
474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
467: WSH_DEBUG_SV.push(l_module_name);
468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);
474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
475: END IF;
468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);
474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
475: END IF;
476:
469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);
474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
475: END IF;
476:
477:
470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_id);
472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);
473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);
474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
475: END IF;
476:
477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
525:
526: END IF;
527:
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.pop(l_module_name);
530: END IF;
531: EXCEPTION
532:
533: WHEN OTHERS THEN
542: , p_data => x_msg_data
543: );
544:
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
547: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
549: END IF;
550:
543: );
544:
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
547: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
549: END IF;
550:
551: END Ins_Backorder_SS_SMC_Rec;
544:
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
547: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
549: END IF;
550:
551: END Ins_Backorder_SS_SMC_Rec;
552:
577: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
578: --
579: IF l_debug_on IS NULL
580: THEN
581: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
582: END IF;
583: --
584: IF l_debug_on THEN
585: wsh_debug_sv.log (l_module_name,'p_message');
581: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
582: END IF;
583: --
584: IF l_debug_on THEN
585: wsh_debug_sv.log (l_module_name,'p_message');
586: END IF;
587: END trace;
588:
589: PROCEDURE update_printer_assignment(
637: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
638: --
639: IF l_debug_on IS NULL
640: THEN
641: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
642: END IF;
643: --
644: WSH_DEBUG_SV.start_debug();
645: IF l_debug_on THEN
640: THEN
641: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
642: END IF;
643: --
644: WSH_DEBUG_SV.start_debug();
645: IF l_debug_on THEN
646: wsh_debug_sv.push(l_module_name);
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
642: END IF;
643: --
644: WSH_DEBUG_SV.start_debug();
645: IF l_debug_on THEN
646: wsh_debug_sv.push(l_module_name);
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
643: --
644: WSH_DEBUG_SV.start_debug();
645: IF l_debug_on THEN
646: wsh_debug_sv.push(l_module_name);
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
644: WSH_DEBUG_SV.start_debug();
645: IF l_debug_on THEN
646: wsh_debug_sv.push(l_module_name);
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
645: IF l_debug_on THEN
646: wsh_debug_sv.push(l_module_name);
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
646: wsh_debug_sv.push(l_module_name);
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
654: END IF;
647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_id);
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
654: END IF;
655:
648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_id);
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);
650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);
651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: l_application_id := p_application_id;
673: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
674: , p_data => x_msg_data );
675: x_return_status := fnd_api.g_ret_sts_error;
676: IF l_debug_on THEN
677: wsh_debug_sv.pop(l_module_name,'RETURN');
678: END IF;
679:
680: RETURN;
681: END IF;
708: AND printer_name = p_printer_name);
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: trace('Printer is not signed on');
712: wsh_debug_sv.pop(l_module_name);
713: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NOT_SIGNON');
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: , p_data => x_msg_data );
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: , p_data => x_msg_data );
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: IF l_debug_on THEN
719: wsh_debug_sv.pop(l_module_name,'RETURN');
720: END IF;
721: RETURN;
722: END;
723: trace('printer has been signed on, continue signing off');
929:
930: END LOOP;
931: COMMIT;
932: IF l_debug_on THEN
933: wsh_debug_sv.pop(l_module_name);
934: wsh_debug_sv.stop_debug;
935: END IF;
936: EXCEPTION
937: WHEN fnd_api.g_exc_error THEN
930: END LOOP;
931: COMMIT;
932: IF l_debug_on THEN
933: wsh_debug_sv.pop(l_module_name);
934: wsh_debug_sv.stop_debug;
935: END IF;
936: EXCEPTION
937: WHEN fnd_api.g_exc_error THEN
938: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name);
938: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name);
939: trace('ERROR CODE = ' || SQLCODE);
940: trace('ERROR MESSAGE = ' || SQLERRM);
941: IF l_debug_on THEN
942: wsh_debug_sv.pop(l_module_name);
943: wsh_debug_sv.stop_debug;
944: END IF;
945: ROLLBACK;
946:
939: trace('ERROR CODE = ' || SQLCODE);
940: trace('ERROR MESSAGE = ' || SQLERRM);
941: IF l_debug_on THEN
942: wsh_debug_sv.pop(l_module_name);
943: wsh_debug_sv.stop_debug;
944: END IF;
945: ROLLBACK;
946:
947: WHEN fnd_api.g_exc_unexpected_error THEN
948: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name);
949: trace('ERROR CODE = ' || SQLCODE);
950: trace('ERROR MESSAGE = ' || SQLERRM);
951: IF l_debug_on THEN
952: wsh_debug_sv.pop(l_module_name);
953: wsh_debug_sv.stop_debug;
954: END IF;
955: ROLLBACK;
956:
949: trace('ERROR CODE = ' || SQLCODE);
950: trace('ERROR MESSAGE = ' || SQLERRM);
951: IF l_debug_on THEN
952: wsh_debug_sv.pop(l_module_name);
953: wsh_debug_sv.stop_debug;
954: END IF;
955: ROLLBACK;
956:
957: WHEN others THEN
958: trace(' Other Error In '|| G_PKG_NAME||'.' || l_api_name);
959: trace('ERROR CODE = ' || SQLCODE);
960: trace('ERROR MESSAGE = ' || SQLERRM);
961: IF l_debug_on THEN
962: wsh_debug_sv.pop(l_module_name);
963: wsh_debug_sv.stop_debug;
964: END IF;
965: ROLLBACK;
966:
959: trace('ERROR CODE = ' || SQLCODE);
960: trace('ERROR MESSAGE = ' || SQLERRM);
961: IF l_debug_on THEN
962: wsh_debug_sv.pop(l_module_name);
963: wsh_debug_sv.stop_debug;
964: END IF;
965: ROLLBACK;
966:
967: END update_printer_assignment;
1065: --Commenting the code for Obsoletion of DBI APIs in 12.2
1066: /*l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1067: --
1068: IF l_debug_on IS NULL THEN
1069: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1070: END IF;
1071: --
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.push(l_module_name);
1069: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1070: END IF;
1071: --
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.push(l_module_name);
1074: END IF;
1075: --
1076: IF G_DBI_IS_INSTALLED IS NULL THEN
1077: G_DBI_IS_INSTALLED := (NVL(FND_PROFILE.VALUE('ISC_WSH_FTE_DBI_INSTALLED'), 'N'));
1076: IF G_DBI_IS_INSTALLED IS NULL THEN
1077: G_DBI_IS_INSTALLED := (NVL(FND_PROFILE.VALUE('ISC_WSH_FTE_DBI_INSTALLED'), 'N'));
1078: END IF;
1079: IF l_debug_on THEN
1080: WSH_DEBUG_SV.log(l_module_name,'G_DBI_IS_INSTALLED',G_DBI_IS_INSTALLED);
1081: WSH_DEBUG_SV.pop(l_module_name);
1082: END IF;*/
1083: RETURN 'N';
1084:
1077: G_DBI_IS_INSTALLED := (NVL(FND_PROFILE.VALUE('ISC_WSH_FTE_DBI_INSTALLED'), 'N'));
1078: END IF;
1079: IF l_debug_on THEN
1080: WSH_DEBUG_SV.log(l_module_name,'G_DBI_IS_INSTALLED',G_DBI_IS_INSTALLED);
1081: WSH_DEBUG_SV.pop(l_module_name);
1082: END IF;*/
1083: RETURN 'N';
1084:
1085: /*EXCEPTION
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1088: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1091: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1093: END IF;*/
1094: END DBI_Installed;
1087: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1088: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1091: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1093: END IF;*/
1094: END DBI_Installed;
1095:
1088: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1091: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1093: END IF;*/
1094: END DBI_Installed;
1095:
1096: --========================================================
1113: --
1114: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1115: --
1116: IF l_debug_on IS NULL THEN
1117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1118: END IF;
1119: --
1120: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1121:
1119: --
1120: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1121:
1122: IF l_debug_on THEN
1123: WSH_DEBUG_SV.push(l_module_name);
1124: WSH_DEBUG_SV.log(l_module_name,'Count Input records',p_wsh_id_tab.count);
1125: END IF;
1126:
1127: -- Conversion is required from WSH datatype to DBI datatype
1120: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1121:
1122: IF l_debug_on THEN
1123: WSH_DEBUG_SV.push(l_module_name);
1124: WSH_DEBUG_SV.log(l_module_name,'Count Input records',p_wsh_id_tab.count);
1125: END IF;
1126:
1127: -- Conversion is required from WSH datatype to DBI datatype
1128: -- Use the same counter while adding records in x_dbi_tab
1129: FOR i in p_wsh_id_tab.FIRST..p_wsh_id_tab.LAST
1130: LOOP
1131: x_dbi_id_tab(i) := p_wsh_id_tab(i);
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.log(l_module_name,'Id being converted-',p_wsh_id_tab(i));
1134: END IF;
1135: END LOOP;
1136:
1137: IF l_debug_on THEN
1134: END IF;
1135: END LOOP;
1136:
1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.log(l_module_name,'Count Output records',x_dbi_id_tab.count);
1139: WSH_DEBUG_SV.pop(l_module_name);
1140: END IF;
1141:
1142: EXCEPTION
1135: END LOOP;
1136:
1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.log(l_module_name,'Count Output records',x_dbi_id_tab.count);
1139: WSH_DEBUG_SV.pop(l_module_name);
1140: END IF;
1141:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: wsh_util_core.add_message(x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1149: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1151: END IF;
1152: END WSH_ID_TAB_TO_DBI_ID_TAB;*/
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: wsh_util_core.add_message(x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1149: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1151: END IF;
1152: END WSH_ID_TAB_TO_DBI_ID_TAB;*/
1153:
1146: wsh_util_core.add_message(x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1149: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1151: END IF;
1152: END WSH_ID_TAB_TO_DBI_ID_TAB;*/
1153:
1154: --===============================================
1181: --
1182: /* l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1183: --
1184: IF l_debug_on IS NULL THEN
1185: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1186: END IF;*/
1187: --
1188: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1189: /*IF l_debug_on THEN
1186: END IF;*/
1187: --
1188: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1189: /*IF l_debug_on THEN
1190: WSH_DEBUG_SV.push(l_module_name);
1191: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1192: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1193: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1194: END IF;
1187: --
1188: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1189: /*IF l_debug_on THEN
1190: WSH_DEBUG_SV.push(l_module_name);
1191: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1192: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1193: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1194: END IF;
1195: --
1188: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1189: /*IF l_debug_on THEN
1190: WSH_DEBUG_SV.push(l_module_name);
1191: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1192: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1193: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1194: END IF;
1195: --
1196: -- Check if DBI is installed, possible values are Y or N only
1189: /*IF l_debug_on THEN
1190: WSH_DEBUG_SV.push(l_module_name);
1191: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1192: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1193: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1194: END IF;
1195: --
1196: -- Check if DBI is installed, possible values are Y or N only
1197: -- If not installed, then do not proceed , return Success
1199: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550
1200: IF p_delivery_detail_id_tab.count < 1
1201: THEN
1202: IF l_debug_on THEN
1203: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1204: WSH_DEBUG_SV.pop(l_module_name);
1205: END IF;
1206: RETURN;
1207: END IF;
1200: IF p_delivery_detail_id_tab.count < 1
1201: THEN
1202: IF l_debug_on THEN
1203: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1204: WSH_DEBUG_SV.pop(l_module_name);
1205: END IF;
1206: RETURN;
1207: END IF;
1208: --
1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1216:
1217: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1220: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1221: END IF;
1222: --
1223: ISC_DBI_CHANGE_LOG_PKG.Update_Del_Detail_Log
1216:
1217: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1220: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1221: END IF;
1222: --
1223: ISC_DBI_CHANGE_LOG_PKG.Update_Del_Detail_Log
1224: (p_detail_list => l_dbi_detail_list,
1239: --
1240: END IF;
1241:
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1244: WSH_DEBUG_SV.pop(l_module_name);
1245: END IF;
1246:
1247: EXCEPTION
1240: END IF;
1241:
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1244: WSH_DEBUG_SV.pop(l_module_name);
1245: END IF;
1246:
1247: EXCEPTION
1248: WHEN OTHERS THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: wsh_util_core.add_message(x_return_status,l_module_name);
1252:
1253: IF l_debug_on THEN
1254: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1255: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1256: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1257: END IF;*/
1258: END DBI_Update_Detail_Log;
1251: wsh_util_core.add_message(x_return_status,l_module_name);
1252:
1253: IF l_debug_on THEN
1254: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1255: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1256: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1257: END IF;*/
1258: END DBI_Update_Detail_Log;
1259:
1252:
1253: IF l_debug_on THEN
1254: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1255: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1256: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1257: END IF;*/
1258: END DBI_Update_Detail_Log;
1259:
1260:
1295: --
1296: /* l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1297: --
1298: IF l_debug_on IS NULL THEN
1299: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1300: END IF;*/
1301: --
1302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1303: /* IF l_debug_on THEN
1300: END IF;*/
1301: --
1302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1303: /* IF l_debug_on THEN
1304: WSH_DEBUG_SV.push(l_module_name);
1305: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1306: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1307: END IF;
1308: --
1301: --
1302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1303: /* IF l_debug_on THEN
1304: WSH_DEBUG_SV.push(l_module_name);
1305: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1306: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1307: END IF;
1308: --
1309: -- Check if DBI is installed, possible values are Y or N only
1302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1303: /* IF l_debug_on THEN
1304: WSH_DEBUG_SV.push(l_module_name);
1305: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1306: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1307: END IF;
1308: --
1309: -- Check if DBI is installed, possible values are Y or N only
1310: -- If not installed, then do not proceed , return Success
1312: --IF (WSH_INTEGRATION.DBI_Installed = 'N' OR BUG#11852550
1313: IF p_stop_id_tab.count < 1
1314: THEN
1315: IF l_debug_on THEN
1316: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1317: WSH_DEBUG_SV.pop(l_module_name);
1318: END IF;
1319: RETURN;
1320: END IF;
1313: IF p_stop_id_tab.count < 1
1314: THEN
1315: IF l_debug_on THEN
1316: -- WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1317: WSH_DEBUG_SV.pop(l_module_name);
1318: END IF;
1319: RETURN;
1320: END IF;
1321: --
1329:
1330: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1331:
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1334: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1335: END IF;
1336: --
1337: ISC_DBI_CHANGE_LOG_PKG.Update_Trip_Stop_Log
1330: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1331:
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1334: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1335: END IF;
1336: --
1337: ISC_DBI_CHANGE_LOG_PKG.Update_Trip_Stop_Log
1338: (p_stop_list => l_dbi_stop_list,
1353: --
1354: END IF;
1355:
1356: IF l_debug_on THEN
1357: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1358: WSH_DEBUG_SV.pop(l_module_name);
1359: END IF;
1360:
1361: EXCEPTION
1354: END IF;
1355:
1356: IF l_debug_on THEN
1357: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1358: WSH_DEBUG_SV.pop(l_module_name);
1359: END IF;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366:
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1369: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1371: END IF;*/
1372:
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366:
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1369: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1371: END IF;*/
1372:
1373: END DBI_Update_Trip_Stop_Log;
1366:
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1369: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1371: END IF;*/
1372:
1373: END DBI_Update_Trip_Stop_Log;
1374:
1422: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1423: --
1424: IF l_debug_on IS NULL
1425: THEN
1426: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1427: END IF;
1428: --
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.push(l_module_name);
1426: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1427: END IF;
1428: --
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.push(l_module_name);
1431: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1432: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1433: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1427: END IF;
1428: --
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.push(l_module_name);
1431: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1432: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1433: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1435: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1428: --
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.push(l_module_name);
1431: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1432: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1433: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1435: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1436: END IF;
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.push(l_module_name);
1431: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1432: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1433: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1435: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1436: END IF;
1437:
1430: WSH_DEBUG_SV.push(l_module_name);
1431: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1432: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1433: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1435: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1436: END IF;
1437:
1438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1431: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1432: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1433: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1435: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1436: END IF;
1437:
1438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1439:
1461: IF l_action_rec.action = 'MATCH_GROUPS' AND l_target_rec.entity_type = 'DELIVERY' THEN
1462: --{
1463: IF l_debug_on THEN
1464: --{
1465: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' is ', l_attr_tab.COUNT);
1466: --}
1467: END IF;
1468:
1469: IF l_attr_tab.COUNT > 1 THEN
1470: --{
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF l_debug_on THEN
1473: --{
1474: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');
1475: WSH_DEBUG_SV.pop(l_module_name);
1476: --}
1477: END IF;
1478: RETURN;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF l_debug_on THEN
1473: --{
1474: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');
1475: WSH_DEBUG_SV.pop(l_module_name);
1476: --}
1477: END IF;
1478: RETURN;
1479: --}
1490: SELECT organization_id INTO l_org_id FROM wsh_delivery_details WHERE delivery_detail_id = l_del_det_id;
1491: -- Call wsh_shipping_parameters.Get for appending_limit
1492: IF l_debug_on THEN
1493: --{
1494: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);
1495: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
1496: --}
1497: END IF;
1498:
1491: -- Call wsh_shipping_parameters.Get for appending_limit
1492: IF l_debug_on THEN
1493: --{
1494: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);
1495: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
1496: --}
1497: END IF;
1498:
1499: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_org_id,
1503: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1504: --{
1505: IF l_debug_on THEN
1506: --{
1507: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1508: WSH_DEBUG_SV.pop(l_module_name);
1509: --}
1510: END IF;
1511: RETURN;
1504: --{
1505: IF l_debug_on THEN
1506: --{
1507: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1508: WSH_DEBUG_SV.pop(l_module_name);
1509: --}
1510: END IF;
1511: RETURN;
1512: --}
1513: END IF;
1514:
1515: IF l_debug_on THEN
1516: --{
1517: WSH_DEBUG_SV.log(l_module_name, 'Appending Limit', l_param_info.APPENDING_LIMIT );
1518: --}
1519: END IF;
1520:
1521: IF l_param_info.APPENDING_LIMIT = 'N' THEN
1521: IF l_param_info.APPENDING_LIMIT = 'N' THEN
1522: --{
1523: IF l_debug_on THEN
1524: --{
1525: WSH_DEBUG_SV.log(l_module_name, 'Append Limit is ''Do not append'' and hence exiting..');
1526: WSH_DEBUG_SV.pop(l_module_name);
1527: --}
1528: END IF;
1529: RETURN;
1522: --{
1523: IF l_debug_on THEN
1524: --{
1525: WSH_DEBUG_SV.log(l_module_name, 'Append Limit is ''Do not append'' and hence exiting..');
1526: WSH_DEBUG_SV.pop(l_module_name);
1527: --}
1528: END IF;
1529: RETURN;
1530: --}
1534: WHEN NO_DATA_FOUND THEN
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: IF l_debug_on THEN
1537: --{
1538: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);
1539: WSH_DEBUG_SV.pop(l_module_name);
1540: --}
1541: END IF;
1542: RETURN;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: IF l_debug_on THEN
1537: --{
1538: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);
1539: WSH_DEBUG_SV.pop(l_module_name);
1540: --}
1541: END IF;
1542: RETURN;
1543:
1544: WHEN OTHERS THEN
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: IF l_debug_on THEN
1547: --{
1548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1550: --}
1551: END IF;
1552: RETURN;
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: IF l_debug_on THEN
1547: --{
1548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1550: --}
1551: END IF;
1552: RETURN;
1553: END;
1555: ELSE -- Delivery Detail is Invalid
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: IF l_debug_on THEN
1558: --{
1559: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);
1560: WSH_DEBUG_SV.pop(l_module_name);
1561: --}
1562: END IF;
1563: RETURN;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: IF l_debug_on THEN
1558: --{
1559: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);
1560: WSH_DEBUG_SV.pop(l_module_name);
1561: --}
1562: END IF;
1563: RETURN;
1564: --}
1577: x_return_status => x_return_status);
1578:
1579: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1580: IF l_debug_on THEN
1581: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1582: WSH_DEBUG_SV.pop(l_module_name);
1583: END IF;
1584: RETURN;
1585: END IF;
1578:
1579: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1580: IF l_debug_on THEN
1581: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1582: WSH_DEBUG_SV.pop(l_module_name);
1583: END IF;
1584: RETURN;
1585: END IF;
1586:
1592: -- Move information from l_out_rec to x_out_rec
1593: x_out_rec := l_out_rec;
1594:
1595: IF l_debug_on THEN
1596: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1597: wsh_debug_sv.pop(l_module_name);
1598: END IF;
1599:
1600: EXCEPTION
1593: x_out_rec := l_out_rec;
1594:
1595: IF l_debug_on THEN
1596: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1597: wsh_debug_sv.pop(l_module_name);
1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1601: WHEN OTHERS THEN
1602: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1606: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1608: END IF;
1609:
1602: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1606: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1608: END IF;
1609:
1610: END find_matching_groups;
1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1606: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1608: END IF;
1609:
1610: END find_matching_groups;
1611:
1653: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1654: --
1655: IF l_debug_on IS NULL
1656: THEN
1657: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1658: END IF;
1659: --
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.push(l_module_name);
1657: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1658: END IF;
1659: --
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.push(l_module_name);
1662: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);
1663: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);
1664: END IF;
1665:
1658: END IF;
1659: --
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.push(l_module_name);
1662: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);
1663: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);
1664: END IF;
1665:
1666: IF ( p_source_code IS NULL )
1659: --
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.push(l_module_name);
1662: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);
1663: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);
1664: END IF;
1665:
1666: IF ( p_source_code IS NULL )
1667: THEN
1668: x_msg_count := 1;
1669: x_msg_data := 'INVALID SOURCE_CODE';
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);
1673: WSH_DEBUG_SV.pop(l_module_name);
1674: END IF;
1675: return;
1676: END IF;
1669: x_msg_data := 'INVALID SOURCE_CODE';
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);
1673: WSH_DEBUG_SV.pop(l_module_name);
1674: END IF;
1675: return;
1676: END IF;
1677:
1698: EXCEPTION
1699: WHEN NO_DATA_FOUND THEN
1700: x_cancel_qty_allowed := 0;
1701: IF l_debug_on THEN
1702: WSH_DEBUG_SV.log(l_module_name, 'No Data Found. Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1703: WSH_DEBUG_SV.pop(l_module_name);
1704: END IF;
1705: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1706: FND_MSG_PUB.ADD;
1699: WHEN NO_DATA_FOUND THEN
1700: x_cancel_qty_allowed := 0;
1701: IF l_debug_on THEN
1702: WSH_DEBUG_SV.log(l_module_name, 'No Data Found. Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1703: WSH_DEBUG_SV.pop(l_module_name);
1704: END IF;
1705: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1706: FND_MSG_PUB.ADD;
1707: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1712: --
1713: x_cancel_qty_allowed := l_cancel_qty_allowed;
1714: --
1715: IF l_debug_on THEN
1716: WSH_DEBUG_SV.log(l_module_name, 'l_cancel_qty_allowed: '||to_char(l_cancel_qty_allowed) );
1717: end if;
1718: --
1719: -- Need to do UOM conversion of the Quantity if SRc and REq. differ.
1720: -- and if there are any Cancellable Qtys.
1728: --
1729: x_cancel_qty_allowed := l_src_cancel_qty_allowed;
1730: --
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );
1733: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );
1734: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);
1735: end if;
1736: END IF; --}
1729: x_cancel_qty_allowed := l_src_cancel_qty_allowed;
1730: --
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );
1733: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );
1734: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);
1735: end if;
1736: END IF; --}
1737: --
1730: --
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );
1733: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );
1734: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);
1735: end if;
1736: END IF; --}
1737: --
1738:
1736: END IF; --}
1737: --
1738:
1739: IF l_debug_on THEN
1740: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1741: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);
1742: WSH_DEBUG_SV.pop(l_module_name);
1743: END IF;
1744:
1737: --
1738:
1739: IF l_debug_on THEN
1740: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1741: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);
1742: WSH_DEBUG_SV.pop(l_module_name);
1743: END IF;
1744:
1745: EXCEPTION
1738:
1739: IF l_debug_on THEN
1740: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1741: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);
1742: WSH_DEBUG_SV.pop(l_module_name);
1743: END IF;
1744:
1745: EXCEPTION
1746:
1754: ,p_encoded => FND_API.G_FALSE
1755: );
1756:
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1759: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1761: END IF;
1762:
1755: );
1756:
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1759: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1761: END IF;
1762:
1763: END Get_Cancel_Qty_Allowed;
1756:
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1759: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1761: END IF;
1762:
1763: END Get_Cancel_Qty_Allowed;
1764: --
1855: BEGIN
1856:
1857: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1858: IF l_debug_on IS NULL THEN
1859: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1860: END IF;
1861:
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1861:
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.push(l_module_name);
1866: WSH_DEBUG_SV.log(l_module_name,'header_id ',p_header_id);
1867: WSH_DEBUG_SV.log(l_module_name,'line_id ',p_line_id);
1868: END IF;
1869:
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.push(l_module_name);
1866: WSH_DEBUG_SV.log(l_module_name,'header_id ',p_header_id);
1867: WSH_DEBUG_SV.log(l_module_name,'line_id ',p_line_id);
1868: END IF;
1869:
1870: --If line_id is passed as i/p
1863:
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.push(l_module_name);
1866: WSH_DEBUG_SV.log(l_module_name,'header_id ',p_header_id);
1867: WSH_DEBUG_SV.log(l_module_name,'line_id ',p_line_id);
1868: END IF;
1869:
1870: --If line_id is passed as i/p
1871: IF p_line_id IS NOT NULL THEN
1897: FETCH c_actual_ship_date INTO l_actual_departure_date,l_ship_method_meaning,l_carrier_name;
1898: CLOSE c_actual_ship_date;
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.log(l_module_name,'********** Line_id loop for line_id ',l_line_ids(i));
1902: WSH_DEBUG_SV.log(l_module_name,'actual ship date',l_actual_departure_date);
1903: WSH_DEBUG_SV.log(l_module_name,'Ship Method',l_ship_method_meaning);
1904: WSH_DEBUG_SV.log(l_module_name,'Carrier Name',l_carrier_name);
1905: END IF;
1898: CLOSE c_actual_ship_date;
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.log(l_module_name,'********** Line_id loop for line_id ',l_line_ids(i));
1902: WSH_DEBUG_SV.log(l_module_name,'actual ship date',l_actual_departure_date);
1903: WSH_DEBUG_SV.log(l_module_name,'Ship Method',l_ship_method_meaning);
1904: WSH_DEBUG_SV.log(l_module_name,'Carrier Name',l_carrier_name);
1905: END IF;
1906:
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.log(l_module_name,'********** Line_id loop for line_id ',l_line_ids(i));
1902: WSH_DEBUG_SV.log(l_module_name,'actual ship date',l_actual_departure_date);
1903: WSH_DEBUG_SV.log(l_module_name,'Ship Method',l_ship_method_meaning);
1904: WSH_DEBUG_SV.log(l_module_name,'Carrier Name',l_carrier_name);
1905: END IF;
1906:
1907: --Get the delivery detail and associated container records
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.log(l_module_name,'********** Line_id loop for line_id ',l_line_ids(i));
1902: WSH_DEBUG_SV.log(l_module_name,'actual ship date',l_actual_departure_date);
1903: WSH_DEBUG_SV.log(l_module_name,'Ship Method',l_ship_method_meaning);
1904: WSH_DEBUG_SV.log(l_module_name,'Carrier Name',l_carrier_name);
1905: END IF;
1906:
1907: --Get the delivery detail and associated container records
1908: FOR wdd_lpn_rec IN c_wdd_lpn_for_line(l_line_ids(i)) loop
1920: CLOSE c_assignment;
1921:
1922:
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.log(l_module_name,'wdd_lpn_rec loop count ',ind + 1);
1925: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',x_rec_tab(ind).detail_rec_type.delivery_detail_id);
1926: WSH_DEBUG_SV.log(l_module_name,'parent_delivery_detail_id ',x_rec_tab(ind).parent_delivery_detail_id);
1927: END IF;
1928: ind := ind+1;
1921:
1922:
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.log(l_module_name,'wdd_lpn_rec loop count ',ind + 1);
1925: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',x_rec_tab(ind).detail_rec_type.delivery_detail_id);
1926: WSH_DEBUG_SV.log(l_module_name,'parent_delivery_detail_id ',x_rec_tab(ind).parent_delivery_detail_id);
1927: END IF;
1928: ind := ind+1;
1929: --}
1922:
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.log(l_module_name,'wdd_lpn_rec loop count ',ind + 1);
1925: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',x_rec_tab(ind).detail_rec_type.delivery_detail_id);
1926: WSH_DEBUG_SV.log(l_module_name,'parent_delivery_detail_id ',x_rec_tab(ind).parent_delivery_detail_id);
1927: END IF;
1928: ind := ind+1;
1929: --}
1930: END LOOP;
1932: END LOOP ;
1933:
1934:
1935: IF l_debug_on THEN
1936: WSH_DEBUG_SV.log(l_module_name,'Total records count ',x_rec_tab.count);
1937: WSH_DEBUG_SV.pop(l_module_name);
1938: END IF;
1939:
1940: EXCEPTION
1933:
1934:
1935: IF l_debug_on THEN
1936: WSH_DEBUG_SV.log(l_module_name,'Total records count ',x_rec_tab.count);
1937: WSH_DEBUG_SV.pop(l_module_name);
1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN NO_VALUE_PASSED THEN
1958: close c_actual_ship_date;
1959: END IF;
1960:
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN Get_Delivery_Detail_attributes :line_id and header_id both are not passed' );
1963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_VALUE_PASSED');
1964: END IF;
1965:
1966:
1959: END IF;
1960:
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN Get_Delivery_Detail_attributes :line_id and header_id both are not passed' );
1963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_VALUE_PASSED');
1964: END IF;
1965:
1966:
1967: WHEN OTHERS THEN
1985: close c_actual_ship_date;
1986: END IF;
1987:
1988: IF l_debug_on THEN
1989: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN Get_Delivery_Detail_attributes' );
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1992: END IF;
1993:
1986: END IF;
1987:
1988: IF l_debug_on THEN
1989: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN Get_Delivery_Detail_attributes' );
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1992: END IF;
1993:
1994: END Get_Delivery_Detail_attributes;
1987:
1988: IF l_debug_on THEN
1989: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN Get_Delivery_Detail_attributes' );
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1992: END IF;
1993:
1994: END Get_Delivery_Detail_attributes;
1995: --
2035: --
2036: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2037: --
2038: IF l_debug_on IS NULL THEN
2039: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2040: END IF;
2041: --
2042: IF l_debug_on THEN
2043: WSH_DEBUG_SV.push(l_module_name);
2039: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2040: END IF;
2041: --
2042: IF l_debug_on THEN
2043: WSH_DEBUG_SV.push(l_module_name);
2044: WSH_DEBUG_SV.log(l_module_name,'p_order_source_id',p_order_source_id);
2045: END IF;
2046: IF WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' THEN
2047: --{
2040: END IF;
2041: --
2042: IF l_debug_on THEN
2043: WSH_DEBUG_SV.push(l_module_name);
2044: WSH_DEBUG_SV.log(l_module_name,'p_order_source_id',p_order_source_id);
2045: END IF;
2046: IF WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' THEN
2047: --{
2048: l_return_status := 'N';
2053: l_return_status := nvl(l_return_status,'Y');
2054: --}
2055: END IF;
2056: IF l_debug_on THEN
2057: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2058: WSH_DEBUG_SV.pop(l_module_name);
2059: END IF;
2060: RETURN l_return_status;
2061: EXCEPTION
2054: --}
2055: END IF;
2056: IF l_debug_on THEN
2057: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2058: WSH_DEBUG_SV.pop(l_module_name);
2059: END IF;
2060: RETURN l_return_status;
2061: EXCEPTION
2062: WHEN OTHERS THEN
2062: WHEN OTHERS THEN
2063: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2064: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
2065: IF l_debug_on THEN
2066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2067: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2068: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2069: END IF;
2070: END Validate_Oe_Attributes;
2063: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2064: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
2065: IF l_debug_on THEN
2066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2067: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2068: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2069: END IF;
2070: END Validate_Oe_Attributes;
2071: --
2064: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
2065: IF l_debug_on THEN
2066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2067: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2068: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2069: END IF;
2070: END Validate_Oe_Attributes;
2071: --
2072: -- LSP project : end
2092: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2093: --
2094: IF l_debug_on IS NULL
2095: THEN
2096: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2097: END IF;
2098: --
2099:
2100: IF l_debug_on THEN
2097: END IF;
2098: --
2099:
2100: IF l_debug_on THEN
2101: WSH_DEBUG_SV.push(l_module_name);
2102: END IF;
2103: --
2104: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2105:
2109:
2110: FOR i IN 1..p_detail_rows.count LOOP
2111:
2112: IF l_debug_on THEN
2113: wsh_debug_sv.log(l_module_name,'delivery_detail_id', p_detail_rows(i));
2114: END IF;
2115:
2116: update wsh_delivery_details dd
2117: set inv_interfaced_flag = 'Y',
2127:
2128: END LOOP;
2129:
2130: IF l_debug_on THEN
2131: WSH_DEBUG_SV.pop(l_module_name);
2132: END IF;
2133:
2134: EXCEPTION
2135:
2137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2138: wsh_util_core.default_handler('WSH_INTERFACE.UPDATE_DELIVERY_DETAILS',l_module_name);
2139: --
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2143: END IF;
2144: --
2145: END Update_Delivery_Details;
2138: wsh_util_core.default_handler('WSH_INTERFACE.UPDATE_DELIVERY_DETAILS',l_module_name);
2139: --
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2143: END IF;
2144: --
2145: END Update_Delivery_Details;
2146: --RTV changes