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

Line 231: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

227: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
229: END IF;
230: --
231: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
232: --
233:
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

Line 253: IF (x_api_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

249: p_top_model_line_id => P_TOP_MODEL_LINE_ID,
250: p_transactable_flag => 'Y',
251: x_return_status => x_api_status );
252:
253: IF (x_api_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WSH_DELIVERY_VALIDATIONS.CHECK_SS_IMP_PENDING');
256: WSH_DEBUG_SV.pop(l_module_name);
257: END IF;

Line 422: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');

418: --
419: EXCEPTION
420: --
421: WHEN OTHERS THEN
422: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');
423: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
424: --
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 423: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

419: EXCEPTION
420: --
421: WHEN OTHERS THEN
422: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');
423: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
424: --
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
427: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

636: WSH_DEBUG_SV.log(l_module_name,'P_TOP_MODEL_LINE_ID',P_TOP_MODEL_LINE_ID);
637: WSH_DEBUG_SV.log(l_module_name,'P_ENFORCE_SHIP_SET_AND_SMC',P_ENFORCE_SHIP_SET_AND_SMC);
638: END IF;
639: --
640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
641: x_skip_detail := 'N'; --Bug# 3248578
642: --
643:
644: --Cursor to lock the delivery detail line.

Line 730: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

726: EXCEPTION
727: --
728: WHEN record_locked THEN
729: --
730: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
731: -- Bug Bug 4775539
732: x_requested_qty_uom := null;
733: x_src_requested_qty_uom := null;
734: x_src_requested_qty := null;

Line 749: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

745: END IF;
746: --
747: WHEN no_data_found THEN
748: --
749: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
750: Set_Globals(p_enforce_ship_set_and_smc, p_ship_set_id, p_top_model_line_id);
751: --
752: IF l_debug_on THEN
753: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY DETAIL LINE NOT FOUND: '|| P_DELIVERY_DETAIL_ID);

Line 1056: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1052: g_client_id; --LSP PROJECT
1053:
1054: -- Handle batch does not exist condition
1055: IF get_lock_batch%NOTFOUND THEN
1056: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1057: IF l_debug_on THEN
1058: WSH_DEBUG_SV.logmsg(l_module_name, 'BATCH ID ' || TO_CHAR(P_BATCH_ID) || ' DOES NOT EXIST.');
1059: WSH_DEBUG_SV.pop(l_module_name);
1060: END IF;

Line 1130: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1126: g_client_id; -- LSP PROJECT
1127:
1128: -- Handle batch does not exist condition
1129: IF get_batch%NOTFOUND THEN
1130: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name, 'BATCH ID ' || TO_CHAR(P_BATCH_ID) || ' DOES NOT EXIST.');
1133: WSH_DEBUG_SV.pop(l_module_name);
1134: END IF;

Line 1228: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1224: INTO l_order_header_id;
1225:
1226: IF get_line_info%NOTFOUND THEN
1227:
1228: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1229: --
1230: IF l_debug_on THEN
1231: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER LINE ID ' || TO_CHAR (G_ORDER_LINE_ID)
1232: || 'DOES NOT EXIST' );

Line 1242: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1238: END IF;
1239:
1240: IF l_order_header_id <> g_order_header_id THEN
1241:
1242: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1243: --
1244: IF l_debug_on THEN
1245: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER LINE ID ' || TO_CHAR (G_ORDER_LINE_ID)
1246: || 'DOES NOT BELONG TO');

Line 1334: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1330: p_item => l_validate_item,
1331: p_acct_txn => 1
1332: ) = 0 ) THEN
1333:
1334: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1335: --
1336: IF l_debug_on THEN
1337: WSH_DEBUG_SV.logmsg(l_module_name, g_from_subinventory||' is not a Valid Subinventory for Org ID :'|| g_organization_id);
1338: WSH_DEBUG_SV.pop(l_module_name);

Line 1358: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1354: p_project_id => g_project_id,
1355: p_task_id => g_task_id,
1356: p_txn_action_id => 0) = 0 ) THEN
1357: --
1358: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1359: --
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name, g_from_locator||' is not a Valid Locator for Subinventory :'|| g_from_subinventory);
1362: WSH_DEBUG_SV.pop(l_module_name);

