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_TRANSACTIONS_HISTORY_PKG dependencies on WSH_UTIL_CORE

Line 95: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

91: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
92: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
93: END IF;
94:
95: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
96:
97: -- First check for null values
98: IF (
99: p_txns_history_rec.document_type IS NOT NULL AND

Line 187: wsh_util_core.api_post_call(

183: p_msg_data => l_msg_data,
184: p_api_name => 'WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History',
185: x_return_status => l_return_status);
186:
187: wsh_util_core.api_post_call(
188: p_return_status => l_return_status,
189: x_num_warnings => l_number_of_warnings,
190: x_num_errors => l_number_of_errors);
191:

Line 343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

339: END IF;
340: ELSE
341:
342: -- Not Null checks failed. Return Error
343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
344:
345: END IF; -- if p_txns_history_rec columns are not null
346:
347: IF l_debug_on THEN

Line 352: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

348: wsh_debug_sv.pop(l_module_name);
349: END IF;
350: EXCEPTION
351: WHEN invalid_status THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
355: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');
356: END IF;

Line 358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

354: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
355: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');
356: END IF;
357: WHEN invalid_action THEN
358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
362: END IF;

Line 364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

360: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
362: END IF;
363: WHEN invalid_entity_type THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
367: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
368: END IF;

Line 370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

366: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
367: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
368: END IF;
369: WHEN invalid_direction THEN
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
373: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');
374: END IF;

Line 376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

372: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
373: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');
374: END IF;
375: WHEN invalid_document_type THEN
376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');
380: END IF;

Line 382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

378: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');
380: END IF;
381: WHEN Others THEN
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
385: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

460: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
461: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
462: END IF;
463:
464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
465:
466: OPEN txns_history_cur;
467: FETCH txns_history_cur INTO p_txns_history_rec;
468:

Line 486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

482: IF(txns_history_cur%ISOPEN) THEN
483: CLOSE txns_history_cur;
484: END IF;
485:
486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
489: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
490: END IF;

Line 492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

488: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
489: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
490: END IF;
491: WHEN Others THEN
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
495: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
566: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
567: END IF;
568:
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
570:
571: l_txn_hist_rec.transaction_id := p_transaction_id;
572: l_txn_hist_rec.document_type := p_document_type;
573: l_txn_hist_rec.document_direction := p_document_direction;

Line 596: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

592: IF l_debug_on THEN
593: wsh_debug_sv.log (l_module_name, 'Return status from Create_Update_Txns_History', l_return_status);
594: END IF;
595:
596: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
597: raise create_update_failed;
598: END IF;
599: IF l_debug_on THEN
600: wsh_debug_sv.pop(l_module_name);

Line 604: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

600: wsh_debug_sv.pop(l_module_name);
601: END IF;
602: EXCEPTION
603: WHEN create_update_failed THEN
604: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
605: IF l_debug_on THEN
606: wsh_debug_sv.pop(l_module_name);
607: END IF;
608: WHEN Others THEN

Line 609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

605: IF l_debug_on THEN
606: wsh_debug_sv.pop(l_module_name);
607: END IF;
608: WHEN Others THEN
609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
610: IF l_debug_on THEN
611: wsh_debug_sv.pop(l_module_name,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
612: END IF;
613: END Create_Txns_History;