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

Line 116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 120: wsh_debug_sv.push(l_module_name, 'Get_Warehouse_Type');

116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
117: END IF;
118: --
119: IF l_debug_on THEN
120: wsh_debug_sv.push(l_module_name, 'Get_Warehouse_Type');
121: wsh_debug_sv.log (l_module_name,'Event Key', p_event_key);
122: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
123: wsh_debug_sv.log (l_module_name,'Delivery Id', p_delivery_id);
124: wsh_debug_sv.log (l_module_name,'Delivery Detail Id', p_delivery_detail_id);

Line 121: wsh_debug_sv.log (l_module_name,'Event Key', p_event_key);

117: END IF;
118: --
119: IF l_debug_on THEN
120: wsh_debug_sv.push(l_module_name, 'Get_Warehouse_Type');
121: wsh_debug_sv.log (l_module_name,'Event Key', p_event_key);
122: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
123: wsh_debug_sv.log (l_module_name,'Delivery Id', p_delivery_id);
124: wsh_debug_sv.log (l_module_name,'Delivery Detail Id', p_delivery_detail_id);
125: END IF;

Line 122: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);

118: --
119: IF l_debug_on THEN
120: wsh_debug_sv.push(l_module_name, 'Get_Warehouse_Type');
121: wsh_debug_sv.log (l_module_name,'Event Key', p_event_key);
122: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
123: wsh_debug_sv.log (l_module_name,'Delivery Id', p_delivery_id);
124: wsh_debug_sv.log (l_module_name,'Delivery Detail Id', p_delivery_detail_id);
125: END IF;
126:

Line 123: wsh_debug_sv.log (l_module_name,'Delivery Id', p_delivery_id);

119: IF l_debug_on THEN
120: wsh_debug_sv.push(l_module_name, 'Get_Warehouse_Type');
121: wsh_debug_sv.log (l_module_name,'Event Key', p_event_key);
122: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
123: wsh_debug_sv.log (l_module_name,'Delivery Id', p_delivery_id);
124: wsh_debug_sv.log (l_module_name,'Delivery Detail Id', p_delivery_detail_id);
125: END IF;
126:
127: IF (p_event_key IS NOT NULL) THEN

Line 124: wsh_debug_sv.log (l_module_name,'Delivery Detail Id', p_delivery_detail_id);

120: wsh_debug_sv.push(l_module_name, 'Get_Warehouse_Type');
121: wsh_debug_sv.log (l_module_name,'Event Key', p_event_key);
122: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
123: wsh_debug_sv.log (l_module_name,'Delivery Id', p_delivery_id);
124: wsh_debug_sv.log (l_module_name,'Delivery Detail Id', p_delivery_detail_id);
125: END IF;
126:
127: IF (p_event_key IS NOT NULL) THEN
128: IF l_debug_on THEN

Line 129: wsh_debug_sv.log (l_module_name,'Event Key Not null', p_event_key);

125: END IF;
126:
127: IF (p_event_key IS NOT NULL) THEN
128: IF l_debug_on THEN
129: wsh_debug_sv.log (l_module_name,'Event Key Not null', p_event_key);
130: END IF;
131:
132: l_warehouse_type := SUBSTRB (p_event_key, 1, 3);
133: ELSIF ( p_organization_id IS NULL ) THEN

Line 149: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get x_return_status ',x_return_status);

