[Home] [Help]
107:
108: G. Muratore 28-FEB-2012 Bug 13785754
109: Changed logic to try 3 times if necessary to get a unique batch number for auto doc numbering.
110: This change was needed for customers firing off creation of many batches by many users. Periodically
111: there was a key constraint issue on the wip entities table.
112:
113: G. Muratore 20-MAR-2012 Bug 13811289
114: Make sure all items returned are valid for the specific organization.
115:
200: CURSOR Cur_wip_entity IS
201: SELECT 1
202: FROM DUAL
203: WHERE EXISTS (SELECT 1
204: FROM wip_entities
205: WHERE organization_id = p_organization_id
206: AND wip_entity_name = p_batch_no);
207: BEGIN
208: x_return_status := fnd_api.g_ret_sts_success;
1597: ELSE
1598: l_prefix := FND_PROFILE.VALUE('GME_FPO_PREFIX');
1599: END IF;
1600: /*5698727 rework commented the following code. We will validate the wip entity
1601: when we are updating the wip_entities table later once the actual doc_no is available */
1602: /* Bug6398619 we have to validate the batch no for the manual doc ordering as
1603: the time stamp is not created for the manual ordering */
1604: IF l_doc_numbering <> gme_common_pvt.g_auto_doc_numbering THEN
1605: validate_wip_entity(p_organization_id => x_batch_header_rec.organization_id,
2160: ,last_update_date = gme_common_pvt.g_timestamp
2161: ,last_update_login = gme_common_pvt.g_login_id
2162: WHERE batch_id = x_batch_header_rec.batch_id;
2163:
2164: /*5698727 rework update the wip_entities table with actual batch no*/
2165: UPDATE wip_entities
2166: SET wip_entity_name = l_prefix||x_batch_header_rec.batch_no
2167: WHERE organization_id = x_batch_header_rec.organization_id
2168: AND wip_entity_name = l_prefix||l_doc_timestamp;
2161: ,last_update_login = gme_common_pvt.g_login_id
2162: WHERE batch_id = x_batch_header_rec.batch_id;
2163:
2164: /*5698727 rework update the wip_entities table with actual batch no*/
2165: UPDATE wip_entities
2166: SET wip_entity_name = l_prefix||x_batch_header_rec.batch_no
2167: WHERE organization_id = x_batch_header_rec.organization_id
2168: AND wip_entity_name = l_prefix||l_doc_timestamp;
2169: END IF;
2541: || TO_CHAR (x_batch_header_rec.batch_id) );
2542: END IF;
2543:
2544: /* Update WIP entity table to put the primary product id */
2545: UPDATE wip_entities
2546: SET primary_item_id = l_recipe_validity_rule.inventory_item_id
2547: WHERE wip_entity_id = x_batch_header_rec.batch_id;
2548:
2549: -- Rajesh Patangya Bug # 6752637