DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_FORM_PKG dependencies on WSH_DEBUG_SV

Line 21: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

17: --
18: BEGIN
19: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
20: IF l_debug_on IS NULL THEN
21: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
22: END IF;
23:
24: IF l_debug_on THEN
25: wsh_debug_sv.push(l_module_name);

Line 25: wsh_debug_sv.push(l_module_name);

21: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
22: END IF;
23:
24: IF l_debug_on THEN
25: wsh_debug_sv.push(l_module_name);
26: wsh_debug_sv.log (l_module_name,'p_item_type',p_item_type);
27: wsh_debug_sv.log (l_module_name,'p_event_key',p_event_key);
28: END IF;
29:

Line 26: wsh_debug_sv.log (l_module_name,'p_item_type',p_item_type);

22: END IF;
23:
24: IF l_debug_on THEN
25: wsh_debug_sv.push(l_module_name);
26: wsh_debug_sv.log (l_module_name,'p_item_type',p_item_type);
27: wsh_debug_sv.log (l_module_name,'p_event_key',p_event_key);
28: END IF;
29:
30: x_return_status := wsh_util_core.g_ret_sts_success;

Line 27: wsh_debug_sv.log (l_module_name,'p_event_key',p_event_key);

23:
24: IF l_debug_on THEN
25: wsh_debug_sv.push(l_module_name);
26: wsh_debug_sv.log (l_module_name,'p_item_type',p_item_type);
27: wsh_debug_sv.log (l_module_name,'p_event_key',p_event_key);
28: END IF;
29:
30: x_return_status := wsh_util_core.g_ret_sts_success;
31:

Line 39: wsh_debug_sv.log (l_module_name,'l_activity',l_activity);

35: l_activity := 'WSH_SUPPLIER_WF:WSH_PROCESS_DELIVERY';
36: END IF;
37:
38: IF l_debug_on THEN
39: wsh_debug_sv.log (l_module_name,'l_activity',l_activity);
40: END IF;
41:
42: Savepoint l_wf_status;
43:

Line 55: wsh_debug_sv.pop(l_module_name);

51:
52: COMMIT;
53:
54: IF l_debug_on THEN
55: wsh_debug_sv.pop(l_module_name);
56: END IF;
57:
58: EXCEPTION
59: WHEN OTHERS THEN

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

59: WHEN OTHERS THEN
60: Rollback to savepoint l_wf_status;
61: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
62: IF l_debug_on THEN
63: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
64: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
66: wsh_debug_sv.stop_debug;
67: END IF;

Line 64: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

60: Rollback to savepoint l_wf_status;
61: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
62: IF l_debug_on THEN
63: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
64: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
66: wsh_debug_sv.stop_debug;
67: END IF;
68: END process_wf_status;

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

61: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
62: IF l_debug_on THEN
63: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
64: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
66: wsh_debug_sv.stop_debug;
67: END IF;
68: END process_wf_status;
69:

Line 66: wsh_debug_sv.stop_debug;

62: IF l_debug_on THEN
63: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
64: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
66: wsh_debug_sv.stop_debug;
67: END IF;
68: END process_wf_status;
69:
70:

Line 123: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

119: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
120: --
121: IF l_debug_on IS NULL
122: THEN
123: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
124: END IF;
125: --
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.start_debug (P_transaction_id);

Line 127: WSH_DEBUG_SV.start_debug (P_transaction_id);

123: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
124: END IF;
125: --
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.start_debug (P_transaction_id);
128: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
129: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
130: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
131: END IF;

Line 128: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');

124: END IF;
125: --
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.start_debug (P_transaction_id);
128: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
129: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
130: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
131: END IF;
132:

Line 129: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);

125: --
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.start_debug (P_transaction_id);
128: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
129: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
130: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
131: END IF;
132:
133: IF (P_transaction_id IS NOT NULL ) THEN --{

Line 130: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);

126: IF l_debug_on THEN
127: WSH_DEBUG_SV.start_debug (P_transaction_id);
128: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
129: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
130: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
131: END IF;
132:
133: IF (P_transaction_id IS NOT NULL ) THEN --{
134: -- R12.1.1 STANDALONE PROJECT

Line 138: wsh_debug_sv.log (l_module_name,'l_wms_deploy_mode', l_wms_deploy_mode);

134: -- R12.1.1 STANDALONE PROJECT
135: l_wms_deploy_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;
136: --
137: IF l_debug_on THEN
138: wsh_debug_sv.log (l_module_name,'l_wms_deploy_mode', l_wms_deploy_mode);
139: END IF;
140: --
141: FOR history_rec in history_cur
142: LOOP

Line 145: wsh_debug_sv.log (l_module_name,'Document Number', history_rec.DOCUMENT_NUMBER);

141: FOR history_rec in history_cur
142: LOOP
143:
144: IF l_debug_on THEN
145: wsh_debug_sv.log (l_module_name,'Document Number', history_rec.DOCUMENT_NUMBER);
146: wsh_debug_sv.log (l_module_name,'transaction_status', history_rec.transaction_status);
147: wsh_debug_sv.log (l_module_name,'document_type', history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'client code',history_rec.client_code);
149: END IF;

Line 146: wsh_debug_sv.log (l_module_name,'transaction_status', history_rec.transaction_status);

142: LOOP
143:
144: IF l_debug_on THEN
145: wsh_debug_sv.log (l_module_name,'Document Number', history_rec.DOCUMENT_NUMBER);
146: wsh_debug_sv.log (l_module_name,'transaction_status', history_rec.transaction_status);
147: wsh_debug_sv.log (l_module_name,'document_type', history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'client code',history_rec.client_code);
149: END IF;
150:

Line 147: wsh_debug_sv.log (l_module_name,'document_type', history_rec.document_type);

143:
144: IF l_debug_on THEN
145: wsh_debug_sv.log (l_module_name,'Document Number', history_rec.DOCUMENT_NUMBER);
146: wsh_debug_sv.log (l_module_name,'transaction_status', history_rec.transaction_status);
147: wsh_debug_sv.log (l_module_name,'document_type', history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'client code',history_rec.client_code);
149: END IF;
150:
151: -- TPW - Distribution Changes - Start

Line 148: wsh_debug_sv.log (l_module_name,'client code',history_rec.client_code);

144: IF l_debug_on THEN
145: wsh_debug_sv.log (l_module_name,'Document Number', history_rec.DOCUMENT_NUMBER);
146: wsh_debug_sv.log (l_module_name,'transaction_status', history_rec.transaction_status);
147: wsh_debug_sv.log (l_module_name,'document_type', history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'client code',history_rec.client_code);
149: END IF;
150:
151: -- TPW - Distribution Changes - Start
152: -- Populate Txn History Record details into l_trns_history_rec variable,

Line 184: wsh_debug_sv.logmsg(l_module_name, 'Item Type: '||history_rec.item_type||' Event Key: '||history_rec.event_key);

180: --R12.1.1 STANDALONE PROJECT
181: IF (l_wms_deploy_mode = 'D' OR ( l_wms_deploy_mode = 'L' and history_rec.client_code IS NOT NULL)) THEN --{ LSP PROJECT : Consider LSP mode also
182:
183: IF l_debug_on THEN
184: wsh_debug_sv.logmsg(l_module_name, 'Item Type: '||history_rec.item_type||' Event Key: '||history_rec.event_key);
185: END IF;
186: --
187: IF (history_rec.item_type is not null) and (history_rec.event_key is not null) THEN
188:

Line 190: wsh_debug_sv.logmsg(l_module_name, 'Calling wf_engine.handleError');

186: --
187: IF (history_rec.item_type is not null) and (history_rec.event_key is not null) THEN
188:
189: IF l_debug_on THEN
190: wsh_debug_sv.logmsg(l_module_name, 'Calling wf_engine.handleError');
191: END IF;
192: wf_engine.handleError(
193: itemType => history_rec.item_type,
194: itemKey => history_rec.event_key,

Line 202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);

198: );
199: ELSE
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);
203: END IF;
204: --
205: WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request(
206: p_commit_flag => FND_API.G_TRUE,

Line 217: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);

213: p_transaction_id => p_transaction_id,
214: x_return_status => l_return_status);
215: --
216: IF l_debug_on THEN
217: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);
218: END IF;
219: --
220: END IF;
221: --

Line 243: wsh_debug_sv.logmsg(l_module_name,

239: l_activity_name := 'WSH_SUPPLIER_WF:WSH_PROCESS_DELIVERY';
240: END IF;
241: --
242: IF l_debug_on THEN
243: wsh_debug_sv.logmsg(l_module_name,
244: 'Calling wf_engine.handleError');
245: END IF;
246: --
247: wf_engine.handleError(

Line 257: wsh_debug_sv.logmsg(l_module_name, 'Calling WSH_PROCESS_INTERFACED_PKG.Process_Inbound');

253: );
254: ELSE
255: --
256: IF l_debug_on THEN
257: wsh_debug_sv.logmsg(l_module_name, 'Calling WSH_PROCESS_INTERFACED_PKG.Process_Inbound');
258: END IF;
259: --
260: -- Call process inbound
261: WSH_PROCESS_INTERFACED_PKG.Process_Inbound(

Line 267: wsh_debug_sv.log (l_module_name,'Process_Inbound: l_return_status', l_return_status);

263: x_return_status => l_return_status );
264:
265: --
266: IF l_debug_on THEN
267: wsh_debug_sv.log (l_module_name,'Process_Inbound: l_return_status', l_return_status);
268: END IF;
269: --
270: END IF;
271: -- TPW - Distribution Changes - End

Line 283: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);

279: IF history_rec.document_type = 'SR' AND
280: ( l_wms_deploy_mode = 'D' OR ( l_wms_deploy_mode = 'L' and history_rec.client_code IS NOT NULL)) THEN --{ LSP PROJECT : Consider LSP mode also
281:
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);
284: END IF;
285:
286: WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request(
287: p_commit_flag => FND_API.G_TRUE,

Line 298: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);

