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_INTEGRATION dependencies on WSH_DEBUG_SV

Line 47: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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);

Line 52: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);

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;

Line 53: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);

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:

Line 54: WSH_DEBUG_SV.log(l_module_name,'line_id',p_in_attributes.line_id);

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 )

Line 55: WSH_DEBUG_SV.log(l_module_name,'dummy_quantity',p_inout_attributes.dummy_quantity);

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

Line 66: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DETAILS_VALIDATIONS.Get_Min_Max_Tolerance_Quantity');

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;

Line 85: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity',x_return_status);

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

Line 90: WSH_DEBUG_SV.pop(l_module_name);

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:

Line 104: WSH_DEBUG_SV.log(l_module_name,'p_inout_attributes.dummy_quantity', p_inout_attributes.dummy_quantity);

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);

Line 105: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity_uom',p_out_attributes.quantity_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);

Line 106: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity',p_out_attributes.min_remaining_quantity);

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);

Line 107: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity',p_out_attributes.max_remaining_quantity);

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);

Line 108: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.quantity2_uom',p_out_attributes.quantity2_uom);

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);

Line 109: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.min_remaining_quantity2',p_out_attributes.min_remaining_quantity2);

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);

Line 110: WSH_DEBUG_SV.log(l_module_name,'p_out_attributes.max_remaining_quantity2',p_out_attributes.max_remaining_quantity2);

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;

Line 111: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

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:

Line 112: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);

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

Line 113: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);

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);

Line 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

Line 131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

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:

Line 132: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;

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

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:

Line 183: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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);

Line 188: WSH_DEBUG_SV.log(l_module_name,'api_version_number',p_in_attributes.api_version_number);

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);

Line 189: WSH_DEBUG_SV.log(l_module_name,'source_code',p_in_attributes.source_code);

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);

Line 190: WSH_DEBUG_SV.log(l_module_name,'closing_fm_date',p_in_attributes.closing_fm_date);

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;

Line 191: WSH_DEBUG_SV.log(l_module_name,'closing_to_date',p_in_attributes.closing_to_date);

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:

Line 192: WSH_DEBUG_SV.log(l_module_name,'organization_id',p_in_attributes.organization_id);

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 )

Line 193: WSH_DEBUG_SV.log(l_module_name,'dummy_count',p_inout_attributes.dummy_count);

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

Line 228: WSH_DEBUG_SV.log(l_module_name,'l_untrxd_rec_count',l_untrxd_rec_count);

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

Line 269: WSH_DEBUG_SV.log(l_module_name,'l_rec_exp_count',l_rec_exp_count);

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;

Line 312: WSH_DEBUG_SV.log(l_module_name,'l_rec_direct_count',l_rec_direct_count);

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;

Line 328: WSH_DEBUG_SV.pop(l_module_name);

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

Line 342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

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:

Line 343: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;

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

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:

Line 463: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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);

Line 468: WSH_DEBUG_SV.log(l_module_name,'p_api_version_number',p_api_version_number);

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);

Line 469: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);

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);

Line 470: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);

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);

Line 471: WSH_DEBUG_SV.log(l_module_name,'move_order_line_id',p_backorder_rec.move_order_line_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;

Line 472: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_backorder_rec.delivery_detail_id);

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:

Line 473: WSH_DEBUG_SV.log(l_module_name,'ship_set_id',p_backorder_rec.ship_set_id);

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:

Line 474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);

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;

Line 529: WSH_DEBUG_SV.pop(l_module_name);

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

Line 546: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

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:

Line 547: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;

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

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:

Line 581: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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');

Line 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(

Line 641: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 644: WSH_DEBUG_SV.start_debug();

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);

Line 646: wsh_debug_sv.push(l_module_name);

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);

Line 647: WSH_DEBUG_SV.log(l_module_name,'p_application_id',p_application_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);

Line 648: WSH_DEBUG_SV.log(l_module_name,'p_conc_program_id',p_conc_program_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);

Line 649: WSH_DEBUG_SV.log(l_module_name,'p_level_type_id',p_level_type_id);

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);

