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

Line 72: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled ;

68: l_status VARCHAR2(1);
69: l_industry VARCHAR2(1);
70:
71: --
72: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled ;
73: --
74: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Worker_Upgrade_Closed_Orders';
75:
76: BEGIN

Line 81: WSH_DEBUG_SV.push(l_module_name);

77: --
78:
79:
80: IF l_debug_on THEN
81: WSH_DEBUG_SV.push(l_module_name);
82: END IF;
83:
84: l_script_name := 'wshupoe_01';
85: --l_table_owner := 'ONT';

Line 101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ad_parallel_updates_pkg.initialize_rowid_range',WSH_DEBUG_SV.C_PROC_LEVEL);

97:
98: l_table_owner := l_Prod_Schema;
99:
100: IF l_debug_on THEN
101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ad_parallel_updates_pkg.initialize_rowid_range',WSH_DEBUG_SV.C_PROC_LEVEL);
102: END IF;
103: ad_parallel_updates_pkg.initialize_rowid_range(
104: ad_parallel_updates_pkg.ROWID_RANGE,
105: l_table_owner,

Line 113: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ad_parallel_updates_pkg.get_rowid_range',WSH_DEBUG_SV.C_PROC_LEVEL);

109: l_num_workers,
110: l_batch_size, 0);
111:
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ad_parallel_updates_pkg.get_rowid_range',WSH_DEBUG_SV.C_PROC_LEVEL);
114: END IF;
115: ad_parallel_updates_pkg.get_rowid_range(
116: l_start_rowid,
117: l_end_rowid,

Line 134: WSH_DEBUG_SV.log(l_module_name,'v_notupg.ship_method_code',v_notupg.ship_method_code);

130: FOR v_notupg IN c_get_comb_notupg
131: LOOP
132:
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.log(l_module_name,'v_notupg.ship_method_code',v_notupg.ship_method_code);
135: WSH_DEBUG_SV.log(l_module_name,'v_notupg.freight_code',v_notupg.freight_code);
136: END IF;
137: l_new_freight_code := null;
138: l_new_carrier_id := null;

Line 135: WSH_DEBUG_SV.log(l_module_name,'v_notupg.freight_code',v_notupg.freight_code);

131: LOOP
132:
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.log(l_module_name,'v_notupg.ship_method_code',v_notupg.ship_method_code);
135: WSH_DEBUG_SV.log(l_module_name,'v_notupg.freight_code',v_notupg.freight_code);
136: END IF;
137: l_new_freight_code := null;
138: l_new_carrier_id := null;
139:

Line 147: WSH_DEBUG_SV.log(l_module_name,'l_new_freight_code',l_new_freight_code);

143: FETCH c_get_new_fgt_code INTO l_new_freight_code, l_new_carrier_id;
144: CLOSE c_get_new_fgt_code;
145:
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.log(l_module_name,'l_new_freight_code',l_new_freight_code);
148: WSH_DEBUG_SV.log(l_module_name,'l_new_carrier_id',l_new_carrier_id);
149: END IF;
150:
151: -- Update Closed Order Lines, Interfaced to Shpg. and Not cancelled

Line 148: WSH_DEBUG_SV.log(l_module_name,'l_new_carrier_id',l_new_carrier_id);

144: CLOSE c_get_new_fgt_code;
145:
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.log(l_module_name,'l_new_freight_code',l_new_freight_code);
148: WSH_DEBUG_SV.log(l_module_name,'l_new_carrier_id',l_new_carrier_id);
149: END IF;
150:
151: -- Update Closed Order Lines, Interfaced to Shpg. and Not cancelled
152: update /*+ ROWID (oel) */ oe_order_lines_all oel

Line 212: WSH_DEBUG_SV.pop(l_module_name);

208:
209: END LOOP;
210:
211: IF l_debug_on THEN
212: WSH_DEBUG_SV.pop(l_module_name);
213: END IF;
214: EXCEPTION
215: WHEN OTHERS THEN
216: errbuf := 'Exception occurred in Worker_Upgrade_Closed_Orders: ' ||

Line 221: WSH_DEBUG_SV.pop(l_module_name);

217: 'SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm;
218: retcode := '2';
219: --
220: IF l_debug_on THEN
221: WSH_DEBUG_SV.pop(l_module_name);
222: END IF;
223: END Worker_Upgrade_Closed_Orders;
224:
225: Procedure Master_Conc_Parallel_Upgrade(

Line 233: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

229: p_worker_conc_program IN VARCHAR2,
230: p_batch_commit_size IN NUMBER,
231: p_numworkers IN NUMBER) IS
232:
233: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
234: --
235: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Worker_Upgrade_Closed_Orders';
236: BEGIN
237:

Line 239: WSH_DEBUG_SV.push(l_module_name);

235: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Worker_Upgrade_Closed_Orders';
236: BEGIN
237:
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.push(l_module_name);
240: END IF;
241: AD_CONC_UTILS_PKG.submit_subrequests(
242: X_errbuf => errbuf,
243: X_retcode => retcode,

Line 257: WSH_DEBUG_SV.pop(l_module_name);

253: X_Argument9 => NULL,
254: X_Argument10 => NULL);
255:
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.pop(l_module_name);
258: END IF;
259: END Master_Conc_Parallel_Upgrade;
260:
261:

Line 355: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

351: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
352: --
353: IF l_debug_on IS NULL
354: THEN
355: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
356: END IF;
357: --
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.push(l_module_name);

Line 359: WSH_DEBUG_SV.push(l_module_name);

355: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
356: END IF;
357: --
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.push(l_module_name);
360: WSH_DEBUG_SV.log(l_module_name, 'p_entity', p_entity);
361: WSH_DEBUG_SV.log(l_module_name, 'in x_count', x_count);
362: WSH_DEBUG_SV.log(l_module_name, 'in x_count_nu', x_count_nu);
363: WSH_DEBUG_SV.log(l_module_name, 'in x_sm_state', x_sm_state);

Line 360: WSH_DEBUG_SV.log(l_module_name, 'p_entity', p_entity);

356: END IF;
357: --
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.push(l_module_name);
360: WSH_DEBUG_SV.log(l_module_name, 'p_entity', p_entity);
361: WSH_DEBUG_SV.log(l_module_name, 'in x_count', x_count);
362: WSH_DEBUG_SV.log(l_module_name, 'in x_count_nu', x_count_nu);
363: WSH_DEBUG_SV.log(l_module_name, 'in x_sm_state', x_sm_state);
364: END IF;

Line 361: WSH_DEBUG_SV.log(l_module_name, 'in x_count', x_count);

357: --
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.push(l_module_name);
360: WSH_DEBUG_SV.log(l_module_name, 'p_entity', p_entity);
361: WSH_DEBUG_SV.log(l_module_name, 'in x_count', x_count);
362: WSH_DEBUG_SV.log(l_module_name, 'in x_count_nu', x_count_nu);
363: WSH_DEBUG_SV.log(l_module_name, 'in x_sm_state', x_sm_state);
364: END IF;
365:

Line 362: WSH_DEBUG_SV.log(l_module_name, 'in x_count_nu', x_count_nu);

358: IF l_debug_on THEN
359: WSH_DEBUG_SV.push(l_module_name);
360: WSH_DEBUG_SV.log(l_module_name, 'p_entity', p_entity);
361: WSH_DEBUG_SV.log(l_module_name, 'in x_count', x_count);
362: WSH_DEBUG_SV.log(l_module_name, 'in x_count_nu', x_count_nu);
363: WSH_DEBUG_SV.log(l_module_name, 'in x_sm_state', x_sm_state);
364: END IF;
365:
366: IF (p_entity IS NULL)

Line 363: WSH_DEBUG_SV.log(l_module_name, 'in x_sm_state', x_sm_state);

359: WSH_DEBUG_SV.push(l_module_name);
360: WSH_DEBUG_SV.log(l_module_name, 'p_entity', p_entity);
361: WSH_DEBUG_SV.log(l_module_name, 'in x_count', x_count);
362: WSH_DEBUG_SV.log(l_module_name, 'in x_count_nu', x_count_nu);
363: WSH_DEBUG_SV.log(l_module_name, 'in x_sm_state', x_sm_state);
364: END IF;
365:
366: IF (p_entity IS NULL)
367: OR (p_entity NOT IN (G_ENTITY_TRIP, G_ENTITY_DEL,G_ENTITY_DETAIL)) THEN

Line 369: WSH_DEBUG_SV.log(l_module_name, 'unrecognized p_entity', p_entity);

365:
366: IF (p_entity IS NULL)
367: OR (p_entity NOT IN (G_ENTITY_TRIP, G_ENTITY_DEL,G_ENTITY_DETAIL)) THEN
368: IF l_debug_on THEN
369: WSH_DEBUG_SV.log(l_module_name, 'unrecognized p_entity', p_entity);
370: WSH_DEBUG_SV.pop(l_module_name);
371: END IF;
372: RETURN;
373: END IF;

Line 370: WSH_DEBUG_SV.pop(l_module_name);

366: IF (p_entity IS NULL)
367: OR (p_entity NOT IN (G_ENTITY_TRIP, G_ENTITY_DEL,G_ENTITY_DETAIL)) THEN
368: IF l_debug_on THEN
369: WSH_DEBUG_SV.log(l_module_name, 'unrecognized p_entity', p_entity);
370: WSH_DEBUG_SV.pop(l_module_name);
371: END IF;
372: RETURN;
373: END IF;
374:

Line 403: WSH_DEBUG_SV.log(l_module_name, 'l_work_ids.COUNT', l_work_ids.COUNT);

399: l_continue := c_current_details%FOUND;
400: END IF;
401:
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.log(l_module_name, 'l_work_ids.COUNT', l_work_ids.COUNT);
404: WSH_DEBUG_SV.log(l_module_name, 'l_continue', l_continue);
405: END IF;
406:
407: IF (l_work_ids.COUNT > 0) THEN

Line 404: WSH_DEBUG_SV.log(l_module_name, 'l_continue', l_continue);

400: END IF;
401:
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.log(l_module_name, 'l_work_ids.COUNT', l_work_ids.COUNT);
404: WSH_DEBUG_SV.log(l_module_name, 'l_continue', l_continue);
405: END IF;
406:
407: IF (l_work_ids.COUNT > 0) THEN
408: FOR l_work_index IN 1 .. l_work_ids.COUNT LOOP

Line 442: WSH_DEBUG_SV.log(l_module_name, 'l_update_index', l_update_index);

438:
439: IF (l_update_index >= G_BULK_SIZE)
440: OR ( (NOT l_continue) AND (l_update_index > 0) ) THEN
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.log(l_module_name, 'l_update_index', l_update_index);
443: END IF;
444:
445: IF p_entity = G_ENTITY_TRIP THEN
446: FORALL i IN 1 .. l_update_index

Line 491: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);

