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

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 530: FROM wsh_transactions_history wth

526: IS
527: SELECT wth.Event_Key,
528: wth.Item_Type,
529: wth.Internal_Control_Number
530: FROM wsh_transactions_history wth
531: WHERE wth.Transaction_ID = (SELECT MAX (Transaction_ID)
532: FROM wsh_transactions_history
533: WHERE Document_Number = c_Orig_Document_Number
534: AND Trading_Partner_ID = c_Trading_Partner_ID

Line 532: FROM wsh_transactions_history

528: wth.Item_Type,
529: wth.Internal_Control_Number
530: FROM wsh_transactions_history wth
531: WHERE wth.Transaction_ID = (SELECT MAX (Transaction_ID)
532: FROM wsh_transactions_history
533: WHERE Document_Number = c_Orig_Document_Number
534: AND Trading_Partner_ID = c_Trading_Partner_ID
535: AND Document_Direction = 'I'
536: AND Action_Type = 'A');

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 706: FROM wsh_transactions_history wth,

702: SELECT wth.Entity_Number,
703: wth.Trading_Partner_ID,
704: wth.Transaction_Status,
705: wndi.client_code
706: FROM wsh_transactions_history wth,
707: wsh_new_del_interface wndi
708: WHERE wth.Transaction_ID = (SELECT MAX (Transaction_ID)
709: FROM wsh_transactions_history
710: WHERE Document_Number = c_Orig_Document_Number

Line 709: FROM wsh_transactions_history

705: wndi.client_code
706: FROM wsh_transactions_history wth,
707: wsh_new_del_interface wndi
708: WHERE wth.Transaction_ID = (SELECT MAX (Transaction_ID)
709: FROM wsh_transactions_history
710: WHERE Document_Number = c_Orig_Document_Number
711: AND Trading_Partner_ID = c_Trading_Partner_ID
712: AND Document_Direction = 'I'
713: AND Action_Type = 'A')

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 1413: FROM wsh_transactions_history wth1,

1409: wth1.Attribute13,
1410: wth1.Attribute14,
1411: wth1.Attribute15,
1412: NULL -- LSP PROJECT
1413: FROM wsh_transactions_history wth1,
1414: wsh_transactions_history wth2
1415: WHERE wth2.Item_Type = c_Item_Type
1416: AND wth2.Event_Key = c_Item_Key
1417: AND wth1.Document_Number = wth2.Orig_Document_Number

Line 1414: wsh_transactions_history wth2

1410: wth1.Attribute14,
1411: wth1.Attribute15,
1412: NULL -- LSP PROJECT
1413: FROM wsh_transactions_history wth1,
1414: wsh_transactions_history wth2
1415: WHERE wth2.Item_Type = c_Item_Type
1416: AND wth2.Event_Key = c_Item_Key
1417: AND wth1.Document_Number = wth2.Orig_Document_Number
1418: AND wth1.Trading_Partner_ID = wth2.Trading_Partner_ID

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 1565: FROM wsh_transactions_history wth1,

1561: wth1.Attribute13,
1562: wth1.Attribute14,
1563: wth1.Attribute15,
1564: NULL -- LSP PROJECT
1565: FROM wsh_transactions_history wth1,
1566: wsh_transactions_history wth2
1567: WHERE wth2.Item_Type = c_Item_Type
1568: AND wth2.Event_Key = c_Item_Key
1569: AND wth1.Document_Number = wth2.Document_Number

Line 1566: wsh_transactions_history wth2

1562: wth1.Attribute14,
1563: wth1.Attribute15,
1564: NULL -- LSP PROJECT
1565: FROM wsh_transactions_history wth1,
1566: wsh_transactions_history wth2
1567: WHERE wth2.Item_Type = c_Item_Type
1568: AND wth2.Event_Key = c_Item_Key
1569: AND wth1.Document_Number = wth2.Document_Number
1570: AND wth1.Trading_Partner_ID = wth2.Trading_Partner_ID

Line 1680: FROM wsh_transactions_history wth1

1676: IS
1677: SELECT wth1.Document_Number,
1678: wth1.Transaction_Status,
1679: wth1.Event_Key
1680: FROM wsh_transactions_history wth1
1681: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
1682: FROM wsh_transactions_history
1683: WHERE Entity_Number = c_Entity_Number
1684: AND Trading_Partner_ID = c_Org_ID

Line 1682: FROM wsh_transactions_history

1678: wth1.Transaction_Status,
1679: wth1.Event_Key
1680: FROM wsh_transactions_history wth1
1681: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
1682: FROM wsh_transactions_history
1683: WHERE Entity_Number = c_Entity_Number
1684: AND Trading_Partner_ID = c_Org_ID
1685: AND Entity_Type = 'DLVY'
1686: AND Action_Type = 'A'

Line 1711: select transaction_status from wsh_transactions_history

1707: AND wnd.Organization_ID = c_Org_ID
1708: AND rownum = 1;
1709:
1710: cursor l_check_resend_cur(p_entity_number VARCHAR2 ) is
1711: select transaction_status from wsh_transactions_history
1712: where transaction_id =(select max(transaction_id) from wsh_transactions_history
1713: where entity_number= p_entity_number
1714: and trading_partner_id=p_org_id
1715: and document_direction = 'O'

Line 1712: where transaction_id =(select max(transaction_id) from wsh_transactions_history

1708: AND rownum = 1;
1709:
1710: cursor l_check_resend_cur(p_entity_number VARCHAR2 ) is
1711: select transaction_status from wsh_transactions_history
1712: where transaction_id =(select max(transaction_id) from wsh_transactions_history
1713: where entity_number= p_entity_number
1714: and trading_partner_id=p_org_id
1715: and document_direction = 'O'
1716: and document_type ='SA'

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);