294: p_transaction_id => p_transaction_id,
295: x_return_status => l_return_status);
296:
297: IF l_debug_on THEN
298: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);
299: END IF;
300:
301: -- TPW - Distribution Changes
302: -- Call Process_Inbound api, if document type is SA and its NOT triggered from WF

Line 309: wsh_debug_sv.logmsg(l_module_name, 'For Txn Status AP, Calling WSH_PROCESS_INTERFACED_PKG.Process_Inbound');

305: ELSIF ( history_rec.document_type = 'SA' )
306: THEN
307: --
308: IF l_debug_on THEN
309: wsh_debug_sv.logmsg(l_module_name, 'For Txn Status AP, Calling WSH_PROCESS_INTERFACED_PKG.Process_Inbound');
310: END IF;
311: --
312: -- Call process inbound
313: WSH_PROCESS_INTERFACED_PKG.Process_Inbound(

Line 319: wsh_debug_sv.log (l_module_name,'For Txn Status AP, Process_Inbound: l_return_status', l_return_status);

315: x_return_status => l_return_status );
316:
317: --
318: IF l_debug_on THEN
319: wsh_debug_sv.log (l_module_name,'For Txn Status AP, Process_Inbound: l_return_status', l_return_status);
320: END IF;
321: --
322: -- TPW - Distribution Changes
323: -- Added Comments: Not sure why API wf_engine.completeActivity is invoked, since

Line 327: wsh_debug_sv.logmsg(l_module_name,

323: -- Added Comments: Not sure why API wf_engine.completeActivity is invoked, since
324: -- Txn History record populated from XML Gateway will be with Txn Status 'IP'
325: ELSE --} {
326: IF l_debug_on THEN
327: wsh_debug_sv.logmsg(l_module_name,
328: 'Calling wf_engine.completeActivity');
329: END IF;
330: --
331: wf_engine.completeActivity (

Line 346: wsh_debug_sv.log (l_module_name,'l_trx_status'

342: FETCH c_get_status INTO l_trx_status;
343: CLOSE c_get_status;
344:
345: IF l_debug_on THEN
346: wsh_debug_sv.log (l_module_name,'l_trx_status'
347: , l_trx_status);
348: END IF;
349:
350: IF l_trx_status <> 'SC' THEN

Line 356: wsh_debug_sv.log (l_module_name,'After loop');

352: END IF;
353: END LOOP;
354:
355: IF l_debug_on THEN
356: wsh_debug_sv.log (l_module_name,'After loop');
357: END IF;
358: END IF; --}
359: IF l_debug_on THEN
360: wsh_debug_sv.pop(l_module_name);

Line 360: wsh_debug_sv.pop(l_module_name);

356: wsh_debug_sv.log (l_module_name,'After loop');
357: END IF;
358: END IF; --}
359: IF l_debug_on THEN
360: wsh_debug_sv.pop(l_module_name);
361: wsh_debug_sv.stop_debug;
362: END IF;
363: EXCEPTION
364: WHEN WSH_FAILED_PROCESS THEN

Line 361: wsh_debug_sv.stop_debug;

357: END IF;
358: END IF; --}
359: IF l_debug_on THEN
360: wsh_debug_sv.pop(l_module_name);
361: wsh_debug_sv.stop_debug;
362: END IF;
363: EXCEPTION
364: WHEN WSH_FAILED_PROCESS THEN
365: x_return_status := wsh_util_core.g_ret_sts_error;

Line 369: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

365: x_return_status := wsh_util_core.g_ret_sts_error;
366: FND_MESSAGE.Set_Name('WSH', 'WSH_FAILED_PROCESS');
367: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
368: IF l_debug_on THEN
369: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');
371: wsh_debug_sv.stop_debug;
372: END IF;
373:

Line 370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');

366: FND_MESSAGE.Set_Name('WSH', 'WSH_FAILED_PROCESS');
367: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
368: IF l_debug_on THEN
369: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');
371: wsh_debug_sv.stop_debug;
372: END IF;
373:
374: WHEN OTHERS THEN

Line 371: wsh_debug_sv.stop_debug;

367: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
368: IF l_debug_on THEN
369: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');
371: wsh_debug_sv.stop_debug;
372: END IF;
373:
374: WHEN OTHERS THEN
375: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

373:
374: WHEN OTHERS THEN
375: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
378: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
380: wsh_debug_sv.stop_debug;
381: END IF;

Line 378: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

374: WHEN OTHERS THEN
375: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
378: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
380: wsh_debug_sv.stop_debug;
381: END IF;
382: END process_form;

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

375: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
378: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
380: wsh_debug_sv.stop_debug;
381: END IF;
382: END process_form;
383: END WSH_TRANSACTIONS_FORM_PKG;

Line 380: wsh_debug_sv.stop_debug;

376: IF l_debug_on THEN
377: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
378: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
380: wsh_debug_sv.stop_debug;
381: END IF;
382: END process_form;
383: END WSH_TRANSACTIONS_FORM_PKG;