145:
146: l_otm_enabled_flag := l_shipping_param_info.otm_enabled;
147:
148: IF l_debug_on THEN
149: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get x_return_status ',x_return_status);
150: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled',l_shipping_param_info.otm_enabled);
151: END IF;
152: --
153: IF (x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 150: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled',l_shipping_param_info.otm_enabled);

146: l_otm_enabled_flag := l_shipping_param_info.otm_enabled;
147:
148: IF l_debug_on THEN
149: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get x_return_status ',x_return_status);
150: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled',l_shipping_param_info.otm_enabled);
151: END IF;
152: --
153: IF (x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
154: Raise wsh_ship_param_failed;

Line 166: wsh_debug_sv.log (l_module_name,'TPW Flag', l_tpw_flag);

162: OPEN wh_flag_cur;
163: FETCH wh_flag_cur INTO l_cms_flag, l_tpw_flag;
164: CLOSE wh_flag_cur;
165: IF l_debug_on THEN
166: wsh_debug_sv.log (l_module_name,'TPW Flag', l_tpw_flag);
167: wsh_debug_sv.log (l_module_name,'CMS Flag', l_cms_flag);
168: END IF;
169: IF ( NVL (l_tpw_flag, '!') = 'Y' ) THEN
170: l_warehouse_type := 'TPW';

Line 167: wsh_debug_sv.log (l_module_name,'CMS Flag', l_cms_flag);

163: FETCH wh_flag_cur INTO l_cms_flag, l_tpw_flag;
164: CLOSE wh_flag_cur;
165: IF l_debug_on THEN
166: wsh_debug_sv.log (l_module_name,'TPW Flag', l_tpw_flag);
167: wsh_debug_sv.log (l_module_name,'CMS Flag', l_cms_flag);
168: END IF;
169: IF ( NVL (l_tpw_flag, '!') = 'Y' ) THEN
170: l_warehouse_type := 'TPW';
171: ELSIF ( NVL (l_cms_flag, '!') = 'Y' ) THEN

Line 195: wsh_debug_sv.log (l_module_name,'Manifest Enabled Flag', l_manifest_enabled_flag);

191: END LOOP;
192: END IF;
193:
194: IF l_debug_on THEN
195: wsh_debug_sv.log (l_module_name,'Manifest Enabled Flag', l_manifest_enabled_flag);
196: END IF;
197:
198: IF ( nvl( l_manifest_enabled_flag, '!') = 'Y' ) THEN
199: l_warehouse_type := 'CMS';

Line 218: wsh_debug_sv.log (l_module_name, 'Warehouse Type' , l_warehouse_type);

214:
215: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
216:
217: IF l_debug_on THEN
218: wsh_debug_sv.log (l_module_name, 'Warehouse Type' , l_warehouse_type);
219: wsh_debug_sv.pop (l_module_name);
220: END IF;
221:
222: RETURN l_warehouse_type;

Line 219: wsh_debug_sv.pop (l_module_name);

215: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
216:
217: IF l_debug_on THEN
218: wsh_debug_sv.log (l_module_name, 'Warehouse Type' , l_warehouse_type);
219: wsh_debug_sv.pop (l_module_name);
220: END IF;
221:
222: RETURN l_warehouse_type;
223: EXCEPTION

Line 227: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_org_event_key_null exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

223: EXCEPTION
224: WHEN wsh_org_event_key_null THEN
225: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_org_event_key_null exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');
229: END IF;
230: RETURN l_warehouse_type;
231: WHEN wsh_ship_param_failed THEN

Line 228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');

224: WHEN wsh_org_event_key_null THEN
225: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_org_event_key_null exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');
229: END IF;
230: RETURN l_warehouse_type;
231: WHEN wsh_ship_param_failed THEN
232: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 234: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_ship_param_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

230: RETURN l_warehouse_type;
231: WHEN wsh_ship_param_failed THEN
232: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_ship_param_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_ship_param_failed');
236: END IF;
237: RETURN l_warehouse_type;
238:

Line 235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_ship_param_failed');

231: WHEN wsh_ship_param_failed THEN
232: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_ship_param_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_ship_param_failed');
236: END IF;
237: RETURN l_warehouse_type;
238:
239: WHEN OTHERS THEN

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

238:
239: WHEN OTHERS THEN
240: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
243: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
245: END IF;
246: RETURN l_warehouse_type;

Line 243: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

239: WHEN OTHERS THEN
240: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
243: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
245: END IF;
246: RETURN l_warehouse_type;
247: END Get_Warehouse_Type;

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

240: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
243: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
245: END IF;
246: RETURN l_warehouse_type;
247: END Get_Warehouse_Type;
248:

Line 326: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

322: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
323: --
324: IF l_debug_on IS NULL
325: THEN
326: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
327: END IF;
328: --
329: IF l_debug_on THEN
330: wsh_debug_sv.push(l_module_name);

Line 330: wsh_debug_sv.push(l_module_name);

326: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
327: END IF;
328: --
329: IF l_debug_on THEN
330: wsh_debug_sv.push(l_module_name);
331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);
332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);