Line 650: WSH_DEBUG_SV.log(l_module_name,'p_level_value_id',p_level_value_id);

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;

Line 651: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);

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:

Line 652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);

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;

Line 653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);

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;

Line 677: wsh_debug_sv.pop(l_module_name,'RETURN');

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;

Line 712: wsh_debug_sv.pop(l_module_name);

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 );

Line 719: wsh_debug_sv.pop(l_module_name,'RETURN');

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');

Line 933: wsh_debug_sv.pop(l_module_name);

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

Line 934: wsh_debug_sv.stop_debug;

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);

Line 942: wsh_debug_sv.pop(l_module_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:

Line 943: wsh_debug_sv.stop_debug;

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

Line 952: wsh_debug_sv.pop(l_module_name);

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:

Line 953: wsh_debug_sv.stop_debug;

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

Line 962: wsh_debug_sv.pop(l_module_name);

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:

Line 963: wsh_debug_sv.stop_debug;

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;

Line 1070: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1066: --
1067: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1068: --
1069: IF l_debug_on IS NULL THEN
1070: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1071: END IF;
1072: --
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.push(l_module_name);

Line 1074: WSH_DEBUG_SV.push(l_module_name);

1070: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1071: END IF;
1072: --
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.push(l_module_name);
1075: END IF;
1076: --
1077: IF G_DBI_IS_INSTALLED IS NULL THEN
1078: G_DBI_IS_INSTALLED := (NVL(FND_PROFILE.VALUE('ISC_WSH_FTE_DBI_INSTALLED'), 'N'));

Line 1081: WSH_DEBUG_SV.log(l_module_name,'G_DBI_IS_INSTALLED',G_DBI_IS_INSTALLED);

1077: IF G_DBI_IS_INSTALLED IS NULL THEN
1078: G_DBI_IS_INSTALLED := (NVL(FND_PROFILE.VALUE('ISC_WSH_FTE_DBI_INSTALLED'), 'N'));
1079: END IF;
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.log(l_module_name,'G_DBI_IS_INSTALLED',G_DBI_IS_INSTALLED);
1082: WSH_DEBUG_SV.pop(l_module_name);
1083: END IF;
1084: RETURN G_DBI_IS_INSTALLED ;
1085:

Line 1082: WSH_DEBUG_SV.pop(l_module_name);

1078: G_DBI_IS_INSTALLED := (NVL(FND_PROFILE.VALUE('ISC_WSH_FTE_DBI_INSTALLED'), 'N'));
1079: END IF;
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.log(l_module_name,'G_DBI_IS_INSTALLED',G_DBI_IS_INSTALLED);
1082: WSH_DEBUG_SV.pop(l_module_name);
1083: END IF;
1084: RETURN G_DBI_IS_INSTALLED ;
1085:
1086: EXCEPTION

Line 1091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1087: WHEN OTHERS THEN
1088: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1089: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1092: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1094: END IF;
1095: END DBI_Installed;

Line 1092: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1088: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1089: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1092: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1094: END IF;
1095: END DBI_Installed;
1096:

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

1089: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1092: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1094: END IF;
1095: END DBI_Installed;
1096:
1097: --========================================================

Line 1118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1114: --
1115: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1116: --
1117: IF l_debug_on IS NULL THEN
1118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1119: END IF;
1120: --
1121: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1122:

Line 1124: WSH_DEBUG_SV.push(l_module_name);

1120: --
1121: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1122:
1123: IF l_debug_on THEN
1124: WSH_DEBUG_SV.push(l_module_name);
1125: WSH_DEBUG_SV.log(l_module_name,'Count Input records',p_wsh_id_tab.count);
1126: END IF;
1127:
1128: -- Conversion is required from WSH datatype to DBI datatype

Line 1125: WSH_DEBUG_SV.log(l_module_name,'Count Input records',p_wsh_id_tab.count);

1121: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1122:
1123: IF l_debug_on THEN
1124: WSH_DEBUG_SV.push(l_module_name);
1125: WSH_DEBUG_SV.log(l_module_name,'Count Input records',p_wsh_id_tab.count);
1126: END IF;
1127:
1128: -- Conversion is required from WSH datatype to DBI datatype
1129: -- Use the same counter while adding records in x_dbi_tab

Line 1134: WSH_DEBUG_SV.log(l_module_name,'Id being converted-',p_wsh_id_tab(i));

1130: FOR i in p_wsh_id_tab.FIRST..p_wsh_id_tab.LAST
1131: LOOP
1132: x_dbi_id_tab(i) := p_wsh_id_tab(i);
1133: IF l_debug_on THEN
1134: WSH_DEBUG_SV.log(l_module_name,'Id being converted-',p_wsh_id_tab(i));
1135: END IF;
1136: END LOOP;
1137:
1138: IF l_debug_on THEN

Line 1139: WSH_DEBUG_SV.log(l_module_name,'Count Output records',x_dbi_id_tab.count);

1135: END IF;
1136: END LOOP;
1137:
1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.log(l_module_name,'Count Output records',x_dbi_id_tab.count);
1140: WSH_DEBUG_SV.pop(l_module_name);
1141: END IF;
1142:
1143: EXCEPTION

Line 1140: WSH_DEBUG_SV.pop(l_module_name);

1136: END LOOP;
1137:
1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.log(l_module_name,'Count Output records',x_dbi_id_tab.count);
1140: WSH_DEBUG_SV.pop(l_module_name);
1141: END IF;
1142:
1143: EXCEPTION
1144: WHEN OTHERS THEN

Line 1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1145: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: wsh_util_core.add_message(x_return_status,l_module_name);
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1150: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1152: END IF;
1153: END WSH_ID_TAB_TO_DBI_ID_TAB;

Line 1150: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: wsh_util_core.add_message(x_return_status,l_module_name);
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1150: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1152: END IF;
1153: END WSH_ID_TAB_TO_DBI_ID_TAB;
1154:

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

1147: wsh_util_core.add_message(x_return_status,l_module_name);
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1150: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1152: END IF;
1153: END WSH_ID_TAB_TO_DBI_ID_TAB;
1154:
1155: --===============================================

Line 1184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1180: --
1181: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1182: --
1183: IF l_debug_on IS NULL THEN
1184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1185: END IF;
1186: --
1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1188: IF l_debug_on THEN

Line 1189: WSH_DEBUG_SV.push(l_module_name);

1185: END IF;
1186: --
1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.push(l_module_name);
1190: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1191: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1192: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1193: END IF;

Line 1190: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);

