1524: INTO lp_sub_code,lp_locator_id, lp_line_num
1525: FROM mtl_material_transactions_temp
1526: WHERE transaction_temp_id=lp_mmtt_id;
1527: IF (l_debug = 1) THEN
1528: mdebug('before calling wms_txnrsn_actions_pub.suggest_alternate_location ');
1529: END IF;
1530:
1531: g_return_status := FND_API.G_RET_STS_SUCCESS; --Bug 6116046
1532: mdebug('Setting g_return_status to success');
1529: END IF;
1530:
1531: g_return_status := FND_API.G_RET_STS_SUCCESS; --Bug 6116046
1532: mdebug('Setting g_return_status to success');
1533: wms_txnrsn_actions_pub.suggest_alternate_location
1534: (p_api_version_number =>lp_api_version_number
1535: , p_init_msg_lst =>lp_init_msg_lst
1536: , p_commit =>lp_commit
1537: , x_return_status =>lx_return_status
1548: , p_line_num =>lp_line_num
1549: );
1550:
1551: IF (l_debug = 1) THEN
1552: mdebug('After calling wms_txnrsn_actions_pub.suggest_alternate_location');
1553: END IF;
1554: -- setting the workflow attributes with the output results of
1555: -- the API wms_txnrsn_actions_pub.Inadequate_Qty
1556: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1551: IF (l_debug = 1) THEN
1552: mdebug('After calling wms_txnrsn_actions_pub.suggest_alternate_location');
1553: END IF;
1554: -- setting the workflow attributes with the output results of
1555: -- the API wms_txnrsn_actions_pub.Inadequate_Qty
1556: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
1557: itemkey => l_item_key,
1558: aname => 'XW_RETURN_STATUS',
1559: avalue => lx_return_status);
2547: aname => 'PW_REASON_NAME');
2548:
2549:
2550: IF (l_debug = 1) THEN
2551: mdebug('Before calling wms_txnrsn_actions_pub.Inadequate Quantity');
2552: END IF;
2553:
2554:
2555: -- get data to call suggest_alternate_locatoin
2566: INTO lp_sub_code,lp_locator_id, lp_line_num
2567: FROM mtl_material_transactions_temp
2568: WHERE transaction_temp_id=lp_mmtt_id;
2569:
2570: wms_txnrsn_actions_pub.suggest_alternate_location
2571: (p_api_version_number =>lp_api_version_number
2572: , p_init_msg_lst =>lp_init_msg_lst
2573: , p_commit =>lp_commit
2574: , x_return_status =>lx_return_status
2585: , p_line_num =>lp_line_num
2586: );
2587:
2588: IF (l_debug = 1) THEN
2589: mdebug('After calling wms_txnrsn_actions_pub.suggest_alternate_location');
2590: END IF;
2591: -- setting the workflow attributes with the output results of
2592: -- the API wms_txnrsn_actions_pub.Inadequate_Qty
2593: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2588: IF (l_debug = 1) THEN
2589: mdebug('After calling wms_txnrsn_actions_pub.suggest_alternate_location');
2590: END IF;
2591: -- setting the workflow attributes with the output results of
2592: -- the API wms_txnrsn_actions_pub.Inadequate_Qty
2593: wf_engine.SetItemAttrText(itemtype => l_workflow_name,
2594: itemkey => l_item_key,
2595: aname => 'XW_RETURN_STATUS',
2596: avalue => lx_return_status);