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 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.start_debug (P_transaction_id);

Line 120: WSH_DEBUG_SV.start_debug (P_transaction_id);

116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
117: END IF;
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.start_debug (P_transaction_id);
121: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
122: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
123: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
124: END IF;

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

117: END IF;
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.start_debug (P_transaction_id);
121: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
122: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
123: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
124: END IF;
125:

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

118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.start_debug (P_transaction_id);
121: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
122: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
123: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
124: END IF;
125:
126: IF (P_transaction_id IS NOT NULL ) THEN --{

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

119: IF l_debug_on THEN
120: WSH_DEBUG_SV.start_debug (P_transaction_id);
121: wsh_debug_sv.push(l_module_name, 'PROCESS_FORM');
122: wsh_debug_sv.log (l_module_name,'Transaction ID', P_Transaction_id);
123: wsh_debug_sv.log (l_module_name,'DELIVERY ID', P_delivery_id);
124: END IF;
125:
126: IF (P_transaction_id IS NOT NULL ) THEN --{
127: FOR history_rec in history_cur

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

126: IF (P_transaction_id IS NOT NULL ) THEN --{
127: FOR history_rec in history_cur
128: LOOP
129: IF l_debug_on THEN
130: wsh_debug_sv.log (l_module_name,'Document Number', history_rec.DOCUMENT_NUMBER);
131: END IF;
132:
133: --bmso k proj
134: IF l_debug_on THEN

Line 135: wsh_debug_sv.log (l_module_name,'transaction_status',

131: END IF;
132:
133: --bmso k proj
134: IF l_debug_on THEN
135: wsh_debug_sv.log (l_module_name,'transaction_status',
136: history_rec.transaction_status);
137: wsh_debug_sv.log (l_module_name,'document_type',
138: history_rec.document_type);
139: END IF;

Line 137: wsh_debug_sv.log (l_module_name,'document_type',

133: --bmso k proj
134: IF l_debug_on THEN
135: wsh_debug_sv.log (l_module_name,'transaction_status',
136: history_rec.transaction_status);
137: wsh_debug_sv.log (l_module_name,'document_type',
138: history_rec.document_type);
139: END IF;
140: --
141: IF history_rec.transaction_status = 'ER'

Line 146: wsh_debug_sv.logmsg(l_module_name,

142: THEN --{
143: IF history_rec.document_type = 'SR' THEN --{
144: --
145: IF l_debug_on THEN
146: wsh_debug_sv.logmsg(l_module_name,
147: 'Calling wf_engine.handleError');
148: END IF;
149: --
150: wf_engine.handleError(

Line 160: wsh_debug_sv.logmsg(l_module_name,

156: );
157: ELSE --}{
158: --
159: IF l_debug_on THEN
160: wsh_debug_sv.logmsg(l_module_name,
161: 'Calling wf_engine.handleError');
162: END IF;
163: --
164: wf_engine.handleError(

Line 177: wsh_debug_sv.logmsg(l_module_name,

173: ELSIF history_rec.transaction_status = 'AP'
174: THEN --}{
175: --
176: IF l_debug_on THEN
177: wsh_debug_sv.logmsg(l_module_name,
178: 'Calling wf_engine.completeActivity');
179: END IF;
180: --
181: wf_engine.completeActivity (

Line 191: wsh_debug_sv.logmsg(l_module_name,

187: END IF; --}
188:
189: --
190: IF l_debug_on THEN
191: wsh_debug_sv.logmsg(l_module_name,
192: 'Calling wf_engine.itemStatus');
193: END IF;
194: --
195: OPEN c_get_status(P_transaction_id);

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

196: FETCH c_get_status INTO l_trx_status;
197: CLOSE c_get_status;
198:
199: IF l_debug_on THEN
200: wsh_debug_sv.log (l_module_name,'l_trx_status'
201: , l_trx_status);
202: END IF;
203:
204: IF l_trx_status <> 'SC' THEN --{

Line 216: wsh_debug_sv.log (l_module_name,'l_wf_status'

212: result => l_wf_result
213: );
214:
215: IF l_debug_on THEN
216: wsh_debug_sv.log (l_module_name,'l_wf_status'
217: , l_wf_status);
218: END IF;
219:
220: IF l_wf_status <> 'COMPLETE' THEN --{

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

224:
225: END LOOP;
226:
227: IF l_debug_on THEN
228: wsh_debug_sv.log (l_module_name,'After loop');
229: END IF;
230: END IF; --}
231: IF l_debug_on THEN
232: wsh_debug_sv.pop(l_module_name);

Line 232: wsh_debug_sv.pop(l_module_name);

228: wsh_debug_sv.log (l_module_name,'After loop');
229: END IF;
230: END IF; --}
231: IF l_debug_on THEN
232: wsh_debug_sv.pop(l_module_name);
233: wsh_debug_sv.stop_debug;
234: END IF;
235: EXCEPTION
236: WHEN WSH_FAILED_PROCESS THEN

Line 233: wsh_debug_sv.stop_debug;

229: END IF;
230: END IF; --}
231: IF l_debug_on THEN
232: wsh_debug_sv.pop(l_module_name);
233: wsh_debug_sv.stop_debug;
234: END IF;
235: EXCEPTION
236: WHEN WSH_FAILED_PROCESS THEN
237: x_return_status := wsh_util_core.g_ret_sts_error;

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

237: x_return_status := wsh_util_core.g_ret_sts_error;
238: FND_MESSAGE.Set_Name('WSH', 'WSH_FAILED_PROCESS');
239: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');
243: wsh_debug_sv.stop_debug;
244: END IF;
245:

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

238: FND_MESSAGE.Set_Name('WSH', 'WSH_FAILED_PROCESS');
239: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');
243: wsh_debug_sv.stop_debug;
244: END IF;
245:
246: WHEN OTHERS THEN

Line 243: wsh_debug_sv.stop_debug;

239: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAILED_PROCESS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAILED_PROCESS');
243: wsh_debug_sv.stop_debug;
244: END IF;
245:
246: WHEN OTHERS THEN
247: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

245:
246: WHEN OTHERS THEN
247: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: wsh_debug_sv.stop_debug;
253: END IF;

Line 250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

246: WHEN OTHERS THEN
247: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: wsh_debug_sv.stop_debug;
253: END IF;
254: END process_form;

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

247: X_return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: wsh_debug_sv.stop_debug;
253: END IF;
254: END process_form;
255: END WSH_TRANSACTIONS_FORM_PKG;

Line 252: wsh_debug_sv.stop_debug;

248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: wsh_debug_sv.stop_debug;
253: END IF;
254: END process_form;
255: END WSH_TRANSACTIONS_FORM_PKG;