1186: --
1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.push(l_module_name);
1190: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1191: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1192: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1193: END IF;
1194: --

Line 1191: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);

1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.push(l_module_name);
1190: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1191: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1192: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1193: END IF;
1194: --
1195: -- Check if DBI is installed, possible values are Y or N only

Line 1192: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);

1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.push(l_module_name);
1190: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1191: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);
1192: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1193: END IF;
1194: --
1195: -- Check if DBI is installed, possible values are Y or N only
1196: -- If not installed, then do not proceed , return Success

Line 1202: WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);

1198: IF (WSH_INTEGRATION.DBI_Installed = 'N' OR
1199: p_delivery_detail_id_tab.count < 1)
1200: THEN
1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1203: WSH_DEBUG_SV.pop(l_module_name);
1204: END IF;
1205: RETURN;
1206: END IF;

Line 1203: WSH_DEBUG_SV.pop(l_module_name);

1199: p_delivery_detail_id_tab.count < 1)
1200: THEN
1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1203: WSH_DEBUG_SV.pop(l_module_name);
1204: END IF;
1205: RETURN;
1206: END IF;
1207: --

Line 1216: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);

1212: x_return_status => x_return_status);
1213:
1214: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1217: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1218: END IF;
1219: --
1220: ISC_DBI_CHANGE_LOG_PKG.Update_Del_Detail_Log

Line 1217: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);