Line 331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);

327: END IF;
328: --
329: IF l_debug_on THEN
330: wsh_debug_sv.push(l_module_name);
331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);
332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);

Line 332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);

328: --
329: IF l_debug_on THEN
330: wsh_debug_sv.push(l_module_name);
331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);
332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);

Line 333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);

329: IF l_debug_on THEN
330: wsh_debug_sv.push(l_module_name);
331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);
332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);

Line 334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);

330: wsh_debug_sv.push(l_module_name);
331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);
332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);

Line 335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);

331: WSH_DEBUG_SV.log(l_module_name,'transaction_id',P_txn_hist_record.transaction_id);
332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);

Line 336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);

332: WSH_DEBUG_SV.log(l_module_name,'document_type',P_txn_hist_record.document_type);
333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);

Line 337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);

333: WSH_DEBUG_SV.log(l_module_name,'document_direction',P_txn_hist_record.document_direction);
334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);

Line 338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);

334: WSH_DEBUG_SV.log(l_module_name,'document_number',P_txn_hist_record.document_number);
335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);

Line 339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);

335: WSH_DEBUG_SV.log(l_module_name,'orig_document_number',P_txn_hist_record.orig_document_number);
336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);

Line 340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);

336: WSH_DEBUG_SV.log(l_module_name,'entity_number',P_txn_hist_record.entity_number);
337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);

Line 341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);

337: WSH_DEBUG_SV.log(l_module_name,'entity_type',P_txn_hist_record.entity_type);
338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);

Line 342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);

338: WSH_DEBUG_SV.log(l_module_name,'trading_partner_id',P_txn_hist_record.trading_partner_id);
339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);
346: END IF;

Line 343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);

339: WSH_DEBUG_SV.log(l_module_name,'action_type',P_txn_hist_record.action_type);
340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);
346: END IF;
347: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);

340: WSH_DEBUG_SV.log(l_module_name,'transaction_status',P_txn_hist_record.transaction_status);
341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);
346: END IF;
347: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
348:

Line 345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);

341: WSH_DEBUG_SV.log(l_module_name,'ecx_message_id',P_txn_hist_record.ecx_message_id);
342: WSH_DEBUG_SV.log(l_module_name,'event_name',P_txn_hist_record.event_name);
343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);
346: END IF;
347: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
348:
349: l_txn_hist_record := P_txn_hist_record;

Line 371: wsh_debug_sv.log (l_module_name, 'Transaction Code' , l_Transaction_Code);

367: -- Eg: 'SSRO', 'SSAI' etc
368: l_Transaction_Code := UPPER (SUBSTRB (l_event_name, INSTRB(l_Event_Name, '.', -1) + 1));
369:
370: IF l_debug_on THEN
371: wsh_debug_sv.log (l_module_name, 'Transaction Code' , l_Transaction_Code);
372: END IF;
373:
374: -- Get the Event Key for Raising an Event.
375: --bmos k proj

Line 386: wsh_debug_sv.log (l_module_name, 'Return status after get_event_key' , l_Return_Status);

382: l_Event_Key,
383: l_Return_Status );
384:
385: IF l_debug_on THEN
386: wsh_debug_sv.log (l_module_name, 'Return status after get_event_key' , l_Return_Status);
387: END IF;
388:
389: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
390: RAISE wsh_get_event_key_error;

