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 98: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

94: --R12.1.1 STANDALONE PROJECT
95: wsh_debug_sv.log (l_module_name, 'Doc Revision', p_txns_history_Rec.document_revision);
96: END IF;
97:
98: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
99:
100: -- First check for null values
101: IF (
102: p_txns_history_rec.document_type IS NOT NULL AND

Line 190: wsh_util_core.api_post_call(

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

Line 362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

358: END IF;
359: ELSE
360:
361: -- Not Null checks failed. Return Error
362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
363:
364: END IF; -- if p_txns_history_rec columns are not null
365:
366: IF l_debug_on THEN

Line 371: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

379: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
381: END IF;
382: WHEN invalid_entity_type THEN
383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
387: END IF;

Line 389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

385: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
387: END IF;
388: WHEN invalid_direction THEN
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');
393: END IF;

Line 395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

391: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');
393: END IF;
394: WHEN invalid_document_type THEN
395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');
399: END IF;

Line 401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

397: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');
399: END IF;
400: WHEN Others THEN
401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
404: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
486: END IF;
487:
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
489:
490: OPEN txns_history_cur;
491: FETCH txns_history_cur INTO p_txns_history_rec;
492:

Line 510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

506: IF(txns_history_cur%ISOPEN) THEN
507: CLOSE txns_history_cur;
508: END IF;
509:
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
514: END IF;

Line 516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

512: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
514: END IF;
515: WHEN Others THEN
516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
519: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 596: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

592: --R12.1.1 STANDALONE PROJECT
593: wsh_debug_sv.log (l_module_name, 'Document Revision', p_document_revision);
594: END IF;
595:
596: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
597:
598: l_txn_hist_rec.transaction_id := p_transaction_id;
599: l_txn_hist_rec.document_type := p_document_type;
600: l_txn_hist_rec.document_direction := p_document_direction;

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

622: IF l_debug_on THEN
623: wsh_debug_sv.log (l_module_name, 'Return status from Create_Update_Txns_History', l_return_status);
624: END IF;
625:
626: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
627: raise create_update_failed;
628: END IF;
629: IF l_debug_on THEN
630: wsh_debug_sv.pop(l_module_name);

Line 634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

630: wsh_debug_sv.pop(l_module_name);
631: END IF;
632: EXCEPTION
633: WHEN create_update_failed THEN
634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
635: IF l_debug_on THEN
636: wsh_debug_sv.pop(l_module_name);
637: END IF;
638: WHEN Others THEN

Line 639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

635: IF l_debug_on THEN
636: wsh_debug_sv.pop(l_module_name);
637: END IF;
638: WHEN Others THEN
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640: IF l_debug_on THEN
641: wsh_debug_sv.pop(l_module_name,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
642: END IF;
643: END Create_Txns_History;