1213:
1214: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1217: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1218: END IF;
1219: --
1220: ISC_DBI_CHANGE_LOG_PKG.Update_Del_Detail_Log
1221: (p_detail_list => l_dbi_detail_list,

Line 1240: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

1236: --
1237: END IF;
1238:
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1241: WSH_DEBUG_SV.pop(l_module_name);
1242: END IF;
1243:
1244: EXCEPTION

Line 1241: WSH_DEBUG_SV.pop(l_module_name);

1237: END IF;
1238:
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1241: WSH_DEBUG_SV.pop(l_module_name);
1242: END IF;
1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN

Line 1251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: wsh_util_core.add_message(x_return_status,l_module_name);
1249:
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1252: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1253: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1254: END IF;
1255: END DBI_Update_Detail_Log;

Line 1252: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1248: wsh_util_core.add_message(x_return_status,l_module_name);
1249:
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1252: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1253: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1254: END IF;
1255: END DBI_Update_Detail_Log;
1256:

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

1249:
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1252: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1253: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1254: END IF;
1255: END DBI_Update_Detail_Log;
1256:
1257:

Line 1295: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1291: --
1292: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1293: --
1294: IF l_debug_on IS NULL THEN
1295: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1296: END IF;
1297: --
1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1299: IF l_debug_on THEN

Line 1300: WSH_DEBUG_SV.push(l_module_name);

1296: END IF;
1297: --
1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1299: IF l_debug_on THEN
1300: WSH_DEBUG_SV.push(l_module_name);
1301: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1302: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1303: END IF;
1304: --

Line 1301: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);

1297: --
1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1299: IF l_debug_on THEN
1300: WSH_DEBUG_SV.push(l_module_name);
1301: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1302: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1303: END IF;
1304: --
1305: -- Check if DBI is installed, possible values are Y or N only

Line 1302: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);

1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1299: IF l_debug_on THEN
1300: WSH_DEBUG_SV.push(l_module_name);
1301: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1302: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);
1303: END IF;
1304: --
1305: -- Check if DBI is installed, possible values are Y or N only
1306: -- If not installed, then do not proceed , return Success

Line 1312: WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);

1308: IF (WSH_INTEGRATION.DBI_Installed = 'N' OR
1309: p_stop_id_tab.count < 1)
1310: THEN
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1313: WSH_DEBUG_SV.pop(l_module_name);
1314: END IF;
1315: RETURN;
1316: END IF;

Line 1313: WSH_DEBUG_SV.pop(l_module_name);

1309: p_stop_id_tab.count < 1)
1310: THEN
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.log(l_module_name,'DBI Installed flag-',WSH_INTEGRATION.DBI_Installed);
1313: WSH_DEBUG_SV.pop(l_module_name);
1314: END IF;
1315: RETURN;
1316: END IF;
1317: --

Line 1327: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);

1323:
1324: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1325:
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1328: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1329: END IF;
1330: --
1331: ISC_DBI_CHANGE_LOG_PKG.Update_Trip_Stop_Log

Line 1328: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);

1324: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1325:
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1328: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1329: END IF;
1330: --
1331: ISC_DBI_CHANGE_LOG_PKG.Update_Trip_Stop_Log
1332: (p_stop_list => l_dbi_stop_list,

Line 1351: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

1347: --
1348: END IF;
1349:
1350: IF l_debug_on THEN
1351: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1352: WSH_DEBUG_SV.pop(l_module_name);
1353: END IF;
1354:
1355: EXCEPTION

Line 1352: WSH_DEBUG_SV.pop(l_module_name);

1348: END IF;
1349:
1350: IF l_debug_on THEN
1351: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1352: WSH_DEBUG_SV.pop(l_module_name);
1353: END IF;
1354:
1355: EXCEPTION
1356: WHEN OTHERS THEN

Line 1362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1359: wsh_util_core.add_message(x_return_status,l_module_name);
1360:
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1363: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1364: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1365: END IF;
1366:

Line 1363: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1359: wsh_util_core.add_message(x_return_status,l_module_name);
1360:
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1363: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1364: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1365: END IF;
1366:
1367: END DBI_Update_Trip_Stop_Log;

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

1360:
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1363: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1364: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1365: END IF;
1366:
1367: END DBI_Update_Trip_Stop_Log;
1368:

Line 1420: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1416: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1417: --
1418: IF l_debug_on IS NULL
1419: THEN
1420: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1421: END IF;
1422: --
1423: IF l_debug_on THEN
1424: WSH_DEBUG_SV.push(l_module_name);

Line 1424: WSH_DEBUG_SV.push(l_module_name);

1420: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1421: END IF;
1422: --
1423: IF l_debug_on THEN
1424: WSH_DEBUG_SV.push(l_module_name);
1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);

Line 1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);

1421: END IF;
1422: --
1423: IF l_debug_on THEN
1424: WSH_DEBUG_SV.push(l_module_name);
1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);

Line 1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);

1422: --
1423: IF l_debug_on THEN
1424: WSH_DEBUG_SV.push(l_module_name);
1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1430: END IF;

Line 1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);

1423: IF l_debug_on THEN
1424: WSH_DEBUG_SV.push(l_module_name);
1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1430: END IF;
1431:

Line 1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);

1424: WSH_DEBUG_SV.push(l_module_name);
1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1430: END IF;
1431:
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);

1425: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.action', p_action_rec.action);
1426: WSH_DEBUG_SV.log(l_module_name, 'p_action_rec.output_format_type', p_action_rec.output_format_type);
1427: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab count' , p_attr_tab.count);
1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1430: END IF;
1431:
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1433:

Line 1459: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' is ', l_attr_tab.COUNT);

1455: IF l_action_rec.action = 'MATCH_GROUPS' AND l_target_rec.entity_type = 'DELIVERY' THEN
1456: --{
1457: IF l_debug_on THEN
1458: --{
1459: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' is ', l_attr_tab.COUNT);
1460: --}
1461: END IF;
1462:
1463: IF l_attr_tab.COUNT > 1 THEN

Line 1468: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');

1464: --{
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: IF l_debug_on THEN
1467: --{
1468: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');
1469: WSH_DEBUG_SV.pop(l_module_name);
1470: --}
1471: END IF;
1472: RETURN;

Line 1469: WSH_DEBUG_SV.pop(l_module_name);

1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: IF l_debug_on THEN
1467: --{
1468: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');
1469: WSH_DEBUG_SV.pop(l_module_name);
1470: --}
1471: END IF;
1472: RETURN;
1473: --}

Line 1488: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);

1484: SELECT organization_id INTO l_org_id FROM wsh_delivery_details WHERE delivery_detail_id = l_del_det_id;
1485: -- Call wsh_shipping_parameters.Get for appending_limit
1486: IF l_debug_on THEN
1487: --{
1488: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);
1489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
1490: --}
1491: END IF;
1492:

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

1485: -- Call wsh_shipping_parameters.Get for appending_limit
1486: IF l_debug_on THEN
1487: --{
1488: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);
1489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
1490: --}
1491: END IF;
1492:
1493: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_org_id,

Line 1501: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

1497: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1498: --{
1499: IF l_debug_on THEN
1500: --{
1501: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1502: WSH_DEBUG_SV.pop(l_module_name);
1503: --}
1504: END IF;
1505: RETURN;

Line 1502: WSH_DEBUG_SV.pop(l_module_name);

1498: --{
1499: IF l_debug_on THEN
1500: --{
1501: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1502: WSH_DEBUG_SV.pop(l_module_name);
1503: --}
1504: END IF;
1505: RETURN;
1506: --}

Line 1511: WSH_DEBUG_SV.log(l_module_name, 'Appending Limit', l_param_info.APPENDING_LIMIT );

1507: END IF;
1508:
1509: IF l_debug_on THEN
1510: --{
1511: WSH_DEBUG_SV.log(l_module_name, 'Appending Limit', l_param_info.APPENDING_LIMIT );
1512: --}
1513: END IF;
1514:
1515: IF l_param_info.APPENDING_LIMIT = 'N' THEN

Line 1519: WSH_DEBUG_SV.log(l_module_name, 'Append Limit is ''Do not append'' and hence exiting..');

1515: IF l_param_info.APPENDING_LIMIT = 'N' THEN
1516: --{
1517: IF l_debug_on THEN
1518: --{
1519: WSH_DEBUG_SV.log(l_module_name, 'Append Limit is ''Do not append'' and hence exiting..');
1520: WSH_DEBUG_SV.pop(l_module_name);
1521: --}
1522: END IF;
1523: RETURN;

Line 1520: WSH_DEBUG_SV.pop(l_module_name);

1516: --{
1517: IF l_debug_on THEN
1518: --{
1519: WSH_DEBUG_SV.log(l_module_name, 'Append Limit is ''Do not append'' and hence exiting..');
1520: WSH_DEBUG_SV.pop(l_module_name);
1521: --}
1522: END IF;
1523: RETURN;
1524: --}

Line 1532: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);

1528: WHEN NO_DATA_FOUND THEN
1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: IF l_debug_on THEN
1531: --{
1532: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);
1533: WSH_DEBUG_SV.pop(l_module_name);
1534: --}
1535: END IF;
1536: RETURN;

