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 220: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

216: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
217: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
218: END IF;
219: --
220: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
221: --
222:
223: IF l_debug_on THEN
224: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

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

238: p_top_model_line_id => P_TOP_MODEL_LINE_ID,
239: p_transactable_flag => 'Y',
240: x_return_status => x_api_status );
241:
242: IF (x_api_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
243: IF l_debug_on THEN
244: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WSH_DELIVERY_VALIDATIONS.CHECK_SS_IMP_PENDING');
245: WSH_DEBUG_SV.pop(l_module_name);
246: END IF;

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

407: --
408: EXCEPTION
409: --
410: WHEN OTHERS THEN
411: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');
412: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 412: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

408: EXCEPTION
409: --
410: WHEN OTHERS THEN
411: wsh_util_core.default_handler('WSH_PR_CRITERIA.validate_ss_smc');
412: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
416: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 618: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

614: WSH_DEBUG_SV.log(l_module_name,'P_TOP_MODEL_LINE_ID',P_TOP_MODEL_LINE_ID);
615: WSH_DEBUG_SV.log(l_module_name,'P_ENFORCE_SHIP_SET_AND_SMC',P_ENFORCE_SHIP_SET_AND_SMC);
616: END IF;
617: --
618: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
619: x_skip_detail := 'N'; --Bug# 3248578
620: --
621:
622: --Cursor to lock the delivery detail line.

Line 702: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

698: EXCEPTION
699: --
700: WHEN record_locked THEN
701: --
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
703: -- Bug Bug 4775539
704: x_requested_qty_uom := null;
705: x_src_requested_qty_uom := null;
706: x_src_requested_qty := null;

Line 719: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

715: END IF;
716: --
717: WHEN no_data_found THEN
718: --
719: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
720: Set_Globals(p_enforce_ship_set_and_smc, p_ship_set_id, p_top_model_line_id);
721: --
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY DETAIL LINE NOT FOUND: '|| P_DELIVERY_DETAIL_ID);

Line 1023: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1019: g_dynamic_replenishment_flag; --bug# 6689448 (replenishment project)
1020:
1021: -- Handle batch does not exist condition
1022: IF get_lock_batch%NOTFOUND THEN
1023: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name, 'BATCH ID ' || TO_CHAR(P_BATCH_ID) || ' DOES NOT EXIST.');
1026: WSH_DEBUG_SV.pop(l_module_name);
1027: END IF;

Line 1096: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1092: g_dynamic_replenishment_flag; --bug# 6689448 (replenishment project)
1093:
1094: -- Handle batch does not exist condition
1095: IF get_batch%NOTFOUND THEN
1096: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name, 'BATCH ID ' || TO_CHAR(P_BATCH_ID) || ' DOES NOT EXIST.');
1099: WSH_DEBUG_SV.pop(l_module_name);
1100: END IF;

Line 1184: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1180: INTO l_order_header_id;
1181:
1182: IF get_line_info%NOTFOUND THEN
1183:
1184: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1185: --
1186: IF l_debug_on THEN
1187: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER LINE ID ' || TO_CHAR (G_ORDER_LINE_ID)
1188: || 'DOES NOT EXIST' );

Line 1198: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1194: END IF;
1195:
1196: IF l_order_header_id <> g_order_header_id THEN
1197:
1198: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1199: --
1200: IF l_debug_on THEN
1201: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER LINE ID ' || TO_CHAR (G_ORDER_LINE_ID)
1202: || 'DOES NOT BELONG TO');

Line 1273: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1269: p_item => l_validate_item,
1270: p_acct_txn => 1
1271: ) = 0 ) THEN
1272:
1273: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1274: --
1275: IF l_debug_on THEN
1276: WSH_DEBUG_SV.logmsg(l_module_name, g_from_subinventory||' is not a Valid Subinventory for Org ID :'|| g_organization_id);
1277: WSH_DEBUG_SV.pop(l_module_name);

Line 1297: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1293: p_project_id => g_project_id,
1294: p_task_id => g_task_id,
1295: p_txn_action_id => 0) = 0 ) THEN
1296: --
1297: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1298: --
1299: IF l_debug_on THEN
1300: WSH_DEBUG_SV.logmsg(l_module_name, g_from_locator||' is not a Valid Locator for Subinventory :'|| g_from_subinventory);
1301: WSH_DEBUG_SV.pop(l_module_name);