487: IF c_current_dels%ISOPEN THEN CLOSE c_current_dels; END IF;
488: IF c_current_details%ISOPEN THEN CLOSE c_current_details; END IF;
489:
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
492: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
493: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
494: WSH_DEBUG_SV.pop(l_module_name);
495: END IF;

Line 492: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);

488: IF c_current_details%ISOPEN THEN CLOSE c_current_details; END IF;
489:
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
492: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
493: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
494: WSH_DEBUG_SV.pop(l_module_name);
495: END IF;
496:

Line 493: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);

489:
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
492: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
493: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
494: WSH_DEBUG_SV.pop(l_module_name);
495: END IF;
496:
497: EXCEPTION

Line 494: WSH_DEBUG_SV.pop(l_module_name);

490: IF l_debug_on THEN
491: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
492: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
493: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
494: WSH_DEBUG_SV.pop(l_module_name);
495: END IF;
496:
497: EXCEPTION
498: WHEN OTHERS THEN

Line 504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'

500: IF c_current_dels%ISOPEN THEN CLOSE c_current_dels; END IF;
501: IF c_current_details%ISOPEN THEN CLOSE c_current_details; END IF;
502: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);

Line 505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);

501: IF c_current_details%ISOPEN THEN CLOSE c_current_details; END IF;
502: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
509: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);

502: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
509: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
510: END IF;

Line 507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);

503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
509: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
510: END IF;
511: RAISE;

Line 508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);

504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
509: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
510: END IF;
511: RAISE;
512:

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

505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);
507: WSH_DEBUG_SV.log(l_module_name, 'out x_count_nu', x_count_nu);
508: WSH_DEBUG_SV.log(l_module_name, 'out x_sm_state', x_sm_state);
509: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
510: END IF;
511: RAISE;
512:
513: END process_entity_sm;

Line 565: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

561: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
562: --
563: IF l_debug_on IS NULL
564: THEN
565: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
566: END IF;
567: --
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.push(l_module_name);

Line 569: WSH_DEBUG_SV.push(l_module_name);

565: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
566: END IF;
567: --
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.push(l_module_name);
570: WSH_DEBUG_SV.log(l_module_name,'p_carrier_service_id',
571: p_carrier_service_id);
572: WSH_DEBUG_SV.log(l_module_name,'p_new_state', p_new_state);
573: END IF;

Line 570: WSH_DEBUG_SV.log(l_module_name,'p_carrier_service_id',

566: END IF;
567: --
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.push(l_module_name);
570: WSH_DEBUG_SV.log(l_module_name,'p_carrier_service_id',
571: p_carrier_service_id);
572: WSH_DEBUG_SV.log(l_module_name,'p_new_state', p_new_state);
573: END IF;
574: --

Line 572: WSH_DEBUG_SV.log(l_module_name,'p_new_state', p_new_state);

568: IF l_debug_on THEN
569: WSH_DEBUG_SV.push(l_module_name);
570: WSH_DEBUG_SV.log(l_module_name,'p_carrier_service_id',
571: p_carrier_service_id);
572: WSH_DEBUG_SV.log(l_module_name,'p_new_state', p_new_state);
573: END IF;
574: --
575: SAVEPOINT sp_before_lock;
576: --

Line 609: WSH_DEBUG_SV.log(l_module_name, 'return value', l_found);

605: WHERE carrier_service_id = p_carrier_service_id;
606: END IF;
607:
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.log(l_module_name, 'return value', l_found);
610: WSH_DEBUG_SV.pop(l_module_name);
611: END IF;
612: RETURN l_found;
613:

Line 610: WSH_DEBUG_SV.pop(l_module_name);

606: END IF;
607:
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.log(l_module_name, 'return value', l_found);
610: WSH_DEBUG_SV.pop(l_module_name);
611: END IF;
612: RETURN l_found;
613:
614: EXCEPTION

Line 619: WSH_DEBUG_SV.logmsg(l_module_name,

615: WHEN app_exception.record_lock_exception THEN
616: IF c_lock_service%ISOPEN THEN CLOSE c_lock_service; END IF;
617: IF c_request_completed%ISOPEN THEN CLOSE c_request_completed; END IF;
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,
620: 'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',
621: WSH_DEBUG_SV.C_EXCEP_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,
623: 'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');

Line 621: WSH_DEBUG_SV.C_EXCEP_LEVEL);

617: IF c_request_completed%ISOPEN THEN CLOSE c_request_completed; END IF;
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,
620: 'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',
621: WSH_DEBUG_SV.C_EXCEP_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,
623: 'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
624: END IF;
625: RETURN FALSE;

Line 622: WSH_DEBUG_SV.pop(l_module_name,

618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,
620: 'APP_EXCEPTION.RECORD_LOCK_EXCEPTION exception has occured.',
621: WSH_DEBUG_SV.C_EXCEP_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,
623: 'EXCEPTION:APP_EXCEPTION.RECORD_LOCK_EXCEPTION');
624: END IF;
625: RETURN FALSE;
626:

Line 632: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'

628: IF c_lock_service%ISOPEN THEN CLOSE c_lock_service; END IF;
629: IF c_request_completed%ISOPEN THEN CLOSE c_request_completed; END IF;
630: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
633: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
634: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
635: END IF;
636: RAISE;

Line 633: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);

629: IF c_request_completed%ISOPEN THEN CLOSE c_request_completed; END IF;
630: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
633: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
634: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
635: END IF;
636: RAISE;
637:

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

630: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
633: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
634: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
635: END IF;
636: RAISE;
637:
638: END lock_stamp_service;

Line 690: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

686: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
687: --
688: IF l_debug_on IS NULL
689: THEN
690: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
691: END IF;
692:
693: IF l_debug_on THEN
694: WSH_DEBUG_SV.push(l_module_name);