Line 1533: WSH_DEBUG_SV.pop(l_module_name);

1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: IF l_debug_on THEN
1531: --{
1532: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);
1533: WSH_DEBUG_SV.pop(l_module_name);
1534: --}
1535: END IF;
1536: RETURN;
1537:

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

1538: WHEN OTHERS THEN
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: IF l_debug_on THEN
1541: --{
1542: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1543: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1544: --}
1545: END IF;
1546: RETURN;

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

1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: IF l_debug_on THEN
1541: --{
1542: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1543: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1544: --}
1545: END IF;
1546: RETURN;
1547: END;

Line 1553: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);

1549: ELSE -- Delivery Detail is Invalid
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: IF l_debug_on THEN
1552: --{
1553: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);
1554: WSH_DEBUG_SV.pop(l_module_name);
1555: --}
1556: END IF;
1557: RETURN;

Line 1554: WSH_DEBUG_SV.pop(l_module_name);

1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: IF l_debug_on THEN
1552: --{
1553: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);
1554: WSH_DEBUG_SV.pop(l_module_name);
1555: --}
1556: END IF;
1557: RETURN;
1558: --}

Line 1575: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

1571: x_return_status => x_return_status);
1572:
1573: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1576: WSH_DEBUG_SV.pop(l_module_name);
1577: END IF;
1578: RETURN;
1579: END IF;

Line 1576: WSH_DEBUG_SV.pop(l_module_name);

1572:
1573: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1576: WSH_DEBUG_SV.pop(l_module_name);
1577: END IF;
1578: RETURN;
1579: END IF;
1580:

Line 1590: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

1586: -- Move information from l_out_rec to x_out_rec
1587: x_out_rec := l_out_rec;
1588:
1589: IF l_debug_on THEN
1590: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1591: wsh_debug_sv.pop(l_module_name);
1592: END IF;
1593:
1594: EXCEPTION

Line 1591: wsh_debug_sv.pop(l_module_name);

1587: x_out_rec := l_out_rec;
1588:
1589: IF l_debug_on THEN
1590: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1591: wsh_debug_sv.pop(l_module_name);
1592: END IF;
1593:
1594: EXCEPTION
1595: WHEN OTHERS THEN

Line 1599: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1595: WHEN OTHERS THEN
1596: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1597: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1600: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1602: END IF;
1603:

Line 1600: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1596: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1597: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1600: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1602: END IF;
1603:
1604: END find_matching_groups;

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

1597: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1600: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1602: END IF;
1603:
1604: END find_matching_groups;
1605:

Line 1651: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1647: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1648: --
1649: IF l_debug_on IS NULL
1650: THEN
1651: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1652: END IF;
1653: --
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.push(l_module_name);

Line 1655: WSH_DEBUG_SV.push(l_module_name);

1651: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1652: END IF;
1653: --
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.push(l_module_name);
1656: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);
1657: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);
1658: END IF;
1659:

Line 1656: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);

1652: END IF;
1653: --
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.push(l_module_name);
1656: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);
1657: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);
1658: END IF;
1659:
1660: IF ( p_source_code IS NULL )

Line 1657: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);