Line 1333: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 1357: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 1388: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1384: p_item => l_validate_item,
1385: p_acct_txn => 1
1386: ) = 0 ) THEN
1387:
1388: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1389: --
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name, g_relsubinventory||' is not a Valid Subinventory for Org ID :'|| g_organization_id);
1392: WSH_DEBUG_SV.pop(l_module_name);

Line 1426: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1422:
1423: END IF; --}
1424:
1425: g_initialized := TRUE;
1426: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1427:
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.pop(l_module_name);
1430: END IF;

Line 1435: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1431:
1432: EXCEPTION
1433: WHEN OTHERS THEN
1434:
1435: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1436:
1437: IF get_lock_batch%ISOPEN THEN
1438: CLOSE get_lock_batch;
1439: END IF;

Line 1563: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1559:
1560: -- handle pick sequence rule does not exist
1561: IF pick_seq_rule%NOTFOUND THEN
1562: --
1563: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1564: --
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name, 'PICK SEQUENCE RULE ID ' || TO_CHAR ( G_PICK_SEQ_RULE_ID ) || ' DOES NOT EXIST.');
1567: WSH_DEBUG_SV.pop(l_module_name);

Line 1667: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1663: IF order_ps_group%ISOPEN THEN
1664: CLOSE order_ps_group;
1665: END IF;
1666:
1667: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1668: --
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.log(l_module_name, 'g_use_order_ps ' , g_use_order_ps );
1671: WSH_DEBUG_SV.log(l_module_name, 'g_use_delivery_ps ' , g_use_delivery_ps );

Line 1679: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1675: EXCEPTION
1676: --
1677: WHEN OTHERS THEN
1678: --
1679: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1680: --
1681: IF pick_seq_rule%ISOPEN THEN
1682: CLOSE pick_seq_rule;
1683: END IF;

Line 1738: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1734: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
1735: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1736: END IF;
1737:
1738: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1739:
1740: IF c_work_cursorID%ISOPEN THEN
1741: CLOSE c_work_cursorID;
1742: END IF;

Line 1755: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1751: EXCEPTION
1752: --
1753: WHEN OTHERS THEN
1754: --
1755: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1756: --
1757: IF c_work_cursorID%ISOPEN THEN
1758: CLOSE c_work_cursorID;
1759: END IF;

Line 1844: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1840: --
1841: --bug# 6719369(replenishment project) : need to consider the replenishment status value.
1842: IF g_backorders_flag NOT IN ('E','I','O','M') THEN
1843: --
1844: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: --
1846: IF l_debug_on THEN
1847: WSH_DEBUG_SV.logmsg(l_module_name, 'INVALID BACKORDER MODE.');
1848: WSH_DEBUG_SV.pop(l_module_name);

Line 2675: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2671: END IF;
2672: END IF;
2673: --}
2674:
2675: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2676:
2677: IF l_debug_on THEN
2678: WSH_DEBUG_SV.pop(l_module_name);
2679: END IF;

Line 2688: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2684: IF DBMS_SQL.IS_Open(v_cursorID) THEN
2685: DBMS_SQL.Close_Cursor(v_cursorID);
2686: END IF;
2687: --
2688: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2689: --
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN CREATING SELECT STATEMENT');
2692: WSH_DEBUG_SV.logmsg(l_module_name, 'SQL ERROR: ' || SQLERRM ( SQLCODE ));