Line 1394: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1390: p_from_sub => l_validate_from_sub,
1391: p_acct_txn => 1
1392: ) = 0 ) THEN
1393:
1394: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1395: --
1396: IF l_debug_on THEN
1397: WSH_DEBUG_SV.logmsg(l_module_name, g_to_subinventory||' is not a Valid Subinventory for Org ID :'|| g_organization_id);
1398: WSH_DEBUG_SV.pop(l_module_name);

Line 1418: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1414: p_project_id => g_project_id,
1415: p_task_id => g_task_id,
1416: p_txn_action_id => 0) = 0 ) THEN
1417:
1418: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1419: --
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name, g_to_locator||' is not a Valid Locator for Subinventory :'|| g_to_subinventory);
1422: WSH_DEBUG_SV.pop(l_module_name);

Line 1449: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1445: p_item => l_validate_item,
1446: p_acct_txn => 1
1447: ) = 0 ) THEN
1448:
1449: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: --
1451: IF l_debug_on THEN
1452: WSH_DEBUG_SV.logmsg(l_module_name, g_relsubinventory||' is not a Valid Subinventory for Org ID :'|| g_organization_id);
1453: WSH_DEBUG_SV.pop(l_module_name);

Line 1487: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1483:
1484: END IF; --}
1485:
1486: g_initialized := TRUE;
1487: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1488:
1489: IF l_debug_on THEN
1490: WSH_DEBUG_SV.pop(l_module_name);
1491: END IF;

Line 1496: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495:
1496: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1497:
1498: IF get_lock_batch%ISOPEN THEN
1499: CLOSE get_lock_batch;
1500: END IF;

Line 1624: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1620:
1621: -- handle pick sequence rule does not exist
1622: IF pick_seq_rule%NOTFOUND THEN
1623: --
1624: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.logmsg(l_module_name, 'PICK SEQUENCE RULE ID ' || TO_CHAR ( G_PICK_SEQ_RULE_ID ) || ' DOES NOT EXIST.');
1628: WSH_DEBUG_SV.pop(l_module_name);

Line 1728: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1724: IF order_ps_group%ISOPEN THEN
1725: CLOSE order_ps_group;
1726: END IF;
1727:
1728: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1729: --
1730: IF l_debug_on THEN
1731: WSH_DEBUG_SV.log(l_module_name, 'g_use_order_ps ' , g_use_order_ps );
1732: WSH_DEBUG_SV.log(l_module_name, 'g_use_delivery_ps ' , g_use_delivery_ps );

Line 1740: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1736: EXCEPTION
1737: --
1738: WHEN OTHERS THEN
1739: --
1740: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1741: --
1742: IF pick_seq_rule%ISOPEN THEN
1743: CLOSE pick_seq_rule;
1744: END IF;

Line 1799: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1795: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
1796: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1797: END IF;
1798:
1799: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1800:
1801: IF c_work_cursorID%ISOPEN THEN
1802: CLOSE c_work_cursorID;
1803: END IF;

Line 1816: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1812: EXCEPTION
1813: --
1814: WHEN OTHERS THEN
1815: --
1816: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1817: --
1818: IF c_work_cursorID%ISOPEN THEN
1819: CLOSE c_work_cursorID;
1820: END IF;

Line 1905: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1901: --
1902: --bug# 6719369(replenishment project) : need to consider the replenishment status value.
1903: IF g_backorders_flag NOT IN ('E','I','O','M') THEN
1904: --
1905: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1906: --
1907: IF l_debug_on THEN
1908: WSH_DEBUG_SV.logmsg(l_module_name, 'INVALID BACKORDER MODE.');
1909: WSH_DEBUG_SV.pop(l_module_name);

Line 2781: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2777: END IF;
2778: END IF;
2779: --}
2780:
2781: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2782:
2783: IF l_debug_on THEN
2784: WSH_DEBUG_SV.pop(l_module_name);
2785: END IF;