1653: --
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.push(l_module_name);
1656: WSH_DEBUG_SV.log(l_module_name,'source_code ',p_source_code);
1657: WSH_DEBUG_SV.log(l_module_name,'src line id ',p_source_line_id);
1658: END IF;
1659:
1660: IF ( p_source_code IS NULL )
1661: THEN

Line 1666: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);

1662: x_msg_count := 1;
1663: x_msg_data := 'INVALID SOURCE_CODE';
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);
1667: WSH_DEBUG_SV.pop(l_module_name);
1668: END IF;
1669: return;
1670: END IF;

Line 1667: WSH_DEBUG_SV.pop(l_module_name);

1663: x_msg_data := 'INVALID SOURCE_CODE';
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);
1667: WSH_DEBUG_SV.pop(l_module_name);
1668: END IF;
1669: return;
1670: END IF;
1671:

Line 1696: WSH_DEBUG_SV.log(l_module_name, 'No Data Found. Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );

1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN
1694: x_cancel_qty_allowed := 0;
1695: IF l_debug_on THEN
1696: WSH_DEBUG_SV.log(l_module_name, 'No Data Found. Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1697: WSH_DEBUG_SV.pop(l_module_name);
1698: END IF;
1699: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1700: FND_MSG_PUB.ADD;

Line 1697: WSH_DEBUG_SV.pop(l_module_name);

1693: WHEN NO_DATA_FOUND THEN
1694: x_cancel_qty_allowed := 0;
1695: IF l_debug_on THEN
1696: WSH_DEBUG_SV.log(l_module_name, 'No Data Found. Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1697: WSH_DEBUG_SV.pop(l_module_name);
1698: END IF;
1699: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1700: FND_MSG_PUB.ADD;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1710: WSH_DEBUG_SV.log(l_module_name, 'l_cancel_qty_allowed: '||to_char(l_cancel_qty_allowed) );

1706: --
1707: x_cancel_qty_allowed := l_cancel_qty_allowed;
1708: --
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.log(l_module_name, 'l_cancel_qty_allowed: '||to_char(l_cancel_qty_allowed) );
1711: end if;
1712: --
1713: -- Need to do UOM conversion of the Quantity if SRc and REq. differ.
1714: -- and if there are any Cancellable Qtys.

Line 1726: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );

1722: --
1723: x_cancel_qty_allowed := l_src_cancel_qty_allowed;
1724: --
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );
1727: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );
1728: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);
1729: end if;
1730: END IF; --}

Line 1727: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );

1723: x_cancel_qty_allowed := l_src_cancel_qty_allowed;
1724: --
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );
1727: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );
1728: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);
1729: end if;
1730: END IF; --}
1731: --

Line 1728: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);

1724: --
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. UOM: '||l_src_requested_quantity_uom );
1727: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. UOM: '||l_requested_quantity_uom );
1728: WSH_DEBUG_SV.log(l_module_name, 'SRC Req. Qty. allowed to be cancelled: '||l_src_cancel_qty_allowed);
1729: end if;
1730: END IF; --}
1731: --
1732:

Line 1734: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );

1730: END IF; --}
1731: --
1732:
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1735: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);
1736: WSH_DEBUG_SV.pop(l_module_name);
1737: END IF;
1738:

Line 1735: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);

1731: --
1732:
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1735: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);
1736: WSH_DEBUG_SV.pop(l_module_name);
1737: END IF;
1738:
1739: EXCEPTION

Line 1736: WSH_DEBUG_SV.pop(l_module_name);

1732:
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1735: WSH_DEBUG_SV.log(l_module_name, 'x_return_status '||x_return_status);
1736: WSH_DEBUG_SV.pop(l_module_name);
1737: END IF;
1738:
1739: EXCEPTION
1740:

Line 1752: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1748: ,p_encoded => FND_API.G_FALSE
1749: );
1750:
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1753: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1755: END IF;
1756:

Line 1753: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1749: );
1750:
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1753: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1755: END IF;
1756:
1757: END Get_Cancel_Qty_Allowed;

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

1750:
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1753: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1755: END IF;
1756:
1757: END Get_Cancel_Qty_Allowed;
1758: --