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_TPW_UTIL dependencies on WSH_TRANSACTIONS_HISTORY_PKG

Line 404: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

400: PROCEDURE Send_Cbod_Success ( P_item_type IN VARCHAR2,
401: P_item_key IN VARCHAR2,
402: X_Return_Status OUT NOCOPY VARCHAR2 )
403: IS
404: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
405: l_Return_Status VARCHAR2 (1);
406: l_Cbod_Status VARCHAR2 (5) := '00';
407:
408: wsh_get_txns_hist_error EXCEPTION;

Line 432: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,

428: END IF;
429:
430: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
431:
432: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
433: P_item_key,
434: 'I',
435: 'SR',
436: l_txn_hist_record,

Line 516: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

512: PROCEDURE Send_Cbod_Failure ( P_item_type IN VARCHAR2,
513: P_item_key IN VARCHAR2,
514: X_Return_Status OUT NOCOPY VARCHAR2 )
515: IS
516: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
517: l_Return_Status VARCHAR2 (1);
518: l_Cbod_Status VARCHAR2 (5) := '99';
519:
520: l_Event_Name VARCHAR2 (120);

Line 563: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,

559: END IF;
560:
561: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
562:
563: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
564: P_item_key,
565: 'I',
566: 'SR',
567: l_txn_hist_record,

Line 686: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

682: PROCEDURE Check_Cancel_Allowed ( P_item_type IN VARCHAR2,
683: P_item_key IN VARCHAR2,
684: X_Return_Status OUT NOCOPY VARCHAR2 )
685: IS
686: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
687: l_Return_Status VARCHAR2 (1);
688: l_new_del_status VARCHAR2 (2);
689: l_Event_Name VARCHAR2 (120);
690: l_Event_Key VARCHAR2 (30);

Line 778: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,

774: RAISE wsh_invalid_item_key;
775: END IF;
776:
777: -- Get the record from the Transaction History Table.
778: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
779: P_item_key,
780: 'I',
781: 'SR',
782: l_txn_hist_record,

Line 831: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

827: -- R12.1.1 STANDALONE PROJECT
828: -- LSP PROJECT : consider LSP mode also.
829: IF (WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' OR (WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'L' AND l_client_code IS NOT NULL)) OR ( l_Orig_Transaction_Status = 'IP' ) THEN
830: l_txn_hist_record.transaction_status := 'ER';
831: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
832: l_txn_hist_record.transaction_id,
833: l_Return_Status );
834: IF l_debug_on THEN
835: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);

Line 893: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

889: RAISE wsh_del_interface_rec;
890: END IF;
891:
892: l_txn_hist_record.transaction_status := 'SC';
893: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
894: l_txn_hist_record.transaction_id,
895: l_Return_Status );
896: IF l_debug_on THEN
897: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);

Line 962: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

958: END IF;
959:
960: IF ( l_new_del_status IN ('CL', 'IT', 'CO') ) THEN
961: l_txn_hist_record.transaction_status := 'ER';
962: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
963: l_txn_hist_record.transaction_id,
964: l_Return_Status );
965: IF l_debug_on THEN
966: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);

Line 1024: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

1020: RAISE wsh_del_interface_wrapper;
1021: ELSE
1022: l_txn_hist_record.transaction_status := 'SC';
1023:
1024: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1025: l_txn_hist_record.transaction_id,
1026: l_Return_Status );
1027:
1028: IF l_debug_on THEN

Line 1285: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

1281: END IF;
1282:
1283: WHEN wsh_del_interface_wrapper THEN
1284: l_txn_hist_record.transaction_status := 'ER';
1285: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1286: l_txn_hist_record.transaction_id,
1287: l_Return_Status );
1288: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1289: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 1370: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1366: PROCEDURE Raise_Cancel_Event ( P_item_type IN VARCHAR2,
1367: P_item_key IN VARCHAR2,
1368: X_return_Status OUT NOCOPY VARCHAR2 )
1369: IS
1370: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1371: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1372: l_Return_Status VARCHAR2 (1);
1373: l_Event_Name VARCHAR2 (120);
1374: l_Event_Key VARCHAR2 (30);

Line 1371: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1367: P_item_key IN VARCHAR2,
1368: X_return_Status OUT NOCOPY VARCHAR2 )
1369: IS
1370: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1371: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1372: l_Return_Status VARCHAR2 (1);
1373: l_Event_Name VARCHAR2 (120);
1374: l_Event_Key VARCHAR2 (30);
1375:

Line 1523: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1519: IS
1520:
1521: pragma AUTONOMOUS_TRANSACTION;
1522:
1523: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1524: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1525: l_Return_Status VARCHAR2 (1);
1526: l_Event_Name VARCHAR2 (120);
1527: l_Event_Key VARCHAR2 (30);

Line 1524: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1520:
1521: pragma AUTONOMOUS_TRANSACTION;
1522:
1523: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1524: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1525: l_Return_Status VARCHAR2 (1);
1526: l_Event_Name VARCHAR2 (120);
1527: l_Event_Key VARCHAR2 (30);
1528:

Line 1738: l_curr_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1734:
1735: l_orig_document_number VARCHAR2 (120);
1736: l_orig_Transaction_Status VARCHAR2 (2);
1737: l_orig_Event_Key VARCHAR2 (240);
1738: l_curr_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1739: l_Return_Status VARCHAR2 (1);
1740: l_new_del_status VARCHAR2 (2);
1741: l_Del_Name VARCHAR2 (30);
1742: l_txn_Status VARCHAR2 (2);