Line 2794: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2790: IF DBMS_SQL.IS_Open(v_cursorID) THEN
2791: DBMS_SQL.Close_Cursor(v_cursorID);
2792: END IF;
2793: --
2794: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2795: --
2796: IF l_debug_on THEN
2797: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN CREATING SELECT STATEMENT');
2798: WSH_DEBUG_SV.logmsg(l_module_name, 'SQL ERROR: ' || SQLERRM ( SQLCODE ));

Line 2880: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2876: WSH_DEBUG_SV.log(l_module_name,'P_EXPRESS_PICK_FLAG',P_EXPRESS_PICK_FLAG);
2877: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
2878: END IF;
2879: --
2880: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2881: -- handle uninitialized package errors here
2882: IF g_initialized = FALSE THEN
2883: --{
2884: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2884: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2880: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2881: -- handle uninitialized package errors here
2882: IF g_initialized = FALSE THEN
2883: --{
2884: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2885: --
2886: IF l_debug_on THEN
2887: WSH_DEBUG_SV.logmsg(l_module_name, 'THE PACKAGE MUST BE INITIALIZED BEFORE USE' );
2888: WSH_DEBUG_SV.pop(l_module_name);

Line 2931: IF (l_get_lock_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2927: x_src_requested_qty2 => l_dummy3,
2928: x_inv_item_id => l_inv_item_id,
2929: x_skip_detail => l_skip_detail, -- Bug# 3248578
2930: x_return_status => l_get_lock_status);
2931: IF (l_get_lock_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2932: --{
2933: IF l_skip_detail = 'N' THEN
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.logmsg(l_module_name, 'GOT LOCK ON DELIVERY DETAIL '||

Line 3068: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3064: release_table(g_rel_current_line - 1).top_model_line_id,
3065: release_table(g_rel_current_line - 1).source_header_id,
3066: release_table(g_rel_current_line - 1).source_code,
3067: g_return_status);
3068: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3069: x_api_status := g_return_status;
3070: IF l_debug_on THEN
3071: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN VALIDATE_SS_SMC/0' );
3072: END IF;

Line 3086: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3082: UPDATE wsh_pr_workers
3083: SET processed = 'Y'
3084: WHERE ROWID= v_rowid;
3085: EXCEPTION WHEN OTHERS THEN
3086: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3087: IF l_debug_on THEN
3088: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in updating worker records as processed');
3089: WSH_DEBUG_SV.pop(l_module_name);
3090: END IF;

Line 3124: IF (x_api_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_api_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3120: x_worker_count => l_dummy,
3121: x_smc_worker_count => l_dummy2,
3122: x_dd_count => l_dummy1,
3123: x_api_status => x_api_status);
3124: IF (x_api_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_api_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3125: IF l_debug_on THEN
3126: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in Init_Cursor');
3127: WSH_DEBUG_SV.pop(l_module_name);
3128: END IF;

Line 3206: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

3202:
3203: -- Save fetched record into release table
3204: Insert_RL_Row(p_enforce_ship_set_and_smc, l_skip_detail, g_return_status);
3205:
3206: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3207: x_api_status := g_return_status;
3208: IF l_debug_on THEN
3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN INSERT_RL_ROW');
3210: --WSH_DEBUG_SV.pop(l_module_name);

Line 3220: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3216: CLOSE c_work_cursorID;
3217: END IF;
3218: --RETURN;
3219: raise e_return_excp; -- LPN CONV. rv
3220: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3221: IF l_debug_on THEN
3222: WSH_DEBUG_SV.logmsg(l_module_name, 'WARNING: SKIPPING THE ORDER LINE');
3223: END IF;
3224: x_api_status := g_return_status;

Line 3312: IF g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

3308: WSH_DEBUG_SV.log(l_module_name, 'Return Status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS API is ', g_return_status);
3309: WSH_DEBUG_SV.log(l_module_name, 'current value of x_api_status is ', x_api_status);
3310: END IF;
3311: --
3312: IF g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
3313: THEN
3314: --{
3315: x_api_status := g_return_status;
3316: IF l_debug_on THEN

Line 3320: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

3316: IF l_debug_on THEN
3317: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3318: END IF;
3319: --}
3320: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3321: AND nvl(x_api_status, WSH_UTIL_CORE.G_RET_STS_SUCCESS) NOT IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR))
3322: THEN
3323: --{
3324: x_api_status := g_return_status;

Line 3321: AND nvl(x_api_status, WSH_UTIL_CORE.G_RET_STS_SUCCESS) NOT IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR))

3317: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3318: END IF;
3319: --}
3320: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3321: AND nvl(x_api_status, WSH_UTIL_CORE.G_RET_STS_SUCCESS) NOT IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR))
3322: THEN
3323: --{
3324: x_api_status := g_return_status;
3325: IF l_debug_on THEN

Line 3329: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3327: END IF;
3328: --}
3329: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3330: AND nvl(x_api_status, WSH_UTIL_CORE.G_RET_STS_SUCCESS) NOT IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR))
3331: THEN
3332: --{
3333: x_api_status := g_return_status;

Line 3330: AND nvl(x_api_status, WSH_UTIL_CORE.G_RET_STS_SUCCESS) NOT IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR))