Line 694: WSH_DEBUG_SV.push(l_module_name);

690: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
691: END IF;
692:
693: IF l_debug_on THEN
694: WSH_DEBUG_SV.push(l_module_name);
695: END IF;
696:
697: l_completion_status := 'NORMAL';
698: l_errbuf := '';

Line 818: WSH_DEBUG_SV.log(l_module_name,

814:
815: l_completion_status := 'ERROR';
816: l_errbuf := SQLERRM;
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.log(l_module_name,
819: 'Internal unexpected error has occured. Oracle error message',
820: l_errbuf,
821: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
822: END IF;

Line 821: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

817: IF l_debug_on THEN
818: WSH_DEBUG_SV.log(l_module_name,
819: 'Internal unexpected error has occured. Oracle error message',
820: l_errbuf,
821: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
822: END IF;
823: WSH_UTIL_CORE.printmsg(l_errbuf);
824:
825: IF c_ship_methods%ISOPEN THEN CLOSE c_ship_methods; END IF;

Line 840: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS', l_completion_status);

836: errbuf := l_errbuf;
837: retcode := l_retcode;
838:
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS', l_completion_status);
841: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
842: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
843: WSH_DEBUG_SV.pop(l_module_name);
844: END IF;

Line 841: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);

837: retcode := l_retcode;
838:
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS', l_completion_status);
841: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
842: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
843: WSH_DEBUG_SV.pop(l_module_name);
844: END IF;
845:

Line 842: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);

838:
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS', l_completion_status);
841: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
842: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
843: WSH_DEBUG_SV.pop(l_module_name);
844: END IF;
845:
846:

Line 843: WSH_DEBUG_SV.pop(l_module_name);

839: IF l_debug_on THEN
840: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS', l_completion_status);
841: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
842: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
843: WSH_DEBUG_SV.pop(l_module_name);
844: END IF;
845:
846:
847: EXCEPTION

Line 854: WSH_DEBUG_SV.log(l_module_name,

850:
851: l_completion_status := 'ERROR';
852: l_errbuf := SQLERRM;
853: IF l_debug_on THEN
854: WSH_DEBUG_SV.log(l_module_name,
855: 'API unexpected error has occured. Oracle error message',
856: l_errbuf,
857: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
858: END IF;

Line 857: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

853: IF l_debug_on THEN
854: WSH_DEBUG_SV.log(l_module_name,
855: 'API unexpected error has occured. Oracle error message',
856: l_errbuf,
857: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
858: END IF;
859: WSH_UTIL_CORE.printmsg(l_errbuf);
860:
861: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,

Line 867: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS',

863: errbuf := l_errbuf;
864: retcode := l_retcode;
865:
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS',
868: l_completion_status);
869: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
870: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
871: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 869: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);

865:
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS',
868: l_completion_status);
869: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
870: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
871: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
872: END IF;
873: ROLLBACK;

Line 870: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);

866: IF l_debug_on THEN
867: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS',
868: l_completion_status);
869: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
870: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
871: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
872: END IF;
873: ROLLBACK;
874:

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

867: WSH_DEBUG_SV.log(l_module_name,'COMPLETION STATUS',
868: l_completion_status);
869: WSH_DEBUG_SV.log(l_module_name,'ERRBUF', l_errbuf);
870: WSH_DEBUG_SV.log(l_module_name,'RETCODE', l_retcode);
871: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');
872: END IF;
873: ROLLBACK;
874:
875: END update_ship_method_SRS;