Line 2772: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2768: WSH_DEBUG_SV.log(l_module_name,'P_EXPRESS_PICK_FLAG',P_EXPRESS_PICK_FLAG);
2769: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
2770: END IF;
2771: --
2772: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2773: -- handle uninitialized package errors here
2774: IF g_initialized = FALSE THEN
2775: --{
2776: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2776: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2772: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2773: -- handle uninitialized package errors here
2774: IF g_initialized = FALSE THEN
2775: --{
2776: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2777: --
2778: IF l_debug_on THEN
2779: WSH_DEBUG_SV.logmsg(l_module_name, 'THE PACKAGE MUST BE INITIALIZED BEFORE USE' );
2780: WSH_DEBUG_SV.pop(l_module_name);

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

2817: x_src_requested_qty => l_src_requested_qty,
2818: x_inv_item_id => l_inv_item_id,
2819: x_skip_detail => l_skip_detail, -- Bug# 3248578
2820: x_return_status => l_get_lock_status);
2821: IF (l_get_lock_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2822: --{
2823: IF l_skip_detail = 'N' THEN
2824: IF l_debug_on THEN
2825: WSH_DEBUG_SV.logmsg(l_module_name, 'GOT LOCK ON DELIVERY DETAIL '||

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

2956: release_table(g_rel_current_line - 1).top_model_line_id,
2957: release_table(g_rel_current_line - 1).source_header_id,
2958: release_table(g_rel_current_line - 1).source_code,
2959: g_return_status);
2960: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2961: x_api_status := g_return_status;
2962: IF l_debug_on THEN
2963: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN VALIDATE_SS_SMC/0' );
2964: END IF;

Line 2980: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2976: AND organization_id = v_pr_org_id
2977: AND NVL(inventory_item_id,-99) = NVL(v_pr_inv_item_id,-99)
2978: AND type = 'PICK';
2979: EXCEPTION WHEN OTHERS THEN
2980: x_api_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2981: IF l_debug_on THEN
2982: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in updating worker records as processed');
2983: WSH_DEBUG_SV.pop(l_module_name);
2984: END IF;

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

3014: x_worker_count => l_dummy,
3015: x_smc_worker_count => l_dummy2,
3016: x_dd_count => l_dummy1,
3017: x_api_status => x_api_status);
3018: IF (x_api_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_api_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3019: IF l_debug_on THEN
3020: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in Init_Cursor');
3021: WSH_DEBUG_SV.pop(l_module_name);
3022: END IF;

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

3091:
3092: -- Save fetched record into release table
3093: Insert_RL_Row(p_enforce_ship_set_and_smc, l_skip_detail, g_return_status);
3094:
3095: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3096: x_api_status := g_return_status;
3097: IF l_debug_on THEN
3098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN INSERT_RL_ROW');
3099: --WSH_DEBUG_SV.pop(l_module_name);

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

3105: CLOSE c_work_cursorID;
3106: END IF;
3107: --RETURN;
3108: raise e_return_excp; -- LPN CONV. rv
3109: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3110: IF l_debug_on THEN
3111: WSH_DEBUG_SV.logmsg(l_module_name, 'WARNING: SKIPPING THE ORDER LINE');
3112: END IF;
3113: x_api_status := g_return_status;

Line 3196: IF g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

3192: 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);
3193: WSH_DEBUG_SV.log(l_module_name, 'current value of x_api_status is ', x_api_status);
3194: END IF;
3195: --
3196: IF g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
3197: THEN
3198: --{
3199: x_api_status := g_return_status;
3200: IF l_debug_on THEN

Line 3204: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3202: END IF;
3203: --}
3204: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3205: 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))
3206: THEN
3207: --{
3208: x_api_status := g_return_status;

Line 3205: 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))

3201: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3202: END IF;
3203: --}
3204: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3205: 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))
3206: THEN
3207: --{
3208: x_api_status := g_return_status;
3209: IF l_debug_on THEN

Line 3213: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

3209: IF l_debug_on THEN
3210: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3211: END IF;
3212: --}
3213: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3214: 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))
3215: THEN
3216: --{
3217: x_api_status := g_return_status;

Line 3214: 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))

3210: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS');
3211: END IF;
3212: --}
3213: ELSIF (g_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3214: 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))
3215: THEN
3216: --{
3217: x_api_status := g_return_status;
3218: IF l_debug_on THEN

Line 3256: 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

3252: --
3253: IF l_debug_on THEN
3254: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', g_return_status);
3255: END IF;
3256: 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
3257: x_api_status := g_return_status;
3258: END IF;
3259: --}
3260: END IF;

Line 3282: x_done_flag := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3278: IF c_work_cursorID%ISOPEN THEN
3279: CLOSE c_work_cursorID;
3280: END IF;
3281: --
3282: x_done_flag := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3283: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3284: --
3285: -- K LPN CONV. rv
3286: --

Line 3283: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3279: CLOSE c_work_cursorID;
3280: END IF;
3281: --
3282: x_done_flag := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3283: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3284: --
3285: -- K LPN CONV. rv
3286: --
3287: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

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

3367: l_dummy_exception_id NUMBER;
3368: l_message VARCHAR2(2000);
3369: l_request_id NUMBER;
3370:
3371: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3372: l_dbi_rs VARCHAR2(1); -- DBI Project
3373:
3374: l_debug_on BOOLEAN;
3375: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_RL_ROW';

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

3451: g_last_top_model_line_id,
3452: g_last_header_id,
3453: g_last_source_code,
3454: l_return_status);
3455: IF (g_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3456: IF l_debug_on THEN
3457: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OCCURRED IN VALIDATE_SS_SMC/5' );
3458: END IF;
3459: x_api_status := l_return_status;

Line 3511: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3507: IF l_debug_on THEN
3508: WSH_DEBUG_SV.logmsg(l_module_name, 'IGNORING THIS LINE SINCE ONE OF THE PREVIOUS LINES IN SHIP SET/SMC FAILED' );
3509: END IF;
3510: -- Ignore this line as previous line in ship set or model is faild.
3511: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3512: IF l_debug_on THEN
3513: WSH_DEBUG_SV.pop(l_module_name);
3514: END IF;
3515: RETURN;

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

3532: p_source_code => v_source_code,
3533: p_init_flag => 'N',
3534: x_return_status => l_return_status);
3535:
3536: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3537: /* Don't error out. Raise Warning only */
3538: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3539: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3540: IF l_debug_on THEN

Line 3538: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3534: x_return_status => l_return_status);
3535:
3536: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3537: /* Don't error out. Raise Warning only */
3538: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3539: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3540: IF l_debug_on THEN
3541: WSH_DEBUG_SV.pop(l_module_name);
3542: END IF;

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

3558: x_inv_item_id => l_inv_item_id,
3559: x_skip_detail => x_skip_detail, -- Bug# 3248578
3560: x_return_status => x_api_status);
3561:
3562: IF (x_api_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3563: IF l_debug_on THEN
3564: WSH_DEBUG_SV.logmsg(l_module_name, 'GET_DETAIL_LOCK RETURNED WITH WARNING' );
3565: WSH_DEBUG_SV.pop(l_module_name);
3566: END IF;

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

3566: END IF;
3567: --
3568: RETURN;
3569: -- Bug# 3248578 start of change
3570: ELSIF (x_api_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND (x_skip_detail = 'Y') THEN
3571: IF l_debug_on THEN
3572: WSH_DEBUG_SV.logmsg(l_module_name,'No longer eligible to Pick Release, ignoring the line');
3573: END IF;
3574: RETURN;

Line 3642: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3638: END IF;
3639: --
3640: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3641:
3642: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3643: -- bug 2164110 - log exception
3644: l_message := null;
3645: -- Bug 4775539
3646: IF g_existing_rsvs_only_flag = 'Y' THEN

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

3669: x_return_status => l_exception_return_status,
3670: x_msg_count => l_exception_msg_count,
3671: x_msg_data => l_exception_msg_data,
3672: x_exception_id => l_dummy_exception_id);
3673: wsh_util_core.PrintMsg('Please view Shipping Exception Report for detail of the logged exception');
3674: END IF;
3675: -- end bug 2164110
3676:
3677: IF l_debug_on THEN

Line 3697: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3693: WSH_DEBUG_SV.logmsg(l_module_name, 'IGNORING THE LINE' );
3694: END IF;
3695:
3696: Set_Globals(p_enforce_ship_set_and_smc, v_ship_set_id, v_top_model_line_id);
3697: x_api_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3698: -- bug 2164110 - log exception
3699: l_message := null;
3700: -- Bug 4775539
3701: IF g_existing_rsvs_only_flag = 'Y' THEN

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

3724: x_return_status => l_exception_return_status,
3725: x_msg_count => l_exception_msg_count,
3726: x_msg_data => l_exception_msg_data,
3727: x_exception_id => l_dummy_exception_id);
3728: wsh_util_core.PrintMsg('Please view Shipping Exception Report for detail of the logged exception');
3729: END IF;
3730: -- end bug 2164110
3731:
3732: IF l_debug_on THEN

Line 3854: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3850: g_last_header_id := v_header_id;
3851: g_last_source_code := v_source_code;
3852: END IF;
3853:
3854: x_api_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3855:
3856: --
3857: IF l_debug_on THEN
3858: WSH_DEBUG_SV.pop(l_module_name);

Line 3866: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3862: WHEN OTHERS THEN
3863: IF l_debug_on THEN
3864: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN INSERT_RL_ROW' );
3865: END IF;
3866: x_api_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3867: IF l_debug_on THEN
3868: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3870: END IF;