3326: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3327: END IF;
3328: --}
3329: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3330: AND nvl(x_api_status, WSH_UTIL_CORE.G_RET_STS_SUCCESS) NOT IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR))
3331: THEN
3332: --{
3333: x_api_status := g_return_status;
3334: IF l_debug_on THEN

Line 3372: IF (g_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) AND x_api_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3368: --
3369: IF l_debug_on THEN
3370: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', g_return_status);
3371: END IF;
3372: IF (g_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) AND x_api_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3373: x_api_status := g_return_status;
3374: END IF;
3375: --}
3376: END IF;

Line 3398: x_done_flag := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3394: IF c_work_cursorID%ISOPEN THEN
3395: CLOSE c_work_cursorID;
3396: END IF;
3397: --
3398: x_done_flag := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3399: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3400: --
3401: -- K LPN CONV. rv
3402: --

Line 3399: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3395: CLOSE c_work_cursorID;
3396: END IF;
3397: --
3398: x_done_flag := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3399: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3400: --
3401: -- K LPN CONV. rv
3402: --
3403: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 3487: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

3483: l_dummy_exception_id NUMBER;
3484: l_message VARCHAR2(2000);
3485: l_request_id NUMBER;
3486:
3487: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3488: l_dbi_rs VARCHAR2(1); -- DBI Project
3489:
3490: l_debug_on BOOLEAN;
3491: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_RL_ROW';

Line 3530: l_fulfill_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base('OE',v_line_id);

3526:
3527: -- muom: Do not attempt pick releasing a detail with Zero requested (when fulfillment base is primary) or
3528: -- Zero Secondary requested (when fulfillment base is secondary). This check is deferred to here from main query
3529: IF (v_requested_quantity = 0 OR v_requested_quantity2 = 0) THEN
3530: l_fulfill_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base('OE',v_line_id);
3531: IF (l_fulfill_base = 'P' and v_requested_quantity = 0) OR (l_fulfill_base = 'S' and v_requested_quantity2 = 0) THEN
3532: x_skip_detail := 'Y';
3533: IF l_debug_on THEN
3534: WSH_DEBUG_SV.logmsg(l_module_name,'Zero Requested Quantity/Requested Quantity2 detail cannot be Picked');

Line 3536: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3532: x_skip_detail := 'Y';
3533: IF l_debug_on THEN
3534: WSH_DEBUG_SV.logmsg(l_module_name,'Zero Requested Quantity/Requested Quantity2 detail cannot be Picked');
3535: END IF;
3536: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3537: RETURN;
3538: END IF;
3539: END IF;
3540:

Line 3592: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3588: g_last_top_model_line_id,
3589: g_last_header_id,
3590: g_last_source_code,
3591: l_return_status);
3592: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3593: IF l_debug_on THEN
3594: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN VALIDATE_SS_SMC/5' );
3595: END IF;
3596: x_api_status := l_return_status;