Line 398: wsh_debug_sv.log (l_module_name, 'Event Key' , l_Event_Key);

394: ELSE
395: l_Event_Key := l_txn_hist_record.Event_Key;
396: END IF;
397: IF l_debug_on THEN
398: wsh_debug_sv.log (l_module_name, 'Event Key' , l_Event_Key);
399: wsh_debug_sv.log (l_module_name, 'Trading partner ID ' , l_txn_hist_record.Trading_Partner_ID);
400: wsh_debug_sv.log (l_module_name, 'Entity Number ' , l_txn_hist_record.Entity_Number);
401: END IF;
402:

Line 399: wsh_debug_sv.log (l_module_name, 'Trading partner ID ' , l_txn_hist_record.Trading_Partner_ID);

395: l_Event_Key := l_txn_hist_record.Event_Key;
396: END IF;
397: IF l_debug_on THEN
398: wsh_debug_sv.log (l_module_name, 'Event Key' , l_Event_Key);
399: wsh_debug_sv.log (l_module_name, 'Trading partner ID ' , l_txn_hist_record.Trading_Partner_ID);
400: wsh_debug_sv.log (l_module_name, 'Entity Number ' , l_txn_hist_record.Entity_Number);
401: END IF;
402:
403: IF ( l_Transaction_Code IN ('SSRO', 'SSAO') ) THEN --{

Line 400: wsh_debug_sv.log (l_module_name, 'Entity Number ' , l_txn_hist_record.Entity_Number);

396: END IF;
397: IF l_debug_on THEN
398: wsh_debug_sv.log (l_module_name, 'Event Key' , l_Event_Key);
399: wsh_debug_sv.log (l_module_name, 'Trading partner ID ' , l_txn_hist_record.Trading_Partner_ID);
400: wsh_debug_sv.log (l_module_name, 'Entity Number ' , l_txn_hist_record.Entity_Number);
401: END IF;
402:
403: IF ( l_Transaction_Code IN ('SSRO', 'SSAO') ) THEN --{
404: OPEN l_New_Del_Cur (l_txn_hist_record.Trading_Partner_ID, l_txn_hist_record.entity_number);

Line 412: wsh_debug_sv.log (l_module_name, 'Party Site ID' , l_Party_Site_ID);

408: RAISE wsh_invalid_delivery_no;
409: END IF;
410: CLOSE l_New_Del_Cur;
411: IF l_debug_on THEN
412: wsh_debug_sv.log (l_module_name, 'Party Site ID' , l_Party_Site_ID);
413: END IF;
414: END IF; --}
415:
416: IF ( l_Transaction_Code in ('SSRO', 'SSAO') ) THEN --{

Line 478: wsh_debug_sv.log (l_module_name, 'l_subject' , l_subject);

474: END IF;
475: END IF; --}
476:
477: IF l_debug_on THEN
478: wsh_debug_sv.log (l_module_name, 'l_subject' , l_subject);
479: END IF;
480:
481: WF_EVENT.AddParameterToList (p_name => 'SUBJECT',
482: p_value => l_subject,

Line 501: wsh_debug_sv.log (l_module_name, 'l_del_name' ,l_del_name );

497: FETCH get_customer_name INTO l_customer;
498: CLOSE get_customer_name;
499:
500: IF l_debug_on THEN
501: wsh_debug_sv.log (l_module_name, 'l_del_name' ,l_del_name );
502: wsh_debug_sv.log (l_module_name, 'l_sf_location' ,l_sf_location );
503: wsh_debug_sv.log (l_module_name, 'l_customer' ,l_customer );
504: wsh_debug_sv.log (l_module_name, 'l_st_location' ,l_st_location);
505: END IF;

Line 502: wsh_debug_sv.log (l_module_name, 'l_sf_location' ,l_sf_location );

498: CLOSE get_customer_name;
499:
500: IF l_debug_on THEN
501: wsh_debug_sv.log (l_module_name, 'l_del_name' ,l_del_name );
502: wsh_debug_sv.log (l_module_name, 'l_sf_location' ,l_sf_location );
503: wsh_debug_sv.log (l_module_name, 'l_customer' ,l_customer );
504: wsh_debug_sv.log (l_module_name, 'l_st_location' ,l_st_location);
505: END IF;
506:

Line 503: wsh_debug_sv.log (l_module_name, 'l_customer' ,l_customer );

499:
500: IF l_debug_on THEN
501: wsh_debug_sv.log (l_module_name, 'l_del_name' ,l_del_name );
502: wsh_debug_sv.log (l_module_name, 'l_sf_location' ,l_sf_location );
503: wsh_debug_sv.log (l_module_name, 'l_customer' ,l_customer );
504: wsh_debug_sv.log (l_module_name, 'l_st_location' ,l_st_location);
505: END IF;
506:
507: WF_EVENT.AddParameterToList (p_name => 'DEL_NAME',

Line 504: wsh_debug_sv.log (l_module_name, 'l_st_location' ,l_st_location);

500: IF l_debug_on THEN
501: wsh_debug_sv.log (l_module_name, 'l_del_name' ,l_del_name );
502: wsh_debug_sv.log (l_module_name, 'l_sf_location' ,l_sf_location );
503: wsh_debug_sv.log (l_module_name, 'l_customer' ,l_customer );
504: wsh_debug_sv.log (l_module_name, 'l_st_location' ,l_st_location);
505: END IF;
506:
507: WF_EVENT.AddParameterToList (p_name => 'DEL_NAME',
508: p_value => l_del_name,

Line 569: wsh_debug_sv.log (l_module_name, 'Transaction History return status ' , l_Return_Status);

565: l_txns_id,
566: l_return_status );
567:
568: IF l_debug_on THEN
569: wsh_debug_sv.log (l_module_name, 'Transaction History return status ' , l_Return_Status);
570: wsh_debug_sv.log (l_module_name, 'Transaction History ID' , l_txns_id);
571: END IF;
572:
573: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

Line 570: wsh_debug_sv.log (l_module_name, 'Transaction History ID' , l_txns_id);

566: l_return_status );
567:
568: IF l_debug_on THEN
569: wsh_debug_sv.log (l_module_name, 'Transaction History return status ' , l_Return_Status);
570: wsh_debug_sv.log (l_module_name, 'Transaction History ID' , l_txns_id);
571: END IF;
572:
573: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
574: RAISE wsh_update_history;

Line 581: wsh_debug_sv.log (l_module_name, 'Before Raising Event');

577: COMMIT;
578: END IF;
579:
580: IF l_debug_on THEN
581: wsh_debug_sv.log (l_module_name, 'Before Raising Event');
582: END IF;
583:
584: IF ( l_Transaction_Code IN ('SSRO', 'SSAO') ) THEN
585: WF_EVENT.raise ( p_event_name => l_event_name,

Line 598: wsh_debug_sv.log (l_module_name, 'End of Raising Event');

594: p_event_key => l_Event_Key );
595: END IF;
596:
597: IF l_debug_on THEN
598: wsh_debug_sv.log (l_module_name, 'End of Raising Event');
599: wsh_debug_sv.pop(l_module_name);
600: END IF;
601: EXCEPTION
602: WHEN wsh_invalid_event_name THEN

Line 599: wsh_debug_sv.pop(l_module_name);

595: END IF;
596:
597: IF l_debug_on THEN
598: wsh_debug_sv.log (l_module_name, 'End of Raising Event');
599: wsh_debug_sv.pop(l_module_name);
600: END IF;
601: EXCEPTION
602: WHEN wsh_invalid_event_name THEN
603: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 605: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

601: EXCEPTION
602: WHEN wsh_invalid_event_name THEN
603: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
606: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
607: END IF;
608:
609: WHEN wsh_get_event_key_error THEN

Line 606: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');

602: WHEN wsh_invalid_event_name THEN
603: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
606: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
607: END IF;
608:
609: WHEN wsh_get_event_key_error THEN
610: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 612: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_event_key_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

608:
609: WHEN wsh_get_event_key_error THEN
610: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_event_key_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');
614: END IF;
615:
616: WHEN wsh_invalid_delivery_no THEN

Line 613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');

609: WHEN wsh_get_event_key_error THEN
610: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_event_key_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');
614: END IF;
615:
616: WHEN wsh_invalid_delivery_no THEN
617: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 619: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_no exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

615:
616: WHEN wsh_invalid_delivery_no THEN
617: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_no exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');
621: END IF;
622:
623: WHEN wsh_update_history THEN

Line 620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');

616: WHEN wsh_invalid_delivery_no THEN
617: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_no exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');
621: END IF;
622:
623: WHEN wsh_update_history THEN
624: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 626: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

622:
623: WHEN wsh_update_history THEN
624: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
628: END IF;
629:
630: WHEN OTHERS THEN

Line 627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');

623: WHEN wsh_update_history THEN
624: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
628: END IF;
629:
630: WHEN OTHERS THEN
631: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

629:
630: WHEN OTHERS THEN
631: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
634: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
636: END IF;
637: END Raise_Event;

Line 634: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

630: WHEN OTHERS THEN
631: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
634: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
636: END IF;
637: END Raise_Event;
638:

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

631: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
634: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
636: END IF;
637: END Raise_Event;
638:
639:

Line 663: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

659: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
660: --
661: IF l_debug_on IS NULL
662: THEN
663: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
664: END IF;
665: --
666: IF l_debug_on THEN
667: wsh_debug_sv.push(l_module_name);

Line 667: wsh_debug_sv.push(l_module_name);

663: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
664: END IF;
665: --
666: IF l_debug_on THEN
667: wsh_debug_sv.push(l_module_name);
668: wsh_debug_sv.log (l_module_name, 'Item Name ', p_concatenated_segments);
669: wsh_debug_sv.log (l_module_name, 'Org Id ', p_organization_id);
670: END IF;
671:

Line 668: wsh_debug_sv.log (l_module_name, 'Item Name ', p_concatenated_segments);

664: END IF;
665: --
666: IF l_debug_on THEN
667: wsh_debug_sv.push(l_module_name);
668: wsh_debug_sv.log (l_module_name, 'Item Name ', p_concatenated_segments);
669: wsh_debug_sv.log (l_module_name, 'Org Id ', p_organization_id);
670: END IF;
671:
672: IF ( p_concatenated_segments is not null and p_organization_id is not null ) THEN

Line 669: wsh_debug_sv.log (l_module_name, 'Org Id ', p_organization_id);

665: --
666: IF l_debug_on THEN
667: wsh_debug_sv.push(l_module_name);
668: wsh_debug_sv.log (l_module_name, 'Item Name ', p_concatenated_segments);
669: wsh_debug_sv.log (l_module_name, 'Org Id ', p_organization_id);
670: END IF;
671:
672: IF ( p_concatenated_segments is not null and p_organization_id is not null ) THEN
673: open get_item_id_cur;

Line 687: wsh_debug_sv.pop (l_module_name);

683: x_return_status := wsh_util_core.g_ret_sts_success;
684: END IF;
685:
686: IF l_debug_on THEN
687: wsh_debug_sv.pop (l_module_name);
688: END IF;
689: EXCEPTION
690: WHEN OTHERS THEN
691: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

692: IF get_item_id_cur%ISOPEN THEN
693: close get_item_id_cur;
694: END IF;
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
697: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
699: END IF;
700: END Validate_Item;

Line 697: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

693: close get_item_id_cur;
694: END IF;
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
697: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
699: END IF;
700: END Validate_Item;
701:

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

694: END IF;
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
697: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
699: END IF;
700: END Validate_Item;
701:
702: PROCEDURE Validate_Ship_To ( p_customer_name IN VARCHAR2,

Line 785: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

781: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
782: --
783: IF l_debug_on IS NULL
784: THEN
785: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
786: END IF;
787: --
788: IF l_debug_on THEN
789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');

Line 789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');

785: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
786: END IF;
787: --
788: IF l_debug_on THEN
789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');
790: wsh_debug_sv.log (l_module_name, 'Customer Name ', p_customer_name);
791: wsh_debug_sv.log (l_module_name, 'Location ', p_location);
792: wsh_debug_sv.log (l_module_name, 'Site Use Code ', p_site_use_code);
793: wsh_debug_sv.log (l_module_name, 'operating unit ', p_org_id);

Line 790: wsh_debug_sv.log (l_module_name, 'Customer Name ', p_customer_name);

786: END IF;
787: --
788: IF l_debug_on THEN
789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');
790: wsh_debug_sv.log (l_module_name, 'Customer Name ', p_customer_name);
791: wsh_debug_sv.log (l_module_name, 'Location ', p_location);
792: wsh_debug_sv.log (l_module_name, 'Site Use Code ', p_site_use_code);
793: wsh_debug_sv.log (l_module_name, 'operating unit ', p_org_id);
794: END IF;

Line 791: wsh_debug_sv.log (l_module_name, 'Location ', p_location);

787: --
788: IF l_debug_on THEN
789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');
790: wsh_debug_sv.log (l_module_name, 'Customer Name ', p_customer_name);
791: wsh_debug_sv.log (l_module_name, 'Location ', p_location);
792: wsh_debug_sv.log (l_module_name, 'Site Use Code ', p_site_use_code);
793: wsh_debug_sv.log (l_module_name, 'operating unit ', p_org_id);
794: END IF;
795:

Line 792: wsh_debug_sv.log (l_module_name, 'Site Use Code ', p_site_use_code);

788: IF l_debug_on THEN
789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');
790: wsh_debug_sv.log (l_module_name, 'Customer Name ', p_customer_name);
791: wsh_debug_sv.log (l_module_name, 'Location ', p_location);
792: wsh_debug_sv.log (l_module_name, 'Site Use Code ', p_site_use_code);
793: wsh_debug_sv.log (l_module_name, 'operating unit ', p_org_id);
794: END IF;
795:
796: IF ( p_customer_name is not null and p_location is not null ) THEN

Line 793: wsh_debug_sv.log (l_module_name, 'operating unit ', p_org_id);

789: wsh_debug_sv.push(l_module_name, 'Validate_Ship_To');
790: wsh_debug_sv.log (l_module_name, 'Customer Name ', p_customer_name);
791: wsh_debug_sv.log (l_module_name, 'Location ', p_location);
792: wsh_debug_sv.log (l_module_name, 'Site Use Code ', p_site_use_code);
793: wsh_debug_sv.log (l_module_name, 'operating unit ', p_org_id);
794: END IF;
795:
796: IF ( p_customer_name is not null and p_location is not null ) THEN
797: IF l_debug_on THEN

Line 798: wsh_debug_sv.logmsg(l_module_name, 'Using get_loc_id_cur');

794: END IF;
795:
796: IF ( p_customer_name is not null and p_location is not null ) THEN
797: IF l_debug_on THEN
798: wsh_debug_sv.logmsg(l_module_name, 'Using get_loc_id_cur');
799: END IF;
800: open get_loc_id_cur;
801: Fetch get_loc_id_cur into l_location_id, x_customer_id, x_site_use_id;
802:

Line 806: wsh_debug_sv.logmsg(l_module_name, 'Using c_rel_cust_loc_cur');

802:
803: IF get_loc_id_cur%NOTFOUND THEN
804: --{ bug 3920178 begin
805: IF l_debug_on THEN
806: wsh_debug_sv.logmsg(l_module_name, 'Using c_rel_cust_loc_cur');
807: END IF;
808: OPEN c_rel_cust_loc_cur;
809: FETCH c_rel_cust_loc_cur INTO l_location_id, x_customer_id, x_site_use_id;
810:

Line 821: wsh_debug_sv.log(l_module_name, 'l_location_id', l_location_id);

817: END IF;
818: close get_loc_id_cur;
819:
820: IF l_debug_on THEN
821: wsh_debug_sv.log(l_module_name, 'l_location_id', l_location_id);
822: END IF;
823:
824: IF l_location_id IS NULL THEN
825: --bug 3920178 end

Line 832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MAP_LOCATION_REGION_PKG.TRANSFER_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

828: -- Patchset I : Locations Project. kvenkate.
829: -- Call Transfer Location API
830:
831: IF l_debug_on THEN
832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_MAP_LOCATION_REGION_PKG.TRANSFER_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
833: END IF;
834:
835: WSH_MAP_LOCATION_REGION_PKG.Transfer_Location(
836: p_source_type => 'HZ',

Line 857: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);

853: x_return_status := wsh_util_core.g_ret_sts_success;
854: END IF;
855:
856: IF l_debug_on THEN
857: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);
858: wsh_debug_sv.log(l_module_name, 'Customer Id', x_customer_id);
859: wsh_debug_sv.log(l_module_name, 'Site Use Id', x_site_use_id);
860: wsh_debug_sv.pop (l_module_name);
861: END IF;

Line 858: wsh_debug_sv.log(l_module_name, 'Customer Id', x_customer_id);

854: END IF;
855:
856: IF l_debug_on THEN
857: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);
858: wsh_debug_sv.log(l_module_name, 'Customer Id', x_customer_id);
859: wsh_debug_sv.log(l_module_name, 'Site Use Id', x_site_use_id);
860: wsh_debug_sv.pop (l_module_name);
861: END IF;
862: EXCEPTION

Line 859: wsh_debug_sv.log(l_module_name, 'Site Use Id', x_site_use_id);

855:
856: IF l_debug_on THEN
857: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);
858: wsh_debug_sv.log(l_module_name, 'Customer Id', x_customer_id);
859: wsh_debug_sv.log(l_module_name, 'Site Use Id', x_site_use_id);
860: wsh_debug_sv.pop (l_module_name);
861: END IF;
862: EXCEPTION
863: WHEN fnd_api.g_exc_error THEN

Line 860: wsh_debug_sv.pop (l_module_name);

856: IF l_debug_on THEN
857: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);
858: wsh_debug_sv.log(l_module_name, 'Customer Id', x_customer_id);
859: wsh_debug_sv.log(l_module_name, 'Site Use Id', x_site_use_id);
860: wsh_debug_sv.pop (l_module_name);
861: END IF;
862: EXCEPTION
863: WHEN fnd_api.g_exc_error THEN
864: x_return_status := wsh_util_core.g_ret_sts_error;

Line 869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

865: IF get_loc_id_cur%ISOPEN THEN
866: close get_loc_id_cur;
867: END IF;
868: IF l_debug_on THEN
869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
871: END IF;
872: WHEN OTHERS THEN
873: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

866: close get_loc_id_cur;
867: END IF;
868: IF l_debug_on THEN
869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
871: END IF;
872: WHEN OTHERS THEN
873: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
874: IF get_loc_id_cur%ISOPEN THEN

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

874: IF get_loc_id_cur%ISOPEN THEN
875: close get_loc_id_cur;
876: END IF;
877: IF l_debug_on THEN
878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
879: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
880: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
881: END IF;
882:

Line 879: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

875: close get_loc_id_cur;
876: END IF;
877: IF l_debug_on THEN
878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
879: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
880: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
881: END IF;
882:
883: END Validate_Ship_To;

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

876: END IF;
877: IF l_debug_on THEN
878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
879: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
880: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
881: END IF;
882:
883: END Validate_Ship_To;
884: