[Home] [Help]
978: inv_log_util.g_maintain_log_profile := TRUE; -- Bug 5558315 - duplication so no dependency btw inv_cache and inv_log
979:
980: SAVEPOINT Pick_Release_PUB;
981:
982: -- Standard Call to check for call compatibility
983: IF NOT fnd_api.Compatible_API_Call(l_api_version , p_api_version ,
984: l_api_name , G_PKG_NAME) THEN
985: If is_debug then
986: print_debug('Fnd_APi not compatible','INV_Pick_Release_Pub.Pick_Release');
3125: LOOP
3126:
3127: SELECT count (*) into honor_case_pick_count
3128: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
3129: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
3130: AND mmtt.organization_id = wutta.organization_id
3131: AND mmtt.transaction_temp_id = l_transaction_id(b)
3132: AND honor_case_pick_flag = 'Y';
3133:
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302: END IF;
3303:
3304: -- Standard call to commit
3305: IF p_commit = fnd_api.g_true THEN
3306: COMMIT;
3307: END IF;
3308:
3305: IF p_commit = fnd_api.g_true THEN
3306: COMMIT;
3307: END IF;
3308:
3309: -- Standard call to get message count and if count is 1, get message info
3310: IF is_debug THEN
3311: print_Debug('x_return_status is ' || x_return_status,
3312: 'Inv_Pick_Release_Pub.Pick_Release');
3313: END IF;
3465: BEGIN
3466: -- Set savepoint for this API
3467: SAVEPOINT Reserve_Unconfirmed_Qty_PUB;
3468:
3469: -- Standard Call to check for call compatibility
3470: IF NOT fnd_api.Compatible_API_Call(l_api_version
3471: , p_api_version
3472: , l_api_name
3473: , G_PKG_NAME) THEN
3650: -- Commit if necessary
3651: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3652: ROLLBACK TO Reserve_Unconfirmed_Qty_PUB;
3653: ELSE
3654: -- Standard call to commit
3655: IF p_commit = fnd_api.g_true THEN
3656: COMMIT;
3657: END IF;
3658: END IF;