Line 3648: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3644: IF l_debug_on THEN
3645: WSH_DEBUG_SV.logmsg(l_module_name, 'IGNORING THIS LINE SINCE ONE OF THE PREVIOUS LINES IN SHIP SET/SMC FAILED' );
3646: END IF;
3647: -- Ignore this line as previous line in ship set or model is faild.
3648: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.pop(l_module_name);
3651: END IF;
3652: RETURN;

Line 3673: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

3669: p_source_code => v_source_code,
3670: p_init_flag => 'N',
3671: x_return_status => l_return_status);
3672:
3673: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3674: /* Don't error out. Raise Warning only */
3675: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3676: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3677: IF l_debug_on THEN

Line 3675: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3671: x_return_status => l_return_status);
3672:
3673: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3674: /* Don't error out. Raise Warning only */
3675: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3676: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3677: IF l_debug_on THEN
3678: WSH_DEBUG_SV.pop(l_module_name);
3679: END IF;

Line 3701: IF (x_api_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

3697: x_inv_item_id => l_inv_item_id,
3698: x_skip_detail => x_skip_detail, -- Bug# 3248578
3699: x_return_status => x_api_status);
3700:
3701: IF (x_api_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3702: IF l_debug_on THEN
3703: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_DETAIL_LOCK RETURNED WITH WARNING' );
3704: WSH_DEBUG_SV.pop(l_module_name);
3705: END IF;

Line 3709: ELSIF (x_api_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND (x_skip_detail = 'Y') THEN

3705: END IF;
3706: --
3707: RETURN;
3708: -- Bug# 3248578 start of change
3709: ELSIF (x_api_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND (x_skip_detail = 'Y') THEN
3710: IF l_debug_on THEN
3711: WSH_DEBUG_SV.logmsg(l_module_name,'No longer eligible to Pick Release, ignoring the line');
3712: END IF;
3713: RETURN;

Line 3796: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3792: END IF;
3793: --
3794: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3795:
3796: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3797: -- bug 2164110 - log exception
3798: l_message := null;
3799: -- Bug 4775539
3800: IF g_existing_rsvs_only_flag = 'Y' THEN

Line 3827: wsh_util_core.PrintMsg('Please view Shipping Exception Report for detail of the logged exception');

3823: x_return_status => l_exception_return_status,
3824: x_msg_count => l_exception_msg_count,
3825: x_msg_data => l_exception_msg_data,
3826: x_exception_id => l_dummy_exception_id);
3827: wsh_util_core.PrintMsg('Please view Shipping Exception Report for detail of the logged exception');
3828: END IF;
3829: -- end bug 2164110
3830:
3831: IF l_debug_on THEN

Line 3852: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3848: WSH_DEBUG_SV.logmsg(l_module_name, 'IGNORING THE LINE' );
3849: END IF;
3850:
3851: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3852: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3853: -- bug 2164110 - log exception
3854: l_message := null;
3855: -- Bug 4775539
3856: IF g_existing_rsvs_only_flag = 'Y' THEN

Line 3883: wsh_util_core.PrintMsg('Please view Shipping Exception Report for detail of the logged exception');

3879: x_return_status => l_exception_return_status,
3880: x_msg_count => l_exception_msg_count,
3881: x_msg_data => l_exception_msg_data,
3882: x_exception_id => l_dummy_exception_id);
3883: wsh_util_core.PrintMsg('Please view Shipping Exception Report for detail of the logged exception');
3884: END IF;
3885: -- end bug 2164110
3886:
3887: IF l_debug_on THEN

Line 4015: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4011: g_last_header_id := v_header_id;
4012: g_last_source_code := v_source_code;
4013: END IF;
4014:
4015: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4016:
4017: --
4018: IF l_debug_on THEN
4019: WSH_DEBUG_SV.pop(l_module_name);

Line 4027: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4023: WHEN OTHERS THEN
4024: IF l_debug_on THEN
4025: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN INSERT_RL_ROW' );
4026: END IF;
4027: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4028: IF l_debug_on THEN
4029: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4031: END IF;