DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WMS_DEPLOY

Line 452: IF ( WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' OR (WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'L' AND l_txn_hist_record.client_code IS NOT NULL ) ) THEN

448: END IF;
449: -- Change the Event Name before calling Raise Event
450: -- R12.1.1 STANDALONE PROJECT
451: -- LSP PROJECT : consider LSP mode also.
452: IF ( WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' OR (WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'L' AND l_txn_hist_record.client_code IS NOT NULL ) ) THEN
453: l_txn_hist_record.Event_Name := 'oracle.apps.wsh.standalone.scbod';
454: ELSE
455: l_txn_hist_record.Event_Name := 'oracle.apps.wsh.tpw.scbod';
456: END IF;

Line 595: IF ( WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' OR (WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'L' AND l_txn_hist_record.client_code IS NOT NULL)) THEN

591: END IF;
592: -- Change the Event Name before calling Raise Event
593: -- R12.1.1 STANDALONE PROJECT
594: -- LSP PROJECT : consider LSP mode also.
595: IF ( WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' OR (WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'L' AND l_txn_hist_record.client_code IS NOT NULL)) THEN
596: l_txn_hist_record.Event_Name := 'oracle.apps.wsh.standalone.scbod';
597: ELSE
598:
599: IF (l_txn_hist_record.Transaction_Status = 'SC' AND

Line 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

825: END IF;
826:
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 );

Line 1746: l_wms_deployment_mode VARCHAR2(1);

1742: l_txn_Status VARCHAR2 (2);
1743: l_del_detail_x VARCHAR2 (1);
1744: l_delivery_details VARCHAR2(1);
1745: -- R12.1.1 STANDALONE PROJECT
1746: l_wms_deployment_mode VARCHAR2(1);
1747: l_client_id NUMBER; -- LSP PROJECT
1748:
1749: wsh_invalid_delivery_id EXCEPTION;
1750: wsh_invalid_entity_type EXCEPTION;

Line 1816: l_wms_deployment_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;

1812: END IF;
1813: CLOSE l_new_del_status_cur;
1814:
1815: -- R12.1.1 STANDALONE PROJECT
1816: l_wms_deployment_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;
1817: -- LSP PROJECT : consider LSP mode also.
1818: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN
1819: IF (l_new_del_status NOT IN ('IT', 'CL')) THEN
1820: RAISE wsh_invalid_del_status;

Line 1818: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN

1814:
1815: -- R12.1.1 STANDALONE PROJECT
1816: l_wms_deployment_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;
1817: -- LSP PROJECT : consider LSP mode also.
1818: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN
1819: IF (l_new_del_status NOT IN ('IT', 'CL')) THEN
1820: RAISE wsh_invalid_del_status;
1821: END IF;
1822:

Line 1863: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN --{

1859: end if;
1860:
1861: -- R12.1.1 STANDALONE PROJECT
1862: -- LSP PROJECT : consider LSP mode also.
1863: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN --{
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS.Process_Delivery_To_OM',WSH_DEBUG_SV.C_PROC_LEVEL);
1866: END IF;
1867:

Line 1918: IF (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL ) THEN

1914: l_curr_txn_hist_record.Document_Direction := 'O';
1915: l_curr_txn_hist_record.Entity_Number := l_Del_Name;
1916: l_curr_txn_hist_record.Entity_Type := P_Entity_TYPE;
1917: -- LSP PROJECT.
1918: IF (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL ) THEN
1919: --{
1920: SELECT party_id
1921: INTO l_curr_txn_hist_record.Trading_Partner_ID
1922: FROM hz_cust_accounts_all

Line 1936: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN

1932: l_curr_txn_hist_record.Action_Type := P_Action_Type;
1933: l_curr_txn_hist_record.Transaction_Status := 'IP';
1934: -- R12.1.1 STANDALONE PROJECT
1935: -- LSP PROJECT : consider LSP mode also.
1936: IF (l_wms_deployment_mode = 'D' OR (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL )) THEN
1937: l_curr_txn_hist_record.Event_Name := 'oracle.apps.wsh.standalone.ssao';
1938: l_curr_txn_hist_record.Item_Type := 'WSHSTNDO';
1939: ELSE
1940: l_curr_txn_hist_record.Orig_Document_Number := l_orig_Document_Number;